Ankita Chauhan

Associate Consultant

Gurgaon, Haryana, India5 yrs 5 mos experience

Key Highlights

Proven expertise in architecting end-to-end data pipelines.
Certified in AWS and Snowflake, enhancing cloud data solutions.
Delivered impactful data solutions across diverse industries.

Stackforce AI infers this person is a Big Data Engineer with expertise in cloud-based data solutions across multiple industries.

Contact

Skills

Core Skills

Data EngineeringCloud SolutionsData MigrationData WarehousingData VisualizationData AnalysisWeb Development

Other Skills

Advanced Business Application Programming (ABAP)Amazon Elastic MapReduce (EMR)Amazon RedshiftAnalytical SolutionsApache AirflowApache SparkAzure Data FactoryAzure DatabricksBig DataBusiness RequirementsCommunicationCreative WritingData AnalyticsData IngestionData Manipulation

About

As a results-driven Big Data Engineer with proven experience in architecting, developing, and optimizing end-to-end data pipelines, I thrive on transforming raw data into actionable business insights. I am certified in both AWS (Developer Associate) and Snowflake (SnowPro Core), with hands-on expertise in ETL, data warehousing, and business intelligence. My experience spans industries such as airlines, microfinance, and retail, where I have successfully delivered cloud-based data solutions using AWS, Snowflake, GCP, and Power BI. I excel at automating workflows, optimizing SQL and Python scripts, and designing scalable dashboards that drive better decision-making. I am passionate about staying ahead in the evolving data landscape, continuously upskilling, and tackling new challenges. If you're looking for a data professional who combines technical depth with business acumen to deliver measurable results, let’s connect! Tech stack worked on : Languages : Python ,Pyspark , C++, Linux Databases : Postgresql ,SQL ,Reshift ,Snowflake Cloud Service : AWS (Sagemaker , Glue , EC2 ,SNS , EMR ), GCP (Big query, Dataproc),Azure(ADF, ADLS) Visualisation : Power bi Automation : Airflow I am curious to learn and upskill new technologies and facing new challenges in this field to make useful products.

Experience

5 yrs 5 mos

Total Experience

1 yr 9 mos

Average Tenure

2 yrs

Current Experience

Ey

Technology Consultant

Jun 2024 – Present · 2 yrs · Gurugram, Haryana, India · On-site

Bluepi

Big Data Engineer

Dec 2021 – May 2024 · 2 yrs 5 mos · Gurugram, Haryana, India

Project -(Current )Indigo Airlines
Building a Enterprise data hub platform .Collating data from varipus sources to ADLS using ADF ,further creating a effecient data warehouse in Snowflake and creating power bi from gold layer views and tables.
Project -MPL
1.Successfully migrated data from databricks to Google Cloud Platform .
2.Converted python , sql scripts , analytical queries from databricks to google
big query .
3.Developed testing utilities in python to ensure accuracy greater than 99%.
4.Automated and scheduled scripts on Google cloud reducing manual effort by
75%.
Project - Bajaj Electricals
1.Deep dive into bajaj electricals data and built effecient data warehouse of
Bajaj Electricals .
2.Using Snowflake performed ETL, created tables , views ,facts and dimensions .
3.Visualised the data in POWER BI and created effecient dashboards helping in
sales analysis and improvement by 80% of data analysis and decision making.
4.Applied Role Based Access Control on dashboard to secure visibility of data department wise .
Project : Fusion - Microfinance Industry
1.Built data warehouse of the microfinance company using pyspark python, sql
glue jobs performed ETL operations and stored data in postgresql.
2.Analysed data with optimised SQL queries and created crisp dashboards
using Power BI which helped in better analysis and growth of company by 30
% with better decision making and profit of company .
3.Optimized python code and SQL scripts reducing running time by 20% .

ETLdata warehousingPower BISnowflakeAzure Data FactoryGoogle Cloud Platform+4

Infosys

2 roles

System Engineer

Dec 2020 – Dec 2021 · 1 yr

Project CLient : DowJones
1.Developed scripts to download and analyze data in detail performing
calculations and transformations and creating required dataframes as per
business requirement from official websites using python, libraries - numpy
,pandas,requests.
2.Improved performance by web scrapping and analysis by 25% speed by our
python scripts and optimized scripts for data-heavy & processing heavy task
automation

PythonWeb ScrapingData AnalysisData Engineering

System Engineer Trainee

Sep 2020 – Nov 2020 · 2 mos

1.Training in SAP - BI.
2.Basics of ABAP
3.ETL in SAP BW
4.Reporting using SAP BW BEx
5.SAP Business Objects -Web Intelligence
6.Modelling in HANA

Silverpush

Technical Intern (python)

May 2019 – Jul 2019 · 2 mos · Gurgaon, India

Project :Youtube Video /Audio flask application.
1. Project involved developing a module similar to Pafy using youtubedl python library for the company and a flask application to download audio ,video and save it in database sql .
2.Built connection to database using psycopg2 library .

PythonFlaskSQLWeb Development