Summary:

• 7 + years of Software Development Life Cycle (SDLC) experience as a Data warehouse consultant implementing Client/Server applications in major companies.
• Extensive experience in all phases of the Data Warehouse Lifecycle involving Design, Development, Analysis and Testing of Data Warehouses using ETL, Data Modeling and Reporting tools.
• Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Expert in all phases of Software development life cycle(SDLC) – Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Proficiency in utilizing ETL tool Informatica PowerCenter 8.x/7.x/6.x/5.x for developing the Data warehouse loads as per client requirement.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Main Frame systems (COBOL files), Oracle, Flat Files ( fixed width , delimited ),DB2 , SQL server , XML and Target databases Oracle, Teradata, SQL server, XML and Flat Files ( fixed width , delimited )
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements. Expertise in Data Flow Diagrams, Process Models, ER diagrams with modeling tools like ERWIN & VISIO.
• Strong Experience in Ralph Kimball's Star Schema and Snowflake Schema design to create Data Models like Logical and Physical design by using ER-win for Relational and Dimensional Data modeling.
• Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Worked with different Informatica performance tuning issues like source, target, mapping, transformation, session optimization issues and fine-tuned Transformations to make them more efficient in terms of session performance.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks indata warehousing, Data Profiling and ETL architecture.
• Developed a number of Complex Mappings and Reusable Transformations.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
• Strong experience in complex PL/SQLpackages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Experience in Unit, Functional, Integration and Regression Testing.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

ETL Tools: Informatica 8.x/7.x/6.x, Informatica Power Exchange 7.x/8.x,
Datastage 6.x, SQL Server Integration services.

OS: Sun Solaris 2.x/7/8, HP-UX, IBM AIX, Unix, Linux, Ms-DOS,
Windows ME/2000/2003/NT/XP, Exceed (Editor)

Databases: Oracle (6.x/7.x/8.0/8i/9i/10g),SQL Server,Teradata V2R5, Teradata V2R3, Sybase 11.5, Informix (XPS, 7.x/8.x), MS-Access , XML

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, JAVA,.Net(Eclipse IDE and Net Beans IDE), HTML, JAVA Script, J2EE, CSS

Db Tools: SQL*PLUS, SQL*LOADER, SQL*NET, Quest TOAD, SQL Navigator,
Oracle Enterprise Manager, Oracle WSGL/Web Tool kit.

DM Tools: Erwin, Visio

PROFESSIONAL EXPERIENCE:

Cox Communications,Atlanta: March'12-Current
Sr.ETL Developer

Cox Communicationsis a privately owned subsidiary ofCox Enterprisesproviding digitalcable television, telecommunications andwirelessservices in the United States. It is the third-largestcable television provider in the United States, serving more than 6.2 million customers, including 2.9 milliondigital cablesubscribers, 3.5 million Internet subscribers,and almost 3.2 million digital telephone subscribers, making it the seventh-largest telephone carrier in the country.Worked on analysis,design,development of Product Stickiness would like to assess how long a customer retains a product after the product has been installed during a specified period of time. This analysis will help Customer Care to construct future customer marketing campaigns.

Responsibilities:

• Involved in all stages of Software Testing Life Cycle and waterfall model of software development life cycle (SDLC).
• Involved in creating Technical Specification Document (TSD) for the project.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Used Informatica variables to implement complex logic for Informatica mappings.
• Extracted data from flat files, DB2, Teradata and loaded them into DB2, teradata.
• Developed complex mappings to facilitate daily, weekly, monthly Loading of Data. Worked on various transformations like Lookup, Joiner, Expression, Router, Filter, Update Strategy, Union and Stored Procedure.
• Involved in Performance Tuning of the mappings, sessions and determining the performance bottlenecks.
• Extensively used T-SQL for creating stored procedures, tables, views, triggers and user defined function for Data integration.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Coordinating with the DBA's for managing the databases in different environments for UAT and system testing, also involving with DBA's during the release nights and trouble shooting with any of the production problems.
• Worked with Testing team in trouble shooting the defects in application.
• Scheduled the Workflows and monitored them. Provided Pro-Active Production Support after go-live.

Environment:
Informatica Power Center9.1, Oracle10g,Teradata, Toad,SQL,Erwin,Visio, Unix.

Confidential, Dallas: Feb'11- March'12
Sr.ETL Developer/Tester

T-System was founded in 1996 by two emergency medicine physicians. Since that time, our market reach has exploded to support 1700 emergency departments (ED) totaling over 40% of hospitals in theUnited States. Over 15 years have passed since the first T-Sheet was designed and we are still providing the gold standard's for emergency medicine. As a T-System client, you have a solution that was built on the collective input of thousands of emergency medicine nurses and physicians.

Responsibilities:

• Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Involved in the data analysis for source and target systems and good understanding of DataWarehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Transformed data from various sources like excel and text files in to reporting database to design most analytical reporting system.
• Involved in Data Analysis, cleansing and profiling source data on heterogeneous Database sources like Oracle, SQL Server, DB2, Teradata & flat files.
• Initiate the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.
• Change Data Capture can do using the Power Exchange.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center.
• Using Data Explorer combines the data profiling and Data Mapping Capabilities.
• Extensively worked on Data Cleansing, Data Analysis and Monitoring Using Data Quality.
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router, Sorter and Stored Procedures, Java Transformations. And used debugger to test the mappings and fixed the bugs.
• Involved in fixing of invalid Mappings, Performance tuning, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Batches and the Target Data.
• Carry out Defect Analysis and fixing of bugs raised by the Users.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Using Toad to increase User productivity and application code quality while providing an interactive community to support the user experience.
• Created the Test cases and Captured Unit test Results.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i/10g.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager.
• Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment:
Informatica Power Center 8.6, Oracle10g,Teradata, SQL,Erwin, Control M, Unix.

Confidential, NJ Jan'09-Jan'11
Sr.ETL Developer

Responsibilities:

• Participated in the detailed requirement analysis for the design of data marts and star schemas. Worked with Data Warehouse Architect on logical and physical model designs.
• Worked with the Business users for their requirements and with the technical leads of the systems to understand the process of getting non-redundant data. Worked extensively with Sales and Marketing Data.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Complex mappings like Slowly Changing Dimensions Type 2 (Time Stamping) in the mapping designer to maintain full history of transactions.
• Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively involved in migration of ETL environment, Database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment:
Informatica Power Center 8.6, Oracle10g, Teradata,SQL, Erwin, Control M,XML, Unix.

Confidential, OH Nov '07-Dec'08
ETL/Informatica Developer

The client is into the Health and Medical care vertical. The prime responsibility of the team is to develop a Patient Care Data Warehouse (PCDW).This data warehouse is used to access easily the detailed clinical data on a platform and also to facilitate the enterprise-wide data analysis within the health care environment. The PCDW is up and running with incremental growth starting from 20 Terabytes of data. This Data Warehouse is build using Informatica Power Center 8.6.1 for extracting data from various sources.

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Created ER diagram of the data model using Erwin data modeler to transform business rules into logical model.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Worked with Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Used Source Qualifier, Aggregator, Lookup, Expression, Stored Procedure Transformations.
• Extensively worked with Informatica Designer. Designed and developed Informatica mappings for data loads and data cleansing.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions in a detail design document.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based on commit interval.
• Created Sessions and Batches to run Workflows.
• Responsible for writing unit test cases and performing the unit test.
• Involved in Production support and trained the other developers to handle issues
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Documented the ETL process and also issues encountered during UAT and production support for ease of future maintenance.

Environment:Informatica Power Center 6.1.1, Oracle 8i, XML,Toad, SQL Navigator, Erwin, UNIX, Business Objects 6.5, Windows 2000

Confidential, India Sep'06-Oct'07
ETL/Informatica Developer:

GE Real Estate is one of the world's leading resources for commercial real estate capital, through its capital markets, equity and structured finance products and services. Real estate owners and investors rely on GE Real Estate for a broad spectrum of financing solutions, including intermediate to long-term mortgage financing, restructuring and acquisition capital, asset management services, sales leasebacks and loan servicing.

Responsibilities:

• Worked with various data sources like oracle, flat files
• Involved in designing of Informatica mappings by translating the business requirements.
• Performed data manipulation using basic functions and Informatica Transformations
• Most of the transformations used were source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence generators
• Created reusable transformations and Mapplets and used them in mappings.
• Wrote stored PL/SQL procedures for certain Business Requirements
• Written SQL overrides in source Qualifier according to business requirements
• Written pre session and post session scripts in mappings
• Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process.
• Created sessions and workflows for designed mappings
• Performed unit testing for the mappings using SQL scripts
• Monitoring the session logs to check the progress of data load.

Environment:
Informatica PowerCenter/5.1, Erwin4.0, Oracle 8, MS Excel, MS Word, SQL, PL/SQL, Sql * Plus, QA Run

Confidential, India Oct '05-Aug '06
ETL Developer

Developed an Office Automation System for a software organization. Oasys is a software package, it is the state-of art-technology developed for office management application, which is designed to automate the operations involved in the software organizations. The HR (Human resource) module is responsible for new and existing employees in the organization and also takes care of the consultants pay, insurance, expenses and other facilities.

Responsibilities:

• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Extensively worked on Informatica client tools like Designer, Workflow Manager and Workflow monitor.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively involved in migration of ETL environment, Database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues.
• Debugging and problem resolution in Reports and Forms. Generated master-detail, matrix groups and tabular reports.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment:
Informatica Power Center 4.1/5.1, Windows 2000, Sun Solaris, SQL Server 2000, Oracle 8i, PL/SQL, UNIX Shell Scripting.