Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Gurpreet Singh

Gurpreet Singh

Delhi

Summary

Experienced BI Reporting and Analytics professional with 9.5+ years in the service industry. Skilled in team collaboration, leadership, and communication, with a focus on optimizing efficiency and creating a positive work environment. Looking to contribute to a reputed organization.

Overview

15
15
years of professional experience

Work History

Data Reporting Analyst

Freelance
New Delhi
11.2022 - 08.2024
  • Developed automated reporting procedures and processes to improve accuracy and efficiency.
  • Gathered, analyzed, and interpreted data from multiple sources to create reports.
  • Conducted periodic reviews of existing reports to ensure accuracy and identify areas for improvement.
  • Created visualizations such as charts, graphs, dashboards. to present data in an easily understandable format.
  • Assisted with the development of new report templates and formats for stakeholders.
  • Generated ad hoc queries in response to user requests for additional information or analysis.
  • Performed trend analysis on historical data to detect patterns or anomalies in the data set.

Manager (OTC)- Reporting Analytics

Johnson Control India
Gurugram
03.2022 - 10.2022
  • Created customized ad hoc reports for clients based on their on-demand requests, delivering accurate, tailored insights in a timely and professional manner.
  • Created daily, weekly, and monthly reports for senior management summarizing operational performance metrics different OTC LOBs/Products (Fire, HVAC, Security, and Retail).
  • Utilized MS SQL, data warehousing programs, Power BI, Excel, and other dashboard/visualization toolsets for data intelligence and analysis.
  • Prepare Cash Billing Revenue dashboard and delivered the global JCI top onshore and offshore leaders. This dashboard calculates the delta between the cash collected on a daily basis and the forecasted collection.
  • Converted data into actionable insights by predicting and modeling future outcomes.
  • Reports Tracker, Quality Scores Associate Wise, and RCA for errors and client escalations.

Assistant Manager (Wal-Mart)- Reporting Analytics

Genpact India Pvt. Ltd
Noida
09.2019 - 03.2022
  • Worked as a Data Analyst, focusing on data visualization and reporting.
  • Needed to consolidate data from disparate sources into a single report.
  • Developed interactive Power BI reports to visualize financial metrics and trends dashboards.
  • Created customized ad hoc reports for clients based on their on-demand requests, delivering accurate, tailored insights in a timely and professional manner.
  • Highlighted area of improvements by in-depth analysis of the various sub-processes with the help of extensive reporting dashboards.
  • Designed comprehensive and detailed dashboard (Monthly, Quarterly), MBR, or QBR in 'Power BI' to provide visibility around all key metrics.

Associate Consultant (Team Lead) – Reporting & Analytics

MetLife Global Operations Support Center
Noida
12.2009 - 01.2017
  • Developed complex reports using VBA, MS Access, SQL, and Business Objects and imported data using DAO, RDO, and ADO from external sources.
  • Processed and cleansed data using Excel, Access, and SQL.
  • Delivered weekly/monthly production and quality reports, also identified data issues and areas for improvement, and provided technical expertise on specialized report requests.
  • Created complex internal and external dashboards and shared the provided insights to support marketing objectives.
  • Led automation analysis and planning for new projects.

Education

MBA - financial management

Anamalai University
01.2013

BBA - Computer Aided management

Guru Gobind Singh University
01.2008

Skills

  • BI Reporting & Analytics
  • Data & Business Intelligence
  • SQL, Advanced Excel & VBA
  • Data Visualization (Power BI, Tableau, etc)
  • R2R, AP & AR Financial Data Reporting
  • Data Modeling & Analysis
  • Leadership & Team Management
  • Problem Solving & Decision Making
  • Stakeholder Management
  • Process Optimization
  • MPR, QPR, KPIs & Four Blocker

Accomplishments

  • Received annual 'Star Annual Best Performer Award' (2020 & 2021) in Genpact
  • Six times consecutively 'Best Performer Award' (2010, 2011, 2012, 2013, 2014) in MetLife

Timeline

Data Reporting Analyst

Freelance
11.2022 - 08.2024

Manager (OTC)- Reporting Analytics

Johnson Control India
03.2022 - 10.2022

Assistant Manager (Wal-Mart)- Reporting Analytics

Genpact India Pvt. Ltd
09.2019 - 03.2022

Associate Consultant (Team Lead) – Reporting & Analytics

MetLife Global Operations Support Center
12.2009 - 01.2017

MBA - financial management

Anamalai University

BBA - Computer Aided management

Guru Gobind Singh University

Similar Profiles

CREATE PROFILE
Gurpreet Singh