Oracle Project

Hemender Devangan

Oracle Application Functional Consultant

****************@*******.***

+65 84982844

Singapore

______________________________________________________________________________________

Summary

 Project Manager/ Project Lead/Production Support Lead/ Business Analyst / Oracle Apps Financials Functional / Pre Sales team member

 Total IT experience of 11+ years in Oracle Application/eBS R12/11i/11.03

 5+ yeas experience with Big 5 (BearingPoint, Cap Gemini Ernst & Young) and Oracle Consulting

 Various end-to-end (Financials, Procure to Pay, Acquire to Retire Assets life Cycle) implementation including requirement analysis, GAP fit, Prototype presentation, design, development, customization, testing, production support and user training in Oracle Applications.

 6.5+ years of Leadership experience, as leading small (6-8 members) to medium size (15-22 members) teams.

 Strong functional knowledge of Oracle Application modules R12/11i/11.03 in Financial (AP, AR, GL, FA), Distribution (OM, PO, INV), Oracle Project Accounting, Oracle Project Resource Management, Oracle Enterprise Installed Base/Oracle Asset Tracking, Oracle Time and Labor, iProcurement, iSupplier, Sourcing, iExpense, HR, Oracle Web ADI, Oracle Workflow, Oracle Alerts, BI/XML Publisher, Multi-Org, AOL and Oracle Apps system administration.

 Experience with Project Bid proposal process

 Good technical knowledge of Oracle Applications R12/11i/11.03 for Implementation, Upgrade, Customizations, RICEW (Reports, Interfaces, Conversions, Extensions, Workflows), Migrations, Enhancements, and Maintenance of Oracle Applications.

 Good exposure of AIMS methodology with developing Design documents (MD050, MD070s), Conversion (CV40s, 60s), Test scripts, Implementation “AS-IS”, “To Be” Process Documents i.e. Business process (BP80), Setup (BR100) documents

 Extensive experience in planning, managing, and coordinating offshore custom development, integration, and testing efforts. Well conversant with using Version Control (PVCS), Migration tools (Kintana), FNDLOAD for moving code, and AOL objects from one instance to another.

 Worked for clients within Financial, Manufacturing, automobile, entertainment, high-tech, retail, services and telecommunications industry.

Skills & Technologies

Oracle Applications R12/11i (11.5.9/11.5.x)/11.03 Accounts Payable, Accounts Receivable, General ledger, Fixed Asset, Project Accounting, Project Resource Management, Order Management, Inventory, Oracle Purchasing, iProcurement, Human Resources, Oracle Time and Labor, Oracle Enterprise Installed Base/Oracle Asset Tracking, Install Base, and Service Contracts, iSupplier, Sourcing, iExpense, Multi – Org, Application Object Library (AOL), Oracle Workflows, Oracle Alerts, System Administration

GUI Tools Developer 2000, Developer 6i, Forms 4.5/6i, Reports 2.5/6i, TOAD, SQL Navigator, Data Loaders, Workflow Builder, JDeveloper, XML Publisher, Kintana, PVCS

Programming Languages ORACLE PL/SQL , SQL*PLUS , SQL*Loader, UNIX Shell Programming

Databases Oracle 10g/9i/8i/8.x

Methodology, Applications standards: Oracle AIM (Applications Implementation) Methodology, Oracle Coding Standards, User Interface standards, AOL Standards

Operating Systems Windows NT, Windows 2000, Sun Solaris, Red Hat Linux, HP-UX 11.11

Other Software Fulcrum’s CATS (Cellular Asset Tracking System)

Employment Details

1. Accenture, Singapore since May 2010 to till date

2. Rite Software and Solutions LLC, Houston, Texas since September 2007 to November 2009

3. BearingPoint (KPMG Consulting) Inc, Austin, Texas since January 2005 to September 2007

4. Alphasoft Inc, Walnut Creek, CA since June 2004 to January 2005

5. Oracle India Pvt. Ltd., Bangalore, India since June 2003 to June 2004

6. Wipro Technologies, Bangalore, India since January 2003 to June 2003

7. Cap Gemini Ernst and Young, Mumbai, India since May 2002 to December 2002

8. FCS Software Solutions Pvt. Ltd. ,Noida, India Since December 1999 to April 2002

Experience

Fuji Xerox May ‘10 – till date

Functional Lead Consultant – Accenture, Singapore

Project Summary

Oracle Application 11.5.10 rollout for New Zealand region for modules AP, AR, GL, FA, Project Costing, PO, OM, Inv

Responsibilities

• Implementing AP, AR, GL, FA, Project Costing, PO, OM, Inv for New Zealand region

• GAP Analysis for all modules

• Proposed Business process change

• Completed Application setups for all modules

• Setup users, created responsibilities for different users

• Completed CRP, UAT testing with users

• Completed Training to Users

• Prepared BR100, MD50, MD70, CV40, TE20, and TE50

• Done performance tuning for custom conc. Program and queries using trace and TKPROFs

• Supporting all implemented modules

Environment: Oracle Applications (Financial) 11.5.10, Oracle 9i, Oracle Reports 6i, SQL, SQL * Loader, PL/SQL, OAS, Windows NT/Unix

