SUMMARY:

• More than 11 years of experience in data warehousing architectural design which includes designing, developing, implementing, testing and supporting Business Intelligence applications Lot of experience in utilizing ETL tool Informatica to load data warehouse Experience in building BI reporting solutions using Business Objects and Cognos 10 years of experience in Requirement Analysis, Gap Analysis, Data Cleansing, Data Relationships, Source Systems Analysis and Reporting 3 years of Dimensional Data Modeling experience using Erwin Experience with Siebel. Retrieved the data loaded using the Siebel Call Center module and loaded into data warehouse
• Knowledge of Informatica Data Quality IDQ and Informatica Master Data Management MDM
• Well versed with Informatica Powercenter 9.1 and 8.6.1 64 bit Strong technical development and design experience, especially with systems integration and interface development Well versed in Shell scripting and Perl scripting and fine tuning of the sql Extensively involved in migrating various Informatica sessions and mappings from one version to another Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional model and worked with complex denormalized and normalized data models Over 3 years of experience as a Lead ETL engineer leading team of developers, authoring technical specifications and diagrams, updating and discussing the status of the project with managers Experience in multiple business domains Telecom, Health care, Financial, Hospitality, Insurance, Commodities As a Lead/Sr.ETL Engineer, involved in implementing the best practices and standards to Project Management, Process improvement and Change Management Involved in the installation, configuration and administration of Informatica 9.1, 8.6.1 and upgrading the repository from 7.1 to 8.1.1 Involved in leading a team of onsite and offshore developers Experience in coaching, training educating users in the use of business intelligence tools Involved in on call rotation schedule supporting 24 7 production applications

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr DWH Consultant

Responsibilities Included:

• Provided the results of IDQ to the business users and data stewards for further analysis
• Worked on Informatica Data Quality IDQ for data profiling and to identify and resolve data quality issues per business requirements
• Created and tested shell scripts to call Informatica workflows and parameterized various inputs in the scripts which are supplied to the job scheduling tool Control-M
• Involved in meetings with Business Users, Architects and Managers to understand the current processing methodology and plan for ETL planning, designing, loading and testing and also for decommissioning the interfaces in the legacy system Involved in creating reusable components and testing them to implement the new requirements
• Coordinated and worked with cross functional business teams, development and testing teams to plan and execute the releases per the timelines Leading the status meetings with the project management and business sponsors and providing status reports every day Used Informatica PDO to push the transformation logic to the Teradata database Used Teradata features such TPT, FastLoad, MultiLoad, Query Banding and others
• Worked with Teradata DBAs for performance tuning of the queries and for gathering the compression details and for creating indexes Worked with Master Data Management team and understood their advises and concerns and identified the gaps and enhanced the coding standards accordingly in order to enable them get the data lineage details more clearly for generating more accurate data results and reports Involved in creating new jobs, testing and running them using the job scheduler Control M Responsible for validating the data loaded into QA, UAT and Production databases Mentoring and leading a team of developers and testers. Actively involved in bug fixing and also involved in code reviews

Environment: Informatica Power center 9.1, IDQ 9.1, Control M 8.0, Teradata 13, Subversion, Quality Center, Jira

Confidential

DWH/BI Lead

Responsibilities Included:

• Created shell scripts to call Informatica workflows and parameterized various inputs in the scripts which are supplied to the job scheduling tool Control-M
• Involved in daily meetings with Business analysts, Architect and Manager to understand the current processing methodology and plan for ETL design and loading Involved in planning, designing, developing mappings/mapplets/workflows/worklets and reusable transformations to implement the new requirements
• Coordinated and worked with cross functional business teams and testing teams to plan and execute the releases per the timelines Leading the status meetings with the project management and business sponsors and providing status reports every day Involved in preparing Best practices document, Code review approach document, Migration document, Run Books and Error handling strategies document for handling bad records Involved in creating new jobs, testing and running them using the job scheduler Control M Responsible for uploading and downloading the code using ClearCase software and sharing that with the team members Mentoring and leading a team of developers. Actively involved in coding, bug fixing and also code reviews

