SUMMARY OF EXPERIENCE:

• Over 12+ years of total IT experience in the Analysis, ETL Architecture, Design, Development, Production support, Data profiling, Implementation and Testing of Client/Server and Data Warehousing Applications using Object Oriented Analysis, and ETL Methodologies.
• Over 12 years of Experience in Data warehousing and business intelligence wif exposure to SQL Server, Oracle 11g/10g/9i, Teradata and Informatica Power Center 10.x9.x/8.x, Power Exchange.
• 6+ years of experience as Tech/Project Lead, successfully handed offshore - onshore model by achieving all the delivery deadlines.
• 5+ Years experience and strong background in Agile Methodologies.
• 3+ Years of experience in Reporting tools Business Objects and Cognos
• 5+ years of experience of Scum Master
• 2+ years of experience wif ETL development wif Ab Initio.
• 3+ years of experience wif ETL development wif Pentaho
• 1+ Years of experience using ETL tool Data stage
• Worked extensively in Architecture wif regards to setting up ETL applications in the view of work environment and source code management.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Vastly experienced wif various Databases like Vertica 8.2,Teradata,Oracle 11g/10g/9i, Db2, Sql Server
• Performed data analysis and data profiling using complex SQL on various sources systems including Vertica, Oracle and Teradata.
• Efficient in all phases of the software development lifecycle, coherent wif Data Profiling, Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Experience wif Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Monitoring and resolving Data warehouse ETL Production issues.
• Experience in Visual Studio, UNIX Shell scripting, COBOL, SAS and VSAM.
• Extensively used Change Data Capture to simplify ETL in data warehouse applications.
• Automated the jobs using the Scheduling tool Automic, AutoSys, CA7, Tidal and Control-M
• Efficiency displayed Team-coordination and ensuring customer satisfaction by providing extensive support.
• Provided production & development support (24X7).
• Co-ordinate wif Offshore team in all phases and had the responsibility of the onsite has well as offshore Team.
• Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, sincere, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS:

Data Warehousing Tools: PowerCenter10.x/9.x/8.x, Power Exchange, Data stage, Ab Initio (GDE 1.15/1.14/1.13), Pentaho7.0

Databases: Vertica8.2,Oracle10g/9i/8x/7x,SQLServer2008/2012,Teradata V13.0.,DB2

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and Dimension Modeling Tables, Erwin 4.0/3.5.5,MSVisio

Reporting tools: Business Objects XI 6.5/ Cognos 8.2/8.3/8.4

Testing tools: MTM,WinRunner7.X,QTP, Load Runner, Test Director 8.0/7.x/6.0

DB &Other Tools: USQL, SQL Navigator, VSTS, Toad, SQL* Plus, SQL*Loader, Test Director 8.0, Quality Center, SQL Navigator, Visual Source Safe (VSS), PVCS, Clear Case, Clear QuestProgramming: SQL, PL/SQL, COBOL, JCL, SQL SAS, TSL, HTML, XML,JAVA, C++, C, Unix Shell Scripting, PERL

Job Scheduling Tools: Automic, Control-M, Autosys, CA7 and Tidal

Version Control Tools: Rational Clear Case, PVCS

Operating Systems: Windows 9x/NT/2000/XP, Mainframe, Linux, UNIX, Sun Solaris, HP-UX 10.0.2, IBM-AIX

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL Lead /Sr. ETL Developer

Responsibilities:

• Involved in meeting wif business to gather requirements.
• Provide technical leadership to other support team members and resolution of technical issues
• Provide recommendations on database index strategies based on performance metrics
• Reviewing data models and doing code reviews.
• Code change migration from Dev to QA to PERF to Production.
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Conduct impact assessment and determine size of effort based on requirements
• Using the data Integration tool Pentaho Informatica for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Initiated extensive documentations for the Production Support process improvements.

Environment:Informatica9.5,Pentaho7.0,Vertica,Oracle11g,DB2,Mainframe,Automic,python,MTM,SQL Server, Linux scripting,Cognos

Confidential, Wilmington, DE

ETL Lead /Sr.ETL Developer

Responsibilities:

