SUMMARY

• Over 8 years of IT experience, which includes Analysis, Design, Development, and Testing under Business Intelligence and Client - Server environment.
• Over 7 years of experience in design and development in ETL tools.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball Methodology.
• Strong experience in Designer tools like Source Analyzer, Target Designer, Transformation Developer, Mapping and Mapplet Designer along with Workflow Manager and Monitor tools.
• Excellent knowledge in data warehouse development life cycle including Software Development Life Cycle (SDLC), Relational and dimensional modeling, repository management and administration and implementation of slowly changing dimensions.
• Strong understanding of teh principles of DW using fact tables, dimension tables and star schema modeling.
• Expert in writing critical ETL stored procedures that extract data from different data feeds, transform and load into database that is used by business users in teh form of reports.
• Expertise in working with relational Databases i.e. DB2 UDB 9.6/9.7, Oracle 11g/10g/9i, SQL Server 2005/2008 and ERP Systems which include SAP and PeopleSoft.
• Expert in designing and developing backend PL/SQL packages in database layer, functions and triggers.
• Extensive experience in Requirement Gathering, Customization, Maintenance and Implementation of various Business Applications.
• Hands on experience in resolving errors using Debugger, Log files of Session & workflows, Output Window.
• Extensive experience in writing SQL and PL/SQL scripts as per teh requirement. Efficient in trouble shooting, performance tuning, and optimization ETL Mappings.
• Expert in developing complex test cases and performing unit and integration testing.
• Experienced in gathering user specifications, design and development and smooth integration of teh application.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/ 8.6.1/8.6.0/7.1/6.2 (Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplet Transformations, Workflow Monitor, Worklet Designer), Informatica Power Exchange 8.6.1/9.0.1 , Informatica B2B Data Exchange, Informatica MFT (Manage File Transfer), Informatica DVO (Power Center Data Validation option), Informatica Power Mart 5.1.1/5.0/4.7.2 , Informatica Power Analyzer, Metadata, Data Mining, Data Mart, OLAP, OLTP, Oracle Data Integrator (ODI).

Data Quality: Informatica Data quality.

Data Modeling: ERwin 4.1, 7.2, MS Visio 2003, Star and snowflakes modeling, Fact and Dimension Tables.

ETL application Server: UNIX Solaris / Windows 2000 Server

BI tools: OBIEE, BI publisher/XML, Cognos Event Studio

Programming: Unix Shell Scripting, SQL, PL/SQL, Transact SQL

Source & Target Systems: DB2 version 9.5, Oracle8i/ 9i/10g/11g, Teradata, MS SQL Server 2000/2005/2008 (SSIS, SSRS, SSAS), Informix, XML files, Flat files

Utilities: TOAD for DB2, IBM DB2 Command line tools, IBM Rational Clear quest, TOAD for SQL Server, SQL Developer, Putty, Transact SQL Designer2000, Rapid SQL Erwin Data Modeling tool, MS SQL Server 2008, Tortoise SVN.

PROFESSIONAL EXPERIENCE

Confidential, Newark, CA

Sr. Informatica Developer

Responsibilities:

• Worked with business Analysts and Architects to get teh functional specs and design documents in order to get a better understanding of teh user requirement.
• Developed new and customized existing mappings and bought in data into data warehouse.
• Extensively used flat files as source table and loaded data into database tables.
• Created mapping document with all teh necessary fields which helps to develop or customize teh mappings more efficiently.
• Used several transformations in Power center Designer to build a mapping.
• Extensively used mapping variables, mapping parameters and parameter files in ETL mappings.
• Involved in code deployments while pushing from one environment to teh other using Repository Manager.
• Extensively used connected and unconnected lookups, Update strategy, Router transformations in teh mapping to bring in new fields into target table.
• Used various inbuilt functions like Date, Character, Special functions to calculate new fields in teh mapping using power center Designer tool.
• Modified existing mapplets, added new lookup and expression transformations and used those mapplets in teh mapping.
• Used TFS to check in Informatica code.
• Client web application(Upload Utility) is used to extract teh data from teh sql server to flat files.
• Responsible to monitor data during teh daily and weekly loads and fix teh issues related to load failures.