Environment: Informatica Power center 9.1, Control M, Oracle 10g, COBOL, VSAM Files, Business Objects, ClearCase

Confidential

Sr DWH Consultant

Responsibilities Included:

• Created batch scripts which call Informatica executables and parameterized various inputs in the batch scripts which are supplied to the job scheduling tool Control-M
• Created batch scripts to call cURL utility in order to read files from websites and pull to our servers
• Used Sybase IQ bulk loader as part of loading
• Worked with various databases such as SQL Server, Oracle and Sybase IQ
• Involved in daily scrum meetings with Business analysts, Architects, SMEs and Director to understand the current processing methodology and provide status updates and plan for ETL loading Involved in Admin activities and worked with Architect to create the Informatica shared folders, project folders, connection objects and give access rights
• Involved in planning, designing, developing mappings/mapplets and reusable transformations to implement the new requirements
• Involved in creating new jobs and running them using the job scheduler Control-M Coordinated and worked with cross functional business teams and testing teams to plan and execute the releases as per the timelines Responsible for migrating projects between multiple environments Dev, QA and Prod Worked with the QA team to resolve and fix the defects Involved in preparing Best practices document, Code review methodology document, Migration document and Error handling strategies document for handling bad records Mentored existing developers and helped in resolving their issues and involved in code reviews.

Environment: Informatica Power center 9.1, Control-M 7.0, Sybase IQ 15, Oracle 10g, SQL Server 2008 R2, cURL, Batch Scripting, Agile Scrum Methodology

Confidential

Sr DWH Developer/On-Site Lead

Responsibilities Included:

• Worked with various source systems such as DB2,SQL Server and Oracle
• Actively understanding and following Agile methodology principles
• Involved in meetings with Business analysts and source system SMEs to gather the requirements and understand the source data and involved in doing the impact analysis Involved in daily status meetings with project manager, technical manager to update the status and understand the future project deadlines and update that with the team members
• Involved in developing mappings/mapplets and Linux scripts to implement the new requirements Involved in creating new jobs and running them using the job scheduler ESP Coordinated and worked with various groups such as Architects and testing teams to plan and execute the releases as per the timelines Responsible for migrating projects between multiple environments Dev, QA, UAT and Prod Worked with the QA team to resolve and fix the defects Involved in preparing best practices document and error handling strategies for handling rejected records Acted as a liaison by involving in daily status meetings with offshore developers and updating them about onsite activities, priorities and status of projects Involved in code reviews and also advising the team on the design and coding best practices and troubleshooting the issues

Environment: Oracle 10g, Informatica Power center 8.6.1, Red Hat Enterprise Linux 5.5, Cybermation ESP, Agile Methodology, AS400, DB Visualizer, SQL Server Management Studio, SQL Developer, and Teradata.

Confidential

Sr DWH/BI Developer

Responsibilities Included:

Involved in the meetings with cross functional teams such as business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the loading to DWH Involved in status meetings with project manager, technical manager and architects to update the status and understand the future project deadlines and updated that with team members Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin Prepared project plans, best practices document, error handling process document and project timelines documents Implemented Informatica recommendations, methodologies and best practices Involved in installing, configuring and administering Informatica and created multiple repositories/folders to support multiple projects Setup folders, groups, users, permissions and performed Repository administration using Repository Manager/Admin console Involved in configuring LDAP authentication for Informatica Involved in managing the Unix servers and defining the file systems/directory structures on the Unix box for various parameters and deciding the disk space and memory requirements Involved in designing and developing the entire warehouse architecture and plan the ETL process Documented technical design documents based on the BRD and SRS. Leveraged the advanced features such as data masking transformation and Pushdown optimization for developing mappings Analyzed existing sql queries, tables and indexes for performance tuning and advised based on the loading time Extensively involved in developing shell scripts, perl scripts for analyzing the database tables automatically Involved in creating stored procedures, functions and triggers for generating custom reports Responsible for implementing the type2 slowly changing dimensions Involved in code review and implemented better design standards for process improvement Extensively worked with QA team to resolve the issues Worked extensively with the Dev and QA teams to plan and execute the releases. Responsible for migrating projects between multiple environments Dev, QA, UAT and Prod using TFS version control utility Responsible for troubleshooting and backup of various repository databases Involved in leading a team of 6 on-shore and offshore developers and communicating with the offshore team on daily basis and assigning tasks to them and updating the management about the status of tasks Extensively involved in loading the data from oracle to Netezza database and validating it and resolving issues related to Netezza Used Informatica metadata manager MDM for data analysis and lineage Environment: Informatica Powercenter/Powerexchange 8.6.1, Oracle 10g, Erwin, Windows, HP-UX-IA64, HP Quality Center, Netezza 4.6, Perl, SQL Server 2000, Metadata manager

