Summary
Overview
Work History
Education
Skills
Certification
Technical Tools
Achievements Activities
Timeline
Generic
Manjeet Singh

Manjeet Singh

Senior Analyst
Gurugram,Haryana

Summary

Experienced Data & Analytics Specialist with over 4 years of industry experience, excelling in process improvement and operational efficiency. Achieved 150+ hours saved via automation and led efforts that contributed to the release of 40-50 FTEs by streamlining operations. Proficient in data analysis, reporting, and dashboard creation using Power BI, Excel, and SQL. Certified in Lean Six Sigma (LCS 1A & 1B), with a strong background in automation, project management, and stakeholder management. Currently working at NAB to lead and deliver impactful data-driven projects for operational excellence.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data & Analytics Specialist

NAB
05.2023 - Current
  • Lead data-driven initiatives to support operational excellence, focusing on data acquisition, trend analysis, and process automation
  • Design and develop Power BI dashboards to track key business metrics, improving reporting accuracy and decision-making
  • Automate reporting and data integration workflows using VBA, saving 150+ hours annually across teams
  • Manage stakeholder relationships, facilitating cross-functional collaboration and ensuring alignment on project objectives
  • Implement Lean Six Sigma methodologies to streamline operations and improve process efficiency, contributing to 40-50 FTEs released by process improvements
  • Key Projects:
  • Project Edge: Managed data communications across Citi Bank brands acquired by NAB, developing Power BI dashboards and ensuring compliance with AUSTRAC regulations
  • Merchant Payment Gateway Transition: Oversaw the migration of 500+ merchants from Citi Bank to NAB's payment gateway, developed dashboards, and coordinated stakeholder workshops

Associate Operation Analyst

Moody's Corporation
12.2020 - 05.2023
  • Led the development of an automated tool based on Power Query, Selenium library in VBA, and advanced Excel formulas, optimizing the document management process by integrating it with one of the legacy system groups
  • The tool utilized web scraping techniques to extract text from documents and automatically upload them to the system, improving workflow efficiency
  • Designed and implemented Power BI dashboards to track key metrics, ensuring data quality and timely upload of documents
  • Streamlined document upload process, increasing the rate of document uploads from 75-80 documents per day to 300 documents per day, significantly improving team productivity
  • Analyzed legacy system bottlenecks, identifying areas for automation, and led the implementation of process improvements that reduced manual handling of documents
  • Worked cross-functionally with IT, business, and operations teams to ensure the seamless integration of the automation tool with existing systems, providing training and support for smooth adoption
  • Key Achievements:
  • Developed an automation tool that increased daily document uploads 3.75x (from 75-80 to 300+), significantly boosting efficiency
  • Integrated the automation workflow with legacy systems, improving operational accuracy and consistency
  • Delivered real-time insights with comprehensive Power BI dashboards, enhancing workflow performance monitoring

Business Intelligence Expert

BT
09.2019 - 12.2020
  • Spearheaded the creation of Power BI dashboards for real-time business performance tracking, improving decision-making processes
  • Automated data reporting tasks, reducing report preparation time by 20%, using advanced Excel functions and VBA scripting
  • Played a key role in designing and implementing business intelligence solutions that improved the efficiency of internal reporting
  • Collaborated with teams to gather and analyze data, ensuring that reports accurately reflected performance metrics
  • Conducted training sessions for junior team members, improving the overall competency in Power BI and Excel
  • Key Achievements:
  • Automated reporting processes, saving the department 15+ hours per week
  • Developed a sales dashboard that contributed to a 10% increase in sales

Finance and Accounts Executive

AGS Transact Technologies Ltd
04.2018 - 09.2019
  • Designed and implemented key performance indicator (KPI) dashboards for senior management, improving financial visibility
  • Automated reconciliation of vendor accounts, reducing manual effort and improving accuracy
  • Actively contributed to financial reporting, ensuring timely delivery of monthly and quarterly reports
  • Enhanced financial forecasting models, improving projection accuracy and resource allocation
  • Key Achievements:
  • Developed and implemented a comprehensive financial dashboard, enhancing financial oversight
  • Reduced manual reconciliation time by automating processes in Excel

Education

Postgraduate Certificate -

Pune Institute of Business Management
08.2018

Bachelor of Business Administration -

Kurukshetra University
08.2015

Skills

  • Data Analytics & Visualization: Power BI
  • Data Analytics & Visualization: Excel
  • Data Analytics & Visualization: MySQL
  • Data Analytics & Visualization: Qlik Sense
  • Data Analytics & Visualization: Power Query
  • Automation & Programming: VBA
  • Automation & Programming: Excel Macros
  • Automation & Programming: SQL
  • Process Improvement: Lean Six Sigma
  • Process Improvement: Stakeholder Management
  • Process Improvement: Process Mapping
  • Project Management

Certification

  • Lean Competency System (LCS), Cardiff University, 02/22
  • Google Data Analytics Professional Certificate, 01/23
  • Excel Business Intelligence: Power Pivot, Power Query, DAX, Udemy, 02/22
  • Power BI for Business Intelligence, Udemy, 02/22
  • Analysing and Visualizing Data with Microsoft Power BI, Udemy, 01/21

Technical Tools

  • Data Analytics: Power BI, Qlik Sense, Excel, MySQL, Power Query
  • Automation & Programming: VBA, Excel Macros
  • Database & Querying: SQL
  • Cloud & ETL: AWS (basic exposure)

Achievements Activities

  • Two-time Star Award Winner, One-time Quarter Award Winner for Best Performer at NAB.
  • Actively participated in and organized internal cricket tournaments, table tennis, and team-building activities.
  • Played a key role in organizing team outings, CSR events, and internal parties to foster team bonding.

Timeline

Data & Analytics Specialist

NAB
05.2023 - Current

Associate Operation Analyst

Moody's Corporation
12.2020 - 05.2023

Business Intelligence Expert

BT
09.2019 - 12.2020

Finance and Accounts Executive

AGS Transact Technologies Ltd
04.2018 - 09.2019

Postgraduate Certificate -

Pune Institute of Business Management

Bachelor of Business Administration -

Kurukshetra University
Manjeet SinghSenior Analyst