SUMMARY:

• Has around 11.8 years of IT experience.
• Worked extensively on Oracle Applications R12.2.4,12.2.3,12.1.3,11i (11.5.9, 11.5.10), Oracle Workflow, Oracle WEB ADI, Oracle Forms Customization and Personalization, Reports, Interfaces, Conversions, XML Publisher, BI Publisher and strong in SQL and PL/SQL.
• Have Knowledge on modules like SFM (Expertise in SFM module), TCA (Implemented Customer Data Hub& Supplier Data Hub), Installed Base, OM, PO, INV, BOM,WIP, PA, AP, Cost Management etc.
• Has 3+ years of “Onsite Experience”.
• Went to Onsite and achieved the status of “Single Point of Contact” for SFM technical and functional related issues and played a very prominent role in implementing the application.
• Currently with the role of Senior Technical Consultant. Performed roles like Team Lead, IT Analyst etc.
• Possess good analytical skills, has resolved issues at the earliest.
• Stood always supportive to complete the tasks within timelines and has achieved proficiency in completing the work assigned.
• Prepared Technical Specification (MD70) documents based on the (MD50) documents provided by the functional team.
• Used FNDLOAD utility to migrate concurrent programs, request sets, value sets etc.
• Worked on Outbound and Inbound Interfaces using API'S and Staging table concepts.
• Responsible for migration of packages and procedures, shell scripts and SQL*Loader files.
• Used various Oracle API’s and Interfaces to convert data from an existing system to Oracle Apps.
• Expertise in Oracle Forms personalization, Customization, Interfaces, conversions & Performance Tuning.
• Expertise in Oracle RICE technologies.
• Very strong in full suite of Oracle Tools including Forms 10.1/9.0/6i, Reports 10.1/9.0/6i, PL/SQL, SQL Loader, FNDLOAD.
• Used SQL*Loader and UTL FILE for uploading flat file data into Staging Tables.
• Experience in System Administrator and Application Developer responsibilities.
• Excellent communication and presentation skills.
• Skilled in Designing Business Process and Notification mailers using Workflow Builder 2.6.
• Ability to identify root causes of problems and consider both long and short - term impact of proposed solutions and develop workable solutions along with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

ERP: Oracle Applications 12i versions 12.1.2, 12.1.3/11i E-Business Suite (EBS) versions 11.5.9, 11.5.10

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

Apps Modules: SCM, Install Base, TCA, OM, PA, INV, PO,Costing etc.

Methods: Applications Implementation Methodology (AIM), Software Development Life Cycle (SDLC), Agile Methodology.

