SUMMARY
RDBMS Product Specialist with extensive proven technical experience on RDBMS internals and SQL Development. Informatica Developer proficient at developing ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution. Experienced IBM DB2 down systems Support Engineer seasoned in solving critical issues in OLTP and Data Warehouse environments and core database skills extend to Development, Performance tuning, Database Recovery, deep troubleshooting, resolving code defects and identifying workarounds / alternate paths to critical problems.

PROFILE

• Proficient DB2 DBA and SQL Developer Skills on Linux, UNIX and Windows Platforms
• Informatica Developer with excellent ETL and BI Concepts in a Data Warehouse Environment
• Highly proficient in the use of SQL, T-SQL, PL/SQL, C and C++ languages and UNIX Shell Scripting and Perl Scripting
• Proven expertise at understanding business needs and converting them into technical solutions with SQL development and Informatica Power Center Client Tools.
• Excellent understanding of fact, dimension tables and star and snowflake schemas
• Expertise in design and implementation of Slowly Changing Dimensions (Type 1,2,3)
• Experience in integration from various data sources -SQL Server, Oracle, DB2, Flat files
• Expertise in designing and developing ETL mappings making intelligent use of transformations (filter expression, rank, router, aggregator, joiner, sequence, sorter, normalizer, lookup and update strategy).
• Skilled performance tuning of mappings and sessions in Informatica.
• Ability to generate of BI Reports from fact and dimension tables.
• Database Design and Implementation, Administration, Monitoring, Performance Tuning, Installation, Migration and Troubleshooting single node as well as multi-node DPF environments
• Expertise in handling high pressure production down critical situations
• Analytical approach to technical problem solving with attention to details
• Experience of working with a global multicultural cross product team and excellent communication skills
• A self-motivated, responsible and reliable team player with a set of very strong technical skills

CERTIFICATIONS

• IBM Certified Database Administrator

DB2 9 DBA for Linux UNIX and Windows

• IBM Certified Application Developer

DB2 Universal Database V8.1 Family

• IBM Certified Database Associate

DB2 Universal Database V8.1 Family

TECHNICAL SKILLS

Operating Systems : Windows, UNIX, Linux, AIX, Sun Solaris, HP-UX

RDBMS : DB2 UDB V8/9/9.5, SQL Server, Oracle

Languages and Tools: SQL, T-SQL, PL/SQL, C, C++
UNIX Shell Programming, Perl Scripting
Informatica Power Center 8.x / 7.x, VB, HTML
Oracle Golden gate Replication Tool, Oracle Veridata

ETL Skills: Design and Development of ETL Mappings using Transformation Logic
Defining ETL Tasks, Workflows and Monitoring Sessions
Identifying performance bottlenecks
Skilled performance tuning of Informatica Mappings, Transformations & Sessions
Expert at Informatica Power Center Components (Workflow Manager, Workflow Monitor, Designer - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer)

Database Skills : Database Design, SQL Development and Administration
Implementing Stored Procedures, Functions, Triggers, Exception Handlers
Installation, Migration, Upgrades and Configuration of Database Systems
Design and Implementation of Database Backup and Recovery Strategy
Transaction Logging
Table range partitioning, MDC, MQT
Corruption and Recovery
Monitoring and Performance Tuning of Databases, Applications and SQLs
DB2 Memory Management and STMM
Administration using command line as well as DB2 Administrative tools
Troubleshooting Database Systems and Applications

Database : Distributed environments using DPF (Data Warehouse/OLTP)
Environments : High Availability Disaster Recovery (HADR)
Database Replication

PROFESSIONAL EXPERIENCE

Confidential,offers world-class Charge and Credit Cards. American Express sometimes known as AmEx, is a diversified global financial services company accounts for approximately 24% of the total dollar volume of credit card transactions in the US, the highest of any card issuer. Mindtree consultant for project MYCA at AmEx which stands for \'Manage Your Card Account\' . This is a highly available OLTP environment including more than 50 Databases . As part of DB2 DBA Team worked as a path finder for creating migration strategies for each database from Solaris v8 to AIX v97 with minimal downtime.