• Assessed requirements for completeness and accuracy and determined if requirements are actionable for ETL team
• Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Working wif stake holders / product owners to prioritize the requirements for sprint.
• Identified, recommend and implemented ETL process and architecture improvements.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• formed data analysis and data profiling using complex SQL on various sources systems including Oracle, Sql Servers andTeradata
• Review and sign off on system requirements, Design documents, Test documents etc.,
• Created ETL mapping wif PL/SQL procedures/functions to build business rules to load data.
• Solving the complex ETL logic issues wif our Enterprise Data Services scrum teams using ETL tools like Informatica, Ab Initio.
• Initiated extensive documentations for the Production Support process improvements.
• Developed UNIX shell scripts for automation of the process invoking stored procedures.
• Maintains an excellent relationship wif business users, and customers.

Environment: Informatica 8.6, Ab Initio, Teradata, Oracle11g/10g, SqlServer2008 Control-M, Tidal, Toad, Quality Center, ER Studio, UNIX Shell Scripts

Confidential, Wilmington, DE

ETL Lead/Sr. ETL Developer

Responsibilities:

• Created the High-Level architecture design documents and ETL frame work design documents.
• Used Informatica Power Center 8.6 for extraction, transformation and loading (ETL) of data in the data warehouse.
• Worked in analyzing the issue, trace the problem area, suggest a solution, discuss wif business.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance
• Improved the performance of the application by rewriting the SQL queries.
• Establish projects, roles, users, privileges in different ETL environments (DEV, QA, PROD by using Admin console).
• Involved in data analysis and handling the ad-hoc requests by interacting wif business analysts, clients and customers and resolve the issues as part of production support
• Initiated extensive documentations for the Production Support process improvements
• Wrote stored PL/SQL procedures for control processes and certain Business Requirements. Profiled data using Informatica data profiling tool.
• Designed/Developed unit test plans to test Informatica processes.

Environment:SQLServer2008,Oracle10g,Informatica-PowerCenter8.6,Visio,UNIX,WindowsXP,Erwin, cognosv8 Power Exchange.Toad,Tidal.

Confidential, Saint Louis, MO

Sr.ETL Developer/Programmer Analyst

Responsibilities:

• Identify the data from both TCS and ICS required to support the operational reporting for the Credit Card Administration group.
• Analyze the data for completeness and linkages.The sources of the data are: TCS Master from the TCS collections application.TCS Activity from the TCS collections application.
• Used Informatica Power Center 8.6for extraction, transformation and loading (ETL) of data in the data warehouse.
• Involved in FTP process to transfer the files from one server to other.
• Designed/Developed unit test plans to test Informatica processes

Environment: Informatica PowerCenter 8.5 Informatica PowerExchange CDC, Oracle10g and Mainframe,Autosys, SqlServer2005,Toad, QualityCenterv9.0,ER Studio 7.1.1,DB2,Windows XP, UNIX Shell Scripts

Confidential /Syncada, MN

Sr.ETL Developer/Programmer Analyst

Responsibilities:

• Developed high level technical design specification and low level specifications based on the business requirements.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) wif business users.
• Tech Leads will drive all architectural decisions
• Extensively used Teradata SQL for complex Transformations
• Extensive use of Teradata Utilities Multiload and BTEQ
• Involved in creating Data Marts and altering and creating new dimensions and Facts

Environment: Informatica PowerCenter 8.6 Informatica PowerExchange CDC, TeraData,Oracle10g and Mainframe, Autosys, SqlServer2005,Toad, ER Studio 7.1.1,DB2,Windows XP, Quest Central for DB2 v 4.8 UNIX Shell Scripts, Extra X-trame V9, Cognosv8

Confidential, MN

ETL Developer/Programmer Analyst

Responsibilities:

• Wrote stored PL/SQL procedures for control processes and certain Business Requirements.
• Created and used parameter files to provide values to the variable used across sessions and workflows of Informatica to reuse wif multiple criteria to decrease maintenance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Involved developing Shell Scripts for Data validations, PL/SQL procedures and SQL scripts for creating tables, Indexes and for testing the data. Extensively used ORALCE Export/Import Utilities to move the data in between databases.
• Co-ordinate wif Offshore team in all phases of the project and had the responsibility of team work.

Environment: InformaticaPowerCenter8.6, Oracle9i, SQL, PL/SQL, WindowsXP, Shell Script, FTP, UNIX, Autosys 4.0