EDUCATION

· Master of Computer Applications ( Major Computer Science ) from University Of Allahabad, ALLAHABAD - INDIA ( June 1994 )
· Bachelor of Science in ( Major Physics and Maths) from University of Gorakhpur INDIA ( July 1990 )

EXPERIENCE

I have more than 7 Years of Software Design and Development experience in various companies. This includes Analysis, Design, Development, Testing and Implementation of applications. In the recent years I have gained lots of experience in Project Management / Team management.

SKILLS

My main skill area is to Design / Develop Software applications and support of mission critical ORACLE databases ( Oracle DBA ) . Other skills includes the Management of very Large volume of ORACLE Database and Project Management/Team Leadership. Also my skills include various style of JDBC programming, the way the communication protocol has to be made from Java to Oracle with many various flavors of JDBC Drivers based on Web based Applications.

WORK EXPERIENCE

Company : Sun MicroSystems Inc
Title : IR SW Systems Engr ( Oracle DBA )
Location : Newark, CA
From : March 2000 - Till Date
Job Description :
I am involved in Development, Design and Implementation of Collection Management products for SunCollect applications are being implemented in various Countries to help running it's business more efficiently. I am also involved in managing large volume of database responsible for the application, performing Database Tuning for proper functioning of these Databases. My role is also to make sure the Databases are running properly without any Problems. It includes plan for regular backups, running batch jobs , Loading Data from flat files. In the recent years I have gained lots of experience in Project Management / Team management by managing teams for Development and design of the Product.
 

Company : Offshore Digital Services Inc (A subsidiary of Sonata Software ltd)
Title : Analyst Programmer
Location : USA
From : November 1998 To March 2000
Job Description :
I was involved in Development, Implementation and Customer Support of various applications in Client companies. I was also involved in managing large volume of database, performing Database Tuning. My role was also to make sure the Databases are running properly without any Problems. It includes taking regular backups, running batches, Loading Data from flat files, Talking to various users for their changing requirement etc.

Company : Sonata Software Ltd, BANGALORE INDIA
Title : Systems Analyst
Location : INDIA , United Kingdom
From : July 1996 To November 1998
Job Description :
I was involved in design development and implementation of various projects for various Clients of Sonata in UK and INDIA and provided Support for the applications too. Learned the skills to Develop Internet based Applications using various techniques including JDBC implementation to interact with Oracle Database. I was on onsite assignment in UK from March 1997 until June 1998.

Company : Electronics Corporation Of INDIA Ltd, HYDERABAD INDIA
Title : Software Engineer
Location : INDIA
From : July 1994 To July 1996
Job Description :
I learned ORACLE, PL/SQL, Pro *C, Sql *Forms 3.0 and after that I started developing applications using these tools based on Technical/Functional Specs provided. I was also involved in Implementing and Supporting the application at Customer site later.

DETAILS OF PROFESSIONAL HISTORY

1. October 2001 – Till date

SunCollect Merge (Sun Microsystems Inc.) Newark, USA

I am responsible for designing the new architecture of SunCollect product, due to worldwide change in the existing architecture of legacy system MFGPRO to Oracle ERP as a strategic decision.

In this role I am responsible for working with Business users to gather requirements, Design reviews with the Developers to achieve the goal of Merging SunCollect in one instance for Long term gain of product in terms of supportability.

My responsibilities includes

. Identify the resources ( System and people resources )
. Worked with Cross IT orgs to successfully deliver the product
· Analyzed System Requirements after analyzing the Oracle Accounts Receivable ( source for this system )
· Deliver Functional Specs to satisfy the business requirement.
. Keep track of Development team activity regarding Development of Project
. Increase morale of team by providing support as and when needed within scope of organization.

ENVIRONMENT:     Enact ( Project management Tool by Critical path ) , Oracle 8i (Oracle 8.17), PL/SQL 8.1.7, JAVA1.1.7, HTML4.2, Solaris 2.7, Solaris 8, SilverRun (A case tool), iPlanet Web Server,  Oracle Enterprise Manager, Oracle Financials ( AR)

2. February 2001 – September 2001 ( Project Lead )
Collection Management for Enterprise Services (Sun Microsystems Inc.) Newark, USA

