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, UP01.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