Posted by on September 17, 19102 at 04:50:31:

SUMMARY

As a Software Engineer with over 4 years of experience in Software Application Design, Database Design, Development in the E-Commerce and Client-Server Technology Environment and 1 year Experience in Mechanical Engineering field.

SKILLS

Languages SQL, PL/SQL, TSQL, Cobol and Java

Tools DBA Studio (Oracle 8.1.6), Workflow Bench (Firebird) Erwin, Toad, Rational Rose, Visual Interdev 6.0, DreamWeaver 3.0 and Visual Source Safe 6.0

Databases Oracle7.3, Oracle 8.1.7, SQL-Server 7.0 and Firebird

Others Developer 2000(Forms 4.5, Reports 2.5),
Developer 2000(Forms 5, Report 3), Visual Basic 6.0, HTML, XML, JavaScript, VBScript, ASP 3.0,
COM+, Cold Fusion 4.5, Kawa 4.01a

Operating System Windows 2000 Advanced Server, MVS, Windows NT 4.0, Windows 98/95, Unix

Hardware IBM-PC Compatibles

WORK EXPERIENCE

· Patni Computer System Ltd (SEI-CMM Level 5, ISO 9001 Certified)
From Sep 00 to Jul 02 - Software Engineer.

· Clover Technologies Pvt. Ltd (Excellence in Oracle Application Development and
DBA Support)
From May 99 to Oct 00 - Programmer

· Append Computer System
From Jan 98 to April 99 - Programmer

· Kinetic Engineering Ltd (Excellence in Automobile Engineering, ISO 9001 Certified)
From Dec 96 to Dec 97 - Mechanical Engineer

PROFESSIONAL EXPERIENCE

A) Patni Computer System Ltd. Pune.

Project Boiler Management System
Platform Windows NT 4.0, Oracle 8.1.6, Firebird, ASP.
Duration 1.5 Months
Client Core Corporation, Japan

Core Corporation is the Product Development Company. Boiler Management System is one of the products of Core Corporation.
Boiler Management System provides features like Maintain the all information of Boiler.
BMS(Boiler Management System) is using Oracle Database at Backend.
This Project was a Migration Project. Migration is from Oracle to Firebird (New database)

As a Programmer and Database Administrator I was responsible for following tasks:
· System Study
· Database Activities
· Preparing Test Cases and Test Case Results.
· Peer-to-Peer Quality review.

Project Penton ISP-World Web Site
Platform Windows 2000 Advance Server, Oracle 8.1.6, D2k, HTML.
Duration 1 Months
Client Penton, USA

Penton is group of ISP’s (Internet Service Provider).
The Project was the changing Design of 3000 existing HTML pages and Development of
Such module, which maintains the Information of ISP’s.

I was responsible for following tasks:
· System Study
· Redevelopment of Existing HTML pages
· Form Development for ISP.
· Database Activities
· Peer-to-Peer Quality review.

Project GSS Siebel Adapter
Platform Windows NT 4.0, Weblogic server 6.0 SP1 with EJB upgrade 2.0, Java1.3.0_02, XML Spy, GSS2.0 (Gluon System Syndicator), Siebel Server 6.3.2, Oracle 8.1.6, Kawa 4.01a, Visual Source Safe 6.0, Rational Rose 2001, IBM PC Compatibles.
Duration 4 Months
Client Gluon Partners Ltd, Tokyo, Japan

GSS (Gluon System Syndicator) is a middleware solution developed by Gluon Partners for the B2Bi and EAI integration. The GSS System provides features like business message exchange between trading partners, Integration of the business messages with the back office applications and Enterprise Application Interaction within organization.

The Siebel Adapter for GSS is an integration solution that allows information exchange between Siebel application and GSS System. The GSS system in-turn routes this message to other systems such as ERP, Scheduling, and Planning Systems or to the trading partners. This integration offers powerful capabilities designed to meet the sales, marketing, and customer service requirements.

As a Programmer and Database Administrator I was responsible for following tasks:
· System Analysis and Design.
· Database Design.
· Database Activities
· Preparing Program Specification, Test Cases and Test Results
· Coding of common classes
· GUI Development for GSS Siebel Adapter
· Peer-to-Peer Quality review.

Project Fundamental Reservation Administration Management Environment (FRAME)
Platform Windows 2000 Advanced Server with IIS 5.0, COM+ (MTS 4.0), VB6.0, XML, Rational Rose, Erwin, Visual Interdev 6.0, ASP 3.0, VB Script, Java Script, DreamWeaver 3.0, MS SQL Server 7.0, Visual Source Safe 6.0
Duration 9 Months
Client Kuoni Travels India Ltd. (KTIL), Mumbai, India

KTIL is the owner of the brand SOTC World Famous Tours, a brand that commands more than 55% of the Outbound tours market share. SOTC products are marketed by 12 branches, 50 GSA and 12 area sales offices besides the close to 3000 travel agencies around the world.
The project is a complete turnkey solution. The purpose of this system is mainly to build an Intranet application for SOTC SBU that will service its functional areas of Product Design, Product Set-up, Sales Administration, Tour Operations and also the Financial Accounting for its operations at the Central office in Mumbai and the 12 branches.

