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 FlowsOrder 2Cash& Procure 2Pay and technical architecture of R12 - INV, PO, BOM, WIP, OM, CPQ and Oracle Configurator.
• Worked on the development of Template based reporting tool like XML Publisher and Discoverer.
• Good exposure onPL/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.
• 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).
• Win NT/7/XP/2000/95 Server, UNIX (IBM AIX, HP & Solaris), Linux.
• 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 AppsDeveloper

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 and P2P cycle, SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential, Eden Prairie, MN

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.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Involved in oracle Unified Method (OUM).
• Work experience in Business Process Modeling and Analysis (BPA).
• Work experience in Oracle Product Information Management (PIM) module.
• Helped the ITEM LOAD Team for creating Bills & assignment for the items in the BOM.
• Part of maintenance Team delivered simple, complex & very complex Models.
• Worked in Maintenance Standards- Warranty and pricing list.
• Developed complex shell script program calling PL SQL from shell scripts.
• Helped the team in solving critical issues.

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.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Worked on complex configurator models.
• Worked on complex functionality ATP dates in configurator.
• Review of functional documents for technical feasibility.
• Preparing technical designs as per AIM methodology and development of code, preparing Unit Test Scripts documents, issue resolution.
• Validated data collection templates for PTO models. Defining Structure, Rules and User Interfaces for the models in Oracle Configurator.
• Tested the models to ensure the models are as per data collection templates.
• Validated the Model Structure and accuracy of the Configuration Template.
• Designing the QP Template which is an essential part of developing the Model.
• Building Models.
• Preparing Unit Test Documents.
• Unit Test Execution.
• Resolving Post work Issues.
• Writing Rules and creation of UI and structure.
• Unit Testing.

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