Customer Service Project

SUJATHA

Mail: *******.*****@*****.***

Mobile: 850*******

Experience Summary:

Over 4+ Years of experience in the IT industry. Involved in the life cycle of data warehouse Performance tuning, data modeling, application development and product support.

• Experienced in developing Mappings, Sessions and workflows Using Informatica Power Center8.6/7.1.

• Having hands on experience in developing ETL process to extract, transform and load data from various sources, archive systems into data warehousing.

• Used Client Tools Designer, Workflow Manager, Workflow Monitor in Informatica Power Center.

• Extensively used Expression, aggregator, Lookup, Update Strategy, joiner.

• Involved in Unit Testing.

• Worked on extracting data from Oracle, Flat Files to transform and loading into data warehouse.

• Experienced in working on developing Oracle PL/SQL to write stored procedures, oracle functions, packages and triggers.

• Involved in Business intelligence application tools with an extensive use of SQL knowledge of business processes, internal and external identification and documentation of Business intelligence requirements.

• Excellent communication skills and analytical skills and ability to perform as part of the team.

Professional Experience:

Working as an Associate Consultant in Patni Computer Systems Pvt Limited, Hyderabad from July 2010 to till date.

Worked as Software Engineer in Span Systems, Bangalore From March 2008 to June 2010.

Work experience in other areas

Research associate 2006-2007 College of medical technology Nalut

Paper published in international journal

Senior Accounts officer Srinivasa cystine limited,Hyderabad 1993-1999

Educational Qualification:

• B.COM from Andhra University

• D.C.A from Gujarat University

• M.C.A From Indira Gandhi National Open University.

Technical Expertise:

ETL Tools : Informatica Power Center 8.6/7.1.

Operating Systems : Windows/Unix.

Databases : Oracle 10g/9i/8i,SQL Server.

Languages : java,c,c++.

Project Profile:

Project # 1:

Project Title : Risk Management System (RMS)

Client : UBS, Switzerland

Duration : May 2011 to till date

Environment : Informatica 8.6.1, Oracle 9i, Flat Files, Window XP

Description:

UBS is one of the leading global financial services company, with its headquarters located at Basel and Zurich. It is the second largest bank in Europe. UBS is present in all major financial centers worldwide.

Risk Management System (RMS) is the centralized repository of consistent and reconciled customer credit risk information for capital calculations and credit risk reporting. RMS improves accuracy of Risk Weighted Assets calculation for the identified wholesale credit portfolios. It also helps to evaluate credit risk from both a product-specific and enterprise-level perspective across products and report relevant information as required by regulators.

Responsibilities:

Involved in requirements study and understanding the functionalities

Used heterogeneous data sources like flat files and Oracle.

Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, Lookup and Update Strategy.

Created and Monitored Informatica sessions.

Checked and tuned the performance of Informatica Mappings.

Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.

Analyzed Mappings and Sessions for better performance.

Project #2:

Title : Data Warehouse for Mortgage Capital Division

Client : BNP.

Role : ETL Developer

Duration : July 2010 to April 2011.

Description:

BNP an innovator in global finance, serves the financial needs of corporations, governments and municipalities, institutional clients, and high net worth individuals worldwide. BNP acquired 3 Mortgage Business Units (SPML, PML and ELQ) in the UK and the European geography to strengthen their presence in the mortgage business. Key activities relating to Loan Origination, Loans Completion and Loans Servicing like Underwriting, Credit Check reporting etc. are taken care of by these subsidiaries. Lehman funds the subsidiaries by securitizing these loans.

Responsibilities:

Involved in requirements study and understanding the functionalities

Used heterogeneous data sources like flat files and Oracle.

Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, Lookup and Update Strategy.

Created and Monitored Informatica sessions.

Checked and tuned the performance of Informatica Mappings.

Environment: Informatica Power Center 7.1, Windows, Flat Files, Oracle9i, UNIX.

Project #3:

Client : Abbey National, UK

Project : Data warehouse for Motor Insurance

Role : ETL Developer

Duration : May 2009 to June 2010

Project Description:

Abbey National is UK based Insurance Company, is one of the largest insurance providers for Home insurance, Motor insurance, and Travel insurance and Card insurance. This project involves building of data ware housing for Motor insurance.

The source data, which includes

Types of policies:

Information about policy holder

Policy covered item details

Premium Payment details

Types of claims like fast claim payments, fast repairs claim

Responsibilities:

• Extensively working on Informatica Designer, Workflow Manager, Workflow Monitor Working on Source Analyzer, Warehouse designer, Mapping Designer & Mapplet Designer.

• Created mappings, reusable transformations in Mapping Designer and Transformation Developer.

• Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to meet the requirements of the Client.

• Used Informatica features to implement Type I, which keeps current data.

• Involved in Unit Testing and created Testcase document.

Environment: Informatica Power Center 7.1, Oracle 9i, IBM AIX 5, Flat Files.

Project #4 :

Title : Telecom Services Information Systems

Client : Vertech Telecom Services Inc., Texas

Role : Software Tester

Duration : March 2008 to April 2009.

Description:

The main purpose is to develop high-performance data warehouse infrastructure that integrates data from a variety of source systems and provide client with information. The main process that is performed is Extraction, Transformation and Loading. The reporting tools provide on-demand reports to business users who use the information to study service usage patterns, design more competitive, cost-effective services, and improve customer service.

Responsibilities:

• Preparing and reviewing of Test Plans and Test Cases.

• Functionality, Acceptance, Regression, Ad-hoc, and Installation Testing, License Testing

• Reporting and conforming defects in QC

• Documentation review

• Executing Test Cases on mile stones and weekly builds.

Environment: Business Objects 6.5, Oracle 9i, Windows NT Server.

Contact this candidate