SUMMARY:

• Around 8+ years of IT experience in design and development of ETL (Extract, Transform and Loading data).
• Methodology for supporting data transformations and processing, in a corporate wide ETL Solution usingInformatica Power Center.
• 1+ year of experience working on OBIEE Developer.
• Worked with clients in Insurance, Banking HealthCare domain.
• Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, and Transformation.
• Developer, Mapplet, Mapping Designer, Repository Manager and Workflow Monitor.
• Worked extensively with complex mappings using different transformations like Source Qualifiers,Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Experience in Requirement Analysis, Gap Analysis, Data Cleansing, Data Relationships, Source Systems.
• Good knowledge on Dimensional Modeling using Star schema and Snow Flake schema for faster, effective query processing and Business Analysis Requirements.
• Experience in development and design of ETL methodology for supporting data transformations and processing in corporate wide ETL Solutions using Informatica Power Center 9.x/8.x/7.x.
• Experience in using the PDO (Push down optimization), CDC (Change data capture) mechanism.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Strong knowledge of Data warehouse concepts - Star Schema, Snowflake, SCD, Surrogate keys,
• Normalization De normalization.
• Expertise in Data Warehouse Data mart, ODS, OLTP and OLAP implementations teamed with project scope,Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing,Implementation and production support.
• Experience working with relational databases (Oracle, MySQL, SQL Server), Flatfiles, XML, and high-performance.
• Data warehouse appliance like IBM Netezza.
• Experience in the Repository modeling using OBIEE Administration tool. Experience in repository developmentright from the scratch which includes three layers (Physical Layer, Business Model Presentation Layer).
• Dimensional hierarchies, setting up aggregate tables, Time Series Objects, Variables usage.
• Intensive knowledge of setting up the Data level security based on hierarchy based security for an organization.
• Experience in development of Interactive Dashboards, advance Reports with drill-Down capabilities usingFilters and Dashboard prompts, different Analytics Views like Pivot table, Chart, Tabular view, Column andView selector, dealing with Security Setup (groups, access privileges).
• Experience in Configuring and basic knowledge of using iBots.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Excellent client relation skills with the drive to complete tasks effectively and efficiently where customer services and technical skills are demanded as well as the ability to communicate effectively with all levels of management and the client community.

TECHNICAL SKILLS:

Operating System: MS-DOS, UNIX, Linux, Windows NT, Windows 7.ETL Tools: Informatics Power Center 8.6 9.1 9.5, SQL*Loader.

Database: Oracle 9i 11g, IBM DB2, Teradata, SQL Server 2005.

Database Tools: SQL Developer 2000, SQL*Plus, TOAD.

Data Modeler Tools: Erwin 4.0, MS-VISIO, Informatics MDM.

Languages: SQL, PL SQL, UNIX Shell Scripting, KORN Shell Scripting.

Reporting Tool: OBIEE - Oracle Business Intelligence 10.1.3.X, Oracle BI Publisher.

Web Technology: HTML, XML.

Configuration Management:: Tortoise SVN, CVS.

Release and Bug Tracking: Trace, JIRA.

Scheduling Tools: Control-M, Autopsy s.

FTP Client: FileZilla, Putty, Wisp.

PROFESSIONAL EXPERIENCE:

ETL- Informatica Developer

Confidential - Albany NY

Responsibilities:

• Responsible for logical dimensional data model and use ETL skills to load the dimensional physical layerfrom various sources including DB2, SQL Server, Oracle, and Flat file etc.
• Successfully collaborated with business users to capture & define business requirements and contribute todefining the data warehouse architecture (data models, data analysis, data sourcing and data integrity).
• Analyzed source data for potential data quality issues and addressing these issues in ETL procedures.
• Developed technical design documents and mappings specifications to build Informatica Mappings to loaddata into target tables adhering to the business rules.
• Design, develop, test, maintain and organize complex Informatica mappings, sessions and workflows.
• Complete technical documentation to ensure system is fully documented.
• Design and develop ETL using CDC using Power Exchange 9.1 in Mainframe DB2 environment.
• Created registration and data map for mainframe source.
• Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy.
• Created UNIX script for identifying CDC hanging workflows.
• Participate in Developing PL/SQL procedures.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre&Post SessionSQL.Script to meet business logic.
• Extensively used paced commands on command prompt and executed Unix Shell scripts to automateworkflows and to populate parameter files.
• Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc.
• Created InformaticsPower Exchange Restart token and enables recovery for all real-time sessions.
• Worked on data warehouses with sizes from 2-3 Terabytes.
• Worked on Teradata utilities like FLOAD, MLOAD and TPUMP to load data to stage and DWH.
• Worked on Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and DimensionalData Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.

Environment: Informatics Power Center 9.5/9.1, Power Exchange 9.1, SQL Server 2008, Teradata, 12 UNIX, Toad, Erwin 7, Linux, Harvest, Putty, DB2 Mainframe, FLOAD, MLOAD and TPUMP.

ETL-Informatica Developer

Confidential - Lyndhurst, NJ

Responsibilities:

