SUMMARY:

I am a Technical Lead with 20+ plus years of experience in administration, design and development using ORACLE RDBMS and its associated tools. I have a strong knowledge of Oracle R12.1.6 (OAF) and 11i versions in the Operations, Manufacturing, OTC and Finance Project areas. This includes modules such as AR, Advanced Collections, AP, GL, INV, BOM, Routings, PO, XML Publisher, Workflow, APEX, OPM, OM, Advance Pricing, FA and PA.

SKILL:

Languages: PL/SQL 8i/8.0/7.x, SQL 8.1.x/8.0.x/3.x

DBMS/RDBMS: Oracle 8i(8.1.x),8.0.x,7.x, Oracle8, Oracle7, SQLSERVER

Applications: Oracle Financials AR, AP, GL, OPM, FA, OM, HR (11i, 11.x, 10.7SC, 10.7NCA, 10.5)and Manufacturing, Oracle Forms6i/ 6.0/5.0/4.5/3.0 , Oracle Reports6i/ 6.0/3.0/2.5/1.1 , Oracle Developer Server, Oracle Reports Server/CGI, Oracle Designer, Oracle Discoverer, SQL*PLUS 8.1.x/8.0.x/3.x, SQL*Loader 8.1.x/8.0.x/7.3, TOAD, SQL*Navigator, SmartDB

Methodologies: Oracle AIM

EXPERIENCE:

Confidential, Temple, TX

Technical Lead

Responsibilities:

• Worked with customers to build mapping docs for Master data.
• Worked on the Rice List Estimates.
• Conducted Technical Workshops to discuss Conversion Approach.
• Performed SysAdmin tasks to setup multiple instances.
• Designed, developed and deployed the following custom extensions:
• Interactive Dispatch List (IDL)
• Multi - DNC
• Mass User Toggle
• User Audit
• Batch Printing of Work Orders

Confidential, Seattle, WA

Senior Technical Consultant

Responsibilities:

• Worked on modifying Audit Trail for BPA lines.
• Worked on Loader Templates Enhancements using OAF.
• Created a custom solution to Archive BPA Revisions.

Confidential, Detroit, MI

Technical Lead

Responsibilities:

• Worked on managing the offshore GDC team that built Extract and load scripts for MDMs and TDMs
• Worked with Onsite PM to estimate RICE list and manage tools like Pulse and NShore to manage actual hours with estimated hours.
• Performed SysAdmin tasks to setup multiple instances.
• Proposed a change to the Platinum instance so that it could leveraged for future OpCo implementations.
• Built a custom solution for local printing without setting up printers in Unix and the Applications.
• Work on multiple BI Publisher (10.1.34.1) Reports using both RTF templates and Adobe templates.
• Tuned a custom Enterprise Asset Management package and modified code for better error handling.
• Customized the standard Asset Number form, receipts form and the Inter-Org Transfer form by creating Forms Personalizations.
• Supported a custom utility written through Unix shell scripts, that handles code migration from lower environments, like DEV, to upper environments, CAT and SIT.
• Managed multi-tier (DEV, CRP, SIT, CAT, PROD) migration of custom objects using Serena Dimensions Migration Utility.
• Modified the Standard OM Order Header Workflow to in corporate a few business validations before the order is booked.

Confidential, San Diego

Responsibilities:

• Working on PO conversion for ASCP phase of the project in R12.1.0.
• Modified a custom PO workflow by adding some business rules.
• Building 3 EDI Interfaces to handle the invoices coming in from vendors and 3PL.
• Working on Updating vendors and Inserting vendor sites for existing vendors by using vendor related APIs.
• Creating a script to load Historical Promotion related information into Demantra for forecasting.

Confidential, San Diego

Responsibilities:

• Responsible for customizing for OM R12 and OPM R12 modules using advanced PL/SQL 10g programming techniques using TOAD and SQL* Navigator. Modified OPM APIs to customize Creating batches, etc.
• Responsible for Phase 2 customization involving OM and Supply chain modules in R11.5.10.
• Modified and tuned a custom Salesorder package that was running extremely slow.
• Tuned the custom ‘Activation Revenue and COGS recognition Report’ so that it ran more effectively and efficiently.

