Resume

Sign in

Developer Project

Location:
India
Posted:
August 14, 2019

Contact this candidate

Resume:

Prashant Mahadeo Shete

Objective: Acquire a position utilizing my knowledge and expanding on my previous experience in

analysis, design, support and development and be a part of the team that excels in work

towards the growth of the organization.

Work Experience: Total 15.6 Yrs. of experience in Information Technology.

I possess major experience in banking (Credit card, Loan Management System, Loan

Recovery, Loan Disbursement) Domain, Insurance Domain, Telecommunication Domain.

GRC (Governance Risk and Compliance) Domain, Securities.

My Core skills are in Design, Development Databases applications,Product

Development(PRIME, LMS, LRS, TELCOM BILLING), Conversion & Migration using

Oracle SQL, PL/SQL,Oracle Queues,Oracle Streams & Oracle 9i/10g/11g Database,

Query Tunning and Performance, Enterprise Manager.

Tech Lead: On Future Focus payroll with Wipro Technologies, Banglore, From 1st June 2017 to 30th Sep 2018

Tech Lead: MetricStream Infotech, Bangalore, From 26th August 2015 to 24th May 2016.

Tech Lead: Spheregen Technologies Pvt. Ltd., Pune, from 15th April 2014 to 31st July 2015.

Senior System Analyst: R-SYSTEMS Intl. Ltd., Pune, from 28th Jan 2013 to 11th April 2014.

Analyst II: TSYS Card Tech Ltd, Mumbai, from 22nd May 2006 to 16th Jan 2013.

Programmer: Unitech Technologies Pvt. Ltd., Delhi, From 1st March 2003 - 27th April 2006.

Developer: WebComInfo Pvt. Ltd., Delhi, from Feb 2002 to Feb 2003.

Secretarial Officer: Kirloskar Computer Ltd., Pune from Feb 1997 to Jan 2000.

Technology Experience:

Database: ORACLE 8i, 9i, 10g & 11g, SQL, PL-SQL, Crystal-Reports.

Operating System: UNIX (basic), Windows.

Languages : C,C+

Scripting languages: HTML, XML, Javascript.

Educational Qualification:

B.Sc. (Electronics) From Sanjay Gandhi Sarvodaya Science College, Jabalpur (M.P)

Under Rani Durgawati Vishwa Vidyalaya University, in June 1996.

PGDCA From CMC limited (Govt. Of India Department Of Electronics), Pune, From Sep

1997 – Sep 1998

C-DAC Diploma in Advanced Computing from Delhi, From Feb 2001-Aug 2001.

Professional Summary:

Project Details: Wipro Technologies (Client – StateStreet), Bangalore.

Work Experience on Products: Description: State Street’s Application Exchange Trade Products (ETP) helps

Maintain and Monitor the Investments as per Investment Company Act of

1940 funds designed to trade on the secondary market. The purpose of these

investments is to allow the individual or institutional investor the ability to

purchase a share representing an interest in a portfolio that tracks a specified

index. In this way, the investor gets to invest in a market index without the

investment levels needed to purchase the underlying index components or to

meet mutual fund minimum investments. The ETP Application consists of

below Modules: Order Processing, Trade Processing Portfolio Composition

Cash Component Verification of Trade Recon. Burst Process and Recon Process

Daily Processing Market Value Processing.

Base Environment : Oracle 11g, SQL, PL/SQL Developer, SQL Developer, GITHUB, Jeera,

Angular JS, JAVA.

Responsibility: I am responsible for doing Analysis and Build the Application Changes into the backend Oracle

database. Attending daily Stand up Calls, Fortnight Demo, Retrospective and planning

meetings as per Agile standards. Working with an Agile team, has to pick the Story’s where the

Application changes are required by the Product Owners’, and to be delivered for the fortnight

deployment environment. Involved in analyzing the required changes, discussing with Team

members, making the Code changes and Unit Testing in the Dev environment, consulting the

Stake holders of the State Street to incorporate the changes and making the code to work on the

UAT environments with SQA testing before it is deployed in to BAUT and Production

environment.

Project Details: MetricStream InfoTech, Bangalore.

Product Details: Worked on GRC (Governance Risk & Compliance) Domain. Handled AMS (Audit

Management System) and QMS (Quality Management System) Project for US client LOWE’s.

Work Experience on Products: - Discussion with client and B.A (Business Analyst) on project requirement

gathering on daily call basis, system Integration between various modules (QMS, PROTOCALL Testing, Third Party Products) Module screen designing on GRC platform as per client’s requirements and needs. Designing database (Tables, Indexes, partitions etc), query tunning for performance, code Review, Preparing Documentation (Functional specification, Technical Design Documents), Integration, Code Deployment and unit testing, Client QA testing, and project delivery.

Team Size: - Mentor 5-9 People Team

