SUMMARY

• More than 8 years of proven experience in the IT industry with development and implementation of Data warehousing and Database, Application and Web development
• Experience in onsite - offshore model
• In depth understanding of Data warehousing concepts. Experience with various Data ware housing/ETL tools - INFORMATICA. Teradata, reporting.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Development, Informatica Repository Manager and Informatica Server Manager, Workflow Manager & Workflow Monitor.
• Experience in all phases of SDLC including Requirements Gathering, Design, Development, Testing, On-going support and Maintenance.
• Experience in various Databases such as Teradata, Oracle and MS SQL Server 2008 using PL/SQL
• Experience in Dimensional Data Modeling, worked on Erwin Modeling (Erwin 7.3) and developing optimized Logical & Physical data models
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in designing/developing complex mapping using transformation like Unconnected and Connected Lookup, Router, Filter, Expression, Aggregator and SCD involved transformation
• Created reusable transformations and mapplets to reduce the complexity in mappings and to handle repetitive tasks
• Implemented sequence generator and update strategy transformations
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes
• Experienced in Testing, Debugging, Validation and Performance Tuning of data warehouse
• Experience using Flat files, CSV files
• Experience using debugger to test the data flow and fix the mappings.
• Experience in system integration and user acceptance testing
• Familiar with UNIX Shell Scripting, PL/SQL Coding, Normalized Database creation in relational databases like Oracle 8i/9i, MS-SQL Server 2008 and optimizing the SQL to improve the performance
• Good knowledge on IDQ
• Experience in reporting tools Logi Analytics, Business Objects
• Strong experience in Data warehousing, Data Integration, Data Migration from Dev to QA, Prod.
• Successfully optimized slow-running jobs and Informatica code at mapping and session level
• Experience in UNIX Shell Scripting.
• Efficiently used the utilities Teradata SQL assistant, import/export in UNIX environment
• Experienced in working in Manufacturing, Service, Health care and other business domains
• Extensive experience in writing test cases, data validations and verifying the quality of code
• Extensive experience in documentation of data assessment, data mapping, code review, test plan and operations
• Experience in production support
• Certified in Teradata V2R5 and SAP HANA 1.0
• Experience in ASP, VB, .NET, Core Java
• Strong Team working spirit, communication and relationship management skills

TECHNICAL SKILLS

Data Warehousing and ETL: Informatica Power center 8.1.1,8.6.1,9.1 IDQ 8.6.1 BODS 4.0, and Oracle 8i, 10g,11g PL/SQL, Microstrategy 8.0, Unix Shell Scripting Teradata BTEQ and Multi Load, Fast Load, TPump and other loads and utilities scripts

Tools: Teradata SQL Assistant Query man, Informatica, TOAD, Visual Studio.NET, HP Quality Center and Defect Tracking system, Erwin 4.1 Data Modeling.

Databases Tools: Teradata 12, Microsoft SQL Server 2008, Oracle 9i and PL/SQL

System monitoring tool: Teradata Performance Monitor, Teradata Manager, Viewpoint

Query Analysis and Recommendation Tools: Teradata Analyst Pack (Index Wizard, Statistical Wizard, Visual explain and TSET).

Programming Languages: C#.Net, ASP, Java, JavaScript, C++, HTML/XML, Unix Shell scripts

OLAP/Reporting: Business Objects 4.0, XI

Scheduling tools: Dollar Universe Scheduling tools.

Code Versioning Tools: Visual Source Safe (VSS) tool, PVCS

Scripting Language: VB Script, Java script, Shell Script

Operating Systems: Windows NT/2000/XP, UNIX/LINUX

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Sr ETL Consultant

Responsibilities:

