Sr. PL/SQL Oracle Developer (contract) Resume

SUMMARY:

Over 16 years of experience Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle database.
Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

TECHNICAL SKILLS:

Oracle Developer: (Oracle Forms, Oracle Reports), Oracle Workflow Builder, XML Publisher.

Languages: SQL, PL/SQL, Java.

Oracle Databases: 11g, 12c.

Tools: Oracle Designer, Toad, SQL Navigator.

Applications: Oracle Applications 11i, R12.

PROFESSIONAL EXPERIENCE:

Sr. PL/SQL Oracle Developer (contract)

Confidential

Designed and implemented: ACA report for ADP (advanced PL/SQL and Crystal reports).
Performance tuning of many existing oracle reports in Oracle VPD database.
Technical Production support for reporting team.

Sr. Oracle Applications Developer (contract)

Confidential

Designed and implemented: custom real time AR statement in R12 application (PL/SQL, XML)
Created number of high tuned reporting data marts(PLSQL).
Amex interface (XML Publisher e - text template) for outbound payments.
Redesigned and recoded custom PO creation process(PLSQL)..
Cyber source payment interface implementation for ACH customers.
Organized, implemented, and supporting Source Control (GIT) for custom extensions.

Sr. Developer

Confidential

Designing, Development, Implementation and Production Support for Oracle R12( TCA, EDI, AR, OM, AP, INV, SC);
High performance tuning of Supply Chain data mart.
Designed and implemented Custom Form for Mass Update Customer profile Attributes.
Customized AP Invoice Hold Workflow using Oracle Approvals Management (AME), WF builder, OAF.
Designed and Implemented ADI process for mass upload Purchasing Attributes for Inventory Items on inventory organization level.
Designed and Implemented Lockbox interface program for Prism invoices.
Designed and Implemented EDI support program.

PL/SQL consultant(contract)

Confidential

PL/SQL development in high volume transactions Oracle database 11g.
Tuning and redesign custom PL/SQL packages to increase performance in existing Data warehouse ( user statement file, history YTD transaction activity) .

Oracle Application Developer (contract)

Confidential

Implementing Oracle EAM for Preventive Maintenance (R12).
Design and implementation interfaces(mobile) for EAM and WMS using APIs and custom PL/SQL packages.

Oracle Application Developer(contract)

Confidential

Design and development reports for Oracle EBS R12 (various operational areas) on Oracle 10G.
Creating reports based on highly complex queries with GL, OM, Inventory AP, AR, ATP modules.

Senior Application Developer

Confidential

Provided functional and technical solutions for AR, CRM, PO modules.
Customized Oracle CRM forms in Oracle EBS 11.5.10.
Implemented source control system and ensure it’s conformance with company objectives and policies. Integrated the source control system with QA and DBA groups through change control procedures.
Designed and implemented Custom Oracle Help for custom and standalone applications.
Designed and developed address validation application using Oracle forms, PL/SQL and mapped it to existing Oracle EBS 11.5.10 applications.

Senior Data Warehouse Engineer

Confidential

Designed and developed ETL mappings for multiple projects using Informatica and PL/SQL. Used the most advanced PL/SQL: append (bulk) and parallel DML, partitions swapping, index rebuilding, database tuning.
Last project was to process (PL/SQL) around 1 billion rows in reasonable time ( 1 hour) to populate customer history as a start point for new project. Data was located in 800 partitions - each more than 1 millions record.

Senior OPM Manufacturing Technical Analyst

Confidential

Worked on the quality of the customizations/integrations delivered in Oracle Applications implementations through improved definition of customization guidelines and development of reusable components.
Implemented source control system for use by the development team and integrated this system into the change control process used by operations.
Developed custom interfaces using PL/SQL, HTML, ORACLE forms, java in AR, OPM, AP, PO, Inventory modules.

Confidential

System Integrator

Customized numerous Oracle standard forms and reports and developed new Oracle forms and reports for business needs.
Participated in re-implementation systems for Mid-Atlantic region which merged 3 subsidiaries into one company (AR, INV, FA, AP, PO, CE, GL, ONT, QP).
Responsible for the functional and technical customization of Order Management application using Oracle Forms, PL/SQL, functional setup.
Functional design and technical implementation for Invoice, Customer interfaces(AR) between the Oracle Applications and the CommandSeries dispatch system.
Technical implementation of data warehouse for custom reporting.
Implemented custom interface for Cash Management module.
Customized inventory transfer form to serve custom need of simultaneous transfer of many inventory items.