Manager Data
Resume:
RAJ KUMAR DOPPALAPUDI
Mobile : 614-***-****
E-mail : ******@*****.***
PROFESSIONAL SUMMARY
> Over 8 Years of experience in IT Industry.
> Over 6+ years experience in Analysis, Design, Development and
Maintenance of various software applications emphasis on Data
warehousing and Decision Support Systems (DSS).
> Worked in various stages of the Software Development Life Cycle.
> Experience in Data warehousing ETL Informatica Power Center7.1.1/8.x
with extensive experience in design the Mappings, configuring the
Informatica Server and scheduling the workflows/sessions, Creating
Repository Administration.
> Knowledge in full life cycle implementation of Data warehouse.
> Excellent Comprehension of Data warehousing Methodologies like Bill
Inmon & Ralph Kimball approaches.
> Experience in OLTP & OLAP System Study, Analysis and E-R modeling,
developing Database Schemas like Star schema and Snowflake schema used
in relational, dimensional and multi dimensional modeling.
> Experience in developing strategies for Extraction, Transformation and
Loading (ETL) mechanism using Informatica.
> Experience in Performance Tuning of sources, targets, mappings,
transformations and sessions. Knowledge of Partitioning Data and
session partitions.
> Expertise in implementing complex Business rules by creating complex
mappings/mapplets, shortcuts, reusable transformations and
Partitioning Sessions.
> Experience in Data warehousing Reporting tool Business Objects XI R2
(Reporter, Designer, Web Intelligence and Info View) with developing
different types of reports according to client's requirements.
> Worked on Team Foundation Server (TFS) - Microsoft Visual Studio 2005
_Web Access
to assign Tasks and Workflow Items to System and Database
Administrators.
> Worked on Analysis features in Business Objects like Scope of
analysis, Slice & Dice
Drill Mode, created charts and used local variables and functions,
Group values.
> Involved in testing by using Informatica workflow manager and monitor
etcand extensive
testing on log files to detect errors.
> Tested different data load databases by comparing source and target
table counts and tested Informatica data loads from IMS flat files to
database and database to database
> Have good Knowledge on SAP R/3(BAPI, IDOCS, ALE, RFC,BDC,LSMW)
> Have knowledge on Cross Applications using RFC interface to transfer
data from server to server.
> Have knowledge on data migration in Data Management Systems using BDC
and LSMW from legacy systems to sap.
> worked on Quality Center test management tool for defect tracking.
> Managed and delivered large and complex assignments within time/cost
and service level parameters.
> Have Strong technical, communication, time management and
interpersonal skills.
ACADEMIC QUALIFICATION:
Master of Computer Applications from Visvesvaraya Technological
University, INDIA
TECHNICAL SKILLS:
Data Warehousing ETL Informatica Power Center 8.6/8.1/7.1.1/7.0,Power
Exchange,
IDQ/IDE,SSIS(Sql-Server Integration
Services)2000/2005,
Data Warehousing Business Objects 6.5 / XI R2
Reporting Analysis Methods - Drill mode,Slice and Dice,
Scope of analysis
Data Modeling Erwin 4.0/3.5.5,MS Visio,Star Schema Modeling,
Snow-Flake Schema Modeling, FACTS, Dimensions
Databases Oracle10g/9i/8i,Teradata V2R5 (BTEQ,
FastExport,FastLoad,
Multi
Load),MS-SQLServer2000/2005,Netezza,MSAcess2000,
SAP
Languages SQL, PL/SQL,T-SQL, Unix Scripting, Perl
Scripting
Testing Tools Quality center 9.0
ERP SAP R/3
Environment UNIX (Sun Solaris, HP, Linux), Windows
2003/2000/XP/98
Others TOAD,SQL*PLUS,XML, HTML,AS/400,TFS,Sharepoint
Server
WORK EXPERIENCE:
Client: Online Computer Library Center (OCLC), Columbus, OH
Duration: Mar 10 - Till Date
Job Description: Senior ETL Informatica Developer
Responsibilities:
> Involved in gathering the business requirements from Business Analyst.
> Understanding the source system, data model, processing logic of data
flow.
> Co-ordinating team based on Business Specifications and discussing on
dependencies
And defining milestones to reach expected mark.
> Created Mappings to Extract data from source systems and Loading to
staging area and then to Datawarehouse and from datawarehouse to
aggregate tables.
> Modified ETL mappings for Incremental loads.
> Worked on transformations, reusable-transformations and used them in
Start-to-end data flow mappings to populate proessing logic based on
business rules.
> Created workflows,worklets,tasks and reusable tasks to run the
mappings to load the data Into target systems.
> Identified bottlenecks and fine tuned objects at source level,target
level,mapping level
and at session level to increase the performance of the data flow
process.
> Creating & Assigning Tasks and work items like change request to
techno related persons through Jira.
> Loading data from datawarehous to aggregate tables(Datamart Tables) in
DEV,QA,PROD.
> Worked on ODBC Connections to resolve database connection errors
during runtime
Of workflow.
> Participated in daily status review meetings with team and managers to
define milestones on work process.
System Environment: Informatica Power Center 8.6(Repository Manager,
Designer, Workflow Manager, and Workflow Monitor), DB2,Siebel,Oracle,Team
Foundation Server (TFS) -JIRA, Unix,Toad,Windows 2000.
Client: State Of Ohio - Department Of Education, Columbus, OH
Duration: Aug 09 - Jan10
Job Description: Senior ETL Informatica Developer/Support
Project Description:
The decision framework(DF) is a decision-making process designed to assist
districts in making
Informed decisions- based on what their data tell them -about where to
spend their time,energy
And resources to make significant and substantial improvements in student
performance.
The project covers the loading of the subscale data from the Source
Files(Located in CD's)into datawarehouse.The subscale Test Fact contains
data about the students that took one of the mandatory state tests:Ohio
Achievement Test(OAT) and Ohio Graduation Test(OGT).The test
Results are captured at the subscale level for each subject.
Responsibilities:
> Configured Dev,QA,Prod repositories.
> Review the design specification -ETL Processes Decision Framework
-Subscale.
> Involved in gathering the business requirements from Business Analyst.
> Understanding the source system, data model, processing logic of data
flow.
> Analyzing Source_to_Target mapping Excel document.
> Co-ordinating team based on Business Specifications and discussing on
dependencies
And defining milestones to reach expected mark.
> Accessing Sharepoint Environment for Requirement(s)cross-reference
and process flow
> Created Mappings to Extract data from source systems and Loading to
staging area and then to Datawarehouse and from datawarehouse to
aggregate tables.
> Worked on transformations,reusable-transformations and used them in
Start-to-end data flow mappings to populate proessing logic based on
business rules.
> Created workflows,worklets,tasks and reusable tasks to run the
mappings to load the data Into target systems.
> Identified bottlenecks and fine tuned objects at source level,target
level,mapping level
and at session level to increase the performance of the data flow
process.
> Creating & Assigning Tasks and work items like change request to
techno related persons through Team Foundation Server(TFS).
> Created and assigned tasks to get privileges from Database Admin and
to promote mappings and workflows from development box to qa box and
to production box.
> Loading data from datawarehous to aggregate tables(Datamart Tables) in
DEV,QA,PROD.
> Worked on ODBC Connections to resolve database connection errors
during runtime
Of workflow.
> Worked on Critical Bugs assigned by QA team through TFS.
> Created SQL Scripts and assigned them through task to Administrator to
run the
Scripts on specific databases before running the workflows.
> Worked on production tickets and resolved them with expected data.
> Participated in daily status review meetings with team and managers to
define milestones on work process.
> Participated in meetings with Data Manager and End users.
System Environment: Informatica Power Center 8.1(Repository Manager,
Designer, Workflow Manager, and Workflow Monitor), Oracle 10g,Oracle SQL
Developer, Team Foundation Server (TFS) - Microsoft Visual Studio 2005 _Web
Access,Sharepoint Server,Unix,Toad,Windows 2000.
Client: Nationwide Insurance, Columbus, OH
Duration: Oct 08 - June 09
Job Description: Senior ETL Developer
Project Description:
The Project Involved Creating Informatica maps to move multiple data source
to an Oracle database. Extracted Source System data which Includes Policy,
Insured Item(Vehicle), Driver,
Coverage and Metrics (Premium) Sources and these Source data exist in flat
file,oracle and teradata. Using this Source data and ETL Tool Informatica,
Staging and Data warehouse were built and finally data is loaded in to
oracle database.
Responsibilities:
> Involved in gathering the business requirements from Business Analyst.
> Analyzing Source_to_Target mapping Excel document.
> Co-ordinating the team and assigning dependencies tasks to team.
> Created Data Flow Mappings to Extracted data from source system and
Loading to staging area.
> Extensively worked on Filter, Router, Sequence Generator, Look Ups,
Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and
Aggregator.
> Extensively used Mapping Variables, Mapping Parameters, and Parameter
Files for the capturing delta loads.
> Worked on various tasks like Session, E-Mail task and Command task.
> Worked on Informatica Scheduler for scheduling the delta loads and
master loads.
> Used aggregate functions like Avg, Min, Max, First, Last, and Count in
the Aggregator Transformation.
> Extensively used SQL Override in Sorter, Filter & in Source Qualifier
Transformation.
> Extensively used Normal Join, Full Outer Join, Detail Outer Join, and
master Outer Join in the Joiner Transformation.
> Extensively worked on various re-usable tasks, workflows, Worklets,
mapplets, and re-usable transformations.
> Worked on slowly changing dimension Type2.
> Good knowledge on performance tuning of the process at mapping level,
session level, source level, and at target level.
> Extensively used Mapplets for use in mappings thereby saving valuable
design time and effort.
> Extensively worked on various Look up Caches like Static, Dynamic,
Persistent, and Shared Caches.
> Worked on Unix to Import parameter files into workflow manager.
> Worked on session logs, Informatica Debugger, and Performance logs for
error handling when we had workflows and session fails.
> Functionality, Back-end and Regression testing during the
various phases of the application and Data Integrity/back end testing
by
executing SQL statements.
> Involved in testing by using Informatica workflow manager and monitor
etc
and extensive testing on log files to detect errors.
> Tested different data load databases by comparing source and target
table
counts and tested Informatica data loads from IMS flat files to
database
and database to database
> Scheduled meetings with Senior Data Manager and analyzed the data.
System Environment: Informatica Power Center 8.6(Repository Manager,
Designer, Workflow Manager, and Workflow
Monitor),Mainframes,Cobol,CICS,Oracle 9i,Teradata,Sql-Server,
Unix,Toad.Windows 2000,
Client: American Auto Insurance, Madison, WI
Duration: Oct 07 - Aug 08
Job Description: ETL/Report Developer
Project Description:
Worked in the Information Resource management (IRM) team to create Data
Warehouse environment for Agent Information (AGT), Corporate Data
Repository (CDR) and Auto Policy Replacement Tracking System. As part of
the development team of corporate information, played a vital role to
develop Data Acquisition process, data Management process and data Delivery
process.
Responsibilities:
> Involved in gathering the business requirements from Business Analyst.
> Involved in creating Repository,Repository Server and Relational
Connections .
> Uploading data from source system to staging area.
> Extensively worked on Filter, Router, Sequence Generator, Look Ups,
Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and
Aggregator.
> Extensively used Mapping Variables, Mapping Parameters, and Parameter
Files for the capturing delta loads.
> Worked on various tasks like Session, E-Mail task and Command task.
> Worked on Informatica Scheduler for scheduling the delta loads and
master loads.
> Worked on slowly changing dimension Type2.
> Good knowledge on performance tuning of the process at mapping level,
session level, source level, and at target level.
> Extensively used Mapplets for use in mappings thereby saving valuable
design time and effort.
> Worked on Unix to Import parameter files into workflow manager.
> Worked on session logs, Informatica Debugger, and Performance logs for
error handling when we had workflows and session fails.
> Worked on Business Intelligence tool Business Objects XI R2. Created
Reports using Charts, cross-tab, Sub-reports, Running Totals.
> Verified Business object reports those are generated from Informatica
warehouse Tested different tables like loading dimension tables, fact
tables etc and also tested data in data warehousing by comparing with
source data
> Involved in testing by using Informatica workflow manager and monitor
etc
and extensive testing on log files to detect errors.
> Tested different data load databases by comparing source and target
table
counts and tested Informatica data loads from IMS flat files to
database
and database to database
> Formatted the Reports according to end Users Requirements, using
Business Objects XI R2 features like Slice and Dice, Drill down,
Breakpoints, Calculations, Variables, Alerters, @ Functions and
Formulae's etc.
System Environment: Informatica Power Center 8.1(Repository Manager,
Designer, Workflow Manager, and Workflow Monitor), Oracle 9i,SQL Server,
Unix,AS/400 CL,Business Objects XI R2,Toad.
Client: Best Buy Inc, Richfield, MN
Duration: Oct 06 - Aug 07
Job Description: ETL Data warehouse Programmer
Description:
Best Buy is one of the leading specialty retailers of consumer electronics,
personal computers, appliances and entertainment software in the US.
Informatica Power Center serves as the Company's data integration platform,
consolidating information from various applications. This project involved
in the design and development of data warehouse to track and plan sales
activities for the organization which enables the sales department to
analyse the market and product performance.
Responsibilities:
> Involved in gathering Business Information from Business Analyst.
> Involved in conversion of Business Specifications into Technical
Specifications.
> Uploading data from source transactional system into staging area .
> Extensively used various transformations like Filter, Router, Sequence
Generator, Look Ups, Update Strategy, Joiner, Source Qualifier,
Expression, Sorter and Aggregator.
> Extensively used Mapping Variables, Mapping Parameters and Parameter
Files for capturing delta loads.
> Worked on various tasks like Session, Command and Scheduler in
Workflow Manager.
> Extensively worked on various re-usable tasks, workflows, Worklets,
mapplets and re-usable transformations, which saves design time and
effort.
> Worked on Business Intelligence tool Business Objects XI R2.
> Created Reports using Charts, cross-tab, Sub-reports, Running Totals.
> Created Templates for standardizing Corporate Document structure.
> Extensively worked on various Look up Caches like Static, Dynamic,
Persistent, and Shared Caches.
> Worked on session logs, Informatica Debugger, and Performance logs for
error handling when we had workflows and session fails.
> Worked extensively with the business intelligence team to incorporate
any changes that they need in the delivered files.
System Environment: Informatica Power Center 8.1, Teradata, SQL Server,
Oracle 9i, Business Objects XI R2,Toad.
Client: Ontronics Inc., Richardson, TX
Duration: Sep 05 - Aug 06
Job Description: ETL/REPORT Designer
Project Description:
Ontronics is a leading provider of outsourced logistics, remanufacturing
and enhanced services to the Wireless & Consumer Electronics Industries.
The project involved in setting up corporate reporting applications using
Business Objects for the purpose of Strategic Planning, Decision Making,
Monitoring Customer Behavior and Tracking Sales across different
geographies.
Responsibilities:
> Extensively worked on various transformations like Filter, Router,
Sequence Generator, Lookups, Update Strategy, Joiner, Source
Qualifier, Expression, Sorter and Aggregator.
> Extensively used Mapping Variables, Mapping Parameters, and Parameter
Files forcapturing delta loads.
> Worked on various tasks like Session, Workflows, Worklets, and
Command.
> Used Informatica Scheduler for scheduling the delta loads and master
loads.
> Designed, modified and maintained Universes used Prompts, Predefined
Conditions and Hierarchies and resolved Loops and Traps.
> Modified Universes and Reports for optimum query performance.
> Suggested changes in design and architecture of the schema for optimum
performance of user distributed reports.
> Created complex stored procedures to implement business rules.
> Interacted with DBA and other technical teams regarding deployment and
performance related issues.
> Applied Security features of Business Objects like Row level, Report
level & Object level Security in Universe so as to make the sensitive
data secure.
> Created Templates for standardizing Corporate Document structure.
> Identified syntax used in an SQL query to retrieve data by joining
multiple tables.
> Interacted with internal customers (Administrative/Financial) to
understand and collect the requirements for the original Database
Model/Design and also trained end users for Ad-Hoc reporting.
System Environment : Informatica Power Center 8.1, Oracle 9i, SQL Server,
Business Objects.
Client: Browne Technologies, Piscataway, NJ
Duration: April 04 - Sep 05
Job Description: ETL Programmer
Project Description:
The project deals with medical equipment and drugs given to the customers,
claiming the bills from Insurance Companies used by the medical service
providers. The Application has different modules like Customer Details,
Database Management, Inventory and Accounts. The Customer details module
deals about the insurance related queries and insurance claims. The
Inventory module deals with drugs and equipments flow from the vendors to
the customers. The Accounts module deals with bills and claims with various
insurance companies. The Purchase module gives their details of purchase of
stock and its inventory.
Responsibilities:
> Created Mappings using transformation like filter, router, joiner,
aggregate, Lookup, update strategy & sequence generator and
expression.
> Extensively worked on various re-usable tasks, workflows, Worklets,
mapplets and re-usable transformations.
> Involved in testing using Informatica work manager and work monitor.
> Tested log files to detect errors.
> Tested different data load databases by comparing source and target
table counts and tested data loads from IMS flat file to database and
database to database.
> Used Quality Center for the test management process to capture the
entire test management process, test planning, test execution and
defect management.
> Used Quality Center for Bug Tracking & reporting.
System Environment: Informatica 7.1, Quality Center 8.2, Manual Testing,
Oracle, SQL
Contact this candidate