SUMMARY:

• Over 20 years of experience as an Oracle ERP Cloud, Oracle EBusiness Suite R12 (EBS) Applications Business and Technical Analyst, Project Manager primarily in the Unix/Windows environment.
• Extensive experience and expertise in the analysis, design and development of several modules in Oracle ERP Cloud, EBS R12 applications and EDI.
• Multiple full software development life cycle implementations, upgrade experience using AIM methodology in various industries.
• Business Requirement gathering, Gap Analysis and documentation (MD50 and MD70).
• Applications configuration and setups.
• Project Management.
• Design and development of Conversions, Interfaces, Reports and Forms.
• Prototyping, CRP, Unit and system testing.
• Production Support.
• Oracle ERP Cloud 19C (11.13.19.07.0 ) SaaS based software.
• Order Management, Shipping, Product Management, Inventory Management, General Accounting, Receivables, Payables.
• ORACLE Applications R12.2.6, 11i , 10.7.0 SC .5 10 SC.
• Application Object Library ( AOL ) and System Administration.
• General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Purchasing (PO), Procure to Pay (P2P), Cash Management (CM), Procurement.
• OM, Shipping Execution, Order to Cash (O2C).
• Inventory, Warehouse Management System (WMS).
• HR, Payroll
• ORACLE Project Management (PA).
• ORACLE E - Commerce Gateway.
• ORACLE Customer Relationship Management (CRM) 11i. Sales, Contracts
• Oracle Enterprise Data Quality (EDQ).
• X12, EDIFACT, XML formats )
• TIBCO (BusinessConnect & BusinessWorks) and Trinary Windows .
• Oracle GEMMS 3.21.12 (Global Enterprise Manufacturing Management System)
• Developer 11g, 10g / 6i / 2000(Forms 6i, 4.5, 3.0, 2.3 & Reports 6i, 2.5, 2.0, 1.1)
• PL/SQL, SQL*Plus, SQL*LOADER, PRO C, PL/SQL Toolkit 4.0.8, UNIX Shell Scripts
• Oracle Discoverer 4i for Administrators, Toad
• Oracle 11g, 10g, 9.2, 8i, Oracle 7.3
• UNIX, Windows NT

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Techno-Functional Analyst

Responsibilities:

• Managed onsite and offshore implementation team.
• Documented requirements documents and coordinated with technical team for development and testing.
• Coordinated with Business, Functional and Technical teams for requirements gathering, SIT and UAT testing, cutover and successful Production implementation.
• Coordinated with implementation team for knowledge transfer and taking ownership of technical components.
• Post production support, bug fixing and enhancements.
• Customers, Suppliers, Items, Purchase Orders and Sales Orders conversions
• Extracted data from Solomon ERP system using MS SQL scripts.
• Cleansed and massaged data and verified data against master data.
• Transferred the extracted data in FBDI template data files.
• Developed / coordinated development of several inbound and outbound integrations with custom systems and 3rd party systems like UPS, FedEx shipping softwares, Salesforce, Omnify using Oracle SOA and data extraction SQL using BI Publisher.
• Integration between Oracle ERP Cloud and custom Lender Outlook systems:
• Created data mappings for Customer, Customer Specific Pricing, Customer Credit Profile, Device Provisioning, AR Invoice, AR Aging, Orders, Order Status, and Shipment Status integrations.
• Created several staging tables and other objects in intermediate database for integrations.
• Worked with multiple teams for development, testing, implementation and resolving issues.
• Integration between Oracle ERP Cloud and UPS, FedEx shipping systems:
• Created data mapping between Oracle Shipping information and UPS, FedEx Shipping Systems.
• Created inbound and outbound data staging tables in intermediate database for integrations.
• Configured FedEx Ship Manager and UPS WorldShip software systems for shipments.
• Developed and modified several BI reports. To name a few:
• Sales Order Acknowledgement Report.
• Open Sales Order Report (Pick Summary Report).
• Packing List.
• AR Invoice Report.
• PO Commitment Report.
• Logged multiple Service Requests (SRs) with Oracle for reporting bugs and patch applications.

Environment: Oracle ERP Cloud 19B (Version. 11.13.19.04.0 ) SaaS based software, Oracle SOA Order Management, Shipping, Product Management, Inventory, General Accounting, ReceivablesPayables.

Confidential, Rancho Cucamonga, CA

Oracle SCM Developer (Consultant)

Responsibilities:

• AP Check Printing: Created 2 new XML templates for Checks that includes MICR fonts.
• Concur program: Modified the program to in corporate execution of the program for all Operating units.
• Forms Personalization: Customized Legal Entity LOV on AR Transactions and AR Transaction Types Forms.

