Anmol Gulati
Data Analyst
Faridabad,HR
Summary
Results-driven Data Analyst with 6.5+ years of experience in data analysis, dashboard development, and reporting automation. Highly skilled in building end-to-end Power BI dashboards , SQL-based datasets , and advanced Excel reporting solutions to support business decision-making. Proven ability to analyze large datasets, design meaningful KPIs, and translate complex data into clear, actionable insights for stakeholders. Experienced in automating reporting workflows, improving data quality, and delivering executive-ready visualizations that drive operational efficiency and business impact.
Overview
7
7
years of professional experience
Work History
Data Analyst
Axtria India Pvt Ltd
05.2022 - Current
- Built end-to-end Power BI dashboards for leadership to track resource utilization, billability %, capacity gaps, and bench strength for a 150+ member Data Science CoE , enabling faster staffing and revenue decisions.
- Designed and automated advanced Excel models (Power Query, Pivot Tables, dynamic formulas) to monitor real-time workforce KPIs, reducing manual tracking efforts by over 60%.
- Developed SQL-based data pipelines to extract, clean, and aggregate workforce and project data, ensuring accurate, scalable, and audit-ready reporting .
- Created a centralized workforce analytics system, integrating Excel, SQL, and SharePoint data sources, to provide a single source of truth for leadership reporting.
- Delivered executive-ready PowerPoint decks, translating complex analytics into clear insights, trends, and recommendations for senior stakeholders.
- Implemented Power BI drill-through and slicer-based analysis to enable leadership to perform self-serve analytics across teams, skills, and projects.
- Conducted capacity forecasting and gap analysis using historical data trends, supporting proactive hiring decisions, and minimizing idle resource time.
- Automated recurring workforce and business reports using Excel and SQL, improving reporting accuracy and cutting turnaround time from days to hours.
- Built and maintained standardized reporting templates and data validation checks , improving data quality, version control, and cross-team consistency.
- Partnered with cross-functional stakeholders to convert business problems into analytical solutions , driving data-backed decision-making.
- Supported pharma analytics reporting (weekly, monthly, ad-hoc), covering short-term sales forecasts, performance tracking, and market trends for 10+ reports.
- Ensured SLA adherence and reporting accuracy through close collaboration with onshore and offshore teams.
- Used Power Apps and Google Forms to streamline data collection workflows, reducing dependency on manual inputs, and improving data reliability.
- Played a key role in transitioning manual processes into scalable, analytics-driven workflows , significantly reducing operational overhead.
Associate System Engineer
Tata Consultancy Services
12.2018 - 05.2022
- Provided knowledgeable support, resolving complex technical issues through effective problem-solving techniques, while ensuring quality service and escalation of critical problems. Additionally, I responded to and resolved customer issues regarding smartphone or computer applications, such as SAP Concur and Data Pump.
- Managed mainframe applications, meeting SLAs, and improving performance through bug reduction initiatives, and ongoing monitoring. Implemented improvements to reduce bugs and common problems encountered by users, maximizing application performance, and ensuring smooth operations.
- Demonstrated adept project management skills in handling concurrent projects, ensuring the timely delivery of high-quality outcomes. Provided valuable technical guidance while facilitating seamless communication of project updates and insights through diverse channels, fostering collaboration, and informed decision-making.
Education
Post Graduate Diploma - IT
Symbiosis International University
Pune, India01.2023
B-Tech - Computer Science and Engineering
Manav Rachna College of Engineering
Faridabad, India07.2018
Skills
Power BI (DAX, Data Modeling, Interactive Dashboards)
SQL (Data Extraction, Joins, Aggregations, Performance Optimization)
Advanced Excel (Power Query, Pivot Tables, Dynamic Formulas)
Workforce & Capacity Analytics
Data Automation & Process Optimization
KPI Design & Performance Tracking
Accomplishments
- Led Workforce Management operations for a 150+ member Data Science CoE, ensuring seamless resource allocation, capacity planning, and billability tracking with zero reporting delays for over 1.5 years.
- Automated 80% of manual tracking and reporting processes using advanced Excel, Python scripting, and SharePoint solutions, significantly reducing manual efforts and human errors.
- Developed and maintained over 10+ automated reporting dashboards for the Decision Science team (weekly, monthly, and ad-hoc), supported short-term forecasting for the pharma industry.
- Delivered critical business insights and proactive recommendations to leadership, driving resource optimization, operational efficiency, and proactive workforce planning across the organization.
Timeline
Data Analyst
Axtria India Pvt Ltd
05.2022 - Current
Associate System Engineer
Tata Consultancy Services
12.2018 - 05.2022
Post Graduate Diploma - IT
Symbiosis International University
B-Tech - Computer Science and Engineering
Manav Rachna College of Engineering
Certifications
- Microsoft Certified: Data Analyst Associate
- Excel for Analysts – Mastering Advanced Excel Tool
- Analyzing and Visualizing Data using Power BI
- SQL for Data Science