Project Oracle

Mandeep Singh

CAREER SUMMARY:

. Around *.* years of professional IT experience in Oracle apps

technical Lead, Order Management and SCM related modules.

. Experienced in product development, implementation, upgrade and

support projects.

. Expertise in PL/SQL, Oracle reports, ODI, Web ADI, Interfaces,

Conversion and Extensions

. Strong knowledge in FIN and SCM modules of Oracle application like OM,

PO, INV, FA, AP and AR

. Strong knowledge of versioning tools like Share point, MKS integrity

etc.

. Strong application/ enhancement testing skills

. Strong analytical skills, solution providing skills and result

oriented

. Strong knowledge of Global delivery model and SDLC

. Good knowledge in Microsoft Office, Visio and MPP

TECHNICAL SKILLS

Technical Knowledge : PL/SQL, RICE development, Interfaces, Conversions

(ETL tools and PL/SQL), Extensions development, Web ADI,

XML Publisher, workflow and RDF reports.

Functional Knowledge : SCM Domain i.e. Order Management (OM), Purchase

Order (PO), Inventory (INV), Application Developer, System

Administrator.

RDBMS : Oracle 9i, Oracle 10g.

Tools : Toad, SQL Plus, Raptor, Mercury Quality Center 9.0, MKS integrity,

ODI data migration tool.

Projects Done : One complete implementation, two upgrade

project, one support project and one product development.

PROFESSIONAL EXPERIENCE

Project: Toshiba America R12 upgrade and IFRS compliance

Toshiba group has taken a decision that all of their American business

units will move their financial module to a single global application GAIA

on their defined rollout dates. All the open AR balances, AP invoices and

Journals will be moved to that global instance. During the conversion all

the accounts will become IFRS compliant having eleven core segments in it.

Post the rollout the data will be maintained in both instances via

interface. Also for the transactional entities to function properly in the

global instance as a prerequisite all the master entities (Supplier,

Customer and Employee) will be migrated to the Global instance beforehand.

Role: Oracle Apps Technical Lead

Location: Southern CA

Duration: Jan 2013 to till Date

Platform: Oracle 11.5.10, Oracle R12

Modules: Account Payables, Accounts Receivable, Order Management, Purchase

Order, Inventory

Responsibilities:

. Data conversion from 11.5.10 to R12 for Transactional and Master

entities

. Requirement gathering for the interfaces to run every hour for

interfacing the data

. Co-ordination with offshore team to delegate work

. Unit and Integration testing of deliverable

. Co-ordination with other vendors for completing the project

activities

. Provided customer delight by adding more values to their conversion

design

. Designing the Technical documents for the components.

. Testing the Converted Data and Interface functionality in various

rounds of CRP, SIT, UAT and Cutover

. Demonstrating client the functionalities of Interface

. Post go live support and hand over activities

Project: Toshiba Europe R12 upgrade and IFRS compliance

Toshiba group has taken a decision that all of their European business

units will move there financials to a single global instance GAIA on their

defined rollout dates. All the open AR balances, AP invoices and Ledgers

will be moved to that global instance. During the conversion all the

accounts will become IFRS compliant having eleven core segments in it. Post

the rollout the data will be maintained in both instances via interface.

Also for the transactional entities to function properly in the global

instance as a prerequisite all the master entities (Supplier, Customer and

Employee) will be migrated to the Global instance beforehand.

Role: Offshore Technical Lead

Duration: May 2012 to Dec 2012

Platform: Oracle R12

Modules: Order Management, Exchange rate, Oracle Reports

Responsibilities:

. Data conversion from R12 to IFRS compliant R12 instance for

Transactional entities

. Requirement gathering for the conversion

. Impact analysis on all the reports for IFRS compliance

. Lead team of five, assigned and prioritized task for them.

. Assisted in project planning activities

. Designing the Technical documents for the components

. Co-ordination with other vendors for completing the project

activities

. Testing of deliverables in various rounds of CRP, UT, SIT, UAT and

Cutover

. Was Configuration Controller for this project, bought the project

to CMM level 5

. Post go live support and hand over activities

Project: Air Liquide: Implementation/ Upgrade Evaluation

Air liquide Japan subsidiary comprises of 26% of Air liquide business. The

Japan subsidiary was working on an outdated version of SAP and wanted to

take the decision on their present IT infrastructure as in either to

upgrade their present SAP system or migrate to centralized R12 system. Our

focus was to evaluate the benefits and risk for both upgrade and

Implementation of R12 and also to provide them with estimation and project

execution plan.

Role: Technology Analyst

Duration: Feb 2012 to Apr 2012

Platform: SAP and Oracle 11.5.10

Modules: Account Payables, Accounts Receivable, Order Management, Purchase

Order, Inventory

Responsibilities:

. Analyze the risk and benefits of migration form SAP to Oracle

. Provide the estimation of the total project cost

. Demonstrating the similar functionalities between SAP and Oracle

. Designing the project plan

. Defining teams and planning the resources

. Custom delight by handing their complex functionalities with

standard oracle

. Demonstrating Infosys capabilities in the same space

Project: Apple Supply Chain Integration with IOP.

Apple Inc. wanted to implement a system that complements its Financial and

Supply Chain Integration. The main aim was to enable the alignment of key

operational plans with financial plans, thus helping make planning

decisions that are both financially desirable. As part of this project an

integrated business planning framework, that enables seamless metrics and

reports were created.

Role: Technology Analyst

Duration: May2011 to Jan 2012

Platform: Oracle IOP 3.1

Responsibilities:

. ETL framework to get the data from various sources such as

Demantra, SAP and Legacy system

. Analysis of the requirement and providing mapping of the between

