Shubham Balki
Pune
Summary
A dedicated and detail-oriented professional with a passion for data analysis and management information systems, seeking a challenging role as a Data Analyst. With expertise in extracting actionable insights from complex datasets and optimizing business processes through effective MIS operations, Aim to leverage analytical skills and technical proficiency to drive strategic decision-making and operational excellence in a dynamic organization.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst
Bajaj FinServ
Pune, India
06.2023 - Current
- Analytically driven Data Analyst with a passion for extracting actionable insights from complex datasets
- Experienced in statistical analysis, data visualization, and predictive modeling
- Conducted in-depth analysis of financial and customer data to identify trends, patterns, and anomalies
- Developed interactive dashboards and reports using Power BI to visualize key performance indicators (KPIs) for various departments including finance, operations, and marketing
- Collaborated with business stakeholders to gather requirements, understand data sources, and define project scope for Power BI solutions
- Developed and implemented predictive models to forecast customer behavior, credit risk, and financial performance
- Provided training and support to 410 team members on data analysis tools and techniques to enhance data literacy across the organization.
MIS EXECUTIVE
PAREKH INTEGRATED SERVICES PVT LTD
Thane, India
12.2022 - 05.2023
- Detail-oriented MIS Executive with proven track record in managing and analyzing data to optimize logistics and supply chain operations
- Experienced in database management, reporting tools, and data visualization techniques specific to logistics industry
- Managed and analyzed data related to logistics and supply chain operations, including inventory levels, shipment tracking, and warehouse performance metrics
- Developed and maintained databases to store and organize operational data, ensuring data accuracy and integrity
- Utilized advanced Excel functions and macros to automate report generation and streamline data analysis processes
- Analyzed transportation data to optimize routes, reduce transit times, and minimize costs while maintaining service levels
- Generated reports and dashboards to track key performance indicators (KPIs) such as on-time delivery rates, freight costs, and inventory levels.
MIS Executive
TORRENT POWER LIMITED
Thane, Maharashtra, India
05.2019 - 12.2022
- Proficient in database management, reporting tools, and data visualization techniques
- Seeking to leverage expertise in MIS to contribute to success of Torrent Power Limited
- Analyzed sales reports to track sales performance, market trends, and customer behavior, providing insights to optimize sales strategies and improve revenue generation
- Developed and maintained databases to store and organize financial and sales data, ensuring data accuracy and integrity
- Generated customized reports and dashboards using SQL queries, Excel pivot tables, and Power BI to visualize key metrics and facilitate decision-making
- Collaborated with finance and sales teams to understand reporting requirements and provide actionable insights to support business objectives
- Generated daily, weekly, and monthly reports on key performance indicators such as outage duration, distribution losses, and customer complaints, providing insights to improve operational efficiency and customer satisfaction.
Education
Electrical Engineering -
Yeshwantrao Chavan College Of Engineering
Nagpur05.2019
Electrical Engineering -
Shri Sai Polytechnic
Chandrapur05.2016
SSC -
Bhawanjibhai Chawan High School Chandrapur
Chandrapur04.2013
Skills
- Power Bi
- SQL
- Power Query
- Power Pivots
- DAX Functions
- Data Cleaning
- Advanced Excel
- SQL Databases
- Analytical Problem Solving
- Database Management
- ETL processes
- Data Visualization and Presentations
- Excel Functions
- Data Analysis
Certification
Master Program In Data Science, A Master's program in Data Science typically offers in-depth education and training in various aspects of data science, including statistical analysis, programming, and data visualization.
Languages
English
Hindi
Marathi
Timeline
Data Analyst
Bajaj FinServ
06.2023 - Current
MIS EXECUTIVE
PAREKH INTEGRATED SERVICES PVT LTD
12.2022 - 05.2023
MIS Executive
TORRENT POWER LIMITED
05.2019 - 12.2022
Electrical Engineering -
Yeshwantrao Chavan College Of Engineering
Electrical Engineering -
Shri Sai Polytechnic
SSC -
Bhawanjibhai Chawan High School Chandrapur