SUMMARY

• Over 7+ years of experience in Information Technology with a strong background in Database development and Data warehousing and 6 years ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1 , Power Exchange using Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica Power Center in Extraction/Transformation/Loading of data and developed ETL worklets, workflows and ETL mappings.
• Extensively worked on Repository Server Administration Console, Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Expertise in working with data extract using Power Exchange tool by COBOL copybooks layouts.
• Experience in Financial, Banking and Healthcare industries.
• Extensive experience in extracting COBOL copybooks and data files from IDMS/IDMS - R legacy mainframes and IBM DB2 using JCL.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in Dimensional Data Modeling experience using Data modeling, Erwin Modeling (Erwin 4.0/3.5.5) like Physical & logical data modeling.
• Experience with Data Extraction, Transformation and Loading from different data sources like Oracle, MS SQL Server, Teradata etc. into a common analytical data model using InformaticaPower Center 6x/7x/ 8.1/8.5/8.6.
• Experience in performance tuning and query optimization of Informatica Sources, Targets, Mappings, and Transformations & Sessions.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Link.
• Strong experience in Oracle database Performance Tuning and extensive experience in SQL * Loader Imports/Exports
• Experience with industry standard methodologies like RUP, Waterfall, Agile, and Scrum methodology within the Software Development Life Cycle.
• Creating Data Structures i.e. Tables & Views and applying the referential Integrity.
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Experience with Business Intelligence using Business Objects 6.5/4.5.
• Familiar with UNIX Shell Scripting, PL/SQL Coding, Normalized Database creation in relational databases like Oracle 11g, MS-SQL Server 2010 and optimizing the SQL to improve the performance.
• Strong understanding of Performance tuning in Informatica and Databases.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Index, and experienced in loading data into Data Warehouse/Data Marts using Informatica.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1 , Star Schema, Snowflake Schema, OLAP, OLTP, Power Exchange 9.x/8.x/7.x.

Data Modeling: Dimensional Data Modeling, 3NF Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.x

Databases: Oracle 9i/8i/10g/11g, SQL Server 2008, MS Access 2008,Sybase,Teradata 14.1

Reporting Tools: BUSINESS OBJECTS - Designer and Supervisor.

GUI: Visual Basic, Macromedia Dreamweaver MX, FrontPage 98/2K, Visio, MS ProjectTOAD, Putty.

Programming: SQL, PL/SQL, Transact SQL, HTML, DHTML, XML, C, C++, ASP.NET and Shell.

Environment: Windows XP/2003/2005/vista/2007, Unix-AIX 5.2/4.3, WinNT4.0

PROFESSIONAL EXPERIENCE

Confidential - Seattle, WA

Sr. Informatica Developer

Responsibilities:

• Developing mappings to extract the Data from multiple Flat Files and loading them into staging through CDM database.
• Working on Informatica Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Creation and testing of Power ExchangeData maps and involved in extracting COBOL copybooks from IDMS/ IDMS-R legacy mainframes system. .
• Used Informatica Power Exchangeto handle the change data capture (CDC) data from the source and load into Data Mart by following Slowly Changing Dimensions (SCD) type II process.
• Involved in modifying existing Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica source and Target Data.
• Analyzed source systems (SQL server, XML and COBOL files) from third party vendor, these files were the source to the Informatica interfaces used to load data to the target downstream systems.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table, and worked mostly on constraint based loading.
• Creating stored procedures, sequences and triggers to insert key into the database table.
• Working with the maps to reconcile the source data through the ODS.
• Involved in Low level Design for the scripts of the database sequences, constraints, triggers and stored procedures.
• Knowledge of Backups,Partitioning of Database tables.
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings. Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Creating Low level documents for creating maps to load the data from the ODS through the warehouse.
• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Oracle database.
• Optimizing the maps by performance tuning.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.

Environment: Informatica Power center 9.5.1, Informatica Power Exchange 9.5.1, Oracle 11g, SQL Server, IDMS Mainframes, Toad 10.6 for Oracle, Unix AIX, Ultra edit

Confidential - Woonsocket, RI

Sr. Data Warehouse Analyst

Responsibilities:

• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, Sybase, Teradata and Flat Files.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Extensively used Transformations for heterogeneous data joins, complex aggregations and External procedure calls.
• Driving the technical design along with customer team, preparing design specs, functional specs, and other documents.
• Involved in all aspects of software development life cycle. This covers designing, coding, testing, implementing, deploying, and continued support of all projects owned by the team.
• Implemented the EPIC upgrade 2010 for existing EPIC sources and Clinical systems Integration (CSI) work stream.
• Used extensively in Functionality and Logic testing for all Mappings used in populating the Delta Layer.
• Developed mappings for extracting data from Sybase and load to Teradata target using Fload through Acquisition and integration layers.
• Involved in data modeling and dimensional modeling of 3NF data architecture.
• Automated the audit control framework of acquisition layer using MS Access in 3NF architecture.
• Involved in generating Fload, Mload and Tpump scripts to load the data into Teradata tables.
• Designed and implemented change data capture (CDC) using SQL server EPIC source in Power center.
• Created data maps and change data capture registration maps using Power exchange for CDC.
• Created deployment groups and involved in admin tasks such as migrations to higher environments and running normal monthly quality reporting (MQR) and HEDIS process.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, and Validation Techniques and load efficiency.
• Scheduled jobs via CRON Tab in Unix, writing various shell scripts that use PMCMD commands to call the Informatica workflows and stored procedures based on a job dependency table.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Identified and resolved the bottlenecks in source, target, transformations, mappings and sessions to improve performance and query optimization.
• Created new business tracking reports using customized Teradata queries utilizing ETL tools set on an ongoing basis.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.

