vivek pratap singh

Data Engineer II

Advance Auto Parts•  April 2020 - July 2022

Data Warehouse Modeler: Designed and implemented data warehouse on snowflake, managed snowflake account for organization for cost-effectiveness and business value of data-driven applications. ● Streamlined ETL & Data processing: real-time data processing from sales applications and data curation. ● Migration to cloud: Spearheaded a team of five for a migration project of ~10TB of data with Snoqsql. A year-long project with 25 years of business logic and reports. coordinated across teams for accumulation of knowledge. ● Initiated CI/CD pipeline to automation for database deployments to snowflake, removes dependency on admins and saves review and implementation time. (gitlab+ubuntu+snoqsql // bitbucket+jenkins+snowsql). Two different approaches are tested successfully.

Software Engineer

ACS Global•  April 2017 - April 2020

Implemented Bi-temporal database information modeling technique on agile environment in manufacture supply chain warehouse development and business reports for delivery management. ● Managed with onshore business managers on problem statements, and guided offshore team members on resolutions and implementations—built business reports on data visualization tools SAP BOBJ, Tableau, and PowerBI. ● Developed python scripts for file data processing by employing python, Pandas, NumPy, and matplotlib. generated representative reports without integrating data database or reporting tools. ● Created scheduled data pipelines to process audit files from manufacturing units and sent out notifications to unit managers for inventory deficits, and losses. Business and technical knowledge in the Manufacturing and Health Care domain. ● Built data science proof of concept employing python to predict flight booking and cancellation using logistic regression and another one to suggest items to users based on user’s interest fields, using kNN and random forest.