Ritika Rajput

Data Analyst

Indore, India 2+ yrs exp 84 · Excellent

About

Detail-oriented Data Analyst with 2+ years of experience building Excel and Power BI-based reporting and analysis tools for sales, revenue, and operational data. Skilled in advanced MS Excel (Pivot Tables, Power Pivot, complex formulas), SQL-based data management, and Power Query (M Language) for data cleaning and transformation. Experienced in building trend and growth models (YTD, YoY, rolling averages) and translating large datasets into clear, decision-ready insights for stakeholders. Quick to learn new domains and tools, with strong analytical reasoning and dashboard/report automation skills.

Skills & Expertise (30)

Advanced Excel Intermediate

7.4/10

Years Exp

Power BI Intermediate

7.4/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

Data Cleaning & Transformation Intermediate

7.0/10

Years Exp

Data Storytelling Intermediate

6.6/10

Years Exp

Tableau Intermediate

6.6/10

Years Exp

Python Beginner

6.0/10

Years Exp

KPI Reporting ETL Processes Power Query Requirement gathering MySql stakeholder communication Primary & Secondary Research HTML English Hindi DBMS Schema Design Star Schema Data Modeling DAX Root-cause analysis Data Normalization Forecasting Support Report Automation Data Validation Index-match Lookup Power Pivot Pivot Tables

Work Experience

Data Analyst

Cognizant Technology Solutions

Dec 2025 - Feb 2026

Analyzed large datasets using SQL and advanced MS Excel functions to identify business trends, patterns, and actionable insights, supporting data-driven decisions for stakeholders. Built and maintained Excel- and Power BI-based dashboards to monitor KPIs, track growth trends, and report on business performance across departments. Performed data cleaning, validation, and transformation using Power Query (M Language) to ensure accuracy and consistency of source data feeding forecasting and reporting models. Prepared analytical reports summarizing key drivers and trends, and presented findings to business teams to support strategic decision-making.

Data Analyst

Crystal Tech Pvt. Ltd.

Jan 2024 - Dec 2025

Analyzed ERP data using Excel to generate sales and raw-material demand reports; maintained and validated datasets for sales, procurement, and inventory planning. Built Excel-based tracking sheets for Advance Shipment Notices (ASN) and production delivery schedules, improving visibility into workflow status. Developed production and resource plans grounded in data analysis to improve workflow efficiency across departments. Managed BOM, procurement planning, invoicing, and documentation datasets in ERP systems, ensuring data integrity and audit-ready accuracy.