Environment: Informatica Power Center 9.1.1 (Repository Manager, Designer), Power Exchange 9, Sybase, Teradata 14.10, Unix-AIX4.3, Text pad 5.4, Business Objects.

Confidential - Portland, ME

Sr. ETL Developer

Responsibilities:

• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems of dimensions and Facts.
• Extensively used Informatica Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Implemented scheduling logic for daily extract file generation from dimensions and facts.
• Worked on data modeling for designing dimensions and facts for new Cash Flow domain with various source systems for inbound file to DDM.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Worked extensively on Lookup, Router, Filter, Aggregator, Expression and Update Strategy Transformations.
• Used MD5to handle the Slowly Changing Dimensions (SCD) mappings and data from the source and load into Data Mart by following type II process.
• Scheduled Sessions and created connection links for FTP of flat file on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shells scripts.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating shortcuts, re-usable Mapplets and Transformation objects.
• Was involved in Informatica Power Exchange to test the data at mainframe .dat files.
• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum Performance.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited) for temporary persistent repository (TPR).
• Created new Test plans and test queries using Auto-Recon and SQL on an ongoing basis. Assisted in data migration from ETL system to Oracle data warehouse.
• Unit, data and Integration Testing of Informatica source and Target Data.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications of requirements and work status.
• Worked on UNIX machine on which Informatica Server was installed to check for the session logs and stage directories containing data files.
• Tuned SQL queries for better performance and query optimization.
• Optimized the mappings by changing the logic to reduce run time.
• Developed the mappings to extract the data on incremental load basis.
• Developed reusable transformations and user defined functions (UDF) for Julian Date Conversion.

Environment: Informatica Power Center 9.1.1 (Repository Manager, Designer), Power Exchange 9, Oracle 10g, Toad, Unix-AIX4.3, Ultra Edit 15.10, Text pad 5.4, OBIEE.

Confidential

ETL Data transfer Analyst/Developer

Responsibilities:

• Working with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions.
• Was involved in Informatica Power Exchange to test the data at mainframe .dat files.
• Created Data maps in Power Exchange to extract EBCIDIC data from mainframes.
• Implemented some coding in PWX to make length of COBOL copybook to data length of donor file and conversion files.
• Dealt with several kinds of data formats including half byte data for packed decimal formats.
• Implemented coding to extract copybooks and files from Mainframes using Job coding language (JCL).
• Review the data after every data cut on Mainframes by using FILE - AID and ISPF library.
• Working on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Working mostly on Lookup, Aggregator, Router and Expression Transformations to implement complex logics while coding a Mapping for date conversion etc.
• Created mapping for automation of audit process by using SQL transformation in Informatica.
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code.
• Creating Indexes on tables for most retrieved fields of tables and views.
• Follow up with appropriate documents for the Change Management, Incident Management, and Problem Management.
• Unit and Integration Testing of Informatica source and Target Data.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment (with a paging system).
• Development and maintenance of ETL by creating shortcuts, re-usable Mapplets and Transformation objects.
• Implemented slowly changing dimensions Type 1, and Type 2 methodology for accessing the full history of accounts and transaction information.
• Functional knowledge of Mortgage and Home Loan modification Plan
• Taken part of Informaticaadministration. Migrated development mappings as well as hot fixes them in production environment.
• Involved in analyzing the year end process and managed the loads that have yearend aggregations.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Created Workflows with worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Creating stored procedures, sequences and triggers to insert key into the database table.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Used the command line program pmcmd to run Informatica jobs from command line. And used these commands in shell scripts to create, schedule and control workflows, tasks and sessions.
• Validating raw data loads from mainframes file with Informatica Data Profiler by creating custom profiles for business logics and validating dates from mainframes.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Environment: Informatica Power center 8.6.1, Informatica Power Exchange 8.6.1, Informatica Data Profiler, Oracle 10g, Toad for Oracle, Ultra edit 12.20, Flat Files, WinNT 4.0 UNIX, and Business Objects.

Confidential, MN

Application Developer

Responsibilities:

• Working with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions.
• Was involved in Informatica Power Exchange to test the data at mainframe .dat files.
• Created Data maps in Power Exchange to extract EBCIDIC data from mainframes.
• Implemented some coding in PWX to make length of COBOL copybook to data length of donor file and conversion files.
• Dealt with several kinds of data formats including half byte data for packed decimal formats.
• Implemented coding to extract copybooks and files from Mainframes using Job coding language (JCL).
• Review the data after every data cut on Mainframes by using FILE - AID and ISPF library.
• Working on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Working mostly on Lookup, Aggregator, Router and Expression Transformations to implement complex logics while coding a Mapping for date conversion etc.
• Developed T-SQL Queries to create tables and modify them
• Implemented integration for creating connection pools and Data Sources of Oracle, SQL drivers
• Created mapping for automation of audit process by using SQL transformation in Informatica.
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code.
• Creating Indexes on tables for most retrieved fields of tables and views.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.

Environment: Informatica Power center 8.6.1, Informatica Power Exchange 8.6.1, Oracle 10g, Toad for Oracle, Teradata, Ultra edit and UNIX.

Confidential

Database Intern

Responsibilities:

• Driving the technical design along with customer team, preparing design specs, functional specs, and other documents.
• Involved in all aspects of software development life cycle. This covers designing, coding, testing, implementing, deploying, and continued support of all projects owned by the team.
• Interact with business users as well as other members of IT outside of the team. Involved in preparation of specifications, development and testing of scripts.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Involved in writing various PL/SQL stored procedures, functions and packages.

Environment: Oracle 8i, Linux, TOAD, SQL, PL/SQL, Software Development Life Cycle