Oracle Project Manager

ENIGMA Solutions and **** Shadowleaf Dr. Houston TX 77082 Tel: (281)

Design Inc. 924-5273

Resume of Mr. Swarna K. Duttagupta

SUMMARY:

. 19+ years of experience related to Information Technology and 12+ years

of experience as and Oracle functional consultant.

. Completed more than 9 live Oracle Applications full life cycle

implementation projects.

. Strong knowledge and experience (hands-on) in Procure to Pay, Order to

Cash and Financials business processes/flows, specifically R11i and R12

(12.0.6 and 12.1.x)

. Project Manager for a complex Global implementation of Oracle Financials

R11.5.9

. Project Lead for more than 5 complex Procure to Pay implementation of

Oracle Financials R11.5.x and R12 (up to and including latest features in

R12.1.x)

. Experience included 5 Inventory implementations, 1 in Account Payables, 2

in Order Management and Warehouse Shipping, and 1 in CMRO.

. 7-8 comprehensive full life-cycle Procure to Pay projects in R11.5.9,

11.5.10/11.5.10.2 and R12 (12.0.6/12.1.1/12.1.2)

. 8+ year of handling of complex design of Supplier Qualification,

Compliance and Performance

. 10 years or more of experience in analyzing procurement, contract and

vendor management process over the tenure of the 8+ Procure to Pay

projects.

. 10 years or more of Business Process Analysis/Re-engineering (BPA/BPR)

experience in procurement processes.

. Project Manager for a complex Global implementation of Oracle Financials

R11.5.9 at Staples

. Excellent communication, team building and team leader skills.

. Excellent documentation skills (more than 14 years) supplemented by years

of producing Functional and Technical documents to support project needs.

Skills Summary:

. Advanced Level experience and knowledge in: Purchasing, Sourcing,

iProcurement, iSupplier Portal, Procurement Contracts and Services

Procurement integrated with Order Management, Inventory, and Projects

. Strong experience and knowledge in: INV, PO, AP, OM, Shipping, BOM, WIP

and MRO

. Extensive knowledge in the modules: GL, AP, AR, FA, CE and Projects

Costing (integration with iProcurement and iExpense)

. Oracle Application Releases: 11.5.10 and 12.0 (12.0.6 and 12.1.x)

. Tools: Discoverer, DBI, Toad, OBM, Metalink/ My OracleSupport

. Languages: Complex PL/SQL and thorough knowledge of Programming

Constructs

. Team work with Key Users, Leaders, Developers, and Project Managers.

. Wide communication with the customer

. Methodologies & Documents: Oracle's Applications Implementation

Methodology (AIM), Oracle documents including: RD020, BP080, BR100,

BR110, BR120, MD050, BF125, BF015, CV050 BF120, T040 and UAT.

. Productivity Applications: MS Office, MS Project.

Oracle Apps Skills and Tools:

. Study of current business processes, future business flows and

identification of gaps and workaround.

. Business Requirements Mapping for Purchasing, iProcurement, Sourcing,

iSupplier Portal, Procurement Contracts and Services Procurement.

. Business Requirements Mapping for INV, AP, OM, WSH and CMRO modules.

. Designing Oracle Applications Inventory and Operating structure of client

organizations - Multi-Org Setup.

. Setup of Inventory, Purchasing, Account Payables, Order Management and

Warehouse Shipping.

. Oracle DBI: Use of Inventory, Purchasing and Order Management KPI's

. Data Migration from Legacy systems using API's and Open Interfaces.

. Customization of functional designs.

. Functional design of Discoverer Business Areas

. Preparation and execution of Conference Room Pilots (CRPs) as well as

final users training

. Testing modules' setup for inconsistencies and missing steps - Test

scripts and User Acceptance Tests (UAT).

. Log, view, access, monitor, follow-up and close Service Requests (SRs)

online - Oracle MetaLink and Oracle Applications Patch Management.

. Extensive working knowledge and compliance in accordance to Oracle On

Demand Policies.

EXPERIENCE:

Nitor Partners

05/10 - 08/10

Procure to Pay Process Lead/Project Manager

Engaged since beginning (now finishing) of May 2010 in a 4 month Procure to

Pay business process evaluation (BPA)/Business Process Re-engineering (BPR)

for the US division of DHL Germany (Deutsche Post DHL) here in Columbus

Ohio. The approach is taking a holistic and critical view of the current

Business Process and work towards a recommendation of stabilizing and

streamlining the current footprint, with the entire process being a stage

set also for a not-so-in-the-distant future upgrade to R12 of Oracle

Applications EBusiness suite of products

Zanett Commercial Solutions

02/10 - 04/10

Oracle Supplier Management & Contracts Design Project

Designed and delivered a comprehensive Customer and Procurement Contracts

solution for a medical services client of Zanett based out of Jacksonville,

FL. The footprint also involved a design solution involving R12.1.2

Supplier Management (Supplier Hub and Supplier Life Cycle Management) and

iSupplier Portal

IBM Global Business Services

