SUMMARY:

• Over 12 years of working experience in Oracle Application E - Business Suite Versions R 12.1.3/12.2.4/11 i in multiple Oracle Application lead roles with excellent technical project, team & task management skills. Proven ability to plan, co-ordinate and implement Full Life Cycle of Oracle EBS Implementation. This includes requirements gathering, technical design, testing, deployment, migration/cutover planning, production support and transition planning.
• Well versed in Oracle e-Business suite and demonstrated, deep hands on expertise in Oracle RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) development. Extensive working knowledge in Analysis, Design, Development, Documentation and Deployment. Involved in implementation, Upgrade and Support of Oracle Applications E-Business Suite using SQL, PL/SQL, Developer Suite 10g, with hands-on experience of various RICE components and Workflow.
• Strong technical skills in Oracle EBS with experience in - conversions, interfaces, reports, BI Publisher, OAF applications extensions and personalization, forms personalization and extensions, oracle workflow and coding database objects.
• Well versed with the Oracle P2P and O2C flows and possesses good knowledge on modules - General Ledger, Payables, Receivables, Order Management, Pricing, Purchasing, Fixed Assets, Cash Management, e-Business Tax etc.
• Ownership of the development lifecycle and being responsible for managing technical quality deliverable/resource/schedule/risks throughout the project, working extensively under onsite-offshore model using AIM Methodology. Expertise in writing the Technical Design Documents (MD070s) based on the Business Requirement document.
• Good knowledge of System Administration with hands on experience in creating Users, Responsibilities, Request Groups, Menus, registering concurrent programs, defining Value sets and Descriptive Flex fields. Good knowledge of UNIX shell-scripting. Conduct code review to ensure the work delivered by the team is of high quality standards.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite (11.5.10, 12.1.3, 12.2.4)

Work Areas: SQL, PL/SQL, SQL*Loader, FNDLOAD, D2K Forms, Forms Personalization, Reports, BI Publisher, OA Framework Extensions/Personalization, Oracle Workflow, Exposure and hands-on to Fusion Middleware - Oracle SOA & Oracle ADF.

Database: Oracle 9i/10g/11g

Languages: SQL, PL/SQL, UNIX, Shell Scripting, Pro*C

Reporting Tools: BI Publisher Desktop, Developer suite 10g, Oracle Discoverer

Tools and Utilities: TOAD, SQL Loader, SQL Developer, FileZilla (FTP), JDeveloper 11g, WinScp, STAT, Subversion.

Operating Platforms: Linux, Windows 2003, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Technical Lead

Responsibilities:

• Responsible for interacting with Business SME’s for requirements and analyzing the existing processes. Coordinated with IT and business SME’s to get the RICEW development tracker.
• Preparation of technical upgrade and test strategy documents.
• Review the Functional Design Document (MD050s) and prepare detailed Technical Design Documents (MD070s).
• Perform peer review of the technical design documents, code and unit test documents.
• Involved in retrofit and development of the interfaces from external systems to EBS R12 - GL, AP, AR, PO, and PA.
• Coordinated with the infrastructure and DBA team on the instance strategy, instance planning, clone and refresh for development and various test execution cycles.
• Responsible for technical design of Journal Interface abstraction layer from external systems - Constab, Microsiga etec. Worked on Interfaces from Ariba for inbound Purchase Orders, Receipts and Invoices.
• Design of Interfaces from Change Point to Oracle PA - Projects, Tasks Hierarchy, Timecards etc, inbound customer interface from external application, invoice interfaces - inbound and outbound between EBS instances.
• Technical Lead on divestiture engagements involving segregation of data through configuration and performing master and transactional data conversions - Customers, Supplier/Sites/Banks, Projects, Tasks, Agreements, Budgets, Events, etc.
• Designed data extraction & interlock approach, reconciliation strategy, encryption for data extraction project. Involved in preparation of the cutover plan by having meetings with key stakeholders from EBS and external applications. Responsible for execution of cutover and reporting status to leadership and client group.
• Resolve issues identified during System Integration Testing, User Acceptance testing and Post Production Support by working with the business and IT SME’s.
• Responsible for coordinating on various issues with Oracle through SR’s.

