SUMMARY:

• Over 12 years of experience in design, construction, testing, and administration of Enterprise Data Warehouses, Data Marts and Data integration. Hands - on experience leading all stages of system development efforts, including requirements definition, design, architecture, testing, maintenance and support.
• Have 6 years of ETL experience using Informatica Power Center/Power Mart 8.11/7.1/6.2/5. x, Have good experience in Data modeling and Data Analysis using Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Developed Physical & logical data model using ER-WIN 3.x/ 4.x, Rapid SQL (Embarcadero).
• Extensive database experience using Oracle 10g/9i/8i/7.x, MS SQL Server 7.0/2000/2005, Sybase SQL Server 12.0/11.x, DB2, PL/SQL, Multi Load, SQL*Plus, SQL*Loader, Unix, Shell Scripting. Informatica Certified Administrator.

TECHNICAL SKILLS:

Tools: Informatica, DataStage, TrueIntregration 3.5.2 (Trained by the Alexander Group, Inc. ), ER-Win, Crystal Reports, Toad, SQL Assistant, bteq, Visio, HPDC, ServiceNow, PVC

Programming: PL/SQL, T-SQL, MultiLoad, Fastload, Shell Scripting, Perl Scripting, VBScript, Visual Basic, COBOL, C, Java, JCL

DBMS: Oracle, MS-SQL, Informix, Sybase, Access, DB2

OS/ Server: Windows NT, UNIX, Linux, Windows 2000/2005

PROFESSIONAL EXPERIENCE:

Sr Informatica Developer and Administrator

Confidential, Marietta, GA

Responsibilities:

• Identified business rules for data extraction, Parsing high-level design spec to simple ETL coding and mapping standards
• Analyzed the existing process to build the ETL strategy.
• Developed Database Procedures and Functions
• Optimized Query Performance, Session Performance and Reliability
• Standardized the processes, connection objects for sources, targets and lookups following best practices
• Responsible for creating data model and managing meta data based on business requirement.
• Followed standard naming convention and documentation.
• Admin support to Metadata Manager, Installing Metadata Manager Agent, Loading Resources etc.
• Installed and Configuring the Development, Testing and Production Environment for Informatica, applied Service packs, Configured Domain, Node Repository service, Integration Service.
• Responsible for creating and maintaining users, folders and granting privileges.
• Scheduling and minting and Monitoring the ETL jobs
• Backup and restoring the Informatica repository as and when needed.
• Migration of Maps and Workflows from Development to test and to Production environment.
• Created deployment groups and migrated maps, sessions, workflow from Development to QA and from QA to Production.

Environment: Informatica 8.x/9.x - Power center/Proactive Monitor/Metadata Manager, Oracle 10g, Oracle 11i, Teradata V2R6, BETQ, SQL Server 2008/2012, sftp, multiload, fastload, Service Now, HPSD, Erwin 4.1, Windows 2003/XP, Linux

Data warehouse consultant

Confidential, Atlanta, GA

Responsibilities:

• Identified business rules for data extraction, Parsing high-level design spec to simple ETL coding and mapping standards
• Analyzed the existing process to build the ETL strategy.
• Created source, target, lookups, transformations, sessions and define schedules for sessions.
• Deployed new versions of the maps and work flows.
• Scheduling and minting and Monitoring the ETL jobs
• Migration of Maps and Workflows from Development to test and to Production environment.
• Optimized Query Performance, Session Performance and Reliability
• Responsible for creating maintenance scripts for Gift card Process.
• Standardized the processes, connection objects for sources, targets and lookups following best practices
• Designed Exception handling process to capture business exceptions for Merchant Program.

Environment: Informatica 8.1, Pentaho 2.5, Oracle 10g, Oracle 11i, SQL Server 2000/2005, Erwin 4.1, Windows 2003/XP, Linux

Informatica Architect

Confidential, Maritta, GA

Responsibilities:

• Identify business rules for data migration and perform data administration through data
• Responsible for ETL Architecture, Design and Developed complex maps using Informatica to Extract Transform and Load high volume slowly changing dimension.
• Extensively analyzed healthcare data and produced reports. Produced complex SQL queries to analyze the data issues.
• Monitored the data for data availability, data security, reliability, timeliness and completeness of the incoming data. Anomalies were reported for further analysis
• Tuning the Mappings for Optimum Performance.
• Created data base objects like Indexes, Sequence generators, Partitioning and Stored Procedures for accomplishing the Complex logical situations and Memory Management.
• Created the Workflows and scheduled the workflows to run automatically in Window time
• Support implementation of the new data source.
• Scheduling and mainting and Monitoring the ETL jobs
• Automated ETL process for WCH process

Environment: Informatica 8.1.1, SQL Server 2000/2005, Oracle 10g/9.x, Rapid SQL, Windows 2003/XP

Informatica Consultant

Confidential, Alpharetta, GA

Responsibilities:

• Analyzed the source systems, met with end users and business unit requirement in order to define the requirements.
• For NELR system, developed logical & physical data model by defining strategy for Star Schema with Fact & Dimension tables.
• Developed process models, data models, data flow diagrams and ER diagrams.
• Used Informatica as the ETL for extracting data from diverse sources, cleanse, transform the data according to business requirement and loaded the data in the target.
• Identified and tracked the slowly changing dimensions.
• Worked extensively with complex mappings using expressions, aggregators, filters, and lookups.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the data Warehouse.
• Tuning the Mappings for Optimum Performance, Dependencies.
• Created source, target, lookups, transformations, sessions and define schedules for sessions.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Created data base objects like Materialized view, Indexes, Sequence generators, Parallel Partitioning and Stored Procedures for accomplishing the Complex logical situations and Memory Management.

