Geetu Madan

Oracle Apps Technical Consultant/ PLSQL

Consultant

Email: geetu.madan88 @gmail.com

Mobile: +1-551-***-****

Summary:

Over 7+ years of Extensive experience in Analysis, Design, Development, Testing, Implementation, Supporting and upgrading Oracle Applications/EBS 11i, R12 modules.

Extensive experience in Procure to Pay and Order to Cash business flows.

Sound Technical/Functional knowledge in Oracle Financials (AP,AR,&GL), Supply Chain Management

( SCM ) including Order Management ( OM ) and Inventory ( INV ), Purchasing ( PO ) and AOL .

Extensive experience in TCA architecture, MOAC .

Extensively worked on Oracle back end programming and Front end development using tools like Oracle Forms 10g/6.0, Oracle Reports 10g/6.0, XML/BI Publisher,Oracle Alerts, Forms Personalization, Custom.pll, Performance Tuning, SQl, PL/SQL, SQL Developer, TOAD.

Extensive experience in RICEW/CEMLI components ( Reports, Interfaces, Conversions, Extensions ) .

Experience in debugging, testing and deploying the applications, designed and developed interactive GUI screens and reports using oracle forms/reports and creating LDT files .

Strong programming experience in creating Procedures, API’s, Packages, Functions, Triggers and other database objects using SQL, PL/SQL, UTL_File and UNIX etc.

Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency by using Explain Plan and TKPROF

Experience in Application Object Library ( AOL ) such as creating custom responsibilities, custom menus, menus exclusion, form functions, Concurrent programs, creating value sets, profile options, messages, lookups, list of values, FlexFields etc.

Experienced in preparing Technical specs ( MD070 ), Installation Documents ( MD120 ), User Training Documents, Test procedures documents ( TE020 ) and Conversions ( CV060 ) using SDLC/AIM & Agile methodology.

Excellent in team collaboration (Onsite Offshore), quick adaption and problem solving with good communication and interpersonal skills.

Proven ability to lead and manage multiple end to end project implementations. Technical Skill Set Summary

Oracle Applications (EBS) Oracle Apps 11i, R12

● Financials GL, AP, AR

● SCM PO, OM, INV

CEMLI Components (OR)

RICEW Components

Configuration, Extension, Modification, Localization, and Integration

Reports, Interfaces, Conversions, Extensions and Workflow. Development Tools Reports 6i & 10g, XML/BI Publisher, Oracle Forms 6i, 10g Database Oracle 9i, 10g,11g and r12

Utilities SQL * PLUS, TOAD, Putty, Winscp

Operating Systems Windows XL and Unix/Linux

Academic Profile:

● Bachelors of Technology in Computers Science from MDU University, Haryana/India. Project Details

IBM (Dec 2014 to Sep 2017)

Client: American Express

Project Role Duration

American Express Application Developer Dec 2014 to Sep 2017. Implementation Areas: ERP Modules: (R12 upgrade) Financials ( AP, AR, GL) Supply Chain Management (PO,OM,INV)

About Client:

The American Express Company, also known as Amex, is an American multinational financial services corporation headquartered in Three World Financial Center in New York City.

. Responsibilities:

● Designed, developed, and tested the new ERP solutions, while upgrading the existing solutions

● Developed Several RICE/CEMLI Components in PO, OM, AR, AP and INV.

● Extensively used Standard API’s of OM, INV and GL Modules for various requirements.

● Responsible for creating Alerts, BI Publisher Reports in different modules.

● Responsible for preparing MD70, CV60, TE20 and MD120 documents.

● Developing functions, procedures and packages for the new and existing components.

● Responsible for creating LDT files for concurrent programs.

● Created guidelines for System Integration Testing(SIT) and User Acceptance Testing(UAT)

● Providing the production support to the business users. Geetu Madan Oracle Apps Technical Consultant 2

Deloitte Consulting (June 2013 to Dec 2014)

Client: RedHat

Project Role Duration

RedHat

Oracle Technical

Consultant

Apr 2014 – Dec 2014

Implementation Areas: ERP Modules: Supply Chain Management (PO,OM,INV) About Client:

Red Hat, is an American multinational software company providing open source software products to the enterprise community.

Responsibilities:

● Developed Several RICE/CEMLI Components in PO, OM, AR, AP and INV.

● Extensively used Standard API’s of OM, INV, PO, AP & AR Modules for various requirements.

● Responsible for creating interfaces, BI Publisher Reports in different modules.

● Responsible for preparing MD70, CV60 and MD120 documents.

● Developing functions, procedures and packages for the new and existing components.

● Providing the production support to the business users. Client: Motorola

Project Role Duration

Motorola

Implementation

Oracle Technical

Consultant

Jun 2013 to Mar 2014

Implementation Areas: ERP Modules : (R12 Implementation) Supply Chain Management (PO,OM,INV)

About Client: Motorola Solutions, is an American data communications and telecommunications equipment provider.

Responsibilities:

● Rationalized and enhanced the Motorola order management processes and systems

● Improved customer experience, process efficiency and operational margins Geetu Madan Oracle Apps Technical Consultant 3

● Identifying the best approach towards offering customers flexibility, maintaining

● Improved operational efficiency while reducing complexity of various product offerings.

● Worked on development, customization, and personalization of custom forms

● Worked on Extensions track for various standard processes

● Worked on POC requirements for OM, Purchasing, and Inventory modules

● Worked on Sales Order Interfaces using process order API

● Worked on concurrent programs creation

● Tested and reviewed code, and documented the various deliverables

Wipro Technologies(Dec 2010 to May 2013)

Project Role Duration

GIS Re implementation Oracle Technical

Consultant

Dec 2010 May 2013

Implementation Areas: ERP Modules : Supply Chain Management (PO,OM,INV) About Client: Grupo Industrial Saltillo (GIS) is a group of companies based in Saltillo, Coahuila, in northern Mexico, which manufactures and markets a variety of products for the construction, automotive and home markets. Responsibilities:

Oracle ERP Accountability:

● Re implemented, upgraded, and supported Oracle RICE components and Data conversion for Grupo Industrial Saltillo.

● Leveraged my design and development skills to re implement Oracle EBS in R12 from 11i, ahead of schedule

● Data conversion design and implementation from R11 to R12, Developed Item Conversion and Item Onhand Conversion.

● Retrofit and upgrade the RICE components from 11i to R12.

● Led the component migration on the Kintana Workbench

● Judicious understanding of the Oracle EBS 11i and Oracle EBS R12 systems led to the creation of systems that offer improved customer experience, process efficiency, and operation margins

● Unit testing and code review guidelines for existing and new members on my team

● Led the design and requirement gathering meetings with the business users for RICE components

● Preparation of MD070, CV060, TE020 and MD120 Documents.

● Post Production Support.

Geetu Madan Oracle Apps Technical Consultant 4

Contact this candidate