Oracle Techno-Functional Consultant

R AVI S INGH

T: 647-***-**** Toron to, O n ta rio, M9 A4 X7 M: ***********@*****.***

ORACLE APPLICATIONS/E BUSINESS SUITE R12 CONSULTANT

EBS Technical Functional Configurator Developer Analyst Architect Implementer

8+ years of experience in Oracle E Business Suite Implementation, Upgrade, Customization and Automation with

international project experience within the IT industry. Proven skills with a customer service oriented approach to daily

operations. Critical thinker & effective problem solver. Seeks new responsibilities, acts on opportunities and generates

ideas. A progressive record of increasing responsibilities and a record of bringing together disparate groups to achieve

common objectives. Ability to articulate complex concepts to diverse, non technical and technical audiences.

Implementation/Upgrade Conversion/Interface/Integration Workflow

Oracle Application Framework Integrated SOA Gateway BI Publisher

SQL, PLSQL, SQL Loader Oracle Forms & Reports XML Gateway

Personalization/WebADI Oracle SOA/AIA 11g Java, Unix

Oracle Financials, FAH, GL, iBuy, AP, AR, Procurement, OM, FA, iSupplier, iExpense, iProcurement

PROFESSIONAL SUMMARY

Extensive experience as Oracle Applications Techno Functional Consultant in Implementation, Upgrade and

Customization of Oracle E Business Suite Applications. This includes system study, design, development, post

implementation maintenance and support of Oracle EBS.

Extensive experience as Oracle Applications E Business Suite Consultant and Technical Developer in Design,

Development and Implementation of Oracle Applications R12/11i.

Strong understanding of business flows, underlying technical architecture and table structure of Oracle E

Business Finance Suite.

Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in

Oracle Applications with major focus in General Ledger (GL), Financial Accounting Hub (FAH), Accounts

Payables (AP), Accounts Receivable (AR), Order Management (OM), Inventory (INV), Purchasing (PO),

iExpenses, iProcurement, iSupplier.

Hands on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within

several modules in Oracle Applications.

Extensively worked on Oracle Application Framework (OAF/ADF), BI Publisher, XML, Java Concurrent Program

(JCP).

Extensively experienced in Oracle PL/SQL Development (i.e. Stored Procedures, Packages, Functions &

Triggers), Unix Shell Scripting, SQL *Loader.

Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions).

Strong knowledge of Application Implementation Methodology ( AIM), Application Object Library (AOL)

implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).

Extensive experience in different domains like Banking, Telco, Insurance, Pharma, Retail, Manufacturing etc.

Worked with the business functional areas to research and identify the best technical solution to support business

processes.

Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports,

Workflow Builder, Toad, and PlSql Developer.

Designed architecture for integration of EBS with upstream and downstream systems to flow data for supplier,

items, invoices, payments, accounting codes, customer, banks etc.

Experience in designing, developing, testing, performance tuning and supporting data base applications using

Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher ), PL/SQL, Oracle SOA 11g (BPEL,

OSB, AIA, Composite, File Adapter, Database Adapter, JMS Adapter, Mediators, EDN and Fault Handling

Framework).

Excellent in team collaboration, quick adaptation and problem solving with good communication skills.

Interaction with the offshore development team for development of reports and changes needed in the requirements.

Solid understanding & knowledge of SDLC, PMLC, Implementation and Upgrade Processes

Good knowledge in all the phases of Project Management Life Cycle (PMLC)

Strong in analyzing Business requirements, functional specifications and design documents

Excellent problem solving and analytical skills; with the ability to work in a team setting to resolve various problems.

Strong knowledge of business cycles, Procure to Pay (P2P), Record to Report (R2R), Acquire to Retire (A2R)

and Order to Cash (O2C).

Results oriented, self starter with the ability to adapt to dynamic, challenging work environment

WORK EXPERIENCE

MARSH & MCLENNAN, TORONTO, ON MAR 2012 – CURRENT

ORACLE APPS R12 TECHNO FUNCTIONAL CONSULTANT

Company and Role Summary: Marsh & McLennan Companies is the worldwide professional services firm providing

advice and solutions in risk, strategy and human capital. Worked on multiple internal projects as a Techno Functional

Consultant in Implementation, Upgrade, Customization and Support.

Project/Project Narrative: RMB (Revenue Management & Billing). Implementation and Rollout of Oracle RMB and E

Business Suite R12

Tools/Environment/Technologies: Oracle Apps R12, Oracle Application Framework (OAF) using Jdeveloper, BI

Publisher, Forms & Reports, Workflow, SQL Developer, Toad, XML, Java, Rational ClearQuest, CA Service Desk

Manager, Share point, WinSCP

