Data Manager

Vijaya Ulsala

[pic]

*** ********** **, **********, ** 30004

Tel: 972-***-****, Email: ************@*****.***

Objective:

To secure a challenging position in the field of data warehousing that will

utilize my strengths and knowledge.

Summary:

. 9 years of professional experience in information technology using tools

and technologies like Informatica, Pentaho, SSAS, Business Objects,

Teradata, Oracle, DB2, and SQL Server.

. Strong expertise in data analysis, data extraction, data loading,

and performance tuning.

. Experience in Administration activities like Creating and Managing

Repositories, Users, User Groups, Folders, working with administrator

functions and support of Repository Manager.

. Proficient in working in different RDBMS (in Teradata, Oracle 8i/9i, SQL

Server, DB2 etc.) and strong troubleshooting skills.

. Strong Experience in Data Warehouse requirements gathering, analysis,

design, conversion of business requirements into high level functional

specifications, Data Loading, and Business Intelligence Processes. Worked

with Data Loads and Data Migration using Oracle SQL Loader, and Teradata

Loaders.

. Good working knowledge of Teradata utilities like BTEQ, FastExport,

FastLoad, MultiLoad and Tpump.

. Expertise in implementing complex Business rules by creating robust

mappings/mapplets, shortcuts, reusable transformations and partitioning.

. Good experience designing and developing business intelligence

applications by creation of business objects universes using the business

objects designer

. Extensive expertise in implementing complex business requirements by

creating re-usable transformations and mappings/mapplets.

. Extensively used SQL and PL/SQL to write stored procedures,

functions, and triggers.

. Experience in the Implementation of full lifecycle in Data warehouses and

Business Data marts with Star Schemas and Snow flake Schemas, Data

Migration, Data Conversions, Data Extraction, Transformation and Data

Loading (ETL) and product support on various platforms.

. Excellent interpersonal and communication skills, and is experienced in

working with senior level managers and developers across multiple

disciplines.

Certifications:

. Brainbench certified Informatica Developer.

. Teradata Certified Professional V2R5

Technical Skills:

ETL Tools : Informatica powermart/powercenter 8.1/7.1.2/6.2,

Pentaho 3.2/3.4, SSIS

Reporting Tools : Business objects 5.1, Cognos 5.1

OLAP Tools : SSAS

Languages : C, C++, SQL, PL/SQL

Scripting : UNIX shell scripting

Web Skills : HTML, XML

Operating Systems : UNIX (AIX, Solaris), Linux, Windows 95/98/NT/2000/XP

Modeling : Erwin 3.5.2/4.0

RDBMS : Teradata V2R5.1, Oracle 9i/8i, DB2, SQL Server

2008/2005/2000, MS Access 2000

Work Experience:

Sr ETL Developer, SNL (formerly iPartners), Atlanta, GA

Nov 2010 - Current

As a leading provider of on-demand P&C insurance business analytics

solutions, iPartners enables insurance executives to make higher quality

and more timely decisions by delivering accurate, easy-to-use and relevant

data through a suite of customized dashboards, scorecards, and a library of

P&C specific key performance indicators.

iPartners solution gathers client requirements, and applies business rules

using ETL tools to load client's data which is later loaded into

datawarehouse. Cubes are built using SSAS, which feeds data to the reports.

Environment: Informatica Powercenter 8.1, SQL Server 2008, Oracle 11g,

SSIS, SSAS and Windows 2000.

Role:

Created database, designed staging tables and master tables to load

client's data.

Understanding business requirements and converted into technical designs.

Mentored junior developers.

Used Informatica to merge client's data from multiple sources into

datawarehouse.

Involved in Designing and developing Star Schema and creating Fact Tables

and Dimension Tables for the Warehouse, and also built cubes using SSAS.

Worked on identifying mapping bottlenecks in Source, Target, and Mappings

and improved performance.

Interacted with Reporting team to provide data required for creating

dashboards.

Created indexes for improving performance of queries.

Developed stored procedures and functions.

Worked on troubleshooting and tuning SQL queries for better performance.

Created slowly changing dimension tables and fact tables.

Used Workflow manager to create, schedule, monitor, and send the messages

in case of process failures.

Sr ETL Developer, Incomm, Atlanta, GA

Apr '09 - Oct 2010

InComm is the industry leading marketer, distributor and technology

innovator of stored-value gift and prepaid products.

InVision Back Office

IBO is the application used by Incomm to manage its merchants, vendors,

products, pricing and billing. This platform will eliminate disparate

legacy systems by unifying the sales, customer support, transaction

processing, rating, billing, product development, and ERP systems into an

enterprise-wide platform. Pentaho is used to load data from legacy system

to the new application.

Environment: Pentaho 3.2/3.4, SQL Server 2008/2005, DB2, Oracle 10g, Mysql,

Linux, and Windows 2000.

Role:

. Developed complex ETL workflows for data movement from and to SQL server

databases, Data Warehouse, XML and flat files using Pentaho.

. Worked closely with business users to gather the business requirements to

develop the transformation logic.

. Provided on-call production support.

. Migrated ETL mappings from Development to Test and Production

environments.

. Worked on identifying mapping bottlenecks in Source, Target, and Mappings

and improved performance.

. Designed and developed shell scripts to automate the process of loading,

pulling, renaming and pushing data from and to different servers.

