Professional summary:

• Having 4+ Years of IT experience in Data warehousing domain with extensive experience in DW developing and Testing with skill set using tools and technologies like Informatica and Oracle, Teradata, SQL Server
• Worked on Functional Testing and Integration testing of ETL - Informatica and Data Validation
• Working knowledge on different data sources such as Flat files, oracle, SFDC, DB2, SQL SERVER and SAP.
• Hands on experience in writing SQL Queries.
• Skilled in analyzing software requirements specification and identifying the required Test scenarios.
• Experience in Designing test cases, execution, analysis and defect raise using Quality Center
• Exposure to UNIX environment.
• Highly motivated professional with integrity and commitment to quality and perfection.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of source systems
• Expertise in Database Management System, Data Warehousing Technologies.
• Extensive experience in using various Informatica power center tools like Designer, Workflow Monitor, Workflow manager.
• Strong knowledge in Data warehousing concepts like Star schema, Snowflake schema methodologies.
• Strong knowledge in to build ODS and Data Staging area.
• Experienced in Full Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation.
• Excellent Communication and interpersonal skills. Ability to quickly grasp new concepts, both technical and business related.
• Involved in different types of testing like Unit, System and UAT.
• Having exposure on Informatica Cloud Services.
• Working Knowledge on Salesforce.com (SFDC).

Employment Profile:

• Working as Programmer - Informatica with Confidential, Bangalore from Dec'10 to till date
• Worked as ETL Consultant with Confidential, Bangalore from April'10 to Dec'10.
• Worked as a Software Engineer with Confidential, Bangalore from Oct'07 to April'10.

Certifications:

• Oracle Certified Associate (OCA) in Oracle9i.

Educational Qualifications:

• Master of Computer Applications

Technical Skills:

• Tools/Applications: Informatica Power Center 7.x/8.x(Designer, Workflow Monitor, Workflow Manager).
• OLAP Tools : Business Objects XI R2/R3
• Operating Systems: Windows, UNIX
• Database Management System: Oracle 9i/10g,Teradata V2R6.2,SQL SERVER 2005/2008
• Languages: SQL, PL/SQL, Java.
• Other Tools: TOAD,SQL Developer, Quality Center 10

Project Details:

Title ELO-Data Migration
Client Confidential
Duration from Feb'11 to till date

The purpose of this project is to move Adobe Enterprise, Omniture BU, Scene 7, Channel Sales and other organizations/acquisitions into a single sales organization while adopting a unified selling methodology and Go-to-Market strategy into a single sales coverage model, process, workflow, and compensation model. This will enable greater economies of scale, reduce maintenance and support burden, and unify key sales processes such as pipeline management, forecasting, and sales rep performance reporting.

Responsibilities:

• Preparing Test Scenarios and Test cases
• Preparing defect report
• Executing Test cases
• Status reporting

Environment:Informatica Power Center 8.6, informatica cloud services, Business Objects XI R3, Oracle 10g, SFDC, SAP, Windows NT, UNIX

Title ELO-INTERIM
Client Confidential
Duration from Dec'10 to Feb'11

Project Description:
The ELO project aims to consolidate all the sales platforms into a unified instance that would reside in the salesforce.com. Sales Operations needed an interim solution that will load data from different sales platforms into the existing sales model in EDW that utilizes SFA as its primary data source.
This project should provide the Sales Ops team, in the interim, visibility to the opportunities that come from different sales platforms on SFDC i.e. Adobe, Omniture, Scene7 as well as the sales platform on SFA.The data from the sales platforms listed will be loaded through flat files that the business will create and maintain. The data will be loaded into the existing SFA data model in EDW.

Responsibilities:

• Preparing Test Scenarios and Test cases
• Preparing defect report
• Executing Test cases
• Status reporting

Environment:Informatica Power Center 8.6, Business Objects XI R3, Oracle 10g, Windows NT, UNIX

Title SIRIUS
Client Confidential
Duration from April '10 to Oct'10