Tools: TOAD, SQL*Plus, Workflow Builder 2.6.4, Forms 10g Builder, Reports 10g Builder, XML/BI Publisher, Perforce PVCS (code version controller WEB ADI, Edit plus, Toad, SSH Secure Shell Client.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Senior Technical Consultant

Responsibilities:

• Involved in Client calls to gather business requirements, design review and solution provision.
• Analyzing the solution, capturing CR060, MD02060 and CM010 and handling Design document.
• Developed Sales Order Acknowledgement, Toll Invoicing Summary BI publisher report as part of Optio to BI Project with RTF template and Excel Output.
• Implemented Packaging Solution Project.
• Developed Custom module called 'Item Review Tracker’.
• Developed multi tab excel report "Address Book" with bursting option.
• Developed several BI publisher reports as part of Optio To BI Project.
• Developed Audit Report on Inventory Module.
• Developed Custom Workflow for Item Review Process...
• Unit testing the scenarios and preparing Test cases.
• Worked on XML Publisher Report Enhancements and bug fixes.
• Worked on Inbound/Outbound Interfaces using WSDL generation through EBS, with the help of SOAP UI.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Good Experience and Worked on System integration testing with business in UAT.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.

Environment: Oracle Applications R12.1.3, SCM(Commercial),TCA, PL/SQL, Oracle Forms 10g, XML Publisher, BI Publisher,, Toad, UNIX, Windows 7

Confidential, Kentucky.

Team Lead

Responsibilities:

• Involved in Client calls to gather business requirements, design review and solution provision.
• Analyzing the solution, capturing CR060, MD02060 and CM010 and handling Design document.
• Customized Project Accounting Extension Hook API’s, Project Approval and Budget Approval workflows as per business requirements.
• Customized OM order Header workflow to implement custom credit check logic and applying Credit holds.
• Implemented Supplier Data Hub, loaded Suppliers, Supplier Sites and Supplier Site Locations using Integrated import program.
• Loaded Supplier UDA’s with the help of TCA API’s.
• Worked on Creating Users for the Suppliers and assigning Responsibilities to the Supplier users.
• Worked on Conversion for Supplier banks.
• Implemented Customer Data Hub developed custom module called Confidential Territory management in order to assign UDA values located on Party site using web Adi.
• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Developed Custom Web Adi integrators to handle Cost of items for various cost types in Cost management module.
• Worked on EBS Form Personalization’s in OM Modules.
• Developed Routing Conversion in BOM.
• Developed Work Order Interface in Oracle WIP
• Worked on PATCX extensions for Preprocessor & Post Processor Extensions in PA Module.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Loaded the vendor’s information from legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Implemented several custom logics for Form Personalization using ZOOM Functionality.
• Analysis of gap documents and preparation of Technical Design Documents.
• Developed for Hotlist Report &Obsolesce Reports using XML Publisher.
• Involved the Production bug fix and worked on high priority.
• Involved in end to end project implementation and effective interaction with clients to sort the requirement.
• Worked on XML Publisher Report Enhancements and bug fixes.
• Worked on Inbound/Outbound Interfaces using WSDL generation through EBS, with the help of SOAP UI.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Good Experience and Worked on System integration testing with business in UAT.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Extensive experience in PL/SQL stored procedures in Oracle 11g using Toad SQL Developer
• Experience in performance tuning, DB scripts.

Environment: Oracle Applications R12.1.3, SCM,TCA, CDH, Web ADI, Supplier Hub PL/SQL, XML Publisher, BI Publisher,, SQL*Developer, UNIX, Windows 7

Confidential

IT analyst

Responsibilities:

• Involved in Client calls gathering requirements, design review and solution provision.
• Developed Item Min-Max Quantity program to load min and max quantity of the item.
• Developed Buyer Comments Mass Upload program. ‘Buyer Comments’ against an item will be uploaded into system with the help of this program.
• Developed Confidential Demand Vs Commit Form to display the analysis of item demand vs supply.
• Developed Confidential DRP History Work Bench form which will provide the history of the item like history of the shipments, sum of receipts and detailed demand view for the last twelve months from the current date.
• Developed shell scripts, packages, triggers, custom tables, views, interfaces and custom forms.
• Involved in production Support with quick turnaround time.

Environment: Oracle Applications 11i, Oracle Forms, Kintana, PL/SQL, SQL*Plus

Confidential team member

Responsibilities:

• Involved in Client meetings gathering requirements, design review and solution provision.
• Developed Custom Workflows from scratch for each telecom product like Pre Paid, Post Paid, Wire line, Triple Play, IPTV, Secondary IPTV, etc.
• Integrating custom workflows on Quoting and Order standard workflows using SFM (Service fulfillment Module).
• Customized Standard Quote to Order Conversion workflow by adding custom Business events in order to pre check the quote feasibility before converting to order.
• Worked on integration with third parties like Comptel, IRB (Billing) in the end to end cycle implementation of telecom products.
• Interfaced completed SFM workflows with standard quoting and order workflows and then to install base.
• Developed custom forms from scratch.
• Comptel Provisioning form to handle interactions between comptel switch and EBS process flow.
• Developed custom BAR/SUSPEND/RESUME/UNBAR form to bar/unbar or suspend/resume the services of the customer.
• Developed custom subscriptions and added them to Business events.
• Worked on API’s related to installed base, OM, Quoting, Services.
• Developed packages, procedures, functions, triggers, and customtables, views, Concurrent Programs, value sets, request sets, Dff’s, Alerts and other AOL objects.
• Involved in Production support with real quick time since it is telecom project and customer will be waiting to get the services started with immediate effect.

Environment: Oracle Applications 11i, SFM, OM, Quoting, Install base,TCA, PL/SQL, SQL*Plus, Reports6i, XML/BI Publisher, Workflow 2.6, SQL*Developer, Forms 6i, TOAD.