Summary
Overview
Work History
Education
Skills
Accomplishments
Social Links - Linkedin
Courses Certifications
Personal Information
Timeline
Generic
Shubham Asthana

Shubham Asthana

Data Manager
Lucknow

Summary

Solution-focused Data Management/Warehousing Specialist with 7.8 years of experience working in BFSI/L&D/FMCG/Supply Chain sectors. Technically-savvy and proficient in data analysis, team support and process improvements. Polished in Data Assessment, BRD preparation, conducting analysis and research to come up with solutions to business requirements.

Overview

8
8
years of professional experience

Work History

Data Manager

Deloitte
01.2022 - Current
  • Responsibility: Working on Data Manager/Data SME role for FMCG client in their Data & Analytics domain and provide expertise as a Techno-Functional Data Consultant, Owns and / or consults on data components of a project or product. Involve in building Sales and Distribution KPIs for product analytics which in return gives sales business insights for predictive and prescriptive analytics.
  • Individual Contributor: Lead Market Engagement and Stakeholder Management in translating business request/problem into analytics requirements and developing working prototypes for obtaining signing off for build by writing SQL and PLSQL scripts
  • Architecture and Design: Collaborate with Technical Architects to convert the Functional Specifications to Technical Design.Lead trade promotion implementation projects from start to finish, ensuring timely delivery and high-quality results
  • Technical Business Analyst: Technical Design Document/Functional Requirement Document (FRD) preparation for functional requirements and Business Requirement Documents (BRD) preparation for technical requirement. Lead the Data Discovery activity with external customers. Providing an assessment and plan for data acquisition and preparation
  • Data Engineering with Code Quality: Ensure the development of high-quality, maintainable code by setting coding standards, conducting code reviews, monitoring execution of data pipelines and Code peer review. Providing inputs for creation of Data Pipelines.
  • Data Quality: Ensure the accuracy, completeness, and consistency of first-party data through data cleansing, validation, and enrichment processes. Develops methods for improving data wrangling, data solution availability and performance
  • Documentation/Metadata Document: Maintain comprehensive technical documentation, Data Flow Diagram, Data Modelling, Data Dictionary/Catalog to facilitate knowledge sharing and team collaboration. Acquires, prepares, catalogues and maintains data assets for analytical products, projects, and experimentation environments, with a focus on quality
  • Data Integration: Facilitates data integration and data exploration across internal or external data sets that are relevant. Interprets data, analyses results using basic statistical techniques and provides reporting and insights. Integration with SAP-ECC, Snowflake Cloud DB, and multiple different heterogeneous systems, ETL Development, Datawarehouse Design then ingesting the objects in DataLake in different file formats such as CSV, parquet, delta file, etc
  • Data Visualization: Proficiency in deriving data insights, predictive analysis and provide valuable data in the form of Report/Dashboard via PowerBI, which helps the executives to conduct new promotions.

Database Developer and Data Governance Manager

Tata Consultancy Services (TCS)
Kerala, Mumbai, Lucknow
06.2016 - 01.2022
  • About: Worked in BFSI domain for Axis Bank in Technical Support role for 6 months then got deputed for an internal client of TCS in their Learning & Development domain for next 5 years as a Data Analyst/Database Developer.
  • Database Developer: Writing SQL/PLSQL codes from basic to complex at PostgreSQL platform such as Procedures, Functions, Triggers, Batches, data archiving, data integration logics.
  • Performance Tuning: Enhancing the performance of existing procedures for the purpose of increasing the efficiency of the SQL scripts. Defining Indexing, Cardinality, Partitioning, vacuuming, etc
  • Data Consultant: Accountable for technical production support managements, data management, data archiving or migration, data integration, etc
  • Process Improvement: Evaluated problem issues, understanding root cause, solving the tech code issues, improvise the system code health
  • ETL Informatica: Testing of product code which are integrated with ETLs, running on Informatica and movement of ETLs to Kafka for real time flow of data
  • Presentations: Preparing reports and presentations for the management stating trends, patterns,and predictions using relevant data
  • Product Manager: Defines the product vision, product roadmap, and product positioning, bringing customer centric increment in product
  • Data Governance Manager: Working closely with Data Privacy Officer as a Data Steward cum Data Processor, to get align with GDPR policies within a project, bringing Privacy by Design, Data Retention, Data Purging.

Education

Bachelor of Technology - Computer Science Engineering

Integral University
Lucknow
05-2016

Class XII - Science Education

Montfort Inter College
Lucknow
01.2012

Skills

  • Product Management
  • Reporting And Analytics
  • Scrum Master
  • Trade Promotion Management
  • SAP-Sales And Distribution
  • SQL and PL/SQL
  • Data Warehousing
  • Data Management
  • Data Governance
  • Azure Databricks
  • Snowflake Cloud DB
  • Data Engineering
  • ETL Informatica
  • Data Analytics
  • Power BI Desktop
  • Postgresql
  • Oracle
  • SAP ECC
  • Data Architecture
  • Python-Basics
  • Power BI Desktop

Accomplishments

  • Received appreciation from Europe Head of a company with respect to system design, preparing modelling and delivering the complex financial promotion analytics report.
  • Elected as Data Privacy Manager at an organization level to handle Data Privacy of all projects at unit level.
  • Best Team Leader among the similar domain projects in TCS.
  • Chief Coordinator of Integral University Training Placement and Committee (IUTPC)at Integral University.

Social Links - Linkedin

www.linkedin.com/in/shubham-asthana

Courses Certifications

  • PROFESSIONAL SCRUM MASTER I
  • Microsoft Certified: Azure Data Engineer Associate
  • Microsoft Certified: Azure Data Fundamentals
  • IBM Certified: Enterprise Design Thinking Practitioner
  • Microsoft Certified: Power BI Data Analyst Associate (Valid Upto February 2023)
  • GMAT (Valid Upto March 2026)
  • Google Certified: Cloud Digital Leader (Valid Upto September 2025)

Personal Information

  • Total Experience: 7 Years 7 Months
  • Date of Birth: 09/14/94
  • Gender: Male
  • Marital Status: Single/Unmarried

Timeline

Data Manager

Deloitte
01.2022 - Current

Database Developer and Data Governance Manager

Tata Consultancy Services (TCS)
06.2016 - 01.2022

Bachelor of Technology - Computer Science Engineering

Integral University

Class XII - Science Education

Montfort Inter College

Similar Profiles

CREATE PROFILE
Shubham AsthanaData Manager