Base Environment : Oracle 11g, SQL, PL/SQL Developer, SQL Developer, Jenkins, Tortoise SVN, XML

scripts, JAVA Scripts.

Product Environment: PLATFORM, APPSTUDIO, GRC etc.

Project Details: Spheregen Technologies Pvt. Ltd. Pune.

Product Details: Working on product MEDACIST for Hospital drugs management. It manages and dispense

and Administration of drugs.

Environment : Oracle 11g, SQL, PL/SQL Developer, SQL Navigator, SQL Developer, PVCS, Windows.

Work Experience on Product:-

1)Rebuilding of product with new logic comprises of database architecture and designing table structure. Developing new packages, procedures, sequences, triggers, collections, functions.

2)Unit testing cycle

Product Details:- Worked for client MBIA corporation, USA based client having Insurance software

Comprised of various interlaced products like MIDAS (Security), Spendmap, Counsillink

Feeds, PRA, Computron, GEAC, CLAIMS, CPMS, RPT (Reports), SAM, Teamtrack etc.

Environment : Oracle 11g, SQL, PL/SQL Developer, SQL Navigator, SQL Developer, PVCS, Windows.

Work Experience on Products:-

1) Work on listed products for issue solving, core bug resolutions, product enhancement for additional

functionality.

2) Performance tuning, provide consultation on product performance.

3) Developing database architecture and design for new enhancement on products.

4) Preparing Analysis report, documentation, testing and release procedure.

5) Handled MEDACIST project alone.

Project Details: INDUS, R SYSTEMS International Ltd. Pune.

Product Details – CNI (Commission and Incentive), CPF (Core Product Module), LOS (Loan Origination

System), LMS (Loan management System), RISK and RULE Module.

Environment : Oracle 10g and 11g, SQL, PL/SQL Developer, Tortoise SVN, Windows.

Work Experience on Products:-

1)Working on CNI, CPF products- Performance Tunning, preparing documents, Core bug issues fixes.

2)RISK and RULE Module- Documentation and defining Rules and Risk for associated Modules.

3)Working on CNI Airtel project (Telecom Domain), Performance Tunning, Product Issues fixes on Oracle 11g.

4)Working on Collections Product for AIR-CEL (Telecom Domain), Performance Tunning, Product Issue Fixes on Oracle 10g,

Project Details: TSYS Card Tech Services India Pvt. Ltd.

Product Details – Credit card product comprising of various interlaced modules like PRIME,

ONLINE, CASE MANAGEMENT & DISPUTE MANAGER, FRAUD GUARD, ONLINE.

Work experience on Products:

1) Projects on Product PRIME (Issuer & Acquirer).

2) Product CASE MANAGEMENT & DISPUTE MANAGER.

Work experience on Major Projects:

1)Certification for MasterCard Magstrip.

Title : PRIME3R02- Certification for MasterCard, Magstrip

Client : Axis Bank, Mumbai.

Duration : Sep-2009 to Feb-2010

Role : Analyst II.

Environment : Oracle9i, SQL, PL/SQL Developer, Windows.

Team Size : 4 people team.

Description:

Prime is BAU (Region) Project, for client AXIS Bank. This is the third version of PRIME Release 2, it’s been implemented for various clients worldwide who issues MasterCard credit Cards. This covers the full implementation of MasterCard Credit Card from Encoding, Embossing, Application processing, transaction processing cycle, payment gate-ways process i.e. MC (MasterCard) incoming file, MC (MasterCard) Outgoing file, settlement with the payment system i.e. Chargeback process etc till statement generation.

Key Responsibility:

This project I have handled and lead solely. I worked from PDP (Project Development Plan) discussion, Feasibility study, Analysis and customizations/Developments as following

Requirement Analysis of new business requirements.

Channels specification for payment system.

Development & Enhancement of Prime as per client’s requirements using Oracle PL/SQL.

PRIME Parameters settings for MasterCard specification.

PRIME JOBS creation of new threads creation for file generation.

Generation of MasterCard files (Outgoing and Incoming) as per Payment system MasterCard defined norms.

Internal QA, UAT & Project Go Live Support.

2) PRIME migration from 9i to 10g.

Title : PRIME3R01- PRIME Migration from 9i to 10g

Client : ICICI Bank, Mumbai.

Duration : Oct-2010 to April-2011

Role : Analyst II.

Environment : Oracle9i, 10g, SQL, PL/SQL Developer, Windows.

Team Size : 3 people team.

Description:

Prime is BAU (Region) Project, for client ICICI Bank. This is the third version of PRIME Release 1. This includes the complete implementation of PRIME product (PRIME customer application, PRIME Parameters, PRIME JOB Administrator) from 9i to 10g database.

Key Responsibility:

This project I had been handled and lead solely. I worked from PDP (Project Development Plan) discussion and writing, Analysis, specific client’s customizations and new Developments as following

