EXPERIENCE SUMMARY

• Over 13 years of overall experience in System Analysis, Design, Development, and implementation of Client Server applications using all database tools and technologies, of which having around 9 years of experience in Oracle 7.x, 8, 8i, 9i, 10g, 11g. Proficient in Interfaces, Oracle Import and Export Utilities and converting legacy data into Oracle Applications using SQL* Loader, PL/ SQL.
• Experience in MAA using Oracle Streams, RAC and Data Guard etc.
• Familiar with Quest Products.
• Experience in OEM Administration.
• Familiar with ETL tools like Data Junction, Datastage 8.x/7.x to extract and load data.
• Experience in SQL optimization/Performance tuning of SQL queries/stored procedures using STATSPACK, TKPROF, ADDM, AWR, Explain Plan, SQL Trace etc.
• Good understanding of Oracle Data Dictionary, Oracle Workflow, Data warehousing concepts and tools.
• Responsible for all DB related activities w.r.to the development, implementation, administration and support of ETL processes for a large-scale data warehouse.
• Experienced in working with other databases like SQL Server 2005/2000, Sybase T-SQL, DB2
• Experienced in working with Autosys, Quartz job scheduler.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Hands on experience in all aspects of software development life cycle (SDLC) also familiar with Rational Unified Process, Agile and Iterative methodologies.
• Possesses Technical, Project management skills and capable of involving in the project from conceptual phase to development.

TECHNICAL SKILLS

ETL Tools

IBM Websphere DataStage 5/6/7(Designer, Manager, Director, Admin), SQL*Loader, Informatics 6.2, SAP BW, Ab-Initio, Kettle etc.

Modeling Tools

Power Desinger,Erwin 4.0, Rational Rose etc.

RDBMS & Tools

Oracle DBA, Oracle 8i/9i/10g,11G, RAC, Oracle Streams, OEM,Data Guard, RMAN, Import, Export, DataPumps, ADDM, AWR SYBASE,DB2 UDB, MS Access 2000, SQL Server 7/2000/2005,TOAD 7.5/8.5/9.5, SQL Navigator 4.3,Cognus etc.

Operating Systems

Windows NT/XP, SunOS, UNIX, Red Hat Linux

Languages

C, Visual Basic 6.0, UNIX Shell Scripting, SQL*Plus, PL/SQL

Testing Tools

Win runner, Load runner, Test Director and Manual Testing.

EDUCATION:

• Bachelor of Engineering Degree .

PROFESSIONAL EXPERIENCE

Confidential,East Moline, IL Nov ’06 – Till Date
DBA/Data Analyst
iWarranty, from 4CS, is a comprehensive enterprise solution that proactively and collaboratively manages warranty and cost reduction. In this Product, I work as DBA/Data Analyst and make sure that the Data Architecture and conceptual, Logical and Physical Data Models meet the client’s business needs and also in-line with the iWarranty Product Schema which is being supported by all leading database vendors.

Responsibilities:

• Designed and developed a Data Decimation application for summarizinglarge statistical data sets.
• Provided technical support to the development team for developing the complex reports.
• Used Data Junction for loading huge volume of legacy application data into iWarranty application by adapting iterative approach of ETL process and Customized process using PL/SQL
• Designed and developed as a prototype application that ensures the Data replication and synchronization between geographically distributed iWarranty systems using Oracle Streams.
• Lead a team of 10 in an effort to identify poorly performing queries on customer site and resolving them that provided accolades to the product.
• Provided production support by remote troubleshooting to resolve customer’s onsite issues.
• Analyze client data, develop mapping specifications, produce conversion samples, develop a production plan and lead the conversion process through deployment and production phases
• Generate/Create DB scripts and installation documents to be sent to clients along with application installations.
• Developed and maintained UNIX shell scripts/ Windows batch scripts for DB backup and other DB related daily routine activities.
• Analyze, calculate, and recommend the initial data storage size and expected growth percentage/size.
• Measure, identify and optimize the queries, stored procedures and other data processes for better performance
• Document data mapping , data dictionary, database schemas, entity relationships and data flows
• Converted and loaded data from flat files to temporary tables in Oracle database using SQL*Loader.
• OEM Administration for Database Administration.
• Designed complex stored procedures for data loading in data warehouse and Reports.
• Extensively used UTL_FILE package, external tables to write data from flat files to Oracle Database.
• Improved the performance and data manageability by table partitioning, using global and local indexes, materialized views, and bitmap indexes.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans and Trace sessions.
• Created Test environment using SQL & PL/SQL scripts and optimized critical queries to eliminate Full Table scans & reduce Disk I/O.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Maintain the Oracle 10g RAC environment and troubleshoot performance problems.
• Maintain the Oracle 10g and 11g RAC Administration for all services.
• Design and Implemented Oracle 10G RAC 2 nodes on Linux Cluster BI Application.
• Migration of data from MS Access to SQL SERVER 2005.

