SUMMARY

• Having 10 years of diversified IT experience in Oracle Implementation and applications Development.
• Extensive experience in Analysis, Design, Preparation of Specification, Development, Testing, Implementation and Production Support of Oracle applications 11i and R12(12.2.4).
• Hands on experience in development of inbound implementation Flat File to Oracle Applications Environment and Staging tables.
• Good exposure on design and development of RICE Components and involved in implementation and support projects.
• Good understanding on Functional Flows Order 2Cash & Procure 2Pay and technical architecture of R12 - INV, PO, BOM, WIP, OM, AP,GL,CPQ and Oracle Configurator.
• Worked on the development of Template based reporting tool like XML Publisher and Discoverer.
• Good exposure on PL/SQL programming.
• Strong experience in ALERTS, AOL, SYSADMIN and experience in tools like Oracle D2k, PL/SQL Developer, Forms 6i/10g, Reports 6i/10g, Oracle10g/11g under Windows XP/2007
• Expertise in development of Multi-Layout and Multi-org report and customization of oracle standard reports using report builder 10g.
• 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.
• Working Experience in Production Support as a Team lead in Configurator.
• Experience with UNIX and Shell Scripts.
• Prepared the Cut over plan for GO-Live and taken the responsibility to move all the CEMLI objects to PROD.
• Extensive project exposure on Oracle Configurator and CPQ.
• Developer with techno-functional hands on.
• Documentation experience, keeping in line with the AIM Methodology.

TECHNICAL SKILLS

• Modules: SCM, Manufacturing, Oracle Configurator.
• Domain: Oracle Applications Release 12 Business Suites, Ver12.0.X, Oracle Applications 11i Business Suite, Ver11.5.10.2, Ver12.2.4.(INV, PO, BOM, WIP, OM, CPQ and Oracle Configurator).
• Operating System: Win NT/7/XP/2000/95 Server, UNIX (IBM AIX, HP & Solaris), Linux.
• Tools: /DB/Packages: Application Object Library, SYSADMIN, Forms Personalization, Reports 10g/9i/6i, Forms 10g/9i/6i, Oracle BI Publisher, SQL*Plus, SQL* Loader, Toad, Oracle SQLDeveloper, PVCS, Infor Design Studio, Sales Portal, Team Center.

PROFESSIONAL EXPERIENCE

Confidential, Hatfield, PA

Oracle Apps Developer

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 on OM.
• 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.
• Customized the existing forms as per the business requirement.
• 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 - OM, INV,PO,BOM, WIP, AP, GL and P2P cycle, SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Oracle Configurator Developer.

Responsibilities:

• Worked on daily support team(PCS) on ECN’s.
• Analyzing the requirements.
• Re writing the rules based on the change in the ECN.
• Performing Regression Testing based on changes.
• Publishing the model into Production.
• Acknowledging the ECN once the change has completed and published in the production.
• Sending notification to JDE AP and JDE EMA team to check their systems have impacted or not.
• Currently Working on BPH Project.
• Analyzing the BOM data using BOM analysis Tool.
• BPH Project is all about moving the tangible parts to the New OC.
• Earlier all the Tangible parts were there in the CP Parts.
• Creation of the Items in Item master with Item Import tool in the orgs which ATO model has been commened.
• Creation of the Item categories for the new Items and OCs by using Category Update Tool.
• Creation of the Bill of Material for the New OC’s.
• Commoning all the bills to Parent model commoning orgs by using CITRIX tool.
• Adding the all the New OC’s to the I Sub model.
• Creation of the IMODEL Bill as per BPH model Rework Process.
• Pre-Explode the Model and Populate the model into Configurator Developer Repository.
• Create the Isubmodel Structure as per BPH Process.
• Adding Isubmodel to the Parent model.
• Replacing the CP Part rules to tangible part Rules with future effective date.
• Performing QA for all the shipping orgs with before BOM data and After BOM Data.
• Performing JDE AP and JDE EMA QA.
• Publishing the Model in test model to check the Tangible parts are driving as per the Parts Expansion Document.
• Perfoming the MVT by Manufacturing Engineers.
• Publishing the Model in Production Mode.

Environment: : Oracle Apps 11i(Bryan Betsy) - OM, INV, BOM,SQL Developer, Oracle Configurator Developer.

Confidential

Oracle Configurator Consultant.

Responsibilities:

• Analyzing the requirements.
• Prepare MD 70 for the SRS.
• Validating data collection templates for PTO models. Defining Structure, Rules and User Interfaces for the models in Oracle Configurator.
• Testing the models to ensure the models are as per data collection templates.
• Validating the Model Structure and accuracy of the Configuration Template.
• Building Models.
• Preparing Unit Test Documents.
• Unit Test Execution.
• Resolving Post Work Issues.
• Writing Rules and creation of UI and structure.
• Unit Testing.
• Extensive experience in Configure-to-Order Implementation which includes Setups (parameters, Profiles etc.), Creating and process the configurations, Order changes and returns, updating existing configurations and Purging data.
• Extensive experience in configurator architecture which includes tables in cz schema, PopulatingCZ SCHEMA, MigratingData, SynchronizingData,CZ SCHEMA Maintenance, Integration,API's involved in Configurator development.

Environment: : Oracle Apps R12 - OM, INV, BOM, GL modules, SQL Developer, Configurator Developer Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential, Schaumburg, IL

Oracle Configurator Lead

Responsibilities:

• Responsible for all RICEW deliverables.
• Gathering requirements and preparing MD 50, MD 70.
• Involved in performance tuning of sql queries.
• Analyzing the requirements.
• Gathering requirements from client.
• A regular meeting with SME’s to get the SBOM data.
• Assigning tasks to the team.
• We analyze specifications that are provided by engineering team.
• The specifications contain requirements about the Alloy metals.
• Based on requirements provided in the specifications we prepare model structure and create Configurator extension rules.
• Make a valid configuration and create a quote for the end user.
• Worked in Configurator extensions.
• Extensive experience in Configure-to-Order Implementation which includes Setups (parameters, Profiles etc.), Creating and process the configurations, Order changes and returns, updating existing configurations and Purging data.
• Extensive experience in configurator architecture which includes tables in cz schema, PopulatingCZ SCHEMA,Migrating,Data,SynchronizingData,CZ SCHEMA Maintenance,Integration,API's involved in Configurator development.

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

Confidential, Foster City, CA.

Developer

Responsibilities:

• Designed and developed custom conversions - Item Catalog Conversion and Item Conversion.
• Developedstored procedures and packages. Extensive experience in PL/SQL coding.
• Worked with development of packages and procedures usingPL/SQL.
• Worked on one extension: Lot Number Adopt Assign Program.
• Understanding Functional Design and get the clarification, preparing technical design document based on AIM methodology standards.
• Developed reports using XML and BI Publisher on GL Module.
• Developed new reports in Oracle R12 using 10g report builder in SLA Module.
• Reviewing functional specification and get clarifications from onsite, preparing technical specification, Coding and unit testing, preparing documents.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.
• Designed MD070, TE20 and developed the code to meet the client’s requirements MD120, for extracting the correct data to meet the client requirements.
• Worked extensively in XMLP reports.
• Preparing Unit Test Plan and Installation Documents.

Environment: Oracle Apps R12 - INV, PO, OM, GL, SLAmodules, Oracle Reports, XML Publisher, SQL, PL/SQL.