PROFESSIONAL SUMMARY

• SDLC: Over9years of IT experience in Data Analysis, Design, coding and Informatica/MDM/DataQuality IDQ
• And testing of Data Warehousing implementations across Retail, Financial, Pharmaceutical, Health care and Insurance Industries.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical physical.
• Informatica: 7years of Data Warehousing experience using InformaticaPower Center 9.1.0/8.6.1/8.1.1/8.0/7.1.3/7.1.2/7.1.1/6.2/5.1.1,Power Mart 6.1/5.1.1/5.x/4.7, Warehouse Designer, ETL, Data mart Siebel 7.0/2000/5.5, Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Autosys, Control M, Sybase. Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files fixed width, delimited , XML, RDBMS tables, legacy system files.
• Data Analysis: 4 yearsof strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Data Modeling: 4 years of Dimensional Data Modeling experience on Data modeling, Erwin 7.1/4.5/4.0/3.5.5/3.5.2, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data mart, OLAP, FACT Dimensions tables, Physical Logical data modeling and Oracle Designer.
• Methodologies: Complete knowledge of data ware house methodologies Ralph Kimball, Inmon , ODS, EDW and Metadata repository.
• Databases: 6 years of experience using Oracle 11g/10g/9i/8i, DB2 8.0/7.0/6.0,MS SQL Server 2005/2000/7.0,Teradata V2R6/V2R5, Sybase 12.x/11.x, SAP R/3,MS Access 7.0/2000, PL/SQL, SQL Plus, SQL Loader and SQL Developer.
• Experienced with coordinating cross-functional teams.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.

Technical Skills:

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL Informatica Developer

Responsibilities:

• Involved in requirements analysis and Architect rolewith business users for design of tables in the new Warehouse.
• Based on the requirements, created the high level design specs, source to target mapping documents and later created unit testing documents for code reviews based on that.
• Expert in Data Modeling Logical, Physical, Dimensional Modeling
• Performed Customer Address cleanses and Address Matches using IDQ.
• Created Web service to call mapplet for Address cleanse in IDQ using Address doctor.
• Created cleanse functions in IDQ based on customer need
• Integrated IDQ mappings with Informatica power center for scheduling the Jobs
• Created IDD/MDM configuration as customer Need.
• Created MDM data for Product customer and supplier domains and performed Match/merge.
• Created Match/merge rules for both Manual and Auto Match/merge
• Involved in building Enterprise wide Logical and Physical models using Erwin
• DesignedETL functional specifications and converted them into technical specifications.
• Extensively used ETL and Informatica MDM/IDQ to load data from Oracle, Excel spreadsheet, flat files, XML and Mainframe/COBOL to the target PerOracle database.
• Experience in Informatica providing Data warehouse solutions using PowerCenter and data modeling with ERWIN tool.
• Experience in dimensional and relational database design
• Used Erwin tool for physical and logical data modeling.
• Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.
• Extensively involved in Data Extraction from Mainframe source VSAM , Oracle using Power Exchange when there was change in the source data sets.
• Used SQL overrides in source qualifiers with appropriate schema names for extracting only the required rows for optimal performance. Implemented complex expressions in expression transformations. Tested the queries thoroughly for integrity and identifying data errors.
• Extensively worked on Informaticapower center tools Designer, Workflow Manager, Workflow Monitor Repository Manager.
• Extensively worked on InformaticaDesigner Components Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and MappingDesigner.
• Created reusable transformations and Mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and MappletDesigner, respectively
• Extensively worked on the performance tuning of the Mappings as well as the tuning of the sessions.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Created target definition in oracle which was the target database.
• Responsible for maintaining repository backups and their restorations.
• Lead the Performance Tuning of InformaticaMappings, Sessions and workflow. Developed unit test cases and did unit testing for all the developed mappings.
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica.
• Provided production support by monitoring the processes running daily.

Environment:InformaticaPower Center 8.6.1/9.1.0,MDM/IDQ, Oracle 10g/11g,PL/SQL Erwin 5.1, Business Objects xi, TOAD 9.6.1, UNIX AIX 5L version 5.1, Windows XP Professional/2002, UNIX, Windows XP/2000.

Confidential

