SUMMARY:

• Oracle Applications Techno Functional consultant with 11 years of experience in implementation, maintenance and production support.
• Strong experience in Oracle Applications R12/11i (/ 11.5.9/11.5.10 ), SQL, PL/SQL, Oracle 11g/10g/9i/8i.
• Extensively worked on OTC (Oder to Cash), PTP (Procure to Pay) cycles.
• Extensive knowledge in iExpense Module, Implementation knowledge of the CITI Bank VISA Credit Card.
• Expertise in Developing, Customizing and Implementation of Oracle Modules: Account Payables (AP), Account Receivables(AR), General Ledger(GL), Order Management (OM), Human Capital Management (HCM), Purchasing (PO), Bill of Material (BOM), Warehouse Management(WMS) Application Object Library (AOL) and Oracle System Administrator
• Good exposure to Oracle EBS SCM Discrete Manufacturing, process manufacturing, supply chain and planning processes.
• Expertise in design and delivery of Oracle EBS technical objects like RICEW, Oracle Alerts, Oracle BI Publisher, XML Publisher, Oracle Forms & Reports and experience in extension of OAF pages and OAF personalization’s.
• Six full lifecycle implementations experience (R12/11i) of PTP (Procure to Pay) and OTC (Order to Cash), OPS cycles going through Development (DEV), User Acceptance Test (UAT) and Production, User Training, go - live and post go-live Support in complex Multi-Org Environment.
• Strong Programming Experience in writing Packages, Procedures, Functions and Triggers
• Good understanding and exposure to Oracle Apps Data Model, Application Object library components (KFF, DFF, Value Sets etc.).
• Excellent experience in Discoverer Administrator and to create workbooks using Discoverer Desktop and Discoverer Plus.
• Experience in registration of concurrent programs, creation of Users, responsibilities, forms, functions, menu, values sets, request sets, request-groups in Oracle Applications.
• Developed Technical documents for the customizations done on forms and reports.
• Good Experience in Performance Tuning.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Strong interpersonal skills with ability to interact with people across all levels with capabilities

TECHNICAL SKILLS:

ERP: - Oracle apps R12, 11i and 10.7(OM, INV, PO, AR, BOM, WIP, OPM, HR, TCA, P2P, O2C and OPS cycles).

Front End tools: - Oracle JDeveloper (11g, 10g), Forms6i/9i/10g, Workflow Builder2.6.3.5.

Reporting Tools: -Oracle XML Publisher, Oracle Reports6i/10g, Oracle BI Publisher

Middleware: -Oracle SOA 10g, 11g

Tools: -SQL* Plus, SQL* Loader, Toad, SQL Developer.

Languages: - SQL, PL/SQL, Java, UNIX Shell Scripting, XML, XSLT

RDMS: - Oracle 11g/10g/9i/8i.

Operating systems: - UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential

EBS Techno Functional Consultant

Environment: Oracle Apps R12.1.3, IExpense Implementation.

Responsibilities:

• Worked as Techno Functional Consultant, worked closely with CITI Bank and Syneos Business to understand the requirements.
• Configurations for the Credit Card Programs.
• Defining Request sets for the Credit Card Validation Programs.
• Worked on Oracle standard Program Visa VCF 4 Transaction Loader and Validation Program and VCF4 files sent by CITI Bank for Transactions loading and New Accounts creation.
• Developed Payments outbound interface to CITI Bank for payments reconciliation.
• Developed Host Program to rename the file.
• Developed the Host Program to remove the file.
• Modified the Workflow to facilitate automatic assignment of the employee to the new Credit Card account.
• Implemented Tokenization for CITI Credit Card Program, in order to increase the security of the credit card accounts.

Team Lead & EBS Developer

Environment: Oracle Apps R12.2.6, Forms and reports 10g.

Responsibilities:

• Worked with Business and functional team to provide best solution for the data Conversions that are required for the Implementation.
• As Senior Technical Oracle application Consultant worked on Different Modules (Account Payables, Inventory, HRMS) for this implementation.
• Worked on Conversions, Interface across the modules.
• Developed Item Conversion.
• Developed Item Attribute Interface.
• Developed Employee Conversion/Interface.
• Developed Supplier Conversion.
• Developed AP Invoice Interface.
• Developed Expense Report Interface.
• Developed On-Hand Inventory Conversion.
• Interact with the process team to gather the requirement for new developments.

Confidential, Charlotte

Team Lead & EBS Developer

Environment: Fusion HCM, Oracle Apps R12, Forms and reports 10g.

Responsibilities:

• Manage onshore team and take care of work assignment for offshore and onshore teams.
• Developed Employee Conversion Program as part of implementation.
• Developed Employee Interface Program for Fusion HCM to Oracle EBIS.
• Developed Custom API for AP Module to convert Employee to Supplier.
• Interact with the process team to gather the requirement for new developments.
• Work with functional team to schedule the FDD walkthrough calls.
• Review the technical design documents, code and Unit test Plan developed by my team members and makes sure the code is as per the Functional requirement.
• Prepare the daily status reports on New Developments and Change Requests for tracking the development progress.
• Conduct Knowledge sharing sessions on new technologies, Coding standards and processes.

