Manager Data Warehouse

Rakhee ETL Informatica Developer

Phone: 571-***-****

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

Resumes ID: 48984

Location:, California

Posted: 04.13.2012

Resume Details:

PROFESSIONAL SUMMARY:

* ***** *f IT experience in Analysis, Design, Development of various business applications as an ETL developer with strong Data Warehouse Developer experience in Informatica Power Center 8.x/7.x platforms.

Good knowledge in Developing, Implementing, Documenting and Executing of a project in various Domains: Insurance, Finance, Pharmacy.

Experienced in Analyzing business and functional requirements for understanding source systems, Target design thoroughly by going through the Functional specification documents and one-to-one interaction.

Experienced in Kimball Data Warehouse Methodologies.

Proficient in Informatica 8.6x/8.1/7.1 Server and Client tools (Repository Manager, Power Center Designer, Workflow Manager, Workflow Monitor ) and DAC (Data Warehouse Application Console).

Clear knowledge on OLTP/OLAP System study, Analysis, E-R modeling, Developing database Schemas (Star schemas, Snowflake schemas), Dimensions and fact tables.

Good knowledge on Logical and Physical modeling concepts.

Experienced in integrating various sources like Oracle, SQL Server, and Flat Files.

Expertise in using Source Qualifier, Aggregator, Expression, Connected and Unconnected Lookup, Mapplets (Reusable Business Logic), Router, Filter, Sequence Generator, Update Strategy, Joiner, Stored Procedure.

Experience in Mappings, Mapplets, Worklets, Reusable Transformations, Sessions or Tasks, Workflows and Batch processes.

Extracted data from Multiple Source systems to Staging area, Data Warehouse, Data Marts using Data Warehouse Concepts like SCD’s (Slowly Changing Dimensions- Type1, Type2, and Type 3).

Implemented Post-session and Pre-session shell scripting to run workflows using the pmcmd.

Used Informatica Debugging techniques to debug the mapping and used session log file to trace the errors while loading into Targets, Data Marts, and Data Warehouse.

Implemented various Performance Tuning techniques on Mappings, Targets, and Sessions.

Experienced in working with Tools like TOAD, SQL Navigator, SQL Plus.

Hands on experience in writing stored procedures (PL/SQL), triggers and Packages.

Experienced in interacting with Business Users, Business Analysts, IT leads and Developers in analyzing business and functional specifications.

Strong Logical and Analytical reasoning skills, Excellent Presentation, Communication with Good listening, and Intrapersonal Skills.

EDUCATION:

Bachelors in Computer Science and Engineering from JNTU, Hyderabad

TECHNICAL SKILLS:

ETL Tools:

Informatica Power Center 8.6.1/8.5/8.1/7.1.4, Power Marts, Informatica

Metadata Manager 8.5

Data Modeling:

ERWIN 7.0/4.0/3.0, Visio, Dimensional Modeling, Snowflake Schema, Star

Schema.

DBMS:

Oracle 8i/9i/10g/11i, SQL Server 2000/2005/2008, Flat Files, Microsoft

Access, MS Excel.

SQL Utility:

TOAD, SQL plus, SQL Navigator, Query Analyzer.

Languages:

C, C++, SQL, PL/SQL, UNIX Shell Scripting.

Operating Systems

Windows 95/98/2000/XP/NT, UNIX.

Others:

MS Office, MS Outlook, Business Objects (Reporting tool).

PROFESSIONAL EXPERIENCE:

Bank of America, California, LA Oct’10 – Till Present

ROLE: ETL Developer

Description: Bank Of America is one of the leading banking services in the world. The CHDW, a data warehouse for the bank operations and historic data will have an open architecture that allows for changes and allows for in cooperation of new business areas and allows for both central and de-central implementation. The CHDW will use one file set data capturing from source system. Data is populated in the warehouse using ETL tool like informatica. Data transformation/cleansing are done in the tool.

Responsibilities:

Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.

Used Informatica Designer to Create, Load, Update mappings using different transformations to move data to different data marts in Data warehouse.

Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Successfully Loaded data into different targets from various source systems like Oracle data base, Flat files, ODS, SQL Server etc into Staging tables and then into Target Database.

Involved in discussing Requirement Clarifications with multiple technical teams.

Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository Manager.

Created Source, Target, Transformations, Sessions, Batches, and defines Schedulers for the sessions.

Also Used Data Integrators to club data from different kind of Sources.

Performed Incremental aggregation to load data into aggregate tables.

Made substantial contributions in simplifying the development and maintenance of ETL by creating Re-usable Transformation Objects and Mapplets.

Extensive use of Persistence cache to reduce session processing time.

Used Debugger in Mappings to debug the Complex mappings and fixed the Errors.

Created Task Session, Email and Workflow to execute the mappings. Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.

Involved in moving Mappings, Sessions, and Workflows between development and production environments.

Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data using Appworx.

Scheduled Sessions and Batch Processes based on demand, Run on time, run only once using informatica Server Manager.

Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project development to testing and then to Production environment.

Prepared and used test data cases to verify accuracy and completeness of ETL process.

Actively involved in Production Support and helped other team members.

Environment: Informatica Power Center 8.6.1, SQL SERVER 2008, Oracle 10g/11i, Business Objects, PL/SQL, TOAD, Windows XP, UNIX, ERWIN, Appworx v 7.

First Team Health Insurance, Cincinnati, OH May’09–Sep’10

ROLE: Informatica Developer

Description: First Team Health Insurance is among the most respected health care companies in Cincinnati. They have an extensive network of nearly 45,000 physicians, 750 physician groups and affiliates, and 4,200 pharmacies all working together to serve 2 million members. The objective is to achieve single point of reference to get the customer data from various databases. The system helps the customer service representatives to deal and transact with the customers. The different departmental financial data marts are mapped to central Data Warehouse. The data from different operational source are transformed in to dimensional and fact tables of Data Warehouse.

