Resume

Sign in

Project Oracle

Location:
United States
Posted:
October 03, 2016

Contact this candidate

Resume:

Naveen Gupta

Linkedin: https://in.linkedin.com/in/naveen-gupta-2ab70b1

Professional Summary

Highly motivated professional, strong in application software development with more than 14 years of experience in IT industry. I have worked on different domain. i.e. Capital Market (Cash & FO), Purchasing, Finance, Billing, Production & HRMS and Ministry of Defense Operations. Also I have good exposure on procure and Pay and Order to Cash functionality.

I have strong technical knowledge of Oracle 12C,11G, 10g,8.0 and 8i/9i (SQL *Plus, PL/SQL), Forms and Reports 10g, Discoverer Reports, Oracle Workflow, Oracle APPS(AOL) and Good Experience on Oracle Apps OM, PO, AP, AR, GL modules Interfaces/Conversions and XML reporting.

I have specialization is in requirements collection, analysis, design, development, implementation, Support and Maintenance of applications that are based on Oracle Database. This involves the tasks such as creating the database objects like procedures, functions, triggers, packages etc. and Performance Tuning of PL/SQL

Oracle Technical Experience

Expertise in writing stored procedures, functions, packages and triggers using SQL and PL/SQL.

Worked on large data volume and have expert knowledge on SQL and PL/SQL Performance Tuning, Oracle partition, direct path loading, and parallel query/DML/DDL

Extensive knowledge on oracle Forms & Reports along with personalization and customization.

Extensive knowledge of Oracle Workflow tool. Developed many custom workflows with extensive functionality

Very good exposure on procure and Pay Cycle and order to cash Cycle.

Very good knowledge on discoverer and XML reports

Capable of working independently and as well as a part of a team. Have experience of managing offshore technical team from onsite

Design, development and implementation of Interfaces and Conversion programs to integrate Oracle Applications modules with Bolton modules.

Experienced in Oracle ERP modules: SCM (Purchasing, Inventory and Order Management), and Financials (General Ledger, Payables, and Receivables).

Directly interacting with client for Bolt On requirements and on all defects.

Experience of giving training to client and presenting proposal for Boltons to client.

Involved in full life cycle implementation of Oracle Applications for Ministry of Defence, Oman.

Independently handled technical support for 3 years.

Received formal client appreciation on successful implementation.

Education

Degree

University

Year of Passing

M.C.A.

Dr. Bhem Reo Ambedkar University, Agra

(04/2002)

B.Sc. Instrumentation with Computer Sc. (Vocational)

Dr. Bhem Reo Ambedkar University, Agra

(05/1999)

Experience

Organization

Designation

Duration

Tech Mahindra Ltd.

USA Division: Tech Mahindra Americas Inc.

Technical Lead

(05/2006) – till date

Indiabulls Securities Limited.

Sr. Software Developer

(05/2004) – (4/2006)

Synergy Software Limited

Sr. Software Developer

(6/2003) – (5/2004)

4cplus Internet company (P) Ltd.

Software developer

(1/2002) - (5/2003)

Technical Skills

Hardware

Dell and HP

Operating Systems

Windows NT; HP UNIX

Languages

PL/SQL

Databases

Oracle 10g, Oracle 11i, Oracle 12c

GUI

Forms 10g, reports10g, Oracle APPS (AOL,OM,PO,AP,AR,GL)

Case Tools

Web Related

HTML

Tools & Utilities

Oracle Workflow Builder, Oracle Forms & Reports, Discoverer Administrator & Desktop, XML Reporting for oracle Apps, Toad, Reporting Tool BLUEBOOK Application developed by Blue infinity,Mercury Test Director 7.6, SQL-Navigator 4.2,

Domain Knowledge

Order Management,Share Broking Segment(Cash & FO), Finance, Print Media(Circulation), Billing, Production,HRMS, Government Defense Services, Supply Chain Management(Purchasing & Sourcing)

Trainings

Sl#

Title

Location

Organized by

Duration

1

Oracle APPS (AOL)

Hyderabad

Tech Mahindra.

8 Days

2

PMP

