SUMMARY:

• Has 5 years of techno/functional lead experience, 15 plus years of total experience in Application software development, Testing, System integration, Support, Implementing customized solutions for Energy, Manufacturing & Distribution, Financial, Healthcare, Technology and Insurance sectors using Oracle Applications Release 12.0.6/11.i/10.7.x, Oracle 10g/9i/8.x/7.x.
• Has extensive experience in development of functional/technical design documents (AIM methodology).
• Worked on Customization of Oracle Advanced Pricing, OM, INV, BOM, AR, Fixed Assets, Purchasing, PA, WIP, WMS, Workflow, HRMS, GL, AP, Web Services, BPEL, BIS, XML Publisher, Discoverer 4i/10g. Forms 4.5/ (6i)/10g, Reports (6i)/10g, C, PL/SQL, Discoverer, OAF J - Developer 9i/10g, Apex 3.x/4
• Knowledge of underlying data model of oracle applications modules required for development of enhanced functionalities.
• Has 5 full cycles of end-to-end implementations which includes R12 and 6 support project(s) experience.
• GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts, study/audit of existing business process and preparation issue logs, collection of functional/technical requirements, client/user interaction involvement in risks identifications and risk mitigations

TECHNICAL SKILLS:

Operating Systems: HP UNIX, Sun Solaris and Windows NT/95/2000/XP/ v.7

Hardware: SUN SPARC, IBM Pentium, PC-AT 486 & Pentium, HP Unix, Linux

Database: Oracle 10g/9i/8x/7.x, SQL Server

Programming Languages: C, Pro*C, PL/SQL, Java

Tools: & Utilities: ORACLE APPLICATIONS Rel.10.7/11i,12.0.6, OBIEE, Sql*Loader, Forms 10g/6i/4.5, Oracle Reports 10g/6i/2.5, Discoverer 4i/3i, Informatics, Developer 9i/10g, APEX,ODI

Internet Technologies: HTML 4.0, Java Script, ASP, Java 2.0

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. EBS Architect

Responsibilities:

• IT Lead for integrating Oracle to Sales Force.
• Designed and Developed interfaces from Bill of Materials / ASCM / Demantra to Sales Force applications. Said interfaces are used for Enterprise Risk Management.
• Developed and updated Standard Operating Procedures manuals
• Lead Analyst for developing Interfaces in Purchasing, Shipping modules.
• Designed new Forms for Enterprise Risk Management.

Confidential, Brea, CA

Sr. EBS Architect

Responsibilities:

• Lead for implementing WMS Project (Pick to Light) for one of the Warehouse. This has integration with 3rd Party hardware Lightening Pick and were achieved using advanced technologies with UTL packages for Socket connection, XML as communication using Oracle Advanced queues. Oracle Advanced Queues were utilized for system automation as an alternative to SOA interface.
• Setup and configured applications to support client requirements.
• Developed Custom OAF Application for Hazardous material processing for cartonizing and Un-Cartonizing packages.
• Stabilizing existing custom processes within company for Reservations, Delivery Grouping.

Confidential, Irvine, CA

Sr. Functional Analysts / Developer

Responsibilities:

• Lead for implementing Project Accounting for NY Location .Worked with the Business users and plan future Enhancements in accordance with the overall strategic direction of the business. Setting up of UAT and CRP (1 to 3) and created functional/technical design documents. Performed the setups for Project Accounting, Developed automated process from OM to PA.
• Designed and Developed Custom Transportation processes within Oracle that interfaces to 3rd party external applications.
• Designed and Developed processes with external applications OM to Tesseract (IB). EDI files to OM, Order info Emails to External Customers using XML Bursting, Inventory Interfaces for Intercompany Process.
• Customized Auto Invoice/Accounting Process.
• Customized Pick Release Process.
• Primary Support for Month end processes for OM, INV, PO, AR, AP and WMS.
• Drive warehouse activities based on an optimal shipment plan delivered by Custom OTM
• Conversion Scripts for regionalization projects (Conversion of 13 Operating Units into 5 OU’s).
• Designed and developed custom interfaces for ASN, Requisitions, In-transit Shipments / Inter Org Transfers
• Managing an integrated team to provide 24/7 user support and additional configuration that enhances business process. Responsible for Team work plans, Project Scope, Development / Enhancement of Interfaces, following Oracle’s AIM methodology, Implementing customized solutions in Order Management, Inventory, Purchasing, Receivables. Fixed Assets, BOM. Resolving Month end issues like clearing Interfaces, Pending Transactions etc. required for closing of periods.

Confidential, Irvine, CA

Sr. Programmer Analyst

Responsibilities:

• Sr. Lead Developer for upgrading Oracle EBS from 11i to R.12(12.0.6)
• Designed and Developed programs for conversion of Projects, Tasks, Budgets, Events, Agreements, Bill Rate Schedule and Funding into Project Accounting setups for PA
• Designed and Developed 65 Apex Forms and Reports for PA, AR, HR and AP.
• Upgraded Apex 3.0.2 to Apex 4.1

