Deepak C. Pandey

Email - adn3wq@r.postjobfree.com, Cell US: +1-317-***-****

Summary

Working as a Technical System Analyst/Expert Developer for client Cummins Inc., Indianapolis, Indiana, USA.

Over 10+ years of programming experience as an Oracle PLSQL, Forms and Reports (D2K) Developer in Analysis, Design and Implementation of Business Applications using the RDBMS on Windows/Linux platform.

Using Safe Agile concept to perform the software development and deliveries.

Handling 2 Agile teams and respective offshore team members.

Involved in all phases of the SDLC from requirement gathering, analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, ETL tools and SQL*LOADER.

Good knowledge and experience with performance tuning techniques/features such as Query Optimizer, Execution Plans and Indexes.

Good knowledge and experience in Unix/Linux commands and shell scripts.

Worked on well-known ERP application like IBS, BMS and Integrations like CDH (Customer Data Hub), EDQ (Enterprise Data Quality), PGBU Warranty application, BOLT, Vertex etc.

Work appreciated by clients while working as Oracle Application Developer/Technical Analyst for projects.

Working experience of various modules of application such as Finance, Purchase, Sale, Stores, Production, QC and Export.

Good knowledge on other skills like Data Science with Python, Machine Learning and Deep Learning.

Work Experience

Working with Birlasoft Technologies (Earlier KPIT Technologies), Pune (Nov’14 to till date), In USA since Dec 17.

Worked with Virtual Galaxy InfoTech Pvt. Ltd, Nagpur (Dec’13 to Nov 14).

Worked with UNI24 Techno Solutions Pvt. Ltd., Bhopal (Apr’13 to Nov’13).

Worked with Virtual Galaxy InfoTech Pvt. Ltd, Nagpur (Aug’10 to Apr’13).

Worked with Caliber Point Business Solution, Nagpur (Apr’09 to Sep’09).

Educational Qualification

M.C.A (Master in Computer Application) from Nagpur University with 1st Division, Wardha (Maharashtra), May 2010.

B.Sc (Computer Science) from Nagpur University with 2nd Division, Nagpur (Maharashtra), June 2006.

H.S.S.C Passed from C.B.S.E Board, Jodhpur (Rajasthan), May 2003.

S.S.C Passed from C.B.S.E Board, Chabua (Assam), May 2001.

Technical Skills

Database: Oracle 8i/9i/10g/11g/12C

Developer Tools: Oracle Forms/Report (D2K), PL SQL Developer, Toad, Oracle JDeveloper 11g, Net Beans, Eclipse, Hadoop Hive, Pig, Jupyter Notebook for Python, MSBI (SSIS), Machin Learning

Language: Oracle SQL, PL/SQL, Unix/Linux shell scripts, Core Java, XML, Python

OS: Windows, AIX and Linux

Other Tools: WinSCP, Putty, Export, Import, SOAP UI

PROJECTS Details:

Project - 12

Client : Cummins Inc.

Project : Agile Requirements for Service/Finance Modules

Technology/Software : Oracle Forms and Report 11g and Oracle Database 12C

Designation : Expert Developer/SME/Technical System Analyst (Onshore)

Duration : Nov’19 to Present

Team Size : 8

Project Synopsis

Cummins Inc. has implemented the Agile way of working for the requirements using JIRA tool. Team has divided per module and our team is getting requirement related with Service and Supply Chain Module.

As a part of this model, we are receiving high priority and cleared requirements from business to implement in each release cycle.

Roles & Responsibilities

Below are the responsibilities as Expert Developer:

Analysis of JIRA requirements.

Check for the impacted area in the BMS whether the new requirement impacting existing functionality or not.

Creating Design for requirements

Object Development/Modifications as per requirements.

Unit testing/UAT Support

Infant Care Support/ Issue Resolution.

Project - 11

Client : Cummins Inc.

Project : Data Lifecycle Management

Technology/Software : Oracle Forms and Report 11g and Oracle Database 12C

Designation : Technical System Analyst (Onshore)

Duration : Jun’19 to Nov’19

