DINESH KUMAR
Sr. ETL Developer/Program Analyst
abm70k@r.postjobfree.com
SUMMARY
. Over 5 years of IT experience as an ETL Developer/Program analyst,
which includes Data Warehouse/Database Developer experience using
Informatica Power Center 8.x/7.x as ETL tool.
. Hands on experience in Optimizing Database querying, data manipulation
and population using SQL and PL/SQL in Oracle, Teradata, DB2 UDB and
SQL Server databases.
. Hands on experience with Informatica Administration and various
upgrades.
. Experienced in Installation, Configuration, and Administration of
Informatica Power Center Client.
. Experience in Data Warehouse/Data Mart Development Life Cycle using
Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, ROLAP, MOLAP,
Fact and Dimension tables.
. Good understanding of development lifecycle of projects with
Informatica, Oracle and Teradata.
. Experience writing and modifying ETL design documentation, test
results documentation and standard operating procedures (SOP)
documentation.
. Proven experience with writing and technical requirements analysis.
. Worked with Teradata loading utilities like Multi Load, Fast Load,
TPump and BTEQ.
. Experience in developing Shell scripts on UNIX and experience with
UNIX command line.
. Knowledge of Software Testing and Quality Assurance.
. Excellent communication and writing skills and capable of working
successfully both in teams and independently.
. Ability to self-manage time and task priorities to meet project
timelines, and identify potential project risks.
COMPUTER SKILLS
ETL TECHNOLOGY Informatica Power Center 8.6/8.1/7.x/6.x
DATA WAREHOUSE Multidimensional Model Design, Star Schema Development
DATA MODELLING Star-Schema Modeling, Snowflake Modeling, MS Visio,
Erwin
DATABASES Oracle 10g/9i, MS SQL Server7.0/2000, MS Access,
Sybase, DB2,MySQL,Teradata V2R6
PROGRAMMING C, C++, SQL, PL/SQL, HTML,UNIX Scripting
REPORTING TOOLS Business Objects XIR2,Crystal Report
OPERATING SYSTEMS Windows 98/NT/2000/XP,MAC, Sun Solaris, UNIX, MS-DOS
APPLICATIONS MS Office, MS Project, FrontPage, Toad 9.2/8.6
MANAGEMENT TOOLS MS-Office 2007, MS Project
PROFESSIONAL EXPERIENCE
Client: Wells Fargo Advisors
Sep'09 - Current
St. Louis, MO
Consultant Sr. ETL Developer/Support Analyst
Description: The ODS (operational data store) involved consolidating the
data from various data sources
Involving Household, Accounts, Security, Positions, Balances and HR related
information. This data come from different sources which included databases
such as Oracle, MS SQL Server, flat files and BDW. The Project mainly
involved working with data quality, data analysis and production support of
the ODS system.
Responsibilities:
. Provided 24X7 on call support which included monitoring morning and
nightly jobs and emergency production fixes.
. Coordinated the Change Management process which involved driving
the QA and production deployments.
. Involved in Information administration including creating new users
and groups, backing up the repository and domain as well as
handling various upgrades.
. Working on new projects to fulfill the business needs.
. Documented the scope of new development projects.
. Involved in writing and modifying UNIX shell scripts.
. Worked with data quality team to fix the production data issues and
also provide solutions to the business users.
. Involved in providing the solutions for production support job
failures at Tier-2 level.
. Coordinated with offshore team to support the existing ODS system
jobs.
. Coordinated with business users and across the development teams in
implementing new business requests.
. Used Toad for data quality verification and unit testing the data.
Environment: Informatica Power Center 8.6, Oracle 10g, DB2 UDB, UNIX (Sun-
Solaris), UNIX (AIX 6.2), Harvest, SQL Loader, Autosys, Visio, Synsort,
TOAD for Oracle, SQL Developer, Windows XP.
Client: Media Bank Inc.
Apr'09-Sep'09
Consultant Data Analyst
Chicago, IL
Description: Media Bank presents the evolution of media buying -integrated,
open, cross-platform technology that maximizes intelligence and efficiency
in the media buying process. It is powering the future of media buying. The
project is based on testing and analyzing the digital and analog
applications for media related clients.
Responsibilities:
. Used SQL developer to run the queries to verify the data with the
existing GUI functionality.
. Involved in creation of test plan and test cases for testing the
enhanced functionality of MBOX.
. Involved in documentation to describe program development, logic,
coding, testing, and any changes and corrections.
. Developed ETL code by the business logic defined in the Functional
Design Document.
. Analyzed the systems, met with end users and business units in
order to define the requirements.
. Conducted business requirements and source system analysis to
arrive at optimal ETL designs.
. Develops new ETL applications from simple to moderately complex
scope, works with basic applications systems design specifications;
and utilizes Company standards, procedures, and techniques.
. Partnering with project managers and development resources to
assist with design changes and design decisions.
. Worked with creation of reports for decision support.
. Involved in analysis of the data in the development and test
environment.
. Work with analog team to test the existing application.
. Involved in logging defects in JIRA and monitor the progress until
it goes to UAT environment.
Environment: MBOX (digital and analog), Oracle 10g, SQL developer, UNIX,
Windows XP, JIRA
Client: PepsiCo
May'08-Feb'09
Chicago, IL
Role: Consultant Program Analyst/ETL Developer
Description: The QTG Sales Reporting project involved
leveraging SAP Business Warehouse (BW) to report on Actual, Plan and
Forecasted sales data. The company's data come from SAP BW in the flat file
and is then loaded into the Operational Data Warehouse built on Teradata
using Informatica. Various Business Rules and Business Processes were
applied to Extract, Transform and Load the data into the Data Warehouse.
Responsibilities:
. Involved in the documentation/Design of Technical Design Document
of various interfaces like Sales organization, Field AOP, and Field
Forecast.
. Used Teradata, SQL assistant for running the SQL Queries to check
the data loaded to the Target Tables.
. Designed and developed mappings, mapplets and sessions from source
to target database using Informatica Power Center.
. Used simple to moderately complex debugging techniques to test ETL
applications.
. Developed Test Cases for testing the ETL mappings.
. Conducted code reviews and lead design reviews to assure
compliance.
. Involved in migration of ETL/Bteq code from Development environment
to QA environment and finally to Production environment.
. Followed Informatica development standards and enforce best
practices.
. Performed QA work to verify the results provided from other teams.
. Worked with various file formats like fixed length and delimited.
. Involved in creation of BTEQ Script for validating the data quality
like referential integrity, not null check.
. Maintained the proper communication between other teams.
. Utilizing the existing UNIX shell scripts to run the informatica
workflow through process control.
. Scheduled sessions and batch process based on demand, run on time,
run only once using Informatica Workflow Manager.
. Identified BI reporting problems, and suggests practical
resolutions.
. Participates in *on-call* support for ODS and the data warehouse.
. Involved in documentation to describe program development, logic,
coding, testing, and any changes and corrections.
Environment: Informatica Power Center 8.1, Teradata V2 R6, SQL, Windows XP,
SQL Assistant, UNIX Shell Script.
Client: Spectrum Health Care
Jan'07-Apr'08
Grand rapids, MI
Role: Informatica Developer
Description: The project was to design, develop and maintain different Data
Marts which included General Ledger, Bar Code Med Admin and Chart access.
The data used to come from oracle database and in form of flat files and
was loaded into the target using Informatica.
Responsibilities:
. Involved in creation of Logical Data Model for ETL mapping and the
process flow diagrams.
. Worked with SQL developer to write the SQL code for data
manipulation.
. Worked on Informatica versioned repository with check in and
checkout objects feature.
. Used Debugger extensively to validate the mappings and gain
troubleshooting information about data and error conditions.
. Provided guidance to less experienced personnel. Conducted quality
assurance activities such as peer reviews.
. Participate in the business analysis process and the development of
ETL requirements specifications.
. Worked with production support systems that required immediate
support
. Develop, execute and maintain appropriate ETL development best
practices and procedures.
. Assisted in the development of test plans for assigned projects.
. Monitor and tune ETL processes for performance improvements;
identify, research, and resolve data warehouse load issues.
. Involved in unit testing of the mapping and SQL code.
. Developed mappings to load data in slowly changing dimensions.
. Involved in performance tuning of source & target, mappings,
sessions and workflows.
. Worked with connected, unconnected lookups and reusable
transformations and mapplets.
. Utilized Unix Shell Scripts for adding the header to the flat file
targets.
. Involved in designing the star schema and populating the fact table
and associated dimension tables.
Environment: Oracle 10g, SQL Developer, SQL, Informatica Power Center
7.1.3,Sybase, Windows XP, Visio 2000, Business objects XIR2
Dr. Reddy's, India
Jul'03- Aug'05 Database
Developer/ETL Developer
Description: Dr. Reddy's is a global, vertically integrated pharmaceutical
company with a presence across the value chain and active pharmaceutical
ingredients and biological products The project involved computerizing
Payroll Activities and production control activities of Dr.Reddy's. It is
capable of generating monthly income statements of all employees. It is
maintaining the database of entire industry staff and generating reports
over each issue.
Responsibilities:
. As a team member involved in collecting all the requirements for
building the database.
. Involved in Creation and designed required tables, indexes and
constraints for all production activities.
. Played a key role in designing the application and migrate the
existing data from relational sources to corporate warehouse
effectively by using Informatica Power center.
. Responsible for Extracting, Transforming and Loading data from
Oracle, Flat files and placing them into targets.
. Developed various mappings using Mapping Designer and worked with
Source qualifier, aggregator, connected unconnected lookups, Filter
transformation, and sequence generator transformations.
. Involved in Data Modeling and design of Data Warehouse and Data
Marts in Star Schema methodology with conformed and granular
dimensions and fact tables.
. Used SQL, PL/SQL for database related functionality.
Environment: Informatica Power Center 6.1, Oracle 8.0, SQL Server (7.0),
SQL, Sybase, PL/SQL, Erwin, UNIX, Windows XP, C.
EDUCATION
MS Electrical Engineering
Dec'06
New Jersey Institute of Technology, NJ
GPA 3.5
BE Electronics and Communication-
June 05
Maharishi Dayanand University, India
GPA 3.9
CERTIFICATIONS
Teradata certified professional V2R5
Brain bench Certified for Data Warehousing Concepts.
Brain bench Certified for RDBMS Concepts.
[pic]