Associate (Feb, 2022
–Present) at 3.7 years of experience as Data Analyst/ SQL/PLSQL/Developer at Cognizant
Equian Troveris Engagement | PL/SQL, SQL, OIC, XML, JSON
– Developed stored procedures/packages, crafted SQL queries to optimize financial and transactional processes.
– Led end-to-end design, development, and Implementation of OIC solutions for seamless application connectivity .
– Created BI Reports and OTBI Reports tailored to client specifications.
– Developed inbound integrations to Oracle ERP Cloud for seamless data migration using FBDI and REST APIs
– Developed outbound integrations to extract transactional data and transfer files to external systems, ensuring automated and reliable data exchange across enterprise applications.
– Extracted and transformed data from diverse sources. Clean and optimized data, handled missing values, removed duplicates and standardized formats.
– Automation solutions implemented within the SDLC to improve efficiency and accuracy.
McDonald-OHCM-OIC Interfaces | OIC, XML, JSON, SQL, PLSQL
– End-to-end design, development, and Implementation OIC integrations by modularizing components into smaller units, ensuring process continuity with scope-level fault handling for enhanced reliability
– Developed inbound integrations to HCM Cloud from external systems using the HDL approach for seamless data migration
– Developed outbound integrations to submit HCM Extracts and transfer files to target systems, ensuring efficient data flow
– Developed scalable workflows to handle file movement, directory listing, notifications and secure PGP encryption/decryption.
– Conducted testing and validation of interfaces to ensure they met business requirements, provided ongoing support and troubleshooting for integration issues and documented processes, configurations and changes for future reference.