Hari Om Arora
SECTOR 16B
Summary
Dynamic Senior Data Analyst with 11 years at Concentrix India, adept at transforming complex datasets into actionable insights using SQL and Power BI. Recognized for enhancing reporting efficiency by 30% and maintaining 99% data accuracy. Proven collaborator and problem solver, driving process innovation and delivering impactful data-driven solutions.
Overview
11
11
years of professional experience
3
3
years of post-secondary education
Work History
Senior Data Analyst
Concentrix India pvt Ltd
Gurgaon
12.2022 - Current
- Highly analytical Senior Data Analyst and WFM professional with 11 years of total work experience. Expert in transforming complex datasets into actionable insights using SQL, PLX, and Power BI. Proven track record in streamlining reporting workflows, improving efficiency by 30%, and maintaining 99% data accuracy. Recognized with the "Best WFM Award" for exceptional performance.
- Data Analytics: SQL, PLX, BigQuery, Data Management, Data Validation.
Business Intelligence: Power BI, Tableau, Google Data Studio, Dashboard Creation.
WFM & Operations: RTA, Capacity Planning, CMS Avaya, Genesys, Czentrix.
Automation: VBA Macros, Google Apps Script, Spreadsheet Automation.
Expert Excel: Pivot Tables, VLOOKUP/MATCH, INDEX-MATCH, SUMIFS, COUTIFS.
Utilize SQL and PLX alongside Google Apps Script and BigQuery to optimize reporting workflows.
Develop interactive dashboards using Power BI and Data Studio, reducing report generation time by 25%.
Maintain 99% data accuracy and improved report delivery efficiency by 30%.
Conduct comprehensive data analysis for Weekly, Monthly, and Quarterly Business Reviews (WBR, MBR, QBR).
Spearhead process innovation for Google clients, increasing data processing efficiency by 20%.- Analyzed data sets to identify trends and insights for business strategies.
- Collaborated with teams to develop data-driven solutions and recommendations.
- Utilized advanced analytics tools for reporting and data visualization tasks.
- Conducted quality checks to ensure accuracy of data reports and analysis.
- Designed and maintained dashboards for real-time data monitoring and decision-making.
- Mentored junior analysts on best practices in data analysis techniques.
- Presented findings to stakeholders, simplifying complex information for clarity.
- Supported cross-functional projects by providing analytical expertise and insights.
- Developed complex SQL queries to analyze large datasets for trends and insights.
- Established KPI metrics and monitored performance of data analysis projects.
- Investigated root causes of anomalies in datasets using exploratory data analysis.
- Identified opportunities for process improvements through data analysis.
Workforce Real Time Analyst
Teleperformance Global services pvt ltd
Gurgaon
08.2021 - 12.2022
Senior Reporting Analyst
Lenskart solution Pvt Ltd
Gurgaon
12.2020 - 08.2021
Managed data reporting and dashboard creation using Excel and MS Access.
Applied advanced formulas and VBA to automate daily trackers and performance charts.- Analyzed complex datasets to generate insightful reports for management review.
- Developed automated reporting templates to streamline data presentation processes.
- Collaborated with cross-functional teams to gather data requirements and insights.
Lead Associate WFM
IGT solution Pvt Ltd
Gurgaon
12.2018 - 12.2020
Monitored real-time queues and intraday performance metrics. I had worked on reporting for different region and clients like Redison Hotel, United Airlines China, Bogota, Bucharest, Manila and US and have good exposure of different tools like CMS, Avaya, Genesis, Looker, incontact and revenue based reporting like I was doing Redison Bucharest Billing and Preparing PLI Incentives.
Received the Best WFM Award for the quarter (Mar 2020 – May 2020).- Led team projects to improve operational workflows and efficiency.
- Mentored junior associates in best practices and process standards.
- Coordinated cross-departmental communication for project alignment.
Real-Time Analyst
Arvato Bertelsmann
Gurgaon
05.2015 - 12.2018
- Analyzed real-time data to optimize operational efficiency across multiple departments.
- Monitored key performance indicators to identify trends and improve service levels.
- Collaborated with teams to ensure seamless communication during peak periods.
Education
Bachelor of Arts - General Studies
Monad University
Hapur 12.2011 - 06.2014
Skills
- SQL
- Power BI
- Data visualization
- Automation tools
- Data management
- Business intelligence
- Dashboard development
- KPI metrics establishment
- Cross-functional collaboration
- Problem solving
- Effective communication
- Process innovation
- SQL expertise
Timeline
Senior Data Analyst
Concentrix India pvt Ltd
12.2022 - Current
Workforce Real Time Analyst
Teleperformance Global services pvt ltd
08.2021 - 12.2022
Senior Reporting Analyst
Lenskart solution Pvt Ltd
12.2020 - 08.2021
Lead Associate WFM
IGT solution Pvt Ltd
12.2018 - 12.2020
Real-Time Analyst
Arvato Bertelsmann
05.2015 - 12.2018
Bachelor of Arts - General Studies
Monad University
12.2011 - 06.2014