Summary of Professional Experience

Software Industry experience of more than 6 years covering:
	Oracle Apps Forms, Reports customization
	Database Design
	Forms development in Developer 2000, Developer 6/6i.
	Backend development in SQL, PL/ SQL. Procedure creation,  
	Documentation adhering to SEI- CMM Level 5 Quality Standards.
	Actively performing the roles involving Requirement analysis, Design,
Development and Support.
	Writing and Executing Unit Test Plans, Unit Test Cases, Integration
Test Plans, and 
Integration Test Cases.
	Domain expertise includes Bills of Material, Purchase Order, Goods
Receipt Note, and Inventory Management System
	Written, verbal and interpersonal skills.

Specialized in 
	PL/SQL, SQL, Developer 6/6i.


Application/Functional areas/Packages worked on	Purchase Order, Good Receipt
Note, Inventory Management, Material requirement Planning System
Types of projects worked on	Full SDLC
Environments worked on	Windows 98, NT Workstation, Windows XP, Dec-Unix,
Sun-Solaris
Languages/Tools worked on	SQL, PL/SQL – Backend Programming, Oracle Apps,
Developer 2000 (Forms 6i/ 6/ 5/ 4.5   and Reports 6i/ 6/ 3.0/ 2.5), Oracle 8.x/
8i/ 7.x, 
Languages/Tools exposed to	Microsoft Project 2000, Microsoft Power point, Visio
7.0

Career Summary

Feb 04 – Nov ‘04     Mahindra British Telecom Ltd.
                                 Pune, India

Feb ‘02 – Jan ‘04     Zensar Technologies Ltd., 
                                 Pune, India

Sep ‘00 - Nov ‘01    Cummins Infotech Ltd., 
                                  Pune, India

Feb ‘00 – Sep ‘00     Thermax Software Solutions Ltd.,
                                 Pune, India

Sep ‘98 – Feb ‘00    Next Gen Technologies Ltd.,
                                 Pune, India

Dec ‘97 - Aug ‘98    Cummins India Ltd.,
                                 Pune, India

Education	:       Bachelor of Engineering (Electronics & Telecom), 
        May 1998, Cummins C.O.E., Poona University

Certifications:       Oracle Certified Professional (OCP)
		
Trainings:	         Oracle e-business suite (Oracle Apps.)   (Dec ’04 to Apr
‘05)
		         Completed full time course from Oracle Training Partner
         Extensive exposure to AP/ AR/ Inventory/ Finance/HRMS modules.
 
Significant Projects: (in reverse chronological order) 

Project Name :  Planning, Assignment and Configuration System (PACS)
Organization  :  Mahindra British Telecom Ltd, Pune, India
Client              :  British Telecom, UK
Location         :  Pune/ India
Duration         :  Feb ‘04 to Nov’ 04
Role                :  Analyst / DB module lead
Environment :  Oracle 8i,Toad, Visio, MS Excel, Pentium PCs  
Description    : 
PACS – Planning, Assignment and Configuration System (PACS) is one of the
Network Provisioning Systems of the customer’s Synchronous Digital Hierarchy
(SDH) network.  It comprises of order handling, planning, assignment and
configuration sub systems. Planning sub system allows the plan and creation of
network equipment and capacities over which the customer circuit is delivered.
UMT – Utilization Measurement Tool will help in planner to use the existing
network optimally (if possible) before planning any new equipment. Data from PACS
is transferred and stored in UMT, which is used for analysis. UMT is web based
system where JavaScript, oracle web packages are highly used. UMT has strong
PL/SQL base and complex queries have been used for the reporting features.
Responsibilities :
•	To understand the requirement definition of the change. Analyze impact and
develop or modify the code for the change. 
•	Prepare test cases for the different scenarios to test application after code
change.  
•	Resolve the faults existing /appearing in the application.          
•	Resolve performance related issues.
•	Worked on Oracle advance Queues.
•	Grasped domain knowledge of telecom domain used in the project in order to
work productively in UMT with the demanded time scale.

