Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
SARTHAK GUPTA

SARTHAK GUPTA

Integration Consultant II
Ghaziabad

Summary

Dynamic professional with over 7 years of experience in integration solutions, demonstrating a robust background in system integration, software development, and data transformation. Expertise in database management, HCM integrations, and enterprise software drives efficiency and fosters innovation. Proven track record of enhancing team collaboration and adapting to evolving needs ensures consistent delivery of impactful results. Renowned for reliability and a results-driven approach within complex technical environments.

Overview

8
8
years of professional experience
2
2
Certifications

Work History

Integration Consultant II

Ultimate Kronos Group
09.2022 - Current
  • Working in Pro Suite Integrations Team (PSI), UKG Pro, HCM domain, handling new builds, go lives for US clients including SQL and Benefits Hub Integrations.
  • Acquired domain knowledge including US payrolls, General Ledger, Cobra, Benefits etc.
  • Conducted training and trained/mentored junior folks on technical and functional skills.
  • Awarded as ‘Delivery Champ’ for FY 2024-2025 for delivering highest number of Integrations.

Database Associate

Avizva Solutions Pvt. Ltd
06.2021 - 08.2022
  • Developed complex logic while writing Procedures, Functions, Triggers, Indices, Delta Indices, Partitions, T-SQL using PL/pgSQL and PL/SQL.
  • Developed Data Migration Consolidated code based on the UI design changes and the data model changes.
  • Working as part of a development team on MySQL, SQL Server and Postgres and establishing close working relationships with stake holders, quality assurance, architects, as well as management.
  • Collaborate with team members to set business standards, set up recovery, backup archiving processes
  • Worked on 837 and 835 Claims System to generate Claims file for customer.
  • Improved and debugged code by testing throughout design stages.
  • Optimized database performance by systematically tackling system weaknesses.
  • Created conceptual, logical and physical models using specific methodologies for analysis using Draw.io and Oracle Data Integrator (ODI).
  • Drafted database scheme by following Relational Database Management System (RDBMS) rules.
  • Wrote documentation on databases for both technical and non-technical audience.
  • Completed preventative maintenance tasks and recovery procedures for maximum database integrity.

Software Engineer

Puresoftware Ltd
02.2021 - 06.2021
  • Trained and worked upon Advance SQL like Partition over clause, CTEs, Performance Optimization and Archiving Process.

Systems Engineer

Infosys Ltd
09.2018 - 11.2020
  • Responsible for Performance Tuning at the Mapping, Session, Source and Target level for SCDs Type 1, Type 2 for Data loads.
  • Understand the business needs and implement them into a functional database design.
  • Defined technical integration strategy and developed Integration plans.
  • Wrote and coded descriptions for physical and logical databases by writing CTEs, complex SQL logic, Procedures to achieve the desired optimized result.
  • Produced complex database project with zero issues due to effective troubleshooting.
  • Developed and updated all documentation related to database technologies for department.
  • Worked with clients across multiple verticals, including software, investment banking domain.
  • Migrated existing data strategically to prevent disruption to critical business applications using SSMS and IDSS tools.
  • Wrote Unit test cases and prepared documentation for the same to test the integrity of Target Database.

Network Records Associate

British Telecom Global Services Pvt. Ltd
03.2018 - 08.2018
  • Network Auditing and Designing, Performance Reporting and recording the equipment updates from the field engineer.

Education

Bachelor's Degree - Electrical & Electronics

Dr. APJ Abdul Kalam University
Ghaziabad, UP
01.2017

Skills

  • Database- MySQL, MS SQL, Postgres, Oracle
  • Language- SQL, C, C, Python, PL/SQL, PL/pgSQL
  • Data Analytics- ETL, Hive
  • Tools- Informatica, DBeaver, PgAdmin, IDSS, SSMS, Eclipse, POWER BI, Oracle Data Integrator (ODI), Drawio, JIRA, Bitbucket
  • Database performance tuning
  • Strong Communication

Certification

Infosys- Global Agile Developer & Business Intelligence.

Timeline

Integration Consultant II

Ultimate Kronos Group
09.2022 - Current

Database Associate

Avizva Solutions Pvt. Ltd
06.2021 - 08.2022

Software Engineer

Puresoftware Ltd
02.2021 - 06.2021

Systems Engineer

Infosys Ltd
09.2018 - 11.2020

Network Records Associate

British Telecom Global Services Pvt. Ltd
03.2018 - 08.2018

Bachelor's Degree - Electrical & Electronics

Dr. APJ Abdul Kalam University
SARTHAK GUPTAIntegration Consultant II