Nishant Sharma

**** *** ******** **. ***#***

Tampa,FL 33614

Mob#-727-***-****

SUMMARY

* ***** ** **** ********** in IT Industry in analysis, design, development,

administration and maintenance of various software applications mainly in

Data Warehousing in industry verticals like Banking and Financial Domain.

Responsible for all activities related to the administration and support of

ETL processes for large-scale data warehouses using Informatica Power

Center.

Monitor, Manage and Coordinate administration of the Informatica Power

Center for a large complex environment.

Holding Strong skills in Data Analysis, Data Migration and Data Mapping for

ETL processes.

Hold extensive experience in Data Mart life cycle development, performed

ETL procedure to load data from different sources into data marts and data

warehouse.

Experienced at creating effective test data and development thorough unit

test cases to ensure successful execution of the data.

Hands on experience in tuning mappings, identifying and resolving

performance bottlenecks in various levels like sources, targets, mappings

and sessions level.

Understanding of Meta Data, Data Profiling & Data Quality needs on ETL,

Data Migration and Data Warehouse processes.

Excellent communication and presentation skills, self-starter, quick

learner, team player, coordinating cross-functional teams, project

management and presenting technical ideas to diverse groups.

Responsible for creating users, groups in Informatica Administration

console for Informatica domain.

Performed administrative tasks in Informatica such as managing logs, user

accounts and domain objects.

Coordination with Informatica global support team to resolve outstanding

issues related with installations and performance.

Migration of ETL objects among various environments.

Understanding of Meta Data, Data Profiling & Data Quality needs on ETL and

Data Warehouse processes.

Excellent communication and presentation skills, self- starter, quick

learner, team player.

TECHNICAL SKILLS:

ETL Tools Informatica Power Center 8.6/9.0.1/9.1.0, Informatica

Designer, Workflow Manager, Workflow Monitor,

Repository Manager, Informatica Proactive Monitoring,

Informatica Support Console, Power Center Data

Analyzer, Power Center Data Validation Option

9.5.2.1,Metaquery, Informatica Administration,Cognos

8, Framework Manager, Cognos TM1

Data Modeling Dimensional Data Modeling, Star Schema Modeling, Snow

Flake Modeling

Operating Systems Windows 98/2000/XP/Vista/,Windows7

Programming SQL, Java

Language

Databases Oracle 8i/9i,SQL Server 2005

Technical SCJP1.5(Sun Certified Java Programmer)

Certification OCA(Oracle Certified Associate-An Introduction to

SQL)

Professional Experience:

Project: Wellcare Capital Infrastructure Sep 2013-Till Date

Client: Wellcare Tampa, FL

Role: Senior Informatica Administrator(Senior Associate)

Responsibilities:

. Performs Informatica code migrations and monitoring.

. Responsible for creating users, groups in Informatica Administration

console for informatica domain and repository.

. Monitor, Manage, and Coordinate administration of the Informatica

software for a large, complex environment.

. Installing Informatica Power Center 8.x/9.x on windows and applying

patches and hot fixes.

. Performs all Informatica administration functions such as user access

accounts, roles, setting standards perform all Informatica software

upgrades as needed.

. Provides technical guidance and direction for each ETL project design

and development team and ensure documentation is produced using

defined methodologies.

. Responsible for administration, installation, trouble-shooting,

tuning, upgrade, and overall support of Informatica Dev, QA,UAT and

Prod environments.

. Handling of Informatica connectivity, migration, authentication and

security.

. Seeks out best practices to find opportunities for improvements in

develop processes and makes recommendations for implementation.

. Interface and lead discussions with the organization for configuration

of ETL infrastructure.

Project: Informatica BIE May 2012-Sep2013

Client: Microsoft, Redmond

Role: Senior Informatica Administrator Lead

Informatica Business Intelligence Engineering (BIE) group take cares

of Informatica platform architecture across the Microsoft. Project

activities include administration, installation, trouble-shooting,

tuning, upgrade and overall support of Informatica Dev, QA, UAT and

