SUMMARY:

• 20 years of experience in analysis, design, development and deployment of applications with Oracle RDBMS and development tools. Concentration on implementation of Oracle E - Business Application suite for large organizations as a senior level technical consultant/developer with functional knowledge. Assumed leadership roles at times. Solid conceptual background in business aspects of ERP systems as well. Extensive experience in datawarehousing and business intelligence in ERP environment as well. Excellent communication skills to interface with all levels of an organization.

TECHNICAL SKILLS:

ERP Systems: Oracle Applications (E-Business Suite) (R12.1.3)

Modules: Accounts Receivables, General Ledger, Accounts Payables, Fixed Assets, Supply Chain, Purchasing/Procurement, Order Management, Advanced Pricing, Bill of Materials, MRP, Inventory, Project Accounting, Installed Base, Work in Process, Process Manufacturing, Cost Management, SLA, Human Resources, Workflow, OTA, iExpense, Cash Management, Grants Accounting

Impresa ERP/MRO/Service Applications: (Version 7i5)

Data Base Systems: Oracle RDBMS

Database Devl. Tools: Oracle Reports, Oracle Forms, JDeveloper/OAF

OLAP/Reporting Tools: Business Objects (Webintelligence, Broadcast Agent), Discoverer, Polaris

Programming Languages: PLSQL, SQL*Plus, SQL*Loader, Pro*C, Unix Shell Scripting

ETL Tools: DataStage

Operating Systems: Unix, Windows

Project Management: Primavera, Microsoft Project

PROFESSIONAL EXPERIENCE:

Oracle EBS Tech.Consultant

Confidential, Bellevue, WA

Responsibilities:

• Worked on a project to redesign daily and monthly processes for interfacing orders into AR and invoicing in a more efficient manner to be able to accommodate huge volumes (millions of orders monthly) in a constantly changing business environment. Building a custom Pre-Invoicing module for scalability and efficiency. Also built a complex Oracle Forms module for custom interface error correction UI.
• Completed a project to automate “Direct Debit” payment processing for multiple countries and currencies. Built exception reports for automated process and notifications in case of errors.
• Worked on enhancing and automating a process to update customer related data in OM as well as AR Interface based on manual customer/TCA data updates taking place.
• Developed interfaces to correlate booking related business events from multiple sources and deliver automatically to the General Ledger with no manual intervention utilizing PLSQL and the standard Oracle FAH (Financial Accounting Hub) Create Event API.
• Developed a custom purging and archiving process for Order data to be able to efficiently process millions of orders monthly in a multithreaded fashion with dynamic parameters for parallelism.
• Maintained an Oracle Forms module as well as PLSQL procedure accessed via external Web Services to query status of reservations from AR standpoint.

Oracle EBS Tech.Consultant

Confidential, Redmond, WA

Responsibilities:

• Developed a custom process utilizing OM API Process Order to book orders in batches interfaced from external systems. Developed highly complicated and business critical Order Validation process involving allocation, pricing and quantity checks initiated from Oracle forms (utilizing custom.pll) or in batch mode.
• Designed and developed a very complex process to track and manage licensing “rebates” including developing and digitally distributing reports to designated receivers utilizing XML Publisher
• Developed a custom process to extract and send EDI-810 invoices to multiple systems utilizing Web Services and OSB calls triggered via business event subscriptions to Autoinvoice runs.
• Maintained a custom process to receive remittance file from banks (in EDI-820 format) and interface them into Oracle EBS for cash applications through Auto-Lockbox.
• Developed custom processes to perform “mass ship confirm” and “mass backorder orders” automatically for batches of orders utilizing Oracle APIs.
• Developed a number of WEB-ADI interfaces to load Excel based data received from major freight carriers into Oracle EBS.
• Customized GL account generation process in Channel Revenue Management Workflow
• Fixed multiple performance issues on various business critical processes and reports bringing processing times from hours to seconds to make those processes feasible for business.
• Acted as the main technical point of contact in SIT testing phase assessing and dispatching issues as encountered.

Oracle EBS Tech.Consultant

Confidential, Seattle, WA

Responsibilities:

