SUMMARY

• Having 10+ years of diversified IT experience in Oracle Implementation and applications Development(Manufacturing, SCM, Financials and Advanced Pricing)
• Extensive experience in Analysis, Design, Preparation of Specification, Development, Testing, Implementation and Production Support of Oracle E - Business Suite R12 (12.1.3, Ver12.2.4), 11i (11.5.10.2).
• Good exposure on design and development of RICE Components and involved in implementation and support projects.
• Very Good Experience on Functional flows O2C(Order to Cash)& P2P(Procure to Pay)technical architecture of R12 - INV(Inventory), PO(Purchase Order), BOM(Bills of Materials), WIP(Work in Process), OM(Order Management), AP(Account Payables),AR(Account Receivables), OPM(Oracle Process Manufacturing), Shipping, Costing, WMS(Warehouse Management System).
• Worked on the development of Template based reporting tool like XML Publisher and BI Publisher.
• Involved in Customization of Standard Oracle Workflow.
• Strong experience in AOL, SYSADMIN and experience in tools like Oracle D2k, PL/SQL, SQL Developer, Forms 6i/10g, Reports 6i/10g, Oracle10g/11g under Windows XP/2007
• Expert in understanding of user requirements, converting into Functional Documents (MD50’S), technical specifications (MD70’S), statements of problems to detailed logical flow charts for coding into Oracle applications.
• Developed inbound and Outbound interfaces using SQL*Loader, UTL FILE and PL/SQL Packages.
• Has extensive hands-on experience in developing database triggers, stored procedures, functions and packages.
• Developed Interfaces using APIs and Interface tables.
• Experience in interacting with onsite clients while being responsible for deliverables and ability to work with limited resources.
• Documentation experience, keeping in line with the AIM Methodology.
• Familiarity in developing Project related design documents like MD70, MD50, CV60, MD120, and TE20.
• Prepared the Cut over plan for GO-Live and taken the responsibility to move all the CEMLI objects to PROD.
• Upgraded multiple projects from 11i environment to R12.1.3, R12.2.4.

TECHNICAL SKILLS

ERP Modules: Oracle Applications Release 12 Business Suites, Ver12.1.3, Ver12.2.4, Oracle Applications 11i Business Suite, Ver11.5.10.2-Modules R12 - INV(Inventory), PO(Purchase Order), BOM(Bills of Materials), WIP(Work in Process), OM(Order Management), AP(Account Payables), AR(Account Receivables), OPM(Oracle Process Manufacturing), Shipping,, WMS(Warehouse Management System). and Oracle Advanced Pricing.

Operating System: Windows XP/2000/98, UNIX.

Development Tools: Reports 10g/9i/6i, Forms 10g/9i/6i, Oracle BI/XML Publisher, UTL FILE, PVCS, Developer 2000, Discoverer 4i/10g.

Database Tools: SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator, SQL Developer.

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

Document Methodologies: MD.050, CV.040, CV.060, MD.070, MD.120, TE.020.

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Techno Functional Consultant

Responsibilities:

• Requirements Gathering, Data Migration, Extensive work on RICE components that include Reports (RDF and XML Publisher), Conversions, Interfaces, Customizations, Data Mapping, Technical Design, Code/Script Development, issues resolution, Performance Tuning, Documentation(AIM).
• Analyzing the requirements.
• Define and set up DFF's using Application Developer responsibility for Purchase Order Header to identify Contract Retention Invoices.
• Created and customized reports using XML Publisher/BI Publisher in AP, PO, OM, AR, and INV like Item use up date Report, General Inventory Report, Po Distribution Report, Expected Receipt Report, Product Transaction Listing Report, Invoice on hand Report.
• Created PL/SQL and SQL*Loader scripts as a part of conversion process to extract the legacy data from existing applications and loaded them into Oracle Application tables.
• Involved in Customization of Standard PO Requisition Approval Workflow.
• Responsible in creating Value sets, Concurrent Program Definitions and Executable.
• Involved in developing Reports 6i in OM and BOM.
• Developed Item Extract Outbound Interface.
• Create and define template and data definitions for Open Purchase Order report.
• Involved in debugging various interface related issues in AP and Order Management.
• Developed various Extensions and Personalization’s in WIP.
• Responsible to design various AIM document deliverable MD050, MD070, functional, and technical documents.
• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
• Worked on capturing the changes in cost for the Items from the Vendors to be reflected in the Oracle.
• Developed OM Extract for the Daily, Weekly, Monthly analysis for the Order Status in Discoverer.
• Worked on creating application mode End User Layer, building business areas, and building discoverer workbooks using Discoverer4i.
• Good development of workflow components using Oracle Workflow Builder.
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Experience with UNIX and Shell Scripts.

