Summary




6 years of IT experience in analysis, design, development, data conversion, Data Warehouse, Business Intelligence, testing, documentation and implementation of client/server applications.
Extensive Data warehousing experience using Informatica 6. x/7. x/8 .x, Informatica Data Quality 8.6 and Data Modeling tools like ERwin.
Strong experience with RDBMS like Oracle 11g/10g/9i/8i/7 .x, Microsoft SQL Server 2005/2000/7.0/8.0 and Access. Knowledge of Teradata utilities SQL, BTEQ/ BTEQWin, FastLoad, MultiLoad, OleLoad, FastExport, etc experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
Experience in Informatica software installation, configuration for the Informatica client and upgrades as needed.
Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems.
Comprehensive knowledge in Extraction, Transformation and Loading of data using heterogeneous sources and targets.
Experience in performance tuning of Informatica sources, mappings, targets and sessions and tuning the SQL queries.
used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager
Worked extensively with complex mappings using Expressions, Filters, Routers, Look-ups, source qualifiers, sorter and aggregators.
Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.
experience in DCL programming and UNIX Shell Scripting.
experience in loading legacy data into SQL Server using Informatica and CONNX.
Experience in supporting VAX/VMS System.
Extensive experience in VAX RMS file structures, System Services, Library Utilities, System Utilities like Sort/Merge, Convert, Create and Analyze and DCL Command Files.
Experience in Business Objects, Actuate Reports, Web Intelligence, Supervisor, Universe design, calculating data fields and creating table, cross table, Line, Area and Pie chart reports.
Strong project management and leadership skills with proven ability in business analysis, application programming and troubleshooting. Self-motivated, excellent written/verbal communication, leadership and team work skills.


Employment

November, 2008 -  Present
+ Data Analyst

Project Descriptions :
Fleet Legacy is an inventory system used to track the rental vehicle assets. The system includes the processes for leasing vehicles, customer billing and vehicle depreciation. The Fleet software runs on unsupported hardware. This is a mission critical system that if left in its current state the hardware failure would increase over time and result in extensive outages. The hardware is outdated and finding replacement parts for repairs to the system is becoming an impossible task. In order to support the needs of the business this hardware needs to be replaced. This project will address the 6 VAX/VMS systems that are being used for Fleet and Finance applications Ross Data, Coda Data and Franchise Fee systems for both brands. There is 2 steps for this project 1 being the replacement of the 6 VAX/VMS systems used for the Fleet and Finance applications and step 2 the rewrite of the Fleet software for a modern platform.

Responsibilities :
Analyzed sources to verify data availability and to understand data quality.
Requirement gathering and Business Analysis.
Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
Worked with DBA to setup development, test, stage and production environments.
Performed impact analysis for systems and database modifications.
Involved in creating database using SQL server 2008 utility.
Implemented partitioning to handle tables with over 80 million rows.
Reviewed source systems and proposed data acquisition strategy.
Migrated historical data which is 1 time and built migration process for on going data loads using Informatica PowerCenter designer.
Developed complex mappings to load the data from various sources using different transformations like Expression, Aggregate, Update Strategy, Sequence Generator, Source Qualifier, Look up connected and unconnected, Joiner, Filter and Router transformations.

Used Debugger wizard to remove bottlenecks at source level, transformation level, session level and target level.

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.
Used Informatica Data Quality IDQ tool for data conversion, data quality and data cleansing.
Performed Informatica code migrations, test, debug and document and maintain programs and monitor according to DTAG standards.
Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Environment : Informatica PowerCenter 8.6.1 Informatica Data Quality 8.6, CONNX 8.90 Sql Server 2008, Crystal Reports, Microsoft Visual Studio, VAX/VMS system,, Microsoft Office 2003, Windows XP.

May, 2008 -  October, 2008
+ ETL Developer

Project : Secondary Dealer Interest Payments

