Back to Developers
Rachana Lenka

Rachana Lenka

Data Analyst

Bhubaneswar 2+ yrs exp 85 ยท Excellent

About

Data Analyst with 2.8 years of experience in data analytics, MIS reporting, workforce analytics, and business reporting. Skilled in SQL, Advanced Excel, Power BI, Tableau, and Python for data extraction, cleaning, transformation, analysis, and dashboard development. Experienced in automating recurring reports, optimizing SQL queries, validating large datasets, tracking KPIs, and delivering actionable insights to support business decision-making. Strong ability to collaborate with cross-functional stakeholders and translate business requirements into data-driven reporting solutions.

Skills & Expertise (43)

Cross-Functional Collaboration Advanced
8.0/10
3
Years Exp
Analytical Thinking Advanced
8.0/10
3
Years Exp
Problem Solving Advanced
8.0/10
3
Years Exp
Data Extraction Advanced
8.0/10
3
Years Exp
Data Cleaning Advanced
8.0/10
3
Years Exp
Data Validation Advanced
8.0/10
3
Years Exp
Data Transformation Advanced
8.0/10
3
Years Exp
Data Visualization Advanced
8.0/10
3
Years Exp
Tableau Advanced
8.0/10
3
Years Exp
Power BI Advanced
8.0/10
3
Years Exp
Advanced SQL Intermediate
7.5/10
3
Years Exp
SQL Intermediate
7.5/10
3
Years Exp
Variance Analysis Intermediate
7.0/10
3
Years Exp
Query Optimization Intermediate
7.0/10
3
Years Exp
Business requirements Intermediate
7.0/10
3
Years Exp
Stakeholder Management Intermediate
7.0/10
3
Years Exp
Data Modeling Intermediate
7.0/10
3
Years Exp
Data Reconciliation Intermediate
7.0/10
3
Years Exp
Python Intermediate
7.0/10
3
Years Exp
KPI Analysis Intermediate
7.0/10
3
Years Exp
DAX Intermediate
7.0/10
3
Years Exp
Trend Analysis Intermediate
7.0/10
3
Years Exp
EDA Intermediate
7.0/10
3
Years Exp
ETL Processes Intermediate
6.5/10
3
Years Exp
VBA Intermediate
6.0/10
3
Years Exp
Macros Intermediate
6.0/10
3
Years Exp
Report Automation Stored Procedures Power Query Data Integration Data Warehousing Dashboard Development performance reporting PivotTables Dashboard Automation MIS Reporting Seaborn Matplotlib NumPy Pandas Advanced Excel What-If Analysis VLOOKUP

Work Experience

Reporting Analyst

Gallagher Center of Excellence

Dec 2025 - Present

Developed and maintained MIS reports and dashboards using Advanced Excel, PivotTables, and Power Query to support business and operational teams. Performed data validation, reconciliation, and quality checks across large datasets to ensure accurate and consistent reporting. Automated recurring reports and streamlined reporting workflows, reducing manual effort and improving reporting turnaround time. Analyzed business trends, variances, and KPIs to identify performance gaps and provide actionable insights to stakeholders. Collaborated with cross-functional teams to gather reporting requirements and deliver customized analytical solutions.

Business Analyst / Data Analyst

Policybazaar.com, Gurgaon

Jul 2024 - Jan 2025

Prepared and automated daily, weekly, and monthly MIS and financial reports covering KPIs, sales performance, and target variance for management reporting. Designed and maintained interactive Power BI and Tableau dashboards, enabling stakeholders to monitor operational and financial performance. Optimized SQL queries and stored procedures used for CRM and reporting systems, reducing data processing time by 30%. Cleaned, validated, and reconciled datasets to improve data accuracy, integrity, and reporting reliability. Conducted trend, variance, and performance analysis to support sales forecasting, budgeting, and business decision-making. Analyzed staff-level KPIs, incentive calculations, and revenue contribution to provide actionable performance insights.

Electronics Engineer

Ezerx Healthtech Pvt. Ltd., Bhubaneswar

Oct 2021 - Mar 2023

Analyzed large datasets related to device testing and performed trend analysis and performance validation to support accurate reporting. Used Python and Excel automation to improve data processing and reporting efficiency for R&D teams. Conducted pre- and post-deployment data validation and variance analysis, contributing to a 30% improvement in product reliability. Analyzed testing throughput and capacity utilization and provided insights to support cross-functional teams.

Education

Post Graduate Program in Data Science and Engineering - Great Lakes Institute of Management

- 2023 ยท Afghanistan

B.Sc. in Electronics & Telecommunication - Khallikote Autonomous College

- 2021 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 10/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 85/100

Profile Overview

Member sinceSep 2026

Availability Details

Relocation

Open to Relocation