About
I’m a Data Analyst with 3+ years of experience working across operations, reporting, and analytics. I support 5 departments with their data needs, automate ETL workflows, and reduce report turnaround time by 70% through reporting automation. Previously at Gartner, I worked on Excel and Power BI reporting for global teams and supported large-scale data operations across regions. At Spectrum Insurance Broking, I helped build a centralized reporting framework that improved leadership reporting efficiency by 60% and strengthened data reliability across business functions. Earlier at ICICI Bank, I worked on time series analysis over client financial data. I enjoy building clean reporting systems, solving data problems, and helping teams make faster, better decisions. Feel free to reach out at ayushsinghverma07@gmail.com if you’d like to connect. Skills: SQL | Power BI | Advanced Excel | Python | Databricks | ETL | EDA | Data Operations | Data Analytics | Dashboarding | Reporting Automation
Skills & Expertise (56)
Work Experience
Data Analyst (Associate-Data)
Battery Smart
July 2025 - Present
• Managed data operations for 5 teams, translating data into KPI reports, dashboards and actionable insights for performance monitoring. • Built ETL pipelines using Python, SQL and Databricks to automate recurring data preparation and reporting, reducing manual effort by 70%. • Developed Power BI, Databricks and Google Sheets dashboards to monitor KPIs, trends, operational performance and business metrics. • Investigated data inconsistencies and conducted root cause analysis across SQL databases, improving data quality and reliability by 90%. • Automated recurring reports and Slack-based alerts using Python, SQL, Databricks and scheduled jobs, enabling faster information availablity. • Created centralized MIS interfaces and reporting workflows for multiple teams, reducing reporting turnaround time by 60%.
Sr. Coordinator – Data & Analytics
Gartner
March 2025 - July 2025
• Created Excel, Power BI and PowerPoint reports delivering actionable insights to global PD teams across APAC, NA, EMEA and Japan. • Leveraged SQL for data extraction, processing and transformation, reducing FAR dump and FNR generation time by 75%. • Streamlined data collection, validation and preprocessing from Workday, Salesforce Kantata and Forms for downstream analysis and reporting.
Data Analyst (Assistant Manager)
Spectrum Insurance Broking
August 2024 - December 2024
• Developed Excel-based MIS and Power BI dashboards to monitor KPIs, trends and business performance, while providing ad-hoc analysis and performance tracking for stakeholders with 100% accuracy. • Managed databases (Sales, ENAC, PIVC) via MySQL and Python. Performed EDA to find trends and improve data quality by 70%. • Built a structured reporting framework with SQL and Excel-based workflows, improving reporting efficiency and data visibility by 60%.
Deputy Manager II
ICICI Bank
December 2021 - April 2023
• Analyzed 3-year financial data alongside the credit team to identify trends for credit assessments for working capital funding. • Evaluated customer financial information in collaboration with credit teams to support risk assessment, eligibility and exposure decisions. • Prepared Excel-based KPI reports and MIS for regulatory compliance monitoring and management reporting with 100% accuracy.
Education
PGP in Data Science and Engineering - Great Lakes Institute of Management
2023 - 2024 · India
MBA and BBA (Dual Degree) - Amity University
2017 - 2021 · India
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (56)
Click a skill to find developers with the same skill