Confidential, Carlsbad / Irvine, CA

Sr. Programmer Analyst

Responsibilities:

• Led development team through design, development, and execution of programs to convert all inventory, cost from multiple legacy systems into an Oracle Applications 12.0.6.
• Lead Design, Architect and Developed Packages for Adjudication. This is used for calculating co-Payments Verifications to the Drugs and interacting with 3rd Party Systems for approvals using SOA
• Designed and Developed Credit Card Encryption and Decryption using Triple Des Technology.
• Worked as a liaison between the technical and functional manufacturing teams to address and prioritize day to day issues.
• Worked with functional team on strategy and design for conversions
• Provided production support during and after “Go-Live” period for Oracle SCM modules. Evaluated, prioritized and scheduled all enhancement requests. Provided training and documentation to ensure seamless transition of project team’s responsibilities to client personnel prior to roll off.

Confidential, San Diego, CA

Sr. Programmer Analyst

Responsibilities:

• Developed Web Services for Purchasing Requisitions, Purchase Orders, Sales Orders, RMA‘s using BPEL, J.Developer10g.
• Developed Interface for Trade Export Compliance, interfaces for External customers can create Orders in Oracle, Conversion script for the Install Base and Service Contracts from Legacy (Clarify) to Oracle.
• Team Lead for Implementation of Multiple Sets of Books.
• Worked on Integrating the Qualcomm Legacy Systems using Tibco Business Works. This was accomplished with Tibco messaging and worked on integrating Tibco Business Connect with external Vendors.

Confidential, San Clemente, CA

Programmer Analyst

Responsibilities:

• Worked with Functional team to identify and eliminate/minimize the manual processes. In this effort, lead few major projects as outlined below.
• AR Auto Accounting process was customized to meet Confidential, Inc. accounting needs.
• Designed and Developed Custom Module for Sales, which handles Rebates Processing, Sales Commissions, Tracks Sales from ICU to Distributors to End Customers which gives ability to provide reports as per FDA requirements using Interfaces, Forms and Reports.
• Designed and Developed Defaulting rule Package for OM Module.
• Worked on Logical Apps Modules for Creating Rules, Audit Reports and Controls.

Confidential, Fullerton, CA

Programmer Analyst

Responsibilities:

• As the team’s Technical Lead aligned resources from Oracle CPG development and CPG partners’ support and development teams to expedite resolution of customer’s most critical issues.
• AR Auto accounting process: was customized to meet Confidential, Inc. accounting needs. It was built to customize auto accounting process for orders that were interfaced from OM, Oracle Contracts and Oracle Services etc.
• Customized the Custom pll. Created Custom pll’s for each module and these pll’s are called from the Custom pll.
• Developed Interface for Order Management to Fixed Assets.
• FA: Automated the Manual Addition, Reclassification and Retirement of Assets for the instruments that were shipped or returned. Implementing this process has saved lot of time during the month-end close process.
• PA: Worked on Project Accounting Module, Developed interface for PA Budgets and Baseline projects using standard API’s, Expenditure Transactions from Legacy, Project Accounts Generator.
• Worked on Customizing the Auto Lockbox process for eliminating the Unidentified Receipts.
• Developed workflow for the AR Adjustments and Customized the Workflow for the Inventory and OM COGS Account Generator, PA Account Generator.

Confidential, San Jose, CA

Responsibilities:

• Actively involved in cut over implementation which includes Conversions, Interfaces, Testing (integration Test). Participated in all phases of Development Life Cycle including analysis, design, coding and testing
• Designed and developed Interfaces between Oracle Order Management, Purchasing and Siebel for importing Service Orders and Purchase Requisition.
• Developed Interfaces, Conversions Programs for Advanced Pricing (Price Lists, Factor lists), Sales Orders, Sales Reps and Items (Item Import) form Siebel System into Oracle Applications, categories and costs
• Reports 6i: Some of the customized reports include Open Invoice Report, Sales Order Schedule Report. Rescheduling of Sales Order Report. Developed Reports for Billing, Booking and Backlog, Price Lists, Factor lists. Designing and developing the Reports 6i include AP Invoices on Hold

Confidential, Atlanta, GA

Responsibilities:

• Performed database and application installations and upgrades at client sites. Process included installation of Oracle RDBMS 7.3, Oracle Applications 10.7, GEMMS 3.21 and 4.1 and CIMPRO in multiple versions UNIX, OpenVMS and Windows operation systems. Provided high level training on post-installation and system administration for customer’s IT staff.
• Confidential Inc Project is migrating from Oracle Applications 10.7 NCA to 11.5.0.This migration involves a lot of conversion of Reports from 2.5 to Reports 4.5. Developed the following forms in Oracle Forms 6 and Integrated into Oracle applications.
• Customization of forms, which include maintenance Project, Locations Involved in design and development of Financial Statement Generator (FSG).