Confidential,

Team Lead

Environment: Oracle Apps R12, Forms and reports 10g.

Responsibilities:

• Handled two Application ARC and ADMS as onshore Team lead.
• One of the application ARC is legacy application, it’s a standalone system consists of Forms and Reports.
• ADMS is oracle Application support and the work involved is related to SCM, AR and GL Modules.
• Managed team assignments and took care of Development.
• Interacted with the process team to gather the requirement for new developments and to understand the defects.
• Consolidated all the work that is done and send the status report to Project Manager.
• Supported the team in work and made my team members to deliver the task in time.

Technical Consultant

Environment: Oracle Apps R12, Forms and reports 10g

Responsibilities:

• Lead Post Production Support (PPS) Team and HCM Development from HDC.
• As Senior in the team I managed team and team work from HDC.
• Interacted with the onshore process team to gather the requirement for new developments, CR’s and to understand the defects.
• Consolidated all the work that is done from offshore and transitioned it to the onshore team.
• Supported the team in work and made my team members to deliver the task in time.
• Trained fresher’s in the team on Apps technical, made them understand the process, Concepts of Oracle Apps and oracle tools.
• US Steel has large number of extensions in OTC area, As PPS team we support all the Extensions which includes Forms, Form Personalization, XML reports, PLSQL Procedures and Workflows.
• Worked on Oracle Application Desktop Integrator (webADI).
• I am one of the few resources who supported US Steel Customized Pricing, US Steel pricing solution is one of the complex pricing solutions.
• Supported all the Pricing Extensions.
• Worked in the HCM Module for the Implementation of Payroll for US Steel.
• Developed 5 Interfaces out of which 3 are outbound and 2 is inbound interface.
• Developed two Fast formulas in HCM.

Technical Consultant

Environment: Oracle Apps 11.5.10, Forms and reports 6i.

Responsibilities:

• Created Host Program to load HTS Values in Lookups table.
• Created Validation Program to Validate the HTS values while loading to Lookups table
• Created Custom Tables required for the Project.
• Developed 10 Forms.
• Created Procedures to validate PO Number, Part Number, Unit Price, UOM etc,
• Created Procedure to Extract the shipped data for every 24 hours.

Technical Consultant

Environment: Oracle Apps 11.5.10, JDeveloper, Forms and reports 6i.

Responsibilities:

• Created Custom Tables to Define Commodity Defaults, Define Item Control, and Define Sample Size Table.
• Created Collection Elements.
• Defined Corporate Collection Plan (Inspection Collection Plan) and Child Plan (Defect Collection Plan)
• Personalization is done on Receipts, Receiving Transaction and Move Transactions (WIP INSPECTION) Forms.
• Created Custom OA Framework Pages to Define Commodity Defaults, Define Item Control, and Define Sample size.
• Created Procedures to Insert in to custom Item Control table when the combination of Manufacturer, MFG Part number, Organization and Vendor Does not exists.
• Created Procedure to Update the Item Control table based on the inspection Results.

Technical Consultant

Environment: Oracle Apps 11.5.10, Forms and reports 6i.

Responsibilities:

• Customized Application by creating Menus, Request Groups and Setting up Forms, Form Functions and Concurrent Executables.
• Integrated custom forms and reports with oracle.
• Developed custom request set for new responsibilities
• Created custom form RMA RTV Workbench for the Project.
• Created Custom Receipt Traveler and Commercial Invoice Report

Technical Consultant

Environment: Oracle Apps 11.5.10, Forms and reports 6i.

Responsibilities:

• Worked with the Business Users and Functional team to understand the requirements for the business change.
• Created and used stored procedures, packages, cursors and functions to calculate Ryot Share, Company Share and Burnt cane price, calculate Bio compost transactions, Vehicle One/Two-way diesel calculation, Daily process - CHR Calculation etc.
• Created workbooks using Discoverer to make the reports and worked on discoverer Admin and desktop to create Business Area, folders and items.
• Created custom forms for accounting modules i.e. Village Master, Season Master, Vehicle Master, Cane Reception, Nursery Inspection, Farm inputs transact, Wire Slings etc.
• Created Custom Reports using Discoverer and Report builder for accounting modulei.e. Basic data Factory link, Division wise six years yield analysis, Crop class wise eight years yield analysis, Cane price, Purchase tax and Cess Tax, Ryot ledger, Cane Control Sheet etc
• Developed PL/SQL package for AP conversion.
• Assisted in database designing by creating database objects such as Views, and Indexes.
• Created the MD70 technical documents for conversions, forms and reports.
• Involved in testing the new/modified components.

Environment: Oracle Apps 11.5.10 Modules: GL, AP, AR, PO, PL/SQL, Oracle 9i, SQL Server 2005, Toad, Discoverer 4i, SQL*Loader, Reports 6i/10g, UNIX, PL/SQL.