05/08 - 01/10

Procure to Pay Lead

Oracle eBusiness Suite of Applications:

Engaged as an IBM GBS Consultant as a solutions specialist responsible for

implementing Oracle's Procure to Pay, including Procurement Contracts (main

lead/implementer) in a Supply Chain environment for a major Oil & Gas

company in Houston, TX. The project involved 22-24 modules of Oracle

Applications R12. Procure to Pay project lead with additional

responsibilities involving lead for Contract Management (Oracle Procurement

Contracts) process at client site, consolidation of "contracts in force"

around the globe (Global and Domestic contract Terms and Conditions).

Besides implementing Procurement Contracts - authoring and controls) in

Release 12 of Oracle Applications eBusiness Suite. Procurement Contracts is

a module in the Oracle R12 Advanced Procurement (12.0.6/12.1) suite of

products, and integrates with Purchasing, iProcurement, Inventory, Oracle

Sourcing, Services Procurement (EPC type Contracts and Services) and its

integration with Order Management, Oracle Inventory, Projects Costing,

Advanced Pricing and Payables etc. Executed successfully al design from

scratch, to conducting CRPs (Conference Room Pilots) (2 in all) leading to

exhaustive Unit/Integration testing, User Acceptance Testing (UAT) and

signoffs on functionality followed by on-time GO-LIVE in January 2010.

Managed off-shore team of IBM based out of India. Extremely thorough in

design test scripts. Test Plans in all the 5 key essential modules in this