San Jose

Tech Mahinra

40 Hours

3

PEGA

Online

Pega Systems

1 Week

Projects Profile

1.

Customer Registry Transformation

Client

Cisco System Inc.

Role

TL

Organization

Tech Mahindra Americas Inc., USA

Duration

Feb’16 to Till Date

Team Size

Project : 20

Team : 6

Environment

Software

Product : Oracle Application 12.1.3,

Database : Oracle 12C

GUI : Oracle Apps11i,R12, Angular JS

Tools : Toad, SSH Client, Kintana, Quality Center,EDM

O/s : Windows 7

Version Control: SVN

Project Description:

Cisco has launched CRT project to transform and implement their current Customer Register Module from Oracle apps TCA architecture to the non-apps customized design to improve the performance. Also CRT is design to use SOLR indexing to improve the response time for all the searches.

CRT system is the centralized customer database for all the Cisco customer and sites. All the applications in Cisco will subscribe to CRT to send their request for customer creation and search. Auto Engine will be built to accept all the subscriber system request and match it to existing database and if it is not able to map with existing customers repository then it will create a new unregister party.

Another big module of CRT is ODM. Role of ODM (Operational Data Management) starts with Unregistered parties creation where ODM will provide the interface and mechanism to ODM analysts to cleanse these new parties and register them to be used for other subscribers.

Contribution/Responsibilities:

1.Responsible for understanding the current CR system and discuss the new enhancements with Functional and Business teams to design and develop new system.

2.Also responsible to discuss with cross flow team and build the database design for ODM operations for CRT.

3.Created a provision (pl/sql program) to populate and sync huge data volume in SOLR indexes with the SLA of 10 Second.

4.Review the oracle PL/SQL code for peer teams.

5.Responsible for all the ODM screens, Reports and functionality design & Development, which include data base design including table creation, development of package.

6.Responsible for all ODM data migration from CR to CRT.

7.Supported Transition activities for QA, TEST, FPR and PROD environment.

8.Coordinating with offshore team.

2.

OM LSS

Client

Cisco System Inc.

Role

TL

Organization

Tech Mahindra Americas Inc., USA

Duration

Jan’15 to Jan’16

Team Size

Project : 15

Team : 3

Environment

Software

Product : Oracle Application 12.1.3

Database : Oracle 10g

GUI : Forms10G, Reports10G, Oracle Apps11i,R12

Tools : Oracle forms, Reports, Workflow, TOAD, Citrix, SSH Client, Kintana, Quality Center,EDM

O/s : Windows 7

Version Control: SVN

Project Description:

Cisco has launched LSS project to migrate all Business Entities from Oracle Apps 11i to Oracle Apps R12 instance. Cisco has migrated instances in Phased manner. This project has requirement of auditing the migrated data to ensure the quality of Migrated Data.

Contribution/Responsibilities:

9.Responsible for Q3FY15 (America and Canada) and .Q2FY16(NL, Italy & Japan) Data Migration Audit

10.Supported Transition activities for Q3FY15 and Q2FY16 go-live Activities.

11.Post go-live support for Migrated data issues for Q3FY15 and Q2FY16

12.Coordinating & resolving the data issues related to Migrated Data.

3.

Cisco_CVCM_QTC_CCW_ASE_OM

Client

Cisco System Inc.

Role

TL

Organization

Tech Mahindra Americas Inc, USA

Duration

Jul’14 to Dec’14

Team Size

Project : 12

Module : 12

Environment

Software

Product : Oracle Application 12.1.3

Database : Oracle 10g

GUI : Forms6i, Reports6i, Oracle Apps11i,R12, Java Applications

Tools : Oracle forms, Reports, Workflow, TOAD, Citrix, SSH Client, Kintana, Quality Center,EDM

O/s : Windows 7

Version Control: SVN

Project Description:

Cisco Commerce Workplace is place where customer or partner can order products or services and return their products. Cisco has so many Order sources to place orders. For customer satisfaction and Cisco is integrated all the tools at one place is called Cisco commerce Workplace

