SUMMARY:

• 7+ years of progressive IT experience in Analysis, Modeling, Design, Development, Implementation, testing and maintenance of Database and Data warehousing environments for Technology, Finance, and Educational sectors.
• 6+ years of hands - on experience in Data warehouse/Data Mart Analysis, Design and Architecture, Data Integration, Dimensional Data Modeling, ETL design, Analytics, Business Intelligence and all phases of systems development life cycle.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, .CSV, RDBMS tables, legacy system files.
• Development of Logical and Physical data warehouse and designed Dimensional models for data mart creation, allowing flexible high performance reporting of core data, Strong understanding of the principles of DW using Fact Tables, Data Mapping, Dimension Tables, star and snowflake schema modeling.
• Database experience using Oracle 10g/9i/8i/7i, MS SQL Server 2005/2000, MS Access 7.0/’97/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.
• Used the Power Center client tools Designer, Workflow Manager, and Workflow Monitor.
• Ability to work autonomously and also as part of a team under tight deadlines, so as to meet any project expectations.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, MS Access and Teradata.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Experience in implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center 9.0/8.6/8.1/7.1.
• Worked in the entire life cycle beginning from requirements gathering, Data model Design, ETL Design, Testing, Migration to Production and Post production support.
• Possess experience in Informatica Power Center for development, implementation and support of ETL processes for Data Warehouse and Data Mart.
• Experience in designing Small to Mid level Data Warehouse Systems involving Star Schema and Snowflake for Major RDBMS systems like Oracle.
• Strong experience in designing and developing informatica Workflows, sessions and other tasks using Workflow manager tools Task Developer, Workflow & Worklet Designer to handle different load scenarios.
• Proficient in using the Informatica Workflow Manager, Workflow Monitor, to create, schedule and control work flows, tasks, and sessions.

TECHNICAL SUMMARY:

ETL Tools: Informatica PowerCente (9.1/8.6/8.1.1/7.2/7.1 ),OLAP, OLTP, SQL*Loader

RDBMS: Oracle 10g/9i, MS SQL Server2000

Data Modeling: Conceptual, Logical and Physical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERWIN 4.5/4.0/3.5/3. x.

Reporting Tools: Micro Strategy 8.0/8.1/9.0/9.0.1

DW Tools: TOAD 11/10,$Universe Scheduler, SQL*Loader,HP Quality Center/Test director, PVCS, Microsoft Project

Programming: Unix Shell Scripting

Operating Systems: Linux, Sun Solaris, HP-UX,Windows 2003/2000/xp

PROFESSIONAL EXPERIENCE:

Confidential, Coppell, TX

Sr. ETL Developer

Responsibilities:

• Involved in requirements gathering meetings with end users and translated into technical specifications.
• Analyzed/Profiled source data, performed gap analysis and implemented rules to cleanse data as part of analysis and design phase.
• Translated the business requirements into technical details and design to be implemented by developers.
• Worked with data modelers to develop logical and physical data models as per the Business requirements.
• Worked with other developers in defining standard ETL technical designs and development guidelines.
• Created mappings, mapplets, workflows, worklet, sessions for extracting transforming and loading data from the existing credit data warehouse to the new SOP data mart.
• Extensively worked on the differentInformaticatransformations viz Source Qualifier, Expression Filter, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, Router, Aggregator Transformation and SQL override.
• Performed data quality functions through data validation, de-duplication, completeness and conformity checks.
• Implemented daily audit process through Informatica data validation option.
• Created database partitions and Materialized Views and improved the performance.
• Extensively worked in the performance tuning of the Informatica Mapping and workflows.
• Extensively used mapping parameters, mapping variables and parameter files.
• Created Power exchange mappings to convert variable length flat files to fixed widthfiles for Power center processing.
• Created advanced process scheduling using Informatica scheduler
• Worked on SQL performance tuning using various hints, indexing and partitioning.
• Worked extensively with report development team in designing dimensional model for reporting layer.
• Did impact analysis for Teradata outage and Teradata migration.
• Developed number of Informatica mappings, Mapplets and Reusable Transformations for loading of data from DB2 to Teradata.
• Wrote and maintained extensive technical documentation like high level design documents, ETL designs, Data dictionaries and Production Run books.