• Prepared the detailed technical requirements are technical specification and communication set up.
• Worked on Informatica tools -Source Analyzer, Data warehousing designer, Mapping Designer Mapplets, and Transformations Developer.
• Used Source Analyzer and Warehouse Designer to import the source and target database Schema's, and themapping designer to map source to the target.
• Run the work flow manager used to Informatica Generic ETL driver scripts.
• Developed Metadata repository RPD, configured metadata the Business Model
• Layer Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Adminand Web tool.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chartdrilldowns.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performanceoptimizedmanner.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified the Obiee Dashboard using cascadingstyle sheets.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Performing Unit Testing.
• Performance Tuning.

Environment: Informatica 7.1, Oracle 9i, DB2, OBIEE, Oracle SQL Developer, Flat files, XML Files, MS Visio, Toad 7.0, Windows 2000, Putty, Power Exchange.

Informatica Developer

Confidential - Saint Cloud, MN

Responsibilities:

• Requirements gathering from business analysts and responsible for populating the business rules using mappings into the Repository for Meta Data management.
• Performance tuning in the context of dimensional design by creating Mini Dimensions thus providing smaller entries in to the Fact table.
• Flattening out Many to Many relations by creating bridge tables as in the case of account and customer dimension tables.
• End-to-end ETL development of the Data Mart. Designed and developed Informatica mappings for data loads.
• Extensively used ETL and Informatica to load data from Oracle, MS SQL Server, flat files into the target Oracle database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping MappletDesigner and Transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.
• Used Informatica features to implement Type I II changes in slowly changing dimension tables. Created andran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Actively participated in resolving Email tasks working on priority and non-priority issues of employee’sprofilesand figuring out those issues through mappings.
• Optimized Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Developed UNIX scripts to automate different tasks involved as part of loading process and scheduling and performed Unit Testing on the mappings.

Environment: Informatics Power Center 8.6.1 7.1, Oracle 10g 9i, MS SQL Server 7.0 2000, IBM DB2 400, Flatfiles, SQL, SQL*Loader, ERWin 3.5, Toad 7.0, Windows 2000, UNIX Shell Scripting.

Informatica Developer

Confidential - Brooklyn, NY

Responsibilities:

• Involved in Work Stream 3 which handles the developing of interfaces, Integration, Unit Testing, SIT Phase-1, Phase -2.
• Getting the requirements from the BA team understanding the databases and structures required for the development.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, Union, and Normalizer.
• Using of Cassiopeia a global leader in finance and asset management software.
• Full lifecycle oversight of code fixes and monthly deployments, including requirements gathering, design, coding, testing, and deployment.
• Clearing the open attributes sent from the offshore team, andcoordinating the Cassiopeia team with theinformatica developing offshore team to close the gaps in mapping.
• Writing the SQL queries for the incremental logic.
• Wrote Unix Shell Scripts to perform operations on text files.
• Developed SQL Overrides for the Source Qualifiers Based on the Business Requirements.
• Worked extensively on Stored Procedure transformations.
• Worked closely with the defect tracking group to close the mapping gaps in informatica.
• Expertise in OLTP OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.

Environment: Informatics Power Center, SQL Server 2008 express, Oracle SQL Developer, Flat files, XML Files, MS Visio, Toad 7.0, Windows 2000, Putty, Power Exchange.

Informatica Developer

Confidential

Responsibilities:

• Analysis of the existing Database environment and preparing Functional and Technical documents.
• Worked on Informatica tools such as Informatica Designer (Source Analyzer, Target Designer, MappingDesigner, Transformations) and Informatica Workflow Manager.
• Analysis of the Data mart and suggesting the changes in the Data Model.
• Understanding the mappings and logics built in Informatica to extract and load the data from Oracle ERP (OLTP) system to the Data warehouse (OLAP) system.
• Designing Tables and Writing PL SQL Packages, Procedure, Functions, Triggers for various modules involved in complete life cycle development in OBIEE 10.1.3.4.1 and BI Publisher 10.1.3.4.1.
• Developed various reports as per the requirements for user interface design like Drill Down, Pivot Narrativeand Nested reports in Answers.
• Perform Administrative tasks in OBIEE such as granting privileges, creation of custom, complex and summaryfolders, linking folders for Drill-to detail and configuration.
• Granted users with appropriate access to the subject areas and reports.
• Designing the Repository for the Adhoc reporting through Answers.
• Creating Dashboards with Advance filters, Search Options, color code logics and logical columns at cataloglevel.
• Implementing the Authentication model for the OBIEE platform using external table authentication, and somedata level security was implemented to ensure the data authentication to the valid users.
• Created Metadata in OBI Admin tool, Configured Connection Pools, Data Sources and DSN to suit the technicalenvironment.
• Provided inputs designed database tables, views, materialized views, procedure, functions, sequence, etc.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution dataloading process.
• Developed reports using Report Studio-using sub reports, cascading or customizing prompts and cross tabs, tabular objects, list, charts, and drill through reports.

Environment: InformaticsPower Center, Flat files, SQL, SQL*Loader, Erwin 3.5, Toad 7.0, Windows 2000, Unix Shell Scripting.