Open to opportunities

Ananya Pandey

@ananyapandey

Message

Data Analyst and BI Developer delivering scalable Power BI dashboards with ETL, modeling, and SQL expertise.

India

Message

What I'm looking for

I want a role where I can build scalable analytics solutions—owning SQL/Python ETL, data models, and Power BI dashboards—while collaborating with stakeholders to turn requirements into decisions, ensuring data quality, performance, and continuous improvement.

I’m a Data Analyst / BI Developer with 4+ years of experience in data modelling, ETL development, and Power BI reporting solutions. I build reliable datasets and scalable BI structures by performing data extraction, transformation, and cleansing using SQL, Excel, and Python. I’m especially strong in translating business requirements into insightful dashboards and data models.

In my work, I write optimized SQL queries for large datasets, develop DAX measures and dashboard logic (filters and data refresh mechanisms), and build automated ETL workflows in Python to improve reporting efficiency. I also focus on data validation and quality checks to ensure consistency, reliability, and timely delivery, while continuously identifying process improvements and maintaining technical documentation.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst (BI)

Current

Cognizant

Dec 2021 - Present (4 years 6 months)

Performed SQL-, Excel-, and Python-based data extraction, transformation, and cleansing to create reliable datasets for reporting. Built Power BI dashboards with DAX, filters, and refresh mechanisms; developed optimized SQL for large datasets and automated Python ETL workflows with data validation for consistent reporting.

SQL Power BI DAX Python (Pandas NumPy ETL Development Data Modelling Data Validation Excel

System Engineer Trainee

Infosys

Oct 2020 - Apr 2021 (6 months)

Developed backend procedures using MySQL to support data transformation and processing. Assisted with data modelling and requirement analysis for internal applications.

MySQL SQL data transformation Data Modelling Backend Development Data Processing Database Operations Data Analytics Support Technical Documentation

Student Intern

Infosys

Jan 2020 - Mar 2020 (2 months)

Supported data transformation and database operations using MySQL for internal work. Assisted in data modelling activities and participated in business requirement discussions.

MySQL SQL data transformation Database Operations Data Modelling Business Requirements