Environment: Informatica 7.1.3, Oracle 9.x, Linux, Erwin 4.1.4, Toad, Business Objects 6.5, Windows 2000

Data modeler

Confidential, Columbia, MD

Responsibilities:

• Requirement gathering and identification of source system.
• Understanding the differences between the business process in TDW and Confidential and done Gap Analyzes
• Standardized Attributes for integration of TDW data and Confidential Data.
• Used Erwin to design the data model and generate the schema for the data model.
• Designed new database tables to meet business information needs. Set Standards for Naming Conventions and Best Practices.
• Created Physical data model for Sales Force.
• Loading the Data from various sources into the Staging area.

Environment: Informatica 7.1.4, Oracle 9.x, Sun Solaris 5.8, Erwin4.1.4, Toad, Windows 2000

ETL Consultant

Confidential, Alpharetta, GA

Responsibilities:

• Collected data requirement from Business analyst in the early phase of the project. Identified business rules for data migration, parsing high-level design spec to simple ETL coding and mapping standards.
• Facilitated JAD sessions with SME (Subject Matter Experts) and end users.
• Design Mapping document, which is a guideline to ETL Coding.
• Extensively used the Expression, Filter, Router, Lookup, Update Strategy transformations, and Reusable Transformations.
• Loading the Data from various sources into the Staging area.
• Designed complex Mappings Using Informatica Designer that populated the Data into the Target Star Schema, which is on Oracle 9i Instance.
• Optimized Query Performance, Session Performance and Reliability.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Created the Workflows and scheduled the workflows to run under the Window time

Environment: Informatica 7.1.2, Sun Solaris 5.8, Oracle 9i, SQL Server 2000, PL/SQL, Erwin3.5.5, Toad, Windows 2000

Data warehouse Architect

Confidential, Tallahassee, FL

Responsibilities:

• Identified business rules for data migration, parsing high-level design spec to simple ETL coding and mapping standards.
• Facilitated JAD sessions with SME and end users.
• Translated data requirement into a logical model and Physical model.
• Created logical model that captures all business rules. Created data dictionary that defined the model with its entities, attributes and relationships. Worked with the development team and DBA team during the design phase to produce the physical model
• Collected data requirement from business analyst in the early phase of the project.
• Designed UML models, followed RUP development methodology and developed use case, sequence diagram, class diagram etc.
• Data Cleansing and Extraction.
• Optimized Query Performance, Session Performance and Reliability.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Handle the Migration process from Development, Test and Production Environments.
• Populating the Warehouse and documentation of existing mapping as per standards.
• Set Standards for Naming Conventions and Best Practices for Mapping Development.
• Created the Workflows and scheduled the workflows to run under the Window time

Environment: Data Stage 5.2, Sun Solaris 2.7, Oracle 10g/9i/8i, SQL Server 2000, DB2, Micro strategy 6.0 Administrator, Agent, Architect, Intelligence Server, PL/SQL, SQL*Loader, Erwin3.5.5, Toad, Windows 2000/XP

ETL Architect

Confidential, Atlanta, GA

Responsibilities:

• Identified business rules for data migration, parsing high-level design spec to simple ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Design mapping document, which is a guideline to ETL Coding.
• Loading the Data from Flat Files and COBOL Copybooks into the Staging area using Informatica Power Center 5.1.
• Migrate Repository from Informatica Power Center Version 5.1 to Version 6.2
• Worked on Informatica Power Center 6.2 tools - Sources Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Optimized Query Performance, Session Performance and Reliability.
• Data Analysis Cleansing and Extraction.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Maintained Shared Folders and Shortcuts, Global Repositories and User Security via Repository Manager.
• Handle the Migration process from Development, Test and Production Environments.
• Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extractions and Local process and monitor sessions using Informatica Server Manager.
• Designed the Slowly Changing Dimension strategy for the Warehouse.

Environment: Informatica 5.x, Power Center 6.2/5.1, Sun Solaris 2.7, Oracle 9i, SQL Server 2000, DTS, T-SQL, DB2, UDB, VSAM, Micro strategy 6.0, PL/SQL, SQL*Loader, Erwin3.5.5, Windows 2000/XP

Data Warehouse Analyst

Confidential, Tampa, FL

Responsibilities:

• Designed and built DataMarts for Power, Gas and Turbines and underwriting divisions.
• Created temporary repository for already migrated database for system analysis.
• Created Session and batch management and performance tuning and initial testing followed by the volume testing, resolve technical issues with software consultants and vendors.
• Populating the Warehouse and documentation of existing mapping as per standards.
• Written SQL Stored procedures and Shell Scripts to access data from MS SQL Server 6.5, DB2 6.1, and UDB 7.0.
• Customer interaction and User Training for ongoing Maintenance.
• Design new database tables to meet business Informatica needs. Design of Mapping
• Specification and creating multidimensional models.
• Star Schemas are designed using ERWIN 3.5.2.

Environment: Oracle 8i, MS SQL Server 7.0, PL/SQL, SQL*plus, SQL* Loader, MS Excel, Microstrategy, DB2, UDB, Erwin 3.x, Windows NT/2000, 4.0, AIX.