Summary
Overview
Work History
Education
Skills
Projects
Achievements
Timeline
Generic

Shadab Akhtar Ansari

Bangalore

Summary

I am a seasoned Data Engineer, proficient in automating data ingestion, transforming data, building models, and managing data workflows to deliver actionable insights in the e-commerce, FMCG domain. Currently, I am working with a global home appliance company to develop, automate POS and market share insights using SAP HANA and BW. Responsible for creating process chains, overseeing data ingestion, and collaborating closely with stake holders to understand business requirements, and deliver effective solutions.

Overview

4
4
years of professional experience

Work History

Data Engineer

Evalueserve
Bangalore
04.2021 - Current
  • Engineered and managed scalable ETL/ELT pipelines utilizing Azure Data Factory and dbt, integrating data from diverse sources, and loading it into Snowflake for downstream analytics.
  • Designed and developed modular data models in dbt using ETL/ELT, enabling reusable transformations, and improving the pipeline by 20%.
  • Automated file ingestion from Azure Blob via Azure Data Factory, and delivered modeled datasets using dbt in Snowflake, accelerating dashboarding and KPI tracking.
  • Building SAP HANA graphical Calculation Views (CVs) for POS and Market Share to provide insights into retail sales performance.
  • Setting up POS data ingestion pipelines integrated with SAP BW and HANA to develop reusable Calculation Views for reporting and planning.
  • Partnered with stakeholders and BI teams to align Calculation Views with KPI definitions and global reporting standards, saving 10 hours per week.

Education

Bachelor of Technology - Computer Science

Vellore Institue of Technology
Chennai
05-2020

Skills

  • Languages and Querying: SQL
  • Data Warehousing and Modeling: Snowflake, SAP HANA, SAP BW
  • Data Transformation and Workflow Orchestration: dbt, Azure Data Factory (ADF) and ETL/ELT
  • Cloud and Storage: Azure Blob Storage, Azure Storage Explorer
  • Version Control and DevOps: SAP ChaRM, Azure DevOps and Git
  • Other Tools: Excel and SAP GUI

Projects

  • Retail POS Analytics : Worked on Point of Sale data across all retail channels by developing Calculation Views using SAP HANA, SAP BW, and SAP ChaRM to derive insights on sales performance and key KPIs.
  • AHAM Market Share Insights Enablement : Developed Calculation Views in SAP HANA to extract and compute redacted figures from AHAM industry data, leading to enhanced insights and improved accuracy in Market Share analysis.
  • Market Share Analytics : Developed a Calculation View in SAP HANA that generates monthly reports, providing the client with market share metrics such as units and revenue alongside industry data, enabling comprehensive market share analysis.
  • eCommerce Analytics : Developed multiple processes including the US eCom Profit & Loss Report and US Weekly Sales Performance reports for various retailers using SQL, dbt, ADF, Azure Data Storage Explorer, and Snowflake. Automated these workflows to generate monthly and weekly reports, significantly reducing manual effort and human intervention.
  • SKU Availability System : Designed a system for real-time monitoring and reporting of SKU availability using SQL, dbt, and Azure Storage Explorer, improving inventory management efficiency and delivering critical insights for decision-making in the e-commerce domain.

Achievements

  • SQL Advanced, Hacker Rank (03-2023- Present) - Certificate of Qualification from Hacker Rank for SQL Advanced Programming.
  • Made My Day (03/2022) - Certificate for Exceptional Performance within the Team.

Timeline

Data Engineer

Evalueserve
04.2021 - Current

Bachelor of Technology - Computer Science

Vellore Institue of Technology

Similar Profiles

CREATE PROFILE
Shadab Akhtar Ansari