Resume 2

• Six years of experience in the IT industry. Over five years of experience as an Oracle Database Administrator and over two and a half years experience with Informatica.
• Experience with Oracle 9i/8i/8.0/7.3 Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.
• In-depth experience in Data Warehousing using Informatica and Oracle.
• Worked for a large CMM level 5 consulting firm Tata Consultancy Services for over 4 years.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.

• Software PL/SQL, UNIX Shell Scripting

• Databases & Tools Oracle 9i/8i/8.0/7.3, Oracle Enterprise Manager, Oracle Diagnostics Pack, Oracle Performance Pack, ERWin 3.5/4.0, TOAD, SQL*Net/Net 8, Spotlight on Oracle

• ETL Informatica PowerMart 4.6/PowerCenter 5.1.1, Cognos DecisionStream

• Operating Systems Solaris 2.8/2.7/2.6, Windows NT 4.0, HP-UX 10.2/11.0, Windows 98/95

• Hardware SunFire 15K, Sun E6500, Sun E4500, Sun E450, HP 9000, Compaq Proliant

B.E. Bachelor of Engineering , Walchand Institute of Technology
Oracle Certified Professional OCP - Database Administrator from Oracle Corporation.
Certified Oracle DBA from Brainbench.
Received training in Informatica PowerMart by Informatica Corporation.
Received training in Rational Clear Case and Clear Quest by Rational Corporation.
Continuing Education Program CEP included Oracle Database Administration, Data Warehousing and Cognos at Tata Consultancy Services.

Currently working on the CODE project using Informatica and providing DBA support. The Code system is being developed to gather data logged by the Maintenance and Diagnostics division of TG Power Systems and store it in a database on which the Business Intelligence team can generate and run reports. This data is gathered from the turbines installed by TG Power Systems at various sites. The data shows the functioning of the turbines. It shows the values of the various tags of the turbines at different times of day. These data points for a tag can be at 1 minute, 5 minute or 60 minute intervals depending on a tag. The data is transformed while being moved from source to target. On an average 9 to 10 million rows are extracted from the source daily. The Code system being developed will enable users to perform studies on turbine and site data. The source and target databases are Oracle 8.1.7 running on Solaris 2.8 and Informatica PowerCenter 5.1.1 is being used as the ETL tool. Before starting work on the Code project provided Oracle DBA support for a number of databases.

• Installation and configuration of Oracle 8.1.6 server and creation of databases.
• Develop Informatica mappings to extract, transform and load data from source to target.
• Upgrade of Informatica PowerCenter repository from PowerCenter 1.5 to PowerCenter 5.1.1.
• Worked with ETL architect to develop ETL design.
• Database and SQL tuning to improve performance of loads.
• Implemented table partitioning to improve performance and data management.
• Performed SQL tuning by using Explain Plan and Tkprof.
• Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Assisted in logical and physical database design.
• Making structural changes to the databases when design changes are to be implemented. Also implemented those changes in Informatica mappings.
• Installation, configuration and administration of Informatica server on Solaris 2.8 and client on Windows NT 2000. Establishing connectivity through ODBC data sources.
• Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.

Environment: Oracle 8.1.7, Solaris 2.8, Sun E4500, ERWin 4.0, Informatica PowerCenter 5.1.1, Oracle DBA Studio, TOAD

Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Datawarehouse. Used Oracle replication as databases used read only snapshots for maintaining local copy of master tables in OLTP systems. Part of a three-member DBA team managing 36 databases. This included 18 production databases and 18 development/test databases. Users were located in America, Europe and Asia Pacific. Databases were Oracle 8.1.6 and running on HP UNIX. Sizes of databases varied from 5 GB to 40 GB. The projects using these databases are for web development and maintenance of Client-Server OLTP systems for business applications such as cargo tracking, billing, etc. Following are some of the typical tasks carried out as part of database administration.

• Installation and configuration of Oracle 8.1.6 server and creation of databases.
• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution.
• Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
• Performed SQL tuning by using Explain Plan and Tkprof.
• Making structural changes to the databases when database design changes are to be implemented.
• Implementation and maintenance of read only snapshots and snapshot logs.
• Migration from Oracle 7.3.4 to Oracle 8.1.6 using Oracle Data Migration Assistant and mig utility.
• Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.
• Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.

