SUMMARY

• Expert experience in Informatica Power Center 9.1, 8.6.1/8.1.1/7. x, Informatica Power Analyzer, Informatica Designer
• Analysis, design, development, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, Infomatica MDM, OLAP, MOLAP, OLTP, Client/Server and Web applications on Windows and Unix platforms in various verticals
• Worked on various software development such as waterfall and agile.
• Extensively worked on Informatica tools including Power Center Administration console, Repository Manager, Work Flow Manager, and Work Flow Monitor
• Expertise in Autosys, Control M, Visual Source Safe, Maestro, Oracle 9.x/8.x/7.x, and UNIX Shell Scripting,
• Strong experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Teradata, DB2, and worked on integrating data from XML files and flat files like fixed width and delimited
• Knowledge on Java /J2EE.
• Work on Teradata BETQ script to generate reFt and import and export. Good working knowledge on B2B data transformation.
• Solid experience in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin 4.0.
• Proficient in creating mappings/Mapplets using Informatica Lookup, Aggregator, Joiner, Expression, Filter, update strategy, Source Qualifier, Union, and Normalizer Transformations
• Implemented Performance Tuning techniques for ETL Process such as finding bottlenecks in sources, targets, mappings and sessions and have done troubleshooting on them
• Working knowledge using a Informatica dynamic data masking to protect sensitive information.
• Excellent ability in integration mappings; static cache lookup, dynamic, and persistence mappings for fact table mappings.
• Good knowledge and experience working with EDI transactions sets like, 835, and 837I/P and HIPAA migration.
• Extensive data base experience in Oracle 10g/9i/8i, MS SQL Server, TeradataV2R6/V2R5, DB2 8.0
• Good working knowledge in SQL/PLSQL programming, developing and executing Packages, Stored Procedures, triggers, Table Partitioning, Materialized Views
• Worked on UNIX shell Scripting for executing PL/SQL codes and Informatica jobs and performed unit testing and integration testing for the developed data load process

TECHNICAL SKILLS

ETL Tools: Informatica ( 8.6.1/8.1.1/7. 1.x/6.x,9.1,), Informatica Power Analyzer, Informatica Designer Components (Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer Transformation Developer, Workflow Manager, Workflow Monitor

RDBMs: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), Teradata 4.x/5.0, SQL server DB2, Mainframe, COBOL, Flat files

OLAP: Business Objects 5.1, 6.16.5 Info View, Cognos, Web intelligence 2.6.6.Hyperion, Brio Explorer 6.x

Operating System: UNIX, Windows NT/98/95, Windows 2000

Programming: XML, Visual Basic 6.0/5.0, SQL, PL/SQL, UNIX Shell Scripting, Transact - SQL

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh PA

Sr. BI /Informatica developer

Responsibilities:

• Assisted in development of the overall technical architecture for global BI/DW solution that meet the business requirements for the data access, availability, performance, and security
• Translated business requirement into technical solution
• Documents technical requirements to be used for design and development.
• Designs, develops and tests database architecture.
• Design, develops, test and debugs ETL solution.
• Identifies and documents data mapping rules for movement of data between applications.
• Implements and adheres to organizational standards.
• Extract the data from Flat files and load in to the ODS layers then load in to the GDW.
• Maintains versions of all data objects for production and test environments.
• Researches and resolves Data Warehouse technical issues.
• Assists in tuning and optimizes the Data Warehouse solution andPartners with the business reporting team to ensure the data model supports reporting requirements.

