Manager Data

Venkata hanumath teja kakollu

Cell: +1-913-***-****

Email: *******.***@*****.***

SUMMARY:

* ***** ** ****** ********** with ETL design and development using Informatica ETL tool. Have been involved in analysis and design of complex datamart schemas, migration strategies and interfaces for Data Warehouses using Informatica ETL tool

Experience in Data Warehouse using Informatica Power Center v 9.1/8.6/8.5 (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Transformation Designer, Warehouse Designer, Star & Snowflake Schemas, using ETL tool Informatica on Oracle Databases etc)

Heavily involved in complete life cycle of enterprise data warehouse

Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques, pushdown optimization and also identifying performance bottlenecks

Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema)

Experience in multiple domains like Banking, Insurance and Telecom

Worked with connected, unconnected lookups and reusable transformations and mapplets

Involved in unit testing of the mapping and SQL code

Experience in integration of various data sources like Oracle, SQL server and non-relational sources like flat files, CSV and XML into staging area

Expertise in handling multiple projects simultaneously and design / development of client-server and multi-tier applications and Decision Support systems and solutions

Experienced in UNIX work environment, file transfers and error handling

Experience in Job scheduling tools like Control-M, Autosys

An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities

Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation, Resource Planning, Project Tracking, UAT

EDUCATION

Master of Science from University of Missouri Kansas-City Jan 2016-May 2017

TECHNICAL SKILLS:

ETL Tool

Informatica PowerCenter 9.5.1/8.6

Data Modeling

Star Schema Modelling and Snow Flake Modelling

Databases

Oracle 11g,10g/9i,SQL Server 2008

Languages

SQL, PL/SQL, Unix Shell Script, XML,HTML

Scheduling Tools

Auto sys, Control M

Operating Systems

Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

Horizon-BlueCross & Blue Shield Feb 2017 – Till Date

New Jersey.

Horizon is the nation's leading health benefits company serving the needs of approximately 3.2 million medical members nationwide. It is offering a broad range of medical and specialty products. Horizon is a Blue Cross or Blue Cross Blue Shield licensee in throughout all of North, Central and South Jersey.

Project:

Medicare, Capsule and Recon: Blue Cross enterprise data warehouse deals with different kinds of health claims which are categorized as Facility, Professional, FEP. Data is coming from various sources like Oracle, SQL Server, Mainframe etc which will be loaded based on different frequencies as per the requirement. The entire ETL process consists of source systems, staging area, ODS layer, Data warehouse and Data mart.

Responsibilities:

Extensively used Informatica Client tools – Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager

Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files

Responsible for developing for the ETL (Extract, Transform and Load) processes using Informatica Power Center

Developed Informatica mappings using transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations the business logic after replacing the new ERP

Redesigned some of the existing mappings in the system to meet new functionality

Worked on Performance Tuning at Database and Informatica side like Source, Target, Mapping, Transformation and Session to make them more efficient in terms of session performance

Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers

Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process

Daily Data load Monitoring: These Workflows were then scheduled to run at specific time intervals on the Client Production Repository and monitored regularly in Workflow Monitor

Supporting the issues raised by the Front end Development teams and Testing teams

Involved in regular project status meetings related to Development

Coordination of onsite and offshore activities

Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager

Used Control- M Scheduling tool to schedule the jobs as per the requirement

Involved in writing Unit test cases for complex scenarios

Experience in creating UNIX shell scripts and Perl scripts

Knowledge in design and development of Business Intelligence reports using BI tools Business Objects and knowledge in microstrategy

Client interaction with respect to delivery and deployment

Environment: Informatica Power Center 9.0.1, Oracle 10g, Oracle, UNIX.

Frontier Communications July2014-Dec 2015

Dallas, TX

Frontier Communications is one of the nation's largest independent telecommunications providers offering local, long distance, and Internet access services and supporting more than 2 million access lines.

Responsibilities:

Worked with business analysts in gathering the requirement and kept huge efforts to get the precise information as we are working with provider data.

Extensively involved in analyzing the huge data in the data ware house to understand the amount of duplicates, distinct values in order to determine the key column.

Developed mappings/sessions using Informatica Power Center 9.1/8.6.1 / Power exchange 8.5.1 for data loadings

Responsible for managing informatica services like PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier

Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation

Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes

Worked in all the phases of the Data Warehouse project life cycle involving design, development and Implementation of Data warehouses using ETL, Online Analytical Processing & reporting tools(BO)

Good Understanding of Logical and Physical Data Modeling, Dimensional Data Modeling, Star Schema/Snow Flake Schema

Involved in data quality profiling, standardization and testing

Created reusable transformations and Mapplet and used with various mappings.

Checking whether data Imported from source tables transformed and loaded into Data Warehouse Targets using SAS

Assisted the other ETL Developers in resolving complex scenarios

Implemented various functionality such as Drill down, Drill up, Alerts etc.

Designed and created an Autosys job plan to schedule our processes

Shown commitment and enthusiasm to achieve the dead lines by effective time management

Environment: Informatica Power Center 9.1/8.6, Oracle 10g, Oracle, UNIX.

Client: American Telephone and Telegraph May 2011- June 2014

Project Location Chennai, India

Project: Broad Band Operations Business Intelligence (BOBI) and Retail Data Warehousing (RDW)

Project Description:

BOBI is the Broad Band Operations Business Intelligence data ware housing system of AT&T Southeast region. The data from the different source systems are sent to BOBI in form of flat files or in some cases staging tables. Those data will be loaded into Oracle.

RDW is the Retail data ware housing system of AT&T Southeast region. The data from the different source systems are sent to BOBI in form of flat files or in some cases staging tables. That data will also be loaded into Oracle.

Responsibilities:

Created complex mappings using various Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Transaction control, Sorter etc. as per the business requirements

Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer

Used Variables and Parameters in the mappings to pass the values between mappings and sessions

Extensively used the capabilities of Power Center such as File List, Target Load Order, Constraint Based Loading, Concurrent Lookup Caches etc

Used Unix Shell Scripts to automate pre-session and post-session processes

Mainly involved in ETL development and testing

Did performance tuning to improve Data Extraction, Data process and Load time

Participated in the design of Star schema data model

Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements

Involved in Performance Tuning of mappings in Informatica

Perform unit testing at various levels of the ETL

Extensively used AutoSys for scheduling the Informatica Workflows using UNIX Shell Scripting

Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process

Involved in Migration process from development, Test and Production Environments

Provided Weekly status report to manager on the process and timeliness

Developed reports and data to assist in evaluation in business performance and operation

Environment: Informatica IDQ, Informatica Power Center, Oracle

Contact this candidate