Project Descriptions :
The amount that DTG pays for secondary dealer interest was identified as an area of expense that could be improved to save money. The payment cycle related to secondary dealer interest for DCX Daimler Chrysler vehicles is reduced, reducing the interest charges that DTG pays to secondary dealers.
The first phase of this project handled the immediate need of paying for these DCX vehicles as quickly as possible. The A/P payment cycle was increased from twice a week to 5 times a week. For the Fleet Accounting Department, that meant getting the DCX invoice data into the Fleet Legacy System as soon as it was received electronically from DCX. The second phase of this project will handle automating the selection of the invoices from every manufacturer for payment based on new user-configured dealer payment terms. The invoices is paid immediately if necessary or will wait as long as possible to be paid, depending on the dealer payment terms established for that dealer.
Responsibilities :
Analyzed business process and gathered core business requirements.
interacted with business analysts and end users to create Scope and High level requirements documents
Responsible for the design, coding, testing and implementation of Data entry screens and reports written in DATABUS.
Created Menu systems for end users to execute DATABUS programs written in Digital Command Language DCL.
Coordinated development efforts with offshore team used CONNX tool to read and write index files.
Developed ETL processes to populate the index files using Informatica, Oracle CONNX and UNIX shell scripts.
Performed data validation and error handling in the Informatica load process.
Created VBA programs to run Informatica processes using PMCMD commands for end users.
Developed, executed, documented Unit test plans, Integration test plans, System test plans validating the results with Business Analyst and Customers.
Developed tasks like sessions, emails and commands using Informatica PowerCenter Workflow Manager.

Environment : Informatica PowerCenter 8.6.1 Oracle 10g, CONNX 8.90 2008, Microsoft Visual Studio, VAX/VMS system, Microsoft Office 2003, Windows XP.

November, 2006 -  April, 2008
+ Developer

Project Descriptions :
Dollar and Thrifty operate 2 separate data warehouses which were both established before the catapult consolidation of the 2 companies. The business objective of the DTG Data Warehouse Consolidation project is to consolidate the current Dollar and Thrifty data warehouse information. The gathering of these resources reduces licensing, server count and the complexity of reporting. The business objective of the DTG Data Warehouse Consolidation project is to consolidate the current Dollar and Thrifty data warehouse information and re-write loads from multiple Dollar and Thrifty strategic source systems, incorporating all data into a shared platform. This information is made available for ad hoc reporting, canned reporting, analysis and export to various transactional systems.

Responsibilities :
Analyzed sources to verify data availability and to understand data quality

Used Informatica Designer to import the sources, targets, create various transformations, mappings for extracting, transforming and loading operational data into the Staging environment. Used various transformations like expression, filter, router, sorter, rank, source qualifier, joiner, aggregator, stored procedure and normalizer in the mappings.
Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
Created Mapplets and used them in different Mappings.
Used FirstLogic product, Information Quality link for Informatica. Used ACE transformation for Address cleansing and Match/Consolidate transformation for Matching, consolidating and group posting in customer mappings.

Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
Designed and developed the workflows, worklets and various reusable and non reusable tasks like sessions, emails and command using Workflow Manager and monitored the workflows using workflow monitor.
Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
Migrated development mappings to production environment
Transferred data from flat files to VMS system using Informatica and CONNX.
Used Informatica Scheduler for scheduling the workflows.
Created UNIX shell scripts to perform pre-session and post-session tasks. Used shell scripts for customized Event Waiting.
Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment : Informatica 7.1.3 firstLOGIC 7.50c Oracle 9i, Sql Server 2000/2005, ERStudio 7.1, Toad, Cognos, Microsoft Office 2003, Microsoft Visio, Windows XP.

August, 2006 -  October, 2006
ETL Developer

Project Descriptions : The Rearchitect Forward Engineer FE to J2EE EVC POC Project is a component of a pilot of the Modernization Services Rearchitect process. The Modernization Services Rearchitect process is composed of the Relearn process and Forward Engineering process. The purpose of the Rearchitect process is to provide a consistent and repeatable approach to understanding the behavior and requirements of legacy applications and transforming the applications into a modern architecture.

