Ashutosh Pandey
Lead Data Engineer
Bangalore
Summary
Accomplished Sr. Data Management Engineer with a proven track record at Koch Industries, enhancing system efficiency by 35% through innovative data solutions. Expert in Data Bricks, SQL, and leading cross-functional teams. Specializes in data quality and pipeline development, driving significant cost reductions and process improvements.
Overview
10
10
years of professional experience
4
4
years of post-secondary education
2
2
Languages
Work History
Sr. Data Management Engineer
Koch Industries
06.2021 - Current
- Designed and implemented a complete data solution for the LIFT project team using Data bricks, improving system efficiency by 35% and cost reduction by 40%.
- Designed and Implemented the end to end solution for Real State Project using Data Bricks.
- Led the development of end-to-end data pipelines for Cyber Security Vulnerability Management Processes.
- Developed multi-tenant data quality modules, enhancing data accuracy across 15+ sources.
- Designed Data Quality Module for existing projects to track the Data Quality metrics and improve the process efficiency.
- Supervised a cross-functional team, ensuring timely and quality deliverables.
Sr. Software Engineer
Randstand
09.2019 - 06.2021
- Orchestrated ETL pipelines and middleware database designs for real-time data transformation, boosting decision-making for planners.
- Utilized M-Power tools to create models and execute supply chain planning rules with IBPL queries, reducing forecast errors by 25%.
- Integrated multiple tools and frameworks to streamline ETL processes, achieving a 40% reduction in processing time.
Data Consultant
O9 Solutions
04.2017 - 09.2019
- Engineered comprehensive data models for supply chain management, supporting seamless data ingestion and reporting.
- Constructed end-to-end data pipelines to maintain uninterrupted data flows, enabling accurate production cycle reports.
- Designed data transformation middleware to centralize and process multi-source datasets effectively.
- Improved data quality and consistency by standardizing data formats, establishing validation rules, and implementing automated checks.
Data Scientist
Flutura Solutions Pvt Limited
08.2015 - 03.2017
- Built scalable data models and supply chain optimization frameworks for global clients.
- Selected and integrated big data tools to meet customer specifications.
- Oversaw ETL operations, ensuring accuracy in data warehousing and transformations.
- Automated repetitive tasks using scripting languages such as Python or R, saving time during the analytical process significantly.
Programmer Analyst Trainee
Cognizant Technologies Solutions
04.2015 - 07.2015
- Completed training programs in Java, SQL, and C, contributing foundational technical skills for future data engineering roles.
Education
Bachelor of Technology (B.Tech) - Information Technology
UPTU
09.2010 - 07.2014
Skills
- SPARK,PYTHON,PYSPARK
- DATABRICKS,SNOWFLAKE
- AWS,REDSHIFT
- DATA WAREHOUSING,DB DESIGN,DATA INTEGRATION
- IBPL QUERY LANGUAGE,M-POWER (SCM)
- SSIS,MATILLION,SAP BW,ETL DESIGN
- DATA VIRTUALIZATION,MDM,DATA QUALITY,CYBER SECURITY,SUPPLY CHAIN MANAGEMENT
- SQL, R,MYSQL,ORACLE
- TABLEAU,POWER BI
- SAS,DATA ANALYTICS,DATA ENGINEERING
Contact
Bangalore, India 560035
Education
Ghaziabad, India
Languages
6,6
Personal Information
Timeline
Sr. Data Management Engineer
Koch Industries
06.2021 - Current
Sr. Software Engineer
Randstand
09.2019 - 06.2021
Data Consultant
O9 Solutions
04.2017 - 09.2019
Data Scientist
Flutura Solutions Pvt Limited
08.2015 - 03.2017
Programmer Analyst Trainee
Cognizant Technologies Solutions
04.2015 - 07.2015
Bachelor of Technology (B.Tech) - Information Technology
UPTU
09.2010 - 07.2014
Similar Profiles
Brandon HillBrandon Hill
Plant Analyst at Koch IndustriesPlant Analyst at Koch Industries
Leonard GrilloLeonard Grillo
Facility Operations/Maintenance Supervisor at Koch IndustriesFacility Operations/Maintenance Supervisor at Koch Industries
Pramod HaridasanPramod Haridasan
Finance Transformation Capability Leader at Koch IndustriesFinance Transformation Capability Leader at Koch Industries