Requirement Analysis of new business requirements.

Analysis of database objects compatible on 10g and modifications required.

Development & Enhancement of Prime including client’s specific customization and new developments as per client’s requirements using Oracle PL/SQL.

PRIME Parameters configuration and implementation on 10g.

PRIME JOBS Administration configuration and implementation on 10g.

Internal QA, UAT & Project Go Live Support.

3) UID (AADHAR CARD) for ICICI Bank. VISA project done in alliance with VISA,

ICICI, INFONOX and TSYS International Ltd.

Title : PRIME3R01- PRIME UID (Unique Identity)

Client : ICICI Bank, Mumbai.

Duration : March-2010 to Aug-2010

Role : Analyst II.

Environment : Oracle9i SQL, PL/SQL Developer, Windows.

Team Size : 2 people team.

Description:

Prime is BAU (Region) Project, for client ICICI Bank. This is the third version of PRIME Release 1. This includes the implementation of UID (Unique Identity).The customer will come to ICICI outlet/Bank and request for Credit card with UID the application being processed and file will be generated which will get approved and forwarded to TSYS and INFONOX then updations will be done in PRIME system and and generated file will be updated with VISA

Key Responsibility:

This project I had been handled and lead solely. I worked from PDP (Project Development Plan) discussion and writing, Analysis, specific client’s customizations as following

Requirement Analysis of new business requirements.

Application processing and implementation of generated file in system.

Development & Enhancement in Prime product as per client’s requirements using Oracle PL/SQL.

Loading the incoming file in system, extracting required information in format as per prescribed norms and updating the PRIME system data.

Generating outgoing file from the PRIME system after collections of required data in outgoing file format.

Internal QA, UAT & Project Go Live Support.

4) PRIME migration projects from 9i to 11g migration.

Title : PRIME3R02- PRIME Migration from 9i to 11g

Client : AXIS Bank, Mumbai.

Duration : Feb-2011 to till date

Role : Analyst II.

Environment : Oracle9i, 11g, SQL, PL/SQL Developer, Windows.

Team Size : 2 people team.

Description:

Prime is BAU (Region) Project, for client ICICI Bank. This is the third version of PRIME Release 1. This includes the complete implementation of PRIME product (PRIME customer application, PRIME Parameters, PRIME JOB Administrator) from 9i to 11g database.

Key Responsibility:

This project is been handled and lead solely. I worked from PDP (Project Development Plan) discussion and writing, Analysis, specific client’s customizations and new Developments as following

Requirement Analysis of new business requirements.

Analysis of database objects compatible on 10g and modifications required.

Development & Enhancement of Prime including client’s specific customization and new developments as per client’s requirements using Oracle PL/SQL.

PRIME Parameters configuration and implementation on 10g.

PRIME JOBS Administration configuration and implementation on 10g.

Key Responsibilities->

Product Development and Enhancement in PRIME & TS Prime using Oracle PL/SQL, Oracle Queues and Oracle Streams in oracle 10g/11g.

Developed various PL/SQL subprograms, procedures, functions, Packages and triggers, types, collections and query performance.

Create and manage schema objects Indexes, synonyms, sequences, views, Database Link.

SIT, QA, UAT & Project Go Live Support & Application Production Support.

Database Backup activity using expdp & impdp & transportation of table spaces,

Create & Manage Archive Log history.

Maintain the daily Project activities like JIRA and SVN maintenance, ECLIPSE.

Preparing projects technical documents, Interaction with client’s regarding functional requirements through e-mail or conference calls.

a) PDP (Project Development Plan) preparation (discussion & writing), document preparation related to C.R. (Change request)

b) TDN (Technical document Notes) preparation (discussion & writing).

c) PRIME Up-gradation (Prime 3Ro1, Prime3R02, Prime 3R03)

d) PRIME Installation & Configuration (Prime parameters, Prime job administrator, Prime collection,

Prime GL (General Ledger) etc.)

Project Details: Unitech Technologies Pvt. Ltd

Project : Gas booking system for client Swadhinta gas agency, Pune

Project purpose: The Gas booking system is developed for a gas agency .In this system

after installing the software on gas agency’s computer, the computer was connected to telephone

via modem so that when customer calls to agency the system receives the call and gives few

options referring numerical digits to customer for e.g. for booking gas number press ‘1’or for

registering complaint press ‘2’. In this way the customer of the gas agency can book their gas

number on phone and they can also know about the date of the delivery of the gas.

Tools used : Visual basic 6.0 and Oracle 8i, PL/SQL.

Team size/ Time required: 4 peoples/6 months (Mar 2003 to Aug 2003).

Role /Responsibilities: As a member of team, role-played in database designing, developments of forms generation and crystal report generation.

Worked For: Unitech Technologies Pvt. Ltd.