Environment: Informatica Power Center 9.x, Workflow Manager, Workflow Monitor, Repository Manager, windows 2003 server, TFS, Squirrel, Mongo, Micro strategy.

Confidential, Seattle, WA

Sr. Informatica Developer

Responsibilities:

• Actively involved in understanding teh environment and teh business requirement.
• Worked closely with teh Users in order to understand teh requirement and performed Gap Analysis.
• Informatica Designer tools are used to design teh source definition, target definition and transformations to build mappings.
• Developed and implemented Error Handling Strategies
• Worked with mapping wizards for slowly changing dimensions and slowly growing dimensions by using Informatica mapping designer.
• Extensively used mapping variables, mapping parameters and parameter files in ETL mappings.
• Customized mappings like invoice distributions fact, purchase cycle lines fact and purchase schedule lines fact in order to add new columns.
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica Power center.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing teh development time.
• Worked with Informatica Deployment Groups in migrating teh ETL code across environments.
• Responsible for Optimization of Informatica mappings, sessions, SQL queries.
• Written and fixed various Oracle Stored procedures.
• Designed and developed teh OBIEE Repository (.rpd) by importing teh required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Created logical column aggregations with complex calculations using teh inbuilt functions and expressions.
• Creating Materialized views in OBIEE Repository and maintaining teh security for business units based on their roles and responsibilities.
• Create Dashboard reports in Oracle OBIEE Dashboard environment for various business units. Provide technical support by customizing and enhancing existing application set ups.
• Configured presentation layer used by different User groups and also established teh various standard queries, in order to support teh presentation layer.

Environment: Informatica Power Center (9.x, 8.x), Designer, Workflow Manager, Workflow Monitor, Repository Manager, Oracle BI (10.1.3.x), Windows Server 2003, Linux, DAC, Oracle 11g, Windows 2003 server, Toad for Oracle, Oracle SQL developer.

Confidential, Billerica, MA

Sr. Informatica Developer

Responsibilities:

• Extensively involved in System Study & Business Requirement Analysis.
• Informatica Designer tools are used to design teh source definition, target definition and transformations to build mappings.
• Used Shell Script to execute post-session and pre-session commands.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Created stored procedures to validate teh data before loading data into MDM data mart.
• Worked on B2B data Exchange to create new Partner/Accounts, profiles, Endpoints, Workflows and generate flat files for Data Exports.
• Used Informatica MFT(Manage File Transfer) tool to export teh files to Partner location via SFTP.
• Performed validation activities and responsible for preparing and reviewing Test scripts.
• Used DVO tool to run teh Automatic tests on teh files produced through B2B processes.
• Maintained security by assigning permissions to reports and dashboards based on users and groups.
• Slice and Dice data using filters and used pivot tables, charts and Narrative views for better presentation.
• Used different parameter variables in teh template in order to display dynamic data in teh reports.
• Extensively worked on different views like chart, table and pivot to generate teh reports according to teh requirement.
• Integrated Oracle BI Publisher with front end tool and generated Adhoc reports in pdf format.
• Involved in unit testing and migrating Publisher reports from one environment to teh other.

Environment: Informatica Power center 9.0.1, Workflow Designer, Powercenter Designer, Repository Manager, Informatica B2B Data Exchange, Informatica MFT(Manage File Transfer), Informatica DVO (Power Center Data Validation option), Oracle 11g, XML, Windows and UNIX, MS SQL Server 2008, Tortoise SVN, Toad 10.6, SQL developer .

Confidential, Dallas, Texas

Informatica Developer

Responsibilities:

• Involved in teh design reviews to understand teh data structures in different source applications and to understand teh existing EDW architecture and standards.
• Extensively involved in teh ETL design meetings to come up with teh strategies to pull data from multiple source applications (Incremental or Full extracts) into EDW staging and then to Dimensions and facts in teh star schema.
• Developed PL/SQL programs and Informatica mappings to extract incremental data from different sources to teh EDW using Informatica Power Exchange.
• Used Informatica session variables/parameters and source audit tables for incremental data extracts from source applications.
• Staged data into stating tables from source database by following standard naming conventions.
• Utilized debugger functionality in designer to test teh mapping and fixed teh code.
• Extracted data from staging tables and loaded into EDW Dimensions and Facts.
• Created various mappings to load dimensions and facts like customer dimension, Sales Fact etc.
• Responsible for creating mapping documents which helps in creating mappings efficiently.
• Extensively used mapping variables, mapping parameters and parameter files in ETL mappings.
• Used different transformations such as Joiner, Expression, Lookup, Router, Union, Update strategy and stored procedure transformations to process data to teh EDW reporting layer.
• Prepared high level and low level technical documentations and unit test cases.
• Designed, developed and documented teh methodologies for integrating data from different applications to EDW.
• Identified dependencies and Integrated different Informatica jobs such as sessions, work lets, command tasks, event waits, decision tasks and email tasks to build initial and daily loadworkflows.
• Worked with production support team and coordinated in moving mapping objects from Development to test, production environment.

Environment: Informatica Power Center 8.1.1, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Oracle BI (10.x), Windows 2003 server, Erwin, Oracle 10g, Toad,People Soft, SQL Server 2005, DB2.

Confidential, Boston, MA

Informatica Developer

Responsibilities:

• Created teh mappings according to teh design documents.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Lookup, Filter for developing mappings.
• Implemented performance tuning logic on Targets, Sources, Mappings, Sessions to provide maximum efficiency and performance.
• Implemented Error handling logic to capture teh invalid data.
• Analyzed teh database star schema structure.
• Responsible for optimizing teh ETL mappings and monitoring teh load process in order to check teh data.
• Designed reusable transformations and mapplets.
• Studied teh data requirements and teh impact analysis on teh existing schema.
• Created dimensions model star schemas using Kimball’s methodology schema using Erwin.
• Analyzed teh requirements and created teh dimension model using ERwin.
• Defined data definitions, and created target tables in teh database.
• Built some complex queries using SQL and wrote stored procedures using PL/SQL.
• Extensively worked in creating database triggers, exception handlers, cursors, and cursor variables.
• Mapping teh source and target databases by studying teh specifications and analyzing teh required transforms.

Environment: Informatica Power Center 7.x,Designer, Workflow Manager, Workflow Monitor, Repository Manager, HP-UX 11.0, Windows 2003 server, Oracle 10g, Toad.

Confidential, Rockville, MD

ETL Developer

Responsibilities:

• Responsible for gathering teh user requirements and converting teh same into technical specifications.
• Responsible for designing of transformations, mappings and workflows to implement teh business logic.
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Worked on loading techniques like SCD’s and incremental loading for extraction, transformation and loading of teh data.
• Worked extensively with various passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator and Lookup Transformation.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last and Count in teh Aggregator Transformation.
• Extensively used SQL override in teh Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join and Master Outer Join in teh Joiner Transformation.
• Created connected and unconnected Lookup transformation to get teh related values.
• Responsible for performance tuning of Sources, Targets, Mappings and SQL queries in teh Transformations.
• Developed Korn shell scripts to invoke back end SQL and PL/SQL programs.
• Developed Korn shell scripts to schedule loading of flat files on daily, weekly and monthly basis.
• Responsible to keep production test machine in sync with production.
• Wrote test plan documents and unit testing for application modules.

Environment: Informatica Power Center 7.1, Oracle 8i/9i(Enterprise Edition), ERwin, SQL*Plus, SQL*Loader, Toad, UNIX, Windows NT.

Confidential

Oracle Developer

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Designed teh Entity-Relationship model and normalized database
• Created packages for initial load and daily updates.
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining integrity constraints and implementing teh complex business rules.
• Involved in First Level Testing: Unit Testing and Integrated Testing with multiple Components.
• Tuned SQL queries and performed refinement of teh database design leading to significant improvement in system response time and efficiency.
• Troubleshooting day to day database issues.