Environment: Informatica PowerCenter 9.1/8.6.1, Power Exchange, DVO, Microstrategy 9.3, Oracle 11g/10g, PL/SQL, Toad and Universe Scheduler, Informatica Power Center8.5, Mapping and Mapplet Designer.

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• Worked with various on-site business teams in collecting the Business rules and implementing them into the ETL designs.
• Involved in design, development and maintenance of database for Data warehouse project.
• Using Star schema approach for designing of the Data Warehouse.
• Troubleshoot database and ETL performance problems and provide timely solutions
• Interacting with the client’s technical contact to clarify requirements
• Involved in designing and maintaining logical and physical enterprise warehouse schema using Erwin.
• Developed Informatica mappings using various transformations and created sessions
• Extracting, Scrubbing and Transforming data from Flat Files, Oracle, SQL Server and then loading into Oracle database using Informatica.
• Creating of Repository and Maintaining source definitions, transformation rules and targets definitions using Informatica Repository Manager.
• Creating Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with back end database using PL/SQL. Created parameter files in Informatica PowerCenter and passed them to Informatica PowerCenter Tasks.
• Executed Informatica PowerCenter Workflows individually and validated the data
• Defined and built test strategies and testing time lines.
• Written Unix Shell Scripts for getting data from various sources
• Performance tuning by optimizing the sources targets mappings and sessions.
• Responsible for documentation of the mappings used in ETL processes and writing an Operation guide for the users.

Environment: Informatica PowerCenter 8.6.1, Oracle 9i, Erwin, Toad, Mapping and Mapplet Designer, Informatica Power Center8.5.

Confidential, Milpitas, CA

ETL/Informatica Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules in building the Datamarts/Data Warehouse using Kimball Methodologies.
• Interacted with users, documented user requirements, and translated requirements into system solutions and designed ETL processes and job schedule plans.
• Created Mappings using transformations like Source Qualifier, XML Source Qualifier, Expression, Sorter, Aggregator, Filter, Lookup, Update Strategy, Sequence Generator, Normalizer, Stored Procedure, Joiner, Rank, Router and Transaction Control transformations.
• Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Used partitioning in Sessions to improve the performance of the database load time.
• Created Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Worked on Teradata Query man to validate the data in warehouse for sanity check.
• Tested the existing mappings and redesigned the mappings to improve the performance and the efficiency of the design logic.
• Changed the Teradata programs in Mainframe that contain the SQL statements pointing to the old data source to point to the new hierarchy tables.
• Performed various operations like scheduling, publ ishing and retrieving reports from corporate documents using the business objects reporting.
• Performed troubleshooting on the impending issues in identifying the problem, provided appropriate solutions for the production problem.

Environment: Informatica PowerCenter 7.1.4/6.2, Oracle 9i, PL/SQL, SQL Server 2000, DB2 UDB, Teradata, MS Access, Autosys, MS Visio, ERWIN, TOAD, WinSQL, XML, Windows XP, Unix, Shell Scripting.

Confidential, Norfolk, VA

Informatica Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Interpreted logical and physical data models for Business users to determine common data
• Define and establish referential integrity of the system.
• Mapping data items from Source Systems to the Target System.
• Analyzed the sources, transformed the data, mapped the data and loading the data into targets using Power Center Designer.
• Involved in Dimensional Modeling and created Star Schema for FDW(Financial Data Warehouse).
• Worked on Informatica Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked with various Informatica transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner transformations.
• Designed and developed mappings/mapplets/workflows to load migrated data and execute converted transformation processes from legacy system to Enterprise Data Warehouse.
• Extracted data from various sources like Oracle and Flat files.
• Designed and Developed Oracle PL/SQL and Shell Scrips, Data Import/Export, Data Conversions and Data Cleansing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Implemented slowely change data capture using type 2 dimension.
• Extensively involved in Recovery process for capturing the incremental changes in source systems for updating in the staging area and data warehouse respectively.
• Extensively worked on tuning systems for better performance.
• Worked along with the QA team in order to determine the data validation and performed the data validating at the source and target database level.
• Performed the unit testing to the workflows and control flow individually and collectively in order to determine the accuracy of the data to the minutest detail.
• Involved in applying SMP and MPP approaches with Informatica Power center using both Oracle and Teradata.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Data profiling and collecting of requirements, assisting in design of reporting database schema.

Environment: Informatica Power Center 8.6, 8.1, Oracle 10g, UNIX, Shell Scripting,Teradata, TOAD, MicroStrategy 8.0, SQL*Plus,Erwin, SQL Server 2000.

Confidential

GIS/Database Developer

Responsibilities:

• Responsible for sourcing and loading GIS attribute data into data warehouse.
• Tasks include Extraction, Transformation and Loading of data from GIS data files to Oracle9i database using Informatica.
• Handled large volumes of GIS data from ODS to DW tables for aggregated reporting
• Worked with the architecture team participated in designing Data Marts using Star Schema approach.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the Data Warehouse
• Created reusable transformations and mapplets to use in multiple mappings.
• Involved with business intelligence and reporting team to merge GIS mapping data to field attributes.
• Responsible for monitoring jobs and to co-ordinate with the duty team to provide 24x7 production support.
• Prepare technical documents, artifacts and write ups which help for future endeavours.

Environment: Informatica Power Center 7.1.4, Oracle 9i, SQL, PL/SQL, SQL* Loader, SQL*Plus, Erwin, Sun Solaris.