Project : Inventory Control System for client Volvo India Private Ltd., Bangalore

Project purpose: This software is an Inventory control project prepared for Volvo India Pvt. ltd.

This is prepared keeping in mind user friendliness by allowing user to enter only a few fields.

Reports have been created using Crystal-Reports.

Tools used : Visual Basic 6.0 and Oracle 8i, PL/SQL.

Team size/ Time required: 5 peoples/6 months (Sept 2003 to Mar 2004).

Role /Responsibilities: Role-played in coding, and generation forms and crystal report.

Worked For: Unitech Technologies Pvt. Ltd.

Project : Travel Allowances System for client YASHADA, Pune

Project Purpose: The project Travel Allowances system is a web based application and is

developed for the employees of YASHADA (A Govt. Organization). The Travel Allowances

system allows the employees of YASHADA to apply for travel allowances by getting online on

LAN. This system provides better approach for the accounts department of YASHADA to

maintain their database in proper manner.

Tools Used : Vbscript, JavaScript, ASP. IIS server 5.1, SQL server 2000 and Microsoft

Visual Interdev.

Team Size / Required period: 4 / 8 months (Apr 2004 to Dec 2004)

Role / Responsibilities: Design WebPages, designing database, creating tables, QA,testing.

Worked For: Unitech Technologies Pvt. Ltd.

Project : Hotel Management System.

Project purpose: The hotel management system was developed for the hotel employees to

manage the information about the customers from check-in till checkout. This system provides

the facility of advance booking for personal, family, corporate and conference booking. As well as

maintains the billing system, room services and keeps track on transportation services provided by

hotel to their customers.

Tools used : Developed in C++

Team size/ Time required: 4 peoples/5 months (Feb 2005 to July 2005).

Role /Responsibilities: designing algorithm, flow chart, coding and testing.

Worked For: Unitech Technologies Pvt. Ltd.

Project : Clinic Information System.

Project purpose: This software was developed to maintain the patient records. Clinic has the

facility of eyes check-up, dental, heart and laboratory. This software allows to maintains records of

appointments for the patient with respective doctor, keeps track of patient report and case history,

if the patient is bit serious then clinic have the facility to admit patient in clinic for 2-3 days. This

software handles the billing system and discharge details of the patient.

Tools used : developed using C++.

Team size/ Time required: 4 peoples/6 months (Aug 2005 to Jan 2006).

Role /Responsibilities: designing algorithm, flow chart, coding and testing.

Worked For: Unitech Technologies Pvt. Ltd.

Project Details: WebComInfo Pvt. Ltd

Project : Online Store for Client HM International, Delhi.

Project purpose: The purpose of this project was to develop a online garment store where the

customer can shop online. This application allows sale of all types of garments and any other article/item that manufacturer/ distributor wishes to attract business for using this application. It also supports the complete inventory management and provides inventory analysis reports. This module allows adding updating, discontinuing and removing items from the inventory system.

Tools used : ASP (vbscript and java script), Oracle 8i PL/SQL and Server used IIS 4.0

Team size/required period: 3 peoples /6 months (Mar 2002 to Aug 2002).

Role / Responsibilities: As a team member my responsibilities were to develop forms and to

develop master maintenance module (employees, privileges etc), normalization and creating tables

in database.

Worked For: WebComInfo Pvt. Ltd.

Project : Pay Role Package for client Karnataka Hybrid Micro Devices, Bangalore

Project purpose: This Software is very useful for companies to maintain the data of employees

of various Departments and Categories. The software generates monthly salary of all employees

and provides various Reports like Pay Slip, Wage Register, Individual annual wage register,

periodical statutory returns to be filed to various departments like ESI, PT, LIC, and Loan Reports

etc.

The salary is the amount earned by each employee per month consisting of earnings and

deductions like Basic Pay, Dearness Allowance, House Rent Allowance, Conveyance Allowance,

medical Allowance etc and Special Incentives like Attendance Bonus, Production Incentives, and

over time Allowance.

Tools used : Visual Basic 6.0 and Oracle 8i, PL/SQL.

Team size/ Time required: 4 peoples/5 months (Sept 2002 to Feb 2003).

Role /Responsibilities: Role-played in designing and development of forms and modules, coding, testing and report generation for the employees pay slip.

Worked For: WebComInfo Pvt. Ltd.

Personal Information:

Address : Harshada Apartment, flat no. 9, IIIrd floor, behind brahamgiri apt,

Survey no. 146, Dhayri (Garmal), Pune-411041.

Contact No. : +91-903*******/898-***-****. (020-********.

Date of birth : 22nd August 1972

Nationality : Indian

Passport number: holding Indian passport no. K6833684

ITPIN Number is: 901*********

Gender : Male

Marital Status : Married

E-mail : ac92se@r.postjobfree.com



Contact this candidate