SUMMARY:

• Over 8+ years of experience with system design, development, testing support and production support Data Warehousing which involves ETL, Reporting and Data modeling experience.
• Experience in data modeling, data warehouse, and Ralph Kimball models with Star/Snowflake Schema Designs with analysis - definition, database design, testing, and implementation and Quality process.
• Professional Experience in ETL Architecture using Informatica Power Center, 6.x/ 7.1.3/8.1/8.5/8.6.1.
• Experience with reading from Mainframe datasets and Cobol Sources using Informatica Power Exchange.
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. Extensively worked with large Databases in Production environments.
• Extracted data from various sources like Oracle, DB2, Flat file, SQL SERVER, XML files, Teradata and loaded into Oracle database.
• Strong experience in designing and developing business intelligence solutions in Data warehouse/Decision Support Systems using ETL tools Informatica Power Center 9.1/8.6.1/8.1/7.1/6.2/6.1 , OLTP, OLAP.
• Data modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling, and Oracle Designer.
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 9.x/8.x/7.x/6.x, power exchange8.1 and Power Mart 5.x/6.x Client, Server.
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Very good Exposure in IDQ (Informatica Data Quality) Tool
• Extensively worked on Data Warehouse Administrative Console (DAC).
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files, COBOL and XML files. Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Experience in Oracle as Pl/SQL Developer.
• Extensively worked on both Windows (Batch and Power shell) and Unix Scripting.
• Extensively worked on Data Services proactively and iteratively collaborate in the profiling and cleansing of data across the heterogeneous sources.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, Oracle PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, Netezza, MS SQL Server 2000/2005/2008.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Created Business Objects WebI, Crystal Reports specifications document for monitoring performance of Business Objects using BAC Monitoring System.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Worked on data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager. Experience working in Oracle 9i/10g with database objects like triggers, stored procedures, functions, packages, views, indexes.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts. Collaborated onsite teams, interacted and well managed various offshore teams.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Strong Team working spirit, communication and relationship management skills.

TECHNICAL SKILLS:

Data Warehousing/ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformation, Sessions, Workflow Manager-Workflow, Task, Commands, Worklet, Transactional Control, Constraint Based Loading, SCD I, II, Web Services and XML transformations), PowerExchange, ETL, BODI, Metadata, Informatica Data Quality (IDQ) 7.3 & Data Analyzer. Data Quality, Data Profiling, Data Flux, Golden Gate, DataStage, Netezza, Datamart, OLAP, ROLAP, MOLAP, OLTP.

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 2000/7.0/6.5 , Sybase, Db2, Teradata, MS Access 7.0/2000, SQL Server (DTS/SSIS/SSRS)Data Modeling

Star Schema and Snow: Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ER Studio, Erwin 4.5/4.2/3.5/3. x, Oracle Designer/2000.

Tools: MS Office 97/2000/professional, SQL*Plus 3.3/8.0, TOAD, IBM data Studio, Microsoft Visio, Putty, Text Pad, .vsd files, .csv files, Erwin, ER Model, Siebel, Salesforce Integration, DAC, RPD, SAP, Autosys.

Programming Languages: Unix Shell Scripting and Perl Scripting, Batch Scripting, VB.NET 05/08, XML, HTML, C, C++, UML (Rational Rose), Java, Oracle PL/SQL (Stored Procedures, triggers, Indexes).

Environment: Windows 98/2000/2003/ XP/NT and Windows NT, UNIX, SOLARIS.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Informatica Consultant

Responsibilities:

• Analyzing highly complex business requirements, designing and writing technical specifications to design or develop ETL processes.
• Automating the ETL process through scheduling the exception-handing routines as well as source to target mapping development, support and maintenance.
• Loading Data to the Interface tables from multiple data sources such as SQL server, Text files and Excel Spreadsheets using SQL Loader, Informatica and ODBC connections.
• Providing metrics to measure progress and accuracy of data transfers.
• Designing and introducing new FACT or Dimension Tables to the existing Model and deciding the granularity of Fact Tables.
• Extracting the data from EDW which is Teradata and loading into DB2. Also working on the sources like Flat files, XML files and loading them to the appropriate Targets. Providing clean data to OBIEE team to generate their reports.
• Helped the team in analyzing the data to be able to identify the data quality issues.
• Creating necessary repositories to handle the metadata in the ETL process.
• Designing the target warehouse using Star Schema.
• Creating mappings to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Normalizer, Filter and Router transformations, Union transformations, etc.
• Creating the job schedule component using Autosys.
• Code Migrations to Main Development folders, SIT and UAE repository.
• Performance Tuning by adding hints and session level partitions.
• Creating the change request that need to be migrated into PROD by using PAC2000.
• Check in the code into SVN, for migration purpose.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Creating sessions, sequential and concurrent batches for proper execution of mappings using workflow manager.
• Using Informatica Designer designed and developed Source Entities and Target warehouse Entity for Oracle.
• Involving in versioning the whole process and retiring the old records using the built-in’s DD UPDATE, DD DELETE, and DD INSERT.
• Developing Mapplets using corresponding Source, Targets and Transformations.
• Optimizing Query Performance, Session Performance and Reliability.
• Designing Database schemas using ER Studio Design Tool.

Environment: Informatica 9.5.1, 9.6.1 HF3, Db2, Teradata, Oracle 11g, UNIX Server 4.3, TOAD, Version1, Winscp, Putty, IBM data Studio, SQL server.

Confidential, MI

Informatica Consultant

Responsibilities:

• Involved in ETL data design and DB modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling and using Erwin.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Worked with Architecture board in designing ETL High and Lowe level specifications and executed the implementation successfully
• Developed ETL code and involved in peer reviews to align organizations design standards and best practices
• Actively involved in gathering requirements from business analysts and end users.
• Worked with various advanced transformations like Transaction control for multiple heterogeneous extracts SQL Transformation for validating the transaction systems to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Implemented incremental logic using store procedures and file marts systems
• Used ETL (Informatica) to load data from sources like Oracle, DB2 database by using native clients and legacy source systems.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Developed and scheduled Workflows using MJS which intern initiate the command utilities to kick off the scheduled jobs
• Implemented various scheduling mechanisms with the help of shell scripts, worklets and workflow in Workflow manager and monitored the run times for performance enhancements
• Did performance tuning at source, transformation, target, and workflow levels.
• Used command utilities like PMCMD, PMREP with UNIX shell scripts for workflow automation.
• Involved in creating and management of global and local references and assigning permissions using Repository Manager.
• Implemented code migrations across repositories to support CIT, SIT, UAT and Production deployments
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
• Extensively used Stored Procedures, Functions and PL/ SQL Programming.
• Extensively used Normalizer transformation while loading the data from the COBOL copybooks to the staging area.
• Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Checked and tuned the performance of application.
• Developed data Mappings between source systems and warehouse components.
• Created and defined DDL’s for the tables at staging area.
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Analyzed systems, met with end users and business units, in order to define and meet the requirements.
• Automated mappings to run using UNIX shell scripts, which included Pre and Post-session jobs.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.
• Installed and configured Informatica client tools on Windows environments.
• Used Informatica Power Analyzer and Informatica Analytics for developing Dashboards, Alerts, Reports, Indicators and Adhoc Query Reporting.
• Training the users how to access and run the jobs Using Informatica workflow Manager

Environment: Informatica Power Center 9.5/9.1, Oracle 11g, DB2 9.7 Z/OS and UDB, XML, Toad 12, SQL, PL/SQL

Confidential, FL

Informatica developer

Responsibilities:

