SUMMARY

• Oracle Applications Techno Functional consultant wif 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 experience in Unix Shell Scripting.
• 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 wif ability to interact wif people across all levels wif 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, Raleigh, NC

EBS Techno Functional Consultant

Environment: Oracle Apps R12.1.3, IExpense Implementation.

Responsibilities:

• Worked as Techno Functional Consultant, worked closely wif 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.

Confidential, Burlingame, CA

Team Lead & EBS Developer

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

Responsibilities:

• Worked wif 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 dis 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.
• Work wif functional team to schedule the FDD walkthrough.
• Interact wif the process team to gather the requirement for new developments.

Confidential, Charlotte, SC

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 wif the process team to gather the requirement for new developments.
• Work wif 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, Dallas,TX.

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 wif 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.

Confidential

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 me managed team and team work from HDC.
• Interacted wif 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 TEMPhas 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).
• me is 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.

Confidential

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.