UMER SHEIKH

908-***-**** • ad4i4e@r.postjobfree.com

RELATIVE EXPERIENCE:

● Extensive experience in writing Stored Procedures, Functions, Packages, and Triggers as re-usable application programs.

● Well versed in Data Modeling.

● Used SQL*Loader and PL/SQL for conversions and validations

● Well versed in Linux/Unix Shell Scripting

● Skilled in Object Oriented Programming

● Developed client/server web-based applications using Java, HTML, PHP, JavaScript, CSS, and JDBC

● Excellent in programming and quick problem solving skills

● Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask

EDUCATION:

New Jersey Institute of Technology, Newark, NJ – BS in Computer Science, Minor in Business, Dean’s list Union County College, Cranford, NJ – AS in Computer and Information Systems TECHNICAL WORK EXPERIENCE:

Change Healthcare 10/2022 – present

Senior Oracle Developer

Single Billing Platform\

Project: Single Billing Platform (SBP) is responsible for ingesting billing data from 17 sources/vendors. SBP PL/SQL processes will then calculate the data for invoices per business needs. Purpose of the project was to migrate data from PBMP (legacy) to SBP (source) Responsibilities:

• Worked with business and allocated resources to tasks.

• Created conversion / migration scripts using PL/SQL to move data from PBMP to SBMP

• Coordinated with offshore teams for development and testing

• Created PL/SQL procedures to generate reports for different sources

• Implemented and managed scheduled jobs using dbms_scheduler for reports

• Conducted code reviews for team members per standardization documentation

• Proactively troubleshooted and resolved database performance issues and code issues

• Fixed issues for assigned Jiras related to production support for performance and data issues Environment: Oracle 12c, Remedy, Unix, GitHub

CITI Bank 2/2021 – 10/2022

Page 1 of 5

Senior Oracle Developer

RCP(Resource Management application)

Project: RCP is one of the forward looking tools for used by financial planning and analysis. RCP is used for plan- ning cycle, which runs from July to December every year. Purpose of this project was to migrate data from Cloud (4 year scenario) to ECS environment (Dynamic year scenario) Responsibilities:

• Attended daily scrum meetings with API and Dev teams to discuss issues and project deliverables.

• Developed a data migration process which converted source data (cloud - 4 year scenarios) to dynamic year sce- nario (ECS) into new target schema.

• Utilized bulk delete and insert techniques in migration process.

• Created audit scripts to verify migration was successful

• Worked with offshore testing team on defects

• Fixed issues for assigned Jiras related to production support for performance and data issues in ECS and Cloud. Environment: Oracle 12c, Jira, SQL Developer..

Took some personal time for family 1/2020 – 1/2021 Army Corps of Engineers, Millington TN 8/2018 – 12/2019 Oracle Developer

CEFMS II

Background check: NACLC / IT2

Project: The Corps of Engineers Financial Management System (CEFMS) was developed under the direction of the Corps of Engineers (COE) Financial Systems of Development and Maintenance. The primary purpose of CEFMS is to develop, support, and maintain an automated management application. Purpose of the CEFMS II project was to convert legacy CEFMS code to PL/SQL code which would be used to create BI Publisher reports. Legacy code con- sisted of Oracle reports and SQR code for multiple modules including travel and finance modules. Responsibilities:

• Worked with business to gather requirements for BIP reports.

• Converted SQR and Oracle Reports code to PL/SQL.

• Created BIP reports (Excel, RTF, Standard BI reports) using the converted PL/SQL code.

• Analyzed and fixed performance issues on BIP reports and PL/SQL scripts.

• Used Dynamic SQL to fetch data from various databases to generate BIP reports.

• Made use of bulk collect to enhance performance of BIP reports.

• Developed Global Temporary tables and Pipeline functions which were utilized in generating BIP reports.

• Assisted management with debugging and tuning ‘year end’ processes.

• Helped Junior developers with PL/SQL coding issues and unit testing.

• Mentored new hires.

• Performed peer reviews for team members

• Attended daily SCRUM meetings to give status updates on currently assigned tickets. Environment: Oracle 11g, Oracle 12c/19c UNIX, AGILE, Oracle reports, SQR, BI Publisher 12.2, Toad 12.12, PVCS.

Waiting for background check to clear for Army Corps of Engineers. 4/2018 – 7/2018 XPO LOGISTICS, High Point NC 9/2017 – 03/2018

Oracle Developer

ESN Central

Page 2 of 5

Project: To support the contracts with various clients of XPO Logistics, there was a need for a Esn Central reposi- tory. This project included support for the process of planning, implementing and controlling the cost-effective flow of the products and materials in process inventory and finished goods. Responsibilities:

• Gathered user requirements for various customers to design the ESN repository and loading process.

• Developed procedure to load ES_PIPELINE_QUEUE table which would contain data to create JSON objects

• Created a Dynamic procedure to create JSON objects.

• Utilized 19c features for JSON objects.

• Generated and modified views which were utilized by business for the ESN repository data.

• Developed audit scripts to verify Kafka was online.

• Tested Jobs for performance issues and tuned queries.

• Verified data loaded to Elastic Search by using Kabana. Environment: Oracle 11g, Oracle 12c, Rally, Elastic Search, Kafka, Kabana, Toad, PL/SQL Developer, SVN. I needed to take some personal time after leaving Cigna. 04/2017–7/2017 CIGNA, Philadelphia PA 05/2013 – 3/2017