Responsibilities:

Responsible for gathering suit of business requirements, Prepare source to Target Mapping specifications and Transformation rules.

Involved in System study, analyze the requirements by meeting the client and designing the system.

Developed Mappings/ Reusable Objects/ Transformation/ mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power center.

Extracted data from different Sources like Oracle, Flat files and loaded into ODS.

Designed and developed complex Aggregate, Join, Lookup Transformation rules(Business rules) to generate consolidated (Fact/ Summary) data identified by dimensions using Informatica ETL tool

Created Connected and unconnected Lookup transformation to look up the data from the source and target tables, used Update Strategy transformation.

Implemented SCD- Type 1 and Type 2 according to the business requirements in the dimension tables.

Workflow Manager used for creating and maintaining the sessions, Monitor, edit, schedule, copy, abort, and delete session.

Setting up Batches and Sessions to schedule the loads at required frequency using Power Center Workflow Manager, pmcmd and also using scheduling tools.

Involved in Performance Tuning for sources, targets, mappings, sessions.

Used Debugger to debug mappings by creating breakpoints to gain troubleshooting information about data and error conditions.

Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating the connect strings and synchronizing the connect strings and connection objects in Dev, Test and Prod environments.

Involved in Unit testing and created Test cases for those mappings.

Worked with testing team and helped in Testing at Integration Level.

Extensively used various tasks like Session task, Event Wait Task, Decision task, Email task, Command task.

Actively Participated in Team meetings and discussions to propose the solutions to the Problems.

Environment: Informatica Power Center 8.6.1,Appworx 4.4 TYPO3 CMS, Oracle 9i,10g, MS SQL SERVER, SQL, PL/SQL, Erwin, SQL Loader, Unix Shell Script, Win 2000/NT.

MEDCO Pharmaceuticals (Merck), Camden, NJ Jan’08 – Apr’09

ROLE: ETL Developer

Description: MEDCO (Merck) is a leading pharmaceutical company. Purpose of this project is to maintain a data warehouse that would enable the management to take corporate decisions. The project deals with building a real time view of enterprise wide data. A decision support system is built to compare and analyze product prices, their quantities and patient profiles. IMS Health data is combined with data from other sources and is made available for reporting. This Data Warehouse is used to deliver reports and information to sales and marketing management.

Responsibilities:

Involved in all the phases of project (Client Interaction, gathering requirements from business users, preparation of detail design, development, unit testing, and production support).

Worked extensively on transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, and Update Strategy.

Extracted data from various heterogeneous sources cleaned the data before applying business logic and loaded them into central Target Data Warehouse.

Proficient in using Informatica Client tools (Repository Manager, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor).

Created Workflows and Work lets for designed mappings.

Generated status reports using Workflow Manager.

Used UNIX Shell Scripts for data extraction, running Pre-Session, Post-Session and PL/SQL procedures.

Used debugger to test the data flow and fixed the mappings.

Extensively used Performance tuning techniques to improve the session performance.

Worked with various Sessions, Decision, Command, Email tasks in single workflows.

Used Toad to analyze source data, applied various queries for testing.

Environment: Informatica Power Center 7.1, Oracle 8i, Business Objects, SQL, TOAD, MS Outlook

Apollo Health Care, Hyderabad, India Sep’06–Dec’07

ROLE: Data Warehouse Developer

Description: Apollo Health Care is a global healthcare services company offering Business Process Outsourcing and IT Solutions and Services to global clientele with its principle place of business in the city of Hyderabad, India. This project involved working with a financial data mart that was periodically fed from various sources. BUSINESS OBJECTS was the reporting tool used to generate complex reports.

Responsibilities:

Created Dimension Tables and Fact Tables based on the warehouse design.

Involved in creating Logical and Physical design of databases using Erwin.

Participated in build of the Data Warehouse, which includes the design of Data Mart using Star schema.

Created ETL detail design document and ETL standards document.

Created Repository using Informactica Power Center – Repository Manager.

Extracted data from Flat files and Oracle, applied Business Logic to load them in the central Oracle database.

Involved in Extraction, Transformation and Loading (ETL) Process.

Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.

Created Re-usable transformations and Mapplets and used them in mappings.

Worked on SQL- queries and tuned them to improve performance.

Extensively used Shell Scripting to automate the Pre-Session and Post-Session Processes.

Modified Universes and generated reports using Business Objects.

Designed and developed reports, Drill down reports using Business Objects Reporter.

Designed reports with Slice and Dice, Drill down operations.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL Server, ERWIN 3.5, Business Objects5.1, UNIX, Windows NT

DSS, Hyderabad, India May04’-Aug’06 ROLE: ETL Developer

Description: Dimensionality is a leading software consulting service which provides better solutions to their clients in India. This Company specializes in areas like IT services, Business product outsourcing etc. We have involved in all modules like HRMS, Sales, Clients, Sales Monitoring.

Responsibilities:

Driving the technical design along with customer team, preparing design specifications, functional specifications and other documents.

Involved in all aspects of software development life cycle.

Generated DDL queries of new database objects like tables, views, sequences, functions, indexes, triggers, packages, stored procedures.

Produced SQL reports, data extractions, data loading, and scripts for various schemas.

Involved in performing backend testing by writing SQL queries to extract the data from SQL database using oracle.

Worked on Linux Environment.

Performed Testing using Selenium IDE.

Wrote DDL, DML scripts for Schema, Table space, Cluster creation and Alteration.

Environment: Oracle 8i, Linux, TOAD, SQL SERVER 2000, PL/SQL, SDLC, Selenium IDE.

Contact this candidate