Confidential, Los Angeles

Responsibilities:

• Responsible for porting customizations during the upgrade from R11.0.3 to R12.0.6 in AR, AP, GL, PO, Inv, BOM, Routing, WIP and other modules.
• Created custom packages and procedures that were called from Forms Personlizations.
• Customzied R12 OAF forms using Jdeveloper.
• Created 30 Excel reports in R12.0.6 using BI Publisher (XML Publisher) R12.
• Developed the Purchasing Document, Pack Slip, Invoice Document and the Shipper document using BI Publisher (XML Publisher) R12.
• Rewrote lots of custom R11.0.3 reports in R12.0.6 so that they are MAOC compliant.

Confidential, Dallas

Responsibilities:

• Created a custom process which calls Receivables Autoinvoice and then updates AR tables after the invoices have been loaded.
• Created 2 custom forms, Lien Requirements and Contract Status, in AR to handle business specific functionality.
• Developed pdf format reports using XML Publisher 5.0.
• Created 10 custom reports in AR like the Claim Notification Report, Notification to Owner Report, Over credit limit report. Also modified the existing Aging Report to group differently and the Print Adjustments report.
• Modified the standard Transaction Summary Form so users could print a random set of invoices without a high and a low range. This functionality is not available currently in AR.
• Modified the standard Approve Adjustments form to handle flexfields differently.

Confidential, Los Angeles

Responsibilities:

• Responsible for porting customizations, in multiple modules, during the upgrade from R11i to R12.
• Responsible for converting and updating Items, Item Costs, Item Categories, Item Revisions and Item Notes from Legacy into Oracle 11i INV
• Responsible for converting BOMs and Routings from legacy system into Oracle.
• Developed pdf format reports using XML Publisher 5.0.
• Worked on customizing Payment Collector/Campaign Summary/Detail Reports in Oracle Advanced Collections 11i module.
• Responsible for converting Item Price Lists for multiple Organizations and currencies. This also involved the conversion of secondary Price lists.

Confidential, Los Angeles

Technical Lead

Responsibilities:

• Responsible for converting and updating Items, Item Costs, Item Categories, Item Revisions and Item Notes from Legacy into Oracle 11i INV
• Responsible for converting PO headers, PO lines, PO line locations and PO notes from Legacy into Oracle PO.
• Developed pdf format reports using XML Publisher 5.0.
• Worked on customizing Payment Collector/Campaign Summary/Detail Reports in Oracle Advanced Collections 11i module.
• Responsible for converting Manufacturer Part numbers for items.
• Responsible for converting Item Price Lists for multiple Organizations and currencies.

Confidential, Dallas

Responsibilities:

• Responsible for customizing for OM 11i and OPM 11i modules using advanced PL/SQL 8.1.7 programming techniques using TOAD and SQL* Navigator. Modified OPM APIs to customize Creating batches, etc.
• Developed a custom package that imported and exported data files using the eCommerce Gateway. The package managed order flow for EDI and other Gateways. Also helped client create Ad-hoc reports using Discoverer Release 2 (9.0.2).
• Extensively customized the standard delivery processing in the Shipping section of OM 11i module using PL/SQL 8.1.7.
• Involved in a 10.7 to 11i upgrade for the above modules.
• Responsible for importing all Open invoices into Oracle Receivables 11i from a legacy system by creating custom packages to do the conversion using TOAD and SQL*Navigator.
• Created a custom package to load comments into Oracle Receivables 11i from the legacy system.
• Customized the standard ‘Oracle Payables EDI Outbound Advice’ process in 11i to archive data before the Outbound Advice is built .
• Created a custom package that pulls information from the archived EDI data and creates an output file of all the rejected invoices for the parameters passed.
• Modified the Open Interface Invoices form to make it non-insertable and some fields non-updateable.