Environment: Oracle 8.1.6/7.3.4, HP-UX 10.2/11.0, HP 9000, Windows NT 4.0, Compaq Proliant, ERWin 3.5, Informatica PowerMart 4.6, Oracle Replication Manager, Export/Import, Unix Shell Scripts, TOAD, Tkprof and SQL*Net/Net8

German Laboratories is a pharmaceutical company, which had eight Oracle 8.1.6 databases running on Solaris 2.6. They had a two member DBA team which did most of the tasks manually. Most of these tasks needed to be automated. Sizes of databases varied from 2 GB to 10 GB. Following are some of the typical tasks carried out as a DBA

• Developed Unix shell and SQL scripts for database monitoring.
• Developed Unix shell and SQL scripts for database backups.
• Migration of databases from Oracle 7.3.4 to Oracle 8.1.6.
• Performed database tuning.
• Refreshing development/test database from production using Export/Import. This was done so that the latest data is available in the development/test database.

Environment: Oracle 8.1.6/7.3.4, Solaris 2.6, E450, Unix Shell Scripts

The proposed Datawarehouse system is intended to be used by the Six Sigma, Customer Satisfaction and Finance departments. Utilization of this Data Warehouse will guarantee ease and consistency in analytical reports across these departments as it is developed by use of integrated data sources and uniform data warehouse architecture. The feeder systems included OSB, IPT and SFC.

• Creation of Data Warehouse database consisting of Star Schema Fact & Dimensions tables .
• Data extraction from various sources, transformation and loading into the target Oracle database using Informatica PowerMart.
• Installation and configuration of Informatica PowerMart server.
• Administration of the Informatica server. Creating users in Informatica and assigning roles.
• Developing and testing of mappings in Informatica for data cleansing and transformation.
• Installation of client tools on user machines and establishing connectivity to databases.
• Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flex Architecture.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Database server tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
• Providing assistance in logical/physical data modeling using ERWin.
• Making structural changes to the databases.
• Sizing database objects for effective space management and optimal performance. All storage parameters are entered in ERWin for objects to be created.
• Used ERWin to ensure that data model is in sync with database.
• Database backups and recovery.
• Installations of Oracle 8.0.5 database server on Solaris 2.6 and creating new databases.

Environment: Oracle 8.0.5, Solaris 2.6, Sun E450, Compaq Proliant, ERWin 3.5, Oracle Enterprise Manager, Informatica PowerMart 4.5/4.6, Windows NT 4.0

Provide Oracle DBA support for multiple large databases in production and development/ test environments for various types of databases - OLTP, Data Warehouses and Oracle Financials. Part of a two-member DBA team managing 35 databases. This included 23 production databases and 12 development/test databases. Users were located all over Europe. Databases were Oracle 7.3.x and Oracle 8.0.x and running on Solaris 2.6. Sizes of databases varied from 2 GB to 100 GB. Following are some of the typical tasks carried out as part of database administration.

• Installation of Oracle 7.3/8.0 database server on Solaris 2.6 and creating new databases.
• Carrying out upgrades of databases using the Oracle Installer. Applying patches to Oracle using Installer and to Oracle Financials using the adpatch utility.
• Relinking Oracle applications programs and regeneration of Oracle Forms and Reports.
• Refreshing development database from production using export/import.
• Be on-call, attend to problems on a daily basis and resolve various database-related issues and customer requests.
• Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
• Database reorganization of existing databases to meet standards or improve performance.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Sizing database objects for effective space management and optimal performance.
• Capacity Planing for changes in the size of databases due to business growth.
• Database server tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
• Analyzing tables on a regular basis for the Oracle optimizer.
• Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases.
• Monitoring rollback segments. Adopting proactive maintenance strategies to curb extensive shrinking and wrapping of rollback segments.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Data loading using SQL*Loader to assist Data Warehouse developers.

Apart from the above-mentioned tasks, daily monitoring was carried out before start of business hours to ensure database availability and smooth functioning of databases. Daily monitoring includes checking whether all databases are running, listener is running, concurrent manager is running for Oracle Financials databases, UNIX error messages, disk space availability, segments with greater than 10 extents, segments with next extents that would not fit in the tablespace, checking for errors in alert logs and trace files, checking for invalid objects, etc. Corrective action is taken for any of the problems before start of business hours.

Environment: Oracle 7.3.4/8.0.x, Solaris 2.6, Sun E6500, ERWin 3.5, Oracle Financials 10.7, PL/SQL, SQL*Loader, Export/Import, UNIX Shell

