Professional Synopsis

• A competent professional with 7.1 years of experience in IT Industry mainly into data warehousing projects.
• Thorough understanding of the SDLC with proficiency in mapping business requirements, technical documentation, design and development.
• An effective team member with proven abilities in areas of requirement gathering, designing, development, Functional Studies, Quality Reviews, testing and deployment of the projects.
• Worked very closely with customers, end users and powered users to collect requirements and resolve any business process related issues.
• Strong Data Warehousing ETL experience of using Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Experience as Business Intelligence Developer in Production, Development and Staging Environments.
• Expertise in working with relational databases such as Oracle 11g/9i, SQL Server 2012/2008/2005.
• Involved in Huge data migrations, transfers using Tools like Informatica and SSIS.
• Strong experience in Extraction, Transformation and Loading ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center Repository Manager, Designer, Workflow Manager, Workflow Monitor
• Worked extensively with slowly changing dimensions.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions
• Experience in using SSIS tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in importing/exporting data between different sources like SQL/text/Oracle etc. using Informatica and SSIS utility.
• Experience in defining data warehouse star and snow flake schema , fact table, cubes, dimensions, measures
• Experience in using Automation Scheduling tools like Autosys, SQL Server Agent.
• Extensive experience in Database activities like data modeling, database design, performance monitoring.
• Experience in developing reports in SSRS on SQL Server 2005/2008 .

Technical Details

Hardware / Platforms

Win XP, Windows server 2003, Windows server 2008, Windows server 2010, Windows 7

Technology

Oracle 9i/11g ,SQL Server 2000/2005/2008/2012

Programming Languages

T-SQL, PL/SQL Programming

Databases Tools

• Informatica Power Center 9.5.1, Toad, Raptor,
• SSIS,SSRS,SQL Server Management Studio, BIDS, SQL
• Server Migration Assistant

Other Utilities

Crystal report XI, Araxis Merge, Visual Source Safe 6.0, Source of Site, TFS and SVN

Relevant Project Experience

PROJECT 1:-

Technology

Informatica, SQL Server 2008

Project Description

Nationstar Mortgage, headquartered in Dallas, is one of the nation's leading mortgage servicers and lenders offering conforming, Fannie Mae, FHA, FHLMC, VA, Jumbo and USDA products directly to consumers. They are providing exceptional customer service and a wide range of competitive mortgage products.

Nationstar has its own data hub where all loans related data are stored. This project is basically capture loan information from different sources and stored in on data ware house in order to make central repository and build efficient reporting.

Role

ETL Lead

Responsibilities

Informatica ETL development -

• Responsible for Business and data Analysis and Requirements Collection.
• Used Informatica Power Center Workflow manager to create mappings, sessions workflows to apply the business logic.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Creation of Unit Test Cases, Unit Test Cases execution and Code Reviews.
• Creation of Deployment plan and Defect fixing in UAT.

PROJECT 2:-

Technology

Informatica, Oracle 11g, Unix, Cognos, QlikView.

Project Description

Control Room is an initiative by the JPMC Executive Management to showcase their commitment to the Regulators about the Compliance Governance process implemented within JPMC.

Control Room is a physical room located in JPMC, NY which facilitates the monitoring of different risk metrics for the Senior Management.

There are several data categories planned to be on-boarded to the Control Room as a part of the long term plan.

The Technologies involved are Informatica, Oracle 11g, Unix, Cognos, QlikView.

Role

ETL Lead

Responsibilities

Informatica ETL development -

• Involved in requirement Gathering / Design / Development / Enhancement / Testing / Implementation / Support Activities for this Project.
• Developing the Informatica ETL Code required to run on timely Basis to on-board contexts information in RADAR/Control Room.
• Work as a Developer on the Enterprise Data Warehouse Program/ ETL Framework at JP Morgan Chase to deliver Data Warehouse and Business Intelligence solutions utilizing the Informatica and Cognos BI platform.
• Gathering the Requirements from the Business Users / Technical Teams of JP Morgan Chase.
• Analysing the requirements and preparation of ETL Technical Design documents.
• Onsite / offshore coordination.
• Used Informatica Power Center Workflow manager to create mappings, sessions, worklets workflows to apply the business logic.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Creation of Unit Test Cases, Unit Test Cases execution and Code Reviews.
• Creation of Deployment plan and Defect fixing in UAT.
• Support Development / Enhancement requests.

PROJECT 3:-

Technology

Informatica, SSIS, SSRS and MS SQL Server 2008, 2012

Project Description

Think Finance is a lending company offering short-term installment and revolving loans to United States residents. TC payday loan and cash advance services provides a consumer an opportunity to obtain cash funds in an emergency. The loans offered are dissimilar to traditional loans from a bank and other payday lenders in product structure, offer and time to complete a transaction.