Team Size : 10

Project Synopsis

After implementing OneBMS, data started growing into the database drastically because now 4 instances started storing data of 16 distributors, which started affecting others area of the application like performance, storage capacity etc.

The purpose of the data lifecycle management project is purging and archiving the data as per business requirement document. Business has defined the purging and archiving rule for different area in BMS like Claims Management, Orders Management, Service etc.

Roles & Responsibilities

Below are the responsibilities as Technical System Analyst:

Analysis of the BRD requirements.

Check for the impacted area in the BMS whether the new requirement impacting existing functionality or not.

Estimate the requirements.

Suggest and help on solution design to offshore team.

Project - 10

Client : Cummins Inc.

Project : OneBMS

Technology/Software : Oracle Forms and Report 11g and Oracle Database 12C

Designation : Technical Lead (Offshore) & Technical System Analyst (Onshore)

Duration : Apr’16 to May’19

Team Size : 25

Project Synopsis

There are 16 Distributors in North America and each distributor has their own separate instance of the BMS application. DBU is acquiring and integrating NA distributors as a key element of their growth strategy. The goal is to seamlessly manage NA distribution as one business instead of 16 independent businesses.

The purpose of One BMS project is to migrate the 16 BMS instances to 4 BMS instances (One for all regions belonging to USA, Second for Southern Plains, third for Caribbean and the last fourth instance for all the regions belonging to Canada) having single common configuration that allows seamless management, end-to-end visibility and agility to transform and grow NA distribution business.

Roles & Responsibilities

During Offshore:

Responsibilities as Technical Lead and team member, to estimate the requirement, design SDD, develop, testing code (SIT/UAT) and to help team members to understand & develop the requirements. Worked on below OneBMS requirements:

Ability to flexibly assign users to regions and locations in One BMS.

Access control mechanism for new centrally managed roles.

Ability to apply a location/region level pricing.

Ability to override the primary and default price levels.

OneBMS Regionalization for identifier/setup screens (Private SRT’s, Flat Rates, Customer interview wizard etc.)

Ability to process warranty batches region wise.

OneBMS Integration Requirement (Sirius Rental Interface, Powercom, OIM, Xelus, Webcumpas, Vertex Outbound, RPS).

During Onshore:

Responsibilities as Technical System Analyst at Onshore, to get and understand requirements from the BA, to analyze the requirements, to provide high level estimations and to pass requirement & analysis to the development team. Also, to coordinate and took part in each implementation of OneBMS Go Live for each site. Worked on below enhancement request and change request’s.

BMS Customer Data Hub and Enterprise Data Quality Integration

Credit Limit Calculation CR.

Region wise additional charge.

Project - 9

Client : Cummins Inc.

Project : BMS-PGBU Warranty System Integration.

Technology/Software : Oracle Forms and Report 11g and Oracle Database 11g

Designation : Sr. Software Developer

Duration : Nov’15 to Mar’16

Team Size : 1 TSA(Onshore), 2 Developers (Offshore)

Project Synopsis

This Project requires Integration between BMS and PGBU Warranty System for Paid/Admin Denied Claims Data. The dealer will file claims in the new system PGBU Claim Entry Application. Once these claims are adjudicated in the PGBU Claim application then claims and credits will flow from PGBU to BMS via existing DB links in the BMS. This Integration implemented on all the distributor sites and this integration is only for ONAN product.

Roles & Responsibilities

Responsibilities as Sr. Software Developer and team member, to estimate the requirement, design SDD, develop and testing code (SIT/UAT).

Project - 8

Client : Cummins Inc.

Project : BMS-BOLT GL Integration

Technology/Software : Oracle Forms and Report 11g and Oracle Database 11g

Designation : Sr. Software Developer

Duration : Jan’15 to Oct’15

Team Size : 2 TSA(Onshore), 4 Developers (Offshore)

Project Synopsis

This Project requires Integration between Distributor Business Management System (BMS) and BOLT system for General Ledger (GL) data. This Integration will be first implemented on Cummins Northwest Distributor site and after that it rolled out on remaining distributor sites. BMS system will send summarized and CoA (Chart of Accounts) mapped General Ledger (GL) data to BOLT system using Middleware.

