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.