Think Finance has identified improvements in information quality as a strategic activity to improve business processes, performance, and ability to audit. As part of this strategic initiative it has decided to create a data factory organization and practices and the physical data warehouse and architecture. The scope of this project would be create Enterprise subject area model, Enterprise logical data model, Enterprise Data warehouse and operational data store architecture, Organization architecture, Periodic readiness assessments, Backup and restore process, Data warehouse and ODS process automation framework process.

The Technologies involved are Informatica, SSIS, SSRS and MS SQL Server 2008, 2012

Role

Module Lead/ETL Developer

Responsibilities

SSIS/SSRS/T-SQL development -

• Performing all the needed Requirement Gathering / Design / Develop / Enhance / Test / Implement / Support Activities for the Project.
• Developing the SSIS / SSRS/ T-SQL Code required to run on Daily Basis for Marketing ,Finance, Loan ops, compliance LOB's of Think Finance
• Work as a Developer on the Enterprise Data Warehouse Program at Think Finance.
• To deliver Data Warehouse and Business Intelligence solutions utilizing the Microsoft BI platform.
• Gathering the Requirements from the Manager / Business Users / Other Technical Teams
• Analysing the requirements and suggest suitable improvements, Technical Design
• Write SQL Server SSIS Packages, SQL server reports / Procedures in accordance with Standards and Procedures
• Testing Performance Tuning of written code
• Technical Documentation

Code Reviews

Onsite / offshore coordination

Support Development / Enhancement requests

Informatica ETL development -

• Analyzed the business requirements and functional specifications.
• Migration of SSIS developed ETL process into Informatica ETL program using Informatica Power Center.
• Creation of mappings, sessions workflows to apply the business logic similar to SSIS transformation.
• Creation of parameter files for replacement of SSIS package configuration file.
• Prepared SQL Queries to validate the data in both source and target databases.
• Created test cases for the mappings developed and created integration testing document.
• Unit test case Execution and Code Reviews.

PROJECT 4:-

Technology

Informatica, Oracle 11g

Project Description

iCert is a web access tool which will help Information Owners and Line manager of JPMC to complete the Off Boarding Termination and Transfer and Recertification of all WSS High risk applications in a timely format. This web application helps JPMC Information Owners and Line manager to maintain proper access rights of various users of the application while termination, transfer and recertification. This tool also maintains various application information as well as user information. It also provides reporting metrics to Information Owners, senior managers. This project involves loading and processing various data files containing data for various JPMC applications and presents them to Information owner and Line Manager for access right verification. The Technologies involved are Informatica, Oracle 11g, Visual Studio .NET 2008.

Role

Module Lead/ETL Developer

Responsibilities

Informatica ETL Development:-

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Informatica Mapping, Workflow design and development.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Data error logging through mapping.
• Email Notification Configuration in workflows.

PROJECT 5:-

Technology

Informatica, Oracle, SQL Server 2008, SSIS

Project Description

The CFA- talent management tool is for commercial banking and Government Institutional banking group. The Talent Management Tool is a performance analysis model to help Commercial Banking and Government Institutional banking managers streamlines the performance review process, evaluate team members and assign performance rating and long term potential.

This project involves loading and processing various data from database containing data for various team members. The Technologies involved are Informatica, Oracle, SQL Server 2008, SSIS.

Role

Module Lead/ ETL developer

Responsibilities

Requirement gathering and Design:-

• Requirement gathering from onsite counterparts.
• Preparation of Design document for database based on requirement understanding.

Informatica Development:-

• Creation of mappings, sessions, worklets workflows to apply the business logic.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Developed slowly changed dimensions SCD Type 2 for loading data into Dimensions and Facts.
• Involved in Data Extraction from Oracle, SQL Server and Flat Files using mappings in Informatica Power Center.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements
• Tested mappings and sessions using various test cases in the test plans.

SSIS Development:-

• ETL development.
• SSIS Packages design and development.
• Configuration of SSIS Packages.
• Implementation of ETL Packages using SSIS 2008.
• Implementation transformations available on the SSIS toolbox.
• Error logging and event handling in SSIS.
• Email Notification Configuration in SSIS.
• Deployment of SSIS packages on Dev and QA servers.
• Management and administration of SSIS packages after deployment.
• Developing SSRS reports for business end users

Database Design and Development:-

• Design database as per requirement.
• T-SQL Programming: - Writing Stored Procedures, Triggers, functions etc.
• Creation of appropriate indexes on tables.
• SQL Server Agent Jobs: - Development and Maintenance.