ETL Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Extensively used InformaticaPower Center 8.1.1 to extract data from various sources and load in to staging database.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.
• Created mappings for various sources like XML, flat files Oracle and Transformations XML Source Qualifier, XMLparser, xml generator, Normalizers, JMSQueuing, MQ Application, Java transformation, stored procedures etc.
• Created the Shell scripts for Running the jobs and Downloading the Files and Transferring the Processed files to SFT Server.
• Used Power Exchange interface to get the data from mainframe files.
• Performed source data analysis .Primary data sources were from Oracle SQL server 2005.
• Involved in using Erwin for physical and logical data modeling.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area Oracle 10g using InformaticaPower Center 8.1.1
• Created Informaticamappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Participated in all facets of the software development cycle including providing input on requirement specifications, high level design documents, and user's guides.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Implemented Slowly ChangingDimension methodology for accessing the full history.
• Created Several InformaticaMappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designingmapping templates to specify high level approach.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created Universe business objects and reports using drill down, slice and dice reports
• Involved in Unit testing and documentation.

Environment:Informatica 8.6.1, Oracle 10g, PL/SQL, TOAD 8.6.1, ERWIN, SQL Server 2005,Business Objects XIR2, Windows NT, UNIXShell Scripting.

Confidential

Sr ETL Developer

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy Dimensional modeling. Backup recovery.
• Creation of shortcuts for source, targets and created transformations according to business logic.
• Worked in Development, Testing, Pre-production and Production Servers.
• Worked on Power CenterDesigner client tools like Source Analyzer, Warehouse Designer, MappingDesigner and MappletDesigner.
• Created complex reusable transformations and Mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and MappletDesigner, respectively.
• Created reusable Sessions and Commands in the Workflow Manager.
• Created and implemented variables and parameters in the MappingDesigner.
• Created reusable Worklets in WorkletDesigner and set up Workflows in the Workflow
• Used unconnected lookup for populating date-time entered field in the target tables.
• Developed Mapplets, mappings and configured sessions.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mappingdesigner, MappletDesigner, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Worked closely with reporting team and generated reports using Business Objects 6.2.
• Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality assurance testing.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing.

Environment:InformaticaPower Center 7.1 Meta-Data Repository, Designer, Server Manager , DB2 UDB, Oracle9i/8i, Teradata, SQL, PL/SQL, Erwin, SQL Loader, UNIX Shell Script, IBM AIX 4.3.3, Win 2000/NT, Business Objects 6.2

Confidential

Data warehouse Developer ETL / Informatica

Responsibilities:

• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informaticamappings for data loads
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Worked on InformaticaPower Center tool - Source Analyzer, Data warehousing designer, Mapping MappletDesigner and TransformationDesigner. Development of Informaticamappings and also in tuning of mappings for better performance.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle 9i. Tuning InformaticaMappings and Sessions for optimum performance
• Used Informatica features to implement Type I II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Used PMCMD commands in non-windows environments. Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for ETL process under development, test and production environments.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Tuning the InformaticaMappings for optimum performance. Used windows Scripting and Scheduled pmcmd to interact with Informatica Server from command mode. Modeling and populating the business rules using mappings into the Repository for Meta Data management

Environment:InformaticaPower Center 7.1/6.2, Informatica Power Connect, OLAP, Teradata V2R5, Oracle 9i, MS SQL Server 7.0/2000, IBM DB2/400, IBM AS/400, Sybase, MS Excel 97, Flat files, PL/SQL, SQL, SQL Loader, Erwin 3.5, Toad 7.0, Transact-SQL, Windows 2000, HP-UX, UnixShell Scripting and Cognos.

Confidential

Informatica Developer

Responsibilities:

• DesignedLogical and Physical Modeling using Erwin Data Modeler tool.
• Involved in the Development of Informaticamappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Implementing Extraction process of flat files into target database
• Migrated Mappings from Development to Testing and Testing to Production.
• Used Parameter Files for multiple DB connections for the sources and defining variable values.
• Developing the documentation and plan for transformation and loading the Warehouse.
• Analyzing the data from various sources for data quality issues.
• Participated in all facets of the software development cycle including providing input on requirement specifications, high level design documents, and user's guides.
• Worked with Web services.
• Writing Oracle Stored Procedures, SQL scripts and calling at pre and post session.
• Created Concurrent Tasks in the workflows using workflow manager monitor jobs in Workflow Monitor.
• Designingmapping templates to specify high level approach.
• Involved in Unit testing and documentation.

Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, Web Services, PVCS, Windows NT, UNIXShell Scripting.