rachna das

Data Analyst

Delhi, India 80 · Excellent

About

Data Analyst with an M.Sc. in Mathematics and a Google Data Analytics Professional Certificate. Expert at leveraging advanced quantitative frameworks and statistical theory to transform complex, multi-source data into pristine, actionable corporate insights. Highly proficient in SQL, Python, Advanced Excel, Power BI, and Tableau. Demonstrated competence in exploratory data analysis (EDA), database querying, and interactive dashboard engineering to optimize metrics and drive data-backed decision-making.

Skills & Expertise (31)

Data Cleaning Advanced

8.5/10

Years Exp

SQL Advanced

8.3/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Exploratory data analysis Advanced

8.0/10

Years Exp

Pandas Advanced

8.0/10

Years Exp

Python Advanced

8.0/10

Years Exp

NumPy Intermediate

7.5/10

Years Exp

Tableau Intermediate

7.5/10

Years Exp

Data Storytelling Intermediate

7.5/10

Years Exp

Postgresql Intermediate

7.5/10

Years Exp

Matplotlib Intermediate

7.0/10

Years Exp

Seaborn Intermediate

7.0/10

Years Exp

MySql Intermediate

7.0/10

Years Exp

Probability Statistical Modeling Quantitative Analysis Descriptive Statistics Linear Algebra Calculus Interactive Dashboard Design Data Auditing Formulas HLOOKUP VLOOKUP Pivot Tables Advanced Excel Jupyter Notebook Aggregations CTEs Subqueries Joins

Work Experience

Data Analyst

Amazon

Present - Present

Engineered an end-to-end analytical pipeline to extract customer transaction records via advanced SQL logic, utilizing Excel for initial formatting, structural checks, and schema audits. Cleaned a multi-thousand-row dataset using Python (Pandas & NumPy), automating the resolution of missing variables and filtering statistical anomalies to ensure 100% data integrity. Quantified critical consumer behavior trends regarding purchase frequencies and distributions by executing exploratory data analysis (EDA) via Excel Pivot Tables. Synthesized predictive trend matrices using Matplotlib/Seaborn heatmaps, transferring data into an interactive Power BI dashboard that streamlined regional stakeholder tracking.

Data Analyst

Cyclistic

Present - Present

Audited a large-scale historical transit dataset using targeted SQL subqueries to isolate distinct behavioral patterns between casual consumers and annual subscription-based users. Streamlined data preprocessing workflows by blending database cleaning scripts with spreadsheet evaluations, reducing pipeline errors and enhancing overall dataset performance. Constructed an interactive Tableau analytics interface to present structural user patterns, providing marketing teams with clear, data-driven strategies targeting membership growth.