Satyam Upadhyay

Data Engineer

South Delhi, Delhi, India11 yrs 9 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Designed first star schema-based data warehouse at Blinkit.
  • Migrated over 100 jobs from Azkaban to Airflow.
  • Revamped Zendesk CRM for improved efficiency.
Stackforce AI infers this person is a Data Engineer with extensive experience in E-commerce analytics and business intelligence.

Contact

Skills

Core Skills

Data Warehouse ArchitectureStakeholder ManagementCrm ManagementReporting & Analysis

Other Skills

SQLZendeskSpectrumPrestotrinoPostgreSQLazkabanLogical Data ModelingApache AirflowVerticaPython (Programming Language)Extract, Transform, Load (ETL)Data WarehousingAmazon RedshiftQlik Sense

About

With over 8 years of extensive experience in the Analytics and Business Intelligence domain of e-commerce companies such as Blinkit (formerly Grofers), Healthkart, Snapdeal, and Gwynniebee, I have gained valuable expertise. Presently, I work as a Lead BI Engineer at Blinkit for the past 4 years, where my primary responsibilities include designing, developing, and maintaining data warehouses. I established Blinkit's first star schema-based data warehouse for customer-side metrics, as well as designed, developed, and implemented multiple third-party data source replication pipelines. In addition, I have taken several sessions on optimized code writing in Redshift/Presto/Trino/Spectrum to ensure that we maintain high standards of SQL writing and ETL practices. As a self-motivated individual contributor, I possess expertise in data warehouse design and implementation, as well as in-depth knowledge of analytical tools such as Python, SQL, Redshift, and Airflow. In addition to analytics, I have also designed, implemented, and documented the complete backend of CRM (Zendesk) for Snapdeal and Gwynniebee. As a bike lover and avid reader, I am excited to explore new opportunities in Analytics and BI, where I can apply my unique creative and analytical skills to generate valuable insights to enhance and optimize businesses.

Experience

11 yrs 9 mos
Total Experience
2 yrs 4 mos
Average Tenure
2 yrs 10 mos
Current Experience

Udemy

Enterprise Data Engineer

Aug 2023Present · 2 yrs 10 mos

Blinkit

Lead BI Engineer

Jul 2019Aug 2023 · 4 yrs 1 mo · Gurugram, Haryana, India · On-site

  • As a BI Engineer, I am responsible for designing, developing, documenting, and implementing a star schema-based warehouse architecture for consumer-side metrics. I collaborate with a team to accomplish this goal, bringing my expertise to the table to ensure the architecture meets our needs.
  • Additionally, I work independently to design, develop, and document a star schema-based relational data model for temperature data sourced from third-party APIs. I also create and implement a source replication pipeline from various third-party data sources, including APIs, S3 data dumps, chatbot data, and competitive pricing data.
  • To ensure our systems remain up-to-date and optimized, I successfully migrated over 100 jobs from Azkaban to Airflow as part of Azkaban's deprecation. I also conduct multiple training sessions on optimizing query writing for Amazon Redshift, Trino, Presto, and Spectrum tables.
  • Finally, I am proactive in administering Redshift by setting up automated alerts and improving its performance through the application of distribution and sort keys on frequently accessed tables. My contributions help ensure our systems are efficient, effective, and able to meet the needs of the business.
SQLData Warehouse Architecture

Healthkart

Senior Data Analyst

Sep 2017Jul 2019 · 1 yr 10 mos · Gurugram, Haryana, India · On-site

  • In this role, As the primary owner and stakeholder manager for the Operations, Finance, and B2B teams, I oversaw all analysis and reporting requirements. This involved maintaining and updating a star schema-based data warehouse and creating data marts.
  • I provided analytical support to the Leadership/Product and Tech Team in fulfilling their ad-hoc requirements. Additionally, I assisted the Finance and Operations teams during external and internal audits by providing them with necessary data.
  • From an analytical and data support perspective, I acted as a liaison between the Tech, Product, and Business teams to ensure effective collaboration among all parties.
SQLStakeholder Management

Gwynnie bee

Jr. Analyst

Sep 2016Sep 2017 · 1 yr · Greater Delhi Area · On-site

  • In this role, as a product owner and administrator for Zendesk (CRM) and 8x8 (dialer), I was responsible for completely revamping and documenting the existing structure of triggers and automations for Gwynieebie. Additionally, I onboarded two new tenants, namely New York & Company and Ann Taylor, in the professional edition of Zendesk.
  • I also played a key role in restructuring and automating the complete reporting framework for the Customer Service and Accounts team in Tableau. Furthermore, I provided analytical support to the Product Team for their ad-hoc requirements, which helped me gain valuable insights into the product development process.
  • During this experience, I had the opportunity to work in an onshore-offshore model, which allowed me to improve my communication skills and work effectively with colleagues across different time zones.
SQLZendeskCRM Management

Snapdeal

2 roles

Business Analyst II

May 2016Sep 2016 · 4 mos · On-site

  • In this role, I was responsible for overseeing the entire technology execution of the Net Promoter Score (NPS) process. I took ownership of improving and reporting NPS results regularly, and provided analytical support to the leadership team to identify key areas for improvement through Buyer and Seller NPS results. Additionally, I supported the team by analyzing internal surveys and fulfilling custom research requests.
Reporting & AnalysisSQL

Process Analyst

Aug 2014Apr 2016 · 1 yr 8 mos · On-site

  • In this role, I was responsible for a range of tasks related to reporting and analysis. I designed, maintained, optimized, and automated a complete reporting framework, and documented all of the processes involved. I also conducted in-depth analysis of key metrics like OTR, TAT, CSAT, and return processes, and set up anomaly detection reports to ensure that any issues were identified and addressed quickly.
  • Another important part of my role was to analyze the impact of policy changes and new technology releases on performance metrics, so that we could continuously improve our processes and systems. I also measured the efficiency of automated tasks running on the backend, such as auto refund, auto CCA, and RTO updates, to ensure that they were running smoothly and contributing to our overall performance.
  • In addition to these tasks, I assisted with third-party audit processes by providing relevant data and information. I worked closely with the audit team to ensure that they had access to all of the necessary data and that it was presented in a clear and organized manner. I also worked closely with the Product and Data Warehousing teams to devise business requirements that would help us achieve our goals.
  • Finally, I was responsible for the CRM workflows, acting as an administrator to ensure that they were running efficiently and effectively. Overall, my experience in this role allowed me to develop a wide range of skills related to reporting, analysis, and process improvement.
Reporting & AnalysisSQL

Education

PSIT, Kanpur

B.TECH — Computer Science and Engineering

Jan 2010Jan 2014

Raj English School, Varanasi

Intermediate — PCM

Jan 2007Jan 2009

S S Public School

High School

Apr 2006Mar 2007

Stackforce found 100+ more professionals with Data Warehouse Architecture & Stakeholder Management

Explore similar profiles based on matching skills and experience