SUMMARY

• Over 8+ years of IT experience includes Analysis, Design, Development and Maintenance of various software applications in client server environment. Experience in providing Business Intelligence solutions in Data Warehousing using Informatica tool.
• Good knowledge of full life cycle development in Data warehousing projects with Data Analysis, Data Extraction, Cleaning and loading of the data.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, DB2, Excel sheets, and worked on integrating data from Flat files with fixed with and delimited.
• Experience in developing complex mappings using different transformations like Source Qualifiers, Expression Transformation, Joiner Transformation, Filter Transformation, Routers, Union, Connected and Unconnected Lookups, Aggregators, Rank Transformation, Sorter Transformation.
• Experience in developing Sessions/tasks, Worklets and Workflows using Workflow Manager Tools - Task Developer, Workflow and Worklet Designer.
• Experience in dealing with complex dimensions like customer Dimension with slowly changing dimension type2(scd type2) for updating and inserting new rows.
• Practical understanding of Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and dimensional tables modeling of data at all the 3 levels: View, Logical and Physical.
• Extensively worked with OLAP tools such as OBIEE 11g/10g/9i, Business Objects 6.5 (Supervisor, Designer), and various features of Erwin like Forwarding Engineering and Reverse Engineering.
• Experience in Database Administration activities like installation and creation of database, database objects, backup and recovery.
• Excellent knowledge and experience in technical design and documentation.
• Quick learner and excellent team player, ability to meet tight deadlines and ability to communicate effectively with different levels of management and with clients.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1/8.6/8.1/7.1

RDBMS: Oracle 10g/9i/8i, SQL, SQ SQL*Plus, SQL*Loader, Oracle11g/10g/9i/8i, IBM DB2 UDB 8.1/7.0MS SQL Server 2000/2005, MS Access 7.0/2000.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3/ 4/4.1

Tools: Toad, PL/SQL developer,DB visualizer, Clear Quest, clearcase, Rational Team Concert, Quest Central for DB2

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, Visual Basic, Java, XML.

Operating Systems: Windows NT/2000/2003,XP

PROFESSIONAL EXPERIENCE

Confidential, TN

Sr. Informatica Developer

Responsibilities:

• Involved in fine tuning of SQL queries in the transformations.
• Involved in creating workflows and worklets for new mappings.
• Worked extensively in Performance Tuning with existing mappings by analyzing data flow.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Involved in modifying the stored procedure with line of business.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Modified a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data mart.
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator and Joiner on the extracted source data according to the business rules and technical specifications.
• Used Java transformation to implement the loping logic.
• Created reusable transformations and Mapplet and used with various mappings.
• Extensively used XML targets, XML sources, XML generator transformation and XML parser transformation.
• Created Connected, Unconnected and Dynamic lookup transformation for better performance and increased the cache file size based on the size of the lookup data.
• Developed and Implemented Informatica parameter files to filter the daily data from the source system.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Performed regression testing and integration testing.
• Performed scheduling techniques with ETL jobs using scheduling tools, through pmcmd commands, based on the business requirement.
• Developed Shell Scripts for getting the data from source systems to load into Data Warehouse.
• Worked with Serena Version Manager to maintain the versioning of various documents.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 11g/10g, FLATFILES, XML, DB2, SQL Server 2000, PL/SQL, SQL*Loader, Erwin 4.1, TOAD 7.6

Confidential, AZ

Sr. Informatica Developer

Responsibilities:

• Collect business requirements from the users/Business Analysts & Converted the Business logic into functional specs with enhancements to get better performance of the system.
• Created and Worked technical requirements and detail level documents.
• Involve in the entire SDLC (Software Development Life Cycle) process that includes implementation, testing, deployment and maintenance.
• Performed Oracle Data Warehousing development including data modeling and backend processes, specifically, Extraction, Transformation and Loading (ETL) of data into staging tables and then into Data Marts/Warehouses for presentation.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for the data to target warehouse using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Implemented and extensively worked on Slowly Changing Dimensions (SCDs, Both Type 1 & Type2 & Type3).
• Configured the sessions using Workflow Manager to have multiple partitions on Source data and to improve performance.
• Used Informatica Debugger, Session Logs and Toad to resolve problems in a timely manner.
• Coordinate and develop all documentation related to ETL design and development.
• Worked with project management to identify and solved issues through negotiation and/or Procedures, Analytical functions, Triggers, Materialized Views, Packages, Records a formal escalation processes.
• Involved in database development by creating PL/SQL Functions and Collections.
• Coordinated bug fixing activities related to issues raised during end - User Acceptance Testing.