Confidential, Irvine, CA

Sr. Applications Analyst

Responsibilities:

• Provided ongoing support to OBIEE team for data source related to Projects data.
• Fixed bugs with custom ID (Improvement District) Split program and deployed the change to Oracle Application Framework (OAF) HTML page in Production.
• Interfaces to Empower Retirement System:
• Designed and developed outbound interface that fetches all the deferred compensation elements for employees and updates the information in the Empower system.
• Designed and developed inbound interface that updates payroll element entry values based on update made by employees to their deferred compensation contributions on Empower site.
• Interfaces to Occupational Health & Safety (OHM) Software System:
• IRWD maintains information on OHM of all the employees, safety trainings and certifications that they have taken and need. Designed and developed outbound interfaces that transfer all the employee relevant data and master data like Company, Locations, Departments, Jobs etc.
• Updated Purchase Orders from 2-Way to 3-Way and vice versa
• Processed stuck Work Confirmations, Cancelled Work Confirmations.
• Designed and developed outbound Supplier and Inventory Items interfaces to Maximo system.
• Created a Forms Personalization on Material Transactions Form to auto-generate GL Code string based on entered process code.

Confidential, Irvine, CA

Technical Project Manager (Consultant)

Responsibilities:

• Managed resources and implementation of Oracle Warehouse Management System (WMS) module for multiple Mazda warehouses.
• Created project schedules and facilitated completion of tasks as per schedule.
• Created and tracked issue logs and facilitated closure of issues.
• Created status reports for management.

Confidential, Tustin, CA

MDM Manager (Consultant)

Responsibilities:

• Analyzing and improving data quality.
• Establishment of policies, and continuous monitoring of their proper implementation.
• Documentation of cleansing rules.
• Cleansing of data using Oracle Enterprise Data Quality (EDQ).
• Monitoring the cleansed data and manually cleansed data that EDQ failed to cleanse.
• Interface with Oracle EBS team for conversion of cleansed Supplier, Customer and Items (Product Data Hub / PDH) data.
• Testing, validation and reconciliation of converted data in Oracle EBS using HP ALPM.

Confidential, Irvine, CA

Business Analyst

Responsibilities:

• AR Invoice upload/Conversion, AP Invoice upload/Conversion, PO Conversion:
• Designed upload templates for data conversion of source system data and created mapping between source system data and respective Oracle interface tables.
• Documented functional design documents.
• Created upload test data files and provided to development team for testing.
• Setup of new AR Batch Source and AR Transaction Types for multiple operating units.
• AR Receipt upload mapping:
• Designed AR Receipt upload template for data conversion of source system data and created mapping between source system data and Oracle AR Autolockbox interface tables.
• Documented functional design document.
• Customer Conversion:
• Mapped source system Customer data to Oracle Customer Import template.
• Manually created test data file and complete Customer data file from source system data in the designed Customer Import template format.
• Validated converted Customer data in Oracle test instance and provided feedback to development team for corrections.
• Customer extract: Created SQL scripts to extract (i) Customer, Account and contact details data and (ii) Customer account sites and Site contact details data from Oracle.
• PO data extract: Created SQL script to extract PO Conversion data from Oracle
• Designed and setup Chart of Accounts and Organization structure for organizations of newly acquired company.
• Tested possibility of use of alphanumeric values for Company and Account segments to extend available range of values.
• Scheduled meetings with source system team and performed Cash Management Requirements gathering for desired functionalities and Integration needs and performed gap analysis.
• Performed walk through of Oracle Cash Management module’s capability to source system team.
• Auto-reconciliation process: Setup bank account transaction codes, Journal Entry mapping and demonstrated Oracle Cash Management’s Auto-reconciliation process from uploading Bank’s BAI file to automatic creation and posting of Journal Entries and auto-reconciliation of the JEs to bank statement lines.
• Logged a Service Request with Oracle Support for Cashflow transaction creation issue and followed up with application of patches.
• Set up Bank accounts, bank file transaction codes, Journal Entry mapping/rules.
• Setup multiple cash management users and assigned responsibilities to them in Oracle.
• Setup meetings with business users and technical team.
• Documenting meeting notes.
• Maintenance of project documents and meeting minutes on SharePoint.

Confidential, Irvine, CA

IT Specialist

Responsibilities:

• AP Invoice Approval Workflow customization:
• Documented requirements document.
• Facilitated Implementation of the customization.
• Tested the customization, created detailed test results document.
• Performed Order Purge in Production.
• Managed onsite and offshore support teams.
• Worked on assigned tickets, assigned tickets to team and resolved tickets within SLA timeframes.
• Monitored open tickets and provided status to business.
• Scheduled meetings and Created status reports.
• Coordinated efforts with other IT teams when needed.
• Supported month end close for all month ends.
• Created project schedules / Work Breakdown Structure (WBS) for the project and facilitated completion of tasks as per schedule.
• Scheduled and attended meetings involving functional, technical and business teams.
• Created status reports and meeting minutes.
• Created and tracked issue logs and facilitated closure of issues.
• Facilitated execution of conversions, interfaces, implementation, testing etc. in different instances.
• Provided on-going project support.

Confidential, Irvine, CA

Technical Oracle Analyst

Responsibilities:

• Data is extracted from 11i system using DB link and loaded in staging tables in R12. In some cases data is uploaded from data files using SQL*Loader or External Tables. The staging table data is then validated using custom PL/SQL programs and then imported in Oracle using Oracle Standard Import programs or APIs.
• Designed and developed following conversions and documented Technical Design documents:
• Supplier Conversion and Employee Supplier Conversion
• Approved Suppliers List (ASL) Conversion
• Bank, Branches and Accounts conversion and associating the accounts to Supplier Sites
• Purchase Order Conversion.
• Concur travel and expense interface: Designed and developed inbound and outbound interfaces between Oracle EBS R12 and Concur travel and expense management solutions system.
• Created data extract scripts as per Concur format specifications that generate Employee and assignment data, Credit Card data, Expense Account list data as outbound data from Oracle to Concur. Data files are first encrypted using PGP encryption and then transferred using secure FTP.
• Inbound Expense Reports data file from Concur to Oracle is first pulled using secure FTP and then decrypted using PGP. Data is then uploaded in staging table from the data file using SQL*Loader. A custom PL/SQL program validates data and transfers data to either AP interface or GL interface which is then interfaced to Oracle EBS using standard Oracle import programs.
• Documented Technical Design documents for interfaces.
• Designed and developed several Reports using Oracle Reports, XML and XML templates including (i) Delivery Note Report, (ii) Packing Slip Report, (iii) Pick Slip Report

Confidential, Carlsbad, CA

Senior Oracle EBS Applications Technical Analyst

Responsibilities:

• Designed and developed a custom extension that releases single or multiple prescriptions to create order lines and/or order header.
• The extension creates one order line for each Rx passed in a collection and creates an order if one does not already exist. It is one of the most important programs and a critical central piece of the system.
• Data conversion from legacy & external systems:
• Designed complete data conversion strategy.
• Over 35 files are extracted from legacy system
• Data is loaded in staging1 tables using SQL*Loader
• Data is cleansed by PL/SQL procedures and validated data is transferred to staging2 tables
• Data from staging2 tables is loaded into the custom interface tables using custom PL/SQL procedures.
• Data from the custom interface tables will be imported into R12 base tables using standard Oracle import programs or Oracle standard APIs.
• Documented legacy system to EBS data mappings.
• Designed Data Cleansing Procedures and provided pseudo code.
• Provided good error handling and conversion history tracking design.
• Testing & Quality control using Mercury Quality Center (MQC):
• Completed development of Test Scenarios & Test Scripts for Mock Conversion.
• Participated in multiple mock conversions and wrote test SQLs for data correctness and reconciliation.
• Logged test results and defects in MQC, uploaded test labs and test scripts to MQC.

Confidential, Irvine, CA

Senior Oracle EBS Applications Analyst

Responsibilities:

• Designed, developed and implemented a complex Pick Confirm Interface
• Developed EDI 810 and EDI 850 interfaces using Oracle E-Commerce Gateway.

Confidential, Irvine, CA

Senior Oracle EBS Applications Analyst

Responsibilities:

• Developed multiple inbound and outbound EDI projects using TIBCO BusinessWorks Designer (ver. 5.1.3.44)
• Setup Protocols, Trading Partners and Transactions using TIBCO BusinessConnect (ver. 3.5.12).
• Worked with EDI file formats: X12, EDIFACT and XML
• Developed multiple inbound and outbound EDI jobs using Trinary EDI Windows software (ver. 5.3). Setup Trading Partners, defined jobs, scheduling of jobs, data mapping between EDI and flat file formats.
• EDI Support and maintenance
• Oracle Applications 11i activities:
• Documented functional designs
• Developed, tested and implemented Item Cross Reference conversion, EDI 850 (PO) interface

Confidential, Carlsbad, CA

Senior Oracle EBS Applications Analyst

Responsibilities:

• Developed several Reports using Oracle Reports 6i :
• Developed following Conversions and Interfaces :