• Developed a custom Employee interface with a third party system utilizing HR APIs. The custom program built supported functionality to create/update/terminate/rehire employees. The program also automatically created/updated/enddated FND users tied to the employee record.
• Developed and maintained multiple interfaces to support mass updates to Fixed Assets utilizing various APIs (Adjustment, Update Desc, Unplanned Depreciation, Deprn. Override)
• Developed custom AP check print process utilizing BI (XML) Publisher which supported multiple format templates as required by international banking locations of the company.
• Developed a process for mass update of employee health plans for 2013 in a third party health management system.

Oracle EBS Tech.Consultant

Confidential, Seattle, WA

Responsibilities:

• Designed and developed a custom Discoverer EUL from scratch for building custom reports in Order Management, Inventory, Cost Management, GL and AP for operational and financial teams. Also built a custom report for detailed analysis of Order Cancellations.
• Developed custom reports in Subledger Accounting (SLA) also building an SLA extract for Hyperion. Also worked on designing and building custom reports for historical Inventory Valuation, PPV analysis, Customer Review, AR Details utilizing BI Publisher. Worked on modification of standard BOM reports adding images and assembly drawings.
• Created a custom process to update AP interface to populate terms for vendors while uploading files from WellsFargo bank.
• Provided custom analytical reports and calculations for sales commissions (to provide pending commissions info on open sales orders)

Oracle Apps Developer/Tech.Consultant

Confidential, Seattle, WA

Responsibilities:

• Designed and developed a custom program in Oracle Projects/Receivables Modules to automate straightline revenue generation process utilizing Oracle Projects APIs and flexfields
• Developed a custom program for projected “Percent of Complete” calculations on active projects based on forecasts and actual hours and revenue recognized
• Developed a custom application (concurrent program and Workflows) to assign team members to Projects automatically based on rules defined through a custom Oracle Form developed.
• Built various programs to facilitate project setup process along with a custom program to change a project type (FP vs. TM) on demand.
• Automated inbound and outbound HR interfaces from an external onboarding system utilizing Oracle HR APIs.
• Designed an application to interface to an external financial system by building mappings of GL Accounts based on rules maintained through custom Forms and providing extracts based on that.
• Maintaining a process to generate Consolidated Invoices and building various consolidated invoice reports utilizing BI Publisher.
• Providing technical support to existing reporting applications utilizing Discoverer and Oracle Reports. Also upgrading custom reporting applications into version R12

Oracle Apps Developer/Tech.Consultant

Confidential, Seattle, WA

Responsibilities:

• Designed and developed a very complex interface between Oracle Receivables/Credit Management Module and Experian Credit Bureau for automated credit checks of customers. Project involved sending encrypted XML requests and parsing XML responses satisfying the complex security requirements of Experian. This has been the very first interface ever built from Oracle Apps into Experian and received an from the client upon project completion.
• Worked on building and maintaining an Excel based user interface to import/export data into/from Oracle Projects module.
• Worked on a project to upgrade Oracle Discoverer based reporting system into version 10g, also providing technical support to maintain EUL with 200+ Discoverer reports.
• Provided technical support to existing reporting applications with focus into PA, iExpense, GL, HR, AP, Purchasing modules as well as supporting data feed process into datawarehouse.
• Provided technical support for an interface into PA module to bring event data from external systems and create draft invoices in Oracle Apps through custom processes.

11i Developer/Tech.Consultant

Confidential, Austin, TX

Responsibilities:

• Worked on a project to merge and deploy 3 separate instances of Oracle Applications into single global instance while migrating the Oracle Applications business suite from version 11.0.3 to 11.5.10 with modules of AP, AR, GL, FA, PA. Working in the reporting team upgrading 200+ RICE components primarily in Oracle Reports and PLSQL procedures/packages.
• Responsible for preparing technical design documents (MD570/571) from functional specifications (MD050) and upgrading the components using Oracle development tools and troubleshooting any upgrade issues and defects identified. Assumed leadership role at times to mentor junior resources in the team.

Developer/Tech.Consultant

Confidential, Livermore, CA

Responsibilities:

• Worked on a government project to deploy an Oracle Discoverer 10g based reporting system migrated from Business Objects based on Oracle Applications 11i (11.5.10) transactional data residing on Oracle 10g database. Developing various Discoverer (10g) reports and maintaining Oracle Applications EULs in the areas of PA, GL, AP, AR as well as custom financial applications on sponsor funding and a data warehouse.