Environment: Informatica Power Center 8.6.1, Toad Data Modeler, Oracle 10g/11g, Toad, PL/SQL, Excel, object-oriented design, DW architectures, bus architecture.

Confidential, NC

Sr. Informatica Developer

Responsibilities:

• Interaction with the users/analysts to understand the business of the application, gather requirements and put into technical design documents.
• Involved in Design phase of the project and prepared High level Design Specifications for ETL Coding and mapping standards.
• Involved in developing the technical documents from functional specifications.
• Suggested performance tuning techniques in InformaticaMappings for optimum performance.
• Worked closely with Development managers to evaluate the overall project timeline.
• Performed Unit-testing by generating SQL scripts based on the pre-defined test plans.
• Resolved many complex defects involving analysis of mappings and stored procedures.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Helped business analyst to define requirements and translate them to data model and ETL design.
• Worked on Changed Data Capture (CDC) while loading to the Dimension Tables.
• Created Mapplets and reusable transformations to be re-used during the development life cycle.
• Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Involved in Performance testing the mappings and workflows in production staging beforeinstalling in the Production environment.

Environment: InformaticaPower Center 8.1.1(Designer, Workflow Monitor, Workflow Manager), Oracle 10g, Flat Files, Toad, Windows XP, SQL Plus, Quality Center.

Confidential, CA

Informatica Developer

Responsibilities:

• Interacted with the data modeler and business users on a regular basis to understand the functional requirements. Was Involved and created technical requirements and detail level documents.
• Source data from relational tables and flat files is transformed in the stage layer by applying the business logic.
• Prepared user requirement documentation for mapping and additional functionality.
• Involved in creating Repositories, Folders, Versions, and Repository Objects using Repository Manager under the Informatica Power Center.
• Used the mapping transformations like sorter, Lookup, aggregator, expression, joiner and filter in the creation of mappings.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Create Repository, Users and Groups. Analyze and import the Source definitions.
• Create target definitions, logical and physical designing of target tables.
• Tested the target data against source system tables by writing the PL/SQL Procedures.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Extensively worked with performance tuning at mapping levels like implementing active transformation like filter as early as possible in the mapping.
• Deployed the mappings into testing and production environments.

Environment: Informatica Power Center 8.1.1, Erwin, Teradata, SQL assistant, PL/SQL, Informatica Power Exchange, Excel, Oracle 10g, DW architectures, Windows XP/Windows Vista Enterprise Edition.

Confidential, CA

ETL/Informatica Developer

Responsibilities:

• Gather requirements from clients about tables required for reporting, and load them on demand
• Monitor and investigate errors that cause Extract or Load failures. Research and resolve issues with ETL processes or the resulting data.
• Analyze, maintain and resolve Data Integrity issues.
• Develop and maintain strong professional and technical relationships with assigned clients. Become the internal expert for that client's data requirements.
• Provide project management, particularly focused around meeting critical timelines, project communication, and hands-on implementation for assigned projects.
• Work with ETL Developers and QA analysts to create reliable and dependable ETL processes.
• Research and resolve issues with ETL processes or the resulting data.
• Responsible for setting up new consoles.
• Automated the workflows to minimize baby sitting activities for job monitoring.

Environment: ETL, Informatica 7.1/8.1.1, Oracle 10g/9i, SQL Server.

Confidential

ETL Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplet and Transformations.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various business units in tables.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Used most of the transformations such as the Source Qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence.
• Extensively used ETL to load data from MS SQL Server 7.0, Oracle 8i, Sybase and flat files to DB2.

Environment: Informatica Power Center 7.1, Oracle 8i, PL/SQL, SQL Server