• Being an onsite lead involving in full life cycle of the project
• Participated in logical and physical model design meetings and developing logical and physical data models
• Prepared functional specification and detailed design documents
• Worked with various sources types such as relational, flat files and XML sources
• Created Data dictionary using ERWIN modeler
• Experience in designing/developing complex mapping using transformation like Unconnected and Connected Lookup, Router, Filter, Expression, Aggregator
• Used normal and bulk loads
• Used debugger to test the data flow and fix the mappings.
• Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Created reusable transformations and mapplets to reduce the complexity in mappings and to handle repetitive tasks
• Implemented Sequence generator and Update Strategy transformations
• Used session partioning to improve the performance of the database load time.
• Involved in versioning the whole process and retiring the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT.
• Created reusable transformations and mapplets to reduce the complexity in mappings and to handle repetitive tasks
• Implemented Variables and Parameters in the mappings.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX
• Developed Complex Workflows for initial loading, historical data loading using sessions, worklets, commands, decisions, events and timers.
• Cleansing and processing data from stage to data marts using Informatica transformations
• Performed tasks of validating, executing and scheduling the sessions in Informatica
• Involved in design and development of new and change requests
• Involved in ETL developing, Testing and implementation.
• Tuned the mappings different logic's to provide maximum efficiency and performance
• Involved in unit testing, system integration and user acceptance testing and fixing bugs
• Worked on HP Quality center
• Involved in code migration from development to QA and QA to production systems
• Worked change requests

Environment: Oracle 9i, SQL, Flat files, CSV files, Informatica 8.6, 9.1, Erwin 7.3, Teradata 12, Unix

Confidential, Carlsbad, CA

Analyst

Responsibilities:

• Create executive reports, SLA score cards
• Create cross tabs, reports, dashboqrds
• Create various adhoc reports
• Creating monthly newsletters, audits
• Make sure timelines are maintained
• Triaging Remedy tickets

Environment: Logi XML, MS SQL Server2008, Remedy8.1, MS Excel 2010

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• As a developer involved end to end process right from analysis, requirement gathering, designing, development and unit testing.
• Involved in ETL developing, Database Designing, Coding, Debugging, Testing and implementation.
• Analyzed the Sources, targets, transformed, mapped the data and loaded the data into Targets using Informatica.
• Involved in developing mappings for migrating data from source Oracle to target Teradata.
• Tuned session configuration and in session advanced parameters, optimizing mappings, and source and target database for loading the data.
• Developed various sessions for all mappings for loading from source tables to Flat Files and Flat Files to target tables.
• Worked with the TPUMP and FASTLOAD utility of Teradata database for better performance.
• Worked with Teradata BTEQ to run the scripts in batch mode.
• Migration of code from one environment to another environment.
• Tuned mappings with different logic's to provide maximum efficiency and performance
• Used debugger to test the data flow and fix the mappings.
• Worked with workflow manager used for creating and maintaining sessions, copying, editing, scheduling, monitoring and aborting.
• Understand design requirements
• Involved in SQL server reporting, writing T-SQL scripts
• Doing Sanity checks
• Doing Unit testing, Integration testing, Performance Testing in TEST environment.
• Evaluate testing steps and preparing test case
• Working with Users and Downstream for pilot applications, Working closely with SMEs and developers to make sure that test cases and test strategy cover every aspect to catch defects at initial stages of testing
• Doing data reconciliation extensively between Oracle and Teradata, preparing audits for maintaining quality.
• Responsible for evaluating all identified and entered defects encountered during testing
• Raising cases against found issues, and assigning them to developers, updating them in Quality Center.

Environment: Oracle 8i, SQL, Informatica 8.1, 8.6, Teradata, SQL Server, Unix

Confidential, CA 

Responsibilities:

• Clarify requirements
• Understand design requirements
• Developing test cases
• Execute and supervise execution of test case
• Worked with developer in clarifying the exact requirements
• Provide feedback to Analysts and Developers on test results
• Designing and documenting validation rules, error handling and test strategy of the maps and tested all mappings developed in Power Center repository and checked data
• Running month end jobs (most of them need manual intervention) and resolving issue(s), Communication to the concerned mail aliases for any failure
• Following and preparing Quality Documents conferring to standards, Promoting the changes, Production support.
• Interaction with DBAs, Sys-Admins, Operations teams
• Preparing weekly status reports which show various metrics on support hours spent by application, number of issues, Log down this issue & action history in an excel sheet, Participate in the infrastructure process improvement and tool improvement of any existing tools as well as participate in the definition any new processes and tools as needed, Proactively participate in performance tuning of jobs
• Attend & resolve issues with any production job failure either for the day or night refreshes

Environment: Oracle 8i, Informatica Power Center 6.2, Unix, Windows 2003 Server

Confidential

Responsibilities:

• Involved in the design, development of several of the above mentioned modules
• Developed the required data access modules
• Involved in the implementation of the modules
• Provided Support, involved in trouble-shooting production issues.

Environment: ASP, VB, Oracle, IIS, SQL, PL/SQL