In this role I Successfully implemented the product as per plan of the Project. I was responsible for Managing the Team, weekly communication/status update to Business, gathering User requirements, Design reviews with the Developers etc.

As a part of total Project management, I was involved in following activities

. Identify the resources ( System and people resources )
. Worked with Cross IT orgs to successfully deliver the product
· Analyzed System Requirements after analyzing the Oracle Accounts Receivable ( source for this system )
· Written Functional Specs to satisfy the business requirement.
. Keep track of Development team activity regarding Development of Project
. Increase morale of team by providing support as and when needed within scope of organization.
. Major Performance tuning to improve the Performance of Oracle Database and Batch jobs.

ENVIRONMENT:    Enact ( Project management Tool by Critical path ) , Oracle 8i (Oracle 8.17), PL/SQL 8.1.7, JAVA1.1.7, HTML4.2, Solaris 2.7, Solaris 8, SilverRun (A case tool), iPlanet Web Server,  Oracle Enterprise Manager, Oracle Financials ( AR)

3. March 2000 – January 2001
Dispute Management (Sun Microsystems Inc.) Newark, USA

This is an automated system being developed for Finance Users to effectively collect the Dollar amount for the various invoices which are in Dispute. I am involved in Design and Development of the System. I am also involved in supporting the Oracle Database for the Existing SunCollect. This involves Upgrades of the Databases to the new release and making the System availability high.

As a part of Design, Development , I am involved in following activities

· Analyzed User Requirements for the new Dispute Management module
· Analyzing the feasibility of the new Module
· Written Technical Specs to satisfy the business requirement.
· Day to day Support for European and US SunCollect.
· Communicating with Oracle Database from Java using JDBC to get and maintain the Finance Data.
. evaluate new product for Databases, which are suitable for the application future needs.
. Giving input for Designing the Web Site for the Product effectively.

ENVIRONMENT:     Oracle 8.0.4 , Oracle 8i (Oracle 8.1.6 Release 2), PL/SQL 8.0, JAVA1.1, HTML4.2, Solaris 2.7, Solaris 8, SilverRun (A case tool), Java Web Server

4. July 1999 – March 2000
SunCollect (Sun Microsystems Inc.) Newark, USA

This is an automated collection flow system used in various offices of Sun Microsystems in European Countries. I am involved in Implementing   the system and Customer Support in the European Countries.

As a part of Design, Development and Implementation Team, I was involved in following activities

· Analyzed User Requirements.
· Written Technical Specs to satisfy the business requirement.
· Migrating Application from individual Country Servers to Consolidated Server.
· Used Oracle 8.0, oracle 8i export and Import extensively to migrate this application onto single Database.
· Used Sql*Loader to Load the Flat files into the Oracle tables.
· Day to day Support for European and US SunCollect.
· Enhancing the Schema after doing Analysis.
· Working On Stored Procedures and Packages.
. Tuned Oracle Database to improve the performance of the application.

ENVIRONMENT: Oracle 8.0.4, Oracle 8i, PL/SQL 8.0, JAVA1.1, HTM4.2, Solaris 2.6. JDBC

5. November 1998 - June 1999
PBW Customer Care & Billing System (Telegence) Pacific Bell Wireless) Pleasanton, USA

The system was designed to meet the requirements of Customer Care and billing needs of Wireless and Telecommunication Companies. It comprises of various modules like Billing, Collections, Accounts Receivable, Customer Support Management, Dealer Compensation etc

As a part of Development and Implementation Team, , I was involved in following activities

· Migration of Data to Telegence (Developed by Amdocs) from the Existing BSCS(LegacyDatabase ).
· Developed Various Reports using PL/SQL, SQL* Plus with the new Telegence Database.
· Developed "Developer 2000 Reports" like Credit Card Payments, Follow Up Totals, Unpaid deposit of Customers etc, Rate Plan Migration for  end  Users based on their requirements.
· Customer Support activity to satisfy Customer requirements.
· Performed various SQL tuning like Explain Plan, Hints, because of Large volume of data being processed.
· Written Various Unix Shell Scripts to perform various batch jobs.

