SUMMARY

• 14 years 10 months of IT experience in Oracle Applications. Oracle Applications Techno Functional Consultant.
• Expertise in Conversions, Interfaces, Reports and Extensions. Also worked extensively on Data migration.
• Experience in Oracle Forms6i, Oracle Reports6i, Oracle Discoverer, SQL, PL/SQL, UNIX scripts, SQL - Loader, Oracle Workflow, Oracle Applications 11i and Oracle Applications R12
• Technical Expertise in AR, AP, GL(Basics), OM, Purchasing (PO), PA, OTL, Inventory (INV), HRMS (Basics), Cash Management, Fixed Assets (FA), EBTax, Sub Ledger Accounting (SLA) and XML Gateway modules of oracle Apps.
• Has good understanding and hands on in AOL in Oracle Apps. Background coding shell scripts, modifying and developing Reports (6i), Forms (6i). Registering them with Application Object Library and XML Publisher
• Having knowledge on O2C (Order to Cash) process and P2P (procure to pay), and worked in a highly customized environment for these.
• RevPro Go-live and Support. This tool is used for 606 revenue recognition. Single point of contact for supporting this tool. Also worked on Enhancements and performance tuning.
• Involved in analysis, design, development, testing and implementation of medium to large scale projects.
• Able to work independently and have experience in coordinating across multiple team (including business user teams). Also have experience of leading teams.
• Experience includes coding Interface Programs using XML, SQL * Loader and PL/SQL procedures from legacy systems. Have worked on both inbound and outbound interfaces.
• Experienced in performance Tuning and analyzing using Tkprof, SQL Trace, and Explain Plan.
• Onsite client experience in United Kingdom, Romania and United States.

PROFESSIONAL EXPERIENCE

Confidential

Lead Consutant Finance

Responsibilities:

• Lead for the Oracle Financial and RevPro Application Confidential client location.
• R12 Support on Oracle financials.
• Handling and single point of contact for Month end close activities of North America Region.
• Single point of Contact for RevPro support. Includes Actuals and forecast.
• RevPro Month End processing.
• Co-ordination between various teams to make sure the month end closure happens on time with minimal issues.
• Working on Performance improvements for long running programs.(specially RevPro)
• Working on enhancements for RevPro
• Working on Automations
• Working with Business users for identifying data issues with revenue recognition and data rectification.

Environment: Oracle E-Business Suite R12, 11i. Modules TCA, GL, AP, AR, SLA, etc.

Confidential

Lead Consultant

Responsibilities:

• Oracle to Cortera interface for B2B customer credit information. Built the interface from requirement gathering, analysis, design, develop (code) and go-live. Outbound include Customer, Hierarchy, Open Invoice, Closed invoice and Customer balances.
• Daily updates to management on progress, issues, risks and resolutions.
• Interaction with client IT and business teams for Rollouts, CRs and support.
• Worked on treasury interface for AP, AR and GL
• Proposed, analyzed and build small enhancements to Cortera interface and super global customer processes.
• Designed and developed Daily rate interface from Bloomberg

Environment: Oracle E-Business Suite R12, 11i. Modules TCA, GL, AP, AR, SLA, etc.

Confidential

Lead Consutant Finance/ Customers

Responsibilities:

• Customer Data Migration from 11i to R12 and R12 to R12.
• GL Code combination from R12 to R12(localized system)
• Driving Delivery of complex customer migration as per client needs.
• Developed and enhanced code for Customer migration.
• Supporting releases for multiple rollouts of country based operating units based on client needs.
• Daily updates to management on progress, issues, risks and resolutions.
• Interaction with client IT and business teams for Rollouts, CRs and support.

Environment: Oracle E-Business Suite R12, 11i. Modules TCA, GL.

Confidential

Lead Reports and Extensions

Responsibilities:

• Involved as the Reports and Extensions Lead Confidential onsite (US).
• Driving Delivery of complex workflows like Requisitions, PO Approval and AP Invoice.
• Co-ordinations with onsite (including client) and offshore on regular basis.
• Daily updates to management on progress, issues, risks and resolutions.
• Interaction with functional team for effort estimates on CR and feasibility study.

Environment: Oracle E-Business Suite R12 (Multi Language enablement of 2 languages). Modules SCM, AR, GL, PA, AP.

Confidential

Multi Language Support Lead

Responsibilities:

• Involved in the scoping activities of the project.
• Created the ramp plan and execution plan for the project. This had to undergo multiple iterations and planning activities
• Understand the requirements and get POC done for some objects along with client and internal resources. Propose feasible solutions.

Environment: Oracle E-Business Suite R12 (Multi Language enablement of 2 languages). Modules SCM, AR, GL, PA, AP.

Confidential

Multi Language Support Lead

Responsibilities:

• Lead and drive all Multi Language Support (MLS) enablement activities from off site for LATAM and Brazilian Portuguese.
• Assisted client in technical questions/ understanding. Also presented the demo for MLS along with the key technical changes needed
• Co-ordinate with project team from US and Mexico to make sure the MLS patch is applied and tested properly.
• Identified risks and issues and their mitigation actions for MLS.
• Helped Functional team with queries and data for MLS testing for localization requirements

Environment: Oracle E-Business Suite R12 (Multi Language enablement of 2 languages)

Confidential

Offshore Location Lead and Oracle Apps Designer/Developer

Responsibilities:

• Lead the team in India to complete the technical aspect of the deliverables of Oracle Applications
• Designing the high level technical solution from the functional and business requirements for the extensions.
• Creating detailed technical designs from functional specification documents for the deliverables
• Handling major extensions for modules Oracle Project Costing and Oracle Project Contracts.
• Building the code of complex objects for the extensions.
• Reviewing documents and code of other peers for quality
• Helped team members find solutions for their challenges in their deliverables.
• Interact with functional team members for understanding the requirements and solution designing from a process perspective and also end to end technical testing of the deliverables.
• Provide status updates to all other key members of the project.

Environment: Oracle Apps R12, XML Publisher, Developer Suite 10g

Confidential

Offshore Location Lead and Oracle Apps Designer/Developer.

Responsibilities:

• Lead the team in India to complete the technical aspect of the deliverables of Oracle Applications
• Designing the high level technical solution from the functional and business requirements for the conversions and Interfaces.
• Creating detailed technical designs from functional specification documents for the deliverables
• Handling all Major Interfaces and conversions for the GL module.
• Building the code of complex objects for the conversions and Interfaces.
• Reviewing documents and code of other peers. (quality)
• Helped team members find solutions for their challenges in their deliverables.
• Interact with other technical teams from Client and other vendors for solution designing from a process perspective and also end to end technical testing of the deliverables.
• Provide status updates to all other key members of the project.

Environment: Oracle Apps R12 (Finance).

Confidential

Offshore Location Lead and Oracle Apps Designer/Developer.

Responsibilities:

• Lead and Manage the Bangalore Team. The complete offshore team was spread across locations.
• Provide Daily status updates to all other leads from offshore and onsite.
• Developing Technical Designs and code for the conversion of Receivables Open Invoice conversion and Receipts Conversion.
• Making Technical Design of other reports like Standard Invoices, Superbill, Statements, etc. for junior resources to do the build.
• Worked on workflow customization
• Also designed and developed XML publisher reports.
• Reviewing documents and code of other peers. (quality)
• Helped team members find solutions for their challenges in their deliverables.

Environment: Oracle Apps R12 (Supply Chain Management and Finance).

Confidential

Technical Consultant

Responsibilities:

• Developing Technical Designs for the conversion of Payables Open Invoice conversion.
• Build of the components Payables Open invoice conversion
• Review of documents and code done by other peers.
• Helped team members find solutions for their challenges in supplier conversion and Bank account creation.

Environment: Oracle Applications 11.5.9 and R12.

Confidential

Technical Lead

Responsibilities:

• Developed the Inbound for receiving Purchase Orders
• Developed 2 outbounds for sending Invoices and Credit Notes
• Developed Oracle Discoverer Business Area and Reports for error handling.
• Developed the HTTPS and Servlets programs for the connectivity of third party systems
• Usage of XML Gateway in a customized way. This includes DTD and XML along with connection establishment using a core JAVA.
• Developed the RMA return custom check program in Revel
• Handled the whole technical coding for MTIC
• Developed an interface to created receipts in receivables from bank statement.
• Involved with the revenue recognition process.
• Contra project complete technical handling. Build a Contra form which knows of AP and AR balances for dealers (customer and supplier). Also developed reports. Mentoring and leading a junior resource from Romania.
• Part of the support team where we handle trouble tickets and close them in time.

Environment: Oracle Applications 11.5.9, XML Gateway, Discoverer 4i and 10g

Confidential

Technical Consultant

Responsibilities:

• Module Lead for the Oracle General Ledger (GL) module. There were a total of 3 members working for the module.
• Complete Analysis of each and every object and solutions for the same which was to make the objects Multi-Org compliant.
• Active participation in problem solving for other modules whenever possible.
• Handled all Major Interfaces for the GL module.
• All deliverables delivered on time which includes the Code, Documents (MD70, UTC and Code Reviews). All objects tested thoroughly and hence complaints from the client.
• Done Code Review for other Modules like AP, PA and PO.

Environment: Oracle Applications 11.5.9. Main module Oracle General Ledger. Also helped with AP, PA

Confidential

Technical Consultant

Responsibilities:

• Created business area using complex SQL query
• Developed 16 reports in Oracle Discoverer.

Environment: Oracle Applications 11.5.8, Oracle Discoverer 4.1.47

Confidential

Technical Consultant

Responsibilities:

• Developing Reports using Oracle Discoverer. Includes creation of Business Areas in Discoverer Administration and Developing Reports in Discoverer Desktop and Discoverer Viewer.
• Developing TDs and UTCs.
• Created a User Guide.
• Created other documents like Installation Documents.
• Also was a part of the complete support phase of the project.

Environment: Oracle Applications 11.5.8, Oracle Discoverer 4.1.47 Workflow 2.6, D2k Reports 6i.

Confidential

Technical Consultant

Responsibilities:

• Preparation of Application Requirement Manual (ARM) and System Maintenance & Technical Document (SMTD) for OM, INV and ERP Reporting
• Created a SQL piped Report for the business requirement of detailing 1. Activation of the phones and 2. Billing of the customer for the ordered equipment
• Was a part of developing the shell script for automating error generation report and sending the output as an email attachment.
• Detailed Analysis of the Confidential &T Oracle Applications System setup.
• Detailed Study of Integrations with the Third Party Systems for ERP Reporting which includes Discoverer and Business Objects.
• Prepared the AWS Specific Presentations for ERP Reporting which includes Discoverer and Business Objects.
• Open/Close activities & Sustenance Activities in Parallel Perform Phase

Environment: Oracle Application 11i

Confidential

Technical Consultant

Responsibilities:

• Detailed analysis of user requirements
• Understanding of the process of Management for the Training Process.
• Preparing documentations like User guide and System Guide
• Mapping, Coding & testing of assigned reports
• Tracking defects occurred & finding means to overcome them & implementing related defect prevention activities

Environment: Developer 2000 and Oracle 8x