As part of CCW quarterly releases, primary focus is to focus enabling multiple services to their partners and customers and providing the appropriate discounts to them by their eligibility. In order to support the new tool and platform OM has done various enhancements and complex Integrations in various releases thereby increasing the Customer Adoption of the new Ordering tool.

Major releases and enhancement include the OM Track solution the complete integration of NGC tool to SOWB in Oracle ERP. This is a very complex integration and fulfills all the service requirements of the customer and partners. This has brought parity in both the Ordering Tools (CCW) and SOWB.

Contribution/Responsibilities:

1.Responsible for Q1FY15 Scopes Delivery.

2.Supported Transition activities for Q1FY15 and go-live Activities.

3.Post go-live support for Q1FY15.

4.

ICMS

Client

Cisco System Inc.

Role

TL

Organization

Tech Mahindra INC., USA

Duration

Jun’14 – Jul’14

Team Size

Project : 8

Module : 8

Environment

Software

Product : Oracle Application 12.1.3

Database : Oracle 11.2.0.2.0

Modules : AR,AP,OM,GL

O/s : HP AIX

Project Description:

The Integrated Collections Management System (ICMS) is tool functioning as the one-stop location for all collections related activities that are currently managed in multiple ERP systems and various tools. The tool will order and transaction data from various business entities operating on several Oracle platforms as well as case data from TeleService, Dispute and Sales Adjustment (SAF) Data elements from the Advanced Collections tool.

Scope: As a part of UKH(UK Home operating unit) to migrate from BVP(11i) instance to CG1(R12) instance, ICMS also has requirement to migrate UKH data between the data sources.

Contribution/Responsibilities:

1.Created scripts to migrate data.

2.Handled environment setup and supported testing.

3.Coordinate with Pega team to support environment setup, testing and close defects.

5.

NGCCRM: Enabler 3.0

Client

Cisco System Inc.

Role

TL

Organization

Tech Mahindra INC, USA

Duration

Jul’13 – Jun’14

Team Size

Project : 8

Module : 4

Environment

Software

Product : Oracle Application 12.1.3

Database : Oracle 11.2.0.2.0

Modules : AR,AP,OM,GL

O/s : HP AIX

Project Description:

NGCCRM (Next Generation Commitment Compliance & Revenue Manager) is a tool for managing adjustments related to non-standard deals. Adjustments are applied in the form of deferrals when a deal is found to have not met all the conditions for revenue recognition. These deferrals are released when the underlying conditions are met. In NGCCRM the adjustments are made using Reason codes, where each reason code represents a specific condition/requirement not met. The amount of adjustment can be percentage of the Order Line amount or a specific dollar value.

These adjustments (deferrals or releases) for revenue, cogs, and bookings impact the overall revenue, cogs, and bookings numbers. This reporting is done by means of EDW and to enable this reporting, data from NGCCRM is read into EDW. The data from EDW is further propagated to OIC system, which is the system for calculating commissions for the sales force. Data for OIC is also fed from OTM.

Enabler 3.0 is about enablement of new features in existing NGCCRM application. The major functionality includes enablement of Adjustment (CM/DM/RMAs) functionality. This solution involved changes in TBA processing and reporting, to consider Adjustments for deferral calculations.

Contribution/Responsibilities:

1.SME on TBA (template based Adjustments) processing, and implemented functionality of CM/DM & RMA adjustment on TBA deferrals as a part of Enabler3.0 Q3FY14 release.

2.Responsible to receive all calls from client and understand the issue.

3.To analyze the issue and categorize it as bug or change request

4.Supported in QA and BAT testing and post production normalization support.

5.To provide the solution for identified bugs.

6.Supported Normalization phase successfully. Worked 3 months on production issues post normalization period.

6.

Project Name : ADB Implementation

Client

