Oracle Apps Technical Sandip

Sandip’s Resume

Page 1 of 10

Sandip Dey

Professional Summary: Sandip Dey having 3.2 years of experience in IT industry in which 3 years with Oracle Applications E-Business Suite Release 11i (Version 11.5.10.2) as a Technical Consultant and Oracle D2K developer. Coming to the Live Project Experiences, Sandip Played an active role in four full life cycle Implementations of Oracle Applications EBS using SQL, PL/SQL, Forms 6i and Reports 6i, with hands-on working experience in developing various RICE Components (Reports, Interfaces, Conversions and Extensions). Sandip worked on PII Implementation Project , VETCO Gray Oracle Implementation (client GE Oil & Gas), Singapore Rollout and India Localization (client GE Health Care) and EDD CMF Simplifica- tion & Data Conversion ( client GE Energy); through these projects he got a great exposure on Oracle Apps with Inventory, Bill of Materials, OM, PA , PO, GL Modules as a pure Technical. Knowledge of functional overview of Inventory and BOM Modules. Good experience in Oracle PL/SQL coding and familiar with the third party tool TOAD. Good technical background with good communication skills and act as a team player with integrity. Can learn quickly new technologies, think creatively and solve problems in a critical environment.

Education: Degree B-Tech H.S.(10+2) Secondary(10)

University W.B.U.T. W.B.C.H.S.E. W.B.B.S.E.

Year of Passing (06/2006) (03/2001) (03/1999)

Experience: Organization Satyam Computer Services Ltd.,

Designation Oracle Apps Technical Consultant

Duration Nov,2006 – till today

Technical Skills: Sandip is familiar with the modules like INV, BOM, PO, OM, QA, GL, PA etc. Having Technical expertise in Oracle 8i, Oracle 9i, Oracle10g database, Forms

Page 2 of 10

Sandip’s Resume

6i, Report 6i, Form Personalization and Shell Scripting. Proficient in writing stored procedures, functions and packages.

Hardware Operating Systems

Win 98 SE , Windows 2000 Professional ,Windows XP Professional

Languages

Oracle SQL, PL/SQL, Shell Scripting, JAVA, Pro*C and Programming In C etc.

Databases

Oracle 9i , Oracle 10g

GUI

Forms 6i , Reports 6i , XML Reports and Oracle Apps (v11.5.10.2)

Case Tools Web Related



Tools & Utilities

Oracle9i Jdeveloper , TOAD(v7.6 & v8.5), SQL Developer , PL/SQL Developer, SQL * Loader, Data Loader ( Use for Functional Work ) etc

Domain Knowledge

Manufacturing ,Oil & Gas and Health Care

Certification Skills : Organization Oracle India Pvt. Ltd.

Certification Name Oracle OCA Certification

Date 19-Apr-2008

Trainings: Sandip Dey has worked on Oracle 9i, Oracle Apps (v11.5.10), java and has executed a banking management project by “Oracle 9i”, Mailing system by “Java” and “Sales Order Purchasing” case study by Oracle Apps v11.5.10 during the training at satyam computer services ltd. Well versed with RDBMS concepts and also equally good at C and data structures, operating systems and internet concepts. Has good knowledge of HTML, java script .He is strong in developing system tools and system application using C. He has worked on Windows 98, Windows XP platforms. He is conversant with Satyam's ISO 9001 quality procedures, while executing his projects. He is “Satyam Way Certified as well as QMS, IQMS, 6Sigma Certified”.

Sandip’s Resume

Page 3 of 10

Projects Profile: 6.

Project Name : EDD CMF Simplification & Data Conversion Project ID

: 09004811

Client Role Organization Duration Team Size: 10

GE Energy Offshore Lead Satyam Computer Services Ltd (04/2009) – (till today) Project : ERP Design and Delivery (EDD)

Environment (with skill versions)

Software Oracle 10g, Apps(11.5.10.2), Data Loader , PLSQL Developer, TOAD v8.5

Hardware

Module :INV,BOM,OM,PO, PA etc. Languages : SQL,PL/SQL, Shell Programming, SQL*Loader Database: Oracle 10g Tools: Data Loader ,PLSQL Developer, TOAD v8.5 ERP : Oracle E-Business Suite ( v 11.5.10.2 ) O/s : Windows XP Professional . Intel Pentium 4 processor, with 1GB RAM

Project Description: The GE Entergy services wants to build a standard platform by which they want to do the Data Conversion from legacy to Oracle eBS. So, the DCT is introducing us a platform to do the data conversion irrespective to the P&Ls (Profit and Loss) across the GE Energy business. DCT is integrated in Oracle Apps and can be accessed by oracle eBS designated user. DCT will provide us (business users) a very intelligent and user friendly interface by which we can handle the maximum conversion objects within a short period of time and with high accuracy. The DCT will provide a structured, user friendly and intelligent interface by which Small/ Medium/ Large scale data conversions can be done in various GE Data Conversion engagements. The DCT tool allows conversion of any legacy data when a P&L switches to the Oracle ERP from any legacy system. Contribution • Development and Testing of Forms 6i, Packages, Stored Procedures, Functions and Shell Programs. • Development of Technical Design Documents (MD40’s, MD60’s, MD 70’s, CV200’s, TE20’s). • Creating Custom tables in Custom Schema and giving access to APPS schema. • Loading of data from legacy system to custom tables using SQL LOADER. • Registering Custom Forms, Functions, Menu, Responsibility, Request Group, PL/SQL Stored Procedures, Custom Reports, and Host program in apps as a part of AOL Registration.

