AKASH SIRSAT
Pune
Summary
Data Analyst with 3.5 years of experience in telecom and energy domains, specializing in performance tracking, SLA compliance, and operational reporting. Proficient in Power BI, Advanced Excel, SQL, and Python (basic scripting, automation, and data wrangling using Pandas/Numpy) with a proven ability to analyze large datasets and deliver insights that drive strategic decisions.
Overview
6
6
years of professional experience
Work History
Data Analyst
Mahindra Powerol - TIM Business
Pune
03.2024 - Current
- Company Overview: Company involved in power systems and energy solutions
- Developed and maintained interactive dashboards in Power BI to provide actionable insights into commercial and operational KPIs
- Prepared and managed Daily-to-Daily ‘D2D’, Weekly, and Monthly Compliance Reports, supporting internal audits and business performance reviews
- Used Advanced Excel (including pivot tables, VLOOKUP/XLOOKUP, INDEX–MATCH, conditional formatting, data validation, and Power Query) to automate reports, analyze large datasets, and build interactive reporting tools
- Monitored and analyzed vehicle visibility and asset performance data in the Energy vertical of telecom operations
- Tracked the end-to-end billing process, coordinating follow-ups with internal teams to ensure timely and accurate billing closure
- Performed data validation, reconciliation, and trend analysis to support management decisions and highlight operational gaps
- Generated ad-hoc analytical reports and insights for leadership using Excel and Power BI
- Company involved in power systems and energy solutions
Data Analyst (Utility (O&M))
Pratap Technocrats Pvt
Nagpur
01.2023 - 03.2024
- Managed and analyzed Energy (Power & Fuel) of 10868 Towers
- Automated the generation of regular reporting of Power and availability
- Worked on the migration of legacy data to a new system without data loss and with minimal downtime.
- Spearheaded a data cleanup initiative that improved data quality by 25%, ensuring higher reliability for end-users.
- Developed custom interactive dashboards for management, showcasing KPIs that boosted overall strategic planning efficiency
MIS Executive
Pratap Technocrats Pvt
Akola
07.2021 - 12.2022
- Company Overview: Company focusing on telecommunications and energy solutions
- Managed Mobile Tower Billing of 1400 units
- Created reports and Track and report Field KPIs, compliance metrics, and tool adoption across operations.
- Collaborate with NOC and vendor teams to finalize network performance targets and drive achievement.
- Ensured data accuracy and integrity by managing databases
- Company focusing on telecommunications and energy solutions
Customer Service Associate
Asian paints
Akola
01.2020 - 12.2020
- Company Overview: A leading paint and coatings company
- Assisted customers by answering inquiries and resolving problems
- Maintained a thorough understanding of the company's products or services
- Provided information about products or services through various channels
- A leading paint and coatings company
Education
MBA - Business analytics
Rashtrasant Tukadoji Maharaj Nagpur University
Nagpur01.2026
Bachelor Degree -
Nashik University
Nashik02.2018
HSS -
Amaravti University
Akola03.2014
SSC -
Amaravti University
Akola06.2012
Skills
- SQL Skills:
- Proficient in SQL for data extraction, transformation, and reporting
- Experience with complex queries using INNER JOIN, LEFT JOIN, and FULL OUTER JOIN
- Skilled in writing subqueries (both correlated and non-correlated)
- Hands-on experience with Common Table Expressions (CTEs)
- Knowledge of window functions like ROW_NUMBER, RANK, LEAD, LAG
- Proficient with GROUP BY, HAVING, and CASE WHEN for data aggregation and conditional logic
- Basic scripting knowledge for automation
- Hands-on experience with Pandas and NumPy for data cleaning and manipulation
- Created simple scripts for data processing and reporting tasks
Python Skills:
- Used Python for exploratory data analysis
- Proficient in using Pivot Tables for summarizing large datasets
- Performed exploratory data analysis (EDA) on structured datasets
- Generated visual insights using Matplotlib and Seaborn, basic plots
- Read, filter, and aggregate data from CSV, Excel, and SQL databases using Python
- Used for loops, if-else conditions, and list comprehensions for logical operations
- Advanced functions like VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH for data retrieval
- Skilled in using SUMIFS, COUNTIFS, IFERROR, and IF-AND/OR logic
- Experience with Data Validation, Conditional Formatting, and Drop-down Lists for clean data input
Excel Skills :
Accomplishments
- Successfully led a cost reduction initiative that resulted in significant savings and improved operational efficiency.
- Implemented data validation and cleaning procedures that increased data accuracy by 30%.
- Developed automated reporting systems that reduced report preparation time by 50%.
- Designed and delivered data visualization dashboards that enhance stakeholder engagement.
Training
- Advanced SQL for Data Analysts, Depth training on complex SQL queries.
- Data Visualization, Currently learning data visualization techniques.
Timeline
Data Analyst
Mahindra Powerol - TIM Business
03.2024 - Current
Data Analyst (Utility (O&M))
Pratap Technocrats Pvt
01.2023 - 03.2024
MIS Executive
Pratap Technocrats Pvt
07.2021 - 12.2022
Customer Service Associate
Asian paints
01.2020 - 12.2020
MBA - Business analytics
Rashtrasant Tukadoji Maharaj Nagpur University
Bachelor Degree -
Nashik University
HSS -
Amaravti University
SSC -
Amaravti University
Similar Profiles
Uday DeoreUday Deore
Sr.Sales Manager (Real Estate ) at Shyam Global Technoventures Pvt Ltd Autho. Goem For Mahindra Powerol Gensets.Sr.Sales Manager (Real Estate ) at Shyam Global Technoventures Pvt Ltd Autho. Goem For Mahindra Powerol Gensets.
Meadow ReynoldsMeadow Reynolds
Nursing Home Volunteer at -Nursing Home Volunteer at -
Tuana AltayTuana Altay
Translator at -Translator at -
MOHIT SINGHMOHIT SINGH
Fiber Network Planner at Tech MahindraFiber Network Planner at Tech Mahindra
MAHIDHAR DWIVEDIMAHIDHAR DWIVEDI
Key Account Manager at Quadrant Knowledge Solutions Pvt. Ltd.Key Account Manager at Quadrant Knowledge Solutions Pvt. Ltd.