SUMMARY

• Over 7 years of IT experience in system analysis, design, development of software applications and experience in the field of ETL methodologies, business intelligence and data Warehousing principles and architectures including concepts, designs and usage of data warehouses and data mart
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and vice versa
• Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality
• Strong knowledge and Experience in using Informatica Power Center ... ETL tool
• Experience in developing Transformations, Mapplets and Mappings using Informatica Designer to implement business logic
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems
• Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards.
• Extensive database experience and highly skilled in SQL, Oracle, MS SQL Server, DB2, Teradata, Sybase, Mainframe Files, Flat Files, MS Access.
• Skilled in SQL, PL/SQL, SQL*Plus, TOAD, SQL Assistant
• Certified informatica developer
• Proven ability to work efficiently in both independent & collaborative environments with Excellent interpersonal and communication skills.
• Innovative thinking and strong problem solving and analytical capabilities

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter5.x/6.x/7.x/8.x/9.xPower Connects and Informatica APP

OLAP/DSS Tools: Business Objects 6.0

Database Modeling: Erwin 4.0/4.1

Databases: Teradata,Oracle7.x/8.x/9.x/10g,SQLServer 7.0/2000/2003 , Multi - Dimensional (OLAP), SFDC, DB2.

Languages: SQL, PL/SQL

DB Tools: Teradata SQL assistant, SQL* Plus, SQL* Loader, SQL*Forms

OS: MS-DOS 6.1, MS-WINDOWS 95/98/XP,UNIX

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Sr. Informatica Consultant

Responsibilities:

• Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
• Interacted with Source system SME’s to analyze how various business processes have been tracked across the source tables.
• Designed Data warehouse target tables by using Dimensional Modeling Techniques - Star and Snowflake Schemas. Created Dimensions and Fact tables using Erwin.
• Extracted data from various data sources such as Flat file, DB2 and transformed and loaded into targets using Informatica.
• Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Designed and developed initial and incremental data loads using Informatica.
• Designed and Developed several Mapplets and worklets for reusability.
• Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.

Environment: Informatica Power Center 8.6, SQL Server 2008R2, DB2, Flat files, SharePoint, Windows 7 Professional, UNIX, Shell Scripting.

Confidential, Wilmington, DE

Sr.Informatica ETL Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Worked on multiple projects using Informatica developer tool (IDQ) of latest versions 9.1.0 and 9.5.1.
• Involved in migration of the mapps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements
• Worked on different environments with different source and target databases like Teradata, DB2, and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into teradata and DB2 databases.
• Resposible for migration of the work from dev environment to testing environment
• Responsible for solving the testing issues.

Environment: Informatica Power center 9.1/9.5-HotFix 4, IDQ ... Hotfix 2.0, SQL Server 2008, Teradata 13.1, DB2, IBM MainFrames, UNIX, Windows NT, SQL Assistant 6.2.1.

Confidential - Wilmington, DE

Sr. Informatica Developer

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Worked on dimensional modeling to Design and develop Star Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Design ETL processes using Informatica tool to load data from Oracle source systems and Flat files into Oracle Target database
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i/10g.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Used Informatica Repository Manager to create Repositories and users and to give permissions to users.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Performed Unit testing and verified the data.
• Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment: Informatica Power Center 8.6, Flat files, XML files, Oracle10g, SQL Server, UNIX, PL/SQL, Windows 2005/08

Confidential, Louisville, KY

Informatica Consultant

Responsibilities:

• Installed and configured Power Center 8.6 Client/Server components on Windows & UNIX.
• Created reusable metadata by making the Shared Global Repository objects.
• Created, scheduled and monitored batches and sessions using Power Center - Server Manager.
• Involved in data migration procedure and mapped data from legacy systems to new existing systems for providing a design for data extraction and data loading.
• Worked with SAP and Oracle sources to process the data.
• Built variety of prototypes to Extract, Transform and Load data from and to SAP using Informatica Power Connect.
• Created SAP BW OHS source definitions in Informatica and configured work flow to run from SAP process chain.
• Determine Extraction and Loading techniques from and to SAP, also from Non-SAP sources to SAP using Informatica Power Exchange v8 for SAP Data Integration.
• Responsible to tune ETL procedures and Star Schemas to optimize load and query performance.
• Created and executed sessions & batches using Server Manager to load the data into the target database.
• Developed interfaces using Shell Scripts to automate the bulk load & update the processes.
• Worked on Database Triggers, Stored Procedures, Functions and Database Constraints.
• Wrote complex stored procedures and triggers and optimized them for maximum performance.

Environment: Informatica Power center 7.x/8.5, Informatica Power Exchange, Oracle 9i/10G, ERWIN 3.5.2, PL/SQL, COBOL, MS Office, SQL Server 2000.

Confidential - NJ

Informatica Consultant

Responsibilities:

• Configured Informatica Repository Manager to manage all the repositories of various applications. Created users, user groups, security access controls.
• Planned and designed the flow process of the data stored in the repository, in the form of metadata.
• Designed and constructed the Star Schema. Wrote procedures, functions in PL/SQL.
• Designed and created mappings using Mapping Designer.
• Worked extensively on performance tuning by making changes to SQL in Source Analyzer. • Used various Informatica transformations like expressions, filters, joiners, aggregators, routers and lookups to load better and consistent data into the targets.
• Used Mapping Designer to join tables from various databases like Oracle, SQL Server, and DB2.
• Designed and developed catalogs by creating links between the Fact table and the Dimension table to form a Star Schema.
• Used TOAD to FTP file moving processes to and from source systems.
• Created scheduling of jobs in Workflow Manager to trigger tasks on a daily, weekly and monthly basis.
• Wrote shell scripts to join or concat target files, to delete or remove one or more such files if not needed after joining, and etc.
• Monitored the production loads and fixed them, when necessary.
• Involved in the Performance Tuning of Informatica servers and other legacy databases.

Environment: Informatica 7.1/8.6, Oracle 9i/10g, PL/SQL, SQL Server, DB2, MS Excel, UNIX Shell Scripting, TOAD 8.5.

Confidential

Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements.
• Created users/groups and folders using Repository Manager.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Extracted Source Data using Informatica tools and stored procedures from source systems.
• Developed transformation logic and designed various Complex mappings using the Designer.
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility.
• Involved in Fine-tuning the informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.

Environment: Informatica Power Center/ Power Mart 7.1/6.2, Oracle 9i/8i, SQL*Plus, TOAD, IBM DB2 8.0, Erwin 4.0, Sun UNIX 8, Windows NT, PL/SQL Developer.