Summary
Overview
Work History
Education
Skills
Certification
Languages
Disclaimer
Experience Summary
Timeline
Generic
Siddhant SINGH

Siddhant SINGH

Navi Mumbai

Summary

Accomplished Data Analyst with over 7 years at Accenture, specializing in Teradata and Snowflake. Proven expertise in optimizing complex SQL queries and leading teams to enhance performance. Adept in Unix Shell Scripting and Agile methodologies, driving successful project outcomes while ensuring client satisfaction and timely delivery.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Associate

BNP Paribas
Mumbai
01.2023 - Current
  • Project Title 2: FDS LRR (Jan 2023 -Present)
  • Sub Domain: Teradata Data Warehousing
  • Roles and Responsibilities:
  • 7 + years of experience in Teradata development and data warehousing
  • Directed software design and development while remaining focused on client needs
  • Created BTEQ for Staging and Aggregate layers.
  • Managed team resources, including assigning tasks, monitoring progress, and ensuring deadlines were met.
  • As a part of performance improvement, used volatile table and derived queries for breaking up complex queries into simpler queries.
  • Script Automation for PVT testing
  • Working on change requests (CR) and solving Defects.
  • Tools Used: Teradata, SQL, UNIX

Data Engineer

Teradata
Mumbai
07.2021 - 01.2023
  • Understanding the business requirements and implementing in technical design and code.
  • Strong relational design knowledge and experience.
  • Promotion and Scheduling jobs in Control-M
  • Development of scripts using TPT / BTEQ and Unix to perform ETL.
  • Moving the code to higher environments, helping the client perform SIT / UAT.
  • Key contributor for Control-M scheduler migration project
  • Design and implement the testing strategy for ETL processes.
  • Creating functional and technical documents based on requirements, assist in Data Modeling.
  • Perceived basic understanding of snowflake architecture
  • Working on Migration from Teradata to Snowflake .
  • Develop Queries on SnowSql.
  • Validating the data from Teradata to Snowflake to make sure its apple-to-apple match.
  • Contributed to LDM PDM design for Snowflake as per changes required.
  • Define roles and privilege required to access different database object.
  • Exposure to CICD pipelining, Code Promotion.
  • Domain: T-Mobile, USA (Telecom domain)
  • Project Title 1: TMO HR Analytics (July 2021 to Present)
  • Tools Used: Teradata, SQL, UNIX, Control-M, GIT, Jenkins

Data Analyst

Accenture
Mumbai
11.2017 - 07.2021
  • 7+ years of progressive experience in the software industry in various aspects of SDLC such as Requirement Analysis, Design and Development, Implementation, Testing.
  • Have extensive experience on Teradata TD16 tool.
  • Experience in writing Stored Procedure, BTEQ, MOLAD, FASTLOAD, FASTEXPORT, Query Tuning and Other Teradata utilities.
  • Experience in Scheduler like Control-M , Crontab
  • Interacted with end-users and functional analysts to identify and develop Business Specification Documents and transform it into technical requirements (HLDs and LLDs).
  • Replacing Column level collect stats to Summary level Collect Stats.
  • Experience of working in all the phases of Project i.e. Development, Testing and Support.
  • Demonstrated hands-on experience in logical and physical data model. Trained in Teradata Vantage – cloud data platform.
  • Strong Experience in migrating other databases to snowflake.
  • Domain: Health and Public Service
  • Project Title 1: FMO(Finite Mile Optimization) (Feb 2018-Oct 2019)
  • Sub Domain: Teradata BI
  • Description: As part of the Final Mile Optimization project, Royal Mail is looking at a more fluid planning, routing and workload system which will allow a more efficient collection and delivery operation.
  • ETL Data warehousing projects which deals with business requirement to provide data after aggregation and transformations.
  • Roles and Responsibilities:
  • Teradata BTEQ and UNIX job development.
  • Possess good technical as well as functional knowledge of Postal Industry.
  • Playing the role of developer.
  • Created, optimized, reviewed and executed Teradata sql test queries to validate transformation rules from source to target mapping and to verify the data in target tables.
  • Worked with several facets of the Teradata – Fast load, Multiload, Stored Procedure, Table sweeps, Primary Index, Secondary Index or Join index identification for the table, Writing Complex joins and other Teradata functions to meet business requirement.
  • Prepared Unit/ Systems Test Plan and the test cases for the developed mappings
  • Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads
  • Built data layers using BTEQ and wrapper scripts.
  • Worked on Mapping Sheet, HLD, LLD and Capacity Assessment.
  • Participating in decision making discussions and performance tuning.
  • Tools Used: Teradata, SQL, UNIX.
  • Domain: Health and Public Service
  • Project Title 2: TRAFFIC Transformation (Nov 2019-July 2021)
  • Sub Domain: Teradata Data Warehousing
  • Description: Roles and Responsibilities:
  • Performed tuning and optimization of complex SQL queries using Teradata Explain.
  • Wrote BTEQ scripts to run complex queries on the Teradata database.
  • Prepared and executed UNIX scripts for users.
  • Proper analysis on Using volatile/temporary/derive tables as per requirement with proper summary/column level stats
  • As a part of performance improvement, used volatile table and derived queries for breaking up complex queries into simpler queries
  • Working on change requests (CR) and solving Defects.
  • Tools Used: Teradata, SQL, UNIX.

Education

Bachelor of Engineering(B.E) -

Thakur college of Engineering and Technology
Mumbai, Maharashtra
01.2017

Diploma -

Babasaheb Gawde Institute of Technology
Mumbai, Maharashtra
01.2014

ICSE(10th) -

GESEMS
Mumbai, Maharashtra
01.2011

Skills

  • TERADATA Utilities
  • Snowflake
  • SnowSQL
  • ETL Tool (Datastage)
  • Unix Shell Scripting
  • Agile Methodology
  • DevOps
  • Control-M
  • Jenkins
  • Teradata(1620)
  • Git
  • Jira

Certification

  • Vantage 2.3 Certified
  • Received “Zenith Rookie” Award in July 2019.
  • Received appreciations from Clients and leads.

Languages

Hindi (native), English (fluent)

Disclaimer

I do hereby declare that the particulars of information and facts stated here in above are correct and complete to the best of Knowledge and belief. SIDDHANT SINGH

Experience Summary

  • Energetic, composed, motivated Teradata developer with a passion for innovation, learning and technology.
  • Extensive knowledge in Data Warehouse Architecture and Concepts.
  • 7+ years of strong experience in DW for data transformation using Teradata, and Unix in Public Services Domain.
  • Practical Knowledge of Agile methodology.
  • Quick learner and flexible to adopt new technology and tools.
  • Technical expertise with specialization in the Data Warehouse and system development life cycle and support.

Timeline

Senior Associate

BNP Paribas
01.2023 - Current

Data Engineer

Teradata
07.2021 - 01.2023

Data Analyst

Accenture
11.2017 - 07.2021

Bachelor of Engineering(B.E) -

Thakur college of Engineering and Technology

Diploma -

Babasaheb Gawde Institute of Technology

ICSE(10th) -

GESEMS

Similar Profiles

CREATE PROFILE
Siddhant SINGH