Manager Data
Resume:
NAVEEN KUNKULAGUNTA
*********.**@*****.***
EXPERIENCE SUMMARY
Enthusiastic and highly skilled with over 6 years of software development
experience in the field of Data Warehousing using the Informatica ETL tool.
Experience applying business intellegence management techniques to
reeingineer business processes, possessing superior analytical skills and
the ability to meet deadlines. Enjoy sharing technical expertise and
coordinating projects with team members. Professional skills and
competencies include the following:
. Knowledge of working in all phases of the Data Warehouse Development
Life Cycle.
. Strong understanding of business intelligence techniques and has
experience of working in BI production support.
. Strong understanding of logical and physical database designs and also
dimensional modeling schemas like Star and Snowflake schema.
. Development strategies for Extraction, Transformation and Loading
(ETL) of data from various sources into Data Marts and Data Warehouses
using Informatica Power Center (Repository Manager, Designer, Workflow
Manager and Workflow Monitor).
. Strong experience in designing and developing complex mappings to
extract data from diverse sources including flat files, RDBMS tables,
legacy system files, XML files, Applications Sources and Teradata.
. Worked with Business Objects Data integrator creating numerous Jobs,
Work Flows and Data Flows.
. Worked with various transforms in Business Objects Data integrator.
. Experienced in Performance Tuning of Source, Targets, Mappings,
Sessions and Transformations.
. Experience in writing Database Objects like Packages, Stored
Procedures, Functions and Triggers.
. Designed and developed various tools involving Extraction
Transformation Loading (ETL), ROLAP and MOLAP concepts.
. Proficient in all the phases of the Software development lifecycle,
including requirements Definition, Analysis, Design, System
Implementation, Performance Tuning, Testing and Production Support.
. Strong Unit and Integration testing skills.
. Active team player with excellent communication, organization and
Interpersonal skills, self motivated and quick learner. Experience in
UNIX Shell Scripting.
. Ability to work independently as well as in a team, fun-filled and
challenging environment.
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 8.6/8.5.1/8.1.1/7.1/6.2/5.1
(Repository Manager, Mapping Designer, Workflow
Manager)
OLAP Tools: Data Analyzer 8.5, PowerAnalyzer 5.1, Business Objects 6.5/6.0,
XI R2, Cognos 7.2/6.0.
Databases: Oracle 10x/9x, DB2, SQL Server, Teradata, Sybase.
DB Analysis Tools: TOAD 7.6, SQL*Plus, ODBC
Data Modeling Tools: Erwin 4.5/4.0/3.5.2.
Revision Control Tools: IBM Rational ClearCase, VSS.
Languages: SQL, PL/SQL, C, UNIX Shell Scripting.
Web Technologies: HTML, XML,PERL
Operating Systems: Windows Vista, 2000, XP, NT, 98, 95, LINUX and
UNIX
EDUCATIONAL QUALIFICATIONS:
Bachelor of Technology in Computer Science, JNTU, India.
PROFESSIONAL WORK EXPERIENCE:
1. BCBSM, Detroit, MI
DW Informatica Developer
Jan 2010- Till Date
Blue Cross Blue Shield is a Health care insurance company, which deals with
consumer and business data with world-class creative and proven techniques
to maximize marketing success for clients. This Project was aimed at
building both Data warehouse and Data marts for BCBSM Clients. The Data
warehouse is on Oracle database. Data warehouse will be loaded into
different individual data marts which will be used in report generation by
business users. Involved with BI team to support better business decision-
making.
Responsibilities:
. Interacted with source system owners to get a strong understanding of
how each source system works.
. Involved in transforming the Functional Specification, Business
requirement document and Business metrics into High level designs,
Test Case documents. Maintained warehouse metadata, naming standards
and warehouse standards for future application development.
. Extensively Used Informatica Power Exchange to load data from OLTP
Source systems and databases Oracle, Tara Data, VSAM and Sequential
files.
. Experience in developing applications with oracle RDBMS, SQL, PL/SQL,
Informatica and Hyperion business intelligence tools.
. Used Informatica Client Tools Source Analyzer, Warehouse designer,
Mapping designer, Mapplet Designer, Transformation Developer,
Informatica Repository Manager and Workflow Manager.
. Extensively worked on transformations like Filter, Aggregator,
Expression, Router, connected and unconnected Lookup, Update Strategy,
Rank, SQL, XML and Joiner.
. Mapplets and Reusable transformations were extensively used wherever
required.
. Identified Process Bottlenecks and optimized the code in different
areas for better performance involving various performance tuning
techniques.
. Involved in performance tuning for efficient loading of data from
various sources.
. Extensively used Informatica debugger to validate Mappings and to gain
troubleshooting information about data and error conditions.
. Used Stored Procedures in mappings to do complex database level
operations.
. Testing - Unit Testing. Deployment of the developed mappings & tested
mappings in appropriate domains i.e., Development & QA domains
. Communicated with user community regarding production data issues, and
other data warehouse issues impacting users. Performed Integration
Testing and involved in User Acceptance testing.
. Extensively involved with end user training for long term support.
. Logical database design, physical database design, data modeling with
Erwin/Model mart.
Environment: Informatica Power Center 8.6/8.5.1/8.1.1/PowerExchange,
Business Objects 6.5, oracle 10g, Tera Data, PERL, Erwin 4.5, TOAD, SQL
Server 2005,Windows, Informatica Data Explorer.
2. AMEX, Phoenix, AZ DW Informatica Developer
May 2008 - Dec 2009
AMEX offers access to world-class Credit Cards, Charge Cards, rewards,
travel, financial and business services. The project includes designing,
developing and maintaining a data mart for Claim department. It had
historical data for 10 years in data mart. The name of the data mart is
Claim Tran and it included 4 fact tables and 40 dimension tables.
Responsibilities:
. Used ETL tool PowerCenter8.1 for extracting data from Oracle, SQL
Server, and DB2, which as collected from upstream databases and loaded
into target Oracle database.
. Performed code reviews and handled change requests.
. Designing and creation of complex mappings using SCD type II involving
transformations such as expression, joiner, aggregator, lookup, update
strategy Transformations
. Performance tuning of mappings, sessions and workflow. Implemented
performance issues on mappings to increase the efficiency of loading
the data from various metrics to the target database.
. Wrote SQL, PL/SQL, T-SQL, stored procedures for implementing business
rules and transformations.
. Used Informatica Workflow Manager and server to read data from sources
to write to target databases, manage sessions/tasks and to monitor
server ETL Implemented for Oracle, SQL Server
. Tuned performance of Informatica sessions by changing data cache size,
buffer length, target based commit interval and SQL overrides.
. Performed Unit testing on data to check whether it met the business
requirements.
. Involved in the Designing of Reports using Business Objects.
. Designed and developed UNIX scripts for creating, dropping tables
which are used for scheduling the jobs. Responsible for monitoring all
the sessions that are running, scheduled, completed and failed.
. Analyzed system requirement specifications, coding the routines,
developed test plans, test cases to cover overall quality assurance
testing
. Created sessions and workflows to run with the logic embedded in the
mapping using workflow manager.
Environment: Informatica Power center8.1, Informatica Power Connect,
Informatica Power Exchange, Oracle 9i, PL/SQL, SQL,T-SQL, Oracle,
SQL*Loader, MS SQL Server, Mainframes, Windows 2000, UNIX Shell Scripting
and Business Objects 6.0.
3. Walt Disney, Burbank, CA DW Informatica Developer
July 2007 - April 2008
Walt Disney World is the most visited and largest recreational resort in
the world, containing four theme parks, two water parks, twenty-three
themed hotels, and numerous shopping, dining, entertainment and recreation
venues. The project involved analysis, design, testing and deploying the
data from the various source systems to the Data warehouse system according
to the business requirements of the users. The implementation was carried
out through Informatica tool.
Responsibilities:
. Designed and populated dimensional models both star and snowflake
schemas for a data warehouse and Datamart's.
. Creating Informatica Repository in Teradata to store the metadata
required for the Data Conversion.
. Used Informatica Designer for developing various jobs to extract,
cleansing, transforming, integrating and loading data into Data
warehouse
. Generating of unique keys for composite attributes while loading the
data into Data warehouse
. Involved in various phases of the project from design to development
to integration and acceptance testing
. Extensively used various Transformations like Source Qualifier,
Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router,
Sequence Generator etc. and used transformation language like
transformation expression, constants, system variables, data format
strings etc.
. Analyzed the session logs, bad files and error tables for
Troubleshooting mappings and sessions
. Debugged maps using Debugger and Transformations verbose data.
. Performance tuning of mappings, transformations and sessions to
optimize session performance.
. Tuned performance of Informatica session for large data files by
increasing block size, data cache size, sequence buffer length and
target based commit interval.
. Used Informatica Manager for managing Informatica repository define
custom routines & transforms, import and export items between
different Informatica systems or exchange metadata with other data
warehousing tools. Dealt extensively with the data from Oracle 10g/9i,
SQL Server 2005/2000 servers
. Used Informatica Monitor and the runtime engine to schedule running
the server jobs, monitoring scheduling and validating its components.
Involved in writing SQL Scripts to test the data.
. Used Informatica Administrator to assign privileges to users or user
groups to control purging of Repository and Informatica client
applications or jobs they run, move, and rename projects. Providing
flexible resources to users as per the business requirements by
exporting Universe and BO reports
. Developed post scripts and pre scripts for downloading and uploading
data as before and after job routines using shell and SQL
Environment: Informatica 8.1.1, Version Control, Erwin 4.5, Business
Objects 6.5, SQL, PL/SQL, Teradata, Oracle 10g/9i, SQL Server 2005/2000,
Windows XP/2000.
4. Glaxo Smith Kline Informatica Consultant
Nov 2005 - June 2007 Research Triangle
Park, NC
The SRDIS application is GSK's state reporting effort to capture Health
Care Professional spend through its employees and external agents. It also
involves inspecting the data to ensure adherence with GSK's file
specifications and providing valid consolidated spend from different data
sources to Advanced Health Media (AHM). AHM is an external vendor that is
tasked with producing reports and queries that monitor spend.
Responsibilities:
. Direct contact with business users during requirements analysis and
given suggestions to improve the process.
. Creating Informatica Repository in Teradata to store the metadata
required for the Data Conversion.
. Developed Informatica mappings, mapplets and transformations.
. Used most of the transformations such as the Aggregators, Filters,
Routers, Sequence Generator, Update Strategy, Rank, Expression and
lookups (connected and unconnected) while transforming the Data
according to the business logic.
. Created sessions, reusable Worklets and workflows in Workflow Manager.
. Extracted the data from MQ series in F using MQ source qualifier and
XML parser.
. Involved in designing and creating IPM process and also schedule them
to run through Tivoli scheduler.
. Developed and modified UNIX shell scripts to reset and run Informatica
workflows using Pmcmd on Unix Environment. Written scripts when
migrating from Informatica power centre 6.1 to 7.1 versions.
. Written UNIX Shell Scripts to manipulate the process and created
parameter files to run these processes through Pmcmd commands.
. Suggested and implemented some advanced scripts to run Informatica
workflows to schedule.
. Send the scripts to support team and get the schedule id to run each
job.
. Responsible for creating ETL detailed design docs and also high level
process overview documentation.
. Worked on performance tuning.
Environment: Informatica power center 6.1/7.1.1, Oracle 9i, Teradata, MQ
series, XML, Flat files, IPM, Power Exchange 7.1.3, Toad, Perl and UNIX.
5. Novartis Pharma, Morristown, NJ Informatica Developer
Nov 2004- Sep 2005
Novartis deployed an innovative data warehouse project, to collect
information on many of the Sales and Marketing factors from disparate data
sources. Market intelligence analytics, Business Unit Directors, Business
Unit Managers, and other upper level management staff use this information
to take efficient and strategic business decisions. Power Center is used to
extract data from various sources like flat files, excel files, oracle to
load into the Oracle Data Warehouse.
Responsibilities:
. Extensively used Informatica power center tools like the Source
Analyzer, Transformation Developer, Warehouse Designer, Mapping
Designer and Mapplet Designer.
. The objective was to extract data from flat files, excel files and
oracle database and to finally load it into a single data warehouse
repository, which is in oracle.
. Developed ETL procedures to translate business rules and functionality
requirements into business logic ensuring lack of redundancy and
compliance with standards.
. Strongly experienced in using lookup transformations, including the
use and configuration of different types of cache (Static, Dynamic,
and Persistent).
. Developed data Mappings between source systems and warehouse
components.
. Developed Mapplets and reusable Transformations. Created and Scheduled
tasks and Batch Process based on demand, run on time, run only once
using Workflow Monitor.
. Develop and review PL/SQL codes including cursors, procedures and
functions and assisted in tuning SQL statements.
. Created Partitions and Indexes on tables for faster execution of
queries and improving performance.
. Presented the features of Business Objects to the end-users to enable
them to develop queries and reports easily. Supported month-end and
quarter-end reporting processes.
. Extensively worked on report publishing.
Environment: Informatica Power Center 6.2, Oracle 9i, Business Objects XI
R1, SQL, PL/SQL, MS Excel, STAR Schema, Erwin 3.5, UNIX, WINDOWS NT.
7. R.M Coal Agencies, India ETL Informatica Consultant
Jan 2004 - Aug 2004
The Power Bill Program Phase II is a Data Migration project in which the
whole billing data is migrated from the existing Billing System to the new
billing system. The data is analyzed from multiple legacy systems and
migrated into a new environment. The project development was to automate
the ETL process.
Responsibilities:
. Designing and developing the ETL process using Informatica 6.2 as per
user requirement.
. Performing data cleansing, scrubbing and validating the data before
loading into data warehouse as per business rules. Development and
testing of Mappings, Sessions & workflows.
. Creating and running sequential & concurrent sessions and Worklets to
load data to target database.
. Developed Design Document for better understanding of existing ETL
processes.
. Migrated mappings, sessions, Worklets & workflows from Development to
QA and Production Environments.
Environment: Windows XP, Informatica5.1.2, Oracle8i, MS SQL Server 2000.
Contact this candidate