Summary


REHMAN SHABANA



8+ years of professional work experience in analysis, design, development and support using ETL Tools Informatica Power Center and Ab initio in Banking and Healthcare domain.
5 Years of strong experience using Informatica Power Center 6. x/7. x/8 .x. with various tools designer, repository manager, Workflow Manager and Workflow monitor. Excellent with all the Transformations- connected and unconnected lookup, Joiner, aggregator, expression, normalizer, router. Implimenting Change Data capture CDC on data extracted. Utilized Informatica B2B exchange and Transformation.
3+ Years of strong working experience using Ab initio coop 2.13/2.14. Designed and developed complex graphs with multiple sub-graphs in a large Database Systems VLDB environment with massive parallelism. Configured graph parameters, sandbox parameters, environment variables and EME Repository environment for Production/Development and performance tuning for load graph process.
Over 4 Years of strong experience using Teradata utilities like MLoad, Bteq, OLE Load and Fast Load. Excellent knowledge on Teradata architecture. Used Teradata loader utilities in conjunction with ETL tools Abintio and Informatica and designed, developed and maintained ETL process which was loading huge volume of data into teradata using Teradata loader utilities. Good knowledge of Teradata Parallel Transport utility TPT coding.
Proficient in implementation of Agile methodology in projects.
Strong working experience in databases like Teradata, Oracle, IBM DB2 and Sybase. Written complex SQL queries for testing developed ETL objects against databases.
Excellent knowledge and work experience in UNIX Commands Sun Solaris. Proficient in shell scripting.
Excellent experience in dimensional modeling and data modeling. Deep insight of normalization techniques.
Worked on complete software development life cycle SDLC starting from information strategy planning, requirement analysis, design, development, coding, testing, debugging, performance tuning and implementation to production support.
Thorough knowledge and experience in implementing data warehousing concepts like SCD, CDC and dimensional modeling Star and Snowflake schema.
Clear understanding on E-LT Extract Load and Transform tool Oracle Data Integrator. Thorough knowledge on Topology manager, Designer, Security manager, Operator and good understanding on the Projects, models, static/flow control, load knowledge module, integration knowledge module and check knowledge module.
Knowledge of Version Control tool Clear Case and defect tracking tools like Clarify and Clear Quest.
Strong communication skills, systematic approach and quick adaptability to new technologies and new working environment.


Employment

January, 2009 -  Present
Informatica Lead/ developer

Valuation : This Project mainly deals with estimating the futuristic business for the life and the health insurance of the existing clients. This project we have utilized the ability of database partitioning to increase the speed of loading and faster access of the data warehouse. This enhances the usability of the warehouse. Moving the whole application from 2 - tier architecture to 3 - tier architecture.
Contributions : worked with Business Users/Business Analysts in getting functional knowledge and developed detail design, strategies for ETL processes.
Used File Transmission Protocol FTP for fetching the files from client location
Used Informatica B2B exchange to connect the enterprise with the business partners and customers.
Designed the overall ETL Architecture.
Involved in Capacity planning, resource allocation and dependency analysis.
Co-ordinate with the offshore team in on time delivery of the requirements.
Involved in dimensional modeling and data modeling of the warehouse as a Junior Architect.

Designed, developed and unit tested mappings for Extraction, Transformation and Loading of data from source to target.
Converting the XML structures and loading to the DB2 database.
Tuned mappings for better performance.

used various source systems like flat file, Input table and Output table and transform components like Joiner, Lookup Filter, Router and other components Workflow session.
Involved in developing UNIX Korn Shell wrappers to run various Scripts.
Involved in unit testing, integration testing and troubleshooting.
Involved in creating Stored Procedures for relating the front end and Java.
Environment : Database IBM DB2, Tools - Informatica 8.1, Java Engine, Erwin, Perl and O/S - AIX, Windows XP Reporting : Business Objects.

Projection : This project deals with the automating the existing health and life insurance business application. Manly aimed at enhancing the existing backend system for faster and better access of the application. Creating multiple users for utilizing the application. Creating various stored procedures for the frontend to better access the backend.
Contributions : worked with Business Users/Business Analysts in getting functional knowledge and developed detail design, strategies for ETL processes.
Used File Transmission Protocol FTP for fetching the files from client location.
Designed the overall ETL Architecture.
Used Informatica B2B exchange to connect the enterprise with the business partners and customers.
Involved in Capacity planning, resource allocation and dependency analysis.
Co-ordinate with the offshore team in on time delivery of the requirements.
Involved in dimensional modeling and data modeling of the warehouse as a Junior Architect.

