Post Job Free

Resume

Sign in

Oracle Project Manager

Location:
Overland Park, KS
Posted:
April 01, 2014

Contact this candidate

Resume:

Mahesh Kadaganchi

acdf3l@r.postjobfree.com

Contact 913-***-****

***** ******* **. ***:110 Overland Park, KS 66212

Professional Experience:

• I have over 16 years of experience in IT industry and more than 13 years in Oracle e-business Suite (Oracle

ERP).

• I have worked with prestigious companies such as Cochlear Limited, Macquarie Bank, Fuji Xerox, Toyota

Motors, Singapore Sports Council, Trans Island Bus Services, Singapore and Bank Indonesia.

• I have international exposure. Worked in Australia, Singapore, Indonesia, US, UK and India.

• I have good communication skills and a motivated team player.

• My previous employers were Red Rock Consulting, Cochlear Limited, Satyam Computer Services (

www.satyam.com ), NIIT Technologies (http://www.niit.com/tech ) and SQL Star International

(http://www.sqlstar.com/ )

ERP Experience: Oracle Applications (R12/11i/10.7)

• Procurement ( iProcurement, Purchasing, XML Gateway, Oracle Supplier Network, Supplier Life

Cycle Management, iSupplier Portal )

• Oracle Lease Management.

• Order to Cash ( OM, INV, BOM AR, GL )

Technical Skills:

• Oracle database development

• Strong SQL, PL/SQL skills.

• BI Publisher

• Oracle Development tools including Oracle Reports, Oracle Forms and Oracle Workflow builder

and Oracle Discoverer.

• APIs, Open Interfaces. Used mor4apps, Web ADI for interfaces.

• Worked with clients on requirement analysis, database design and testing.

• Written and conducted unit, functional and integration testing.

• Knowledge of Oracle Suite SOA AND OBIEE ( Attended online Trainings )

Awards and Recognition:

• Award for Innovation and Continuous improvement – By Cochlear Ltd

• Award for Excellence - By NIIT Technologies.

Roles looking forward to:

• Oracle e-business Technical Consultant

• Oracle e-business Techno Functional Consultant ( Procurement )

Education:

• BE (Computer Science and Engineering) – PDA College of Engineering, Gulbarga, India.

• MBA (Technology management) from APESMA-La Trobe University, Melbourne, Australia.

• PMP Certified– Project Management Professional.

5

Mahesh Kadaganchi Page 3 of

Mahesh Kadaganchi

acdf3l@r.postjobfree.com

Contact 913-***-****

10500 Barkley St. Ste:110 Overland Park, KS 66212

Red Rock Consulting, Sydney Jan’14 to

Mar’14

Client: DHL Supply Chain

DHL is doing away with Macartor System, which lies between WMS system and DHL Link (customer

facing system). Now, XML files to be sent to DHL Link would be generated using Oracle’s PL/SQL,

LOBs and its XML capability and dynamic SQL.

I am a technical consultant who developed proof of concept (POC) and built the production ready

code.

[ORACLE 11g, PL/SQL, XML, Dynamic SQL]

Dataweave, Sydney Oct’13 to Dec’13

Client: HealtheCare Australia

Healthe Care Australia undertook a major review of its prosthetic item procurement processes in

2012. The review was required because the annual Prosthetics spend for FY2013 is $49mil. There

was a concern that Healthe Care was not recovering the complete rebatable cost from suppliers due

to a) Manual processes used in ordering tracking and billing prosthetic items and b) Frustration with

current system in analyzing cost versus recover and general reporting

My Role as Oracle Procurement techno Functional consultant, enabled descriptive flex fields, created

materialized view from legacy system, developed custom reports using XML publisher and change

PO Print ( PO Output for communication ).

[ORACLE 11g, Oracle Applications Rel 11i PL/SQL, UNIX, XML Publisher ]

Red Rock Consulting, Sydney Aug’13 to

Oct’13

Client: Sydney Trains

This is an upgrade project from Oracle Forms and Reports version 6i to Oracle Forms and Reports

version 10g (10.1.2), upgrade Oracle Database Version to 11gR2 and Oracle Application Server to10g

Release 3 (10.1.3) .

[ORACLE 11g, Forms 10g, Reports 10 g, Webutil, Unix Shell scripts]

Cochlear Limited, Sydney Dec’07 to Jun’13

Cochlear, the leading global expert in implantable hearing solutions, offering cochlear implants for

adults and children who are deaf or affected by deafness or hearing loss.

Cochlear has upgraded their Oracle eBusiness suite from 11i to R12 .I was part of global procurement

team. My role was techno functional. I was involved in configuration, testing, and development.

Procurement module involved iProcurement, Core Purchasing, Buyers work center, iSupplier portal

and Supplier life Cycle management.

I was involved in various other projects

• R12 Upgrade Project.

5

Mahesh Kadaganchi Page 3 of

Mahesh Kadaganchi

acdf3l@r.postjobfree.com

Contact 913-***-****

10500 Barkley St. Ste:110 Overland Park, KS 66212

• HSBC Payments - Payment files to HSBC bank in XML format. Read Accounts payables ( AP )

tables to read data and create payment files.

• Approval Management Engine (AME). Custom approval hierarchy iProcurement. Read HR

hierarchy and include custom business rules.

• Oracle Supplier Network (OSN) – Outbound (Purchase Orders) and Inbound (Invoices).

• Punchout with Supplier.

• Mighty Max – Data migration from legacy system to Oracle database and an Inquiry System.

Various Roles while working with Cochlear

• Senior Technical Functional