Implemented AP, IBUY, iSupplier, FAH, FA and GL.

Analyze and design the payment model with creation of functional documents RD50, RD30, BR100, MD50.

Worked on the designed and development of Interfaces, Data Conversions, OAF pages, BI Publisher Reports,

Java Concurrent Program, Shell Script, XML Loader and Processor, PL/SQL, Customization of Forms & Reports and

SQL.

Collected and document users’ requirements and develop logical and physical specifications.

Defining web services, OSB & BPEL flow, designing Low Level Designs.

Integrating JMS, File and Database with Weblogic using resource adapters.

Developing BPEL Flows for various business processes in accordance with client requirements on AIA, BPEL and

OSB.

Designing and developing Error Handling framework .

Cross Testing with other modules/services

Configured and Customize Supplier Structure using DFF and custom tables.

Developed Supplier Conversion with XML Loader and Processor with custom Staging and Oracle Supplier

Standard Interface Import.

Worked on Customer Interface process using TCA API’s.

Integrated EBS R12 with Oracle Revenue Management and Billing, MART, GIDS to share, copy and maintain

common entities (like Supplier, GL Accounts), Invoices, Terms.

Worked with Wells Fargo to setup and configure WF Adapter module for payments (Wire, ACH, Check etc.)

Gather, document and configure Positive Pay and Rush Check with Bank Accounts using Oracle IBY payment

process profile (PPR) setups and used BI Publisher to create outbound file.

Implemented iSupplier modules with DMZ (Demilitarized Zone) and IBM Websphere reverse proxy.

Customized existing and developed new iSupplier OAF screens using Jdeveloper.

Worked on setting up WebADI Integrator for different operating units to upload Journal entries using Excel Template

and process it with backend pl/sql package.

Created OAF/ADF html pages to create, query and approve WebADI manual journals.

Designed and Developed Approval Workflow process using Oracle Workflow to provide notifications, escalations,

attachments, and rejections for all Inbound Financial Accounting Hub (FAH) Transactions.

Involved in creating FAH package to process journal entries such as PreBill, Installments, and Deferrals.

Also worked on Shell Scripting, XML Dom Tree and XSLT process.

Created PayTo, Vendor and other Web Services using R12 Integrated SOA

Worked on other components like Carrier Remittance Advice, Supplier Compliance with Bridger Insight, and

Standard Register process for Local Check Printing.

Provide support during UAT, Go Live and Post Go live.

Gained extensive knowledge of Oracle E Business Architecture, table structure, business flows and

Configuration Setups.

Used AIM to create MD50, MD70 and BR100 documents.

WIPRO TECHNOLOGIES OCT 2011 – FEB 2012

ORACLE APPS R12 CONSULTANT

Company and Role Summary: Wipro is a multinational IT Consulting and System Integration services company. I was

working for Client Telenor which deals in Telco sector with mobile operations across Europe and Asia. Worked as a

TechnoFunctional Consultant with analyse, design, customization, enhancement and support.

Project/Project Narrative: Order, Return, Inventory, Procurement and Compliance Management. Implementation,

Customization and Extension of Oracle E Business Suite 11i and GTM

Tools/Environment/Technologies: Oracle Apps 11i, Oracle Forms & Reports, Workflow, PLSQL Developer, Rational

ClearQuest, Putty, SSH.

Review and setup of new operating for OM, INV, AR, AR, GTM, and Procurement.

Analyse and create functional requirements with AIM documents.

Worked on Customization, Extensions and Support of Oracle Order Management (OM), Inventory (INV),

Accounts Receivable (AR), Global Trade Management (GTM).

Developed Customer Interface by invoking TCA API’s.

Customized and enhanced OM & AR interfaces for additional functionality and new requirements.

Integrated of Order Management and RMA with Custom Online OE & Return Management System.

Developed and created programs using Public API’s, concurrent programs, workflow, Forms, Reports and

host script.

Developed Order Entry Import interface using Oracle staging to process and complete the order.

Integrated Order Management with Global Trade Management (GTM) for global compliance and licensing.

Developed Item conversion/interface to import it from legacy system into Oracle Inventory using the Standard

Interface program.

Worked on Support issues like Booking, Scheduling, Licensing, Shipping etc.

Strong understanding of Order to Cash flow with business, technical architecture.

Extensively worked on RICEW (Report, Interface, Conversion, Extension and Workflow) components.

Created online dashboards using Oracle APEX for quick access to Orders status like stuck, scheduled, errors

etc.

MPHASIS LIMITED APR 2010 – SEP 2011

ORACLE APPS TECHNICAL CONSULTANT/EXPERT

Company and Role Summary: Wipro is a multinational IT Consulting and System Integration services company. I was

