SUMMARY:

• Over 20 years of experience as an Oracle EBusiness Suite (EBS) Applications Technical and Business Analyst, primarily in the Unix/Windows environment.
• Extensive experience and expertise in the analysis, design and development of several modules in Oracle ERP applications (EBS) 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 Applications R12.2.6, 11i , 10.7.0 SC161 / 10.5 10 SC.
• Application Object Library ( AOL ) and System Administration.
• ORACLE FINANCIALS: General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Purchasing (PO), Procure to Pay (P2P), Cash Management (CM), Procurement.
• ORACLE Order Management: OM, Shipping Execution, Order to Cash (O2C).
• ORACLE Supply Chain Management: Inventory, Warehouse Management System (WMS).
• ORACLE Human Resources : HR, Payroll
• ORACLE Project Management (PA).
• ORACLE E - Commerce Gateway.
• ORACLE Customer Relationship Management (CRM) 11i. Sales, Contracts
• Master Data Management (MDM): Oracle Enterprise Data Quality (EDQ).
• Electronic Data Interchange (EDI : 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

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.
• HRMS, Payroll:
• 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.
• Changed AR Transaction Numbering to Gapless by updating the sequence from default 20 sequence numbers cache to no-cache.
• Designed and developed outbound Supplier and Inventory Items interface 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

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 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

Sr. Applications Analyst

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 team.
• 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

Senior Oracle EBS Applications Technical 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:
• 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
• Documented Technical Design documents for conversions.
• 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:

• 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