OBJECTIVE:

Senior Oracle Applications Developer / Analyst / Architect with 20+ years of thorough and extensive experience in Oracle 10.7/11i/r12 ERP Manufacturing Supply Chain, Financials and CRM modules. Expert in utilizing technical, functional and project management skills in the management, specification, design, development, customization, and troubleshooting of Oracle Applications including interfaces, conversions, enhancements, upgrades and new implementations. Extensive experience working in PL/SQL (cursors, functions, triggers, procedures, packages etc.), Forms/Reports 6i - 12c, BI Publisher, JSP, OAF, ADF, Workflow, Oracle Fusion, Java, XML, SOA, Unix/Linux etc. and also experienced in project management (Estimation, Planning, Execution and Close-down.), creation of detailed technical documents and business communications.

SUMMARY:

• 20+ years extensive full lifecycle technical/ functional experience in all areas of Oracle Application development.
• Extensive technical experience in Oracle ERP covering Manufacturing, Supply Chain, Financials, CRM modules, such as Oracle 11i/r12 Inventory, Install Base, Engineering, Order Management (OM), Purchasing (PO), Bill of Materials (BOM), Work In Process (WIP), Projects, Advance Pricing, Oracle Quality, GL, AR, AP, Oracle TCA/CRM Foundation, Sales Online, Field Service and Support, Oracle Universal Queue, Enterprise Budgeting and Planning, iProcurement, Oracle Sys Admin 11i/r12, CE, Oracle Financial Analyzer OFA, Oracle Energy, XML Gateway, Oracle XDB, Oracle Custom HR Application and Web Development, with expertise in project management (Estimation, Planning, Execution and Close-down.)
• Gained knowledge of Oracle Fusion cloud, File Based Data Import (FBDI) for Suppliers, Customers, Supplier Bank Accounts, Project and AR Auto Invoice Import, creating BIP and OTBI reports, Fusion ESS Jobs (Enterprise Scheduler Jobs), Concurrent request sets, Dependent LOVs, Report triggers, Value Sets, personalization, dashboards, cloud/fusion security roles and cloud’s Automate Data Import Process (ADFDI).
• Hands-on experience in developing interfaces, conversions, customizations, implementations, enhancements, upgrades and troubleshooting of Oracle Applications using skills in PL/SQL (cursors, functions, triggers, procedures, packages etc.), oracle reports (including XML (BI) Publisher), oracle forms, JSP, OAF, Personalization, Workflow, Java, XML.
• Also participated in development projects that included utilization of newer technologies such Java 9, SOA, and ADF.
• Resolved complex integration problems, and obtained experience in analyzing requirements and writing functional, technical, and design specifications.
• Excellent analytical, problem solving, and troubleshooting skills.
• Proficient at planning, strategy, risk mitigation, execution and delivery. Ability to multi-task and detailed oriented.
• Proficient in communications, conflicts resolution, budgeting, cutting costs, providing workable strategies, coaching, carrying out scope, quality and risk management.

TECHNICAL SKILLS:

Oracle 8i/9i/10g/11g/r12, ERP 11i/r12 Manufacturing Supply Chain SCM Financials E-Business Suite, PL/SQL (cursors, functions, triggers, procedures, packages etc.), Forms/Reports 6i/9i, JSP, OAF, CUSTOM.pll, Oracle Workflow 2.5/2.6, Oracle Alerts,, Designer/Developer 6i/9i/10g, JDeveloper 9i, AK Developer, Discoverer 3.1/4.0, UNIX, Linux, PERL, HTML, Java, Java, Python, Oracle Express (APEX), SOA, ADF, C/C++/Pro*C, CGI Script, XML.

FUNCTIONAL SKILLS:

• Delivered solution for functional/technical production issues. Provided Oracle Applications configuration & design documents. Created test cases and handled testing of various oracle projects.
• Coordinated and/or performed testing of Oracle Applications patches, upgrades and modifications.
• Initiated and managed Oracle support TAR requests.
• Analyzed, designed and documented 11i/r12 customizations and interfaces, creation and registration of custom executables, applications, menus, and responsibilities.
• Helped in month end and year-end closing activities.
• Handled oracle standard applications diagnostic tools.
• Managed weekly meetings with Developers, QA and End Users to discuss Open Projects.
• Worked with different EDI File Layouts for Lockbox, invoices, PO and other interfaces.

EXPERIENCE:

Senior Oracle Consultant

Confidential

Responsibilities:

• Participated in completely revamping and enhancing of accounts receivables interface system that linked oracle financials with the boundary systems. This customization provided clients the ability to monitor and control receivables from boundary systems using Oracle Receivables.
• Converted Oracle EBS BIP reports to oracle fusion OTBI and OBIEE reports.
• Worked with Oracle Fusion file based data import templates (FBDI) that are used in loading AR Invoices, Suppliers, Supplier Bank Accounts, Project and Project Billing Transactions.
• Started the project to integrate Oracle PO Approval workflow with mobile notifications using oracle REST APIs.

Senior Oracle Developer

Confidential

Responsibilities:

• Handled conversion of CRM legacy data into Oracle EBS.
• This work involved implementation, integration and enhancement of Oracle Channel Revenue Management (CRM) module. Also worked with Install Base, OM modules and APEX.

Oracle Applications Developer

Confidential

Responsibilities:

• Build, designed, developed and implemented several in-house real-time interfaces that linked Oracle Manufacturing/SCM Supply Chain Modules with other outside systems. These interfaces are being currently used to process hundreds of millions of dollars of inventory, PO, OM, WIP production transactions.
• Handled design, development, testing and implementation of in-house batch and real-time interfaces to import Bank Transactions, GL, AP and AR related data into Oracle Financials such as Cash Management, Oracle Receivable, Oracle Payables and Oracle GL modules using combination of complex custom PL/SQL codes, Bank Transaction import APIs, Auto lockbox, AP, GL, AR (Auto Invoice) import seeded programs. These interfaces are now handling hundreds of millions of dollars of revenue and expense transactions.
• Participated in full life cycle Oracle implementations in more than 20 business units throughout the globe, handling multi-org, multi-language, cross operating units complexities.
• Worked in Oracle Projects on the development, customization and implementation of PA Account Generator Workflows, Personalizations, OAF modifications, Reports and Configurations.
• Gained hands-on experience in working with numerous programs for conversions, customizations, personalizations, enhancements and upgrades of Oracle Financials/SCM Applications, and wrote and modified numerous reports and forms using Oracle reports/forms 6-12c, BI Publisher, PL/SQL, XML/XSL, OAF, Java technologies.
• Developed Dashboards in Apex to monitor status of records in staging and interface tables.
• Design and developed PLSQL scripts to extract data for in-house data-warehouse system from almost all implemented modules of Oracle Supply Chain (INV, PO, BOM, WIP, PO, ONT, PA etc.) and Oracle financials (GL, AR, AP, CE, eBTax etc.)
• Design and developed PLSQL scripts to extract data from almost all implemented modules of Oracle Manufacturing (INV, PO, BOM, WIP, PO, ONT, PA etc.) and Oracle financials (GL, AR, AP, CE, eBTax etc.)
• Wrote and customized conversion codes for validation and import of Customers, Suppliers, Project, Items, Item Category, Item Costs, Bill of Material, Routing, On-hand Material, Work Orders (WIP), Open Sales Orders, Bank Accounts, Open Invoices and Receipts, GL Balances, Financial Reports, Open PO, Projects, Pricelists and Quality, Taxes, Vertex, Lockbox, Auto-Invoice etc.
• Gained knowledge of SOA, Web services, Business Events, OAF, ADF and Oracle Fusion Applications by working on move/upgrade/modify existing forms/reports/interfaces.
• Also worked on creating Data Extractions scripts for iSupplier module.
• Studied Oracle Fusion cloud conversion process using File Based Data Import (FBDI) for Suppliers, Customers, Supplier Bank Accounts, Project and AR Auto Invoice Import. Gained experience in creating BIP and OTBI reports, Fusion ESS Jobs (Enterprise Scheduler Jobs), Concurrent request sets, Dependent LOVs, Report triggers, Value Sets, personalization, dashboards, cloud/fusion security roles and working with Oracle Integration Cloud Service (ICS) to integrate SaaS applications. Got training in cloud’s Automate Data Import Process (ADFDI) and modification of Excel and System Settings for ADFDI.

Application Architect/Sr. System Analyst

Confidential

Responsibilities:

• Designed, created, modified and customized Accounts Payables and Accounts Receivables System for Mexico Subsidiary using PL/SQL, Forms and Reports that resulted in savings/revenue of several thousand dollars to the company.
• Worked on several projects/enhancements in oracle financials ERP/CRM, especially in GL, AR, AP, CRM Foundation, Sales Online and Service modules.
• Worked on Developing Custom Reports to show detailed list of Salesreps revenue volume.
• Created a conversion program to load the supplier invoices into Oracle Payables and developed a validated program to check for paid, unpaid and on-hold invoices
• Customized and developed transactional reports for various transactions like Invoices, Receipts, Credit Memos and Debit Memos. Developed interface program to load Oracle AP Invoices into Oracle AR with automated calculations of vat of other taxes and admin fees.
• Worked on developing Technical Documentation and Code Review documentation before and after the testing.
• Researched and gained knowledge in E-Business Suite Release 12 for GL, AP, AR, Sales Online and Service modules.
• Worked on developing XML interface using oracle XML Gateway and XDB between outside vendors and Oracle Accounts Payable.

Oracle Consultant/Supervisor

Confidential

Responsibilities:

• As technical lead managed and spearheaded several projects/enhancements in oracle financials ERP/CRM, especially in GL, AR, AP and Sales Online modules. These projects brought savings of several hundred thousand dollars to the company.
• Supervised/handled test deployment of Enterprise Budgeting and Planning (EPB) module at UWA.
• Handle complete implementation (from start to finish) of multi-org system in oracle financials, which resulted in better accounting of transactions and savings of several FTEs.

Application Developer / Analyst

Confidential

Responsibilities:

• As technical lead developed the invoice payments control project to regulate payments to different vendors (total amount of payments exceeds 50 million dollars). This project brought savings between several hundred thousand to one million dollars to the company.
• Participated in completely revamping and enhancing the accounts payables interface system that linked oracle financials with the legacy applications. This customization provided users with a new online and real-time monitoring and control capability, which resulted in better customer service and savings in FTEs.
• Spearheaded the integration, customization, and upgrade from in-house web requisitioning system to Oracle iProcurement, which now handles approximately several million dollars in transactions every month.
• Co-presented technical paper on "iProcurement Implementation" at 2004 OAUG (Oracle Application Users Group) Conference in Orlando Florida.
• Selected for Leadership and Management Program. This rigorous two year corporate training program is designed to identify and develop individual talents for personal development and leadership in the organization.

Senior Consultant

Confidential, Houston, Texas

Responsibilities:

• While doing consulting for Conoco revamped and redesigned the entire Interface system between Tobin Application (Leasing) and Oracle Energy Application (Revenue module), in a very short period of time. Due to this work Conoco was able to realize savings of millions of dollars concerning their oil and gas operations.
• Configured and customized Oracle Energy Application (gas production module) for Kuwait Government's National Oil Company to accurately calculate the capacity for their millions of metric tons of oil and gas reservoirs (storage tanks).