Confidential, Dallas

Responsibilities:

• Responsible for converting vendors, sites and contacts from a legacy system into Oracle Payables 11i using SQL*Navigator
• Customized the standard Oracle Invoice Gateway form extensively using Forms 6i. This included modifying the appearance of fields and creating an additional layout to automate the matching of Purchase Orders with invoices.
• Created multiple custom reports using Reports 6i.
• Modified a standard GL form in Oracle Apps 11i.
• Automated the creation of use tax lines for invoices in the Payables interface table.

Confidential

Technical Lead

Responsibilities:

• Responsible for merging data from multiple Operating Units into a new Operating Unit. This includes converting customers and invoices for AR (10.7NCA), vendors for AP (10.7NCA), General Ledger and Assets.
• Developed multiple interface packages to merge data from multiple Operating Units into one Operating Unit.
• Developed custom reports for multiple applications in a multi-org environment.
• Responsible for name change of a custom AR module.
• Developed a form in the custom Order Entry module that enables users to modify data in the interface tables.
• Worked as part of a team that was responsible for converting Oracle modules and custom scripts into a multiorg compliant environment.
• Designed and modified SmartDB templates for multiple scripts so that they could handle data with multiple currencies.
• Designed and modified a custom Matching process so that it was multiorg compliant.
• Designed and developed a custom EFT process that was used by AP to handle payments.
• Actively involved in resolving production support issues.
• Responsible for converting legacy into the existing system. This includes converting customers and invoices for AR, vendors and invoices for AP, General Ledger and Assets.
• Developed multiple interface packages to convert legacy data from external sources.
• Developed custom reports for multiple applications in a multi-org environment.
• Attended siebel for Call Tracking Systems.

Confidential, Dallas

Technical Lead for Oracle Receivables Implementation

Responsibilities:

• Responsible for porting data from numerous sources for companies acquired by client, into Oracle AR 10.7.
• Developed multiple interface programs to convert legacy data from external sources. This included converting customers and their related transactions (invoices, payments, etc.)
• Wrote custom Oracle Financial reports to meet client specifications.
• Developed custom forms for use in custom billing system.
• Partially involved in the design of custom billing system that was interfaced into Oracle AR.
• Attended Oracle General Ledger R11 .
• Developer for Oracle Reports 2.5
• Responsible for creating a large number of custom reports for Oracle Financials in a short period of time in order to meet an aggressive deadline.
• Created reports for custom application specific to client needs.

Confidential, Dallas

Database Administrator/Developer

Responsibilities:

• Responsible for performing Database Administration tasks that included database creation, user setup, starting and maintaining instances and concurrent manager, performance tuning, space management, creating roles and privileges for users and other day to day management issues.
• Actively involved in the design and development of a number of custom applications centered around insurance billing administration applications. These applications were designed using Designer and Developer/2000 tools for Windows95, SQL*Forms 3.0, Unix scripts, SQL*Menu 5.0, SQL*Loader 1.0 and PL/SQL. These applications were also interfaced with Oracle Financials 9.4.2 (GL, AR, AP).
• Ported applications from IBM RS6000 / AIX 3.2.5 to Data General 5700 / DGUX 4.11. This process involved the installation of Oracle (7.1.6.2.0), creating a database, and creating users and their schemas.
• Used server utilities to export and import objects to the corresponding users, as well as moving application code to the newly created NFS and copying the menu application executables.
• Performed the duty of System Administrator for Oracle Financials 9.4.2.
• Actively involved in modifying a customized transport process that involved moving data from OPEN BASIC to the Oracle financials interface tables in AR and GL.
• Coresoft Corporation, Los Angeles
• Performed duties as an instructor in conducting Oracle classes for private institutes.
• Designed the course outline and documented text books for these classes. These classes were conducted on weekends and covered Database design and data modelling, SQL*Plus, PL/SQL, Oracle*Forms 4.5 and Oracle reports 2.5.