SUMMARY:

• 11+ years of experience in Oracle Applications E - Business Suite in which 6 months underwent training for Oracle Apps R12 technical and functional.
• Have worked in diverse areas like Requirement Gathering, Architects, Design, Analysing the Gap, Development, testing, Implementation, Product Support, documentation and Rollout of business comprising ERP solutions.
• Completed four end-to-end life cycle implementation on Oracle Applications R12 and one implementation in Oracle Applications on 11.5.10.
• Done one Upgradation from 11. .1.3 and done performance tuning for various components.
• Involved and Expertise in development & customization of Oracle Application ie PL/SQL package, Interfaces, Reports, Forms, OAF, Discoverer, XML Publisher, Form Personalization, Form Custom pll and Workflow.
• Expert in architecting system interfaces, designing custom solutions, performing impact analysis, scheduling deployments, production support.
• Had trained in OAF and developed, done extension, personalization on OA Framework page.
• Current role is Techno-Functional Lead managing the 5 member team and also doing the development.
• Strong familiarity with AIM methodology in creating MD-50, MD-70, MD-120, BR-100 etc. documents throughout multiple Projects.
• Excellent verbal and written communication skills, analytical and interpersonal skills.
• Underwent training in Oracle SOA in BSIP Solution (India).
• Underwent training in J2E at NIIT (India)

SOFTWARE SKILL:

ERP: Oracle Apps (E-Business suite) (R12, 11.5.10)

Modules Worked: (Finance and Distribution) GL, AP, AR, FA, INV, OM, PO, PN, PA, PON, CA OPM, Alert, AOL, Sysadmin, AME, i procurement, i-expense.

Tool: Toad, SQL* Loader, Oracle D2K report and forms 10g, Discoverer 10gPL/SQL Developer, XML Publisher, Workflow, OAF, Oracle SOA, HPQCKintana, PVCS, SVN version, Gdocs, Putty, Winscp.

Languages: SQL, PL/SQL, Java, XML, XSL

Operating System: Windows, DOS, UNIX

RDBMS: Oracle 9i, 10g

EXPERIENCE SUMMARY:

Confidential

Techno-Functional Lead

Environment: : Oracle Apps R12.1.3

Responsibilities:

• Delivering Projects on time from conception and development, to detailed planning, execution and delivery, ensuring customer satisfaction.
• Instrumental in understanding the client’s business processes architecture
• Analyse the functional specification received from business partner and develop MD070 and deliver the technical component
• Lead the development team and consultant’s teams globally
• Involved in requirement analysis.
• Involved in Design documents, Test Scripts, Test Cases.
• Involved in developing Inbound and Outbound Interface, Reports, XML publishers, OAF as per project requirements.
• Designed and developed Pick Slip and Packing Slip reports to include the Barcodes and additional business requirements.
• Prepared design and deployment documentation provided deployment and data migration services and assisted with user training.
• Involved in development, customization and data migration into Oracle Applications project.
• Involved in tuning queries in Oracle SQL and PL/SQL.
• User training and production support

Confidential

Consultant ERP

Environment: Oracle Apps R12.0.6

Responsibilities:

• AR Invoices Interface: Interface done using Auto Invoice Import Program.
• AR Customer Interface: Interface done including bill to & ship to address.
• AR Lockbox Interface: Involved both functionally and technically in setup of Lockbox process and coding.
• Involved in requirement analysis.
• Involved in Design documents, Test Scripts, Test Cases.
• Involved in developing, Customizing and testing Oracle Apps Reports
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Involved in customization, developing Inbound and Outbound Interface, Reports, XML publishers.
• Involved in developing and testing Oracle Stored Procedures, Functions and Packages.
• Involved in developing, Customizing and testing Oracle Apps Reports
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Involved in registering the reports, screens and batch programs, unit testing, and verification with users.
• Prepared design and deployment documentation provided deployment and data migration services and assisted with user training.
• Responsible for registration of new programs in Oracle Applications as concurrent programs.
• Wrote Shell scripts that were directly called from Oracle Applications.
• Involved in development, customization and data migration into Oracle Applications project.
• Tested the Custom Migrated forms from 11i to R12.
• Tested the Custom Migrated code in R12.

Confidential

Senior Technical Associate

Environnent: Oracle Apps 11.5.10

Responsibilities:

• Involved in requirement analysis.
• As Sr. Associate guiding the Associate in development and Support projects.
• Involved in customization, developing and testing Outbound Interface, Reports, XML publishers and AME.
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Created MD70’s Documents for reports and interface
• Involved in registering the reports, screens and batch programs, unit testing, and verification with users.
• Prepared design and deployment documentation provided deployment and data migration services and assisted with user training.
• Involved in development, customization and data migration into Oracle Applications project.
• Review of code changes, test procedure.
• Responsible for registration of new programs in Oracle Applications as concurrent programs.

Confidential

Technical Consultant

Environment: Oracle Apps R12, Oracle 10g, Report 10g, Discoverer, XML Publishers.

Responsibilities:

• Involved in requirement analysis along with functional consultant.
• Involved in Uploading the legacy data to Oracle apps through Interface in both finance and distribution modules
• Involved in development, customization and data migration into Oracle Applications project.
• Involved in customization, developing and testing the Oracle Reports, XML publishers, Discoverer.
• Done Reconciliation for upload data and Client data.
• Involved in registering the reports, screens and batch programs, unit testing, and verification with users.
• Prepared design and deployment documentation provided deployment and data migration services and assisted with user training.
• Responsible for registration of new programs in Oracle Applications as concurrent programs.
• Review of code changes, test procedure.

Confidential

Technical Consultant

Environment: Oracle Apps R12, Oracle 10g, Report 10g, form 10g, XML Publishers and Workflow.

Responsibilities:

• Created Three Custom Forms using Template fmb for rate card component, rate card template and rate card.
• Created Oracle Alert for Transfer of flat, cancellation of flat, Approval of rate card template and rate cards.
• Customize the Oracle Application form Using Custom pll and Form personalization as client requirements.
• Program for generating customer rate card from rate card template.
• Program for automation of billing schedules on customer agreements
• Created Value set and Descriptive Flex Field.
• Created similar two custom forms for maintenances.
• Created program for bill maintenance template and monthly bill.
• Created Value Sets and DFF.
• AR Invoices Interface: Interface done through Auto Invoice Import Program.
• AR Customer Interface: Interface done through Customer Interface.
• Item Upload Interface: Interface done using Import Items.
• PO Interface: Interface done using Import Standard Purchase Order.
• Open AP Invoices Interface: Interface done for all open invoices. Open invoices are those invoices against which payments are not entered in the system. These include cases of partial payments as well.
• AP Supplier & Sites Interface: Interface done for suppliers & Supplier Sites.
• PO Receipt Interface: Interface done using Receiving Transaction Processor.
• Item Quantity Upload: Interface done using Import Item Quantity.
• API
• Created User party, add responsibility and add user security attribute for the suppliers.
• Updated the vendor sites using API (ap vendor pub pkg).
• Created Employee, created user for employee and add user security attribute using api
• Created MD70’s Documents for reports and interface.