SUMMARY:

• Over 11 years of Extensive experience with Oracle Applications ERP as Techno Functional Consultant.
• Experience includes design, development, implementation and post production support in both Oracle e - Business Suite 11i/R12 Versions
• Experience in Oracle Application 12.1.3 &12.2.5 Reimplementation/upgrade Projects.
• Have a good experience in maintaining the team and helping them to solve the typical issues they are facing and completing the deliverables on time.
• Expert in development and enhancement of RICEW /CEMLI objects
• Strong analytical and technical skills with good programming experience in SQL, PL/SQL, Reports 10g, Forms 10g, Developer 6i/2000 (Forms 6i, Reports 6i), SQL*Loader.
• Expertise in Oracle Workflow Design and Development.
• Personalization and customization knowledge on Oracle Frame Work (OAF)
• Strong knowledge on TCA architecture
• Experience in writing and understanding Unix Shell scripting
• Having Good Knowledge in Business Events and Subscriptions.
• Worked extensively on developing stored Procedures, Packages, Functions, Database triggers, Exception handlers, and Cursors
• Very well conversant with all the aspects of Application Object Library (AOL), and Data Model of Oracle Applications.
• Expert in creation of Concurrent programs, creation of Executables, Registration of Forms and reports, creation of Users, Responsibilities, functions, value sets, request sets, request groups and lookups in Oracle Applications.
• Good exposure to Oracle Application Implementation Methodology (AIM).
• Extensive work experience in projects related to AOL, PO, AP, INV, OM, AR, PA, GL
• Good Knowledge on Procure to Pay and Order to Cash business cycles
• Strong knowledge on performance tuning techniques (Explain Plan / All levels of Trace File reading)
• Developed SQL Program to load data from Excel files, flat files into temporary table using UTL FILE utilities and SQL loader.
• Experience in working under software development methodology and is very proficient in Gathering Specs, Application design, development, and customizations, coding.
• Post Production support, bug fixing and enhancement experience.
• Planning and execution of Unit, Integration (SIT), and User Acceptance Testing (UAT) through the development of test scripts.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.

TECHNICAL SKILLS:

Oracle eBusiness Suite Modules.: AOL, PO, OM, INV, AP, AR and GL.

Oracle eBusiness Suite: R12,11i

Processes: Order to Cash, Procure to Pay

Languages: SQL, PL/SQL, JAVA and Shell Scripts.

Databases: Oracle 9i/10g/11g/12c.

Tools: Oracle Workflow Builder, Oracle AME, Forms Builder 6i/10g, Oracle Discoverer, Reports Builder 6i/10g, XML Publisher, JDeveloper,, SVN, HPPM, HPQC, Microsoft Office, Microsoft Visio, DB11g, MS SQL,CVS, SharePoint, JIRA.

Operating Systems: Windows, UNIX (Sun & HP), Linux, Solaris

Utilities: SQL*Loader, TOAD, PLSQL Developer, Unix SQL Developer, SQL*Plus.

PROFESSIONAL EXPERIENCE:

Confidential, Ada, MI

Oracle Apps Technical Consultant

Responsibilities include:

• Development of MD070 and Involved in the MD050 Reviews.
• Developed Outbound Item Interface for the Replenishment Planning
• Developed inbound interface to load purchase requisition.
• Developed inbound interface to load Contract Purchase Agreement and Blanket Purchase Agreement (CPA/BPA).
• Developed custom packages, procedures and functions as per the requirement.
• Development of Test scripts used for unit testing of the objects.
• Developed Item Interface which will auto assigned to Organization based on Branch Plant.
• Developed Multiple Tab reports in Excel Templates Based on Business Requirement
• Developed inbound interface to ship confirm the Sales Orders based on the data send by RP (Red Prairie) using Oracle APIs
• Developed Inbound Interface to create Internal Order Interface to RP. Developed the Miscellaneous Transaction Interface Page in OAF
• Customized VO Extension on Supplier Page to add Extra fields in Supply Base Form
• Developed Shell Scripting program for SQL data loader to move data to staging tables
• Developed Data validation scripts in PL/SQL to validate the data in staging tables.
• Developed Creation of Auto Debit Invoices for Supplier
• Development of Outbound Interface for PO Information to Red Prairie
• Development of Cash Receipts Interface in Oracle Receivables
• Developed BOM Outbound Interface
• Worked on Oracle Form Personalization and OAF Personalization

Environment: Oracle Applications R12 (OM, INV, PO, AP, AR and iExpenses), Oracle 11g, Workflow, Forms 10g, Reports 10g, LINUX

Confidential, Cleveland, OH

Oracle Apps Technical Consultant

Responsibilities include