Modules: Payables (AP), General Ledger (GL), Purchasing (PO), Fixed Assets (FA), Receivables (AR), Project Costing, Order Management and Inventory

Gulf States of Toyota, Houston Tx Apr ‘09 – Nov’09

Functional Lead Consultant – Rite Software, USA

Project Summary

Implemented, enhancement and supporting of existing oracle apps modules AP, AR, GL, FA, Project Costing, Billing and Resource Management, PO, iProcurement, iSupplier, Sourcing, iExpense

Responsibilities

• Implemented Oracle modules AP, AR, GL, FA, Project Suite, PO, iProcurement, iSupplier, Sourcing, iExpense

• GAP Analysis for all modules

• Proposed Business process change

• Completed Application setups for all modules

• Setup users, created responsibilities for different users

• Completed CRP, UAT testing with users

• Completed Training to Users

• Prepared BR100, MD50, MD70, CV40, TE20, and TE50

• Done performance tuning for custom conc. Program and queries using trace and TKPROFs

• Supporting all implemented modules

Environment: Oracle Applications (Financial) 11.5.10, Oracle 9i, Oracle Reports 6i, SQL, SQL * Loader, PL/SQL, OAS, Windows NT/Unix

Modules: Payables (AP), iExpense, General Ledger (GL), Purchasing (PO), iProcurement, Sourcing, Fixed Assets (FA), Receivables (AR), XML Publisher, Project Suite, iSuppliers

LEAP Wireless (Cricket communications Inc), San Diego CA May ‘08 – Apr ‘09

Functional Lead Consultant – Rite Software, USA

Project Summary

Phase II implementation of Oracle Inventory, Purchasing, iProcurement, Payables, Receivables, General Ledger, iExpense, Oracle Time and Labor, Project Accounting, Fixed Assets and Oracle Asset Tracking/ Oracle Enterprise Installed Base System with third party software CATS.

Responsibilities

• Implemented Phase II for Oracle Asset Tracking solution with Procure to Pay and Acquire to Retire Assets

• Completed Application setups for all modules

• Completed CRP, UAT testing with users

• Completed Training to Users

• Prepared BR100, MD50, MD70, CV40, TE20, and TE50

• Supported Financial month end process for auditing purpose

Environment: Oracle Applications (Financial) 11.5.10, Oracle 10g, SQL, SQL * Loader, PL/SQL, OAS, Windows NT/Unix

Modules: Oracle Install Base (IB), Oracle Asset Tracking (OAT/EIB), Payables (AP), iExpense, General Ledger (GL), Purchasing (PO), iProcurement, Fixed Assets (FA), Project Accounting (PA), Inventory (Inv), Receivables (AR), Oracle Time and Labor (OTL), Oracle Web ADI

Texas Parks & Wildlife Department, Austin TX Apr ‘08 – May ‘08

Functional Consultant – Rite Software, USA

Oracle Applications (11.5.10) Project Summary

TPWD is doing implementation of HR, Grants, Purchasing, GL, FA, and Project Accounting.

Responsibilities

• Implemented Grants and Project Accounting including CRP and User testing

DELL Corporation, Austin TX Sep ‘07 – Mar ‘08

Functional Consultant – Rite Software, USA

Project Summary and Responsibilities

DELL implementing Oracle R12 for cost accounting solution with keeping minimum number of manual entries currently processed by S&P Finance, improves reconciliation and aging capabilities, and improves the efficiency and accuracy of accounts payable matching.

Implementation of Software and Peripherals (Proof of concept for future Implementations)

• Did requirement gathering phase

• Created System maps for existing systems

• Designed and developed the programs to import Standard PO, PO Receipts, and Suppliers

• Created custom program to upload value sets in GL

• Setups for GL, AP, PO, Inv

Environment: Oracle Applications (Financial) R12, Oracle 10g, Oracle Workflows, SQL, SQL * Loader, PL/SQL, OAS, Windows NT/Unix

Modules: Oracle Payables (AP), Inventory (Inv), Purchasing (PO), iProcurement, General Ledger (GL), Multi- Org, iSetup, Oracle Projects (PA) ,AOL ( Application Object Library)

AIM Investments, Houston, TX Apr ’06 - Oct ‘06

Functional Lead Consultant - BearingPoint Inc, USA

Project Summary and Responsibilities

• Implemented Oracle Enterprise Install Base system including setups for EIB, FA, Inv, PO, PA

• Designed conversion strategy for Asset and Item conversion

Environment: Oracle Applications11i (11.5.10), AOL, Oracle 9i, SQL, PL/SQL, Windows NT/Unix

Modules: Oracle Install Base , Asset Tracking (OAT/EIB), Payables (AP), General Ledger (GL), Purchasing (PO), iProcurement , Fixed Assets (FA), Project Accounting (PA), Inventory (Inv)

LEAP Wireless (Cricket communications Inc), San Diego, CA Mar ‘05 – Apr ‘06

Oct ‘06 – Sep ‘07

TechnoFunctional Lead Consultant – BearingPoint Inc, USA

Project Summary and Responsibilities