ENVIRONMENT: Oracle 8.0, Oracle 7.3, PL/SQL 2.3, PL/SQL8.0, Oracle Reports, Procedure Builder, TOAD (Tool For Oracle Application Development), Telegence Online, Winframe Client , Vista 1.0

6. July 1998 - October 1998
Sonata Club Information System (Bangalore, INDIA)

This application is being developed for internal usage of our company. This project gives on line information of the members like when they joined the club, what are their hobbies etc. All the members are given their email account and the password. Whenever they want to access the system they have to enter their email and password to verify themselves as the valid user. Password can be modified by Password module at any time as and when required by the member. We are developing this system using NCA (Network Computing Architecture ) concepts. We are using Oracle Web Application Server as middle ware and Oracle 8.03 as the database.

I was involved in -

· Developing 15 Database Packages
· Installation and configuration Web Application Server
· Working with new feature of Oracle 8 like object oriented databas
· Working with PL / SQL Cartridge
· Working with HTP,HTF,OWA,OWS packages
· Producing Dynamic as well as static HTML pages

In a team of 4 , I was responsible for leading the design and development.

ENVIRONMENT: Windows NT 4.0, Oracle Web Application server 3.0, Oracle 8.03, Pl/SQL 8.0.3, Java Script and Visual page

7. January 1998 - June 1998
Sun Oracle Integrated Logistics (SOLEIL). Sun Microsystems Inc. ( Camberley, UK )

The application was a real time system developed in Sun Microsystems UK, being used in Sun Microsystems offices throughout Europe. It was a conversion from the traditional character based Forms 3.0 to GUI Forms 4.5 running in Character base. The project dealt with various Inventories, Finance etc throughout Sun Offices across Europe.

I was involved in -

ENVIRONMENT:  Sun-Solaris, Oracle 7.3, Forms 3.0, Forms 4.5, PL / SQL 2.3, Reports 2.0, Reports 2.5, Pro *C 2.0, Procedure Builder, HTML 3.2, Dev Guide 1.0

8. July 1997 – December 1997
Metering Asset Register Systems (MARS)  Scottish Power plc. ( East Kilbride, Glasgow, SCOTLAND )

The project is designed to help in all activities of Scottish Power Plc Scotland, UK in helping to achieve its goal to provide a common functionality for the different suppliers of electricity as part of their Change 1998 programme. The project was maintaining the various suppliers of electricity and the form in which they were charging to their customers. After getting all the data from the suppliers it was being populated in the unique format, so that to maintain a standard format for the electricity regulation in UK.

In a team of 10 , I was Involved in

· Development and Testing.
· Preparing technical specifications for 10 modules.
· Backend development in Oracle Version 7.3.
· Written batch processing
· PL/SQL stored procedures, functions and packages to move bulk data and other necessary processing. These procedures and functions are being developed using PL/SQL 2.3 which has the latest facilities such as DBMS UTILITY.UTL FILE for I/O operation Cursor variables (Referenced data-type) and PL/SQL tables.
· Preparing Unit test plan, Test documents
· Writing Test harness.

ENVIRONMENT:     Designer 2000, Developer 2000, Forms 3.0 Forms 4.5, Reports 2.5 Oracle 7.1, Unix Sql*Plus

9. March 1997 - June 1997
Banner Customer Information. SCT Ltd. ( MANCHESTER, UK )

The software is designed to help in all customer related services of North West plc UK. Billing and collection for the various reasons can be made through the application.

I was involved in -

· Developed Work Order Generation, Completion, Master Bill Printing, Identification of sensitive addresses batch processes etc. using Pro*C and Forms 4.5
· Development of Batch processing job for the project.
· Development of Forms in Forms 4.5 using features of alerts, libraries, VBX controls and other GUI features.
· Modification of some of the database triggers and procedures for the application.
· Working extensively on DBMS PIPE package to call the external 3GL features from Forms 4.5.

In a team of 10 , I was responsible for Development and Testing.

ENVIRONMENT: Pro*C 2.0 1.6, Forms 4.5, Oracle 7.x PL/SQL 2.x Unix SQL*Plus

10. October 1996 - February 1997
Conversion Project (Bangalore, INDIA)