Sandip’s Resume

• • • •

Page 4 of 10

We wrote shell program to send mail with the Report output as an attachment. Creating FND Load files of Concurrent Programs, Reports and Form Personalization to go hade towards the Production Instance. Along with that we have to do the setup on DCT for 16 conversion objects. I handled Inventory, Bill of Materials, Purchase Order, Projects conversions. Testing - unit testing

5.

Project Name : DI Intl India Localization Project ID

Client Role Organization Duration Team Size: 10 Environment (with skill versions)

: 08021641

GE Health Care Team Member Satyam Computer Services Ltd (08/2008) – (03/2009) Project : GEMS ERP Implementation Module : QA, BOM, INV etc. Software Languages : SQL,PL/SQL, Shell Programming Oracle 10g , Database: Oracle 10g Apps(11.5.10.2), Tools: Data Loader ,PLSQL Developer, TOAD v7.6 Data Loader , PLSQL Developer, ERP : Oracle E-Business Suite ( v 11.5.10.2 ) TOAD v7.6 O/s : Windows XP Professional . Hardware

Intel Pentium 4 processor, with 1GB RAM

Project Description: In this project the GEHC having his own Business across the world. Now they want to create one new Operation unit (Singapore Operation Unit) and add this as a distribution operating unit with their existing Business. Basically the Requirement was to create the PTOActive Items under the new Organizations and related all the BOMs. To upload Items and BOMs from Flat file to staging table, we used SQL LOADER program. After that we did Item and BOM Conversion also. Apart from this we need to create 12 reports among those Report 4 Reports ware New Custom Reports on WIP, INV modules and Remaining are some customization of Existing Standard Reports. These all Reports the users want in Excel format and the output file automatically come in their Mail ID. So, we need to write shell program and also we used shell program to send JOB Gate Pass alert mail. In case Form 6i , we did some Form Personalization on standard Forms. We did almost 6 Form Personalization to fulfill the client requirements. The all Personalization related to Oracle QA i.e. Quality module.

Sandip’s Resume

Page 5 of 10

Contribution • Development and Testing of Stored Procedures and Functions. • Development of Technical Design Documents (MD70’s, MD64’s, CV60’s, TE20’s,UTS’s). • Creating Custom tables in Custom Schema and giving access to APPS schema. • Loading of data from legacy system to custom tables using SQL LOADER. • Registering PL/SQL Stored Procedures, Custom Reports in Front End using Concurrent Program. • Create the Form Personalization on standard Form to fulfill the client Requirements. • We wrote shell program to send mail with the Report output as an attached and alert mail for JOB Gate pass Expiry alert. • Creating FND Load files of Concurrent Programs, Reports and Form Personalization to go hade towards the Production Instance. • Extension of OAF objects and java classes for oracle applications. • Testing - unit testing

4.

Project Name : VETCO Gray Oracle Implementation Project ID

Client Role Organization Duration Team Size: 10 Environment (with skill versions)

: 07024481

GE Oil & Gas Team Member Satyam Computer Services Ltd (02/2008) – (07/2008) Project : VGC ERP Implementation Module : AP,AR,BOM,INV etc Software Languages : SQL,PL/SQL Oracle 10g , Database: Oracle10g Apps(11.5.10.2), Tools: Data Loader ,PLSQL Developer, TOAD v7.6 Data Loader , PLSQL Developer, ERP : Oracle E-Business Suite ( v 11.5.10.2 ) TOAD v7.6 O/s : Windows XP Professional . Hardware

Intel Pentium 4 processor, with 1GB RAM

Project Description: The Oil & Gas acquired five Companies (one of them is VETCO Gray; it is a UK Based Company). VETCO Gray Oracle Implementation project is about transferring data from legacy to oracle and developing code to meet the standards. Contribution • Development and Testing of Stored Procedures and Functions. • Development of Technical Design Documents (MD70’s, CV60’s, TE20’s). • Creating Custom tables in Custom Schema and giving access to APPS schema.

Sandip’s Resume •

• • • •

Page 6 of 10

Loading of data from legacy system to custom tables using SQL LOADER. Registering PL/SQL Stored Procedures in Front End using Concurrent Program. Creating workflow and testing workflows. Extension of OAF objects and java classes for oracle applications. Testing - unit testing

3.

Project Name : GE Oil & Gas, PII Oracle Implementation Project ID

Client Role Organization Duration Team Size Environment (with skill versions)

: 07021131