Environment: Power Center9.1, (Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle11g, SQL Server 2008, SQL developer, SSIS, Visual studio2008

Confidential, Pittsburgh PA

Sr. Informatica/Application Developer

Responsibilities:

• Extensively used Informatica client tools like Source Analyzer, Mapplet Designer, Informatica Repository Manager and Workflow Manager
• Developed complex ETL mappings using various transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator and Sequence Generator transformations
• Re works on the existing mapping to fix the errors and updates the mapping using new logic.
• Wrote the complex transformation logic for different transformation in Informatica to get the accepted result as per the business needs.
• Debugged the mapping figure out where the problem occurs.
• Worked on complex script and transform it using Informatica power center.
• Worked on writing the mapping documents and unit testing documents.
• Run the SSIS package calling stored procedure (SP).
• Involved in analyzing and writing complex procedures and queries to extract data from SQL Server and Toad.
• Wrote SQL queries, PL/SQL procedures, Functions, Cursors, Triggers in Oracle and SQL server

Environment: Power Center9.1, (Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle11g, SQL Server, Reflection, UNIX, TOAD, SSIS, Visual studio2008

Confidential, Buffalo NY

Sr. Informatica Developer

Responsibilities:

• Worked extensively on Informatica components (Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager).
• Created complex mappings in Informatica by using the transformations like Mapplets, Normalizer, SQL transformation, Router, Union, and Aggregator.
• Used the SQL tools like TOAD inorder to validate the data against the various databases like Oracle.
• Debugged to optimize the complex mappings and figure out the bottlenecks in the mapping.
• Actively participated in using the Kalido tool to build the Crosswalk tables in new MDM-EDW and use them in the complex mappings in Informatica.
• Performed Unit Testing for ETL Mapping and documented the test cases.
• Involved in Performance tuning of the Informatica Mappings and Sessions to enhance the performance by using different Partitioning techniques and the Various Transformations
• Scheduled the Informatica jobs using the Tidal Scheduler.
• Involved in comparison tools like exam diff and Confidential compare to compare files and folders and for automatic change detection.
• Migrated mappings, sessions, and workflows from Development to Testing environments.

Environment: Power Center8.6.1, (Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle11g, SQL Server, DB2, Reflection, UNIX, TOAD

Confidential, Buffalo, NY

Informatica Developer

Responsibilities:

• Extensively used Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Workflow Manager
• Involved in extracting the data from various source systems like Sybase, DB2, Oracle and flat files and loaded to a relational data warehouse and flat files
• Developed complex ETL mappings using various transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator and Sequence Generator transformations
• Extensively optimized all the Informatica sources, targets, mappings and sessions by finding the bottlenecks in different areas and also debugged some existing mappings using the Debugger to test and fix the mappings
• Extensively worked on Mapping Variables and Parameters, Workflow Variables and Session Parameters
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time
• Migrated mappings, sessions, and workflows from Development to Testing environments
• Worked with DBAs to make the daily loads run much faster by tuning different aspects of the loaded jobs
• Extensively worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing
• Worked with Developers to troubleshoot and resolve mapping / workflow / session logic, as well as performance issues in Development, Test and Production repositories

Environment: Power Center 8.6.1(Repository Manager, Designer, Workflow Manager and Workflow Monitor), Sybase (facets), Oracle10g, SQL Server, DB2 Flat Files, Reflection, UNIX, TOAD, WinSQL

Confidential, Detroit, MI

Informatica Developer

Responsibilities:

• Designed ETL process, load strategy and the sequence of execution of developed Informatica objects
• Defined and documented the technical architecture of the Data Warehouse, including the physical components and their functionality
• Involved in dimensional modeling of the Schemas across the Data Warehousing requirements
• Responsible for creating the extracting (incremental) CDC data from Mainframe sources, exporting and updating them to the Repository, importing the required source files on to the staging environment by using Informatica Power Exchange
• Responsible for creating XML source files, web services consumer connections and their sources
• Extensively used ETL to load data from wide range of sources such as Flat files, DB2, SQL Server, and Oracle
• Involved in creating simple to complex mappings using transformations like aggregator, Source Qualifier, Router, expression, look-up, joiner transformation
• Developed re-usable transformations, mappings and Mapplets confirming to the business rules
• Built Workflows and Worklets to schedule, sequence and parameterize data loads into the different Datamarts and the Enterprise Data Warehouse
• Involved in Performance tuning of the Informatica Mappings and Sessions to enhance the performance by using different Partitioning techniques and the Various Transformations
• Involved in analyzing and writing complex procedures and queries to extract data from SQL Server
• Wrote SQL queries, PL/SQL procedures, Functions, Cursors, Triggers in Oracle and SQL server
• Implemented Slowly Changing Dimensions to update the dimensional schema
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings
• Developed UNIX shell script to validate, screen door of flat files and audits
• Used Business Objects to check the validity of the data in the Data Warehouse
• Created the reports using Business Objects functionality like Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formulae
• Helped in migrating from version 8.5 to version 8.6 of Informatica Power center on Windows environment

Environment: Informatica Power Center 8.6/8.5 (Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle10g, SQL Server 2005, Sun Solaris, Windows NT, Query Analyzer, Businessobjects6.5 (Designer, Reporter)

Confidential, Milwaukee, WI

Informatica Developer

Responsibilities:

• Responsible for the full lifecycle development, implementation and production support of the Oracle Data warehouse using Informatica Power Center
• Identified and defined business rules and transformation logic for various phases of the project
• Netezza Database tables were used as the sources with which various reusable transformations, parameters and Mapping variables were used based on the business strategies
• Worked on BTEQ script to provide batch to import and export data and generate reports.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details
• Worked on various Transformations like Connected and Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Stored Procedure and Sequence Generator, Sorter
• Configured single-pass reading to reduce the number of times the Integration Service reads sources
• Optimized filters to maximize session performance, only process records that belong in the pipeline
• Interacted with the users and making changes to Informatica mappings according to the Business requirements.
• Created UNIX shell scripts for Informatica jobs automation
• Analyzed sales/spend data and provided quantitative analyses across markets, business units and functions

Environment: Informatica Power Center 8.6, Informatica Power Exchange, Teradata, BTEQ, Autosys, Oracle 10g, Windows NT, HP UNIX, Toad

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Upgraded Informatica from version 7.x to 8.x for data warehouse
• Involved in the design of customer loan data warehouse
• Developed DOS command scripts for running Informatica jobs and to implement pre-session and post-session tasks
• Developed complex stored procedures to implement the routing logic
• Designed ETL process flow for entire DWH application and developed data mapping spread sheets to define transformation rules for each stage of ETL process
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Involved in debugging mappings, recovering sessions and developing error-handling methods
• Used SQL SERVER Data transformation service (DTS) to load data
• Worked with Terabyte data volumes, Optimized the sessions, mapping to achieve the best performance, and to load the data in a specified time window
• Worked in pre and post production environments providing 24x7 production support

Environment: Informatica 7.x/8.x, Business objects 5.1, Infoburst 1.5, Mainframe DB2, Oracle10g/9i, SQLServer2000, PL/SQL, Teradata, Solaris 8.0, Windows XP/2000/2003, HP-UNIX, T-SQL,DTS

Confidential, St. Louis park, MN

ETL Developer

Responsibilities:

• Worked in all phases of project life cycle (Design, Development, Testing and Production Support)
• Worked with the Business Analysts to gather Requirements and to implement business
• Developed several Complex Informatica Mappings using filter, expression, look up, joiner, and update strategy transformations
• Worked on Informatica Power Exchange to pull Policy data from SAP system
• Helped in Migration from version 7.1 to version 8.x of Informatica Power center.
• Identified the bottlenecks and helped in optimizing ETL performance
• Cleanse the source data, extract and transform the data based on business rules
• Created and Scheduled Sessions and Batches through the Informatica Server Manager
• For better performance, created partitions, SQL Over ride in source qualifier
• Worked on Informatica Power Analyzer 3.5 to generate Reports having functionality such as Slice and Dice, Master/Detail, Charts/Plots and Formulas
• Wrote Unix Scripts for event automation

Environment: Informatica Power Center 8.x (Informatica Server Informatica Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), Informatica Power Exchange, SQL Server 2000, SQL Server 2005, Oracle 10g Windows NT, Query Analyzer