• Designed the Data model and Load strategy to get data from different systems and use it for the Online Registration database.
• Prepared the Technical Specs, Reverse Engineered Logical designs using Erwin, Flow diagrams and Timeline sheets to facilitate development of Informatica Flows.
• Database sizing & CPU estimation on Data Base, ETL & OLAP for Development Server, Test Server and Production Server
• Perform risk analysis, Business requirements, Project Plan and Hardware/Software requirements
• Developed and maintaining of Informatica mappings and DTS packages for work around ETL process
• Extensive experience in ETL development and maintenance using Oracle SQL, PL/SQL and written Store procedure for the Data Dimensions table to insert 10 years’ worth of data and also used the Informatica Store Procedure Transformation to update the columns in the same table
• Implemented Star Schema for De-normalizing data for faster data retrieval for Online Systems.
• Developed Procedures and Functions in PL/SQL for Data ETL.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Designed and Developed Mappings, sessions and workflows in Informatica.
• Extracted, transformed data from various sources such as Flat files, Oracle 11g and transferred data to the target data warehouse Oracle 11g and Flat files.
• Customized Project, HR, Procurement and Finance inbuilt mappings.
• Involved in installation and configuration of Informatica and DAC.
• Designed and Deployed UNIX Shell Scripts.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Responsible for Pre and Post migration planning for optimizing Data load performance, capacity planning and user support.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Involved in creating STAR Schema for OLAP cubes.
• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Partitioned sources and used persistent cache for Lookup’s to improve session performance
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Worked with Data / Data Warehouse Architect on logical and physical model designs.
• Performed impact analysis for systems and database modifications.
• Involved in developing of stored procedure for Change Data Capture (CDC), Auditing etc.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Extracted data from Sales department to flat files and load the data to the target database.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Performed data validation, reconciliation and error handling in the load process.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Overall project delivery and maintenance of project like implementations.
• Delivery of daily/weekly/monthly outbound client extracts.
• Onsite and offshore coordination.
• Resource management.
• Responsible for training and overseeing the Quality procedures related to the project

Environment: Informatica Power Center 9.1/8.6.1, Power Exchange8.1.1, Oracle 11g/10g, OBIEE, SQL Server, Teradata, XML, Flat Files, Toad, Sql Developer, Shell Scripting.

Confidential, CO

ETL/Informatica Developer

Responsibilities:

• Developed ETL for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 8.6.0
• Informatica Power Center is used to extract the base tables in the data warehouse and the source databases include Oracle, Flat files and SQL Server.
• Setup the batches, configured the sessions and scheduled the loads as per requirement using UNIX scripts.
• Worked on Power Exchange for change data capture (CDC).
• Extensively worked in fixing poorly designed mappings and developed schedules to automate the Informatica workflows
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Developed oracle PL/SQL, DDLs, and Stored Procedures and worked on performance and fine Tuning of SQL PL/SQL stored procedures. Involved in creation of multiple data integration schemas for tuning and purging of data
• Involved in SQL tuning while creation of various different sql procedures.
• Developed Informatica mappings using transformations like Lookup, Stored Procedure, Filter, Expression, and Aggregator.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Identified all impacted ETL mappings/Jobs and modified source/target connections and made the system into Netezza specific
• Created test plans and did unit testing for the Informatica mappings and stored procedures
• Extensively involved in writing ETL Specs for Development and conversion projects.
• Reviewed the code and technical specifications.
• Worked on various data issues in Production environment.
• Uploaded data from operational source system (Oracle 8i) to Teradata.
• Data is Staged, integrated, Validated and finally loaded the data into Teradata Warehouse using Informatica.
• Recommended temporary fixes and workarounds for production issues and also proposed permanent fixes.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQL, PL/SQL, Teradata, TOAD, SQL*Plus, Windows 2000, SQL Server, UNIX, Cognos.

Confidential

ETL PL/SQL Developer

Responsibilities:

• Designed and created a multi-dimensional schema.
• Installed and Configured Informatica Server and Power Center, Repository and Server Manager.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer and Mapplets, and Transformations for ETL Processes to load operational data into multi-dimensional database.
• Worked closely with various DW Analyst/Developers working on specific data marts, multiple business units to identify key information that will enhance business decision-making.
• Responsible for tuning ETL procedures and STAR Schema and SNOWFLAKE Schema to optimize load and query Performance.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL
• Created and Monitored Batches and Sessions using Server Manager.
• Wrote UNIX scripts and PL/SQL scripts for implementing business rules.
• Informatica Server Manager was used to do the loading of the transformed data on to the multi-dimensional schema.
• Generated Unix Scripts for Data warehouse applications and maintaining batch processing.
• Developed Database Triggers and Stored Procedures in Oracle.
• Responsible for training end users in installing and Configuring Informatica, creating sessions, batches and browses through repository.
• Involved in organizing production and documentation of complete project

Environment: Informatica Power Center (Repository Manager, Designer, Server Manager), Business Objects 5.1.1, Oracle 8i, SQL Server, PL/SQL, TOAD Shell Scripting, UNIX.