Technical Consultant

Confidential, Santa Clara, CA

Responsibilities:

• Working on a project as a techno-functional resource to migrate applications with sensitive Federal government related data into a secure Oracle Applications 11i (version 11.5.10) platform from legacy system 10.7 as well as brand new implementation of Order Management/Advance Pricing, Service Delivery, Service Contracts and Installed Base modules of 11i in Oracle RDBMS 10g environment. Providing technical support in all those environments.

Technical Consultant

Confidential

Responsibilities:

• Building a custom form and an interface (package procedure) to transfer labor costs into Oracle Projects utilizing Transaction Import open interface.
• Developing 20+ custom reports (using Oracle Reports and Discoverer) for analysis of project costs (budget vs. actual) at the summary and task level by resources including detailed material and labor usage by timeline.
• Building a custom application (concurrent program based on a stored procedure) for inventory aging calculations by bulk processing relevant material transactions over time.

Technical Specialist

Confidential, Seattle WA

Responsibilities:

• Worked on the implementation of OM (Order Management) of Oracle Applications 11i. Designed and developed interfaces between OM and Manugistics forecasting and planning applications. Also developed custom reports using Oracle Reports and Discoverer.
• Worked as the main technical resource responsible for implementation of Advanced Pricing module. Created various custom extensions (Pricing Extensions) to apply complex pricing algorithms. Created custom procedures making calls to the Pricing Engine to use in complex reporting and providing extracts of pricing data to data-warehouse. Also supported the Workflow development team for creating backend PLSQL procedures.
• Worked as the designer/developer on a project developing a Transportation system as an extension and customization of Oracle Supply Chain and Procurement modules. Designed and developed interfaces to Procurement, OPM, Inventory modules.
• Worked on the project to upgrade Oracle Suite of Applications modules to version 11.5.9. Also supported OPM (Oracle Process Manufacturing) module for changes and maintenance.

Technical Consultant

Confidential, Seattle WA

Responsibilities:

• Customizing a major interface utilizing API between Oracle Apps 11i and a 3rd party Inventory Management system to accommodate FG Inventory transfer/shipping/receiving procedures for an international plant based in Netherlands.
• Developing 20+ custom reports in the functional areas of Process Manufacturing, Cost Management, Inventory and Procurement using Oracle Forms and stored procedures. Modifying standard Oracle Applications forms in Process Manufacturing to enhance functionality,
• Creating daily automated database processes to capture Inventory data to be used in Inventory Turn calculations developing PLSQL packages and batch processes,
• Creating Unix Shell script applications to process data files from/to Manugistics applications to integrate with Oracle Applications 11i.

Architect/Technical Lead

Confidential, Bellevue, WA

Responsibilities:

• Designing the overall hardware and software system architecture to support the enterprise database fed by multiple data sources and presented through multiple front end tools, Coordinating the deployment of hardware and software for the front end tools per the system architecture
• Working with the back-end ETL team for mapping source system data into the business dimensional model (BDM), Making recommendations for changes on the BDM and the physical data model,
• Working with analysts defining technical specs for OLAP Cubes, ad-hoc BO universes, custom reports, designing aggregate tables for performance tuning.

Senior Analyst/Developer

Confidential, Bellevue, WA

Responsibilities:

• Designing and developing “Universes” in Business Objects 5.x OLAP tool running against the “Reporting Database” built and assisting functional users and analysts to build ad-hoc reports using Business Objects.
• Handling promotion of universes into production and setting up users and privileges as the Supervisor.
• Tuning and optimizing queries and applications.
• Developing data extracts to feed other third party applications and department specific data marts using Oracle development tools PLSQL, stored procedures and Unix shell scripts.

Technical Consultant/Development Lead

Confidential, Bothell, WA

Responsibilities:

• Converting Customers data using Oracle Customer Open Interface developing a program to merge customers automatically,
• Conversion of customer transactions and AR balances using AutoInvoice Open Interface,
• Designing and implementing a major modification in the Invoice Consolidation process in AR module. Developing a major custom interface between OTA and AR modules utilizing db packages and PLSQL
• Developing a custom interface between Oracle and a third party Sales Management and Commissions Application.
• Developing custom PLSQL stored procedures to periodically generate a number of data files from PO and OE modules to be used for GL month end closing processes,
• Modifying various Oracle's standard reports including Invoice Print processes, Sales Order Acknowledgement Report and coordinating those modifications with “Optio” team for bit-map output formatting. Developing around 30 different business views and Oracle Reports to present summary data to the Crystal report users.