Roles & Responsibilities

Responsibilities as Sr. Software Developer and team member, to develop and test integration packages require to transfer data between BMS to BOLT and to load chart of account data using external tables.

Project - 7

Client : Bhakti Extractions Pvt. Ltd. and Geeta Refinery Pvt. Ltd, Jalna

Technology/Software : Oracle Forms and Report 10g and Oracle Database 10g

Designation : Sr. Software Developer

Duration : Mar’14 to Nov’14

Team Size : 4 Developers

Project Synopsis

Bhakti Extractions Pvt. Ltd. and Geeta Refinery Pvt. Ltd, Jalna is a solvent plant. Bhakti Extractions involved the production of Soya nuggets, Soya Granules, Soya flour, Soya Doc, Soya Crude Oil etc. and Geeta Refinery involved the production of Soya Refined oil. The Company’s requirement was to integrate all the ERP modules.

Roles & Responsibilities

Responsibilities as Sr. Software Developer and team member

I worked for Seed and Other Purchase, Sales, Production, Weighbridge Management, Export and Finance Module in the above-mentioned ERP - Software and contributed in the following areas:

Implemented above module and Customized above module as per client requirement.

Creating Masters and Master detail forms and Reports for Quality control modules.

Written Procedures, triggers and functions for above modules.

Project - 6

Client : Anjani Steel, Raigarh

Technology/Software : Oracle Forms and Report 10g and Oracle Database 10g

Designation : Sr. Software Developer

Duration : Dec’13 to Feb’14 (3 Months)

Team Size : 1 Developer.

Project Synopsis

Anjani Steel, Raigarh is a rolling mill which produced all steel structure related to building material like Angles, Channels, HSD Bars, and Rods & TMT Bars in the Brand Name of RADHE.

Store Management

Job Work

Scrap Module

Roles & Responsibilities

Responsibilities as Sr. Software Developer

I worked for Scrap, Stores and Job Work Module in the above-mentioned ERP - Software and contributed in the following areas:

Creating & implementing FIFO valuation of for stores and related reports as per client requirement.

Implementation of Job work module as per client requirement.

Written Procedures and functions for above modules.

Project - 5

Client : Vippy Solvex Ltd, Dewas

Technology/Software : Oracle Forms and Report 10g and Oracle Database 10g

Designation : Software Developer

Duration : Jan’13 to Apr’13 (4 Months)

Team Size : 4 Developers.

Project Synopsis

Vippy Solvex Ltd is a solvent company. It involved production of soya DOC; Soya Oil (Crude and Refined). The Company’s requirement was to integrate the activities of the following departments functioning in their company

Finance

Production Management.

Sales Management.

Purchase Management.

Weighbridge Management.

Human Resource.

Job Work

Logistics

Insurance

Export

Roles & Responsibilities

Responsibilities as Programmer and team member

I worked for Stores and Job Work Module in the above-mentioned ERP - Software and contributed in the following areas:

Creating Job work module and Customizing Store module as per client requirement.

Creating Master detail forms and Reports for Job work modules.

Project - 4

Client : Goyal Protein Ltd, Kota (Rajasthan)

Technology/Software : Oracle Forms and Report 10g and Oracle Database 10g

Designation : Software Developer

Duration : Jul’12 to Dec’12 (6 Months)

Team Size : 5 Developers.

‘

Project Synopsis

Goyal Protein Ltd is a solvent company. It involved production of Mustard Oil, Soybean Oil, byproduct like Lecithin; DOC (Soya and Hi Pro Both). The Company’s requirement was to integrate the activities of the following departments functioning in their company

Finance

Production Management.

Sales Management.

Purchase Management.

Weighbridge Management.

Human Resource

MIS (Management Information System)

Roles & Responsibilities

Responsibilities as Programmer and team member

I worked in the Finance, Purchase, Sale, Weighbridge and MIS Module for the above-mentioned ERP -Software and contributed in the following areas:

Created Master, Master Detail and Query Forms for above modules.

Creating Reports for above modules.

Creating Query form like Dashboard for MIS Management.

User creation, Granting Roles, Export, Import. Writing Procedures functions

Project - 3

Client : Mahamay Sahakari Shakkar Utpadak Karkhana, Ambikapur, (C.G)

Technology/Software : Oracle Forms and Report 10g and Oracle Database 10g

Designation : Software Developer

Duration : Apr’12 to Jun’12 (3 Months)

Team Size : 4 Developers.

Project Synopsis

Mahamaya Sugar Factory is Co-operative sugar factory deal with the production of sugar. It involved production of S-30 type sugar and byproduct like Molasis, Bagasse etc. The Company’s requirement is to integrate the activities of the following departments functioning in their Company

Agriculture Management

Cane Purchase Management

Weighbridge Management

Finance

Production Management.

Sales Management.

Purchase Management.

Human Resource.

Roles & Responsibilities

Responsibilities as Programmer and team member

I worked for the Agriculture, Cane Purchase and Weighbridge Management for the above-mentioned ERP -Software and contributed in the following areas:

Created Master and Master Details Forms for Agriculture, Cane Purchase and Weighbridge modules.

Creating Reports for Agriculture, Cane Purchase and Weighbridge modules.

User creation, Granting Roles, Export, Import. Writing Procedures functions

Project - 2

Client : Bhoramdev Sahakari Shakkar Utpadak Karkhana, Kawardha, (C.G)

Technology/Software : Oracle Forms and Report 10g and Oracle Database 10g

Designation : Software Developer

Duration : Nov’11 to Mar’12 (5 Months)

Team Size : 4 Developers.

Project Synopsis

Bhoramdev Sugar Factory is Co-operative sugar factory deal with the production of sugar. It involved production of S-30 type sugar and byproduct like Molasis, Bagasse etc. The Company’s requirement is to integrate the activities of the following departments functioning in their Company

Agriculture Management

Cane Purchase Management

Weighbridge Management

Finance

Production Management.

Sales Management.

Purchase Management.

Human Resource.

Roles & Responsibilities

Responsibilities as Programmer and team member

I worked for the Store, Sales, Other Purchaser and Cane Purchase for the above-mentioned ERP -Software and contributed in the following areas:

Created Master and Master Details Forms for Agriculture, Cane Purchase, Weighbridge Management, Stores, Sales and Other Purchase modules.

Creating Reports for Agriculture, Cane Purchase, Stores, Stores, Sales and Purchase modules.

User creation, Granting Roles, Export, Import. Writing Procedures functions.

Project - 1

Client : Ritspin Synthetics Limited, Indore (M.P)

Technology/Software : Oracle Forms and Report 10g and Oracle Database 10g

Designation : Software Developer.

Duration : Dec’10 to Oct’11 (11 Months)

Team Size : 5 Developers.

Project Synopsis

Ritspin Synthetics Limited is deal with Synthetics. It involved production of Synthetics Yarn. The Company’s requirement is to integrate the activities of the following departments functioning in their company.

Finance

Production Management.

Sales Management.

Purchase Management.

Export.

Human Resource.

Roles & Responsibilities

Responsibilities as Programmer and team member

I worked for the Store, Sales and Purchase for the above-mentioned ERP -Software and contributed in the following areas:

Created Master and Master Details Forms for Stores, Sale and Purchase modules.

Creating Reports for Stores, Sales, Export and Production modules.

User creation, Granting Roles, Export, Import. Writing Procedures functions

PERSONAL DETAILS

Name : Deepak C. Pandey

Date of Birth : 19-Jan-1986

Marital Status : Married

Passport No : R5375443

Language Known : English and Hindi

Current Address : 1034 N PAZ DR, Apt C, Greenwood, Indiana - 46142, USA

Permanent Address : Plot No 7, Dwarkapuri, Rameshwari Ring Road, Nagpur-440027

Date:

Place: Indianapolis, Indiana, USA Deepak C. Pandey

Contact this candidate