Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Manish Gupta

Manish Gupta

Noida

Summary

Accomplished Data Solution Architect at Tata Consultancy Services with expertise in Snowflake and data integration. Proven track record in designing data lakes and enhancing business intelligence reporting. Strong analytical skills complemented by effective communication, driving actionable insights that empower decision-making. Passionate about leveraging data warehousing and analytics to deliver impactful solutions.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Data Solution Architect

Tata Consultancy Services
07.2021 - Current
  • Company Overview: Client: Bekaert It is a global company which is mainly involved in steel wire transformation and coatings
  • Enterprise Data Lake solution: Collect and integrate data obtained from multiple source systems and populate a dedicated Data Management Platform. The solution is intended to provide a single version of truth to empower users with a consistent, trustworthy, and actionable data that will drive business decisions.
  • Design & Development of Data lakes to facilitate various Business Intelligence Reports and Adhoc Reporting.
  • Used Temporary and Transient tables on diff datasets.
  • Time traveled to 30 days to recover missed data.
  • Heavily involved in testing Snowflake to understand best possible way to use the cloud resources.
  • Technology: Snowflake, Teradata, SQL, Power BI, Python

Senior System Analyst

Intersoft Data Labs
05.2019 - 06.2021
  • Company Overview: Bed Bath & Beyond Inc. is an American chain of domestic merchandise retail stores. Client: Bed Bath & Beyond Inc.
  • EDW Migration: Involved in the design of end to end migration of data from Teradata into Snowflake datawarehouse. Data Migrated are from different domain areas like: POS(Point of Sales, E-Comm( online commerce, Pricing and customer data.
  • Digital Marketing: Promotion of brand through social media platform (Facebook, pinterest, Google Ads and internet to connect with the potential customers. Also, integrating the social media data with the sources of EDW to make digital datamarts and providing the data through visualization reports for the business needs.
  • Involved in Migrating Objects from Teradata to Snowflake.
  • Created Snowpipe for continuous data load.
  • Used COPY to bulk load the data.
  • Created internal and external stage and transformed data during load.
  • Worked on streams and tasks to schedule the procedures.
  • Heavily involved in testing Snowflake to understand best possible way to use the cloud resources.
  • Technology: Snowflake, Teradata, Python, Linux Shell Script

System Analyst

Larsen & Toubro Infotech
10.2016 - 05.2019
  • Company Overview: Client: CBDT (Central Board of Direct Taxation)
  • Account Master Creation and Data Analysis(Fuzzy Match, Deduping and Imputation logic): As, part of this project we are cleansing the data provided from the different Source. Once, the cleansing is done we are deduping and imputing the PAN coming from sources(SFT and FIU). Also, doing the FUZZY MATCH.
  • Email Categorization: Classify an email as Self or Others based on probabilities and pre-defined rules, Identification of the two best emails for a PAN in order to communicate effectively
  • Data processing and cleaning of data using advance SQL and python script.
  • Migrated GBs of data into Teradata from different source systems.
  • Working on TERADATA to write the complex logic of BI and meeting the client's need.
  • Design and maintenance of data marts for Specific business purpose.
  • Project Insight was meant to perform analytics on the information gathered from different source system and to check the hidden insights.

Data Engineer

Capgemini India Pvt. Ltd
09.2014 - 04.2016
  • Company Overview: Client: Barclays Technology: Teradata, Unix
  • TDCOE is a group which takes care of Code and Performance review of application before production checkout. Performance tuning of production based performing Teradata queries. DDL review and implementation in Development environment requested by app team.
  • Involved in performance tuning of production Teradata SQL queries.
  • DDL review and implementation in Development environment requested by app team.
  • Analyzing/Resolving the code/logic to enhance the logic of the process.
  • Project: Teradata Center of Excellence

Senior Software Engineer

Exilant Technologies Pvt. Ltd.
01.2011 - 09.2014
  • Company Overview: Client: Apple Inc.
  • The goal of this project is to measuring performance of Apple Care Call Center Agents/Advisors through the different set of performance index.
  • Developed stored procedures to facilitate consistent data entry into the database. Using Teradata Utilities(Fastload,Multiload,Bteq) to load the data.
  • Deployment document, Unit testing plan, signed off Document preparation and review
  • Project: Teradata Center of Excellence
  • Technology: Teradata, Informatica , Unix

Education

Bachelor of Engineering - Electronics and Communication Engineering

RGPV
Bhopal
07.2010

Skills

  • Snowflake
  • Teradata
  • Azure Synapse
  • SQL
  • Python
  • Tableau
  • Data integration
  • Data warehousing and analytics
  • Datalake
  • Azure Data Factory
  • Data visualization

Certification

  • Snowpro Associate certification
  • Azure Data engineer

Timeline

Data Solution Architect

Tata Consultancy Services
07.2021 - Current

Senior System Analyst

Intersoft Data Labs
05.2019 - 06.2021

System Analyst

Larsen & Toubro Infotech
10.2016 - 05.2019

Data Engineer

Capgemini India Pvt. Ltd
09.2014 - 04.2016

Senior Software Engineer

Exilant Technologies Pvt. Ltd.
01.2011 - 09.2014

Bachelor of Engineering - Electronics and Communication Engineering

RGPV

Similar Profiles

  • Vrunda Chindhade

    Vrunda ChindhadeVrunda Chindhade

    HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited

  • Sreya Basu

    Sreya BasuSreya Basu

    Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)

  • Arun V

    Arun VArun V

    Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services

  • Naimish Agnihotri

    Naimish AgnihotriNaimish Agnihotri

    Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services

  • Richa Sharma

    Richa SharmaRicha Sharma

    Deputy Manager at Optum Global SolutionsDeputy Manager at Optum Global Solutions

CREATE PROFILE
Manish Gupta