Mahalakshmi Rajkumar

Data Analyst | Business Intelligence (BI) Developer

Chennai, Tamil Nadu 8+ yrs exp 90 · Outstanding

About

Results-oriented Data Analyst and Business Intelligence Developer with over 7+ years of corporate IT experience, specializing in SQL, Python (Pandas, NumPy), Advanced Excel, and Power BI. Proven expertise in engineering end-to-end BI dashboards, automating complex MIS reporting frameworks, and analyzing large-scale datasets (10,000+ rows) to drive actionable business decisions. Demonstrated leadership in designing internal skill-management frameworks to train team members on modern analytics and Generative AI tools. Recognized for operational excellence with 100% First-Time Right (FTR) accuracy at Tata Consultancy Services (TCS) and twice awarded 'DTDC Star Performer of the Year'. A agile self-learner ready to deliver immediate value to fast-paced Startups and leading IT MNCs with short notice period.

Skills & Expertise (28)

Advanced Excel Advanced

9.0/10

Years Exp

Power BI Advanced

9.0/10

Years Exp

Python Advanced

8.5/10

Years Exp

SQL Advanced

8.5/10

Years Exp

Generative AI Tools Intermediate

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Exploratory data analysis Advanced

8.0/10

Years Exp

ETL workflows Intermediate

7.5/10

Years Exp

Technical Mentorship Advanced

7.0/10

Years Exp

Quality assurance Prompt Engineering Data Validation Missing Value Imputation Preprocessing Java Filtering CTEs Aggregations Joins Matplotlib NumPy Pandas Executive insights KPI Dashboards MIS Reporting XLOOKUP VLOOKUP Pivot Tables

Work Experience

Data Analyst/BI Developer

RETECH Solutions Pvt Ltd

Apr 2025 - Present

Clean, preprocess, and analyze unstructured sales and customer feedback datasets using Python (Pandas, NumPy) and SQL, identifying key growth trends and operational bottlenecks. Conceptualized and executed an internal Technical Skill Management program, training team members in emerging tech domains including Generative AI tools, quantitative analytics, and future-shift skills. Leverage state-of-the-art Generative AI platforms for rapid self-learning, automated Python code optimization, data transformations, and accelerated reporting turnarounds. Build and deploy interactive Power BI and Advanced Excel dashboards tracking core organizational KPIs such as revenue velocity, order fulfillment rates, and customer retention. Draft complex SQL queries to extract, aggregate, and transform relational database records, optimizing query speed and data extraction efficiency. Automate weekly and monthly MIS reports, reducing manual processing overhead and receiving consistently strong feedback from cross-functional stakeholders.

Senior Executive (CRM & MIS Analytics)

DTDC Express Pvt Ltd

Jan 2016 - Jan 2018

Monitored operational logistics metrics, SLA delivery timelines, and customer satisfaction scores, generating daily and monthly executive MIS reports with 100% data precision. Automated routine Excel reporting models using macros and advanced formulas, reducing manual data entry workload by 30% and eliminating discrepancy risks. Executed qualitative and quantitative trend analysis on customer queries and operational logs, directly driving process adjustments that elevated service quality scores. Awarded 'DTDC Star Performer of the Year' twice consecutively (2016 and 2017) in recognition of analytical consistency and operational excellence.

Citizen Service Executive

Tata Consultancy Services (TCS)

Jan 2011 - Jan 2016

Managed structured application databases with high precision, maintaining full compliance with strict enterprise Information Security standards. Achieved an outstanding operational benchmark of 100% First-Time Right (FTR) data processing and 100% On-Time Delivery (OTD) across client deliverables. Queried database logs to investigate and resolve customer queries, identified systemic data errors, and maintained database integrity across enterprise platforms.