SUMMARY

• Around 7 years of experience in Information Technology with special emphasis on design & development of Data Warehousing.
• 7 + years of strong Data Warehousing experience using Informatica Power Center 6.x/7.x/8.x/9.x (Designer, Workflow Manager and Repository Manager).
• Strong skills in various data bases like Oracle, DB2, Terdadata, Netezza, SQL server.
• Expertise in in design and development of ETL processes for large Data warehouse as well support production code base.
• Experience in developing Strategies for Extraction Transformation Loading (ETL) mechanism.
• Experience in performance and data quality validation on new and existing packages, mappings and workflows.
• Expertise in system study, analysis, design, development, testing, implementation, maintenance and enhancement, and documentation of various application systems.
• Experience in executing unit tests and validate expected results; iterating until test conditions until they have passed.
• Expertise in problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production.
• Strong skills in performance tuning ETL process and recommend and implement ETL tuning techniques.
• Worked on Informatica B2B Data Transformation studio to generate xml messages.
• Strong Data warehousing skills, used ERWIN to create datamodels.
• Able to work independently with other IT support as well us users for operational support.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, B2B Data Transformation studio

BI/OLAP Tools: ReportNet 1.1/1.0 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos EP Series 7.x (Impromptu, PowerPlay, Transformer)

Database: Oracle 10G/ 9i/8i/7x, SQL Server 2000/7.0, UDB/DB2 V 8.x/7.x, Teradata, Sybase 11,Netezza

Modeling: Power Designer 6.0, Erwin 7.0/4.0/3.5, Oracle Designer 2000

Languages: C, SQL, ASP, PL/SQL, Korn Shell Scripting, HTML, VBScript, JavaScript, XML

Tools: Putty,FTP Pro, Quest Central for DB2, TOAD, SQL Navigator, SQL*Loader

Version Control: CVS, PVCS, Harvest.

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn,NY

Sr. Informatica Developer

Responsibilities:

• Analyzed existing Database structures, file systems and other sources of data like xml, flat files etc.,.
• Worked with Business Analysts and Architects in gathering the requirements and designed th Source to Target Mapping Documents.
• Performed gap analysis of legacy and new systems, and developed conforming dimensions, based on business requirements.
• Used technical transformation document to create data conversion rules (from legacy to target).
• Prepared Data conversion scripts using various transformations in informatica .
• Used Sequence Generator to create Dimension Keys and Update Strategy to insert records into the target table in staging and Data Mart.
• Used Parameter files to initialize workflow variables, Mapping parameters and mapping variables and used system variables in mappings for filtering records in mappings.
• Implemented Slowly Changing Dimensions - Type I,II mappings as per the requirements.
• Designed, Developed, tesed and deployed mapping s using various Informatica Transformations like Union, Joiner, Expression, Lookup, Aggregate, Filter, Router Normalizer, Update Strategy, etc.
• Involved in the performance tuning of Informatica mappings, mapplets, and Reusable transformations and analyze the target based commit interval for optimum session performance.
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications .
• Used xml generator, UDT transformations to generate xml messages.
• Used mapper in B2B Data transformation studio to parse xml to xml message.
• Performance tuned the workflow by identifying the bottlenecks in sources, targets, mappings and sessions.
• Developed procedures in SQL Server and concepts such as common table expressions, nested sub queries, indexed views, table partitioning and aggregate functions.
• Troubleshoot issues in reports related to data or formatting and used ad-hoc queries to investigate data issues in relational source systems.

Environment: Informatica Power Center 8.6.0/9.1 Tools (Designer, Workflow Manager, Workflow Monitor), Informatica B2B Data Transformation studio, Oracle 9i/10g, Sql server 2005, Toad 9.5

Confidential, Dover,NH

Informatica ETL Developer

Responsibilities:

• Worked with Business Analysts, functional lead to gather, analyze and document the Business requirements.
• Involved in data analysis and documented the technical requirements.
• Developed models using Erwin Data modeler and Created data mart models from multiple data sources
• Identified mismatches between the data, metadata, documented definitions from source systems and developed a comprehensive report for data management purposes
• Involved in creating reusable logic (SQL script) for selecting dates from diff history tables and also created reusable transformation for creating effective end dates.
• Wrote PL/SQL procedure to create a control file.
• Implemented performance tuning for reducing throughput time.
• Wrote shell scripts and called them from workflows to extract flat files from FTP.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows.
• Implemented performance tuning on Aggregator, Sort, Rank, Join Transformations.
• Worked with Slowly changing transformations, Type 1 dimension, Type 2 Dimension, Type 3 Dimension.
• Documented standards for Informatica code development and prepared a handbook of standards
• Scheduled walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle

Environment: Informatica power center v.7.1(power center Designer, workflow, Workflow Monitor), Informatica Metadata Manager, Oracle 9i, DB2, PL/SQL, HTML, Putty(Unix shell scripting), Erwin 4.x. Cognos Series 7.3 Impromptu and Cognos Series 7.3 PowerPlay Transformer and PowerPlay.

Confidential, Hartford,CT

ETL Consultant

Responsibilities:

• Extensively involved in different team review meetings, conferences with remote team.
• Worked on the logical and physical design of the Data warehouse. Identified sources/targets and analyzed source data for dimensional modeling.
• Extensively involved in designing and developing of Star Schema Model for Data Store.
• Responsible for modularizing/design and assigning the work to various team members. With a team of 6 ETL developers, 2 Report Developers, 1BA.
• Responsible for development and ontime deliverables of business releases from technical aspects.
• Responsible for review and sign-off of design, coding and test results
• Improved existing performance on the database tier by creating necessary views and indexes.
• Improved application tier performance by emphasizing operations like joins, aggregations and lookups using SQL overrides.
• Extensively used ETL to load data from Mainframe Datasets & Flat files Source, XML/XSD/DTD sources to Oracle DB Server.
• ETL design provided for error detection and handling by performing necessary validations. File / unit / account rejected accordingly on error detection.
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy, Lookup (Connected and Unconnected) to load the data.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Working closely with DBA in creating the Tables, Indexes, Materialized views, Table Partitioning, Index Rebuilds, Parallel Threads etc.
• Developed UNIX shell script to migrate source files from a staging area, archive files, schedule and trigger Informatica workflow runs and update logs on operations performed.
• Prepared test cases/test scripts/test data for stress and integration testing.
• Administered the Informatica Power Center v7.1.
• Maintained and enhanced the existing the Catalogs and reports developed using Cognos 7.3
• Trained end-users with Cognos( Query Studio) and provided Production support
• Developed Various complex List, Cross tab, List report and Free Style reports using Report Studio
• Developed various Production Plan, Sales Forecast, Demand Management, Material/Constraints, BOM Reports using Report Studio that helped users to make day to day business decisions
• Responsible for Integration / System testing and promote to production
• Trained end-users with Cognos( Query Studio) and provided Production support

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, Cognos 7.3 (Impromtpu), Erwin 4.x, IBM AIX5.2, UNIX shell scripting, Visio 2003.

Confidential, Charolette,NC

Informatica Developer

Responsibilities:

• Analysis of requirements, existing system, Identification of required dimensions and facts
• Extracted data from different sources like SQL Server 2000, Oracle and Flat files to load into ODS
• Generated Entity-Relationship diagrams based on actual values and relationships in source data
• Identified mismatches between the data, metadata, documented definitions from source systems and developed a comprehensive report for data management purposes
• Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy
• Developed complex mappings to implement Type1 and Type 2 slowly changing dimensions.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
• Created pre/post session Stored procedures to drop, recreate the indexes and keys of target tables
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides
• Performed data validation, reconciliation and error handling in the load process
• Migrated the mappings and workflows from the development server to the Test Server to perform the integration and system testing
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings
• Developed, executed, documented test cases, test plans for integration and system testing
• Scheduled and monitored transformation processes using Autosys and UNIX scripting.
• Generated various reports Cognos as per the client's requirements.
• Integrated the Informatica workflows using PowerCenter Connect.

Environment: Informatica PowerCenter 6.2/5.1, PowerMart 6.2, Informatica PowerConnect, (Repository Manger, Designer, Server Manager), Erwin 3.5.x, ETL, Flat files, SQL Server 2000, Oracle 9i, PL/SQL Developer, DDL, UNIX (Solaris), Windows NT, Cognos Impromptu 7.0, SQL * Loader, Unix scripting, Windows NT

Confidential

Junior Informatica developer

Responsibilities:

• Root-cause analysis for all the incidences reported by client.
• Analysis of Change requests and enhancements provided by the client.
• Preparation of Unit Test Cases and test results as per the requirements.
• Preparation of Identification and Correction scripts.
• Making changes to existing Oracle procedures, packages.
• Writing new Oracle procedures and packages whenever required.
• Used informatica 6.2 to transform oracle packages and procedures into Informatica.
• Created informatica mappings, workflows and deployed code to integration and QA tiers.
• Performed unit testing and debugged code to fix issues.
• Preparation of requisite documentation and performed code review.
• Assisted testing team by fixing issues in various environements.

Environment: Oracle 9i, D2K forms and reports, PL/SQL Developer,Informatica 6.2.