EXPERIENCE SUMMARY:

• 15 years of experience in the Information Technology (IT) industry with specialization in the Analysis, Design, Data Modeling, Development, Testing, Implementation and Maintenance of Data Warehousing/OLAP Reporting Applications.
• Extensive Experience in data staging, database design, decision support system (DSS), Dimensional modeling, data warehouse requirement analysis and Implementation.
• Experience in designing the architecture for Extract, Transform, Load environment and development of mappings and processes using Informatica Power Center and Power Mart.
• Strong Knowledge in Logical/Physical Data model (LDM/PDM), with Normalized/Denormalized Databases on both OLTP /OLAP environment using ERwin 4.0, Designer 2000 and Ms Visio
• Experience in designing Star, snowflake schema and Denormalization techniques.
• Experience in understanding the requirements and creating ETL specifications as per the requirement.
• Exposure to Insurance, Banking, Retail, Finance and Telecommunication sectors with regards to data warehouse development.
• Experience in creating mappings for slowly changing dimensions and incrementing facts.
• Experience in informatica admin related tasks, server startup and shutdown and managing repository.
• Actively involved in Performance Tuning, Backup and Recovery process, product support on various platforms.
• SQL Tuning and creation of indexes for faster database access and better query performance
• Experience in UNIX shell scripting, automation of ETL process and scheduling of jobs using CRON.
• Strong in writing SQL Queries testing and debugging Queries.
• Extensive experience in writing PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.
• Have clear understanding on Business Intelligence and Data warehousing Concepts.
• Experience in dealing with various Data sources like Oracle, SQL Server, Ms - Access, COBOL, Excel, Flat files.
• Strong in Business objects- reporter, supervisor, designer, WebI, ZABO, and Broadcast Agent.
• Excellent analytical and problem solving skills along with strong programming knowledge in Pl/Sql.
• Highly skilled, self-motivated team player, outstanding organizational and excellent communication and interpersonal skills with result oriented dedication towards goals.

TECHNICAL SKILLS:

Data Warehousing (ETL) Tools: Informatica PowerCenter 9.i( since 5.i), PowerMart 4.7.2/5.1/6.2 , Power connect

Programming Language: SQL, PL/SQL, C, C++, Java, and UNIX Shell Scripting.

Databases/DBMS: Oracle 7x/8x/9x, DB2 UDB 9, Teradata 5, SQL server 7.0/2000, Netezza

Operating Systems: Unix/Solaris/HP, AIX,Windows XP/2000/NT 4.0/95

Reporting(BI) Tools: Business Objects 5.x/6.1(Supervisor, Designer, Reporter)BCA, ZABO, Cognos 6.5 (web Reports Power Play, Transformer), Reportnet and framework manager Actuate Reports.

Data modeling Tools: Erwin 4,7,8, Visio

Testing Tools: Test director 8

Database tools: TOAD, SQL DEVELOPER, SQL Navigator 4.1,Quest and AQT

Other tools: I2-FP, Servigistics,Autosys,Winscp

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Environment: Informatica 9.1. DB2 UDb 9.1, Oracle 9i, Quest, SQL*Loader, UNIX Shell Scripting, Erwin, ESP and Toad

Sr. Informatica Architect /Data Modler/Informatica Admin

Responsibilities:

• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Data Modeled for both Finance Data warehouse as well as other projects.
• Leading efforts in designing and implementation of client information using dimension model techniques.
• Designed and developed end-to-end ETL process for Sales and Material Data Mart.
• Involved in creation of repositories, groups users and assigning privileges using Repository Manager.
• Creation of users and groups, configured profiles and privileges. Created folders and configured folder security. Configured shared folders for re-usable objects.
• Migrated informatica Meta data from one repository to another repository using static/dynamic deployment groups.
• Participated in informatica server start up and shutdown process and managing repository.
• Extensively used Power Connect for SAP R/3 to source master data into DB2
• Executed sessions, tasks, sequential and concurrent batches for proper execution of mappings.
• Customized the Source Qualifier in Informatica with basic ABAP code to extract only the required data from SAP R/3.
• Created workflows, commands and created pre and post session scripts as required.
• Supporting Vehicle Tracking system and SAP main for on call
• Installed, configured, troubleshoot and administered Informatica.
• Involved in upgrading informatica from 32 bit server to 64 bit server
• Documented the implement check list and also blackout plan in server up gradation and migration
• Involved in writing the UNIX shell scripting, automation of ETL process and scheduling of jobs using CRON and autosys scheduling.

