SWETHA REDDY
SUMMARY:
. Around *+ years of experience in IT and in the areas of analysis,
design, development in client-server environment with focus on Data
warehousing applications using ETL tool Informatica.
. Experience in data warehouse development life cycle, requirements
analysis, dimensional modeling, Repository management &
administration, implementation of STAR, Snowflake schemas, Incremental
loads/Change Data Capture and slowly changing dimensions.
. Experience in creating mappings using various transformations, and
developing strategies for Extraction, Transformation and Loading (ETL)
mechanism by using Informatica.
. Constituency with data marts using Kimball Views.
. Experience in business requirements gathering, define and capture
metadata for business rules, creating physical infrastructure, system
analysis, design, development and user training associated with the
ETL processes.
. Experience in performance tuning of sources, transformations, targets,
mappings, Worklets, workflows, sessions and batches.
. Reporting in quick understanding of requirement and analysis.
. Experience in SQL Programming (Stored Procedures, Functions and
Triggers).
. Involved in understanding Data model and assisted in fine tuning the
physical model and best understanding the hierarchies and dependency
of the Warehouse loads
. Performed system and QA testing and involved in Production Support.
. Designed and developed various mappings, from varied transformation logic
like Unconnected and Connected lookups, Router, Filter, Expression,
Aggregator, Joiner, and Update Strategy.
. Expertise with domain knowledge like Healthcare, Insurance,
Telecommunications.
. Excellent Interpersonal communication, Documentation skills and
experience coordinating with
Project managers, business Analyst, Architects, DBAs and Developers
TECHNICAL SKILLS
Data Informatica Power Center, Repository Admin Console,
warehousing Repository Manager, Designer, Work Flow Manager, Work
ETL Flow Monitor, Source Analyzer, Warehouse Designer,
Transformation Developer, Mapplet Designer, Mapping
Designer, Workflow Designer, Task Developer, Worklet
Designer, Gant Chart, Task View, mappings, re-usable
transformations, Mapplets, Shortcuts, sessions, and
workflows, Power center real-time
Ralph Kimball Methodology, Bill Inmon Methodology,
Data Modeling Physical Modeling, Logical Modeling, Relational
Modeling, Dimensional Modeling, Star Schema, Snow-Flake,
FACT Tables, Dimension Tables, Normalization,
De-Normalizations, Erwin
Databases Oracle, MS SQL Server 2000/7.0/6.5, MS Access, SQL,,
PL/SQL,SQL Server 2005
BI Tools BO, Cognos
Testing tools Quality Center, Test Director, QTP
Environment Windows 2003/2000/XP/98,UNIX
Others Microsoft Word, Microsoft Excel, Outlook
PROFESSIONAL EXPERIENCE:
Medtronic Surgical Technologies - Jacksonville, FL
Jan' 11 - Till Date
ETL Informatica Analyst
Description:
Medtronic Surgical Technologies are market leader for ENT. The main
purpose of this project is to remove old data sources to new data sources
by using SAP Implementation.
Responsibilities:
. Designed and prepared the documents according the given requirement
for the SAP Remediation Daily.
. Used Oracle 10g - Toad and Worked on the stored procedures, Views,
Packages and made changes depending upon the requirement.
. Updated the worked done using the ETL Remediation Status Excel Sheet
and Attended daily Data Mart Sap Remediation Update meeting.
. Created and Modified the Unix Scripts using X-shell and Putty.
. Involved in Design, Development, Unit testing and System Testing in
the process and documented all the necessary steps in the low level
documentation.
. Used ETL Informatica Client tools like Designer, Workflow Manager,
Workflow Monitor and Repository.
. Worked extensively with transformations like Source qualifier,
Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, and
Rank Etc.
. Used Debugger by making use of Breakpoints to monitor data movement,
identified and fixed the bugs.
. Created Design Document and Test Case Document for the SAP
Implementation.
. Unit testing is rigorously done to make sure we end up in zero errors and
involved in integration testing of mappings in ETL different
environments.
. Performance tuning of mappings, transformations and sessions to optimize
session performance.
. Used change data capture (CDC) to get the new updated records details in
a table.
. Analysis of the requirements and translating it into Informatica
mappings.
. Migration of mappings are done from one folder to other folder using the
Repository Manager and also created different folder.
. Created session and workflows using workflow manager and customized the
parameter according to the requirement.
. Developed Test Cases for Unit Testing, also involved in Integration,
system, and performance testing levels.
. Scheduled Informatica sessions and workflows using Informatica Scheduler.
. Created mapplets in the Informatica Designer which are generalized and
useful to any number of mappings for ETL jobs.
. Migrated all the mappings from development to the production using
Informatica Client tool.
Environment: Informatica 8.6, Oracle 10g, Toad, SQL Detective, Microsoft
office, Putty, UNIX, X-shell and Windows XP Professional.
AmeriGroup - Virginia Beach, Virginia
Nov'10 - Dec'10
Informatica Developer
Description:
The purpose of the Care plus Mobile project is to provide a means for Care
Managers to electronically capture member information via portable device;
thus reducing paper usage, eliminate duplication of data capture, and
improve efficiencies.
Responsibilities:
. Understood the Business requirement for the application process and
created the Datefeeds accordingly.
. Used Informatica 8.6.0 to develop the various mapping, Sessions,
Worklets and Worflows.
. Involved in the production support and used Tidal scheduling tool to
run the workflows in production and QA.
. Manually ran worflows in QA environment.
. Used several transformations in creating mappings like lookup, stored
procedure, Source Qualifier, Expression, Update strategy
transformation.
. Attended daily status meetings and walk through meeting regarding the
project status and its maintenance process was discussed.
. Created Date Feed for the application which captures daily updated
data to Sync db to IPAD and vice-versa.
. Daily MOD, MARS and HIPPA data was updated in the system using
Informatica 8.6.0
. Involved in the Reporting refreshing of the WebFeeds.
. Used SQL server 2005 as source and target for the Informatica Mapping
process and also used SQL Server to Unit Test the SQL Overrides.
. Created Parameter files for the mapping dynamically.
. Performed Bulk Load of large volume of data by creating pre- and post-
load scripts to drop indexes and key constraints before session and
rebuild those indexes and key constraints after the session completes.
. Involved in the performance tuning of mappings, Session, Worklets and
Workflows.
. Used debugger to check the errors in the mappings.
. Created Data feed for Careplans and Mobile Medication list for the
IPAD application.
. Used SQL Server to create Non -clustered Indexes for the required
tables.
. Created Post SQL and Pre SQL attributes according to the requirements.
. Involved in creating non reusable session for the corresponding
Datafeed mappings
Environment: Informatica 8.6.0, SQL Server 2005, Windows XP, Microsoft
Office, Tidal
ADECCO - Jacksonville, Florida
July'10 - Oct'10
Informatica Developer
Description:
This project deals with Business applications like sales, recruiting,
placement, pay rate, bill rate and managing the profiles and creating PAY
STABS for the individual depending upon the Time Sheet numbers. In this
project Informatica is used in the reporting division and with this ETL
tool Time sheets are generated according to the pay distribution and bill
distribution and mainly to obtain the split in the percentage.
Responsibilities:
. Developed mappings using various transformations like source
qualifier, lookup, aggregation, expression, router transformations and
also created session for various mappings.
. Understood the requirement and made changes in the mappings and
documented the changed mapping and the reason for the change.
. Used Informatica 8.1.1 to debug the mappings and used edit Breakpoints
to create breakpoint conditions in a mapping
. Used Repository Manager to create the folders and to check the
connections for the Informatica users.
. Scheduling of the mapping is done using Workflow Manger and monitored
by using Workflow Monitor.
. Worked on Datawarehouing using fact and dimensions by using star
schema.
. Involved in system analysis, design, Build and Testing
. Used the Oracle SQL Developer to generate and to create the query's
and extracted the data from Oracle 10g data source and created ODBC
connections accordingly.
. Migration of the mapping from development folder to Production folder
is done using Informatica 8.1.1.
. Used People soft financial, custom apps and human resource data as
source to calculate the pay and bill split percentages.
. Analysis is done to get the exact result that requirement by the
client through Daily scrum meetings and walk through meetings.
. Used Informatica Designer to create the reusable targets and
transformations.
. Involved in the Testing of mapping using Informatica 8.1.1
. Changed Universes in Business Objects according to the requirements
and generated reports to check the data flow.
. Exported and Imported the Universes after making the changes in the
Business Object Designer 6.5
. Involved in changing the reports in Business objects and created new
data providers, made changes in the structure of the reports and also
used section delimiters.
. Worked with the Elite change management system and Initiated the
change process system
Environment: Informatica 8.1.1, Oracle 10g, Windows XP, Knowledge Spring,
Decision Studio (Business Objects 6.5), Elite change management system,
Oracle SQL Developer, SQL Server 2005, People soft 8.4.6.
ACS - Lansing, Michigan State
March'09 - June'10
Informatica Developer
Description:
A conversion projects involving the Tennessee state team, working with ACS
at Lansing location. With 5 source systems involving two DB2 and three
Oracle. Oracle was being used as main source system and the other four data
was being compared and loaded, removing duplicates. Main purpose of this
project was to handle client records, and insurance policies. Providing
food stamps to the clients meeting the requirements.
Responsibilities:
. Understand the requirement and develop mappings according to the
client requirement.
. Informatica and Oracle Developer to analyze the data, if it was
according to the specs and do the development. Work with Business
analyst and/or directly with users to gather specifications.
. Extract data from oracle data source, create ODBC connections
accordingly.
. Set some understanding according to the business approach and making
development while confirming with BA's if any BR (Business Rule) being
used was not effective. In a way, that using the experience and
business understanding to make out BR's and implement them to design
the business logics. In-house tool MATT - Mapping analysis and
tracking tool to get the latest version of specs, minimizing the
development process time, while the BA's work on feed-backs.
. Migrating the code from development to production and making sure the
migration is successful with no errors, validating the mappings,
sessions, connectivity and work-flows.
. Testing the code in production with a sub-set data base and making
sure the test results match with the client requirement. EUT -
Extended unit testing for Quality of data being loaded, with proper
documentation for the amount of data loaded and also the reason for
loss of data.
. Daily meetings to sort out issues in the team and make use of
technical advices to make better and faster approaches. Extensively
used un-connected Look-Ups for minimizing the run time and add to the
performance of the server, while making sure to avoid duplicates of
data from other source systems.
Environment: Informatica 8.6.1, DB2 and Oracle 10g, MATT, Microsoft Excel,
Windows XP.
Department of Health and Human Services, Chicago, IL
Sep'07- Feb'09
Informatica Analyst
Description:
Involved in design and maintenance of Data Marts. We have to upload the
data from various centers with data in different source systems using ETL
tools. Informatica Power Center was used to load strategic source data to
the data marts. An operational data store was created. Meta Data Build up
was designed for performing data mapping. We have extracted data from
different data sources and then we have created different Data Marts to
answer different query reports using Business Objects.
Responsibilities:
. The project involved developing mappings for moving data from BPST
Flat Files to Staging Area (STG) and then to Data Warehouse (DWH) and
then to Data Mart.
. The data to the warehouse was moved in a Normalized fashion while the
Data Mart Involved dimensionally modeled data. Used Update Strategy
Transformation to update the slowly changing Dimension tables, Type2
updates was often used. Develop technical documents in ease of
improvements on existing code. ETL mappings were developed to perform
tasks like validating file formats, business rules, database rules and
statistical operations.
. Used Informatica Designer to create reusable transformations to be
used in Informatica mappings and mapplets. Working with designers to
form a Data model for critical issues and lead to better design
decisions. Create test cases for the above projects in providing error
free solution.
. Work with Workflow manager to check with session and validate the
workflow.
. Maintain the access time and access methods for error free dataflow
and time management.
. Organized way of work and validate the mappings to prevent time on
debugging and improve the efficiency of debugger. Precise
Documentation was done for all mappings and workflows.
. Involved in performance tuning of SQL Queries, Sources, Targets and
sessions to achieve high response times.
. Assisted Project Manager with preparation of high-level estimates for
the technology component of the project and also for any change
requests.
Environment: Informatica Power Center 7.x, Win 2000, Oracle, Flat Files,
XML files, PL/SQL, UNIX, TOAD7.0, Business Objects.
Cardinal Health, Inc, Dublin, OH
Jan'07- Aug'07
ETL Informatica Developer
Description:
Cardinal Health, Inc. is a health care services company. Cardinal health
specializes in health care supply chain services, providing pharmaceuticals
and medical products to more than 40,000 locations each day. The Project
Audit Management System (AMS) aims at building a system to analyze and
audit the Resources Data (Types of resources, Number of resources
Available, Used and needed, etc.). Created reports for analyzing resources
data responsibilities
Responsibilities:
. Involved in Requirement Analysis, ETL Design and Development for
extracting the Gold Points Member data from the source systems and
loading it into the EDT.
. Wrote Functional specifications for each of the ETL processes, working
in close co-ordination with business users and development leads.
. Converted functional specifications to technical specifications
(design of mapping documents).
. Developed complex mappings to load data from Source System (Oracle)
and flat files to Oracle and other extracts which are flat files.
. Involved in Dimensional modeling like logical and physical modeling.
. Performed Functional spec reviews, Prepared Technical and Unit test
plan documents
. Transformations like Source Qualifier, Aggregator, Expression, Lookup,
Filters, Stored procedure, and Sequence generator are mostly used.
. Used Informatica Power Center Workflow manager to create sessions and
workflows to run the logic embedded in the mappings.
. Created different transformations like Source Qualifier, Expression,
Router, Filter, Lookup, Sequence Generator, Normalizer transformations
for loading the data into the targets.
. Created and used reusable Mapplets and transformations using
Informatica Power Center
. Migrated objects from the development environment to the QA/testing
environment to facilitate the testing of all objects developed and
check their consistency end to end on the new environment.
. Participated in weekly end user meetings to discuss data quality,
performance issues. Ways to improve data accuracy and new
requirements, etc.
Environment: Informatica Power Center 6.x, Informatica Power Exchange
5.2.2, UNIX, Oracle 9i, TOAD, MS Visio
Larsen & Turbo Limited India
Oct'04-Nov'06
Informatica Developer
Description:
Larsen & Turbo Limited are in the business of manufacturing and selling of
its new machinery parts. This project was aimed to computerize and keep
track of all sales and orders and their status by organizing the data into
the centralized server in client server architecture. The system also gives
all the required information of clients and suppliers of the company.
Responsibilities:
. Involved in complete system analysis, design, development and
implementation
. Prepared user manuals and project documentation. Involved in end user
training and application installations. Data is extracted from different
source systems using Informatica.
. Worked on Informatica Designer tools -Source Analyzer, Data warehousing
designer, Mapping Designer, and Transformations, Repository manager,
Workflow manager and Workflow monitor.
. Involved in designing the procedures for getting the data from all
systems to Data Warehousing system. The data was standardized to store
various Business Units in tables.
. Most of the transformations were used, like Source qualifier,
Aggregators, Connected & unconnected lookups, Filters & Sequence. Created
Sessions and Workflows for Mappings in workflow manager.
. Monitoring the Session Performance by using workflow Monitor
. Analyzed the existing OLTP system Performed data cleansing and
transformation using Informatica.
. Preparing the Impact analysis for the Change Request from the client.
. Monitoring the Session Performance by using workflow Monitor
. Testing of enhanced programs in development region with the prepared unit
test plans.
Environment: Informatica Power Center 6.1/5.1.4, Oracle 8i, SQL Server,
Toad, Business Objects 6.5, Windows, Linux (Main Server)
Reliance Communications, Mumbai, India
Feb'03- Sep '04
Informatica Developer
Description:
The Reliance project is a strategic initiative designed to improve the
client reporting efforts of the various functional groups. Reliance is
expected to create competitive advantage by improving the management
decision making process with more accurate and timely information and
improving the quality of the client interactions with better advance
communication and coordination among the various teams.
Responsibilities:
. ETL tool Informatica was used to load strategic source data to build the
data marts. An operational data store was created. Metadata Build up was
designed for performing data mapping. Also involved in Mass data loads,
refreshing the data in various applications, Performance evaluations,
modifying the existing code to accommodate new features.
. Used various Transformations like Aggregator, Router, Expression, Source
Qualifier, Filter, Lookup, Joiner, Sorter, XML Source qualifier, Stored
Procedure and Update Strategy.
. Worked extensively on Flat Files, as the data from various Legacy Systems
are flat files.
. Have setup Test and Production Environment for all mappings and sessions.
. Created and configured Sessions in Workflow Manager and Server Manager.
. Debugged the sessions using Debugger and monitored Workflows, Worklets
and Tasks by Workflow Monitor. Extensively used SQL & PL/SQL for
Transformations.
. Developed Oracle stored procedures, packages and triggers for data
validations.
Environment: Informatica Power Center 5.2, Business Objects 5.1, UNIX,
Oracle 8i and Windows 2000
EDUATION:
. Bachelors in Engineering, JNTU, India.
REFERENCES:
. Available upon request.
abg7h8@r.postjobfree.com