PROFESSIONAL SUMMARY:

• 8+ years of IT experience in all phases of Software Development Life Cycle ( SDLC ) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookup, joiner, sequence generator, sorter, SQL, stored procedure, Update strategy, Source Qualifier.
• Data Modeling : Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables.
• Strong working experience in Informatica Power Center (PWC) Data Integration Tools - Repository Manager, Designer, Workflow Manager, Workflow Monitor.
• Designing and developing Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions (SCD).
• Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition, participating in requirement gathering, Analyzed the requirements.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files and XML files.
• Created an XML definition in PowerCenter from an XML file
• Experience writing shell scripts on UNIX platforms.
• Modify/Migrate the Informatica mappings (XML) from the Development to Test Server and Production server.
• Extensively worked in ETL process consisting of Data Analysis, Data Modeling, Data Cleansing, Data Transformations, Integration, Migration, Data import/Export, Mapping, Conversion.
• Experience in integration of various data sources like SQL Server, Oracle, Flat Files, and XML files.
• Created Informatica maps using various transformations like SAP BAPI/RFC, SAP IDOCs transformations, Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica Power Center, IDQ.
• Importing source data from and target data records into flat text file and XML data file.
• Coordinating with Business Users, BI teams, functional Design team and testing team during the different phases of project development and resolving the issues.
• Experience in Design, Development & Implementation of OBIEE with expertise in managing OBIEE Admin tool in developing OBIEE Repository (. RPD)-3 layers (Physical Layer, Business Model & Mapping Layer & Presentation Layer).
• Worked extensively on Customizing Physical Data Layer, Business model and mapping layer and Presentation Layer in Administration Tool.
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts Scheduled Agents and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Actively participated in sprint and daily status calls to discuss on the progress of the work and various issues which came across during integration.
• Created Test plans for unit-test, System Integration Test and UAT and tested code in all Development.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, IDQ 9.6.1,DAC

BI Tools: OBIEE 10.x/11.x, Tableau 8.x/8.1

Programming Languages: SQL, PL/SQL, Shell Scripting

Database: Oracle 11g/10g/9i, SQL Server, Teradata

Operating System: Windows 9x/NT/2000/XP/ 2003/ 2007, Unix, Linux

Supporting Tools: Toad, Win sap and Putty

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr. Informatica & BI Developer

Responsibilities:

• Worked on Informatica 9.6.1 Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Used Informatica designer for designing mappings and mapplets to extract data from various sources like Oracle, flat files and XML files.
• Extensively used Source Qualifier Transformation to filter data Confidential Source level rather than Confidential Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Written ETL Specs and documentation to describe program development, logic, coding, testing, changes and corrections.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Perform unit testing of these Workflows from source to staging and staging to warehouse.
• Analysis & fix on QA defects made by QA team.
• Created an XML definition in PowerCenter from an XML file
• Experience writing shell scripts on UNIX platforms.
• Modify/Migrate the Informatica mappings (XML) from the Development to Test Server and Production server.
• Build the OBIEE Data model repository (RPD) - Physical, logical and presentation layers required for BI reporting and necessary variables and Initializing blocks to implement security.
• Build ad hoc BI reports and dashboards using OBIEE.
• Deftly managing Cache management, RPD Merging, MUDE Setup.
• Migration of Webcat between environments including refresh of GUID's.

Environment: Informatica Powercenter 9.6.1, PL/SQL,TOAD, SQL Developer, Linux, Oracle 11g, OBIEE 11.1.15.1

Confidential, Phoenix, AZ

Informatica Developer

Responsibilities:

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Developed Data Mappings between source systems and warehouse components using mapping designer.
• Involved in creating various metadata types, including legacy source and data warehouse target data definitions and ETL jobs.
• Implemented mapping for slowly changing dimensions (SCD) to maintain current data as well as historical data.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Excellent understanding of business process modeling, process improvements, and developing process flows.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management

Environment: Informatica Powercenter 9.6.1, PL/SQL,TOAD, SQL Developer, Linux, Oracle 11g

Confidential

Informatica Developer

Responsibilities:

• Working as ETL Developer/BI Developer and implemented OBI solutions.
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
• Prepared High level & low-level ETL flow design and technical documents.
• Review Informatica Code, Unit Test Cases & Results with the Developers.
• Designed & Customized Informatica mappings according changes & requirements by the business team.
• Create mappings employing various transformations, filters, joiners, lookup, SQL Transformation & SQL overrides etc to load Data from multiple Databases into Warehouses and performing the full, incremental loading and processing.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Perform unit testing of these Workflows from source to staging and staging to warehouse.
• Analysis & fix on QA defects made by QA team.

Environment: Informatica Powercenter 9.6.1, PL/SQL,TOAD, SQL Developer, Linux, Oracle 11g, OBIEE 11.1.15.1

Confidential

Informatica and BI Developer

Responsibilities:

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Developed Data Mappings between source systems and warehouse components using mapping designer.
• Involved in creating various metadata types, including legacy source and data warehouse target data definitions and ETL jobs.
• Implemented mapping for slowly changing dimensions (SCD) to maintain current data as well as historical data.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Excellent understanding of business process modeling, process improvements, and developing process flows.
• Worked on Informatica Analyst Tool to get score cards report for data issues.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Build the OBIEE Data model repository (RPD) - Physical, logical and presentation layers required for BI reporting and necessary variables and Initializing blocks to implement security.
• Build ad hoc BI reports and dashboards using OBIEE.
• Deftly managing Cache management, RPD Merging, MUDE Setup.
• Migration of Webcat between environments including refresh of GUID's.
• Responsible for creating complete test cases, test plans, test Data, and reporting status ensuring accurate coverage of requirements and business processes.
• Involving in Functional Testing & Regression Testing

Environment: Informatica Powercenter 9.6.1, PL/SQL,TOAD, SQL Developer, Linux, Oracle 11g, OBIEE 11.1.15.1

Confidential

Informatica & SQL Developer

Responsibilities:

• Interacted with the Business Personnel to analyze the business requirements and transform the business requirements into technical requirements
• Prepared technical specifications for the development of Informatica (ETL)Process to load data into various target tables.
• Extensively used Informatica power center 8.6.1 for extraction, transformation and loading process.
• Extensively developed various Mappings, which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, and Joiner etc.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Involved in Unit Testing and Integration Testing of the application.
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.
• Gathered business requirements and created mapping documents based on the data model and source system analysis.
• Involved in initial design meetings
• Integrated data from heterogeneous source systems extract and transform data with business rules and built re-usable Mapplets using Informatica Designer.
• Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router, joiner and others.
• Created complex mappings and transformations using expressions, aggregators, filters, and sorter, and sequence generator, lookups to develop DataMart’s.
• Worked on creating star schema DataMart’s using the dimensional modeling approach.
• Fine-tuned transformations and mappings for better performance.
• Used Informatica Power Center workflow manager to create sessions, workflow to run with the logic embedded in the mappings.
• Efficient documentation was done for all phases like analysis, design, development, testing and maintenance.
• Associated with Production support team in various performances related issues.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Written PL/SQL procedures for processing business logic in the Database. Tuned SQL queries for better performance.
• Preparing Test Data for Unit Testing for existing application.

Environment: Informatica 8.6.1, PL/SQL, TOAD, SQL Developer, Linux.