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)