The FE to J2EE component uses the Forward Engineering process, known as the GSMS OCE work type, to develop a Java application from artifacts created during the Relearn process. The artifacts for this project are derived from a legacy application known as EVC. A copy of the application data is modeled, exported, transformed and loaded ETL into an Oracle Relational database, for use with the rearchitected application.

Responsibilities :
Involved in Designing Logical and Physical Database Designing using ERWIN Tool.
Created Tables, Table Partitions and Indexes on Oracle 9i. Implemented integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
Creations of generic scripts for the extraction of data from Legacy system to flat files.

Used Informatica Power Center for extraction, transformation and Loading ETL tool to load data from flat files source to target Oracle tables.
Implemented various transformations using like Expression, Lookup, Sequence generator and Source Qualifier, Rank, Aggregator etc.
Collecting requirement and doing analysis for the reports.
Ensured the Business Rules and Data Validation
Involved in writing the test cases and documentation.

Environment : Informatica 7.1.3 Oracle 9i, ERwin, Toad, Microsoft Office 2003, Microsoft Visio, Windows XP.

January, 2006 -  July, 2006
Informatica Developer

Project Descriptions :
The Main objective of this project is to provide an integrated view of EDS resource supply and projected demand to help drive labor and training strategies, work assignment and other relevant workforce activities. The application will use common definitions, taxonomies and metrics for the entire global enterprise to support a consistent workforce management process where possible. It will improve the accuracy and currency of data by automating the collection data from multiple source systems.

Responsibilities :
Analysis was done using existing transactional database schema and designing star schema model to support user need for reporting.
Helped in Analysis and design of table Structure for the development of data warehouse and data marts.

Created mappings for extraction, transformation and loading from heterogeneous sources to targets.

used ETL tool Informatica to load data from ORACLE source to SQL Server target.
Involved in the development of Informatica mappings and tuned for better performance.
Implemented various transformations using like Expression, Lookup, Sequence generator and Source Qualifier, Rank, Aggregator etc. To load the data from Staging area to EDW Enterprise Data ware house.
Ensured the Business Rules, Data Validation and ETL standards.
Constructed mapplets for reusable business process in development.
Tested all the business application rules and monitored the sessions, worklets and Workflows using Informatica Workflow Manager.
Used UNIX scripts to build Parameter files.
Created Store procedures in Oracle database to import procedures into Informatica for the business usage.
Tested all the business application rules with test and live data and monitored the sessions.
Created design documentation for UAT.

July, 2005 -  December, 2005
Informatica Developer

Project Descriptions :
EDS has embarked on a multi-year plan MYP that will transform EDS s business processes, creating new capabilities and efficiencies for the company. The objective of the Operating Metrics project is to capture as much of the data via automation where possible and in the time frame required by the business, calculate key Transparency metrics and create useful reports to analyze and compare results.

Responsibilities : Involved in Data modeling and design of Data warehouse using Star schema methodology and confirmed granular dimensions with FACTS tables.
Involved in Data loading from different sources Using ETL tools of Informatica Informatica Power Centre, Power Mart.

Created several mappings related to transparency for extraction, transformation and loading from sources Oracle to targets SQL Server.
Tested all the business application rules and monitored the sessions, worklets and Workflows using Informatica Workflow Manager.
Created Parameter files.
Tuned all mappings in order to increase the performance-related issues for existing data.

Involved in writing source to target mapping documents and unit test cases.

Environment : Informatica 7.1.2 Oracle 9i, Sql Server 2000, ERwin, Toad, Panorama, Microsoft Analysis Services, Microsoft Visio Windows XP.

January, 2004 -  June, 2005
Informatica Consultant

Project Descriptions :
The Insurance Company has started to build a data warehouse system to evaluate policyholders and setup regional markets. The code involved reading from complex source flat files, having variable length records, performing various transformations and writing to proprietary target systems typically hierarchical in nature in a specified format.

