Summary
Overview
Work History
Education
Accomplishments
Additional Information
Certification
Timeline
Key Skills
Tools
Generic

Richa Singh

Summary

Experienced IT Team Lead with 7 years in business applications, analytics, integration and project leadership. Proven in end-to-end business analysis, SQL, and Power BI. Skilled in data analysis, integration, automation, and project delivery. Seeking to elevate skills, drive efficiency, and contribute to organizational success in a dynamic role.

Overview

7
7
years of professional experience
1
1
Certificate

Work History

Executive-IT-Business Relationship Management

Page Industries Ltd
04.2023 - Current

1. DMS, SFA and TPM Transformation (Salesforce) :

  • Subject Matter Expert specializing in Primary Order Management, Auto-Replenishment Model, Operational Analytics, and Schemes and Incentive Management module.
  • Led the development and implementation of master data management modules, ensuring accurate and consistent data across systems.
  • Established Salesforce object-to-report relationships for 80+ reports and 20+ dashboards, supporting operational and leadership decision-making with tailored data insights.
  • Defined requirements for 15+ transactional data sets for cutover, facilitating a smooth transition and integration process.

2. Primary Auto Replenishment Re-modeling :

  • Revamped ARS model to facilitate dynamic distributor assortment, boosting penetration from 17% to 28% while optimizing budget allocation within set norms which led to enhanced inventory optimization through strategic enhancements.

3. Secondary Auto Replenishment Enhancement :

  • Led integration and order generation with a 3rd party assortment generation tool for dynamic assortment management in exclusive stores and seamlessly integrating orders between POS, and DMS platforms.

4. BI Reporting :

  • Developed 5 key Power BI reports for Auto Replenishment systems, including Order Summary, Inventory Saturation, Product Penetration, New Product Addition, and Norms Breach, enhancing data-driven decision-making
  • Utilized existing data and transformation pipelines to automate report generation and refresh processes, ensuring timely and accurate updates for stakeholders.

5. Sales Inventory Planning :

  • Contributed to the development of a customized inventory planning tool, tailoring it to specific business needs and enhancing inventory management efficiency.

Senior Consultant-GTM (D&S)

Page Industries Ltd
04.2020 - 03.2023
  • Delivered Auto Replenishment System for Channel Systems and Exclusive Outlets with Deloitte, adopted by 92% distributors and 100% Exclusive Outlets, resulting in 34% increase in primary orders, and 60% reduction in inventory holding.
  • Collaborated with KPMG to gather and analyze business requirements for 17+ sales analytics reports, ensuring alignment with key stakeholder needs and objectives.
  • Collaborated in designing strategies to map data sources with reports and transform raw data into actionable data using filters and criteria, optimizing report usability.
  • Collaborated in developing data refresh strategies in Azure Warehouse, determining refresh types and schedules to maintain data accuracy and relevance.
  • Collaborated in testing and validating reports for data accuracy, providing ongoing support to ensure seamless delivery and usage.

Consultant

Page Industries Ltd
04.2018 - 03.2020
  • Contributed to the successful setup of Order Management System across 4000+ trade partners and 400+ Pan India field staff, along with providing support and training.
  • Developed insightful reports and visualizations in Excel using functions such as Pivot Tables and VLOOKUP, to support decision-making.
  • Ensured report accuracy through data validation and regular updates, improving the reliability of business insights.

Trainee

Page Industries Ltd
04.2017 - 03.2018
  • Attended training courses to build understanding of company products, model, processes, techniques, and industry.
  • Supported project managers with documentation of 50+ process flows and departmental tasks leading to better project tracking and communication.

Education

Bachelor of Technology-EEE - 74.62%

BBD-NITM
Lucknow, India
2015

Intermediate - 82.5%

Seventh Day Adventist Senior Secondary School
Lucknow, India
2011

High School - 87%

Seventh Day Adventist Senior Secondary School
Lucknow, India
2009

Accomplishments

  • GATE - AIR 9953 (2016)
  • HackerRank (richasingh2101) - SQL Five stars completed
  • Recognition from President-Sales excellence and Retail Operations for new ideas and going extra mile for the projects multiple times
  • Received recognition from President-Inventory Planning for innovative solution for Channel and Franchise ARS systems

Additional Information

  • SQL
  • Python

Certification

  • DSS Core Designer by Dataiku Academy
  • ML for Business Professionals by Coursera

Timeline

Executive-IT-Business Relationship Management

Page Industries Ltd
04.2023 - Current

Senior Consultant-GTM (D&S)

Page Industries Ltd
04.2020 - 03.2023

Consultant

Page Industries Ltd
04.2018 - 03.2020

Trainee

Page Industries Ltd
04.2017 - 03.2018

Bachelor of Technology-EEE - 74.62%

BBD-NITM

Intermediate - 82.5%

Seventh Day Adventist Senior Secondary School

High School - 87%

Seventh Day Adventist Senior Secondary School

Key Skills

  • Data Analysis
  • Data Manipulation
  • Data Integration
  • Data Cleaning
  • Reporting
  • Analytical Thinking
  • Documentation

Tools

Microsoft Excel
SQL Server
Power BI
BigQuery
Jupyter Notebook
SAP Business reports
JIRA
ITSM
Tableau
Azure Data Factory

Richa Singh