Confidential, Renton, WA

Environment: Informatica 7.1, Netezza,Oracle 9i, SQL*Loader, UNIX Shell Scripting, Erwin and Toad

Sr. Informatica Architect

Responsibilities:

• Collecting requirements, analyzing data, design and development of Data warehouse
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Leading efforts in designing and implementation of client information using dimension model techniques.
• Designing Logical/Physical Data Model (LDM/PDM) using Erwin 4.0/3.5.
• Forward and Reverse Engineered Data models for database creation.
• Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• Created mappings using the Transformation like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created workflows, commands and created pre and post session scripts as required.
• Used NZLOAD (equal to SQLLOAD) to load the data from log files to Stagging Area.
• Involved in writing the UNIX shell scripting, automation of ETL process and scheduling of jobs using CRON

Confidential, Chicago, IL

Environment: Informatica 6.2, Oracle 9i, SQL*Loader, UNIX Shell Scripting, Erwin and Toad

Sr. Informatica Architect (Subject Matter Expert)

Responsibilities:

• Involved in Full life cycle design and development of Data warehouse
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Leading efforts in designing and implementation of client information using dimension model techniques.
• Designed Logical/Physical Data Model (LDM/PDM) using Erwin 4.0/3.5.
• Forward and Reverse Engineered Data models for database creation.
• Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• Imported sources and targets into Informatica and created shortcuts.
• Created mappings using the Transformation like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created workflows, commands and created pre and post session scripts as required.
• Used constraint based loading to load the targets.
• Performed partitions on the sources to improve the performance
• Used SQL*Loader for Bulk Loading
• Involved in writing SQL, Stored procedures and debugging them.
• Involved in writing the UNIX shell scripting, automation of ETL process and scheduling of jobs using CRON
• Developed ETL process for the integrated data repository from external sources.
• Involved in the mappings documentation.

Confidential, Chicago, IL

Environment: Informatica 7.1, Oracle 9i, Servigistics,SQL*Loader, UNIX Shell Scripting, Erwin and Toad

ETL Architect

Responsibilities:

• Understand the Requirements and document it.
• Design specification and preparing low level design document.
• Worked, as a Technical Architect responsible for Informatica and Writing Extraction, Transformation and Loading (ETL) routines using Informatica
• Used Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings
• Developed ETL process for the integrated data repository from external sources
• Document Unit test case and results.
• Created User Defined Reports
• Understanding the Business requirements, Servigistics system forecast and procurement recommendations.
• Involved in writing the UNIX shell scripts.
• Scheduled the workflows and automated the process

Confidential, Chicago, IL

Environment: Windows NT, Unix HP, Oracle 9i, Informatica 6.2, I2-FP, SQL*Loader, UNIX Shell Scripting, Erwin and Toad

ETL Architect

Responsibilities:

• Involved in understanding the business and the required analysis for the data mart design.
• Involved in identifying different methodologies for ETL to extract, transform and load into the target area.
• Involved in designing star schema and using denormalization techniques.
• Involved in populating the fact tables
• Created source and target definitions in the warehouse designer.
• Involved in creating mappings in the mapping designer.
• Involved in using slowly changing dimension techniques using lookup and update strategy.
• Used various transformations in the mapping designer like joiner, expression, Aggregator, Sorter and Router.
• Involved in writing SQL, PLSQL Stored Procedures, functions, triggers, packages.
• Created reusable transformation and mapplets in Power center 6.
• Involved in writing UNIX shells in pre and post sessions to update files before and after sessions.
• Involved in testing and debugging SQL queries and stored procedures.
• Create Informatica mapping using Power Center 6 to load the data in data warehouse.
• Used Debugger to detect the bugs in the logic and fixing them. .
• Creating and scheduling sessions and batches to load the data mart.
• Involved in performance and maintenance activity of the mappings and the configuration tables.
• Involved in the mappings documentation.

