Summary
Overview
Work History
Education
Skills
Certification
Timeline
Tools And Software
Generic

Ritika Malhotra

Romeoville,IL

Summary

Outstanding Senior Leadership and entrepreneurial track record as Data Analyst, Reporting Champion, Change Management Expert, and Client Advocate. Highly skilled in data visualization, accelerating critical projects, and resolving complex operational issues in a timely fashion. Confident talents in multi-project oversight, acquisition integration, enterprise planning, cost/benefits analysis, and organizational streamlining in fast-paced environments. Widely recognized by executives and clients for comprehensive expertise in building complex reports & dashboards and executing critical programs to meet important metrics and achieve long-term goals.


Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Ulta Beauty
02.2023 - Current
  • Developed custom reporting solutions in Power BI, resulting in a 15% enhancement in data usability and accessibility for end-users.
  • Implemented a robust data quality framework, reducing data inconsistencies by 30% and improving the accuracy of business decision-making.
  • Collaborated in end to end process of the creation of data models and visualizations, delivering actionable insights for product enhancement.
  • Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
  • Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
  • Coordinated cross-functional teams to integrate data solutions, effectively streamlining reporting processes.
  • Designed and deployed interactive dashboards in Tableau, significantly boosting stakeholder engagement.
  • Generated detailed reports that identified opportunities for optimization and efficiency.
  • Managed and delegated Cherwell/SNOW tickets to appropriate teams based on business user requests, ensuring timely resolution and alignment with business needs.
  • Utilized data visualization techniques to present and explain complex data sets.

Senior Analyst

7-11
01.2021 - 04.2022
  • Developed comprehensive reports on inventory management, resource allocation, and payroll processing.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Created and utilized pivot tables for data analysis, leading to actionable operational plans.
  • Conducted predictive analysis to optimize inventory management and ordering processes.
  • Managed daily operations across three retail outlets to ensure efficiency and compliance.
  • Conducted gap analysis to identify operational discrepancies and implement corrective measures.
  • Oversaw product management initiatives while aligning with core business values and objectives.
  • Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.

Senior HR Analyst

GEODIS
08.2020 - 12.2020
  • Reviewed, screened and hired more than 200 candidates in 2 months.
  • Conducted a full cycle recruitment of operational roles for seasonal field distribution center.
  • Posted job openings on company's website in a precise manner.
  • Organized multiple job fairs in different and creative formats, for example drive thru hiring on a sunny day.
  • Completed end to end hiring process for each employee which also included the processing of the application, presenting offer letters, submitting HireRight background check requests, and administrating i9 application forms.
  • Extensively profiled candidates through various different social media portals such as LinkedIn, Indeed, Twitter and Facebook.
  • Conducted in house profiling such as reviewing resumes posted on company's website or drop offs.
  • Maintained a metrics of total hired which was presented to the stakeholder and upper management.

HR Analyst

AMR Consulting
01.2019 - 01.2020
  • Maintained an I-9 repository for all the employees.
  • Worked under the organizations policy and procedures for the company to be as compliant as possible.
  • Performed day to day HR support including on-boarding, off-boarding, compensation analysis, employee relations, performance management, and employee development.
  • Handled the grievances of employees in a formal manner as per the company's policies.
  • Helped employees by empowering them with the ability to provide better ideas to create a better work environment.
  • Managed the accounts of retail vendors, contractors and other accounts payable as well as receivables.

HR Analyst

Corsalite
01.2017 - 01.2018
  • Performed day to day HR support including on-boarding, off-boarding, compensation analysis, employee relations, performance management, and employee development.
  • Maintained an I-9 repository for all the employees.
  • Standardized the appraisal process of all departments by working closely with the managers.
  • Worked under the organizations policy and procedures for the company to be as compliant as possible.
  • Handled the monthly payroll duties for 150+ employees.
  • Worked across departments to get the best feedback from each employee by idea sharing such as surveys and workshops.
  • Created pivot tables and various other reports to see the latest trends and conduct regressive analysis.
  • Conducted audits on a bi-weekly to a monthly basis for the betterment of different departments.

HR Assistant

ICF
01.2016 - 01.2017
  • Conducted various data processing tasks in PeopleSoft such as transitioning of internal transfers, status change, promotions and pay rate change.
  • Acted as a liaison for the team to provide production support on Oracle PeopleSoft.
  • Worked with new hires in post joining formalities such as onboarding and orientation.
  • Supported new hires and existing employees with HRIS related issues.
  • Maintained an I-9 repository for all the employees.
  • Worked with the Sr. Management to provide reports for annual employment reviews.
  • Maintained data for each employee in a precise format as per the company's sensitive data policies.
  • Conducted employee engagement like offsite and on-site activities to create a better work environment.

Human Resources Executive

Red Express LTD
01.2014 - 01.2015
  • Actively recruited through employee referrals, online job portals, and walk-ins.
  • Worked on deliverables such as orientation and training programs.
  • Handled grievances from employees regarding any issues with their incentives and salary.
  • Documented benefits letters, appointment letters as well as offer letters.
  • Successfully exited 300+ employees.
  • Reported regularly to management about the current health of the organization.

Education

Master's Degree - Human Resource Management

Indian Institute of Planning & Management

Bachelor of Science - Business Administration

Indian Institute of Planning & Management

Skills

  • Effective Communication
  • Reporting
  • Critical Thinking and Problem-Solving
  • Predictive Analysis
  • Profit Building
  • Consulting
  • Pivot Tables
  • Pipeline Development
  • Community Relations
  • Project Expediting
  • Site Inspections
  • Interviewing
  • Portfolio Management
  • Operational Streamlining
  • Machine Learning Basics
  • Market Knowledge
  • Data Visualization
  • Internal Controls
  • Contract Negotiations
  • Training & Development
  • Onboarding Strategies
  • Compensation Planning
  • Data Cleansing and Preparation
  • Sales Strategies
  • Corporate Communications
  • Workforce Planning
  • Power BI
  • Mondaycom
  • Tableau
  • SAP HANA
  • ServiceNow
  • Cherwell
  • PeopleSoft
  • Microsoft Office
  • WebEx
  • Outlook
  • Skype

Certification

  • CSPO - Certified Scrum Product Owner

Timeline

Senior Data Analyst

Ulta Beauty
02.2023 - Current

Senior Analyst

7-11
01.2021 - 04.2022

Senior HR Analyst

GEODIS
08.2020 - 12.2020

HR Analyst

AMR Consulting
01.2019 - 01.2020

HR Analyst

Corsalite
01.2017 - 01.2018

HR Assistant

ICF
01.2016 - 01.2017

Human Resources Executive

Red Express LTD
01.2014 - 01.2015

Bachelor of Science - Business Administration

Indian Institute of Planning & Management

Master's Degree - Human Resource Management

Indian Institute of Planning & Management

Tools And Software

  • Power BI
  • Monday.com
  • MySQL
  • Tableau
  • SAP HANA
  • ServiceNow
  • Cherwell
  • PeopleSoft
  • Microsoft Office
  • WebEx
  • Outlook
  • Skype
Ritika Malhotra