IOP and various sources

. Co-ordination with other vendors for completing the project

activities

. Designing the Technical documents for the components

. Testing the Converted Data and Interface functionality in various

rounds of CRP, SIT, UAT and Cutover

. Making key matrices to across various functions to do What If

analysis

Oracle Corporation (Hyderabad, India)

Project: Oracle Fusion Migration Tool Development

Oracle is planning to launch its new application called FUSION (which is

the best breed of all new technologies and ERP's). Infosys being the

technology partner of Oracle is developing this tool called Oracle Fusion

Migration Tool Development. In this tool we will be able to convert the

Oracle EBS, Siebel CRM or Peoplesoft HRMS data to Fusion database with the

help of ODI tool. Our focus was to create those standard templates, which

will help in converting the data in an easier and faster way.

Role: Technology Analyst

Duration: Dec 2009 to Apr 2011

Platform: Oracle Data Integrator (ODI) 11g, Functional Set Up Manager

(FSM), Oracle Diagnostic Framework (ODF), Sql, Pl/Sql

Modules: Product Information Management (PIM), Purchase Order (PO)

Responsibilities:

. ETL framework to get the data from R12 and to load it into FUSION

. Analysis of the requirement and providing mapping of the between

R12 and FUSION for various modules

. Table Mappings and Additional Logic Implementation for PIM domain

. Designing solutions

. Testing the data migrated in Fusion PIM application

. Configuration Controller activities

Project: Arrow Electronics - Maintenance and Post Production Support

Arrow Electronics is a global provider of products, services and solutions

to industrial and commercial users of electronic components and enterprise

computing solutions. Arrow is one of the biggest R12 implementation done by

Infosys. The project included maintenance and support of global component

post ANZ go-live.

Role: Sr. Developer

Duration: Apr 2009 to Nov 2009

Platform: Application Desktop Integrator (Web ADI), Sql, Pl/Sql, MKS

version control system, Mercury Quality Center (MQC), People soft

Defect Management system (PPS), ODI 10g

Modules: Purchase Order (PO), Inventory (INV)

Responsibilities:

0. Understanding the user requirement and redesigning the custom

requirement

1. Getting the change request approved from user, development and

testing of the same

2. Implementation of defect prevention matrix

3. Resolution of the issues while testing the change request

4. Providing user the demo and the documentation for better

understanding of functionality

5. Resolution of the people soft tickets raised by the end user

6. Resolution of Setups and configurations issues causing the failure

of extensions developed

7. Logging SR with Oracle and taking it patch fixes

Project: Arrow Electronics -Global Objects (Extensions) and European

Rollout (Interfaces)

Arrow Electronics is a global provider of products, services and solutions

to industrial and commercial users of electronic components and enterprise

computing solutions. The project included extension of the standard

functionality around the PO Domain. The work mainly comprises of creating

custom requirements around Ship and Debit and Price Protection modules of

Oracle Trade Management. The European rollout project included the regional

requirements catered by creation of Web ADI and PL\SQL interfaces.

Role: Developer

Duration: Feb 2008 to Mar 2009

Platform: Application Desktop Integrator (Web ADI), Sql, Pl/Sql, MKS

version control system, Mercury Quality Center (MQC), People soft

Defect Management system (PPS), XML publisher reports

Modules: Purchase Order (PO), Inventory (INV), Application developer,

System administrator

Responsibilities:

. Requirement gathering and understanding the existing system

. Preparation of Technical Design

. Development of the extension as per the custom requirement

. Configuration & Testing

. Developing Web ADI layout to integrate the desktop utilities with

Oracle Apps

. Developing Interface program to implement TCL requirements for

Europe

. Development of Simple XML reports

. Understanding the user requirement for the interface development

. Testing the developed interface and presenting demo to client

. Preparing Training Manual and Imparting User Training.

. Logging SR with Oracle and taking it patch fixes

Project: Star Bucks Global Program - Reports

Starbucks Coffee Company is one of the world's leading retail of Coffee

house. The project involved integration of Star Bucks Sandy Run Roasting

Plant in to the current system by developing the reports providing the

desired information of plant production.

Role: Developer

Duration: Mar 2007 to Jan 2008

Platform: Sql, Pl/Sql, Microsoft version control system (VSS)

Modules: Order Management, Application developer, System administrator

Responsibilities:

. Development of RDF reports.

. Configuration & Testing.

. Business Requirement Validation.

ORGANIZATIONAL/PROJECT INITIATIVES

. Imparted training to fresher's on Order Management module of Oracle

. Imparted training pan Infosys on Web ADI technology

. Taken Buddy initiative for the new folks joining the project and

Chandigarh DC

. Active Anchor of Oracle Fun Club which takes initiative for making

work zone a little more fun

. Active member of the sports Club in Chandigarh DC for providing inputs

and raising voice to have better facilities

. Hosted Smavesh an annual Infosys initiative to bring out other talent

in employees

. Hosted programs Catch Them Young and Campus Connect for giving young

guns an exposure to IT

TRAINING & CERTIFICATIONS

. Undergone training for Oracle Applications from Infosys Technologies

Ltd. Chandigarh.

. 11i10 Application Developer - Oracle Implementation Champion

Certificate

. Oracle Corporation trained ODI 11g developer

EDUCATIONAL BACKGROUND

. Bachelor of Technology (B.TECH) in Mechanical from Punjab Technical

University with an overall aggregate of 67.4% in the year 2006.

. H.S.C from CBSE with an aggregate of 69.2% in the year 2001.

. S.S.C from CBSE with an aggregate of 67.6% in the year 1999.

. Certified Oracle professional.

Contact this candidate