• Customization and development using SQL, PL/SQL, Web ADI and workflow.

• Reporting using XML Publisher, Oracle Reports and Oracle Discoverer.

• IT Project Manager

• iProcurement and iExpense Training to users

• Support production (Procurement).

[ORACLE 11g, Oracle Applications Rel 12/11i PL/SQL, UNIX, XML Publisher, Web ADI ]

Oracle Leasing Implementation Aug’04 to Nov’07

Client: Macquarie Bank Limited, Sydney

Macquarie Capital has chosen to implement the Oracle Lease Management (OLM) system to replace

their core leasing systems – ComLease, STaRs Sales, STaRs Inertia, etc. OLM is a new Oracle

product, leveraging existing Oracle modules, e.g. Accounts Receivables, General Ledger

Role:

• Team Lead for developers and DBA.

• Conversion of Legacy System Data into Oracle Lease Management

• Customer Interface, Master Lease Agreement API, Contract Open interface, Contract Authoring,

Billing, Termination interface, Sales Order interface .

• Modified Workflow and Discoverer Reports.

Team Size: 16

[ORACLE 9i, Oracle Applications Rel 11i PL/SQL, UNIX]

Asian Logistic Centers Dec’99 to Jul’04

Client: Fuji Xerox Asia Pacific Ltd, Singapore

Description: This is basically beginning of consolidating logistic business and Inventory across the

globe. To begin with Fuji Xerox has started with Singapore and Malaysia. After successful integration

between these two countries, this may be extended to Thailand, Taiwan, Vietnam, and Philippines.

Role:

• Oracle Applications Technical Consultant.

• Writing Interfaces using PL/SQL, Writing Reports using Reports 2.5.

• Order Import, Delivery based Ship confirm, Item and BOM import, Material Transaction interface

(Miscellaneous Issue/ Receipt ), BOM Price Rollup, Auto Invoicing

• Web queries using Oracle’s HTP package.

• Post-production support

5

Mahesh Kadaganchi Page 3 of

Mahesh Kadaganchi

acdf3l@r.postjobfree.com

Contact 913-***-****

10500 Barkley St. Ste:110 Overland Park, KS 66212

Team Size: 8

[ORACLE 8.0, Oracle Applications Rel 11i/11.0 Forms, Reports, PL/SQL, UNIX]

Trans Island Bus Services Apr’99 to Dec’99

Client: Trans Island Bus Services, Singapore

Description: This is an Enterprise Wide Information System project being implemented over a period

of 18 months. It involves an integrated implementation of 17 applications including Oracle Applications

Release 10.7 (Oracle 8.0.3.2 and HP-UX) as part of the Financial Accounting System as well as

custom development of some modules. The Oracle Applications modules being implemented are GL,

AP, PO, Inventory and AR.

Role:

• Oracle Applications Technical Consultant.

• Building interfaces of retail sales module to various modules of Oracle Applications (including

Inventory, AR and PO)

• Developing screens in Forms 4.5, reports in Reports 2.5 and on stored procedures (PL/SQL).

Team Size: 10

[ORACLE 8.0, Oracle Applications Rel 10.7, Forms 4.5, Reports 2.5, PL/SQL, UNIX]

SFRS (Sports Facilities Reservation System) Apr'98 to Jan’99

Client: SSC (Singapore Sports Council), Singapore

Description: The system is used to facilitate booking and cancellation of sports facilities like

stadiums, open pitches, swimming complexes and sports halls around Singapore through the Internet.

This system is one of the first in Singapore to use e-commerce on Singapore One and enables secure

payment through a cash card. About 100 bookings are recorded on the system per week.

Role:

• Module Leader.

• System Analysis and design of the system, Database Design Using Designer 2000.

• Writing stored procedures and database triggers

• Developing Screens/Reports in Developer 2000 2.1.,

• Involved in Unit, Functional and Integration testing.

Team Size: 16

[ORACLE 8.0, Designer 2000, Developer 2000, PL/SQL, UNIX]

TMSD2 (TOYOTA Multi Source Distribution 2) Sep'97 to Mar’98

Client: TOYOTA MOTORS, Singapore

Description: This system will be used to automate their ordering, Shipping, Invoicing, and SMQR

system. This system has given new electronic transfer system called TNS-O.

Role:

• Involved in System Analysis.

• Writing stored procedures and database triggers.

Team Size: 10

[ORACLE 7.0, PL/SQL, Power Builder 5.0,WINDOWS NT]

DAMS (Debt Analysis & Management System) March'97 to Aug'97

5

Mahesh Kadaganchi Page 3 of

Mahesh Kadaganchi

acdf3l@r.postjobfree.com

Contact 913-***-****

10500 Barkley St. Ste:110 Overland Park, KS 66212

Client: Bank Indonesia, Jakarta, Indonesia

Description: The system deals with international loans, loan renewal dates, charges for renewing or

extending the repayment dates.

Role:

• Support DBA, writing stored procedures and database triggers,

• Developed screens and reports in Forms 3.0 and Reports 1.1. Trained people on Oracle.

Team Size: 6

[ORACLE 7.0, Forms 3.0, PL/SQL]

TMS (Training Management System) Jun'96 to Jan'97

Client: SQL Star International Ltd., Hyderabad, India

Description: This software was developed for a training institute. This Project deals with admission of

a student, starting of a new course, intermediate phases of the courses, examinations and results.

Role:

• Developed Screens and Reports in Forms 4.5 and Reports 2.5

• Trained to users on Oracle7.x and Developer2000.

5

Mahesh Kadaganchi Page 3 of



Contact this candidate