Project Name :  Learning Partner Mgmt System (LPMS)
Organization  :  Zensar Technologies Ltd., Pune , India
Client              :  Cisco, USA
Location         :  Pune/ India
Duration         :  Feb ‘02 to Jan ‘04
Role                :  Analyst / DB module lead
Environment :  Oracle 8i, JSP, Servlet, Toad, Visio, MS project, MS Excel
Description    : 
LPMS involved fresh analysis, design and re-architecture of the legacy TPMS
system per the new business needs. A number of new functionalities for online
entry and approvals were incorporated for the Learning Partners and a set of user
friendly tools were created. LPMS has been developed in Java using JSP-Servlet
and MVC. The User experience complies with the new Cisco.com (CDC) standards.
Business Rules and the control functionalities are incorporate into backend.
Processing of all transactions is done using backend packages. 
Responsibilities :
•	To understand the existing legacy system and its functionality. Analyze the
system for redesigning as per new business rules and requirements.
•	Prepare the analysis data with business rules to map with the new application
requirements. 
•	Structuring requirement specifications and scheduling the activities, so as to
generate the analysis documents for the new development. 	
•	Database designing and implementation using the concepts of OOAD.
•	Data migration from old to new system.
•	Plan activities for database related development for new web based
application.
•	Database Synch activities between legacy application and new application.
.  
Project Name :  Sales Order Management System
Organization  :  Cummins Infotech Ltd., Pune, India
Client              :  Fleetguard, USA
Location         :  Pune/ India
Duration         :  Jul ‘01 to Nov ‘01
Role                :  Module Leader
Environment :  Oracle 8i, Developer 6i, and MS Project
Description    : 
Sales order management system had defined transactions and set of transactional
screens. The system managed the sale of the engine and the order scheduling,
execution of order in system. 
Responsibilities :
•	Responsible to understand the system and functional, requirement
specifications and schedule the activities. Adding/modifying procedures,
function, triggers forms and reports incorporated the changes in the system. 
•	Testing of each component as per test plan before delivery.

Project Name :  Business Management System
Organization  : Cummins Infotech Ltd., Pune, India
Client              :  Cummins Power Solution Limited
Location         :  Pune/ India
Duration         :  Feb '00 to Jun '01
Role                :  Module Leader 
Environment  :  Oracle 8i, Developer 6i, MS Project, MS Word, Toad, Sun Solaris,
Pentium III
Description    : 
Business management system for tracking the asset movement right from purchase /
hire to rent / sale. The system captured the assent movement from purchasing or
hiring, to the rent or sale to customer. This was to provide all information of
fleet like location, contract duration, charging, availability of sets and its
movement. The system kept information of all fleet items, contract details,
commission details, operation data and closing records. The system provided MIS
requirement to see the types of fleet items in contract, under acquisition and
under sale. 
Responsibilities :
•	Responsible for preparing system/ functional requirement specifications
document and database design. 
•	Developing common templates for system, object libraries and PL/SQL libraries
of common functions in PL-SQL server side and client side. 
•	Responsible to complete UAT and train the users on the system.

Project Name :  Web Parts
Organization  : Cummins Infotech Ltd., Pune, India
Client              :  Cummins Latin America, Brazil 
Location         :  Pune/ India
Duration         :  Dec ‘00 to Feb ‘01
Role                :  Team Leader 
Environment :  Oracle 8.0, Cold fusion 5.0, Sun Solaris, IBM PC Pentium III
Description    : 
Web parts system was a set of web pages to access the parts information data on
web. This was to provide all information on web for the distributors and
authorized dealers. It also allowed ordering spare parts on web by using shopping
cart, online order entry form, and file uploads method on web. Web parts had
multilingual support of Spanish and Portuguese language. Dealers could view the
parts data on web in 3 different languages.
Responsibilities :
•	Prepared requirement analysis
•	Functional and change control documents. 
•	As Oracle support for the application, responsible for database design,
writing PL/SQL program units and triggers. 

Project Name : eGEM (Empowering Global Employee Management)
Organization  :  Cummins Infotech Ltd., Pune, India
Client              :  Cummins India Ltd., Pune, India
Location         :  Pune/ India
Duration         :  Sep '00 to Nov '00
Role                :  Technical Representative
Environment :  Oracle Apps 10.x
Description    : 
Cummins worldwide entities had to be connected together in HRMS suit of Oracle
11i.  HRMS catered the needs of human resources functionality. eGEM project had
the ability to link with existing payroll system and to facilitate other
dependent systems. eGEM was held at Singapore to discuss on the implementation
plan of HRMS 11i
Responsibilities :
•	As a Technical representative from India attend the conference held at
Singapore. Discussing about the implementation phases and planning for the
worldwide approach to complete the implementation. 
•	Understood the process in HRMS and to map/customize the current human
resources activities in Cummins India. Analyse Multilingual functionality in HRMS
suit for implementation.
•	Plan the implementation of HRMS at different locations of Cummins worldwide
branches. 