Confidential

Sr DWH/BI Developer

• Involved in creating stored procedures, functions and triggers for generating custom reports
• The objective of this project is to load data from various external and internal sources. The source data consists of Customer details, sales, revenue, call details, handset details from manufacturers and all other information that is sent by various vendors and business groups. The source data is loaded as different work units and processed to the presentation layer from where reporting team takes care of generating reports. Responsibilities Included: Involved in the meetings with business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the loading to DWH Involved in daily project status meetings and updated project manager, development manager and team members about the achievements Provided support in administration of the Informatica repository and assisted in the design and architecture of multiple repositories to support multiple application development and QA environments Setup folders, groups, users, permissions and performed Repository administration using Repository Manager Worked with the Admin team to upgrade the project from Informatica 7.1 to 8.1.1 Provided support to develop the entire warehouse architecture and plan the ETL process Documented technical design documents based on the BRD and SRS. Involved in developing mappings, mapplets, worklets and other reusable objects Used the advanced features and implemented various techniques at Informatica level and database level to improve the performance of the applications Involved in preparing stored procedures and complex sql to filter data at source qualifier level it self Analyzed existing sql queries, tables and indexes for performance tuning and advised based on the loading time Extensively involved in developing shell scripts and perl scripts for loading the partitioned data from one database instance to another database and for rebuilding indexes
• Responsible for code walk-through with other co-developers for knowledge sharing and process improvement Worked extensively with the release team to plan and execute the releases. Responsible for migrating projects between multiple environments Dev, QA, UAT and Prod . Involved in on call schedule to support production environment and extensively involved in resolving the production issues Responsible for troubleshooting and backup of various Projects Extensively involved in loading the data from oracle to Teradata database and validating it Used the Teradata components BTEQ, Fast export, Multiload etc to load the tables Used informatica metadata manager for data analysis and lineage

Environment: Informatica Powercenter 8.1.1, Oracle 10g, Erwin, Windows, Solaris, Business Objects, Remedy, Cybermation, Perl, Teradata V2R5, Metadata Manager MDM

Confidential

DWH/BI Developer

Responsibilities Included:

Involved in requirements gathering, ETL design, development and analysis in support of data warehousing efforts Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin Involved in weekly status meetings and updated the team about the achieved and pending tasks Setup folders, groups, users, permissions and performed Repository administration using Repository Manager Involved in the installation, configuration and administration of Informatica and upgrading the repository from 7.1 to 8.0 Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area Processed customer address elements by Cleansing, standardizing and converting using Trillium Implemented various techniques to improve the performance of the application Involved in creating stored procedures to perform database operations on pre mapping/post mapping Responsible for implementing the CDC using type1 and type2 slowly changing dimensions Executed queries on the source database to get the required data which is being populated from the front end using Siebel Call Centre module Responsible for developing the mappings, mapplets and reusable objects and having code walkthrough with other co-developers for knowledge sharing and process improvement Creation of process flows to run the mappings and UNIX shell scripts depending on requirements. Responsible for the daily loads and handling the rejected data Drilled out each of the data flows to plan which areas to work on, and for sequencing the transformations with in each data set Extensively involved in production support and also in resolving issues related to UAT and Production Responsible for troubleshooting and backup of various Projects

Environment: Informatica Powercenter 8.0/7.1, DB2, Windows XP, AIX, Autosys, Sql Navigator,