Resume - Informatica and Cognos certified- Sushma

Please contact 813-892-4581 or soja@abstargroup.com

SUMMARY

Informatica and Cognos certified data warehousing professional with a verifiable track record of handling complex data warehousing projects.

· Over 5 years of experience in Data warehousing practice with a total of 6 years of IT experience.
Presently working as a Technical Lead with prior experiences as an Analyst, Designer and Developer in various Data warehousing projects.
Strong experience in analyzing, designing, developing and implementing Business Intelligence solutions in Data Warehousing using ETL tools, Informatica PowerCenter 7.1/6.2/5.1
Involved in all aspects of software projects such as identifying requirements, system analysis, preparing specifications, data migration, documentation, client interaction and team leading.
· Experienced in designing Star Schema, Snow Flake Schema, Dimensional data modeling as well as Entity Relational model.
· Experienced in creating reports in Cognos Impromptu by developing catalogs.
Excellent communication and presentation skills.
Excellent analytical and problem solving skills and ability to conceptualize and document project plans.

TECHNICAL PROFILE

ETL Tools: Informatica 7 -Power Center Designer, Workflow Manager and Monitor
OLAP/BI Tools: Cognos Business Intelligence Series 7 Suite –
Impromptu, Powerplay
Database: Oracle 9i, DB2

Operating Systems: UNIX, Windows NT, Windows 95/XP
Languages: PL/SQL,
Utilities/Tools: Erwin 4.0, Appworx, TOAD

CERTIFICATIONS

· Informatica Designer
· Impromptu Product Professional Certification
· PowerPlay Product Professional Certification
· Brainbench Certified Data warehousing professional.
· Brainbench Certified OLAP professional.
· Brainbench Certified Data Modeling Professional.
· Brainbench Certified RDBMS Professional.

ACHIEVEMENTS

Excellent Performance Award from Patni in 2004
Team Award for project AGFA Integration in 2003

EMPLOYMENT

Name of employer
Employer's address
Designation
Period
Patni Computer Systems
One Broadway
Cambridge, MA 02142
Software Specialist
Jul, 2003 to
Till Date
RDG Micro Electronics
JB Nagar, Andheri (E)
Mumbai, India
Software Engineer
Oct, 2002 to Jun, 2003
Clarisoft Corporation
Marol (E)
Mumbai, India
Software Engineer
Mar, 2002 to Aug, 2002



EDUCATION

Diploma in Advanced Computing from CDAC in 2001
Bachelor of Engineering (Electronics and Telecommunication) from University of Mumbai in 2000


PROJECTS

Project 1 Institutional Data Warehouse
Technology/Software DB2, Informatica 7.1, UNIX, Windows
Duration Apr 2006 till Date
Client Metlife, New Jersey

MetLife has an Institutional Data Warehouse (IDW) that is loaded on a daily basis from internal and external data sources. The Enterprise Data Warehouse further feeds data at various intervals into Company Relationship Data Mart, Dental Data Mart, Disability Data Mart, Long Term Care Data Mart, eMetrics Data Mart, Finance Data Mart, Case Definition Facility, Life Data Mart, and Retirement Solutions Data Mart

The IDW/Data Marts provide critical information for business analytic and decision-making purposes. The data is extracted, transformed and loaded into IDW using Informatica as an ETL tool. Business users use this information for their decision-making using COGNOS and ACTUATE reports.

Responsibilities:
Technical Lead for ETL using Informatica Power Mart.
Establishing the data loading strategy from various source systems into the Data Warehouse, using Informatica.
Creating the Source and Target Definitions in Informatica PowerCenter
Creating reusable transformations and mapplets and mappings to load static fact and dimension tables using Informatica Designer.
Performance tuning and Error handling of Informatica mappings.


Project 2 iManage
Technology/Software Oracle 9i, Informatica 7.1, UNIX, Cognos Impromptu 7.1, Cognos IWR 7.1, Cognos Powerplay 7.1, Windows
Duration Oct 2005 to Mar-2006
Client GE Commerical Finance Fleet, UK

GE Commercial Finance Fleet Services Europe has launched a program, called iMANAGE, to develop a comprehensive online solution to fulfill its customers’ needs. This is a European-wide program covering 10 countries as well as international pan-European customers.
The objective of this program is to propose to customers a comprehensive fleet management online desktop that will link information to analysis to action to control. This solution will comprise a web dashboard, data query capabilities (vehicle contract data, driver data, event data) and will offer transactional capabilities (data update, online services booking) as well as reporting capabilities.
Responsibilities:
Develop ETL (Extract, Transform and Load) strategies by using Informatica.
Develop and scheduled transformation processes using Server Manager.
Performance tuning and Error handling of Informatica mappings.
Develop OLAP Reports using Cognos BI Tools
Created Impromptu reports with prompts.
Testing in Development