working for Client Seagate which deals in data storage with different products hard disk drive, flash storage and server

storage. Worked as a technical consultant with customization, enhancement and support.

Project/Project Narrative: Implementation, Customization and Extension of Oracle E Business Suite 11i and Integration

with external Systems

Tools/Environment/Technologies: Oracle Apps 11i, Oracle Forms & Reports, Workflow, PLSQL Developer, Rational

ClearQuest, Putty, SSH.

Customized existing forms to define system Profile Options, Descriptive and Key Flex fields.

Developed several forms using TEMPLATE.fmb and Customized standard forms through custom.pll.

As per the company requirements, created and implemented XML/BI Publisher reports.

Worked on modules AR, AP, GL, PO, FA, and CM.

Worked on Supplier and Invoice Open Interface program.

Integrated EBS with other systems using interface and web services.

Used Oracle Public API’s to create and load customers.

Developed AR Credit memo and AR Customers forms.

Built custom forms using Oracle Forms 9i/10g Builder to fulfil the business requirements of the client.

Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various

custom PL/SQL Packages, Procedures and Reports developed.

Developed technical design and test documents complying with Oracle AIM standards.

ORACLE FINANCIAL SERVICES DEC 2008 – MAR 2010

ASSOCIATE CONSULTANT

Company and Role Summary: Oracle Financial Services Limited is a subsidiary of Oracle Corporation. It is an IT

solution provider to the banking industry with integrated best in class and end to end solution.

Project/Project Narrative: Oracle Flexcube

Tools/Environment/Technologies: Oracle Forms & Reports, PLSQL Developer, WinSCP, Putty

Actively involved in code design in SQL, PL/SQL, Oracle Forms, and Oracle Reports etc.

Enhanced features of Loan and interest, CASA, EOD modules for Bancpost.

Involved in analysis, estimations, design and development of enhancements.

Worked as key team member for the enhancement & support of this project.

Support provided during UAT performed by Business units from Bancpost.

Gathering requirements, translating requirements into test case for UAT.

Managed post production issues arising after UAT.

XCHANGING SOLUTIONS LIMITED DEC 2005 – NOV 2008

SOFTWARE ENGINEER

Company and Role Summary: XCHANGING is a global business processing company. It also deals in worker’s

compensation business. Worked in modules Claims processing, Injury, Reserves, Payments, and Adjustments.

Project/Project Narrative: Ovation Kangaroo

Tools/Environment/Technologies: Oracle Forms & Reports, Toad, SSH, Putty, Oracle Forms 6i/10g, Oracle

Reports 6i/10g, Oracle Database 9i, Oracle Designer

Involved with the Business team for the requirement gatherings from Client.

Extensively worked in creating programs and screens using Oracle Forms 10g, Oracle Reports 10g, Sql, and

Pl/Sql.

Interacted with Client in Australia, and part of Business team in US.

Supported customers during UAT phase and provided satisfactory solutions.

Developed GUI screens (including PLL libraries, menus, Standard objects) using Oracle Forms 10g.

Key Developer for completion of some important modules like Reserves, Injury, Claim Adjustment etc.

Guided team members for completing work to follow product coding standards.

Involved in code review for the better quality.

Responsible to handle team for complete Accounting modules.

Wrote complex procedures, functions, database triggers for the application.

Involved in development of Outbound interfaces for file submissions to Workcover Authority.

Worked closely with testing team and involved in integration testing.

MIT JAN 2005 – JUN 2005

TRAINEE

Company and Role Summary: MIT is the ministry of Communications and Information Technology promoting the

inclusive and sustainable growth of the Electronics, IT & ITeS industries.

Project/Project Narrative: Talk2Me Messenger

Tools/Environment/Technologies: Java

It’s an instant chat messenger which helps in personalize chat and conference between a groups of users. Its key

features are displaying list of users in a tree view with different icons representing status of user, sending invitation

for conference to the selected group of available users, automatic generation of message if any user goes offline

in between during conference.

EDUCATION & CERTIFICATIONS

Bachelor of Engineering in Information Technology, 2005

TECHNICAL SKILLS

Applications / Databases Oracle Applications R12/11i, Oracle 11g

Tools Jdeveloper, Toad, Sql Developer, Putty, WinScp, BI Publisher, Oracle Forms & Reports,

Eclipse, Informatica, Workflow Builder, Integrated SOA Gateway

Languages Pl/Sql, Sql, Java, Shell Script, C, C++, HTML, Java Script, XML

Operating Systems Windows, Unix, Linux

Database Oracle

Methodologies Agile, Iterative, Waterfall

References available upon request

*** End of Document ***

Contact this candidate