Summary




Over 3 years of professional experience in Information technology
Progressive experience in the implementation of the Date Warehousing ETL tool Informatica Power Center 6. x/7. x/8 .x
Knowledge of Installing and Configuring Informatica Server/Client
Knowledge of data warehousing techniques Star/ Snowflake schema Ralph Kimball methodologies, data quality, ETL, OLAP and Report delivery methodologies
Good exposure and hands on experience of relational databases like Oracle8i/9i
Experience providing 24x7 production support activities
Proficient in UNIX and Windows environments.
Knowledgeable and experienced in all the phases of SDLC Requirements Analysis, Design, Coding, Testing, Implementation and Maintenance


Employment

April, 2007 -  Present

Description DeAM Deutsche Asset Management is a global asset management division of Deutsche Bank which provides investment services to clients from different countries. DeAM has 2 main data warehouse applications, SalesMart and SKIP. SalesMart serves as a repository of data used in generating reports for Mutual funds operations area. SalesMart repository holds different vendor information and different data source application systems for generating Sales Reports on Daily, Weekly, Monthly, Quarterly of the US Retail business. The SKIP Warehouse is a central repository of Scudder Mutual Fund Data. It is also the performance engine for all Scudder Mutual Funds and Variable Annuities. The information housed in SKIP is provided to customer facing applications.

Role Production Support Executive/ETL Developer
Solution Environment Informatica Power Center 7.1/8.1, Sybase, Control-M for Job Scheduling, Remedy and DbSmphony for updation and closing of tickets, WindowsXP, Windows NT, Unix, IBM Pentium PC, Windows 2000 Intel Pentium

Responsibilities Study of production processes and supporting tools
Development of mappings, sessions and workflows.
Monitoring, fixing the issues of the scheduled workflows, store procedures jobs in Control-M.
Making changes to the existing requirement.
Unit testing of mappings, sessions and workflows.

Documented Test Cases corresponding to business rules and other operating conditions.
Carried out ETL Testing using Informatica.
Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
Executed sessions and batches in Informatica and tracked the log file for failed sessions.
Write SQL queries to validate that actual test results match with expected results
Communicate with the Database business leaders or users along with Onsite coordinator to get the exact requirements.

Preparing Defect Reports and Test Summary Report documents.
Checking the ETL jobs in Unix, Control - M

September, 2006 -  March, 2007

Description Swiss Re is 1 of the leading global re-insurers. Swiss Re offers a wide range of traditional reinsurance products and related services. The main business functions include Client Management, Underwriting, Claims and Liability Management, Pricing, Technical Accounting, Financial Management, Reserving.
These functions are supported by various support functions like Product Management, Risk Management, Capabilities Development, Information Technology, Legal Services, HR, Communication and Liability Management.
Project in the Swiss Re : BI Maintenance Services is 1 of the projects in Swiss Re.

Applications Developed : CSA Core Systems Aligment
CSA Factual Core Systems Aligment Factual
ODSP
TA Monitoring

Role ETL Developer.

Solution Environment Informatica Power Center 7.1, Business Objects 6.1.3 WindowsXP, Oracle 9i, Sun Solaris Sun OS 5.8.

Responsibilities Involved in gathering requirements from business user. Prepared the Estimation and Blue print Documents.
Created the new mappings for CSA and ODSP flows.
Created the session parameter files
Created and Monitored Sessions, Workflows.
Involved in the unit testing.
Involved in preparation of the design document.
Prepared the Release related Documentation.
Updated the PDM and Dimensional model diagrams.

July, 2006 -  September, 2006

Description SEI INVESTMENTS SEI Investments is a leading global provider of wealth/asset management and investment technology solutions. They provide financial solutions that help corporations, financial institutions, financial advisors and affluent families/individuals create and manage wealth.

The main objective of the project is to help the decision making team and running reports in a faster pace from Desktop. This is achieved by loading data from different tracks consisting of several sources like Oracle, Flat files, Mainframes DB2 from EDB database into new database called DSS which is designed in such a manner, for the faster access of data.

Role ETL Developer
Solution Environment Informatica Power Center 7.1.3 Oracle 9i, SQL, Flat Files, Windows XP Professional.
Responsibilities Developed ETL mappings using heterogeneous data sources like flat files and Oracle.
Created mappings using the transformations like the Source Qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator and Update Strategy.
Created reusable transformations and mappings using Informatica.
Preparing Unit Test Plans.

July, 2006 -  Present
System Engineer

Skills

Good understanding of ETL Test Processes and Test Methodologies. working in the role of Production Support Executive/ETL Developer.
Technology ETL tools Informatica PowerCenter 6.x or 7. x/8 .x OLAP tools Business Objects 5.1. Databases : Oracle 8 or 9i PL/SQL, Access Oracle 8i or 9i PL/SQL, Access, Sybase 12.5 Scheduling Tools Control-M Operating Systems Windows XP, Windows 2000, Windows NT, Sun Solaris SunOS 5.8 Degree and Date Institute Major and Specialization Master of Computer Applications, Dec-2004 Jawaharlal Nehru Technological University, Anantapur Andhra Pradesh Computer Science Bachelor of Commerce Computers, May 2001 Holy Cross Degree College for Women, Osmania University, Hyderabad. Computer Science Intermediate, April 1998 Holy Cross Junior College for Women, Osmania University, Hyderabad. Maths, Economics and Commerce Secondary School Certificate, April 1996 Jodi Vidhalaya High School, Hyderabad Assignments Project Database SMD Sales and marketing distribution


Miscellaneous

Passport Details
Name as on passport Passport Number Date of Issue Expiry Date Place of Issue
Tulasi Vasudeva F5543987 17 - NOV-2005 16 - NOV-2015 Hyderabad