Environment: Oracle Apps R12 - OM, INV, AP,AR,PO, BOM modules, and SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential, Tinley Park, Illinois

Technical Developer

Responsibilities:

• Analyzed the 11i version tables which are going to modify in the R12.
• Retrofitted (changing the columns which are obsolete in 11i to R12) views In R12
• Performance tuning of the views.
• Prepared Build Notes and Unit Test Scripts for the respective objects.
• Involved in migrating the objects from one instance to other instances.1
• Involved in converting Oracle Standard Reports into XML Reports in WIP and INV.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document.

Environment: Oracle Apps R12 - OM, INV, WIP, BOM modules, XML Publisher, SQL, PL/SQL.

Confidential

Techno-Functional Lead

Responsibilities:

• Responsible for all RICEW deliverables.
• Gathering requirements and preparing MD 70 and TE20 and MD120 documents.
• Identified the impacted objects during this Upgrade.
• Migrated more than 30 reports from EBS Applications Ver11i to R12.1.3
• Customized Print Purchase Order report.
• Customized the PO, Requisition Workflows.
• Upgraded around 10 Discoverer reports.
• Involved in performance tuning of SQL queries
• Worked on retrofitting of the 11i reports and packages of AP and AR applications as part of upgrade.
• Analyzing the requirements and discuss with Functional users and prepare Technical documents.
• Gathering requirements from client and based on our understanding prepare and understanding document, later a Functional document is prepared based on this.
• Assigning tasks to the team members and coordinate with them in timely delivery of the objects.
• Upgraded the existing reports and forms and PL/SQL code from 11i toR12.1.3 instance.
• Review of functional documents for technical feasibility.
• Created new Discoverer workbooks based on Client requirement.
• Preparing technical designs as per AIM methodology and development of code, preparing Unit Test Scripts documents, issue resolution.
• Preparing Unit Test Documents.
• Unit Test Execution of the deliverables to see that its working as per the requirement.
• Prepared the Cut over plan for GO-Live and taken the Responsibilities to move all the CEMLI objects to PROD

Environment: Oracle Apps R12 - OM, INV, PO modules, XML Publisher, SQL, Forms, Reports, PL/SQL, Oracle Discoverer 4, Oracle Workflow.

Confidential

Technical Analyst

Responsibilities:

• Analyzed the EBS Applications 11i tables which are going to be modified in the R12.
• Retrofitted (changing the columns which are obsolete in 11i to R12) views In R12
• Created UNIX scripts to migrate the objects from one instance to other.
• Performance tuning of the views.
• Involved in converting Oracle Standard Reports into XML Reports.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document
• Involved in Unit Testing of the objects developed.
• Done the end-to-end testing of the P2P and O2C cycle of the retrofitted components as part of Upgrade to R12 applications.
• Responsible for Creation of Technical Design Documents (TDD).
• Involved in registration of various AOL objects Functions, Value set, Concurrent programs.
• Designed and Developed necessary feeder system i.e. staging tables, validation routines using SQL* Loader, SQL and PL/SQL procedures
• Involved in development of Purchase Document Open Interface.
• Prepared Build Notes and Unit Test Scripts for the respective objects.

Environment: Oracle Apps R12 - OM, INV, PO, AP and AR modules and also P2P and O2C cycles, XML Publisher, SQL, and PL/SQL.

Confidential, Boston, MA

Techno-Functional Developer

Responsibilities:

• Involved in Technical designing, development and Installation documents
• Created Technical Design for Conversion, Interfaces and Reports
• Involved in developing Inbound and Outbound Interfaces.
• Responsible in developing Item Extract (Outbound Interface).
• Responsible in developing Requisition Import Interface.
• As part of support and enhancement used to fix all the issues in P2P cycle.
• Designed and Developed necessary feeder system i.e. staging tables, validation routines using SQL* Loader, SQL and PL/SQL procedures
• Involved in converting Oracle Standard Reports into XML Reports.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document
• Involved in Unit Testing of the objects developed.
• Responsible for Creation of Technical Design Documents(TDD)
• Involved in design and development of Oracle XML Publisher Reports.

Environment: Oracle Apps R12 - OM, INV, PO, BOM, WIP, AP, AR, GL, Cash Register and P2P cycle, SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential, Boston, MA

Technical Business Analyst

Responsibilities:

• Providing support for objects in Oracle SCM and Finance Modules
• Designed and developed custom conversions - Item Categories Conversion and Item Conversion.
• Updated the Technical Design Documents as per the changes made.
• Closely interacting with the users by providing resolution to the issues raised.
• Created Host Program which will send out an email of the output file to end users.
• Working closely with the DBA Team while moving the code to production.
• Involved in the supporting the interface between SAP and Oracle for the Purchase orders.
• Created many new concurrent programs to automate the process.
• Involved in functional setting up of approval hierarchy for Purchase Orders.
• Developed stored procedures and packages. Extensive experience in PL/SQL coding.
• Worked with development of packages and procedures using PL/SQL.
• Closely interacting with the users by providing updates day by day on the issues.
• Customization and development of reports Order Management module.
• Created various new value sets as per customer requirement.
• Customization and development of reports purchasing module.
• Loading the data from external files to temporary table by using SQL*Loader, validated the data and then inserted the resulted data in the Inventory base table.
• Involved in required functional setups and form personalization.
• Reviewing the progress of issues with Project Manager.
• Involved in client discussions and gathered information directly with client.
• Responsible for User Accepting testing (UAT), Functional testing and System testing.
• Developed reports using XML Publisher and also converted some standard reports to XML reports.
• Developed new reports in Oracle R12 using 10g report builder.
• Reviewing functional specification and get clarifications from onsite, Preparing technical specification, Coding and unit testing, preparing documents like UTP and installation instructions.
• Proposing solutions for the requirements and Involving in status calls.
• Registered Concurrent Programs and custom Applications using System Administration.
• Developed many reports for retail, distribution and supply chain modules in version R12.
• Test the developed code as per the cases given in FDD and fixing bugs.
• Worked extensively in XMLP reports.
• Preparing Unit Test Plan and Installation Documents.

Environment: Oracle Apps R12 - PO, OM, AP, AR modules and also P2P cycle, Oracle Reports, XML Publisher, SQL, PL/SQL.

Confidential, Hamilton, NJ

Technical Consultant

Responsibilities:

• Requirements Gathering, Data Migration, Extensive work on RICE components that include Reports (RDF and XML Publisher), Conversions, Interfaces (using standard API’s), Customizations, Data Mapping, Technical Design, Code/Script Development, issues resolution, Performance Tuning, Documentation (AIM).
• Upgraded Custom forms from 11.5.10 to Release 12.1.3 version.
• Upgraded more than 40 reports of Oracle Applications from 11.5.10 to R12.1.3
• Worked on the standard Purchasing reports like Printed Purchase Order report and Purchase Price Variance Reports and created the custom reports based on the client requirement.
• As part of unit testing of P2P cycle, have done testing of Purchasing and Payables modules components to see that transactions are created properly and the correct entries are created in General Ledgers.
• Worked on Item Conversion and Supplier Conversion.
• Developed Technical design, Unit Test Plan, Installation and Load Plan Documents.
• Developed and modified several custom packages according to the business needs.
• Customized several existing reports to have additional features.
• Developed new RDF reports and also XML publisher reports.
• Developed new application Alert based on the requirement.
• Developed new form in the custom Module
• Prepare MD070 and MD050 for the SR’s.
• Preparing Unit Test Documents.
• Created the shell scripts to migrate the developed objects across the instances.
• Created form personalization as per the business requirement.
• Have done Unit Test plan Execution.
• Part of maintenance Team delivered simple, complex & very complex Models.
• Developed complex shell script program calling PL SQL from shell scripts.
• Helped the team in solving critical issues.

Environment: Oracle Apps R12 - INV, OM, PO, AP, AR, Procure to Pay cycle, SQL, PLSQL, TOAD and SQL*Plus.

Confidential

Technical Developer

Responsibilities:

• Worked on Item Conversion.
• Handling issues related Interfaces.
• Worked on AP Supplier Inbound Interface.
• Extensively used AOL for registering concurrent programs, Value Sets, Flex fields creating users and assigning responsibilities to end users.
• Involved in developing PL/SQL Packages, Stored Procedures and Functions.
• Involved in migrating the objects from one instance to other instances.
• Involved in converting Oracle Standard Reports into XML Reports.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document
• Involved in Unit Testing of the objects developed.
• Responsible for Creation of Technical Design Documents (TDD).
• Interacted with the end users and functional architects to meet the requirement.

Environment: Oracle Apps R12 - AP, AR, SQL, PL/SQL, TOAD, Winscp, Putty and SQL*Plus.

Confidential

Technical Developer

Responsibilities:

• Analyzing the requirements.
• Regular meetings with the business users.
• Gathering requirements and preparing MD 50, MD 70.
• Worked on PO Conversion.
• Preparing Solution Design Documents for the developments.
• Interacting with clients to get the requirements and support activities.
• Involved in regular Support Activities.
• Involved in Unit Testing of the developed objects.
• Responsible in developing Sales Order Interface using the Standard API’s.
• Involved in design and development of Oracle 6i Reports.
• Designed and developed several PL/SQL packages.
• Data Extraction on request raised by end user.
• Interacted with the end users to meet the requirements.

Environment: Oracle Apps 11i - INV, PO, OM, AP, AR, SQL, PLSQL, TOAD, Winscp, and SQL*Plus and Putty.