• Creation and Updating of Technical Design Documents (MD070)
• Developed item and item categories conversion program
• Developed On hand quantity conversion
• Developed Stock Locator conversion using open API
• Development of Supplier Conversion
• Development of Open Purchase Order Conversion
• Development of Invoice Conversion
• Created Oracle form personalization on Inventory as per customer requirement
• Developed Custom Forms, Reports (XML/Reports), Alerts and workflow
• Developed Custom workflow for OPM Engineering Item Approval
• Involved in Oracle AME Setups.
• Customized the OEOL Workflow and PO Workflow
• Developed an Interface with MES systems to Oracle EBS
• Personalizing the OAF Pages.
• Worked in Oracle Alerts to send the Error message to specific Users
• Trouble shooting the performance issue using SQL Trace/TKPROF and Explain plans.
• Development of Test scripts used for unit testing of the objects.

Environment: Oracle Applications R12.1.3 (OM, OPM, INV, PO, AP and AR) Oracle 11g, Workflow, Forms 10g, Reports 10g, LINUX

Confidential, Chicago, IL

Oracle Apps Technical Consultant

Responsibilities include

• Development of MD070, Test Documents and Deployment Documents
• Developed Item Outbound Interface.
• Developed custom packages, procedures and functions as per the requirement.
• Development of Test scripts used for unit testing of the objects.
• Proactive solutions to long running custom concurrent programs.
• Developed of Invoice Inbound Interface integrated with Amazon.

Environment: Oracle Applications 11.5.10 (PO and AP) Oracle 11g, 6i Forms & Reports

Confidential

Oracle Apps Team Lead

Responsibilities include

• Preparation of MD 70 and CV 60 and TE 20 Documents
• Responsible for all the data migration in PO, INV, AP, Oracle Sourcing Modules
• Developed Custom Forms, Reports (XML/Reports/Discoverer),Alerts and workflow
• Form Personalization on Purchasing / receiving / Payable module
• Configured Custom Wed ADI for AP Invoice upload
• Modified Standard PO Account Generator/PA Suppler Invoice Account Generator Workflow.
• Designed custom workflow/Oracle Form to support custom process (Purchase Proposal Note Approval process)
• Developed Inbound interface Customer / AR invoice from POS(Port Operating System) to OEBS (Oracle E-Business Suite) - BPEL integration
• Allocation of work to offshore team members and responsible for all deliverables
• Code review, Code backup, conducting trainings, knowledge transfer
• Development of customer conversion using API
• Participated in CRP, SIT, UAT and Go-Live activities
• Development of PO Receipts conversion
• Design and development of change request (CR's)
• Various defect fixes in Custom Forms / Custom Workflow / Report / Oracle Forms
• Preparation of Weekly status documents and driving review calls with team.
• Involved in SOA Integration to connect with Oracle Applications.
• Developed SOP on Custom Process using Oracle UPK

Environment: Oracle Applications R12.1.3 (PO, AP, INV, PM, Sourcing) Oracle 11g, 6i Forms & Reports

Confidential

• Building, Building Management and Services
• Civil and Specialist Engineering and Services
• Rail Engineering and Services
• Investments and Developments

Oracle Technical Consultant

Responsibilities include:

• Involved in preparation of MD 70 documents.
• Developed custom forms as per business requirements.
• Developed Asset Number Interface to upload the asset activities.
• Developed Open Purchase orders conversion to upload purchase items.
• Developed Supplier Merge Details Report.
• Developed Supplier Insurance Details Report.
• Developed Asset Maintenance Report.
• Developed Alerts for Retiring or Adding an Asset.
• Customizing the forms Using form Personalization.
• Customizing the Workflows as per business needs.
• Preparation of Release Notes
• Identifying root cause of the issues and giving permanent fixes.
• Unit testing - Preparation of Test Cases.
• Identifying the Bugs and provide permanent solutions.
• Enhancements performed on existing components as per business requirements.
• Trouble shooting the performance issue using SQL Trace/TKPROF and Explain plans.
• Worked on Form Personalization
• Worked on Developer Reports

Environment: Oracle Applications 11.5.10 (PO, AP, INV, PM) Oracle 11g, 6i Forms & Reports

Confidential

Oracle Technical Consultant

Responsibilities include:

• Involved in preparation of MD 70 Documents.
• Developed Work order details form. Developed Asset Activity Status form.
• Developed internal fleet Transaction Details Form.
• Developed Performa Invoice Report & Developed Asset Activity Details Report.
• Creating Custom Work Flows as per the Business Requirements.
• Developed CUSTOM Interfaces as per Business Requirements.
• Deploy and Registration of developed reports/forms in Oracle Apps.
• Creation of Alerts on Asset Management when a new Fleet is added
• Development of Printed Purchase order report
• Worked with FNDLOAD utility to migrate objects from one instance to other instance.
• Trouble shooting the performance issue using SQL Trace/TKPROF and Explain plans.
• Developed custom packages, procedures and functions as per the requirement.
• Worked on Form Personalization.

Environment: Oracle Applications 11.5.10 (PO, AP, INV, PM, EAM, AM) Oracle 11g, 6i Forms & Reports