This involved study and identification of conversion methodologies for Forms 3.0 to Forms 4.5. There are three methods to convert Forms 3.0 application to Forms 4.5.

I was involved in -

· Using default generator(f45gen) provided by Oracle
· Giving inputs for manual conversion of Forms 3.0 application using Reverse engineering
· Developing the standard procedures to convert the application.
· Re-engineering the database and forms to generate developer 2000 specific executables using Designer 2000.

In a team of 4 , I was responsible for the conversion methodology formulation.

ENVIRONMENT:   Designer 2000, Developer 2000, Forms 3.0 Forms 4.5, Reports 2.5, Oracle 7.1, Unix, Sql*Plus

11. July 1996 - September 1996
Personnel Information System (Bangalore, INDIA)

This software is designed to provide information for its employees in an organization with decision support available. This package maintains information about the employees like date of joining, skill areas and total experience etc.

I was Involved in -
· Development of software
· Using various features of GUI interface, property classes, object groups, attached library advanced features like VBX controls, OLE etc. This application developed 5 forms and 3 reports.

In a team of 3 , I was responsible for Analysis and Development of the system.

ENVIRONMENT:   Windows 95, Oracle 7.1, Developer 2000, Forms 4.5, Reports 2.5 Unix, Sql*Plus

12. December 1995 - June 1996
Purchase Management System (HYDERABAD, INDIA)

This software is designed to purchase analysis and central purchasing needs of transaction system with decision support. This package maintains information about Quotations submitted to various Vendors, Purchase orders given by them.

I was involved in -
· Development of software
· Including various features like generation of vendor master, quotation raised by supplier using Forms 4.5 features.
· Using TEXT_IO package for manipulating texts from operating system file.
· Development of 8 forms and 4 reports.

In a team of 4 , I was responsible for Analysis and Development

ENVIRONMENT:  Windows 95, Oracle 7.0, Developer 2000, Forms 4.5, Reports 2.5 Unix Sql*Plus

13. March 1995 - October 1995
Integrated Material Management System (HYDERABAD, INDIA)

This is computerization of a manufacturing system of any stores department. The IMMS system is aimed at facilitating the stores department in material requirement planning, procurement of material, and issuing of material to various user departments.

I was involved in -
· This application is developed using various database triggers, packages, stores procedures.
· Also used DBMS packages like DBMS_PIPE_DBMS_ALERT to communicate to the various session and alert the user for specific job.
· Development of complex report using Pro*C.
· Development of 15 forms and 6 reports.

In a team of 6 , I was responsible for Development and Testing

ENVIRONMENT:     Oracle 7.0, Forms 3.0, Reports 1.1, PL/SQL 2.0, Pro*C Unix, Sql*Plus

14. October 1994 - February 1995
Material Management System (HYDERABAD, INDIA)

The MMS System is aimed at facilitating the User departments in material requirement planning, procurement, stocking of material, and issuing of material to various departments. Various MIS reports are being generated by the system for taking proper decision by the top level management.

I was involved in -
· Development of the application using various packages, stored procedures and user exits using Pro*C.
· Development of complex reports for the application using Pro*C
· Writing shell scripts for the various operations.
· Providing several security options to prevent unauthorized access of the unwanted users.
· Development of 17 forms and 7 reports for the application.

In a team of 4 , I was responsible for Development, Testing, Integration and Implementation.

ENVIRONMENT:     Oracle 7.0, Forms 3.0, Reports 1.1, Pro*C, PL/SQL Unix Sql*Plus

15. June 1994 - September 1994
Inventory Control System (Hyderabad, INDIA)

This is a sub-system of computerization of Inventory management system. The package is mainly designed for maintaining up to date information of stock position in the organization. Daily Issuing and receiving items are recorded through which updation of Inventory is being made.

I was involved in -
· Development of many reports for the application using Pro*C.
· Creation of several user exits to incorporate complex operations and provide DDL operation.
· Development of 20 forms and 8 reports for this application.

In a team of 6 , I was responsible for Development and Testing.

ENVIRONMENT: Oracle 6.0, Forms 3.0, Reports 1.1, Pro*C, PL/SQL Unix Sql*Plus