Project 3 Sales Data Mart
Technology/Software DB2, Informatica 6.2, Cognos Impromptu 7.1, Unix Shell script, UNIX, Windows
Duration Aug 2005 to Oct 2005
Client Metlife, New Jersey

The Sales Data Mart project involves extracting of policy related data from data warehouse into data mart. It involved calculation of various policy premiums required by the Sales team at MetLife. The data from the data mart was used for sales person to generate sales reports.

Primary responsibilities on this project are to understand reporting requirements of user community and development of loading strategies and reports, using Informatica and Cognos tools.

Responsibilities:
Analyze business and system requirements including impact analyses on existing systems and to develop systems specification.
Document user requirement and the impact analysis on existing application.
Design- Database design, data modeling and application design.
Establishing the data loading strategy from various source systems into the Data Store, using Informatica.
Creating the Source and Target Definitions in Informatica Power Center.
Configuring and running test sessions using Server Manager available with Informatica Power Mart.
Building run schedules for the Informatica jobs and building dependencies.
Developed analysis reports in Impromptu.

Project 4 GEAE –AGFA Integration Development 2
Technology/Software Oracle 9i, Informatica 7.1, Unix Shell script, Cognos Impromptu 7.1, Cognos IWR 7.1, Cognos Powerplay 7.1, AppWorx, Unix, Windows
Duration Jan 2004 to Jul 2005
Client General Electric - Transportation, Cincinnati

The client is in the business of manufacturing Film products like Ultra sonic systems, Eddy currents. The scope of the project is to integrate all financial data of AGFA for net margin countries like India, China, Japan and Brazil with current GEAE Financial systems including Oracle, AR, AP and GL. It also involves processing of AGFA films and history data to facilitate generation of ad-hoc queries and allow the user to drill down to minute levels of details for Sales and Cost reports for various countries.

Responsibilities:
Interactions with the Business to understand the overall financial processes.
Use of Informatica Power Center for Designing/Creating of Mappings/Sessions to populate the Data Warehouse.
Performance tuning and Error handling of Informatica mappings.
Create multi-dimensional cubes as per the user requirements with drilling down and slice & dice features.
Quality Checking and Integration Testing.

Project 5 GEAE- AGFA Integration
Technology/Software Oracle 9i, Informatica 5.1, Unix Shell script, Cognos Impromptu 7.1, Cognos IWR 7.1, Cognos Powerplay 7.1, AppWorx, Unix, Windows
Duration Jul 2003 to Jan 2004
Client General Electric - Transportation, Cincinnati

GEAE-AGFA Integration involves the integration of AGFA Company with GEAE processes. The project needs to integrate all financial data of AGFA with current GEAE Financial systems including Oracle AR, AP, GL and IBS systems and build a data store that will be the foundation to support this integration.

Responsibilities:
Interactions with the Business to understand the overall financial processes.
Develop ETL (Extract, Transform and Load) strategies by using Informatica.
Performance tuning and Error handling of Informatica mappings.
Develop OLAP Reports using Cognos BI Tools
Created Impromptu reports with prompts.
Testing in Development and QA region and after final approval from customer, Production implementation.

Project 6 Campus Automation
Technology/Software VB 6, MS Access, DCOM
Duration Sep 2002 to Jun 2003
Client Product Development

The project involved implementation of Smart Card technology in campus automation. The software automated the Student Admission, Attendance, Library Module, Examination and Staff Details processes. Initially all these processes were carried out manually. For attendance the software extracts data from flat files generated by attendance marking system on daily basis from multiple locations. And generates daily reports with in time/out time entries.

Responsibilities:
Developed front-end screens using VB to provide user-friendly interface.
Developed client side validation programs to check the input.
Involved in unit testing for all the modules.

Project 7 Text Based Search Engine
Technology/Software ASP, MS Access
Duration Mar 2002 to Aug 2002
Client Lntinfotech

The application was designed to upload documents and enable the user to search word or words from the documents and give its entire path.

Responsibilities:
· Requirement Analysis, Code creation, reviews
· Test case preparation, review of Unit test cases, Integration test cases of all the assigned modules.
· Review of Unit test cases, Integration test cases of all the assigned modules.

Reference Available upon request