PROFESSIONAL SUMMARY:

• Over 13 years of experience in the implementation of Oracle Applications and Customizations.
• Excellent Techno/ Functional knowledge in Account Payables (AP), General Ledger (GL), Account Receivables (AR), Order Management (OM), Purchasing (PO), Inventory (INV), Application Object Library(AOL).
• Proficient in Support, Upgrade and Implementation of Oracle E - Business Suite R12 and 11i.
• Strong Functional Consultant in implementing, supporting and maintaining Procure to pay (P2P) process.
• Expertise in Data Conversion, Data migration, Developing Interfaces in Oracle Applications.
• Experience and Expertise includes Business Requirement Gathering, Requirement Mapping, GAP analysis, Functional architecture, CRP (Conference Room Piloting), Solution Design, Proof of Concept, Unit Testing, UAT and User Training.
• Experience in Oracle 8i/9i, PLSQL, SQL*PLUS, Oracle Reports, Forms, XML Publisher (5.6.3) and Oracle Workflow
• Module Implementation for Oracle E-Business 11i (11.5.10.2) and R12 (12.2.5) for Financial Modules.
• Excellent knowledge on Functional Analysis and Implementation, Training the client’s super users and users on the application and conducted Pilot Testing, Integrated Testing, Design Validation and Setups.
• Experience with Other Utilities: TOAD, SQL*Loader.
• Strong experience in Software Development Life Cycle (SDLC) process - Lead business meetings to gather requirements, perform feasibility analysis, design, technical specifications, development and unit testing, integration and production install and support
• A Good team player with Excellent Technical, Communication & Interpersonal skills.
• Motivated and determined to deliver High Quality Deliverables within deadlines with minimal supervision.
• Extensive experience in Source/ Existing/ Legacy system business functionality and preparing the Functional and Technical Design Documents using Oracle AIM Methodology (MD050, MD070, CV040, BR100, MD120).
• Was solely responsible for Production Support issues after the implementations and issues raised from day to day business.
• Good in Identifying the process improvements based on best practices, presented to the Client and Implemented the Functionality
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

FUNCTIONAL SKILLS

Oracle Modules: Account Payables (AP), General Ledger (GL), Account Receivables (AR), Order Management (OM), Purchasing (PO), Inventory Management

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, JAVA, HTML

Enterprise Applications: Oracle E-Business Suite R12, 11.5.9 to 11.5.10, OAF

ERP/Modules: GL, AR, AP, OM, INV, PO, AOL, Sys. Admin

Oracle Tools: Reports 6i/9i/10g, Discoverer 4i/10g, Forms 6i/9i/10g, SQL*LOADER, XML Publisher, Oracle Work Flow Builder.

Databases: Oracle 11g/10g/9i, MS Access

Tools: TOAD, SQL* PLUS, SQL Developer, SQL * Loader, PUTTY, ODI 11g

Operating System: Windows 9x/NT/2000/XP/Vista, MS DOS, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Understanding the functional requirements of the client, Analysis and Review of High-Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs.
• Developing custom interfaces between various Applications for integration.
• Developing reports through Oracle Reports and XML Publisher.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Collecting Business requirement and Leveraging with Oracle Applications
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Customization and development Reports as per client requirements.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle Applications EBS R12.2.5 (OM, INV, PO, GL, AP, AR), Oracle Database 11g, SQL, TOAD, Workflow, WEBADI, XML Publisher

Confidential, Detroit, MI

Oracle Application Techno Functional Consultant

Responsibilities:

• Gathering and analyzing user requirements and interacting with onsite team and business users
• Day to day status track of issue logs
• Involved in the project meetings to define/direct project goals and objectives
• Architecting and developing customer specific solutions
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Solely responsible for gathering business requirements and developing numerous Reports/ Interfaces/ Customization as per the requirement.
• Involved in Report development using XML Publisher
• Writing Unit Test cases and testing after completion of the Object.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Extensively used bulk collection in PL/SQL objects for improving the performing.

Environment: Oracle Applications EBS R12.1.3 (OM, PO, INV, GL, AP, AR, AOL), Oracle Database 11g, SQL, TOAD, Workflow, XML Publisher

Confidential, Minneapolis, MN

Oracle Apps Techno Functional Consultant

Responsibilities:

• Gathering and analyzing functional requirements and In-depth understanding of the Client’s business processes and business needs
• Interacting with onsite team and business users and architecting and developing customer specific solutions
• Technical analysis of existing RICEW components of existing components functionality
• Prepared Technical Documents, Unit Test Scripts, Test plans and Test results
• Design, Code, Test, code review and preparation of test scenarios/cases for all technical components
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Develop shell scripts for migration project to automate encryption, decryption and SFTP process.
• Worked as a Technical consultant ( RICE Development ).
• Solely responsible for Standard Sales order and Blanket sales order conversion process along with 4-5 XML publisher reports as per the requirement.

