Sahil Patil
Analyst
Pune
Summary
Dynamic MIS Analyst with a proven track record at Tata Consultancy Services, enhancing business strategies through expert data analysis and BI tools like Power BI. Proficient in SQL, Power BI and Excel to deliver actionable insights, optimize reporting processes and improve data-driven decision-making. I've driven data quality improvements and actionable insights, significantly streamlining operations. My blend of technical prowess and strategic thinking fosters informed decision-making and business process enhancements.
Overview
3
3
years of professional experience
1
1
Certification
Work History
MIS Analyst (Business Process Lead)
Tata Consultancy Services
12.2021 - Current
- Developed custom reports to support decision-making processes, leading to more informed business strategies.
- Designed visually appealing dashboards for easy interpretation of key performance indicators, assisting management in strategic planning efforts.
- Developed and maintained complex SQL queries to extract, manipulate, and analyze data from multiple relational databases.
- Designed and built interactive Power BI dashboards, enabling management and stakeholders to monitor key business metrics and KPIs.
- Improved overall data quality through consistent monitoring, review, and cleanup efforts as part of ongoing maintenance activities.
- Optimized database performance by conducting regular maintenance and updates on existing systems.
- Collaborated with cross-functional teams to understand business requirements and translate them into data-driven insights for decision-making.
- Conducted ad-hoc analysis to identify business trends, opportunities, and areas for improvement.
- Managed data quality and performed data cleaning to ensure integrity in reporting.
- Provided actionable insights to senior management, helping streamline business operations and drive performance improvements.
Education
Bachelor of Engineering - Mechanical
Dr. D.Y. Patil School Of Engineering Academy
Pune 04.2001 -
Skills
Database & Querying: SQL, PostGreSQL Programming, Creating Databases and Tables
Business Intelligence: Power BI (Dashboard Creation, DAX, Power Query)
Data Analysis: Data Modeling, Data Cleansing, Data Visualization
Excel: Advanced Formulas, Pivot Tables,Data Validation
Reporting & Automation: Power BI Reports, Excel Dashboards
Others: ETL Process, Data Integration, Business Process Improvement,Report development,Data review, Reporting skills, Business process improvement
Certification
Microsoft Power BI Desktop for BI, Complete SQL Bootcamp, Advanced Microsoft Excel
Timeline
MIS Analyst (Business Process Lead)
Tata Consultancy Services
12.2021 - Current
Bachelor of Engineering - Mechanical
Dr. D.Y. Patil School Of Engineering Academy
04.2001 -