Project Name :  Enterprise Wide Solution.
Organization  :  Thermax Software Systems Ltd Pune, India
Client              :  Finolex Industries Limited. Chinchwad, Pune, India
Location         :  Pune/ India
Duration         :  Feb ‘00 to Jul ‘00
Role                :  Module Leader
Environment :  Oracle 8.0, Developer6i, MS Word, Designer 2000, MS Project ,Sun
Solaris, 
   IBM PC Pentium III
Description    : 
Finolex Industries Limited was involved in manufacturing of pipes. Enterprise
wide solution had three major modules viz. sales and marketing, inventory and
purchase and finance.
The system included all transaction involved in departments like sales and
marketing, Inventory and purchase and account. The system acted as a centralized
data required for all the transactions and did the linked transactions. 
Responsibilities :
•	Preparation of system / functional requirement specification documents and
planning / scheduling of the module. 
•	Developed Forms template and PL/SQL libraries of common functionalities.
Creation of back end program units. 

Project Name : Payroll and Time Attendance System
Organization  :  Next Gen Technologies Pune, India
Client              :  Cummins India Limited Pune, India
Location         :  Pune/ India
Duration         :  Sep’99 to Feb ‘00
Role                :  Module Leader
Environment :  Oracle 8.0, Developer 6
Description    : 
Payroll and attendance system captured the employee attendance data in flat file
generated by swap card Hardware unit. Using attendance data and other information
system runs the payroll for each employee in every month. 
Responsibilities :
•	Responsible for system requirement analysis, documentation, development and
testing. 
•	Involved in data uploading of all masters from existing Ingress database into
the master tables for pay roll calculations


Project Name : Imports Account System
Organization  : Next Gen Technologies Pune, India
Client                   :  Cummins India Limited, Pune, India
Location         :  Pune/ India
Duration         :  Sep ‘98 to Sep ‘99
Role                	:  Programmer/Analyst
Environment :  Oracle 8.0, Developer 2000 (Forms 5.0, Report 2.5), MS project,
Pentium III
Description    : 
Cummins India Ltd. was involved in manufacturing of diesel engines. The system
was developed to keep accounting of imported parts required for Engine
manufacturing. The system handled it in three different modules viz. planning,
foreign exchange and bill passing.
Electronics Data Interchange (EDI) transmission for sending delivery schedule
(Purchase order) and receiving invoices through service provider using
EDIFACT92.1 & EDIFACT97A.
Responsibilities :
•	Work for planning module in accounts system. 
•	Development and implementation of planning module. 
•	Uploading the data from existing Ingress database to new database. The
planning module consisted of creation of various documents such as Indent,
purchase order, invoices, and vendor bills forms. 
•	Designed an application to generate data from Oracle database for EDI
transmission.
•	UAT for the planning module after implementation.

Project Name : Training System.
Organization  :  Cummins India Limited, Pune, India
Client              :  Cummins India Limited, Pune, India
Location         :  Pune/ India
Duration         :  Mar ‘98 to Jun ‘98
Role                :  Programmer/Analyst
Environment :  Oracle 7.3, Developer 2000 (Forms 4.5, Report 2.3), MS Word,
Pentium III
Description    : 
Cummins India Ltd. conducted various training programs for their employee’s,
viz.
	Technical training for workers
	Personality development and Induction training programs for new
entrants. 
The system kept track of employee’s technical and personal skill levels.
Training programs were executed as per requirements of various departments, or as
per the schedule designed by the training department, or as suggested by the
personal department. The system maintained Information of different programs with
interactive data such as images of trained employees, their skill levels
(Individual Skill Matrix), and further requirements training programs (Functional
Skill Matrix) for other departments. 
Responsibilities :
•	Requirement analysis and development of the set of transactions. Complete
development in backend and front end. 
•	Interaction with head of training department and the users of the proposed
system.



Project Name :  EUC Audit System
Organization  : Cummins India Limited, Pune, India
Client     	: Cummins India Limited, Pune, India
Location         :  Pune/ India
Duration         :  Dec '97 to Mar '98
Role                :  Module Leader
Environment :  Oracle 7.x Developer (Forms 4.5, Reports2.3), MS Excel, IBM
compatible PC
Description    : 
End user computing audit system was mainly concentrated on the maintenance of
the PC’s in organization located in different departments and use for different
purpose. End user computing included details of each PC viz. Owner, location,
hardware configuration, software installed and used for etc.
Responsibilities :
•	Designed and developed the system in PC maintenance department. 
•	Upload of data from MS Excel to Oracle, preparation of user manual, system
implementation with user training.