Production environment. Technical guidance and direction for each ETL

project which uses Informatica. Interface and lead discussions with

the organization for configuration of ETL infrastructure. Seeks out

Best practices to find opportunities for improvements in develop

processes and makes recommendations for implementation.

Responsibilities:

. Performs ETL Administration responsibilities for the Business

Intelligence Engineering (BIE) group using Informatica 9.1.0/9.0.1

environment.

. Performs Informatica code migrations and monitoring.

. Performs all Informatica administration functions such as user access

accounts, roles, setting standards perform all Informatica software

upgrades as needed.

. Provides technical guidance and direction for each ETL project design

and development team and ensure documentation is produced using

defined methodologies.

. Responsible for administration, installation, trouble-shooting,

tuning, upgrade, and overall support of Informatica Dev, QA,UAT and

Prod environments.

. Handling of Informatica connectivity, migration, authentication and

security.

. Seeks out best practices to find opportunities for improvements in

develop processes and makes recommendations for implementation.

. Interface and lead discussions with the organization for configuration

of ETL infrastructure.

Environment:Informatica9.0.1/9.1.0,Microsoft SQL Server 2008, SQL Server

Management Studio 2008 R2, Informatica Administration.

Project: Cash Board June2011-April2012

Client: Disney

Role: Senior Informatica Administrator Lead

The Cash Board is intended as a holistic solution to a real and

pressing need for large enterprises to have a more accurate view of

cash and cash forecasts. It provides leaders and managers with an

integrated forecasting solution that is plugged-in with true sources

of data to minimize /eliminate manual manipulation of data. Cash Board

will help organizations to improve forecasts by providing smart

information on the trending and accuracy of metrics and their

variances. This will lead to actionable insights to improve business

performance quickly, through more effective treasury operations and

better risk management.

Responsibilities:

. Informatica software installation/upgrades and hot-fixes.

. Managing the Power Center Domain, Nodes, Service Manager.

. Performing upgrading Informatica Power Center Version 8.x to

Informatica Power Center Version 9.

. Involving in migration of folders/objects in all phases (Dev, UAT, and

PRD) of projects.

. Implemented facts and dimension structure in Cognos TM1.

. Involving in regular Domain and Service maintenance and restoring the

services.

. Working with various business and technical domain experts to design

and document entire system's user and technical requirements and

specifications.

. Proficient in an environment administration, setting up process, user

communication, escalation handling, troubleshooting, user training and

coordination.

. Monitor daily, weekly, monthly Data warehouse load processes and other

DW related processes.

Environment: Informatica Administration, Microsoft SQL Server 2008, SQL

Server Management Studio 2008 R2, Cognos8,CognosTM1,Framework Manager,

Informatica 8.6

Project: Risk Based Performance Management Dec2010-May2011

Client: Avalon

Role: Senior Informatica Administrator

Cognos risk based performance management dashboard Implementation

involves implementing dashborad in cognos enviroment for the risk

analysis,having multiple levels.It involves measuring various type of

risk on the basis of score attached to it.Created facts and dimension

tables and generated reports for different level of risk.

Responsibilities:

. Responsible for creating users, groups in Informatica Administration

console for informatica domain and repository.

. Monitor, Manage, and Coordinate administration of the Informatica

software for a large, complex environment.

. Installing Informatica Power Center 8.x/9.x on windows and applying

patches and hot fixes.

. Performed upgrading Informatica Power Center Version 8.x to

Informatica Power Center Version 9.x.

. Involved in migration of objects in all phases (DEV, UAT, TEST, and

PRD) of projects.

. Creating Folders and manages user and user group access to objects in

the repository.

. Security Management, Server Administration, System Maintenance, and

Schedule Management.

. Ensures proper configuration of the Power Center Domain components.

. Ensures proper application of the licensing files.

. Performed create, backup, restore and DR for Informatica Repositories.

.

. Performed Unit testing and integration testing.

. Coordinate patching and upgrades of infrastructure.