Environment: ERP Applications Oracle EBS (12.1.3), GL, PO, AP, PL/SQL, Oracle 10g/9i, Reports 10g/6i, SQL*Loader, SQL*Plus, PVCS, OBIEE, Putty, Winscp.

Confidential, San Jose, CA

Oracle Application Techno Functional Consultant

Responsibilities:

• Responsible for gathering Requirements, Development of Functional, Technical, Installation and User Documents
• Identifying functional and technical gaps.
• Assisted in business process reengineering, solid understanding of As-Is documentation and created To-Be process document
• Involved in code development, migration and test (Documented for Unit Test Scripts, Test Plans, and Test Results)
• Closely worked with users to understand business needs and objectives
• Worked Extensively on XML Publisher 5.6.2 against Applications R12, to develop various reports in GL, AP, AR, PO
• Designed and created over 5 XML Publisher Reports from various finance modules
• Involved in developing interfaces, conversions and reports as a part of R.I.C.E objects .
• Check & Validate, Rename, Recompile and Test existing customizations like custom forms, custom reports, and concurrent programs (host, SQL loader, SQL*plus, PL/SQL) in Oracle R12.
• Created new Invoices in AP for the Procure to pay process.

Environment: Oracle Applications - EBS 12(GL, AP, AR, INV, PO,) Oracle XML/BI Publisher Database Oracle 10G, Windows XP professional, CVS, Oracle Report Builder 6i, Form Builder 6i, Workflow

Confidential

Oracle Application Techno Functional Consultant

Responsibilities:

• Responsible for gathering Requirements, Development of Functional, Technical, Installation and
• User Documents
• Identifying functional and technical gaps.
• Assisted in business process reengineering, solid understanding of As-Is documentation and created To-Be process document
• Involved in code development, migration and test (Documented for Unit Test Scripts, Test Plans, and Test Results)
• Closely worked with users to understand business needs and objectives
• Worked on RICE components development.
• Developed sql*loader control files to load the flat file into intermediary tables finally into RA CUSTOMERS INTERFACE ALL, RA CUSTOMER PROFILES INTERFACE ALL.
• Worked Extensively on XML Publisher 5.6.2 against Applications R12, to develop various reports in GL, AP, AR.
• Customized XML/BI Publisher reports for Oracle Purchasing.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Created PDF/EXCEL outputs for reports based on requirements
• Used Data Templates for generating the XML data.
• Worked on creating Workflow Events with XML Payload and performed WORKFLOW Customizations.

Environment: Oracle EBS R12(PO, AP, AR, GL, OM, INV), Database Oracle 10G, Windows XP professional, CVS, Oracle Report Builder 6i, Workflow

Confidential

Oracle Application Developer

Responsibilities:

• Worked as Techno Functional Consultant
• Gathering and analyzing user requirements and interacting with onsite team and business users
• Day to day status track of issue logs
• Involved in the project meetings to define/direct project goals and objectives
• Architecting and developing customer specific solutions
• Design, Code, Test and code review Preparation of test scenarios/cases for all technical components bases on functional designs.
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Extensively performed conversions and interfaces on financial modules for upgrade to Oracle R12.
• Involved in developing interfaces, conversions and reports as a part of R.I.C.E objects development and development required for implementation of P2P process.
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation
• Have extensively worked on Oracle Account Payables Open Interface and AP Invoice Interface for Oracle R12.
• Involved in entering the invoices, approving invoices and then GL transfer for Oracle Accounts Payables.
• Imported the data from legacy systems into the temporary tables in Account Receivables (AR).
• Using XML Publisher according to the Client Requirement.

Environment: Oracle EBS R12(GL, AP, AR, PO, OM, INV), Forms 6i, Reports 6i, TOAD, Oracle XML/BI Publisher, Unix, Kintana

Confidential

Oracle Application Developer

Responsibilities:

• Study the Requirements and interact with Onsite Business Analysts and business users
• As a Team member interact with Team lead and manager for Requirements.
• Responsible for developing the assigned RICE components
• Testing the developed components with front and Applications
• Worked as a Technical consultant
• Worked over Oracle Applications 11i financial modules.
• Have been into discussion with business and identified questions to be resolved.
• Extensive experience in development of various interfaces like Auto Invoice Interface and Customer Interface for AR.
• Create intercompany invoice in PDF format to be emailed to receiving entity Utilized PL/SQL developer tool in developing all backend database interfaces.
• Developed a custom program for GL Interface
• Created new Oracle Reports and Customized standard Oracle Reports using Reports 9i
• Designed and customized custom Forms using Oracle Forms 6i.
• Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and BI/XML Publisher

Environment: Oracle Applications 11i Financial Modules (GL, AP, AR), Forms 6i, Reports 6i, TOAD, UNIX, KINTANA