. Involved in analyzing stored procedures on legacy systems and converted

them to ETL mappings.

. Conducted Unit, Acceptance, and Regression testing for initial/daily

master data & data warehouse ETL load.

. Designed exception process for the ETL processes that load legacy data

into the new master data.

. Participated in designing Data warehouse and worked on ETL logic to load

Data warehouse.

. Developed Mappings using various transformations like Lookups, Filters,

Aggregators, Joiners, and SQL based upon requirement.

Sr ETL Developer, ING Insurance, Atlanta, GA

Jun '06 - Mar '09

ING's businesses offer individual, business and institutional customers

innovative financial products and services in insurance, investment, asset

management, and internet banking.

AdminSever

AdminServer is a web-based policy-administrative system that supports Life

New Business and Policy services. The AdminServer Implementation Program

will implement the new AdminServer administrative system, new term products

on the platform, and convert selected legacy systems to the new platform.

Informatica was used to load the data from DB2 to DB2 and flat files.

Environment: Informatica Power center 8.1/7.1.2, DB2, UNIX, and Windows

2000.

Role:

. Designed and developed the Extraction, Transform and Load process by

studying the business requirement from the users.

. Analyzed clients ETL needs, Identified distinct functional areas.

Interacted with end users and documented their queries for business

analysis and reporting needs.

. Wrote override sequel queries, documented the Informatica mappings,

design and error handling and test strategy of the mappings.

. Designed and developed mappings and reusable objects using

Informatica.

. Developed Mappings using various transformations like

connected/unconnected Lookups, Filters, Aggregators, Update strategy,

Routers, Joiners, Union, and SQL depending upon requirement.

. Scheduled and monitored sessions and batches on the Informatica Server

using Informatica Workflow Manager and ControlM.

. Developed Informatica sessions for data processing and loading, scheduled

sessions using Informatica Work flow Manager.

. Wrote SQL, PL/SQL, stored procedures cursors for implementing business

rules and transformations.

. Designed mappings between flat file, using Informatica and RDBMS source

to data warehouse which is in db2.

. Created join indexes, materialized views, dimensions for increasing query

performance

. Developed shell scripts and stored procedures to run from the Informatica

pre and post sessions to create and drop the indexes to improve the speed

of session execution.

. Involved in tuning Informatica mappings and workflows for better

performance.

ETL Developer, Cendant (Galileo - Orbitz), Denver, CO

Aug '05 - May'06

MIDT Repository

This project provides competitive MIDT booking information to Galileo

Subscriber departments. Creation of the Knowledge Management repository

includes taking the output files from Shepard, applying the business rules

where applicable, and loading this data into the Knowledge Management

Repository.

Environment: Informatica Power center 7.1.2, Cognos 5.1, Teradata V2R5.1,

Oracle 9i, UNIX, Informix, DB2, and Windows 2000.

Role:

. Used teradata loaders like Tpump, Mload and fast load to load data from

Informix, teradata into teradata.

. Developed several reusable transformations and mapplets.

. Analyzed clients Data Warehousing needs, Identified distinct functional

areas. Interacted with end users and documented their queries for business

analysis and reporting needs.

. Worked with large volumes of data.

. Extensively worked on performance tuning of Teradata SQL using explain

plan and understanding Joins and Data distribution.

. Involved in migrating data from Informix to teradata.

. Created slowly changing dimension tables for loading the history data.

. Developed mappings with transformations like joiner, update strategy and

lookup (Connected& Unconnected, Flat file lookups) to mould the data in

required form.

. Created List, Sub and Cross-Tab reports using Impromptu and distributed

Catalog to users for Ad-Hoc reporting and analysis using Cognos.

. Developed Korn shell scripts to load data from various source systems to

Teradata warehouse using MultiLoad and BTEQ utilities on UNIX Platform.

. Involved in tuning mappings and workflows for better performance.

. Done debugging using debugger.

. Troubleshoot and tune SQL using explain plan.

ETL Developer, Neiman Marcus, Irving, TX

Jan '05 - Jul '05

The main aim of this project was to support the exposure of Neiman's online

catalog to search engines like Google, Yahoo, MSN, and AOL. Informatica was

used to load the data from oracle database to oracle and flat files. This

warehouse also helps marketing and sales teams in promotional campaigns and

generating sales reports.

Environment: Informatica Power Center 6.2, Business objects 5.1, Oracle 9i,

TOAD, UNIX, PL/SQL, Windows 2000.

Role:

. Involved in the development of Informatica mappings and Mapplets.

. Extensively used parameter files.

. Worked with transformations like Source qualifier, Aggregator,

Expression, Lookups, Filter, Router, Sequence Generator, Update strategy,

Rank Etc.

. Performed tuning SQL queries for speedy extraction of data.

. Wrote UNIX Shell Scripts to process text files.

. Business Objects Universe, Business Objects Reports and Business Objects

repository has been extensively used.

. Created sessions, batches and unit testing of the mapping/sessions and

batches.

. Interacted with the end users to gather the business requirements.

. New universe were designed and developed to support the user Requirements

using Business Objects.

. Used partitions like key range to improve the performance.

. Enhanced the existing Informatica mappings to meet the new requirements.

. Wrote pre session and post session commands for processing shell scripts.

Education:

Bachelor's in Engineering[pic]

Contact this candidate