Project Description:
Confidential, is an Insurance firm which deals with various aspects like Life, Annuity etc. Project is divided into three phases depending upon the client's requirement. It has 24 Source systems out of which important are Ingenium, AS400, and Mainframes. From the Source systems data is loaded to a Staging area called IAS. In phase two from the Staging area FA data is loaded into another staging area Financial Activity Header. In the final stage Data is loaded from FAH to Data warehouse called FDS which is Teradata.

Roles & Responsibilities:

• Involved in understanding design and requirement documents.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging area.
• Involved in analyzing the source data coming from different Data sources such as Oracle, and Flat files.
• Prepared ETL standards, naming conventions and wrote ETL flow documentation.
• Importing source and target tables from their respective databases.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, Look up, Router, Filter, Update Strategy, Joiner, Union and Normalizer.
• Used workflow manager to create workflows, sessions.
• Followed TCS standards while documentation & development of code.
• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.
• Validate the data for accurate load into target databases.

Environment:Informatica Power Center 8.6, Oracle 10g, Business Objects XI R3, Windows NT, UNIX,ESP

Title Company Business Management
Client Confidential
Duration from April '09 to March'10

Project Description:

Confidential, is the web application that automates the process of requesting and submitting asset valuations. These valuations are stored in application itself, building a database of information on assets and values. This database enables you to retrieve the information quickly and limits the number of exceptions generated. CBM generates an exception whenever the application cannot generate a value automatically. When as exception is generated the request is assigned to the Asset Management Analysis Group. The team then responds to the request online. The automated process helps sales representative, risk analysts, residual analysts and asset management analysts to deliver on time to the customers. This application is storing data in oracle database.

Responsibilities:

• Worked on Informatica designer components -Source Analyzer, warehouse designer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Involved preparation of the low level design(LLD) documents for Informatica Mappings
• Created mappings, sessions and workflows to populate data into Staging Area and Warehouse area.
• Developed Mapplets, reusable transformations to populate the Data into Data warehouse.
• Created Informatica mappings as per the business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, lookups, Router, Expression, Filters, Sequence Generator & Update strategy.
• Developed slowly changing dimensions as per requirement.
• Involved in unit testing at mapping level and debugged at mapping level.

Environment:Informatica Power Center 8.1.1, Business Objects XI R2, Oracle 10g, Windows NT, UNIX

Title E-Rooming
Client Confidential
Duration from Nov '07 to March'09

Project Description:

E-Rooming is a system to distribute rooming lists to hoteliers. Bookings and associated room information will be taken from third party system into the E-Rooming system during the overnight processes which runs from the cron to load the table .Bookings from third party database are passed over night into third party system where they are allocated to hotels and rooms as appropriate using the auto allocation functionality in third party system. Once this is complete all new and changed bookings are extracted and loaded into ware house. Application used for the resort Office users which are used to manage, release and check bookings. And the application used for the hoteliers to access the booking for their own accommodation units via the web. It will be possible to sort booking information and print it in varying levels of detail. All changes or access to bookings will be recorded using auditing functions. Third party system is hosted on IBM mainframe. Overnight booking information is extracted from third party system and sent to Eroom system. The same will be loaded into Eroom's warehouse. Similarly hourly extract comes from third party system during business hours; the same will be loaded into Eroom's system.

Responsibilities:

• Development of ETL process using Informatica to load data.
• Extracting of data from different sources like oracle tables and flat files.
• Used most of the Transformations like Source Qualifier, Joiner, Expression, Aggregator, Lookup, Filters, Sequence generator etc.
• Implemented slowly changing dimensions.
• Unit testing for validating the data to meet business requirements.
• Used mapping Parameters, Variables and Tasks.
• Worked on Informatica Performance Tuning.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging area.
• Prepared ETL standards, naming conventions and wrote ETL flow documentation.
• Importing source and target tables from their respective databases.
• Developed Informatica ETL mappings and workflows.

Environment:Informatica Power Center 8.1.1, Business Objects XIR2, Oracle 9i, Windows NT and UNIX