Aseem Pandey
New Delhi
Summary
Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
1
1
Certification
7
7
years of professional experience
4
4
years of post-secondary education
Work History
Data Engineer
Bot Consulting
Jaipur
02.2024 - 09.2024
- Have been budding the startup team which reached from me being the first member to reaching to 20 people for handling a a supply chain giant.
- Created SQL scripts to query, update, and manage databases as well as optimize queries for performance improvement.
- Developed and maintained data pipelines to ingest and store large volumes of data from multiple sources.
- Provided technical guidance to team members on best practices of data engineering tasks and reporting in Power BI.
- Identified potential risks associated with data processing activities and proposed mitigation strategies.
Product Analyst
Monotype
01.2023 - 12.2023
- Utilized SQL, Python, Google Analytics, Heap Analytics, Power BI, RedShift, Snowflake, and Salesforce
- Conducted Voice of Customers (VOC) Analysis to gather valuable insights on customer preferences, needs and feedback, driving product enhancement and overall customer satisfaction
- Performed Visualization Using Power BI / Tableau according to the client for data-driven decisions.
Data Engineer
Cognizant
09.2019 - 12.2022
- Converted data into actionable insights by predicting and modeling future outcomes
- Utilized SQL, Azure, AWS, SnowFlake, ETL Pipelines, Python, and data warehousing and administration.
- Performed ETL jobs to prepare the data for analysis
- Prepared and automated reports that interpret consumer behavior, market opportunities and conditions, marketing results and trends
- Assisted client having data coming from 110+ countries and organizing their supply chain data along with sales forecast and recommendations
- Worked in all the phases of the project.
Lead Data Engineer
Bounteous X Accolite
Remote
10.2024 - Current
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Applied loss functions and variance explanation techniques to compare performance metrics.
- Ran statistical analyses within software to process large datasets.
- Improved data collection methods by designing surveys, polls and other instruments.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
Internship
Cognizant
02.2019 - 05.2019
- Got a chance to work under the shadow of an experienced Data scientist
- Utilized Python libraries like pandas, matplotlib, and SQL.
Education
B.E Coputer Science Engineering - Hons In Big Data Analytics
Chandigarh University
Chandigarh 07.2015 - 07.2019
Skills
- BI Analysis
- SQL
- Snowflake
- PowerBI
- Airflow
- Stakeholder Management
- Python
- MS Excel
- Cloud(AWS,Azure)
- Statistics and Probability
- Google Analytics
- Azure Data Factory
- Big Data
- ETL
- Data Modeling
- Data Security
Certification
- Snowflake Snowpro Core Certified (04/2024)
- Power BI Certified. (08/2022)
Timeline
Lead Data Engineer
Bounteous X Accolite
10.2024 - Current
Data Engineer
Bot Consulting
02.2024 - 09.2024
Product Analyst
Monotype
01.2023 - 12.2023
Data Engineer
Cognizant
09.2019 - 12.2022
Internship
Cognizant
02.2019 - 05.2019
B.E Coputer Science Engineering - Hons In Big Data Analytics
Chandigarh University
07.2015 - 07.2019