Kiran Mehrawat
Overall 8+ years of experience in Web/Mobile Application Development & Data Analytics.
- Built BI solutions using Power BI, NodeJS, Python. Helped business to gain insights with Data.
- Story telling using Power BI + DAX Language to design and develop visuals
- Experience connecting to various data sources Oracle, MySQL, MS SQL and performance
- Tuning queries to reduce run time of codes
- Actively participate in recruitment and provide trainings at organizational level on technology
- And best practices
- Role
Senior Engineer (Data Analyst)
- Years of Experience
10.8 years
Skillsets
- Team management
- Graphic Designing
- Data Analytics
- Data Engineering
- Test routines
- Application development
- Restapi development
- Innovative Thinking
- PowerBI - 3 Years
- DAX - 3 Years
- Data Analysis - 11 Years
Professional Summary
Senior Engineer (Data Analyst)
Shree Cement Limited- Jul, 2013 - Apr, 202410 yr 9 months
Senior Engineer
Shree Cement Limited GET - Engineer (Full Stack Developer)
Shree Cement Limited
Applications & Tools Known
Power BI
NodeJS
Python
HTML
CSS
BootStrap
EJS
PHP
jQuery
Oracle
MySQL
MS SQL
Photoshop
Work History
Senior Engineer (Data Analyst)
Shree Cement LimitedSenior Engineer
Shree Cement Limited- Analyzed data to derive valuable insights that informed strategic business decisions.
GET - Engineer (Full Stack Developer)
Shree Cement LimitedAchievements
- Best HOSTELER
- Miss Information Technology 2013
- Best GROUP LEADER in Parivartan-2010
- Award Winning HRMS
- Certified in B and C certificate with A Grade in National Cadet Corps
Testimonial
Shree Cement Limited
Mr. Atul RawatShe is so disciplined, creative & passionate about allotted work. Understand requirements and pro-actively suggest real-time scenarios. I enjoyed working with her a lot.
Major Projects
Various Power BI Reports & Dashboards
Around 70plus major and minor web/Mobile applications
Shree Cement LimitedWeb Applications
Bidding Applitcations
Shree Cement LimitedForward & reverse Bidding applications
HRMS
Shree Cement LimitedAward Winning HRMS based on open source technology.
Education
Bachelor of Technology (Information Technology)
Rajasthan Technical University, Kota
Certifications
Pl-300 microsoft power bi data analyst
Advanced certification programme in machine learning & deep learning (iiit-bangalore)
Interests
AI-interview Questions & Answers
Could you help me to understand all about your background by giving a brief introduction of yourself?
Let's send the steps to optimize, MySQL store procedure to reduce data to more times.
What for this, we can use the data that is required only, or we can use a direct query on the index.
We can create a table and implement it using RLS.
We can create a user where we can secure by using RLS and also set sensitive data, that's also set sensitive flag.
Yes, we can send dynamic parameters from MySQL of yield mappings.
In this, we have to use some x function in place of sum.
The start time and the end time are the same.
Integrating the PBI format with Azure Development DevOps lets you use Azure Pipelines to automate continuous integration and continuous development pipelines.
With the help of entity-relationship diagram, we can create custom visuals in Power BI to represent complex MySQL queries.
With the help of Microsoft Copilot tool, we can use AI visuals and in-built AI engine capabilities.