Shenchung Tang

Accomplished IT professional with experience in full life cycle development, including analysis, design (system / database), development, testing, implementation, and maintenance of application software. Superb attention to detail and time management skills, multi-tasking to ensure all projects completed to desired specifications in necessary time frame.

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)