SUMMARY

• Software professional over 12 years of IT industry experience encompassing a wide range of skill set, roles and Industry verticals.
• 10 years of strong technical experience in Dimensional Modeling, ETL architecture, design, development, testing, debugging and performance tuning in Data Warehousing environment.
• I have experience in all the phases of Software Engineering Life Cycle, specializing in design, development, testing and implementation.
• Well knowledgeable with Data Warehousing, Data Modeling, Dimensional Modeling (Star and Snowflake schema), Logical and Physical data modeling involving Very Large Databases.
• I have experience in analyzing and translating business requirements to technical specifications.
• Solid knowledge of general data architecture concepts, metadata management, modeling standards and best practices for medium to large - sized complex environments.
• Expertise in Informatica Administration, Data Modeling/Architecture, Shell Scripting, PL/SQL, ETL, Oracle, Teradata, DB2, Informatica.

TECHNICAL SKILLS

ETL Tools: Informatica,Ab Initio,Data Stage and Metadata Manager

OLAP Tools: Business Objects and Cognos

Data Modeling Tools: ERwin, Visio

Databases: UDB (DB2), Oracle 11g/10g/9i Exadata, MS SQL Server 2005, MS Access, Teradata

Languages: SQL, PL/SQL, UNIX Shell Scripting, DOS Scripting, PERL, Java, C, C++, Visual Basic, VB Script, HTML, XML, Java Script,Big SQL

Tools: /Utilities: Tivoli Work Scheduler,Workload Manager(WLM), SQL Navigator, TOAD for Oracle, TOAD for DB2, MS Projects 2000, Rational ClearCase, HL7

Operating Systems: Windows, Unix, Sun Solaris, AIX

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior ETL Consultant

Responsibilities:

• Provides security incident crisis support, 24x7 on call support, night/weekend support as required.
• Ensures timely & accurate loading of the data from different source systems into Data Warehouse.
• Support and maintenance of the real-time solution for core subject areas such Membership and claims using IBM Event Publisher and MQ to enable real-time log reading capabilities.
• Support and maintenance of process extract billions (70+) claims using partitions in extracts for parallel processing utilizing multi-threading for these s/w's and loading back to Warehouse.
• Solve performance issues of the Informatica sessions, Teradata Store Procedures UNIX/ BTEQ Scripts loading data into Data Warehouse.
• Applied various Performance Tuning techniques to expedite ETL Loading which includes Indices, Partitioning, Partition Points, Persistent Cache Lookups, Materialized Views, Parallel processing.

Confidential, Dallas, TX

Team Lead & Informatica Admin

Responsibilities:

• Architecture, Installed and Configured Databases and Informatica ETL platform for Development, QA and Production Environments.
• ETL scripts migration from old into the new IBM UNIX AIX 6.1 servers.
• Standardize Extract Transform Load scripts, Informatica objects on the new IBM UNIX AIX 6.1.
• Install Informatica Power Center 9.x on IBM AIX 6.1 the new IBM UNIX AIX 6.1 servers.
• Upgrade Informatica Power Center 9.x with latest hot fixes /patches.
• Provided Technical/Administration Support and maintained Informatica Servers.
• Install and configure IBM Tivoli Workload Scheduler on the Linux Red Hat release 5.6.
• Migrate UNIX cron and Informatica jobs into Tivoli Workload Scheduler.
• Informatica Power Center and Tivoli Workload Scheduler setup on the new EDW servers and ensure automation of all ETL jobs on the new environments.
• Optimized Legacy ETL code by debugging and applying various performance tuning measures.
• Reviewed Business Requirements and worked with Enterprise Architects, SME's and Business Analysts and provided Technical Design Specifications.
• Designed and created Data Models, DDL's, Source to Target mapping documents and Developed Mapping Templates.
• Developed file handling and archiving scripts and integrated with the ETL process.
• Designed and Built ETL code to extract data from the Legacy Systems into EDW data warehouse.
• Design metadata tables, control tables, transaction tables for the new project.
• Built several complex ETL mappings, PL/SQL, Procedures, Shell Scripts, debugging, performance tuning and provided end to end solutions and support for very large data warehousing applications.

Confidential, Richmond, VA

Team Lead & Informatica Admin

Responsibilities:

• Upgraded to Informatica PowerCenter 8.5 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Confidential Corporation.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Architected and Integrated systems into a single DWH repository. Provided the best possible reporting solutions for the business needs.
• Preparation of High & low level Design documents.
• Extensively write SQL scripts for the reports and creating objects like tables, views, macros, store procedures etc.
• Solve performance issues of the Informatica sessions, Teradata Store Procedures UNIX/ BTEQ Scripts.
• Build new and modify Informatica mappings to extract data from Mainframe, Oracle, DB2 and flat files and load to Teradata.
• Developed various Shared and Reusable objects and strategies like Mapping Templates, User Defined Functions, Mapplets, ETL Test Scripts, Change Data Capture (CDC) in a Team Based environment and Version Control.
• Wrote Several Shell Scripts, Procedures, Parameter Files and ETL Control Process.
• Applied various Performance Tuning techniques to expedite ETL Loading which includes Indices, Partitioning, Partition Points, Persistent Cache Lookups, Materialized Views, Parallel processing.

Confidential, Los Angeles, CA

Team Lead

Responsibilities:

• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Preparation of High & low level Design documents.
• Develop complex mappings in Informatica to extract, transform, cleanse and load data.
• Design UNIX and Perl Scripts to extract data from different sources such as flat files and Mainframe in combination with Informatica tool.
• Conduct code review and involved in testing phases and production implementation.

Confidential

Team Lead

Responsibilities:

• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Preparation of High & low level Design documents.
• Coordinate with Data Architecture Team on modify Data warehouse model.
• Build new/modify Informatica mappings to extract data from mainframe, DB2 and perform transformation through Teradata macros and stored procedures.

Confidential, Oklahoma City, OK

Team Lead

Responsibilities:

• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Develop mappings based on business rules and cleanse data from ODS to the Data Mart.
• Coordinate with Informatica Administrator on Informatica upgrade from 6.2 to 7.1 versions.

Confidential, Norman, OK

Team Lead

Responsibilities:

• Develop SQL Database scripts for tables, views, indexes, triggers, sequences and synonyms.
• Database design and creation of triggers and PL/SQL procedures in order to enforce business rules.
• Create UNIX Scripts and perform network activities.