Responsibilities :
Involved in Analysis and design of table Structure for the development of data warehouse and data marts

Creating the mappings in the Informatica for extraction, transformation and loading from flat files to targets.
Creations of generic scripts for the extraction of data from different source system to staging.
Involved in Data loading from different sources Using ETL tools of Informatica Informatica Power Centre, Power Mart
Implemented various transformations using like Expression, Lookup, Sequence generator and Source Qualifier, Rank, Aggregator etc. To load the data from Staging area to DW
Collecting requirement and doing analysis for the reports.
Was responsible for bring the data from the different source system to the staging area and to the warehouse.
ETL process and creation of several dimensional cubes for web reporting using tools like INFORMATICA and Actuate reporting tools.
Scheduling the batch jobs for the UAT and Production environments.

Created PL/SQL programs like procedures, function, cursors to extract data from Target System

Environment : UNIX, OLAP tools, Erwin, Windows NT, Actuate 6.0, Informatica 6.2, Informatica Power Center, Power Mart and Power Plug, TOAD, SQL*PLUS, Business Objects, Oracle 9i, Teradata, Unix.

April, 2003 -  December, 2003
Informatica Developer

Education

Skills


ETL Tools : Informatica PowerCenter 6. x/7. x/8 .x, Informatica Data Quality 8.6 OLAP Tools : Business Objects 5.0 or 5.1, Microsoft Analysis Services, Cognos, Crystal Reports. RDBMS : Oracle 8i or 9i/10g/11g, Sql Server 2000/ 2005/2008, DB2, Access 7.0 or 2000 Languages : HTML, DHTML, C, C++, VB, JAVA, ASP, UNIX Shell Scripting, SQL, PL/SQL, DCL, DATABUS. Operating Systems : UNIX, LINUX, Windows 98/NT/2000/XP, MS-DOS, OpenVMS 5.2. Tools/Utilities : ERwin, TOAD, CONNX 8.90 dbSaint, FirstLogic, Microsoft Visual Studio, Visual Basic. Net, Project 2000, VISIO, SmarTerm 11.0a Mobius, 24x7 scheduler.


Miscellaneous

Manulife Financial is a leading Canadian-based financial services company, operating worldwide, offering a diverse range of financial protection products and wealth management services. Recently Manulife has bought over John Hancock Financials. The objective of the project was to consolidate data from various systems namely Oracle, Siebel, DB2, VB into a centralized database which is in Sql Server using Informatica product suite.
Responsibilities : Involved in Analyzing, Designing and Implementing the ETL architecture.
Used various data sources namely Oracle 9.2/8i SQL server
Populated the SQL Server ODS and generated the flat files on scheduled basis.
Analyzed all the data sources and develop requirements for data conversion.
Designed and developed the workflows/sessions using Workflow Manager and monitored the workflows using workflow monitor.
Used Informatica Designer to import the sources, targets, create various transformations, mappings for extracting, transforming and loading operational data into the Staging environment.
Used various transformations like expression, filter, router, sorter, rank, source qualifier, joiner, aggregator, stored procedure and normalizer in the mappings.
Develop and test data conversion scripts and programs based on the data mappings and transformation rules.
Validate the data loaded into the production database to ensure data quality and generate reports to represent data completeness.
Involved in the data integration from John Hancock Financials mainframe data.
Support DW team on analysis and providing of data for DW purposes.
Experience in Creation of Aggregate, Expression, Filter, Join, Lookup and Rank Transformations start all the Tasks in the Workflow at once
ENVIRONMENT : Informatica PowerCenter 6.2 Informatics Server, Repository Server, Repository Manager, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, PowerMart, Power Analyzer 3.5, Power Connect for Siebel, Oracle 9i/8i, Sybase, SQL Server, TOAD, Erwin, SQL *Plus, Sybase, TOAD, Windows 2000/NT, Unix.
References available upon request