Confidential, Charlotte, NC

Environment: Business objects 5.1, Informatica 6.2, Tera data, SQL*Loader, windows 2000, Unix Shell Scripting, Erwin 4, SQL server

Data Modeler/Data warehouse consultant

Responsibilities:

• Understanding the requirements and the elements required for the reporting.
• Analyzed the data coming from different sources and their relationships and created configuration tables.
• Designed Logical/Physical Data Model (LDM/PDM) using Erwin 4.0/3.5.
• Forward and Reverse Engineered Data models for database creation.
• Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts
• Developed programs using T-SQL.
• Developed the architecture for data warehouse - star schema/snowflake model.
• Created the configuration tables to establish relations and used ERWIN for data modeling.
• Responsible for the physical and logical design of the Datamart on Windows NT.
• Involved in creating dimension and fact tables in the database.
• Identified, imported the sources and targets into shared folder and created shortcuts.
• Extensively used mapplets, lookups, Expressions, aggregators, filters, sequence generators and other transformations in the mappings.
• Wrote shell scripts in the command tasks to implement the requirement.
• Created sessions and workflows and populated the data mart with the development data.
• Used debuggers to detect bugs in the mappings with the development data.
• Performed partitions on the sources to improve the performance.
• Enabled incremental loading in fact table mappings and made required changes to the mappings to populate the production data.
• Improving the performance of the mappings by indexing and tuning.
• Created windows batch programs.
• Involved in the design of Universes, Classes, Objects, and Hierarchies for Multidimensional Analysis of the database using Business Objects 5.1 for sales, purchase and finance departments.
• Created Master-Detailed reports using Drill down/up functionality for the Decision Support System regarding to the companys products.
• Created Joins, Contexts, and Aliases, for resolving Loops, and checked the Integrity of the Universes.
• Created user manuals for the user to go through and understand effectively.
• Created complex reports and published on Web using Web Intelligence.
• Scheduled reports on daily/ weekly/ monthly basis using Broadcast Agent Server.
• Created and managed users/groups and assigned privileges using supervisor module. Exported the universes to the Repository making resources available to the corporate users.
• Collaborated closely with the client managers, architects, DBAs and business users.
• Trained end users in generating Ad-hoc reports

Confidential, Princeton, NJ

Environment: Actuate Reports 7, Informatica 5.1, DB2 UDB 7, SQL*Loader, Windows 2000/NT 4.0, AIX, UNIX Shell Scripting and Erwin 4

Data modeler/ Data Analyst

Responsibilities:

• Understanding the requirements and interacting with the required users.
• Involved in analyzing the requirements, identifying the sources and targets and creating the specifications accordingly.
• Identified, imported the sources and targets into shared folder and created shortcuts.
• Creating the mapping as per the specifications in the Power Center and debugged them.
• Created ETL development standards and implement them.
• Extensively used transformations like lookups (connected, unconnected), expressions, routers, joiners, normalize, sequence generators etc.
• Used debuggers to debug the mapping and correct them.
• Used slowly changing techniques to load the conformed dimensions.
• Written scripts to archive the files and to maintain same naming for the files coming from different machines and also to update the parameter file.
• Created workflows, commands and created pre and post session scripts as required.
• Created scripts to update the parameter files to establish delta extraction.
• Analyzed the exception files using different commands as part of unit testing and fixed the bugs.
• Performed partitions on the sources to improve the performance.
• Involved in improving the performance of the mappings.
• Involved in answering the change requests as part of the integration testing.
• Monitor daily, monthly load processes.
• Improving the performance of the ETL by indexing and caching.