Designed, developed and unit tested mappings for Extraction, Transformation and Loading of data from source to target.
Tuned mappings for better performance.
Converting the XML structures and loading to the DB2 database.

used various source systems like flat file, Input table and Output table and transform components like Joiner, Lookup Filter, Router and other components Workflow session.
Involved in developing UNIX Korn Shell wrappers to run various Scripts.
Involved in unit testing, integration testing and troubleshooting.
Environment : Database IBM DB2, Tools - Informatica 8.1, Java Engine, Erwin, PERL and O/S - AIX, Windows XP Reporting : Business Objects.

February, 2008 -  Present
Informatica Lead

CRUSE :
To Move and store Picasso CRUSE data on IDN DW, create a portal tool that allows for Executive MIS reporting. In doing, this project will provide metric scoring and reporting for the Business Growth Consultant BGC role encompassing those acting directly as Business growth Consultants and those supporting it through Commercial Underwriting CUW. These metrics is used to measure BGC and CUW productivity and express achievements and milestones in areas key to meeting business objectives. Completion of this project will provide capability for BGC and CUW associates to be included in incentive pay programs.
Contributions : worked with Business Users/Business Analysts in getting functional knowledge and developed detail design, strategies for ETL processes.
Involved in Capacity planning, resource allocation and dependency analysis.
Co-ordinate with the offshore team in on time delivery of the requirements.
Involved in dimensional modeling and data modeling of the warehouse as a Junior Architect.

Designed, developed and unit tested mappings for Extraction, Transformation and Loading of data from source to target.
Tuned mappings for better performance.

used various source systems like flat file, Input table and Output table and transform components like Joiner, Lookup Filter, Router and other components Workflow session.
Involved in developing UNIX Korn Shell wrappers to run various Scripts.
Created functional and unit test cases and executed the same. Also, created a production support document, High level design and Detail design documents
Involved in unit testing, integration testing and troubleshooting.
Environment : Database DB2, Tools - Informatica 8.1, Java Engine, and O/S - UNIX, Windows XP.

Radio : Triumph Customer Service will create a new batch job that will unload all Manual Construct Change and Manual Construct Lock Counter Change for the current batch processing day from the Minimum Payment History Update table. Data is put into a 60 generation GDG file to be fetched by the IDN group for reporting.
Environment : Database DB2, Tools - AQT, Informatica 8.1, Java Engine, and O/S - UNIX, Windows XP.

Contributions : Involved in understanding the requirements of the end Users/Business Analysts and developed detail design, strategies for ETL processes.
Partition components like Partition by Key and Partition by Expression were used to partition the data files to facilitate parallel operations on the partitioned datasets on different nodes and use the parallelism features of Informatica to good effect
Worked on improving the performance of mappings.
Created reusable generic mappings.
Created shell scripts for automating the process.

Strategy Flag : Create monthly Strategy Flag file in IDN from GRMS database output file provided to get complete list of flagged accounts. Currently when GRMS assessment file is used it does not capture all flagged accounts. We get different data for various markets and this has information about the various modifications done at the account and the customer level.
Environment : Database DB2, Tools Informatica 8.1, Java Engine, and O/S - UNIX, Windows XP.

January, 2007 -  December, 2007
ETL Lead

Description : The purpose of this project was to collect all the non card suppliers and check them against VMPD database to know if they card acceptors. Finally a csv file was generated and sent through OFT to validate against existing supplier database. A notification was sent to the Non card suppliers if they were willing to take payments through cards. This phase provides the buyer with the WEB service which facilitates the power of requesting for generating various cards.

Contributions : Requirement analysis and creation of ETL specifications.
Guided the team in designing and developing ETL mappings for creating csv file and modified the existing mappings to accommodate non supplier information.
involved in data modeling of the Database using Erwin.
Utilized Teradata utilities and performance tuned the database.

