Senior Oracle PL/SQL Developer - Sodexo - Remote (WFH)
(2025-02 - 2025-08)
Data Warehouse/Informatica with Oracle: Sodexo global company provides food services and facilities management expertise to more than 1,600 clients. Work on the Carma Modernization project which is a reengineering of the national rebate and volume discount calculation platform that drive much of Sodexo's profitability.
- Work on the data modeling, analytics platform fed by the inbound data, assessment and remediation in VAST package.
- Develop complex package/stored procedures/functions for spend product, sold amount, rebate and rollup sum.
- Tune and optimize PL/SQL code to improve performance in Data Warehouse using hints and tools like EXPLAIN PLAN.
- Verify millions records in fact tables and identify data discrepancy then provide solution to resolve errors or issues.
- Extremely strong SQL development skills to execute the target state of VAST.
- Work on the ETL process extracting data from source files/tables, through transformations and loading into target staging/dimension/fact tables in Snowflake Data Warehouse using Informatica PowerCenter.
- Modify mappings, transformations, workflows, tuning queries and monitoring results.
- Validate architectural design regarding the ingestion of data from ITN and the consumption of data by downstream.
- Involve Supply Chain, particularly rebate management and volume discounts on non-VAST downstream systems.
- Monitor Autosys scheduled jobs and review reports when the job enters various phases of the schedule.
- Communicate complex technical issues to business user; Assist with architecture and code reviews.
Senior Oracle PL/SQL Developer - Cigna - Morris Plain, NJ
(2023-06 - 2024-12)
DataMart/AWS/APEX with Oracle
- Develop complex package/stored procedures/functions/views for Claim Data, Enrollment and Endorsement processes for Supplement Health System
- Tune and optimize PL/SQL code to improve performance in OLTP and OLAP environments
- Employed data model / table / view / index / trigger / constraint / sequence / cursor for business requirements
- Load and transform Majesco claims extract data file (external tables) to staging tables and process staging data into claims on-prem data mart
- Extract claims delta records and create JSON format file then send file to EDP
- Create/Schedule UC4 jobs and job chains for files process flow to execute procedures and move files to AWS
- Work on Enrollment and Endorsement process – proceed Majesco eligibility file from AWS and go through reconciliation then load data to staging tables; process staging data into master tables and save errors into table
- Resolve members and claims data discrepancy between Majesco and Cigna databases
- Modify Python package and deployed to AWS Lambda functions for endorsement; troubleshooting through Cloud Watch; Involved AWS Glue job for ETL process
- Use APEX App Builder to create and design eligibility pre-processing file applications; owners can generate reports
- Prepare SQL Query for data verification and conduct performance tuning for PLSQL in APEX app
- Support and maintain APEX API calls to Get/Post/Put/Delete member information through ORDS RESTful service
- Use GitHub, DevOps, Jenkins CI/CD pipeline process for Oracle/Python/UC4 Job packages release deployment
- Involve production and operations support for all ServiceNow related claims/enrollment/endorsement issues
Senior Oracle PL/SQL Developer - United Healthcare - Horsham, PA
(2021-06 - 2023-04)
MicroStrategy Report with Oracle DataMart:
- Develop complex package/stored procedures/functions for Billing, Claim Data, Application, Agent, Employer etc.
- Employed table / view / index / trigger / constraint / sequence / cursor for business requirements
- Write queries with reference cursors, collections (variable arrays/nested tables), analytical functions and inline views
- Tune and optimize PL/SQL code to improve performance using hints and Oracle tools like EXPLAIN PLAN and Profiler
- Design and create MicroStrategy Freeform SQL Report/Dashboards/Documents using various Data Warehouses
- Use Dossier to create showcase by importing data from a file, database and custom query to explore business data
- Involve maintaining Mapping, Transformation, Workflow, Monitoring Informatica ETL process and data verification
- Test and troubleshoot Report/Dashboards/Documents from Data Warehouses/Data Marts
- Wrote Unix Shell Script for Archive/Purge reports monthly process
- Use IBM Workload Scheduler to schedule and monitor jobs for reports
- Use GitHub, DevOps, Jenkins CI/CD pipeline process and IntelliJ tool for Oracle package release deployment
- Involve production and operations support for all the ServiceNow related issues
- Develop technical specification and design document
Senior Sybase/SQL Server Developer - SelectHealth - Murray, UT
(2021-01 - 2021-04)
Sybase to SQL Server Migration:
- Analyze data modules of Medical/Dental healthcare system for FACETS database in Sybase
- Prepare queries and migration plan to convert or create users / roles from Sybase to SQL Server
- Migration of Sybase objects using migration tool called SSMA (SQLServer Migration Assistant).
- Convert Sybase stored procedures and functions to SQL Server manually or using SSMA
- Performance tuning, tuning of queries, analyzing structure of queries using Microsoft T-SQL.
- Experience in developing custom reports for business end users using SQL Server Reporting Services SSRS.
Senior Oracle Developer - BNY Mellon - Jersey City, NJ
(2020-02 - 2020-12)
Sybase to Oracle Migration
- Convert Sybase stored procedures and functions to Oracle and analyze output data results
- Review and enhance existing Sybase/SQL code to improve performance
- Involved data conversion, tool configuration, data refresh or migration
- Troubleshoot or confer with others troubleshooting errors or QA test problems
- Analysis of Sybase/SQL codes and development where changes are necessary
- Performance tuning, tuning of queries, writing stored procedures and functions
Senior Application Developer/Oracle Developer - UPS - Parsippany, NJ
(2018-01 - 2019-10)
ESP/ESTAT Sales Application (Oracle)
- Implement, support and maintain ESP (Enterprise Sales Planning) and ESTAT Sales Application
- Worked on Monthly Snapshot, Customer Definition, Sales Hierarchy, Opening and Closing Sales Planning
- Created, developed and modified SQL scripts / packages / procedure / function based on business requirements to support programs and ensure proper execution
- Involved in Extraction, Transformation and Loading (ETL) processes using UNIX shells scripting, PL/SQL and SQL*Loader
- Performed SQL, PL/SQL performance tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE
- Involved in table partitioning, index creation and used bulk collection in PL/SQL objects for performance improvement
- Using hints to direct the optimizer to choose an optimum query execution plan
- Worked on data loading using PL/SQL and SQL*Loader within UNIX scripts to download and manipulate files
- Created PL/SQL scripts to extract the data from the operational database into flat text files using UTL_FILE package
- Maintain VB.NET and Java web application to display data by calling procedures through db connection
- Developed Unix Shell Scripts for invoking SQL scripts and scheduled them using crontab
- Wrote Unix Shell Script for Audit program, daily AM/PM Batch, Data Refresh and Mass Alignment processes
- Involved daily SCRUM meeting including Sprint Planning/Backlog, Daily Standups, Sprint retrospectives and Demos
- Responsible for 24x7 production support including troubleshooting to diagnose, isolate, correct data and issues
Lead Application Developer - ADP - Roseland, NJ
(2010-01 - 2017-11)
Associate Portal (NodeJS / AngularJS / React / MongoDB):
- Utilized HTML/JavaScript/jQuery/Ajax/AngularJS, developing Node.js RESTful APIs for developing rich user experience
- Worked on new Associate Portal user-facing features, using React.js and retrieving data through APIs
- Created Oracle PL/SQL stored procedures/function/views/queries using TOAD for enhancement in the application
- Developed and integrated PL/SQL code for data manipulation, validation, and reporting
- Performance tuning and query optimization to enhance database performance
- Conducting unit testing and debugging to ensure the functionality and accuracy of PL/SQL code
- Created JavaScript programs, utilizing NodeJS modules that handled automated email distribution
- Installed / configured MongoDB, built Node.js controllers and APIs, retrieving data from MongoDB
- Prepared data mappings, JSON d
Associate/Developer - ADP - Roseland, NJ
(2000-01 - 2010-12)
