SUMMARY

• me has eleven years’ experience of executing Oracle Applications (E - Business Suite) 11.5.10.2, R12i (12.1.1, 12.1.3) in projects across multiple geographies and business areas, while working wif teh IBM relationship.
• During these engagements, me has taken over various challenging and customer facing roles, including Technical Consultant, Technical Architect and ensured successful ERP implementations.
• Multiple project experience involving Implementation, Customizations, Conversions, Re-implementation, Support, Solutions, Multi-Currency and Multi-language development
• Core areas of skill are: Team Leading, Collecting teh requirements, analyzing, defining teh problem areas, working out teh logical solution, proposing teh solution based on teh technology available and suitable, planning and supervising teh design, development, testing, implementing and maintaining teh Enterprise Solutions.
• Good Functional Knowledge of Modules (OM, PO, AP, AR).
• Two Full Life Cycle Implementation Experience of Order to Cash and Procure to Pay Business Flows on Oracle Applications (11.5.10/12.1.3 ).
• Experience of handling multiple support projects as a Technical lead.
• Experience in developing R.me.C.E components for Financials, SCM Modules.
• Exposure wif roles and responsibilities of Designed and developed interfaces in oracle E-business suite to integrate wif web ordering tool to Oracle Apps.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i

Languages: PL/SQL

Tools: /IDEs: Kintana, WinScp,, PVCS, Toad, SQL Developer, Putty, HP Quality Center, ServiceNow

Oracle Applications Modules: Order Management, Oracle Purchasing, Oracle Inventory, Advanced Pricing, Oracle Configurator, Oracle Receivables, Oracle Payables, Application Object Library, Flexfields, Oracle Alerts.

Oracle Tools / Components: Oracle Developer 6i/9i (Forms 6i/9i and Reports 6i/9i), Workflow Builder 2.6, BI Publisher, SQL *Plus, SQL *Loader

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Sr. Oracle ERP Technical Consultant

Responsibilities:

• Developing a Sales Order interface for creating/updating a sales order using OM API’s.
• Developing a Sales Order Holds interface for applying holds using OM Hold API’s.
• Customization for PA Budget Workflow for changing Supervisor Hierarchy approval replace wif Finance Manager.
• Developed functionality for changing Pricing attributes and Product Qualifiers by using Modifier and Qualifier for providing discount at teh time of sales order entry.
• Developed Concurrent Program for rescheduling of sales order date on teh basis of customer Priority.
• Developed Concurrent Program for Auto Accounting Process for overriding teh segments values
• Developed Custom reports for Order related data.
• Developed BI Publisher PA to OTL Reconciliation Report
• Customized Account Analysis Report.
• Customized Printed RFQ Report(Landscape) Purchasing
• Customized PO Output for Communication Report
• Customized Purchase Order Detail report.
• Developed MD70 and UTP document.
• Actively handled all development activity whatever team is doing for smoothly deliver.
• Involve in handling Bug fixing during development.
• Developing Technical specification & UTR Documents.
• Form Personalization on Sales Order line form not to allow user to enter more than 1 quantity.

Environment: Oracle Applications 12.2.4 Release 2(OM, INV) Oracle DB 11g, PL/SQL, SQL*Developer, Winscp, Putty, Developer 10g

Confidential, Miami, FL

Sr. Oracle ERP Technical Consultant

Responsibilities:

• me was responsible to handle teh Enhancement Request as well as issues occurred in Oracle ERP System.
• Supported teh Order Management, Inventory, Purchasing modules.
• Customizing teh existing programs as per teh requirement in OM, PO, INV and AP Module.
• Responsible for collecting, managing and documenting teh Requirements.
• Participated in Data modeling and Data model reviews.
• Setup of Development as well as Integration and Production Environment
• Preparing teh Unit Test Case and Unit Test Results document.
• Involved in User Testing and Support
• Responsible for Production Deployment activities.
• Managing multiple teams, while ensuring quality deliverables, tracking SLAs and regular project monitoring
• Communicate clearly wif onsite team to understand and capture teh requirements accurately, support
• During teh testing and acceptance process etc., lead discussions wif onsite business and technical
• Consultants to clarify teh functional specifications, build technical design requirements and explain teh
• Options clearly.
• Effort estimation of teh Team co-ordination and discussion of teh components.
• Good Understanding of Oracle AIM methodology
• End-To End testing of components.
• Done all teh activities like creation/escalation/co-ordination of Oracle SR, wif Oracle Corp.
• Resolved OM, Inventory, PO related tickets for teh client.
• Data fix based on requirements.
• Design and development of teh concurrent program Order management.

Environment: Oracle Applications 12.1.3 (AP, AR, INV, OM, PO), Oracle Applications Release 11.5.10, Developer 6i/9i, Oracle DB 10g, PL/SQL, Toad

Confidential, Tampa, FL

Sr. Oracle ERP Technical Consultant

Responsibilities:

• Retrofit Custom objects (Interface, Forms, Reports, Packages, Workflows, Views, Triggers, Tables, Synonyms, Shell Scripts, Value Sets, and Concurrent Programs) from 12.0.6 version to 12.1.3 version of Oracle EBS.
• Studied teh impact of Upgrade on Custom objects and performing necessary changes to retrofit custom.
• Resolved AP related problem, RFC (Request for Change).
• Worked on upgrade from R12.0.6 to R12.1.3
• Prepared unit test cases for technical components and Conduct trainings.
• Worked wif offshore, client, onsite teams as part of teh project.
• Worked on Extensive testing for all customization as part of R12.1.3 Testing.
• Analyzed teh patched need to apply for R12.1.3 upgrade.
• Worked on XML Publisher Report.
• Worked on upgrade R12.0.6 to R12.1.3
• Worked on Extensive testing for all customization as part of R12.1.3 Testing
• Analyzed teh patched need to applied for R12.1.3 upgrade
• Performance Tuning for Various reports and custom objects
• Helped Business to resolve critical issues and halping teh team at offshore to understand teh functionality

Environment: Oracle Applications 12.1.3 (AP, PO, FA, GL), Developer 10g, PL/SQL, Toad, PVCS, Putty, Kintana

Confidential

Oracle ERP Lead Engineer

Responsibilities:

• Handled Multiple roles and responsibilities; Lead architect, Developer, project manager in teh project to deliver a deliverables.
• Functional consultant for Order Management for support project.
• End to end cycle for teh new customization.
• Requirements Analysis, Solution design, Functional Analysis.
• Solution testing of mapped Oracle processes.
• Preparing Solution Design Docs and Unit test plan.
• Conducting training sessions to teh end users.
• Prepared BR100, MD50, Test cases documents.
• Requirement gathering developed functional Specifications for new development, enhancements and Change requests.
• Developed XMl publisher Report for Oracle Quote module.
• Handled a team of 7 peoples.
• Extensively Worked on XML Publisher Report.
• Worked on item forecast interface through API.
• Developed Periodic alerts like Sales Order Acnoledge Failure Alert, Shipping Notification Failure Alert, New Item creation Alert.
• After post production me provided Support of Non-Us country like EMEA, Europe
• Involved in lots of rollout for various countries.
• Provided Post Production support by issue resolution and support including Month, Quarter, and Year End Close Support.

Environment: Windows2000, Oracle Apps ERP 11.5.10.2, XML Publisher, PVCS, Kintana

Confidential

Software Engineer

Responsibilities:

• Implemented several change requests to customize functionality in Oracle apps Order to cash cycle.
• Designed and developed interfaces to legacy systems
• Developed, validated and tested Oracle ERP data migration scripts
• Designed and setup Order Management module in 11i.
• Developed WOT interface for Order import from third party using interface tables.
• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing and adhoc report requirements
• Continued support for production issues as third level production support specialist.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets.
• Delegating and/or Solving Critical and High Priority Support and Development Activities for Oracle Receivables and Order Management
• Form personalization on teh Order form order types should not change by user instead of using Custom.pll.
• Involved in Manual Testing in Order management and Account receivables Modules.
• Worked on Internal Order Through Internal Requisition.
• Developed order import program.
• Involved in full life cycle testing in order management to account receivables(till auto invoice)
• Involved in full life cycle in RMA (Return material authorization)
• Prepared Software testing document like UTP, CIT document.
• Prepared D-spec (MD-70) for different projects.
• Done lots of setup for different country like Turkey, Canada etc. for Order management like
• Transaction types, Price list setup, Item setup and assign to other organization, Responsibility Setup.
• Worked on Form Customization using Form Personalization and CUSTOM.PLL.
• Worked on creation of Menus, Responsibilities, Profiles, DFF, Value Set and Concurrent Request.
• Registration of concurrent programs and creation of value sets.
• Involved in production support issue.
• Worked on PL/SQL Procedures, Triggers and Packages.

Environment: Windows2000, Oracle Apps ERP 11.5.10.2

Confidential

Technical Consultant

Responsibilities:

• Analysis, design, development, implementation and support of Oracle Apps ERP solutions for new implementations and upgrades.
• Developed Forms and Reports that handles teh Scrap and Tool Maintenance.
• Worked on Purchasing Document Open Interface.
• Customized teh few reports in PO and AP.
• Created Value Sets, Request Sets, Concurrent Programs as per teh Client Requirement.
• Developed technical document (MD-70) for process improvement
• Wrote package to validate data before loading into teh corresponding interface table.
• Extensive Knowledge of working wif SQL*Loader control files from flat files.
• System Integration Testing (SIT).

Environment: Windows2000, Oracle Apps ERP 11.5.10.2, Forms6i, Report6i, Toad, XML Publisher

Confidential

Software Engineer

Responsibilities:

• Analysis, design, development, implementation and support of Oracle solutions for new implementations and upgrades
• Analysis of teh user requirements.
• Involved in requirement gathering for Confidential Corporation.
• Involved in writing Functional document.
• Designing Database Tables for teh Project.
• Coding Using Forms Developer 2000.
• Pl/SQL coding using Sql*Plus
• Write teh Stored Procedures Using Oracle9i.
• Prepared Software testing document like UTP, CIT document.
• Developed new forms and reports as per teh business needs.

Environment: Windows2000, D2K Oracle, Forms6i/Reports6i