Summary
Overview
Work History
Education
Skills
Hobbies
Timeline
Generic

Sushant Singh

Ghaziabad

Summary

  • Hands on 3+ years of experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS)
  • Expertise in Automating SSIS packages through TaskScheduler/Autosys/Control-M
  • Worked on migration of On-Prem SQL Server, Oracle DB to AWS RDS
  • Experience designing and building web environments on AWS, which includes working with services like EC2 and ELB.
  • Hands on experience on different database like MS-SQL, Oracle, Sybase.
  • Having 3 years of IT Experience in Database Design,T-SQL, Development and business intelligence of Microsoft SQL Server 2008/2016.
  • Worked on Microsoft SQL Server 2008/2016 in Development, Test and Production Environments in banking domain.

Overview

4
4
years of professional experience

Work History

Consultant || SSIS Developer

Genpact
10.2023 - Current
  • Architected a scalable data warehousing solution that supports real-time analytics, resulting in a 40% increase in data retrieval efficiency for client-facing applications.
  • Developed a timer job for pushing the PDF file generated from the Suncorp Bank intranet site (PPF) to WB Docs (World Bank database).
  • Integrating software with the client’s existing systems and platforms using tools such as Bitbucket, Bamboo, and uDeploy.
  • Collaborated with data analysts, BI teams, and business users to understand data requirements and implement ETL solutions accordingly.
  • Maintained version control of SSIS packages, and supported CI/CD pipelines for automated deployment.
  • Developing unit tests and automated test suites to ensure software quality, and reduce defects.
  • Transformed raw data into meaningful insights through the creation of interactive dashboards, resulting in enhanced performance tracking.

Associate Senior Software Engineer

Accenture
08.2021 - 09.2023
  • Operational Data Store is a type of database designed to integrate data from multiple data sources used for regulatory reporting.
  • Working as a developer in a team which consists of 4 people where I had been Developing and maintaining SSIS package for managing data for different applications.
  • Following agile model for development.
  • Interaction with the Business Analysts to gain functional knowledge.
  • Coding in SSIS and MS SQL (complex programming queries. SPs).
  • Designing, creating and scheduling jobs through Control M and Created functions, procedure and tables in MS-SQL
  • Migrated MSSQL, Oracle Database from OnPrem to AWS Tata Consultancy

Education

B.Tech - CSE

G.L. Bajaj
Greater Noida, UP
06.2021

12th -

Vidya Bharati School
Ghaziabad, UP
06.2017

10th -

ST. Mary Christian School
Ghaziabad, UP
05.2015

Skills

  • Programming languages: C, Java
  • Tools: SSMS, SSIS, Power BI, Tableau, Visual Studio, SSDT, BIDS, DataStage, Control-M, Jira, ServiceNow, Putty
  • Operating systems: Windows, Linux
  • Database: PostgreSQL, MS SQL, SQL Server, Oracle

Hobbies

  • Watching Sci-Fi Movies
  • Playing Cricket, Badminton

Timeline

Consultant || SSIS Developer

Genpact
10.2023 - Current

Associate Senior Software Engineer

Accenture
08.2021 - 09.2023

B.Tech - CSE

G.L. Bajaj

12th -

Vidya Bharati School

10th -

ST. Mary Christian School

Similar Profiles

CREATE PROFILE
Sushant Singh