The Asset Management System ATLAS is one of the main applications used by Asset managers of TGE Capital Real Estate. ATLAS helps in collecting, analyzing and reporting information related to assets like loans and property. This application forms the backbone of Asset Management Services, which are spread nationwide through a network of field offices and Dallas, TX based centralized service platform. The existing system uses an Oracle 7.3.4 database with MS Access front end. This has to be migrated to Oracle 8.0.5 and Visual Basic 6.0.

• Installation of Oracle 7.3.4/8.0.5 database server and creating a new target database.
• Creating tablespaces, tables, indexes, users, etc., maintaining OFA compliance.
• Migrating the Oracle 7.3.4 database to Oracle 8.0.5 and incorporating the changes in the database design.
• Database reorganization. Making structural changes to the databases.
• Developing stored procedures to migrate the data from Oracle 7.3.4 database to Oracle 8.0.5 database. UTL FILE package was used for error logging. The error code, error description and rejected record were logged in the log file.
• Managing database security and creating and assigning appropriate roles and privileges as required by the application.
• Implementing the changes in the database design and modifying stored procedures if necessary.
• Sizing database objects for effective space management and optimal performance.
• Database server tuning. This included tuning the shared pool, database buffers and redo buffers.
• Database backups and recovery. Developing scripts for cold backup.

Environment: Oracle 7.3.4/8.0.5, Solaris 2.6, Sun E450, ERWin 3.5, Oracle Enterprise Manager, PL/SQL, Export/Import, UNIX Shell

The Data Warehouse system enables TGE Financial Assurance users to perform actuarial studies on historical policy and claims data. This is done in an effort to improve pricing, underwriting and customer targeting. Informatica PowerMart was used for data extraction, transformation and loading. The source data was in flat files, Oracle and SQL Server databases and the target database was Oracle. In addition, provided Oracle DBA support for the project.

• Creation of Data Warehouse database consisting of Star Schema Fact & Dimensions tables .
• Data extraction from sources, creating transformations and loading into the target Oracle database using Informatica PowerCenter.
• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution. Database objects were sized for effective space management and optimal performance.
• Installation, configuration and administration of Informatica PowerMart server and client on Windows NT 4.0.
• Establishing connectivity through ODBC data sources.
• Making structural changes to the databases when design changes are to be implemented.
• Database server tuning to improve performance using ultbstat and utlestat or custom scripts. Proactively tuned the shared pool and buffers db buffers and log buffers . Checked for I/O contention. Took appropriate action by adjusting parameters or moving datafiles.
• Used parallelism to improve performance. By setting parallel_automatic_tuning to true the degree of parallelism is set automatically by oracle.
• Performed SQL tuning by using Explain Plan and Tkprof.
• Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space. Also helps efficient processing of star queries.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Development of stored procedures for carrying out transformations on data and loading target tables.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Installation and configuration of SQL*Net/Net 8. Installation of Oracle 8.0.5 on Windows NT 4.0.

Environment: Oracle 8.0.5, Windows NT 4.0, Compaq Proliant 7000, ERWin 3.5, Informatica PowerMart 4.6, SQL*Net/Net8.

The Global Pricing System was developed as package software to handle complex business processes within GE Plastics and as a need to simplify the Information Management in GE Plastics for better positioning for the future. The system has Pricing and Contract as its modules.

• Installation of Oracle 7.3.4 on Solaris 2.5 and creating new databases.
• Developing PL/SQL programs for data manipulation.
• Installation of Oracle client tools and establishing connectivity to databases
• Creating tablespaces, tables, indexes, users, etc.
• Providing assistance in physical data modeling.
• Managing security.
• Sizing database objects for effective space management and optimal performance.

Environment: Oracle 7.3.4, Windows NT, Compaq Proliant 7000, ERWin 3.0, PL/SQL, PowerBuilder 5.0

Worked in the application development team to develop variety of applications for end-clients, such as, Inventory Management System, Payroll System, Recruiting System, etc. These applications were developed using PowerBuilder 5.0/4.0 and Oracle.

• Development of various front-end modules using PowerBuilder 5.0/4.0.
• Developing PL/SQL programs for backend processes.
• Developing and performing unit and integration tests.
• Testing and debugging.
• Client demonstrations and user training.

Environment: Oracle 7.3.x, PL/SQL, PowerBuilder 5.0/4.0, Windows NT/3.11