Environment: Oracle 10g,11G, DB2, MS-SQL server, Power Designer, Data Junction (ETL), Toad, Visual Explain, windows server, UNIX, Linux.

Confidential,IL May ‘06 – Oct ‘06
Oracle DBA /Developer/ETL developer
Aon Corporation is a fortune 500 company, which runs its Business operations from Chicago, Illinois. They are leaders in creating innovative solution in insurance, human capital consulting, and insurance underwriting to help clients.
Responsibilities:
.

• Worked extensively with STATSPACK and TKPROF reports for performance problem. Also worked with a variety of corporate performance monitoring tools to identify bottlenecks with memory and disk contentions.
• Providing DBA support for Production environment, which involves Database tuning such as Oracle Stored Procedures/Functions/Packages optimization using advanced PL/SQL features and dynamic SQL.
• All the daily database administration tasks including backup and recovery thru RMAN, Import/Export, grants and roles etc.
• Configured Data broker for Data Guard and Create physical stand by Data Guard.
• Database Reorganizations for better space management.
• Performed Database Refreshes, copies for Development, Test and Production databases.
• Refresh schema level and full level production to non-production databases.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Upgrading OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
• Provided technical support to the development team for developing the complex reports.
• Extensively used UNIX shell scripts for various DB related tasks.

Environment: Oracle 9i/10g, PL/SQL, Toad 7.5, Sun Solaris, Windows XP, Cognos 7.0, People Soft 8.0.

Confidential, New York, NY Oct’05 – May’06
Oracle DBA and Developer
Description: This project basically cash forecasting reporting tool. The Cash information is downloaded from an external systems “Exidio”. The downloaded data are then loaded in a staging environment. From staging table the data will be populated into warehouse. The warehoused data has been used to generate various reports by using OLAP analysis server.

Responsibilities:

• Worked extensively on Data warehousing and to move data from source to target database-using Data Stage.
• Extensively Used DataStage Universe Basic Commands in Performing DataStage Administrative Task.
• Worked extensively on oracle data forms and MQ messages on UNIX box and loading data onto Oracle.
• Designed, Developed DataStage Jobs oracle Plug-in Stages invoking oracle Load Utilities.
• Developed UNIX Shell scripting for file manipulation operations and data loading procedures, created CRON jobs for automate tasks etc related to the application.
• Involved in both hot and cold data backup.
• Developed procedures, functions, triggers for complex business needs which cannot be done using tools.
• Interacting with User Groups/Corporate Testing Groups/Business people.

Environment: IBM Websphere (Ascential) DataStage 7.5., Oracle 9i, PL/SQL/, Toad 8.0, Sql Server 2000, Sun Solaris, Windows.

Confidential,India Jan‘02- Dec‘03
Oracle Programmer & DBA

Responsibilities:

• Involved in analysis, design and development of MPMS (Material Purchasing Module).
• Responsible for business analysis, data analysis and developing functional flow and data flow diagrams.
• Lead the project team for developing HR/PS (Pay roll System).
• Responsible for coordinating the team activities for data analysis, design, code development, testing and implementation.
• Involved in system architecture, infrastructure and capacity planning.
• Responsible for designing and implementing OEMS (Order Entry Management System).
• Involved in database physical and logical design, developing administrative procedures, making backup and recovery policies and preparing operating metrics for production database and making security policies. Acquired a good knowledge of using data modeling tools, database design and administration, developing security policies, planning backup and recovery techniques.
• Exposed to using different tools like TOAD, OEM for developing and maintaining the oracle database.

Environment: Oracle 8i, SQL/PLSQL, Forms 6.0, and Reports 2.5, Manual Testing.

Confidential,Arlington, VA Apr’00-Jun’01
Oracle DBA
Responsibilities:

• Database Administrator supporting multiple applications/database instances including development, testing and production in OLTP and Datawarehouse environments in a Mission Critical highly available 24X7 environment on Aix and HP servers on databases varying from 500GB to 2TB
• Installing, upgrading/migrating and configuring of 9i and Tuning the SQL using SQL Trace, tkprof and Explain Plan utilities. Used rule and cost based optimizers to get better throughput and optimization. Used database hints to drive the best access path and better throughput. Used Statspack for overall health check of the database like cpu usage, memory usage, finding performance bottlenecks and for system wide tuning .
• Ensure performance related database activities are performed on all instances like
• Gather schema statistics, rebuild indexes, reorganization of database objects like
• Tablespaces and big tables having around 50 million rows.
• Bulk loading of data using SQL*Loader and PL/SQL and Merge feature in 9i. Automated the loading jobs using pl/sql and unix(ksh) shell scripts.
• Refreshing test databases using data from production using Export/Import utility. Used the Transportable Tablespace feature to migrate data from one database to another.
• Implemented the oracle partitioning feature for large tables and indexes. Created range/list partitioning. Maintaining partition tables and indexes by truncating, dropping, exchanging and merging partitions.
• Developing unix shell scripts(Ksh) and pl/sql procedures for automating the batch jobs at OS level and at Database level using Cron jobs and dbms jobs.
• Provided 24/7 on call support for mission critical multiple database instances. Monitored the database using BMC Patrol.
• Extensively used OEM for performing various tasks including monitoring database locks, long running sql statements, viewing performance statistics, tuning the database, running explain plan and scheduling various jobs.
• Used CM-Synergy as a packaging tool to create and deploy packages for supporting Change Control operations.
• Configured and supported RMAN for backup and recovery purposes. Recovered the accidentally dropped datafile successfully.
• Installed and configured 9i two node RAC on a linux server in the development environment.
• Performance tuning of DB2 database including tuning sql queries.
• Creating DDL (like Tables and Indexes) on DB2 database and performing DML operations.
• Generating text files from Mainframe DB2 and Loading the data into Oracle tables using SQL*Loader.

Environment: AIX4.3 - 5.2, HP-UX 11.0, windows2000, Veritas Netbackup, Oracle Server 8i
SQL, PL/SQL, Toad 8.0, DB2

Confidential,VA, Jan‘99 – Apr’00
Oracle DBA and Developer.
Online Asset Exchange is one of the worlds largest online surplus equipment marketplace for used industrial, medical and chemical processing equipment with over 250,000 of items having asset value about 15 Billions on display.

Responsibilities:

• Installation and configuration of the Oracle Server, up gradation of applications to new versions.
• Physical and logical designing of the database, which includes the distribution of data-files on different disks.
• Management of Table spaces such as dropping/creation and modification of storage parameters depending on the applications.
• Management Rollback Segments such as dropping/creation and modification of storage parameters depending on the applications.
• Management of Clusters and Indexes.
• Creation and maintenance of user accounts, roles, system & user level database objects.
• Identification and elimination of different contention factors like IO, buffers, locks and latches.
• User Management - Creation and maintenance of users, creation of users and profiles.
• Identification and tuning the resource intensive applications and routines that influence the database performance.
• Configuration of the database for handling fluctuations in the load due to distributed database calls.
• Defining and implementation of database backup and security strategies, testing the backups periodically for consistency and reliability.
• Performing the media/object recovery in the event of any database crash or user accidents.
• Predicting the future storage and other resource requirements for the production database.
• Creating Stored Procedures & Packages and writing scripts for automating routine activities like backup, alert file scanning and generating periodic performance monitoring reports.

Environment: Oracle 8.0.5, SQL/PLSQL and Sun Solaris.

Confidential,OH Jan‘98- Dec‘98
Oracle Programmer

Responsibilities:

• Involved in analysis, design and development of MPMS (Material Purchasing Module).
• Responsible for business analysis, data analysis and developing functional flow and data flow diagrams.
• Lead the project team for developing HR/PS (Pay roll System).
• Responsible for coordinating the team activities for data analysis, design, code development, testing and implementation.
• Involved in system architecture, infrastructure and capacity planning.
• Responsible for designing and implementing OEMS (Order Entry Management System).
• Involved in database physical and logical design, developing administrative procedures, making backup and recovery policies and preparing operating metrics for production database and making security policies. Acquired a good knowledge of using data modeling tools, database design and administration, developing security policies, planning backup and recovery techniques.
• Exposed to using different tools like TOAD, OEM for developing and maintaining the oracle database.

Environment: Oracle 7, SQL/PLSQL, Forms4.5, and Reports 2.5, Manual Testing.