Environment: Oracle EBS R12.1.3, 12.2.4, BI Publisher, OAF, SQL, PL/SQL, XML, Workflow, Forms, Reports etc.

Confidential

 Lead Oracle Apps Technical Consultant

Responsibilities:

• Create technical design documents (MD070), development and review of code. Review of deliverables - technical designs, code and technical unit testing etc. and perform peer testing to log defects in HPQC and assign to developers.
• Worked on XML Publisher translation utility which consisted of development of OAF custom pages: Loader program to load the translatable text - source to target language into the repository.
• Building Custom User Interface in OA Framework to display and edit the translations that are loaded into repository.
• Involved in the development of the following RICE objects: Purchase Order Outbound based on Japanese layout; Import bank statement; Monthly Invoices and Refund reports in Receivables; Custom OAF page to upload data from excel used by different custom extensions.
• Cutover Activities: Prepared the Cutover kick off deck and the detailed cutover plan by coordinating with various teams. Execution of the cutover and report cutover status to leadership.

Environment: Oracle EBS R12.1.3, BI Publisher, Oracle forms, reports, OAF, SQL, PL/SQL and XML, Workflow, HPQC, Subversion.

Confidential

Lead Oracle Apps Technical Consultant

Responsibilities:

• Developed modifier excel upload utility, interfaces from Solution Builder to Oracle EBS on pricing modifiers/qualifiers, price. Worked on OM order header and line workflow customizations.
• Development of Oracle Alerts - Order Management, Bill of Material, Engineering etc. Developed custom forms, forms personalization and xml reports.
• Worked on POC for i-Receivables to i-Store integration.
• Involved in development of OAF personalization and extensions.
• Development of extensions - custom pages in OAF and personalization/extension of seeded pages.
• Worked on Price Agreements, Modifiers, Price List, Sales Order conversion etc.
• Developed common utility packages for - email distribution program; Common Data Loader program for conversions.
• Worked on Sales Order Interfaces using process order API; performed POC for BOM explosion for PTO kit items etc.
• Responsible for developing the Technical cutover plan and integrating with the overall project cutover plan.

Environment: Oracle EBS R12.1.3, BI Publisher, OAF, SQL, PL/SQL and Oracle Workflow.

Confidential, Texas

Senior Oracle Apps Technical Consultant

Responsibilities:

• Worked on development and maintenance of conversions – AR Transactions conversion; Customers Conversion.
• Worked on building a common data loader program to load legacy data for all the conversions.
• Built custom oracle forms ex: Quote and Order query forms to meet with business needs. Worked on reports like – Claims Aging, Claims Letter, Quote Document, Sales Order Acknowledgement etc. with XML Bursting included printing output documents.
• Worked on extensions, forms personalization, customization using CUSTOM.pll modifications. Worked on Oracle Payables – generation of Payment Files (for Check and EDI printing) using XML Publisher RTF and e-text templates.
• Worked on Customer Facing Document i.e. XML Based Receivables outbound invoice using Bill Presentment Architecture feature (BPA) in Oracle. Well versed with the setups in BPA. Worked on customizing the seeded LCT’s ex: forms personalization to suite project object’s migration needs.
• Worked on generating custom EDI outbound process for PO – 850 and PO Change – 860. Worked on PLSQL API’s and packages, procedures and functions for Tally Based integration i.e. custom application functionality built using oracle OAF.
• Coordinated with team members in resolving defects and participated in peer reviews for objects. Involved in unit test and system integration testing phases support.

Environment: Oracle EBS 12.1.3, Oracle Forms, Oracle Reports, XML Publisher, Oracle 10g, PL/SQL, SQL Developer, Oracle Workflow, Putty etc.