Manager Data
Resume:
SHESHANK
****************@*****.**.**
. Around 5+ years of experience in IT, with in depth knowledge in
Database/data warehouse design, modeling, development, ETL processing
and reporting of data warehouse and client Server Application.
. 4 years of experience in Dimensional Data Modeling using Data
modeling, Star Schema/Snowflake modeling, Fact & Dimensions tables,
Physical & logical data modeling and hands on experience in Star and
Snowflake schema design in relational, dimensional and
multidimensional modeling and De-normalization techniques.
. Involved in Full Life Cycle Development of building a Enterprise Data
Warehouse.
. Strong skills in using ETL tools like Informatica Power Center
8.x/7.x/6.x /5.x.
. Experience in performance tuning of Informatica Sources, Targets,
Mappings and Sessions.
. Extensively worked on Informatica Power Center Transformations such as
SourceQualifier,Lookup,Filter,Expression,Router,Joiner,UpdateStrategy,R
ank,Aggregator, Stored Procedure, Sorter, Sequence Generator, and XML
Source Qualifier.
. Extensive experience in error handling and problem fixing in
Informatica.
. Designed complex Mappings and expertise in Performance tuning.
. Excellent Interpersonal and Communication skills, coupled with strong
technical and problem solving capabilities.
EDUCATION:
Jawaharlal Nehru Technological University, India (GPA 3.7) May
2004
Bachelors of Technology in Computer Science Engineering.
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center5.1/6.0/6.2/7.1/7.1.2/7.1.3/
8.1.1/8.6.1
OLAP/DSS Tools: Business Objects 5i
Databases: Oracle,SQL Server,Teradata,DB2,Access.
Database Modeling: Erwin.
OS: UNIX,Windows 97/98/2000/NT/XP.
Languages: C, C++, SQL, PL / SQL, UNIX Shell Scripting.
Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word).
PROFESSIONAL EXPERIENCE:
Bank Of America Mar
2009 to Jun 2010
Migrating customer information from one database to another database.The
data warehouse represents the balances and transaction data information
extracted and integrated from various source systems. The objective of Data
Warehouse is to represent a financial reporting infrastructure that
centralizes access to information, data, applications, reporting and
analytical systems for the required content dealing with different
programs.
Responsibilities:
. Responsible to implement database solutions using available database
development tools like Informatica Powercenter.
. Responsible for developing complex Informatica mappings using
different types of transformations like UNION transformation,
Connected and Unconnected LOOKUP transformations, Router, Filter,
Aggregator, Expression and Update strategy transformations for Large
volumes of Data.
. Responsible for creating Workflows and sessions
using Informatica workflow manager and monitor the workflow run and
statistic properties on Informatica Workflow Monitor.
. Used various Transformations such as Multiple Lookups, Filter,
Expression, Source qualifier, Updated Strategy, Router, Joiner,
Aggregator, Sequence Generator, Union, XML parser
transformation,Stored Procedure and Customer Transformation.
. Involved in performance tuning of mappings and sessions.
. Used to schedule the workflow using Control-M.
. Involved in migrating repositories from one environment to another
environment.
. Worked extensively on SQL, PL/SQL using Toad.
. Worked on removing bottlenecks for the optimum usage of sources,
transformations and targets.
Environment: Informatica power center 8.6.1,oracle 10g,PL/SQL,UNIX,Windows
XP.
Symantec Corporation India Oct
2006 to Mar 2008
ETL developer
The Quick Arrow Data Warehouse & Reporting project will consolidate data
from required data sources and provide timely availability of reliable data
in a data warehouse and reporting environment that is easy to use and
provides the ability to generate standard and ad-hoc reports.
Responsibilities:
. Analyzed user requirements and developed Business rules associated with
the ETL processes.
. Understanding the Functional Requirement.
. Created mappings for Dimension Tables using SCD Type 2.
. Designed and developed complex mappings by using Lookup, mapplets,
Stored procedures, Router transformation rules to generate
consolidated data identified by dimensions using Informatica ETL tool.
. Monitoring the loads for a check on data load into the target tables.
. Design and implementation of Test plan and Test Approach.
. validating the source data with target data for finding the
mismatches.
. Created sql Scripts to Execute on the Oracle Database.
Environment :Informatica Power Center 7.1.3, Work Flow Manager, WorkFlow
Monitor,Oracle 9i, Windows XP.
PriMed, INDIA Jan 2004 to Jul
2006
Hill Physician Medical Group ETL
Developer
Hill Physician Medical group is the leading provider of real time
surveillance healthcare information and market research to their global
Primary Care Physicians(PCP) of a medical group and healthcare companies.
It provides syndicated research intelligence data, which tracks and
predicts illness and product sales for pharmaceutical and healthcare
companies, marketing & sales analysts, Data was available in the form of
Text files, Oracle and MS Access. It was extracted and loaded using
Informatica tool. The Data Warehouse is populated on daily basis using ETL
Methods (Extraction, Transformation & Loading Methods) this ETL job was run
on daily basis to fed data to Data Warehouse.
Responsibilities:
. Data extracted from different databases like SQL Server and Oracle
using ETL tool.
. Developed mapplets/Lookup/Stored procedure transformations.
. Created daily, weekly, monthly and quarterly reports for the
management team.
. Developed data Mappings between source systems and warehouse
components.
. Involved in migrating repositories from one environment to another
environment.
. Responsible for creating Workflows and sessions
using Informatica workflow manager and monitor the workflow run and
statistic properties on Informatica Workflow Monitor.
Environment : Informatica Power Center 5.1,Oracle 8i, PL/SQL, Unix, Windows
XP.
Contact this candidate