Pratik Thorat
Data Analyst
Pune
Summary
Results-oriented Data Analyst with over three years of experience in data analysis, reporting, and business intelligence. Expertise in SQL, Power BI, and Excel, complemented by a strong foundation in data visualization and analytics. Proven experience with Azure Databricks, Data Lake, and Enterprise Data Warehousing (EDW) enhances the ability to extract actionable insights. Strong problem-solving capabilities and effective stakeholder management skills drive data-driven decision-making aligned with organizational objectives.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst
Bajaj Finance Limited - Strategic Partnerships
06.2023 - Current
- - Designed and automated daily dashboards and reports using SQL and Power BI.
- - Queried databases to extract and analyze data, providing insights to stakeholders.
- - Managed data from customer service channels, ensuring accurate performance tracking.
- - Utilized Azure Databricks, Azure Data Lake, and EDW to retrieve and process data for business intelligence.
- - Conducted Root Cause Analysis (RCA) for data anomalies and dropouts in sales funnels.
- - Extracted and analyzed Airtel sales data using Databricks to generate insights.
- - Developed interactive dashboards in Tableau to visualize key metrics across partnership channels, enhancing decision-making for senior stakeholders.
- Supported strategic decision-making by translating raw data into actionable insights and recommendations.
- Optimized data collection methods, resulting in more comprehensive datasets for analysis.
- Used statistical methods to analyze data and generate useful business reports.
- Produced monthly reports using advanced Excel spreadsheet functions.
Technical Analyst
Capgemini Technology Services
06.2021 - 03.2023
- Collected and analyzed error data from servers to troubleshoot client issues.
- - Led a data collection project for hospital accounts, structuring large datasets in Excel.
- - Provided insights and recommendations to improve system performance.
- - Trained team members on data analysis techniques, and troubleshooting best practices.
- - Created and shared performance reports with senior management.
- - Used Power BI to create visual reports for server error patterns, enabling faster resolution, and reducing downtime.
Customer Insights Analyst
Amazon Development Centre Pvt Ltd
09.2020 - 03.2021
- - Managed customer interactions, and analyzed service data for process improvement.
- - Ensured efficient issue resolution within SLAs, while maintaining high satisfaction scores.
- Enhanced customer satisfaction rates through detailed analysis of customer feedback data and subsequent improvements in service offerings.
Education
Bachelor of Engineering (B.E.) - Mechanical Engineering
Pune University
Pune, India01-2020
Skills
SQL
Python programming
Excel functions
Data visualization and presentations
Data analysis
SQL databases
MS Excel
Relational databases
Business intelligence tools
Microsoft power BI
Structured query language (SQL)
Certification
- Google Data Analytics Professional Specialization
Timeline
Data Analyst
Bajaj Finance Limited - Strategic Partnerships
06.2023 - Current
Technical Analyst
Capgemini Technology Services
06.2021 - 03.2023
Customer Insights Analyst
Amazon Development Centre Pvt Ltd
09.2020 - 03.2021
Bachelor of Engineering (B.E.) - Mechanical Engineering
Pune University