Inserted the last used card value and other values for the online use.
Created graph level parameters to co-ordinate with the java properties file for automation.
Unit testing and integration testing of data samples.
Tuned mappings for better performance. Created functional and unit test cases and executed the same.
Post-production support.
Environment : Database - DB2, Teradata Tools - AQT, Informatica 8.1, Java Engine, and O/S - UNIX, Windows XP

2. Project : Accounts Payable Automation Service APAS Phase I

Description : The purpose of this project was to be able to process all payables in an accounts payable file and identify opportunities to convert non-card payments to the purchasing card program. The APAS service for payments would create new and leverage existing automated procedures to submit payments to suppliers and reconcile payments against purchase orders/invoices. It has following steps Pre-process, payment process, reconciliation and extraction.
Environment : Database - DB2, Tools - AQT, Informatica 8.1, Java Engine and O/S : UNIX, Windows XP.

3. Project : VIM CCDRi

Description : CCDRi deals with the commercial card data processing of international banks. Its vision was to build or integrate service oriented data collection, integration, delivery platform to improve the performance, maintainability, extensibility, traceability, audit ability, robustness and scalability of the data processing and implementing the newer functionality

Contributions :
Loading data into various target locations for deals from various banks.

Certification of new bringons new member banks.

Creating a status report of all the deals.
Ad-hoc requests and troubleshooting the system.
Environment : Database - DB2, Tools AQT and O/S : UNIX, Windows XP.

December, 2004 -  November, 2006
ETL Developer

1. Project : Clinical Services Profitability

Description : This project dealt with the creation of profitability table. Clinical services objective was to implement a financial reporting solution to enable the Key Performance Indicator KPI and P and L reporting. The tool developed had provided a rich OLAP layer to the business analytics to determine complex ad-hoc and detailed reporting of the business profitability at various levels. It helped in identifying the Financially Challenging Accounts FCA s

Contribution :
Created XFRs and complex Graphs for data loading from relational and flat file source into teradata targets using teradata loader utilities.
Used Components like unconnected lookup, joiner, reformat
Created parameter files and shell script.
Created B-teq Scripts and used utilities MLOAD and FLOAD.
Unit testing and integration testing of data samples.
Performance tuning of Graphs. Creating functional and Unit test cases, executing the same.
Post-Production Support.
Environment : Database - Oracle 9i/10g Teradata, Tools Abinitio GDE 1.11 Toad, Cognos ReportNet, and O/S - UNIX, Windows XP.

Project : Sales Work Bench SWB-Siebel ITO

Description : The purpose of Sales Workbench SWB was to provide end-to-end reporting solution on the sales lifecycle. This has eliminated redundant reporting tools and spreadsheets mechanisms of reporting and provided Multi-dimensional analysis capability using COGNOS and Reportnet analytical tools. Biosciences and GEHC Services were using siebel application for opportunity management. As part of siebel ITO FW10 release we is bringing in clinical service opportunity data into BI from Siebel.
Environment : Database - Oracle 9i, Teradata, Tools - Abinitio GDE 1.11 Toad, Cognos ReportNet, and O/S - UNIX, Windows XP.

October,  -  December, 2004

Education

Skills


ETL Tools : Informatica Power Center 5x/6x/7x/8x, Informatica B2B exchange, Ab initio 2.13/2.14. OLAP Tool : Cognos 7.x, Business objects. Modeling Tool : Erwin Scheduling Redwood Cronacle Languages : UNIX Shell Scripting, PL/SQL, SQL*Plus Databases : DB2, Oracle 8i/9i/10g, Teradata V2R5/R6 Sql Server Operating System : Win 95/98/2000 Professional/XP/2003, UNIX Sun Solaris, AIX Description : The aim of the project was to load the data from various applications to the telecom data warehouse using ETL tool to determine the no. of pieces manufactured and sold. It was meant for the use of executives, Senior Managers and Business Analysts with access to accurate, consolidated information. It was used for trend identification, forecasting and competitive analysis and targeted market research. Client wanted to have some system which can give those reports of their business situation and can help them to analyze the business. Environment : Database - Oracle 8i, Tools - Informatica 5.1/6.2, Abinitio GDE 1.09 coop 2.09 and O/S - Windows XP.