I was responsible for following tasks:
· Screen Designs.
· Database Design of the Module Product Marketing Team.
· Database Activities
· Preparing Functional Specification, Program Specification
· Preparing Test Cases and Test Case Results.
· Coding of Assigned Module.
· Peer-to-Peer Quality review.

B) Clover Technologies Pvt. Ltd. Pune.

Project Clover Intranet
Platform Cold Fusion 4.5, Oracle8i, DreamWeaver 3.0 and Windows NT
Duration 6 Months
Client Clover Technologies Pvt. Ltd, Pune, India

Clover Technologies is one of the leading DBA Support and Client Server Development Company.

The System is use for on line working HR System, Admin, and Marketing department.
In HR System employees can enter and update their resumes and their personal details. HR can get all information about Employees with search option.

As a Group Leader/Programmer I was responsible for following tasks:
· Analyses the requirement
· Database Design
· Database Activities
· Creating custom report
· Coding for Screens

Project Order Processing and Billing System
Platform HP 9000, Windows NT, Oracle 7.3, Developer 2000 Forms 4.5 and Reports 2.5
Duration 5 Months
Client Associated Cement companies (ACC), Pune, India

ACC is one of leading Cement Manufactures in India. It has the highest capacity in terms of cement production and sales. It’s distribution network is the best in India and it has got distributors spread across every district in India.

This system is designed for the regional marketing offices throughout the country, the system facilitates the organization with supply orders, Billing, Keeping track of the deposits and interest on the same.
The system has interfaces with other external system like Warehouse maintenance systems at the warehouses, which send inputs to the system.
The system aggregates the information from the different warehouses and provides the data for the sales journal generation.

I have worked at the Client Site, in Pune Head Branch. I was responsible for following tasks:
· Requirement gathering and analysis
· Testing the current System
· Coding and Modifying for Billing System, which requested by the customers
· Providing Information to the Clover Technologies
· Production Support
· User Support

Project R.A. Conference System
Platform Windows NT, Oracle 7.3, Developer 2000 Forms 4.5 and Reports 2.5
Duration 5 months
Client Dena Bank, Mumbai, India

Dena Bank is one of the leading Bank in Mumbai.

This system collects the data from all the regional offices of Dena Bank. This data consists of the deposits, advances, which are contributed towards the hotel, small scale and some other industries. Based on this data the MIS reports are generated.

I was responsible for following tasks:
· Coding for New Reports as per client’s requirement
· Modifying the existing Report and getting it reviewed by the client
· Reviewing the code changes

Project Sales and Marketing System
Platform Windows NT, Oracle 7.3, Developer 2000 Forms 5 and Reports 3.
Duration 4 months
Client Clover Construction Pvt. Ltd, Pune, India

Clover Construction is one of the leading Construction Company in the Maharashatra.

The system is developed to meet the Marketing needs of the organisation. It consists of Customer Entry, Customer Visit details, Customer details, Customer contact person details, Company Executive details, Executive target details, Customer Hardware and Software details

My responsibilities was as an Analyst/Programmer included:
· Requirement gathering and analysis
· Database Design
· Database Activities
· Coding, Review of the code and Testing the code with Test Data.

Project On Line Evaluation Test
Platform Oracle 7.3, Developer 2000 Forms 5.0 and Reports 3.0
Duration 2 Months
Client Clover Technologies Pvt. Ltd.

Clover Technologies is one of the leading DBA Support and Client Server Development Company.

The system manages the Applicant details. The system can handle various type of papers.
It can also update questions in various papers. The System gives result immediately to the Applicant, who has given On Line Test.

I was responsible for following tasks:
· Requirement gathering and analysis,
· Database Design
· Database Activities
· Coding, Review of the code and testing the code with Test Data,

C) Append Computer System. Pune.

Project Student Information Management System
Platform Oracle 7.3, Developer 2000 Forms 5.0 and Reports 3.0
Duration 6 Months
Client Department of Vocational Education and Training, Maharashatra, India

Department of Vocational Education and Training is a central govt. organisation, which keeps the information about all the students who pass the I.T.I (Industrial training institute) course and helps them in getting apprentice ship in companies.

The system gives information about student’s personal details, and details about exams, students performance in company.

My responsibilities as Analyst/programmer included:
· Requirement gathering and analysis,
· Database Design
· Coding, Review of the code and testing the code with Test Data,

D) Kinetic Engineering Ltd. Pune.

Duration : 12 Months

Role: During the period at company I was involved with the production and inspection of Cylinder Head designed for K4-100 Engine head. While at works under inspection department I have played a key role for inspecting engine parts and accessories.

EDUCATION

· Diploma in Mechanical Engineering 1996, B.T.E. Mumbai, India

CERTIFICATION

· Cold Fusion 4.5 Programmer – Brainbench.com
· Best Team Awards – Patni Computer Systems Ltd.
· Internal Quality Audit Best Project Team Awards – Patni Computer Systems Ltd.

PERSONAL INFORMATION

Address : Sno 629/2/2 Silver Estates, Bld. No. B1 Flat No. 1,
Bibwewadi Pune 411037, Maharashtra.

Date of Birth : 11 June 1976

Language : English, Hindi, Marathi, Learning Japanese Language.

Nationality : Indian

Sex : Male

Marital status : Single

Passport : Valid upto 15 March 2008

Email : onlyabhay@rediffmail.com
abhaypanchwagh@yahoo.com

Contact : 91-020-4212687 (Residence)