Professional with extensive experience in Software design, development, testing and quality assurance of various Business and Financial application software projects in Oracle Applications - Manufacturing, Oracle, Developer 2000. Involved in data conversions and interfaces, utilizing PL/SQL, SQL; development of custom Oracle Applications employing Oracle Development Tools, JAVA, HTML.

Wipro Technologies Client: Seagate Technology, Inc. Minneapolis, MN, USA

Oracle Applications 11i Gap Analysis – Compiled Oracle customizations that have been related to Engineering, Bills of Material and Inventory. Tested to determine if any of these customizations are in the 11i vanilla product. Responsible for custom Bills Of material Form – Indented, reports included Indented Bills of material Report, single and Multi level BOM reports.

Installed Oracle Applications 11i to test the same and to understand the new web based architecture.

Wipro Technologies Client: Seagate Technology, Inc. Minneapolis, MN, USA

Worked as a project manager to implement the CSM project at client site. The Component Supplier Management (CSM - System purchased to replace the existing Parts database and will also be used as the Part Number Assignment System) Data Promotion System is designed to sync the various databases and provide reporting capability to compare the Item Quest internal metadata between databases and a method to keep them in sync. Item Quest (A Component Supplier Management (CSM) tool, purchased from IQXpert to replace the existing Parts Database) clients can "update" the Oracle database data using the ItemQuest database data. This "update" includes editing table definitions (Add columns, Delete columns), adding tables, and adding indexes. IQ client (Administrator) makes these changes to IQ database. User requirement suggest that "any change made by the IQ Client administrator to Oracle database should get reflected on all the CSM databases" .Form 4.5 front end was developed to provide an easy to use interface for running DDL or DML or Other (SQL*Plus report) Reports. These reports then will be sent to the users lotus notes account or can be viewed in the specified UNIX directory.

Wipro Infotech – Enterprise Solutions Client: Seagate Technology, Inc. Singapore

Design, developed and implemented a new system called Far East Vault distribution system which provides list of part numbers built by other Seagate sites like Wellgrow, Senoko, Chokchai, etc for vault replication purpose. Request to be able to automate print report that shows all part numbers build by different instances like Senoko, Prai, etc. Subsequent printing prints only new part numbers creation/deletion. Created PL SQL procedures, Oracle Forms and integrated them with Oracle Applications 10.7.

Wipro Infotech – Enterprise Solutions Client: Seagate Technology, Inc. Minneapolis, MN, USA

Responsible for design and development of a system called World Wide Item and BOI description Sync. Developed, implemented, and supported this system. The system was developed to keep the descriptions of item numbers and its descriptions the same in all Oracle Instances in the world. This program read all the item numbers in an Instance’s Global Master and verify that the description matches the description in the US Instance, Global Master. The system is also used to determine what item numbers exist in other Instances but not in the US Instance and determine what has been updated after the initial sync program . Created snapshots, PL SQL procedures, Oracle Forms and integrated them with Oracle Applications 10.7.

Designed developed, Customized & Tested the code in Oracle Bills of Material, Engineering & Inventory. Created various new report included Item Variance Report, ECO Approval Reports. Customized Oracle Vanilla reports Consolidated BOM and Indented Bills of Material Report to cater to client’s requirements. Environment included Oracle Server 7.3.4 and Oracle Applications 10.7, Oracle Forms 4.5 and Oracle reports 2.5.

Wipro Systems Client: Seagate Technology, Inc. Londenderry, Northern Ireland

Was responsible for Planning and executing migration of Oracle from Novell to HP Server. This included sizing of the new Oracle database (tablespaces, datafiles, logfiles), reorganizing the tables in proper tablespaces, configuration of SQL*NET V2 and V1, configuration of ODBC and BDE for Delphi, testing of each application on test database, and going live with minimum downtime. Written PL/SQL scripts for some of the applications. Environment included Oracle Server 7.1.3 on Novell 3.11 and Oracle 7.2.3 on HP-UX10.01. Installed and configured Oracle transparent gateway for Informix software and connectivity between database using database links. Environment included Oracle Server 7.2.3 on HP-UX10.01, Oracle Transparent gateway for Informix 3.0.

Was responsible in creating SQL*loader scripts to load the text files into Oracle database for the Bank reconciliation system. The module imports ManMan cheque report text file and the electronic bank statement text file into system. It also provides the reconciliation and reporting functions required by bank reconciliation coordinator. Was involved in the design and development of the reports for internal Seagate project, which was carried out to streamline the process of issuing the garments to employee working on different work areas on different shifts. Environment also included Oracle Forms 4.5 and Reports 2.5.

Wipro Systems Client: Seagate Technology, Inc. Cupertino,CA USA

Was responsible designing and developing the reports for a new marketing software - SCOPUS. This project was carried out as a part of client’s shifting to new marketing software - SCOPUS from File Maker. Developed 17 reports, which included Sales Lead Count, Marketing Development Lead, Literature Fulfillment, and Mailing Label. The team size was 2 and environment included Crystal Reports Pro 5.0, SCOPUS, Oracle 7.1, and Solaris 2.5.

Wipro Infotech Client: NIC, BPCL, BPL etc Bangalore, India

Was responsible for conducting standard and customer benchmarks. Was responsible for setting up the environment and database tuning as well as application tuning. Performed various System administration and Database administration (DBA) activities which included Installation of Oracle on AT&T, SCO UNIX and SUN Solaris, Developer and Designer 2000 installation, Configuration of SQL*Net V2 and V1, database creation, tablespace, logfiles and rollback management, database backup and recovery management. Performance tuning included server tuning (memory, I/O and CPU) and Application tuning (SQL and PL/SQL).

Govt. Engineering College Client: Wipro Infotech Bangalore, India

Was responsible for creating software packages to demonstrates how Oracle 7 uses its Performance Tuning Tools like Indexes, Clusters, Hash Clusters etc. This package basically shows the user the improvement in performance in using the above tools provided by Oracle by showing details like Time Taken by any Query to retrieve the results with the Oracle provided Performance Tools and without them. Environment also included Oracle 7.0, SCO OSES, Forms 3.0.

Involved in the design and development of the Sales Order Processing System which assists the management in Viewing of Order Status, Processing of fresh Purchase Orders, Checking the availability of Items, Delivery of valid Orders, Report Generation for Pending Orders, Total Orders and deliveries made between any given period of time. This project was a part of final MCA curriculum done for Wipro Infotech, Bangalore, India and environment included Ingres 6.4, SVR4.