Implemented Oracle Applications 11i modules (Oracle Enterprise Install Base, PA, FA, GL, Inv, AP, iExpense, OTL and PO).

Implementation of Oracle Applications for LEAP Wireless

• Implemented Oracle Inventory, Purchasing, Project Costing, Asset Tracking, Fixed Assets

• Prepared BR 100, MD70 for critical outbound Interfaces (POs, Vendors, Items, Locations, Project and Tasks), Receiving Inbound Interface, Items Conversion, Asset Conversion and Asset Retirements

• Prepared BR 100 and CV40 to convert Oracle Projects, Tasks and Budgets in PA and Conversion of Assets from Legacy system into Oracle Assets using Mass Additions Interface

• Proposed solution for grouping of Asset Lines by Customized standard ‘PRC: Generate Asset Lines for a Single/Range of Projects’ in PA and Customized Oracle standard package to change rules to create Projects Asset Header in PA

• Prepared MD70 for custom Concurrent program to create automatically Projects Asset Header in PA

• Setting up Oracle Projects including System Options (Implementation Options and PA Periods)

• Define Project Types, Statuses, Service Types in PA

• Define Expenditure Categories, Expenditure Types and Transaction Sources in PA

• Customized client extension PA_CLIENT_EXTN_GEN_ASSET_LINES in PA

• Created custom program to reversed the Project Expenditure in PA

• Developed Asset Tracking automated process using EIB APIs (Project Item Installed, Project Item Uninstalled, Project Item In Service, In Service, Out of Service, Item Move)

• Done Mass Populate Securing Attribute by directly inserting into table ak_web_user_sec_attr_values

Environment: Oracle Applications11i (11.5.9), AOL, Oracle 9i, Workflows, Forms 6i, Reports 6i, SQL, PL/SQL, OAS, Windows NT/Unix

Modules: Oracle Install Base (IB), Asset Tracking (OAT/EIB), Payables (AP), iExpense, Oracle Time and Labor, General Ledger (GL), Purchasing (PO), iProcurement, Fixed Assets (FA), Project Accounting (PA), Inventory (Inv), CATS (third party tool)

USG Inc., Chicago, IL Jan ‘05 - Mar ‘05

Oracle Applications11i (11.5.9) TechnoFunctional Consultant – BearingPoint Inc, USA

• Developed a custom report in AP,AR,PO

BMC Software Inc., Houston, TX Aug ‘04 –Dec ‘04

Oracle Applications11i (11.5.9) TechnoFunctional Consultant – Alphasoft, USA

• Developed a custom workflow in Oracle Time and labor and customized PO Approval workflow

7-Eleven Inc., Dallas, TX Jun ‘04 - Aug ‘04

Oracle Applications11i (11.5.9) TechnoFunctional Consultant – Alphasoft, USA

• Developments of Alerts and customized PO Approval workflow

American Tire Distributors Inc., Charlotte Mar ’04 - May ‘04

Lead TechnoFunctional Consultant – Oracle Corporation, Bangalore, India

• Developed custom objects in Inv and OM modules in Oracle Applications11i (11.5.9)

Imagistic Inc., Connecticut Oct ’03 - Feb ‘04

Lead TechnoFunctional Consultant - Oracle Corporation, Bangalore, India

• Supported customizations and extensions (Reports and PL/SQL program) to the AR, IB, OM, PO , Service Contracts Modules in Oracle Applications11i (11.5.9) and Oracle 8i

Rogers Group Inc., Nashville, TN Aug ‘03 - Oct ‘03

Techno-Functional Consultant - Oracle Corporation, Bangalore, India

• Developed Conversion program HR in Oracle Applications11i (11.5.9)

Diebold Inc., North Canton, Ohio Jul ’03 - Aug ‘03

Technical Consultant - Oracle Corporation, Bangalore, India

• Developed the custom form View Source link and Sourcing Override in Oracle Applications11i (11.5.9)

BlackRock Inc., NY Jun ’03 - Jul ‘03

Technical Consultant- Oracle Corporation, Bangalore, India

• Developed Conversion program HR – Payroll Back feed Interface in Oracle Applications11i (11.5.9)

Cisco Systems Inc., CA Jan ‘03 - Jun ‘03

Technical Consultant – Wipro Technologies, Bangalore, India

• Migrated the SQL Scripts, Reports 2.5 to Reports 6i, Forms 2.3 to Forms 6i from Oracle apps 10.7 to Oracle Applications11i (11.5.7)

Lead Technical Consultant – CGEY, Mumbai, India May’02 – Dec’ 02

Developed custom reports, conversion and interfaces in PO, HR, GL for the following clients

1. Continuum Health Partners Inc., NY

2. Neiman Marcus Inc., Dallas

3. Mattel Toys, WI

Technical Consultant – FCS Software Solutions, Noida, India Dec’99 - Apr ‘02

Worked on Oracle Applications 11.0.3 for the following clients

1. Production Resource Group, NY

2. efundSystems, Marshall

3. FCS Software Solutions, Noida, India

Education

Master of Computer Application (MCA), 1999 from MD University, India

Contact this candidate