. Migrating code across various environments.

. Trouble Shooting Informatica related issues.

. Performing Informatica Admin Console activities and handling user

privileges at Informatica level.

. Design of ETL process using Informatica.

Environment:Cognos8,Informatica8.6,Framework-Manager,Informatica

Administration,SQL Server Management Studio 2008, SQL Server Management

Studio 2008 R2

Project: Economic Event Calendar Jan2009-Nov2010

Client: Deutsche Bank

Role: Informatica Administrator

The Deutsche Bank Calendar is an economic event data management tool. It

allows users to view forward and backward looking calendars of data

releases and events, it reads Deutsche Bank analyst pre-release, post-

release and event commentary and utilizes a number of bolts on functions to

analyze the implications of the releases and events for the economy and

markets.

Responsibilities:

. Requirement Analysis from Business.

. Migration of ETL objects among various environments.

. Coordination with Informatica global support team to resolve outstanding

issues with Infa8 Installations and Performance issues.

. Involved actively in upgrade/migration process of Informatica PC.

. Developed Informatica Mappings to Load the Data from Flat files to target

tables using various transformations like Lookup, Joiner, Aggregator,

Expression, Router, Filter, Source Qualifier, and Update Strategy.

. Written SQL queries for analysis of master data, catering to adhoc

business requests and Bug Fixing.

. Monthly code migration review and release coordination.

. Steady state operational support of Informatica.

. Analyze and execute performance improvement measures.

. Trouble Shooting Informatica related issues.

. Successfully upgraded from Informatica 8.1.1 to Informatica 9.0.1.

. Environment setup activities for new/existing projects in QA for

System/Integration testing.

. Following QA processes and guidelines.

Environment: Informatica 8.6,IDQ(Informatica Data Quality),Oracle9i

Project: Relative Value Research Quant Oct 2007-Dec2008

Client: Deutsche Bank

Role: Informatica Administrator

The Relative Value Research Quant database is the Research fixed income

pricing and analytics database. Strategic purpose is to provide a

consolidated source of both internal and external end-of-day and Intra-day

pricing & analytics with advanced web presentation and graphing facilities

via the GM/GMR website. Broker pricing captured from various sources ex:

Reuters, Bloomberg, RMS Oscar and Tradegate. It involves maintenance and

enhancements in the existing applications.

Responsibilities:

. Responsible for creating users, groups in Informatica Administration

console for informatica domain and Repository.

. Performing Informatica Admin Console activities and handling user

privileges at Informatica level.

. Installing Informatica Power center 8.x/9.x on Windows and applying

Patches and Hot fixes.

. Scheduling reports via info view, maintaining and supporting schedules.

. Creating Folders and manages user and user group access to objects in the

repository.

. Ensures proper configuration of the Power Center Domain components.

. Experience in Grids, nodes, Repository services and Integration services.

. Performed create, backup and restore ETL applications.

. Involved in Documentation and Reviews, Status Reporting, Knowledge

Management, Recommendations to Process Improvements, and UAT.

. Handled user privileges and environment setup process.

. Effective testing of the developed ETL components and defect fixing.

. Environment setup activities for new/existing projects in QA for

System/Integration testing.

. Following QA processes and guidelines.

Environment: Informatica 8.6,IDQ(Informatica Data Quality),Oracle9i

EDUCATIONAL QUALIFICATIONS:

* Bachelors Degree-: Information Science and Engineering, VTU, India.

TRAININGS and CERTIFICATION:

. Attended ASPIRE leadership and talent development program at Deloitte.

. Attended Contributing to Client Engagement training program at

Deloitte.

. Attended Virtual Tech Days training program conducted by Microsoft.

. United Way Ambassador for the event United Way giving campaign in year

2012 at Deloitte.

. SCJP1.5(Sun Certified Java Programmer)andOCA(Oracle Certified

Associate-An Introduction to SQL).

. 4 months of training program at HCL Technologies on Datawarehousing

and Business Intelligence Tools.

Contact this candidate