Senior Application Developer

HC ICMS & EQE Integration

Project: HC ICMS application is the Eligibility book of records for Cigna which also maintains Precerts (Claims). Responsibilities:

• Work with business to gather user requirements for Eligibility and Claims for new Cigna clients.

• Modified PL/SQL ETL procedures and packages to load Eligibility for new and existing clients per business re- quirements.

• Develop and Test connect direct (NDM) shell scripts to transfer files to data movement.

• Enhance Perl scripts for Precerts and PL/SQL packages for daily jobs per business requirements.

• Maintain extracts that send eligibility data downstream from HC ICMS.

• Worked with offshore teams to make sure projects were delivered on time.

• Monitored 17 jobs for any issues or failures.

• Analyze processes for performance issues and tuned processes as necessary.

• Worked on production support tickets per business needs.

• Assist business with data analysis for any inconsistencies with Eligibility load.

• Attend daily meetings for various Agile projects to coordinate with business. Environment: Oracle 11g, UNIX, PL/SQL Developer, Perl, Agile, VSS 6.0, HPSM.Visio, Rally GENERAL DYNAMICS, Towson MD 08/2012 – 05/2013

Senior Analyst / Application Developer

I&A Integration

Project: I&A (Identity and Access) allows Medicare providers to perform core tasks such as enrolling in Medicare and registering for NPI’s. I&A is currently part of the NPPES application. Purpose of the project is to create and enhance a separate I&A application with a new design and added functionality for CMS (Centers for Medicare & Medicaid Services).

Responsibilities:

Page 3 of 5

• Developed and recommended strategies and specifications for data solutions based on analysis of the business goals, objectives and needs.

• Created logical and physical diagrams for new I&A application.

• Played a lead role in the data conversion process.

• Converted legacy I&A data from source to target environment using PL/SQL ETL process and bulk loading tech- niques.

• Coordinated with Java developers to develop and test PL/SQL packages, stored procedures, functions and triggers to integrate with application.

• Analyzed AWR reports to find problematic queries.

• Tuned and optimized queries to fix performance issues.

• Loaded test data from CSV files using SQL Loader for QA team.

• Managed and Deployed database scripts to GDIT and CMS environments. Environment: Oracle 11g, UNIX, Java 1.6, WebSphere 7, Agile, PL/SQL Developer, SVN, TeamTrack, Erwin. GOLF SMITH INTL, Austin TX 11/2011 – 08/2012

PL/SQL Developer

Oracle ERP EBS R12

Project: Golf Smith migrated from Oracle Apps 11.0.3 to R12. Project was to design and build custom modules / programs/ applications for other integrated applications. Responsibilities:

• Gathered user requirements for various custom applications such as MEP, RAD, Physical Inventory and LOE for golf smith.

• Retrofitted, created and tested custom packages, stored procedures and functions to integrate with Oracle EBS R12.

• Worked with developers to design and integrate programs with .NET applications

• Developed shell scripts to provide batch processing and ftp transactions for physical inventory application

• Provided production support for order import from POS and WEB.

• Tested Jobs for performance issues and tuned queries.

• Setup system profiles in Oracle Apps.

• Created concurrent batch jobs for automating programs in Oracle Apps.

• LOE (Order Entry) – Developed application so users / customers can enter orders from POS/Phone/ WEB. Devel- oped validations for orders such as checks for fraudulent IP Address.

• MEP (Marketing Enhancement Program) - Enhanced MEP application to provide users with fixed dollar and per- centage rates.

• RAD (Receiving and Distribution) – Enhanced application so users can cancel purchase orders and sales orders. Environment: Oracle 11g, Oracle application R12 (Order Management, Inventory, TCA), Red Hat Linux, PL/SQL Developer, Tortoise SVN, TrackIT.

DISH NETWORK, Englewood CO 1/2011 –10/2011

PL/SQL Developer

(Billing Transformation)

Project: The purpose of the Billing Transformation project was to transfer from real time processing to batch pro- cessing for the Salescom application. The Salescom application helps define the majority of the commissioning mechanism and facilitates payouts to distributors and vendors for Dish Network. The billing transformation project consisted of eliminating the middleware and converting EJB code to PL/SQL code. Responsibilities:

Page 4 of 5

• Actively involved in gathering requirements from Business Users and converting them into system requirement specifications and creating detailed use-cases and design documents. .

• Designed, developed, and maintained PL/SQL packages and procedures as re-usable application programs that translated complex business logic in accordance with Java EJB code.

• Created tables, sequences, and indexes.

• Developed batch scripts which provided parallel processing for subscriber accounts.

• Performed unit testing, end-to-end testing and documented cases.

• Tuned and optimized queries as part of the development process and for production support.

• Utilized version control for new code changes.

• Used import/export utility to migrate data from production to development.

• Coordinated with offshore team in the development and testing phases.

• Created TRD (Technical requirements documentation) and DFD (Data flow diagrams) for new code.

• Analyzed system problems and prepared software change requests.

• Provided 24 x 7 on call production support for bi-weekly calculation processes.

• Played a lead role in daily SCRUM meetings.

Environment: Oracle 10g on UNIX, OLTP, Windows NT, Shell Scripts, PL/SQL, XML, Java, Weblogic server, Toad, PVCS, Autosys, Erwin.

Page 5 of 5

Contact this candidate