• Engineered ways to cut down on migration down time to achieve near zero outage for DB Migration.
• Unix Shell Scripting in production to automate and club numerous migration tasks and various post migration checks.
• Devised ways with Oracle Golden Gate replication to have data sync in production to minimize downtime.
• Performed efficient troubleshooting for client on various production issues with DB2.
• Quickly grasped the existing AIX HACMP Cluster set up and developed migration strategy for HADR Databases as well.

Confidential,is the largest online travel company in the world, with an extensive brand portfolio that includes Expedia.com, Hotels.com, Hotwire, Venere.com, Egencia, TripAdvisor and Classic Vacations.
This is an extremely challenging job role as member of the DB2 DBA Team for Enterprise DataWarehouse for Expedia, Inc. Practiced hands on field experience at the challenges involved in a dynamic DataWarehouse Environment:

• Overcame persistent performance problems by analyzing the resource under contention (CPU).
• Guided and designed constant monitoring efforts to pick out rogue queries in real time that are high CPU consumers affecting performance experience by others enterprise wide.
• Made intelligent use of very light OS and DB2 commands that collect useful information without further impacting performance.
• Guided developer on creating a ‘Heavy Hitters’ webpage to track such rogue queries and allow users to take proactive action before DBA team reaches out to them to mitigate performance risks for the enterprise.
• Worked to improve performance of ETL jobs, BI Queries as well as SQL user queries.
• With better performance, monitored a monthly increase in number of queries the production was now able to handle.

This is a highly specialized team of less than a hundred chosen Product specialists worldwide having full 360 degree expertise of the entire Product. Extremely challenging and dynamic role where resolving Down Systems becomes a habit rather than a critical situation. Groomed deep technical skills for problem determination, analysis and delivering effective timely solutions to worldwide IBM DB2 customer base for Linux, UNIX and Windows. Identifying and fixing or delivering immediate workarounds for DB2 V8/V9 product defects were some of the challenges faced.

• As one of the best Support Analyst I was always hand-picked to provide support for a number of worldwide high profile customers like Sprint, HSBC, Bank of America, Verizon, Home Depot, Standard Chartered Bank, Target, Hallmark, Cognizant, NSDL, TCS, Wipro to name a few, on critical production down conference calls
• Selected to be the single point of contact as IBM DB2 Support for one of IBM India\'s biggest customer Bharti Airtel managing 110 million subscribers. Provided onsite visits for disaster management during their data warehouse health check-up

ETL Design and Development Role
As part of the Bharti Project, having in depth RDBMS product Knowledge, I was always assigned the complete end to end ownership of design and development of ETL solutions to deliver the most complicated business requirements involving:

• Business Requirement Gathering from client
• Collaborate with various teams to set data integration standards
• Designing Technical solutions using various transformation logics to implement the business requirements
• Test Solutions to verify that the business requirements are met.
• Performance Tuning and Support in Production Environment.
• Identified and resolved production problems on mission critical systems.

Database Development

Specialize in writing optimized code by analyzing the optimizer access plans to achieve best performance with extensive experience in coding and debugging SQL routines (functions and stored procedures) in a single node and DPF environments on UNIX, Linux and Windows platforms

• Gained excellent understanding of DB2 usage in Industry environments (OLTP, Data Warehouse)
• Acquired in-depth knowledge of DB2 Code Internals working directly with DB2 Product Developers and designed and developed internal support tools coding in C and C++
• Numerous occasions where I was able to speedily grasp the complex system set-ups and problem being faced. I was quick to ask DBAs the right questions for effective problem determination and then drive DBAs to take systematic steps for solving the problem at hand

EDUCATION
Bachelor of Engineering - Information Technology