project: Purchasing, iProcurement, Oracle Sourcing (all key feature

including Competitive Bids, Negotiations (direct and in-direct) and

Auctions including some of the key Release 12 functionality, iSupplier

Portal, Procurement Contracts and Services Procurement. Multi-national

rollout included video-conferencing based Interactive Design sessions,

workshops for 4 Design Validation Workshops, Organizational Alignment and

Change Management, Unit Testing and Integration testing (conducted

simultaneous across the globe - 9 specific OUs), design validation and

acceptance during Integration Testing and eventual G0-LIVE.

Complete involvement (right from the initial stage of conducting the first

Global Workshop, to Business Requirements gathering to translation into

Requirements Definitions leading to the final design/development (RICE

objects) and implementation of final solution. Completely hands-on all

setups and configuration, including that of the GOLD and Production system.

Various stages of Domestic and Global Testing for all Operating Units (OUs)

involving but not limited to extensive use of the 3 mainstay feature:

Competitive Bids, Direct Negotiation and Auctions. Noteworthy mention

includes implemented of Release 12.1 features as outlined below:

. Requisition to Receipt for the Procurement piece of the design ...

incorporating key client's Supply Chain product category based Content

Zones, punch-out to OfficeMax and use of extensive ASL based sourcing for

optimal Spend Management using "preferred Suppliers", exhaustive

Hierarchy Approval management process et al.

. Quantity-based price tiers functionality which offers different unit

prices for different quantity ranges. This allows buyers to suggest tier

structure and thus provides flexibility to suppliers to either respond to

tier structure defined by buyers or define their own structure. All in

all, this new feature allows to award where prices are selected from the

appropriate price tier, use of optimization to find the best award

scenario and create purchase orders with the awarded price tier price.

. Supplier Incentives, a feature that allow suppliers to provide bonuses or

rebates to buyers to transact or increase the spend amount with them

. The final award decision will include the supplier incentives including

fixed incentives which would represent signing or transition bonuses for

new suppliers, and also use of rebate tiers which would apply a different

rebate percentage based on level of spend for existing suppliers

. Additional features and enhancement in the Award Optimization process

like

. Constraint Priority

. Indicates the importance of different constraints

. Determines constraints that can be relaxed when no solution can be

found with all constraints satisfied

. Cost of Constraints

. Measures the cost of imposing a business constraint

. Calculates the difference in award amount when the constraint is

removed

. Scenario Analysis

. Provides side-by-side comparison of optimization results from

various scenarios

. Displays detailed breakdown of award amount and savings by supplier

and by line

Business and Decisions Inc.,

08/07 - 02/08

Procure to Pay Functional Lead

Implemented a working solution Purchasing and iProcurement (Procure to Pay)

iSupplier Portal, (including Procurement Contracts and services through

Services Procurement) - authoring and controls) in Release 12 of Oracle

Applications eBusiness Suite in a Process Manufacturing environment

(including Advanced Supply Chain Planning) for a Steel client in Wheeling,

West Virginia (August 2007 trough February 2008). The 7 month project

involved demonstrating the superior capabilities that exists in Oracle's

new revised Advanced Procurement suite for the Procure to Pay business

flow. Implemented salient/core features/functionality of R12 like:

. Extensive and full use of the new Professional Buyer's Workbench,

including Supplier authoring functionality

. Advanced content management, including Content Zones

. Catalog Bulk Load and Maintenance

. Comprehensive end-to-end execution of Procure to Pay business flow

(search an item ( create a req ( generate receipt in iProc ( Approve

and Pay Invoices and also view the transactions in iSupplier

Portal)

. Oracle Sourcing where use of Competitive Bids and Direct Negotiation

was implemented, Medium to Complex levels for handling of 2 Stage RFQs

with both Technical and Commercial evaluation process for

sourcing of specific categories of raw materials. Handled all setups

and configurations, being the only consultant for this role.

. iSupplier Portal core features - New supplier registration process and

also creation of a Supplier User including functionality of Supplier

Managed User maintenance.

. Services Procurement - implemented sourcing of services through

iProcurement (based of off service categories like Fixed Price

Services (Facilities Maintenance), and Resource Based Services

(Contingent Labor)).

. Order Management Setup, Configuration an Enablement - performed

necessary setups to facilitate orders in an ASCP model

. From a "business flow" perspective at least the Order to Cash and

Procure to Pay (included items, goods and services) flows were

executed end-to-end.

MASCO Contractor Services

12/06 - 07/07

Functional Lead

MASCO Contractor Services (division of MASCO based in Taylor Michigan,

manufacturer of Delta faucets and BEHR Paints) - Functional Lead (December

2006 through July 2007). Functional lead for implementation of the 7 basic

business flows that constitutes the 7 basic Business flows - Lead to

Sell/Quote to Sell, Schedule to Dispatch, Planning to Inventory, Billing

to Cash, Procurement and Finance to Reporting. The Vision to Reality

program mission is to redesign MCS business processes, reduce cost and

complexity, and implement a new Enterprise Resource Planning (ERP) system.

The Program will also include implementation of truck-mounted technology

for the MCS fleet. Spearheaded and conducted the automation of the scripts

for the 25-28 modules that constitutes the 4 major tracks for this project.

. Tested at least 15 modules and participated in the Unit, Business and

Integration testing of the following modules. The Integration testing

flow starts with the creation of a Quote from a lead to the generation of

a Sales Order to Invoicing the customer and finally the billing solution.

. Tested comprehensively working with the development and the functional

team 17 Interfaces (inbound, outbound and bi-directional) as part of the

Finance GO-LIVE. Planned the story-board for the Finance testing

...leading to creation of OKC & OKS (Core and Service Contracts) of key

areas of concern for the UAT. The UAT for Finance was conducted and

completed in a record time of 4 business days. Subsequent testing was

done in context of the different component of the middle-ware (SOA

specific MAEF, BAM Gateway and BPEL). Assisted in the re-validation of

key interfaces as mentioned above.

. Successfully wrapped up the Finance UAT to the satisfaction of MCS users

and obtained sign-off. Comprehensively tested 45-60 reports as part of

UAT testing.. Conducted issues and defect review meeting with Finance

GO_LIVE committee. On-time successful GO-LIVE of V2R Finance on time on

1st of August 2007.

. Setup and Configuration of Order Management: Mandatory and option setups

to facilitate Sales Order customizations and Blanket Sales Agreements as

also Back to Back Orders and Drop Ship processing. Customization of Sales

Orders and Blankets, Project Task changes for Booked Orders. Processing

for Multiple and Partial Payments, Catch Weights for Discrete Inventory

and use of Pricing and Availability functionality. Additional setups to

accommodate Advanced Pricing model in Order Management.

. Modules involved are GL, AP, FA, CE, AR, OM, PO, iProcurement, iSupplier

Portal, Oracle Sourcing, iSupplier Portal. Inventory, Advanced Pricing,

Order Management, Projects (Costing and Billing), Contracts (sales, core

and service) Oracle Apps version is 11.5.10.2, Oracle HTML Quoting et al

. Involved in/ conducted 3 rounds of Business Validation of the developed

solution, 3 rounds of Integration testing and for Finance User Acceptance

Testing.

. Business flows to which the entire implementation conformed to were at

least the following: Lead to Sell, Quote to Order, Plan to Inventory,

Order to Cash, Procure to Pay and Financials to Reporting.

Verigy Inc. 10/06 -

12/06

Techno-Functional Lead

Verigy Inc. (division of Agilent, based at their HQ in Cupertino/Santa

Clara, CA) - Testing and Cutover coordination (functional and technical)

lead for Global Rollout of 60+ Change Requests in an existing Oracle

Applications 11.5.10.2 instance. ( October 2006 through December 2006)

Execute comprehensively a 2 Release based rollout of Change Requests

(spanning, HRMS, Order Management, Fixed Assets, Payables, Receivables,

Sales, Sales Compensation et al) (conforming to the Order to Cash business

flow, end-to-end complete cycle) and other third party systems like

Ceridian and Vsource. The role involves working on finalization (through

multiple iterative

JAD reviews of functional design), coordination with Technical team leading

to completion and further JAD session reviews of completed Technical Design

docs, validation of completed code/CR and release to user Testers for

initial reviews. On completion of all CRs for Release 1, setup and

coordination testing for UAT. Setup and administered use of Mercury

Interactive's Quality Center 9.0/ Test Directory, for registration of all

Test Plans, Testing Strategy (Test calendar and Test lab and

resolution of all defects logged into Test Director. Daily conference calls

were held in the evening at 5:30 pm (Monday through Thursday) for the

global users (performing the testing in UAT). Testing and Status reviews

were conducted during this time with users (Europe, China, Japan, Singapore

and US), developers and project leads. Progress was reviewed, defects were

discussed and potential alternatives/workarounds addressed. Test Director

was used to its maximum capacity for e-mail based notification capability

for discussions of testing during the workday between the said participants

and effective testing and resolution of all defects. Project Plans were

drawn out cutover into production, via kickoff. Phase rollout of CRs were

controlled effectively through e-mail based triggering concept, indicating

what action was to be taken by which user to facilitate a smooth segue for

the entire process. Release 1 has been globally cutover into Production

(21+ CRs) and currently working on 10+ CRs for global rollout as part of

Release 2.

7-Eleven 01/06 -

09/06

Advanced Procurement Project Lead and Functional Consultant

7-Eleven - Financials and Procurement upgrade from 11.5.9 to 11.5.10.2

Project (World Headquarters at Dallas) - Advanced Procurement Project Lead

and Functional Consultant (Procure to Pay end-to-end complete cycle)

(January 2006 through September 2006)

Involved as the Functional IT Testing Procurement Lead Consultant for

Procure to Pay implementation with Projects (iProcurement, Purchasing,

iSupplier Portal and Sourcing). Responsibilities include design of new

testing scenarios, changed functionality consolidation; functionality

standardization...and creating unit and regression level test cases. Also

working on an Advisory (Subject Matter Expert) for the new implementation

of Oracle Accounts Payables, Receivable and Fixed Assets, as part of its

integration with storefront application TRIRIGA at 7-Eleven. Involved in

multiple design changes for iProcurement and Purchasing in 11.5.10.2,

involving changes to Workflow. Key differences in functionality between

11.5.9 and 11.5.10.2 ware identified and changes incorporate in a formal

document. Played a multi-faceted roll in the capacity of the GO-LIVE

committee. Besides core iProcurement and Sourcing and Procurement

Contracts features (negotiation, awards etc.) following iSupplier features

were implemented - PO Collaborative effort functions, advance shipment

(ASNs and ASBNs), Supplier User Management (all features), use of OAF (non-

AK Developer) for OAF specific personalization of UI Definition overlays

and saved Views (besides modification of FND message lookups and CSS).

Extensive design involvement involving Blanket Purchase Orders as also PPA,

Standard POs and Contract Purchase Orders. SmartForms were used and design

for certain specific IT purchases.

Hanover Companies

12/02 - 12/05

IT Manager

Oracle Applications 11.5.8 eBusiness Suite implemented in a 9iRAC Linux

based environment for the Hanover Companies in Houston, Texas. Designation

was that of an IT Manager for the Hanover companies. Modules implemented

were the entire oracle eBusiness Financials Suite (GL, AP, AR, FA, PO),

iProcurement, iExpenses, iCollections, iSupport, Oracle CRM based modules,

namely Incentive Compensation, Sales Online, Sales contracts, Oracle

Install base, Oracle ERP based modules PO, INV, EAM, BOM, OKS, OKE, ENG.

Played a pivotal role in jump-starting the Conversions for the Phase I, II

and III of Project UNITE. Provided analysis, design (BR.10 and BR100),

installation, and rollout of Oracle 11i General Ledger, Accounts Payable,

Purchasing, Inventory, Fixed Assets, iProcurement, iSupplier Portal,

Receiving, Payables, Oracle Install Base, Order Management, Collections,

MRP, BOM, Engineering and Quality for offshore (development team) and

onshore projects worldwide. Setups included Multi Language, Multi

Reporting Currency, Multi Organization. Coordinated and lead the entire

phase of the project which included initial operations analysis, business

process re-evaluation, testing, training, conversions, customizations and

documentation and implementation of modules Worked on validating through

multiple rounds the interface and data conversion programs for

applications. Addressed operational problems, concerns, and questions posed

by users. Laid the foundation for standards for technical design, build and

install of all Conversions and Interface modules. Oversaw and signed of on

all Technical design documents for the Hanover Companies. Streamlined the

co-ordination of 3 key implementation groups during the entire 16 month

project. Laid down standards for monitoring and maintained a 98% uptime on

the Production system, including 9 development and test servers. Maintained

and supported 11 instances including security and user accessibility during

the CRPs prior to Phase II go-live. Provided key support to Project UNITE

in implementing the initial portion of SOX compliant security

infrastructure for Oracle Applications 11i. Assisted in the development of

test scripts for unit and system testing

. Prepared and presented test results by providing metrics and graphs to

the central testing committee, from the innumerous rounds of testing

. Delivered high standards of testing even with stringent timelines

resulting in SMEs satisfaction. Coordinated test efforts including

resource allocation and planning Responsible for volume testing to ensure

proper load balancing of the system. Was a key Command Center player for

ensuring Operations Readiness prior to go-live for the domestic section

of implementation, termed Phase II. Improved 2 major business processes

that helped ensure timely monthly billing to the tune of 22 million

dollars. Worked on the design, testing and implementation of 6 key

business process enhancements through Oracle Workflow. Reviewed 37 key

Change requests that helped lower the cost of implemented the same by

over half a million dollars. Laid down coding and development standards

in terms of key packages and CUSTOM.pll enhancements for certain

customization of Forms based application extensions.

. Assisted in the stand-alone implementation of Oracle 11i HRMS and

Advanced Benefits for the Hanover companies. Amongst all the interfaces,

report & forms worked on the following were key, as they had a major

effect on the Domestic go-live effort for Phase II ( Note: these cover

practically every aspect of almost all the 18-19 major applications there

were implemented as part of the big-bang approach on July 7 2003)

(Project location: Hanover HQ at Houston, TX):

. PO Account Generator Workflow Customization

. Projects Account Generator Workflow Customization

. Oracle Sourcing - Complex design of sourcing of parts for maintenance of

products (Christmas Trees) for optimal use of on-truck and warehouse

inventory

. Oracle Purchasing Approvals design to facilitate speedy acquisition of

raw materials so as not to affect repair an maintenance.

. ADP Payroll Inbound Interface

. Unit Profit & Loss Project Interfaces:

. HCCA Interface Depreciation Expense to Projects Specification

. HCCA Interface Revenue Transaction to Projects Form

. HCCA Update Project Expenditure Items with Contract Number Asset Location

Exception Report

. iExpense integration with Payables

. OKS Auto Renewal Extension in Oracle Service Contract

. COGS Workflow Extension in Inventory

. COGS deferral by extending Oracle line level workflow (Billing Hold).

. Allow choosing multiple lines to defer/recognize when all lines option is

not suitable (e.g. deferring 4 out of 7 lines),

. Allow posting deferral/reorganization to an open period in the past -

when you use accounting rules the system uses system date as the GL date

and does not allow changing i

. PHH Interface Custom design & Build (Fuel surcharges for all company

vehicle

. Revenue Accounts Generator Trigger ( database trigger to derive the

revenue, receivables, freight general ledger accounting flexfield values

based on special rules on top of auto accounting rules) (Receivables

. Contract Billing Date Customization

. Customized OEOL workflow to accommodate our changes for 'Return To

Vendor' functionality. We have introduced a process between 'FulFill' and

'Close Line' activities of 'Lineflow - Generic Ship Only

. OM to OKS Interface Exception Report Design & Build

. Asset Location Exception Report

. Contract Renewal Report for Auto-renewal of Service Contracts

. Advanced Pricing

As IT Manager also responsible for conducting "business process analysis"

for analyzing and improving the Procurement, Contract and Vendor Management

process prevalent in Hanover. Effectively reduced cost for all IT

procurement over a period of 2.5 years by about 7%. Use of Oracle

Procurement modules/technology involving Strategic Sourcing for optimizing

procurement of goods from preferred vendors (ASL) and implemented

iProcurement to control maverick buys across all IT an across entire

Hanover enterprise wide.

All processes were documented and Guideline and Policies were implemented

in keeping with SOX requirements.

Oracle Consulting, Oracle Corporation

12/93 - 10/02

Technical Manager

. Technical Manager, Oracle Consulting (South Central Industries, Verticals

practice of Oracle Consulting)

. Oracle Applications 11i Upgrade assessment for Williams Energy Services

in Tulsa, Oklahoma. Tasks involved (but was not limited to) conducting

work-shop sessions for apprising the Purchasing team on the functionality

changes in the PO, INV, AP and iProcurement, modules, assessing the

upgrade effort. This was a two (2) week effort that could lead to future

upgrade opportunities.

. GL, INV and BOM (Apr - Dec 1999): Created the GL Journal Entries, Items,

Routings and Bill of Materials, Item Categories, Customer Items, Customer

Item Cross References, Quantity on Hand and Price List Conversion and

Interface Programs at a leading Building Systems Manufacturer in Houston.

Created technical documentation for all the conversions and interfaces

mentioned above. Oracle AIM, Oracle Applications 10.7 SC/11.0.3, SUN

Solaris 2.5.1 on SUN - 6000. Worked subsequently on the 11i

migration/upgrade plans for PO, INV and AP.

. Lead the Oracle Manufacturing 11i upgrade effort as part of the entire

Oracle Applications 11i upgrade efforts (11.0.3 to 11.5.7) for H B

Zachry, a major construction company in San Antonio, Texas. This was a

3.5 month effort that resulted in timely production. Responsibilities

also involved Production server sizing, architecture planning and

justifications, Oracle Workflow upgrade (2.5 to 2.6), DBA effort planning

and Program Office co-ordination efforts.

. OM, GL, AP, AR, INV, BOM, PO, iProcurement, Pricing, Costing, EDI, HR,

APS: Assumed the role of technical leader/functional advisor for a large

scale 11i Oracle Applications (11.5.6) implementation at SAS Institute

World HQ at Carey/Raleigh-Durham, NC. Managed a team of 12 developers

(third party consultants) in addition to 7 Oracle technical leads.

Despite the aggressive timelines for the project, delivered 30 + complex

integrations with third party systems in addition to a set of 30 +

workflow enhancements implemented for the individual modules. Oracle

Applications 11i, multi-org, multi-language and multi-currency, RDBMS

8.1.7, Sun Solaris 8, WebMethods, Vertex, TradeSphere, Shareplex, Noetix.

As a crucial player worked with PWC Consulting in the complete exhaustive

testing of the new application and performed capacity and performance

adjustments in the system for optimal stability.

. Internet Procurement SSP5 11i for a large computer manufacturer, Oracle

Exchange with Oracle Financials Rel. 11.5.6, 11.0.3 and BEA Systems

Messaging and Tuxedo Tools : Technical Team member instrumental in

customizing & extending the requisition/purchasing process via

automation of Oracle's iProcurement requisition creation, approval, PO

approval and PO delivery. Customized Workflow to extend P-card

functionality to incorporate controls on maverick buying by enforcing

approval hierarchies. These customizations included: PO Requisition

Workflow, PO Document Creation Workflow, PO Approval Workflow, Order

Acknowledgment Workflow and System Mailer Workflow; Content Management

from the perspective of Requisite database installation and use of its

tool; User Interface (UI) changes to give a custom look-and-feel;

customizations to collect and feed vendor and location information

obtained from regular feeds from a PeopleSoft HR system. From the

technical aspects served as point person for producing Current and Future

Technical Architecture Baseline documents. Installed and maintained the

iProcurement software (inclusive of Applications software patching)

through the life cycle, implemented a patch consolidation mechanism to

reduce the patching effort during a major upgrade and performed in-depth

problem resolution involving Apache, Jserv and Java in Oracle RDBMS

8.1.6. realm. Laid down development, coding and performance standards for

both the development and DBA teams to follow. Handled all key

infrastructure issues like installations, network, e-mail and LAN/WAN

issues and performance tuning.

. Internet Procurement SSP5 11i for a key energy solutions provider with

over 8,500 employees, 15,000 MW of power generation, 15 Bcf of daily

capacity, and 227,000 bbl of daily NGL production, This company maintains

11,300 miles of gas-gathering pipe, 14,300 miles of natural gas liquids

(NGL) pipeline and 64 million barrels of NGL storage capacity. Other

resources include 17 gas processing plants 11 gas-treating and liquids

extraction plants, and the largest energy trading floor of its kind in

the U.S. (Internet Procurement, iP (SSP5), Traderanger & Oracle Projects

with Oracle Financials R10.7 and Tibco Message Broker): Technical team

lead for installation of Internet Procurement and Supplier Management

Portal (Web Supplier), during a phased approach integrating with

Traderanger and iProcurement. Assisted and laid down standards for all

areas, covering Content Management, Workflow, TIBCO interfacing to

Traderanger (Supplier Punch-out) and key Oracle Applications Modules

namely AP,GL and PO. EDI XML Gateway etc. Production Capacity and Sizing,

including iProcurement Installations. Worked on resolving key Content

Management issues, incorporated Workflow customizations (Approval

Workflow), customization of UOM interfacing to meet ISO Unit of Measure

standards across the fire-wall with Traderanger. Key testing team member

involved in all aspects of testing: laying ground work/foundation for

testing scenario and validation of scenarios, creation of test scripts

and plans, setting up of test machine and data volume creation,

coordination of actual testing, (unit and system), exhaustive documenting

of results working with the Accenture functional and Williams team

members, fine tuning of system (functional system profile setups and

technical ) for performance and stability et al. Final steps involved

exhaustive Performance & Capacity Tuning effort that stabilized the

iProcurement system. Developed/designed custom interface to PeopleSoft HR

system for Property and Location feeds.

. Final steps involved exhaustive Performance & Capacity Tuning effort that

stabilized the iProcurement system. Developed/designed custom interface

to PeopleSoft HR system for Property and Location feeds.

. Project lead over implementation of Purchasing Intelligence EDW and

Financials Intelligence EDW for the initial analysis and planning phase

for Oracle's EDW 3.4.1. Responsibilities included planning, coordination,

interface with Strategic Implementation Program leads. Also handled a

subset of hands-on implementation tasks.

. Easy Migration Method: for a major player in the Petrochemicals industry

(Huntsman Chemicals ) with revenues of about $8.5 billion, more than

14,000 employees and facilities in 44 countries (Oracle Applications

10.5, 10.7 and HP/UX platforms). Technical team lead responsible for

developing a comprehensive Migration Assessment plan to facilitate an

upgrade /transition from Oracle Financials 10.5 Prod 8 to Oracle

Financials 10.7 Prod 16.1, Human Resource & Payroll Prod 8 to HRMS 10.7

and Oracle GEMMS 3.2 to GEMMS 4.1.

. Oracle Manufacturing Applications (INV, PO, BOM, WIP etc.) (DANA & Eaton

Hydraulics ) Technical team lead for a six member team of technical

consultants for Conversions, Interfaces and Customizations in Oracle

Manufacturing and Purchasing Applications and Financial implementation

project for major heavy trucks components (transmissions, axle & breaks

etc.) manufacturer. Instrumental in 5 plants going into production, over

a period of 18 months. Partnered with E&Y consultants and provided

valuable technical and functional knowledge . This included applications

conversions, designing interfaces and production responsibilities,

coupled with post-production support. This also involved creation,

validation and performance (as a core team member of CRPs) test scripts

and plans, exhaustive documentation of results leading to the complete

unit and system testing of the application, pre-Production.

. Oracle Architecture & Administration (GL, AP, PO, AR, FA, INV): for a

leading medical systems equipment manufacturer (GE Medical Systems,

Wisconsin) - (Oracle Applications 10.7 NCA, Oracle Financials GL,AP, PO,

AR, FA, INV etc. on SUN ES10K platforms) : Technical Team lead

responsible for developing a comprehensive Architecture Scope and

Strategy plan for GE Medical Systems Conversions and Interfaces processes

for their Mongoose OTR system. Responsible for providing assistance in

generating a two phase work-plan using AIM methodology for a multi-year,

multi-million dollar implementation. Assisted project team in GAP

identification and resolution. Also participated and was partially

responsible for Process Definition, Requirements Analysis, and

configuration for modules mentioned above, project standards creation and

maintenance, WWS co-ordination, Prototype Environment planning and setup,

project planning and status reporting to the Program Office committee.

. GL,AP, PO, AR, FA, INV and Workflow, for a leading utility (San Diego Gas

& Electricity) company - (Oracle Applications 10.7, Sun Solaris platforms

): Technical and functional lead of a team 4 people in developing a

competitive prototype in Oracle Financials, and Oracle Supply Chain for a

San Diego Gas & Electricity.

. CRM (TeleSales Agent/eBusiness Center, AR and TCA (Trading Community

Architecture Release 11.5.7,TCA Mini-pack HZ.I)( YMCA Corporate, Los

Angeles, a major health and fitness organization ) - (Oracle Applications, CRM, TeleSales Agent, Sun Solaris 4.x platforms ) : Technical design

and conversion of customer data from legacy system in keeping with

Oracle's TCA architecture. This involved conversion for Party type of

both Members (customers) and corresponding Organizations and the

relationship between the different parties.

. GL, AP, PO, AR, FA, INV etc. for the industrial control systems (GE

Industrial Control Systems/previously GEMIS) division of a major

corporation: Oracle Applications 10.7 on Sun Solaris platforms :

Performed extensive technical scope and architecture study and developed

technical architecture documentation for conversions from standard legacy

systems. Lead technical architect for the initial software and hardware

infrastructure layout/planning and ongoing architectural modifications.

Sarbanes-Oxlye (IT Governance & GCC Controls):

. Conducted for Hanover Compressors an exhaustive IT audit of controls,

help lay the foundation for establishing formal Policies & Procedures so

that Hanover can be SOX compliant for FY2004. Wrote key 30-35 policies

and procedures in areas, where critical controls were missing from the

aspect of IT and corporate governance

. Conducted IT audit for Metals USA (client) for two of their divisions,

wrote controls matrix steps for audit steps and wrote Policies &

Procedures to help the client comply with SOX for FY 2004.

. Working on validation/testing of Internal Controls for IT, remediation of

policies and procedures and testing of COSO/COBIT General Controls at

Dril-Quip in Houston.

Oracle Development Initiated - Product Testing:

. While working for Oracle Consulting, Oracle corporation (for 9 years), as

a Consultant we were constantly called upon by Oracle Production

Development team to test new releases. I was responsible for testing in

Oracle Applications, release 11.0.6, 11.5.6 and Oracle 11.5.8/9 the

functionality of GL, AP, Fixed Assets, Purchasing and iProcurement,

Inventory, Oracle Supply Chain, Oracle CRM Products (Install Base, Sales

Contract, Service Contract. Oracle Sales etc.). The job involved

reviewing existing test scripts, recommend changes where necessary to

include repeatable testing steps. Execute test scripts, report actual

results and conformity to standards, record defects and steps to

reproduce. This testing was exhaustive and complete

. Database Administration, for a leading computer manufacturer: Technical

Advisor to analysts in developing a an Enterprise backup and recovery

process for most major mission-critical servers for COMPAQ Worldwide.

Fine-tuned a 60Gbyte Oracle Application Financials 9.4 based application

running on Sequent Dynix/pTX UNIX based machines. This included complex

performance & capacity tuning. Devised a data compression method for

faster and efficient file systems / table-spaces bordering 2Gbyte in

size.

. Data Administration for a 11.5.3,11.5.6 multiple installation based

Oracle iProcurement implementation during the SDLC of the same product at

Compaq Computers ( annexed by Hewlett-Packard). This involved every

function ...right from configuration of servers, installation, daily

administration and backup. The key tasks included, but was not limited to

the following :

. Installing and Upgrading of Oracle Applications 11.0.x and 11i (single

node and multi node configurations) over various Operating System

platforms and also performing assessments for successful upgrades.

- Troubleshooting of Oracle Applications

- Oracle Applications conversion to Multi-Org and Multiple Reporting

Currency (MRC).

- Cloning from single node to multi-node or vice-versa, either using

adclone or proven successful methods.

- Applications patching, using adpatch and also customized patching.

- Applications maintenance using adadmin and other Oracle Application

tools.

- Applications Tuning, Migration, Troubleshooting & End User Support.

- Mentoring the Oracle DBA's and Oracle Applications DBA's.

CAPABILITIES:

Engagement Project Management Applications Implementation

Expertise Practice Management Business Intelligence

Business Process Modeling Beta Testing and QA Testing

Supporting Oracle Users Development Liaison

Applications Development

Data Conversion

Developing Interfaces

Applications & Oracle Rel 11i Advanced Supply Oracle Inventory

Modules Chain Planning. Oracle Order Entry

Oracle Bill of Materials Oracle Purchasing

Oracle Service (R11 and 11i) Oracle Application Object

Oracle Warehouse Management Library

System Oracle System Administration

Oracle General Ledger Oracle Contracts (R11i)

Oracle Accounts Payable Oracle Mobile Supply Chain

Oracle Accounts Receivable Applications

Oracle Workflow Oracle Trading Community

Oracle iProcurement 11i & R12.1 Architecture

Oracle EAM (Enterprise Asset Oracle Sales Online

Mgmt.) Oracle Incentive Compensation

Oracle Installed Base Oracle Service Contracts (OKS)

Oracle Service Procurement Oracle Sourcing

Oracle Procurement Contracts

Methods Oracle Applications Oracle Easy-Migration

Implementation (AIM) Methodology

Methodology (2.0 & 3.0) eRWin

Oracle Business Model flows Oracle Case* Dictionary/Case*

(Oracle proprietary) Designer

Designer 5.x

Technology Software, Tools & Languages Database

Oracle Warehouse Builder (OWB), Oracle DBMS (8, 7.3.4.4, 6,

Enterprise Data Warehouse (EDW 8.1.6, 8i, 9i)

3.x and 4.1), Oracle SQL Server 6.0

Applications Versions 11i (upto IBM DB2 2.x

11.5.8,11.5.9), 11.03, 10.7SC,

10.6, 10.5, 10.4, 10, 9.4, 9.3;

Forms Versions 4.5, 4.0, 3.0,

2.3; Graphics Versions 2.5; AOL;

Discoverer 3.1, PL/SQL/Java

Smart*Db/TAVIZ from TAVIZ

Corporation/Smart(used for

Conversion/Interfaces)

Oracle Enterprise Manager 2.2,

9i

Hardware & Operating Systems Networking : TCP/IP protocol

Red Hat Linux 2.1, 30.0, UNIX Internet Computing

(HP-9000)10.x/11.x, Sun Solaris Apache HTTP listener,

(2.6 to 4.1), IBM-AIX installation, configuration and

4.3.x,Windows 2000, NT 4.0, MS- tuning and training.

Industry & Retail/Dot Com Company - Internet Procurement (Self Service

Process Purchasing) Management.

Expertise Manufacturing - Oil and gas specific business involving high-end

gas compression equipments and fleet rental of the same

Manufacturing - Manufacturing - Inventory Management,

Purchasing, Creating Bill of Materials, Contract Management,

Business Intelligence (Data Warehouse),

Procurement Management, Advanced Planning

Automotive - Purchasing, Inventory Management, Bills of

Materials, Accounts Payables, General Ledger.

Manufacturing process in Diamond Industry.

EDUCATION:

. Project Management Basics (PMI Certified Course at Oracle Corporation)

. Project Management Mastery (PMI Certified Course at Oracle Corporation)

. Masters in Physics, Institute of Science, University of Bombay, India,

1984

. BS in Physics /Electronics Faculty of Science, M.S.University of Baroda,

India, 1981

. Associates in Computer Information & Technology, Datapro, Bombay, India,

1986-87

Certifications & Organizations:

. Oracle Master Certificates:

. Applications 8.1.x & 9i.x and 10g Database Management Track

. Applications (Financial and Manufacturing) Technical Foundation

. Oracle Boot-camp - Participated as an instructor for several Boot-camp

conducts. Led classes in Purchasing, Inventory, iProcurement, including

Oracle Apache Server 1.0.2 and 9iAS.

. Oracle Consulting AIM Methodology - Taught AIM to client personnel on

projects at GE Medical Systems, Dana & Eaton Hydraulics Inc. and Compaq

Computers (now HP). This was via comprehensive and interactive workshops

that provided a natural segue to the start of the first phase of each of

these projects

Contact this candidate