Sarthak Gupta

Mentor junior consultants and contribute to best-practice frameworks and training programs while advising clients and driving architectural decisions for UKG Pro integrations. Lead complex PSI integration implementations for US clients across UKG Pro, SQL interfaces, and Benefits Hub using US Payroll, GL, COBRA, and HCM domain knowledge.

Worked in the Pro Suite Integrations Team (PSI) on new builds and go-lives for US clients, including SQL and Benefits Hub integrations in the UKG Pro/HCM domain. Trained and mentored junior team members and received the 'Delivery Champ' award for FY 2024-2025.

Developed and optimized database logic including procedures, functions, triggers, indices, partitions, and delta indices using PL/pgSQL, PL/SQL, and T-SQL. Built and executed data migration, supported claims file generation (837/835), and performed performance tuning and maintenance with documentation and recovery processes.

Trained and worked on advanced SQL topics including partitioning, CTEs, performance optimization, and archiving processes. Focused on writing and tuning SQL to improve query and database performance.

Responsible for performance tuning at mapping/session/source/target levels for SCD Type 1 and Type 2 data loads. Implemented functional database designs, integration strategies and plans, wrote SQL logic and procedures, migrated data using SSMS and IDSS tools, and created unit test cases and documentation.

Conducted network auditing and designing activities and prepared performance reporting. Recorded equipment updates from field engineers.

Earned a Bachelor's Degree in Electrical & Electronics. Completed the degree at Dr. APJ Abdul Kalam University in Ghaziabad, Uttar Pradesh, India.