Manager Data
Resume:
SUNIL
*********@*****.***
Summary:
. 7+ years of total IT experience in the Business Requirements Analysis,
Application Design, Development, Implementations and Testing of Data
Warehousing and Database business systems for various Retail,
Pharmaceuticals and Manufacturing industries.
. 6+ years of Data Warehousing experience using Informatica Power center
8.1.1/7.1/6.2/5.1, Power Connect, Power Exchange, Warehouse Designer,
Power Analyzer, ETL, Data Mart, OLAP, OLTP, Star Schema, Snowflake Schema
Five years of Data Warehousing experience using Informatica PowerCenter
8.1.1/7.1.4/7.1.3/7.1.2/7.1.1/6.2/6.1/5.1.2, Power Mart, Repository Admin
console, Repository Manager, Designer, Workflow Manager, workflow
Monitor, Data mart, OLAP, OLTP.
. Technical expertise in ETL methodologies, Informatica 6.x/7.x/8.x - Power
Center, Power Mart, Client tools - Mapping Designer, Workflow
Manager/Monitor and Server tools - Informatica Server Manager, Repository
Server Manager, and Power Exchange.
. Expertise in Data Warehousing, Data Migration, Data Modeling, and Data
Cleansing.
. Experience as a Business Objects Data Integrator and which is responsible
for design/development of ETL and batch load data processes.
. Experience in software development life cycle.(SDLC)
. Directly responsible for the Extraction, Transformation & Loading of data
from multiple sources into Data Warehouse.
. Expertise in source to target mapping in Enterprise and Corporate Data
Warehouse environments.
. Expertise in Informatica data quality tool kit.( IDQ)
. Extensive database experience and highly skilled in SQL in Oracle, MS SQL
Server, DB2, Teradata, Sybase, Flat Files, MS Access.
. Skilled in SQL, PL/SQL, SQL*Plus, TOAD, Teradata SQL Assistant.
. Experience in SQL server integration service( SSIS) and SQL server
reporting service( SSRS).
. Skilled in UNIX, Shell programming on UNIX systems using Visual Editor
and in Informatica Sessions.
. Expertise in configuring and manipulating Dimensional Data Modeling, Star
Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables,
Physical and Logical Data Modeling. Extensive knowledge with Dimensional
Data modeling, Star Schema / Snowflakes Schema, Fact and Dimension
tables.
. Advanced knowledge in ETL, DSS and Data warehousing with OLAP technology.
. Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3
methodology for accessing the full history of accounts and transaction
information.
. Extensive experience in implementing CDC using informatica power exchange
8.x/7.x.
. Vast experience in Designing and developing complex mappings from varied
transformation logic like Unconnected and Connected lookups, Source
Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update
Strategy etc.
. Significant Experience in PL/SQL, Procedures/Functions.
. Responsible in Extraction, Transformation and Loading of data from
multiple sources into Data Warehouse.
. Expertise in doing Unit Testing,Performance Tunning, Integration Testing,
System Testing and Data Validation for Developed Informatica Mappings.
. Excellent Analytical, Communication skills, working in a team and ability
to communicate effectively at all levels of the development process.
Technical Skills:
Data Warehousing ETL Informatica Power Center 8.1/7.x/6.x, ETL,
Metadata, (Source Analyzer, Warehouse Designer,
Transformation Developer, Mapplet, Designer,
Mapping Designer, Repository Manager, Workflow
Manager, Workflow Monitor and Informatica Server)
Data Mart, FACT & Dimensions tables, Physical &
logical data modeling.
RDBMS Oracle 10g, MS SQL Server 2008,Sybase ASE.
Database Languages SQL, MSQuery, PL/SQL, SQL*Plus, SQL*Loader.
Programming C, C++.
Languages
Office Package Ms Office-97, 2000,2003 and 2007.
Environment Linux, HP-UX,Windows2000/NT, Windows XP/Vista/7.
Professional Experience:
American Airlines, Texas
April 2009 - Till date
ETL Developer /Business Objects Data Integrator
Project Description: The main objective of the system is loading data into
mart. The idea is to build a Decision Support System for
executives.Involved in ETL (Extraction, Transformation and Loading) and
Business Intelligence processes. Its primary operations include health
insurance products for employer groups and Medicare beneficiaries. This
project mainly deals with the report related to performance of business
associates and dealers in specific regions across time to analyze customer
performance of large data warehouse for Airline division of Several reports
related to customer information management and sales profile management was
created.
Responsibilities:
. Designed and Developed mappings needed for enhancement of project.
. Worked with Informatica Powercenter V8.1/7.1 Mapping Designer, Workflow
Manager, Workflow Monitor and Admin Console.
. Created Informatica Mappings to populate the data into dimension and Fact
tables.
. Exported and Imported mappings between different Informatica folders and
also Repositories.
. Used different transformations like Aggregator, Lookup, Filter,
Expression, Router, Update Strategy and Sequence Generator.
. Informatica Debugger is used to test the mappings and fixed bugs.
. Provided Production Support for IDS DSS and created Unix Shell Scripts to
delete data that is older than 3 years from fact tables.
. Experience in working with Informatica Service and Repository Service.
. Experience with Informatica V8 support in a high availability grid
environment.
. Familiar with Data Warehouse Architecture, design methodologies and Best
practices.
. Experience with server log files, editing UNIX scripts, FTPing files and
checking space on server.
. Scheduled Informatica sessions and workflows using Informatica Scheduler.
. Performance and fine tuning of Informatica mappings.
. Experience in writing DB2 scripts and gave them to DBA's for implementing
in Production database tables.
. Loaded data into datamarts on a daily basis.
. Created new repositories and new folders within the repositories using
Repository Manager.
. Experience with Designer, Workflow Manager, Workflow Monitor and
Repository Manager.
. Involved in System testing and User Acceptance Testing.
. Changed existing Universes to accomplish the changes in business
requirements.
Environment: Informatica 8.x, Oracle 9i, SQL, PL/SQL, TOAD, SQL*Plus,
Sybase,Windows 2000, Business Objects.
Seagate,OK
May 2008 - March 2009
Informatica Developer
Responsibilities:
Analyzed source data and gathered requirements from business users.
. Developed approach paper according to the business rules.
. Designed the functional and technical specifications for migrating the
existing database system to the data mart.
. Involved in the design phase of logical and physical data model using
Erwin.
. Developed technical design specifications to extract the data from the
data mart tables and export them as text files to the downstream system.
. Created shared folders, local and global shortcuts to reuse metadata.
. Worked with various Transformations such as Source Qualifier, Aggregator,
Expression, Lookup, Sequence Generator, Update Strategy In developing
Various mappings to load the data
. Developed UNIX shell scripts as part of the ETL process to compare
control totals, automate the process of loading, pulling and pushing data
from and to different servers.
. Created snapshots for the transactional tables in distributed databases
and also created triggers, procedures and functions for the backend
development.
. Extensively worked on tuning of Informatica mappings and Sessions for
better performance.
. Used server manager to create sessions and to execute jobs.
. Tuned performance of Informatica session for large data files by
increasing block size, data cache size, sequence buffer length and target
based commit interval.
. Worked with the QA team in order to determine the data validation and
performed the data validating at the source and the target database
level.
. Performed Unit Testing and verified the data and performed Error Handling
on sessions in Workflow.
. Involved in extensive Performance tuning by determining bottlenecks at
various points like targets, sources and systems. This led to better
session performance.
. Worked with the QA team in order to determine the data validation and
performed the data validating at the source and the target database
level.
Enviornment:Informatica Power Center 8.x, SSIS, SSRS, Flat Files, Oracle
9i, SQL, PL/SQL, TOAD, SQL*Plus,Sybase, Windows 2000.
Ranbaxy, NJ
March 2006 - April 2008
Informatica Developer/Business Objects Data Integrator
Description:
The project was intended for migrating data from the source system to
company's data warehouse. The data was made available through Teradata and
from other sources while the target being Oracle database.
Responsibilities:-
. Designed Logical and Physical Modeling using Erwin Data Modeler tool.
. Involved in the Development of Informatica mappings and mapplets and also
tuned them for Optimum performance, Dependencies and Batch Design.
. Implementing Extraction process of flat files into target database
. Migrated Mappings from Development to Testing and Testing to Production.
. Used Parameter Files for multiple DB connections for the sources and
defining variable values.
. Developing the documentation and plan for transformation and loading the
Warehouse.
. Analyzing the data from various sources for data quality issues.
. Participated in all facets of the software development cycle including
providing input on requirement specifications, high level design
documents, and user's guides.
. Writing Oracle Stored Procedures, SQL scripts and calling at pre and post
session.
. Created Concurrent Tasks in the work flows using workflow manager monitor
jobs in Workflow Monitor.
. Controlled version documents using PVCS.
. Designing mapping templates to specify high level approach.
. Involved in Unit testing and documentation.
Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, Toad 9.4, Windows NT
Johnson & Johnson, NA July2004 -
Jan2006 Informatica Developer
Johnson & Johnson is maintaining all its data of different vendors and
goods brought from them for its indirect spend in Ariba System. The
data from the Ariba system is cleansed and migrated into the Global
Procurement Data Warehouse which is in the Oracle database using
Informatica 7.1 tool. The GPDW will provide JnJ procurement and
sourcing professionals a platform to identify and develop leveraging
opportunities and sound sourcing strategies. For the reporting purpose
JnJ is using Cognos as a reporting tool.
Responsibilities:
. Installed and configured Power Center 6x Client/Server components on
Windows & UNIX.
. Created reusable metadata by making the Shared Global Repository objects.
. Created, scheduled and monitored batches and sessions using Power Center
- Server Manager.
. Developed mappings and also tuned them for better performance.
. Responsible to tune ETL procedures and Star Schemas to optimize load and
query performance.
. Created and executed sessions & batches using Server Manager to load the
data into the target database.
. Worked on Database Triggers, Stored Procedures, Functions and Database
Constraints.
. Wrote complex stored procedures and triggers and optimized them for
maximum performance. Analysis of Current Informatica, UNIX, Oracle
Environments.
. Interaction with Client On Daily basis and giving the updates on the
current status.
. Unit testing and UAT Testing
. Deploying into production and upgrading the PRD environment.
. Defining the new process for the application
. Setting up the new security rules and regulations for User and Developers
. Designing skeleton mapping/mapplet and giving it to junior developers
. Creating complex mapping, Promoting the code from one environment to
another Env.
. Deploying the code in Production.
. Taking care of PRD issues and release issues
. Giving the Estimates for the Implementation.
. Brining up Informatica on New Schema and on 7.1.2.
. Installing Informatica on the HUFS.
. Installing Nodes on the HUFS location for the
. Modifying the Profile files and Scripts
. Update the Run workflow scripts
Environment: Informatica 6.2, Oracle 8i, MS SQL Server, SQL, PL/SQL,
UNIX, Windows 2000.
iGate, India
June 2002 - Sep 2004
ETL Developer
This Project is basically developed for AIRTEL for building a data mart and
OLAP reports for order management, strategic testing and technical call
center/customer relationship Management. This data mart stores historical
information about Local, Long Distance, Voice Mail, and Pager Services.
This system extracts data from order management system database (OLTP).
Responsibilities:-
. Extracted Data from Different Sources by using Informatica.
. Extensively used Informatica client tools Source Analyzer, Warehouse
designer, Mapping designer, Mapplet Designer, Transformations.
. Cleanse the source data, Standardize the Vendors address, Extract and
Transform data with business rules, and built Mapplets using Informatica
Designer.
. Extracted data from different sources of databases. Created staging area
to cleanse the data and validated the data.
. Designed and developed complex Aggregate, expression, filter, join,
Router, Lookup and Update transformation rules.
. Developed schedules to automate the update processes and Informatica
sessions and batches.
. Analyze, design, construct and implement the ETL jobs using Informatica.
Environment:Power Center 5.1.1,Windows NT, PL/SQL,Excel,SQL Server 7.
Contact this candidate