GE Oil & Gas Team Member Satyam Computer Services Limited, India (03/2007) – (01/2008) Project : GE PII ERP Module : INV,BOM,PO,AP,AR,PA Implementation etc Software Languages : SQL,PL/SQL Oracle 10g , Database : Oracle 10g Apps(11.5.7), Tools : Data Loader ,PLSQL Developer, TOAD v7.6 Apps(11.5.10. ERP : Oracle eBusiness Suite ( v 11.5.10.2 ) 2), Data Loader , O/s : Windows XP Professional PLSQL Developer, TOAD v7.6

Hardware

Intel Pentium 4 processor, with 1GB RAM

Project Description: The Oil & Gas acquired one Company (named PII, one UK Based Company). The PII Company’s data are in Apps. 11.5.7 and Client want to upload those date in existing Apps 11.5.10 with changing GL account and adding some Operating units across the world. Not only that the Business want some Organization splitting also, so PII will spread across Germany, USA, Canada, Mexico, Argentina, Brazil, Venezuela and Cramlington . This PII Oracle Implementation project has 6 Modules (like INV,PA, AP,PO, AR, GL) and within these total 23 Components .

Sandip’s Resume

Page 7 of 10

In this project we need to bring complete system for PII from oracle 11.5.7 instance (Oracle 9i Database) to oracle 11.5.10 Instance (Database 10g). A number of conversion and interface we need to develop for bringing all the data from old instance to new instance like conversions are AR Customer Master, Item Conversion, BOM conversion, GL Daily Rates Conversion, Purchase Order Conversion, PO Requisitions, AP Invoices, On Hand Quantity, Avg. Cost, FA Assets, Employee Master Conversion, AP Banks, AP Closed Invoices, AP Vendors and interfaces are CMF, GE-cars, ETL Time sheets and Cpars etc. Here we handled a large volume of data and we converted them with 100% efficiency. Contribution: As a team member, was responsible for • Analysis of the specifications provided by the clients (MD 040 DOCs) • Design the Technical DOC. (like MD 060, MD 070 DOCs) of respective Components. • Coding using PL/SQL on Toad 7.6 version and maintain the GE standard. • I handled the Inventory, BOM, PO portions and GL Rates also. • Testing - unit testing , integration testing & Creating TE20 DOCs • Responsible for overseeing the Quality procedures related to the project. • I interact with Client for any change in implementation, in Technical aspects.

2. Client Role Organization Duration Team Size Environment (with skill versions)

Project Name : Sales Order Purchasing Satyam Technology Centre Developer as well as Tables and Forms Designer Satyam Computer Services Limited, India (02/2007) – (02/2007) Project : Internal Project Module : OM Software Languages : SQL,PL/SQL Oracle 9i , Database : Oracle 11.5.10 Apps(11.5.10), Tools : Oracle Apps TOAD v7.6 O/s : Windows XP Professional Hardware Intel Pentium 4 processor, with 512MB RAM

Project Description: The main aim of this project was to automate the Sales Order Purchasing Management System i.e. a tool was to be developed so that it becomes easy to Sale Products , maintain the Purchase Orders and it’s data .Uniquely maintain each and every transactions and cater to the growing number of customers.

Sandip’s Resume

Page 8 of 10

Contribution: As a team member, was responsible for • Analysis of the specifications provided by the clients • Design the Tables Structures and Register in Oracle apps(v11.5.10) and Development • Coding using forms 6i, and PL/SQL • Testing - unit testing & integration testing • Responsible for overseeing the Quality procedures related to the project. • Client site for implementation. 1. Client Role Organization Duration Team Size Environment (with skill versions)

Project Name : Bank Management System Satyam Technology Centre Team Member Satyam Computer Services Limited, India (01/2007) – (01/2007) Project : Internal Project Module : Software Languages : PL/SQL Oracle 9i, Database : Oracle 9i Forms 6i Tools : Forms and Reports Reports 6i O/s : Windows server2003, Windows XP Professional Hardware Intel Pentium 4 processor, with 512MB RAM

Project Description: The main aim of this project was to automate the bank management system i.e. a tool was to be developed so that it becomes easy for bank management to maintain it’s data and carry out day to day transaction and cater to the growing number of customers. Contribution: As a team member, was responsible for • Analysis of the specifications provided by the clients • Design and Development • Coding using forms 6i, and PL/SQL • Database management and JDBC connectivity • Testing - unit testing & integration testing • Responsible for overseeing the Quality procedures related to the project. • Client site for implementation.

Sandip’s Resume

Page 9 of 10

Personal Details Name

Sandip Dey

Email Id

[email protected] [email protected] F8576215 Valid Upto: 20/08/2016 (mm/dd/yyyy) Valid Upto : (mm/dd/yyyy)

Passport No. Type of Visa holding (if any) Location

India , Bangalore

Contact Numbers

Home: 09800004081 / 09163599431 Personal Mo. : 09916978023 / 09985285005 AKHPD0893R

PAN

Page 10 of 10

Sandip’s Resume

Date: (DD/MM/YYYY) ……………………………

Signature: …...…………………………...