Asian Development Bank (http://www.adb.org)

Role

TL

Organization

Tech Mahindra Limited, India

Duration

Oct’12 – Nov’12

Team Size

Project : 42

Module : 4

Environment

Software

Product : Oracle Application 12.1.3

Database : Oracle 10.2.0.2.0

Modules : Oracle Projects

O/s : HP AIX

Project Description

Asian Development Bank (ADB) is an international development finance institution established in 1966, dedicated to reducing poverty in Asia and the Pacific region through Loans, Grants, Technical Assistance and Equity investments. This project involves the implementation of the financial processes through bolt on customizations and integration with the existing legacy systems.

Contribution

Extensively work on Workflow and PL/SQL

Assists the PL/SQL and Oracle Workflow developers in completion of their work.

Developed three workflows with major functionality.

Taking interview for new joiners.

7.

Project Name : NEBRAS

Client

Ministry of Defence, Oman

Role

Onsite Technical Lead

Organization

Tech Mahindra Limited (Satyam), India

Duration

Dec’07 – Oct’12

Team Size

Project : 6

Module : 4

Environment

Software

Product : Oracle Application 12.0.6

Database : Oracle 10.2.0.2.0

Modules : General Ledger, Accounts Payables, Accounts Receivable, Purchasing

O/s : HP AIX

Project Description

The Ministry of Defence (MOD), Sultanate of Oman has launched Nebras project to replace the current core Financial and Procurement systems with an Enterprise Resource Planning (ERP) system - Oracle Applications E-Business Suite. The overall requirements of any Ministry of Defence tend to be extensive covering a range of functional areas from finance to procurements to inventory to logistics.

The project includes implementation of Oracle Applications E-Business Suite covering Financials & Supply chain management covering the following modules:

1.Supply Chain Management (Purchasing and Sourcing)

2.Financials (General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets and Cash Management)

There are Bolt On modules to cater the requirement which can not be full fill by Oracle Application. Detail of major Bolt-on is as follow

1.Custom Clearance : To cater the administration part in clearing the purchase order shipments received from overseas by sea or air

2.Freight : To recording all overseas freight invoices. It currently maintains 16 freight registers (10 for air and 6 for sea).

3.Insurance : For Recording the information related to Insuring the fixed assets and purchase order shipments for Ministry of Defence

4.Letter of Credit : For Recording the details of Letter of Credit for Purchases or contracts entered with suppliers

5.Market Research : To record the information about enquiry from services (Different Forces) about specific products or services and to record supplier’s details. This module should also record the specific products or services which the supplier deals with. This is the only entry point for all suppliers creation which gets approve through workflow and the interface to AP

6.Utility Bills : for recording meter readings and to generate Utility bills for the services i.e. Telephone, Electricity that MOD provides to the contractors.

7.Tender Sales : This is to address all the requirements related with tender execution and not address by Oracle sourcing Module. Like selling of tenders and documents, Re-Tendering process, sorting out the eligible suppliers and recording different miles stones in this process.

To cater these requirements number of Interface and Conversions are created from legacy system i.e. Purchase order, Payroll, Supplier, Customer, Requisition, Invoice Etc.

Contribution

Understanding the requirement with client and Satyam functional team for Conversion, Interfaces, and bolt on Modules and for reports.

Development of almost 140 Reports, 40 Oracle forms, 5 Workflows and 10 alerts for different Bolt and Oracle modules. It includes database design in most of the Bolton’s development.

Testing of all the Conversion and Interfaces and Bolton Modules with the development of most of them.

Review of document: Reviewing of all the code & the technical document for conversion, Interfaces and Bolt on modules

Code Modification : Modification of code required at the time of conversion and Interfaces Implementation

Implementation of Conversion and interfaces for AP, AR & Purchasing modules

Implementation of all Bolt On modules

Ensuring overall quality of project deliverables/output

Guiding the Offshore technical team members with regard to Technical, design and other activities of the project.

Also participated in inventory study for this project by providing the technical view on proposed solution.

Implemented Shared area for the Interfaces with legacy systems

Supported all custom application components for all technical issues alone for more than 3 years.

8.

Project Name : ADMS-HRIT

Client

Agilent Technologies, Inc

Role

Team Member

Organization

Tech Mahindra Limited (Satyam), India

Duration

(05/2006) – (11/2007)

Team Size

Project :14

Module : 4

Languages : SQL,PL/SQL

Database :Oracle 9i

Tools : Bluebook Reporting Tool Developed By Blue Infinity, SQL Plus, SQL Navigator,

O/s :Windows NT

Hardware

Dell Servers

Project Description: The project involves Development & production support for various customized applications across ‘Agilent Technologies’ in the domains of Data warehousing and Reporting. The data warehouse applications is called WEDB – Workforce and Employee Database that contains worldwide information about all Agilent employees including non-Agilent workers such as contractors and that enables proactive business decision-making. The reporting tool is called Bluebook, that is a web-based application which provides the HR community, Second Level managers and above, Financial Analysts and areas such as Workplace Services, Communications and also the ability to create or modify reports, and an easy to use employee lookup.

Contribution

1. Net metting with Agilent Managers to

• Obtain clarifications of requirements as needed

• Attend Discuss escalation issues

• Attend CR review meetings

• Work closely with stream lead to obtain resources to work on Change Requests

2. Worked independently on developing & testing of annual reward summary Module. That Consists of numbers of reports related with Annual Reward Process cycle of Agilent.

3. Acquire knowledge on customer specific tool Bluebook and trained Satyam team on Bluebook

9.

Project Name : Indiabulls Back Office

Client

Indiabulls Securities Limited

Role

Team Leader

Organization

Indiabulls Securities Limited, Delhi

Duration

(05/2004) – (04/2006)

Team Size

Project :14

Module : 10

Languages : SQL,PL/SQL

Database :Oracle 9i

Tools : Forms 6i, Reports 6i,Toad

O/s :Windows NT

Hardware

Dell Servers

Project Description

This s/w provides complete Back Office assistance to Share Brokers in all segments Cash/Option/Future. It also calculates the margin block in terms of shares and money of a client. It is fully compatible with files received from NSE/BSE stock exchanges. It provides market trend of all Scrips. It also Includes finance module which provide net position of a client any point of time. And also Include Incentive Module which calculates the incentive for different level of sales team i.e. RM, TL, BH, RH, SH AND MA On the basis of brokerage/turnover from their clients. This module also include feature of financing (Cash Movement) against shares pledge. Margin trading is the additional feature of the package.

Contribution

1.Design and development of Margin Trading Module (as per SEBI Rules)

2.Design and development of Incentive module of the software

3.Design and development of financial (voucher entry/balance sheet/P&L a/c) module

4.Implementation of turnover tax logic.

5.Design and development of No Delivery Trades.

6.Design and implementation of financing for trading against share value.

7.Sometime developed the processes over night and implement them with foolproof testing.

8.Used lots of Performance tuning methods to avoid performance issue As several trades need to be uploaded on daily basis and database size was huge.

10.

Project Name : Focus (Back Office For Share Brokers)

Client

Fortis Security Ltd, Indus portfolio Ltd., Damani Share Broker Bombay

Role

Team Member

Organization

Synergy Software Limited, Delhi

Duration

(06/2003) – (05/2004)

Team Size

Project :7

Module : 3

Languages : SQL,PL/SQL

Database :Oracle 9i

Tools : Forms 6i, Reports 6i,Toad

O/s :Windows NT

Hardware

HP Servers

Project Description

This s/w Provide complete Back Office assistance to Share Brokers in all segments Cash/Option/Future. It is fully compatible with files from NSE/BSE Stock Exchanges. It provides market trend of all Share. It also Includes finance module which provide net position of a client.

Contribution

1. Testing of Base functionality of the software.

2. Balance Sheet and Profit & Loss A/c Part of finance module

3. MIS report and price trend Graph in Excel sheets

4. Performance Tuning Of Data Base

11.

Project Name : Mid-Day ERP

Client

Mid-Day Multimedia,Mumbai

Role

Team Member

Organization

4C Plus Internet Company (P) Limited., India

Duration

(09/2002) – (05/2003)

Team Size

Project :3

Module : 3

Languages : SQL,PL/SQL

Database :Oracle 8

Tools : Forms 4.5, Reports 4.5, Forms 5, Reports 5,Toad

O/s :Windows NT

Hardware

Dell Servers

Project Description

This s/w Provide complete services to finance, Billing, Outdoor booking, circulation, Advertisement divisions of mid day. It also provides automatic billing after booking. Computerized cheque printing and Bank Reconciliation feature is also provided in this s/w

Contribution

1. Design & Development of various database objects such as procedures, functions, triggers, packages etc at the database level.

2. Coding & requirement analysis of Finance System of all the division (centralized)

3. Coding in Billing and booking module of out door division.

4. MIS report and graph in excel sheets

5. Design and develop Computerized Cheque Printing and inventory maintenance.

12.

Project Name : Chitralekha Circulation

Client

Chitra Lekha Magazine,Mumbai

Role

Team Member

Organization

4C Plus Internet Company (P) Limited., India

Duration

(02/2003) – (05/2003)

Team Size

Project :3

Module : 3

Languages : SQL,PL/SQL

Database :Oracle 8

Tools : Forms 5, Reports 5,SQL Plus

O/s :Windows NT

Hardware

HP Servers

Project Description

This soft has completely automated circulation department work of chitralekha which includes daily supply posting and unsold deduction. It also provides consolidate billing after each month. And have full coordination with finance.

Contribution:

1. Work on unsold management part

2. MIS Report and Graph in Excel sheets

13.

Project Name : Amar Ujala ERP

Client

Amar Ujala News paper, Meerut

Role

Team Member

Organization

4C Plus Internet Company (P) Limited., India

Duration

(06/2002) – (09/2002)

Team Size

Project :3

Module : 3

Languages : SQL,PL/SQL

Database :Oracle 8

Tools : Forms 4.5, Reports 4.5,Toad

O/s :Windows NT

Hardware

HP(Xion) servers with RAID 5

Project Description

This s/w has Finance, advertisement and Circulation modules. In this s/w all the reports and graphs are design in drill down format

Contribution

1. Coding & requirement analysis of Finance system

2. All MIS Report and Graph in Drill down Format

14.

Project Name : Export management system

Client

JK Tyre Ltd., I.T.O. New Delhi

Role

Team Member

Organization

4C Plus Internet Company (P) Limited., India

Duration

(05/2002) – (06/2002)

Team Size

Project :5

Module : 5

Languages : SQL,PL/SQL

Database :Oracle 8

Tools : Forms 4.5, Reports 4.5

O/s :Windows NT

Hardware

HP Servers

Project Description

A leading Export management system to control the export process of different items from different factories to foreign clients through different C & F agents and all the transactions are done through letter of credit of bank. Also provide the facility to export items individual or in a kit

Contribution

1. Development of bank transaction part

2. Test case designing

15.

Project Name : CIO-365 tm ERP & GIS (Geographical Information System) 365 TM

Client

Shakumbhri Sugar Mills, Saharanpur.

Role

Team Member

Organization

4C Plus Internet Company (P) Limited., India

Duration

(01/2002) – (05/2002)

Team Size

Project :6

Module : 6

Languages : SQL,PL/SQL

Database :Oracle 8i

Tools : Forms 4.5, Reports 4.5, Visual Basic 6.0, Map Object (Tool for VB.), Arc View (For drawing maps)

O/s :Windows NT

Hardware

Hp Servers

Project Description

This is the ERP solution for shakumbhari sugar mills; it Includes purchase, production, store, finance, gate pass module. We also provide GIS module with this s/w this GIS s/w provide field management of sugar mills that it can take care of production promotion of sugar cane and prediction of sugar cane arrived this GIS module which is developed in visual basic is fully incorporated with main ERP module which is developed in developer form 5.0

Contribution

1. Coding and implementation of financial and gate pass module

2. Connectivity between ERP module and GIS module which is developed in visual basic

Personal Details

Name

Naveen Gupta

Email Id

acwwai@r.postjobfree.com

Passport No.

J7416037

Valid Upto: 07-OCT-2021

(mm/dd/yyyy)

Type of Visa holding (if any)

H1B

Valid Upto : July 2018

(mm/dd/yyyy)

Location

CA, USA

Contact Numbers

+1-510-***-****(mobile)



Contact this candidate