Technical Consultant/Lead

Confidential, Everett, WA

Responsibilities:

• Performing data migration of PO, Inventory, WIP from the legacy system and Accounts Receivables from Oracle suite of Applications Version 10.7,
• Performing various enhancements in the processes of order entry, shipping, purchasing, inventory tracking, WO releasing and component picking,
• Designing and developing a Re-Order point planning process,
• Integrating a third party shipment software with Impresa, developing a serial number tracking system,
• Building a custom WO staging history system including data modeling and coding,
• Designing and developing a system to issue material to shortage work orders during receiving,
• Enhancing major reports including Pack-slip, Invoice, PO Print, WO Print, Parts Usage List, Pick-list and building new reports and inquiry forms needed for business.

Technical Consultant/Lead

Confidential, Orlando FL

Responsibilities:

• Developing a customized “Time & Attendance” system and integrating with the Oracle Payroll Module including the design and data modeling,
• Implementing various cost re-classification processes in GL, customizing and interfacing periodic WIP variance and excess inventory figures with General Ledger, also generating a process to book value of material in MRB in reserve accounts,
• Developing processes for unit hour calculations, scrap analysis, assembly line balancing, analysis of manufacturing overhead and profit & loss,
• Generating bar-coded pack-slips, customizing sales picking process, developing various sales analysis programs and reports, integrating FSG (Financial Statement Generator) with custom Oracle reports,
• Generating cross functional custom “Views” for users’ data requirements and developing a security system to restrict access to those views based on the functional area and the applicable organization of the user,
• Modifying various standard reports in Oracle Applications, designing and developing various custom reports and inquiry forms using Oracle Reports and Oracle Forms to meet the customer specific requirements for their business.

Technical Consultant

Confidential, Austin Texas

Responsibilities:

• Completed a technology upgrade project, converting Forms 3.0 based custom programs to Oracle Applications v10.7 NCA for Confidential Company. Utilized Oracle Developer 2000 (version 1.6) to deliver web enabled, customized and fully integrated Time & Attendance and Financials applications to Oracle Suite of Applications.

Technical Consultant

Confidential, Houston, TX

Responsibilities:

• Worked as a team leader, analyst/programmer to perform requirement analysis, design and generate custom reports, forms and interfaces in manufacturing and financial modules of Oracle based ERP system JIT v3.0 on Unix in a multi-org company producing hi-tech medical equipment using Oracle Forms4.5, Reports2.5 and PLSQL. Modified the standard JIT code extensively to meet customer’s requirements in the areas of consignment inventory tracking, handling foreign exchanges as well as developing over 50 custom Oracle reports.

Technical Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Performed requirement analysis, designed and generated custom reports, forms and interfaces in manufacturing and financial modules of Oracle based ERP system JIT v4.0 on Unix using Oracle Forms4.5, Reports2.5 and PLSQL. Developed a summary level data pool for DSS purposes. Designed and generated more than 100 custom reports for business needs.

Analyst/Programmer

Confidential, Salt Lake City, UT

Responsibilities:

• Performed requirement analysis, designed and generated custom reports, forms and interfaces in manufacturing and financial modules of Oracle based ERP system JIT v3.0 on Unix. Major work done included developing a serial number tracking system, modifying PO Print process using Oracle Forms4.5, Report2.5 and PLSQL.

Analyst/Programmer

Confidential, Washington D.C

Responsibilities:

• Designed and developed EDI interfaces to JIT v2.7 system on Unix in Purchasing and Order Entry areas using Oracle Developer2000 and PLSQL.

Analyst/Programmer

Confidential, Orlando, FL

Responsibilities:

• Perform requirement analysis, designed and generated customized reports, forms and interfaces in manufacturing and financial modules of Oracle based ERP system JIT v3.0 on Unix using Oracle Forms4.0, Reports2.0 and PLSQL. Responsible for developing a bar-coded WIP tracking system, building an engineering change request tracking system and modifying and developing various programs and reports for business needs.