KHAN REZA

ETL / INFORMATICA

acwrob@r.postjobfree.com

213-***-****

Professional Summary:

7+ years IT experience in Data Warehouse applications using Informatica power center tool 9.6/9.5/8.6/7.5, Oracle, Teradata, MS SQL server on Windows, UNIX platforms.

Excellent understanding of ETL(Extract, Transform and Load) design principles and practical knowledge of performing ETL design processes through Informatica Power Center Tool.

Solid understanding of ETL design process and principle, development and maintenance using Oracle SQL, PL/SQL, Informatica Power Center.

Extensively worked in Repository configuration using transformation, creating Mapping, Mapplets, Workflow, Sessions, Worklets, and processing tasks using Designer/ Workflow Manager to move the data from multiple Source system to Targets.

Solid understanding of Data Warehousing concepts and Dimensional modeling (Star schema and Snowflake schema) and Relational Data Modeling and Slowly Changing Dimensions.

Expertise in creating Unix shell scripts like file validations, file downloads, workflow executions

Excellent understanding of OLAP (Online Analytical Processing) concepts and challenges, with large data sets.

Participated and understanding business requirements, discuss with Business Analyst to gathering and analyzing the requirements and to prepare business rules.

Experience in writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.

Good understating in Relational and Dimensional Data Modeling Techniques and existing data model of the Data Warehouse to design ERWIN data models.

Excellent interpersonal skills, technically proficient, decision making and detailed-oriented with problem solving skills and also ability to work independently.

Experience in import/export of data using Data loader, Informatica cloud connector from legacy CRM database into Salesforce.com.

Skills

Data Warehouse Tools

Informatica Power Center 9.6/9.5/8.x/7.x

Operating System

Windows XP/Vista 08/07, Unix, Linux, Putty, Winscp

Databases

Oracle 11g/10g/9i, MySql, SQL Server 2008/2012, Teradata,

Dimensional Data Modeling

Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Erwin.

Reporting Tools

SSRS, SSAS, SAP BO

Data Base Tools

Oracle SQL Developer, SQL Plus, Toad, MS office, Microsoft Visio, SharePoint.

Languages

SQL, PL/SQL, XML, Unix Shell Scripting

Email Clients

Outlook Express, IBM Lotus Note

Zurich Insurance Company Ltd, Plantation, FL

ETL/Informatica Developer: March 2016 to Present

Description:

Zurich is a Swiss insurance carrier with over 140 years serving businesses worldwide, including 100 years in the United States. Zurich Insurance Group (Zurich) is a leading multi-line insurer with about 55,000 employees worldwide serving customers in global and local markets. In North America, Zurich is a leading commercial property-casualty insurance provider serving small businesses, and mid-sized and large companies, including multinational corporations. Company headquarter is located in Zurich, Switzerland and Schaumberg, Illinois in North America.

Responsibilities:

Interacted with Business Analyst to identify the process and requirements gathering, implementing designs process, development and preparing business rules.

Worked in Software Development Life Cycle (SDLC) like in Agile Scrum methodologies.

Actively performed in the meeting and providing comments for user story review meeting in Agile Scrum environment.

Created Complex Mappings to load data using transformations like Source Qualifier, Expression, Aggregator, Dynamic Lookup, Connected and unconnected lookups, Joiner, Sorter, Filter, Stored Procedures, Sequence, Router and Update Strategy.

Developed Mapping using parameters, used Session parameters, Mapping variable/parameters and created Parameter files and runs of workflows based on changing variable values.

Implemented Slowly Changing Dimensions (SCD Type 1 & 2) in Mappings.

Worked on complex mapping for the performance tuning to reduce the total ETL process time.

Developed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle.

Developed Informatica Workflows and sessions connected with the mappings using Workflow Manager.

Involved in creating new table structures and modifying existing tables discussing with Data Modeler.

Experience in writing documentation like Micro documents from Macro documents, High level and low level design, analyzing Source to Target Mapping (STM’s), Test cases and Code migration report.

Developed Mapplets, Source and Target definitions, mappings, Reusable Transformations, using Informatica Power Center 9.6.1.

Update the tables as per the requirements by generating queries using SQL to check the data consistency in the table.

Checked Sessions and error logs to troubleshoot problems and also used debugger.

Created shortcuts for reusable transformation, source/target definitions, Mapplets in Shared folder.

Worked with various Salesforce.com objects Lead, Account, Contact, Opportunity, Campaign, Cases, Solutions Standard objects and Custom Objects.

Created Custom objects to build new application functionality in the Salesforce.com.

Responsible for understanding the data migrating requirements and analyze data to be loaded from legacy systems to Salesforce.com.

Worked on various Salesforce.com standard objects like Accounts, Contacts.

Customized page layouts for Opportunity, Contacts, and Accounts depending upon user roles, and groups.

Responsible for all the activities related to configuring Data Loader, uploading data in CSV files intosalesforce.com, checking for integrity of the data.

Environment: Informatica Power Center 9.6.1, SQL Server 2012, Power mart, Pl/SQL, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), Fimmas, Salesforce, XML, SharePoint, Lotus Note, Quality Center.

Well Care Health Plans, Tampa, FL

ETL/Informatica Developer: February 2014 – February 2016

Description:

WellCare Health Plans, Inc. began operations in 1985 and is based in Tampa, Florida. WellCare provides Medicare and Medicaid managed care health plans for 2.2 million members, partners with over 91,000 physicians, and employs over 3,500 associates. Wellcare Health Plans, Inc. is the holding company for several subsidiaries, including WellCare, Staywell, HealthEase, Harmony, and 'Ohana. Regional offices are located in Miami, Florida; Manhattan, New York; New Haven, Connecticut; Baton Rouge, Louisiana; Marietta, Georgia; Houston, Texas; and Chicago, Illinois.

Responsibilities:

Interacted with Business Analyst to identify the process and requirements gathering, implementing designs process, development and preparing business rules.

Worked in Software Development Life Cycle (SDLC) like in Agile Scrum methodologies.

Actively performed in the meeting and providing comments for user story review meeting in Agile Scrum environment.

Created Complex Mappings to load data using transformations like Source Qualifier, Expression, Aggregator, Dynamic Lookup, Connected and unconnected lookups, Joiner, Sorter, Filter, Stored Procedures, Sequence, Router and Update Strategy.

Developed Mapping using parameters, used Session parameters, Mapping variable/parameters and created Parameter files and runs of workflows based on changing variable values.

Implemented Slowly Changing Dimensions (SCD Type 1 & 2) in Mappings.

Worked on complex mapping for the performance tuning to reduce the total ETL process time.

Developed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle.

Developed Informatica Workflows and sessions connected with the mappings using Workflow Manager.

Hands on experience using query tools like SQL Developer, PLSQL developer, Teradata SQL.

Involved in creating new table structures and modifying existing tables discussing with Data Modeler.

Experience in writing documentation like Micro documents from Macro documents, High level and low level design, analyzing Source to Target Mapping (STM’s), Test cases and Code migration report.

Developed Mapplets, Source and Target definitions, mappings, Reusable Transformations, using Informatica Power Center 9.6.

Update the tables as per the requirements by generating queries using SQL to check the data consistency in the table.

Checked Sessions and error logs to troubleshoot problems and also used debugger.

Created Unix Shell Scripts to automate pre-session and post-session processes.

Created shortcuts for reusable transformation, source/target definitions, mapplets in Shared folder.

Environment: Informatica Power Center 9.6/9.5, Oracle 11g/10g, Power mart, Pl/SQL, Teradata, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), Erwin, Putty, WinScp, Linux, XML, Sharepoint, Quality Center.

CITI Group, Chicago, IL

Informatica Developer: May 2013 – February 2014

Description:

Citigroup is an American multinational banking and financial services corporation headquartered in Manhattan, New York City. Citigroup is today s pre-eminent financial services company and was built to create a highly diversified financial services company that could act as one to deliver solutions to clients throughout the world. The company has the most diverse array of products and the greatest distribution capacity of any financial firm in the world, and its employees manage 200 million customer accounts across six continents in more than 100 countries.

Responsibilities:

Interact with business analysts, Analyzed, inspected and translate business requirements into technical specifications.

Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.

Involved Creating Fact and Dimension tables using Star schema.

Extensively involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.

Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.

Design and developed complex informatica mappings including SCD Type 2 (Slow Changing Dimension Type 2).

Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.

Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.

Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Environment: Informatica Power Center 9.5/8.6, SQL server 08, Oracle 10g/9i, Oracle11g/10g, PL/SQL, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.

AAA, Washington DC

Informatica Developer: February 2011 – May 2013

Description:

AAA formerly the American Automobile Association is a federation of motor clubs throughout North America. AAA is a not-for-profit member service organization; in 2010, it had 51 million members. AAA provides services to its members, including roadside assistance and others. Its national headquarters are in Heathrow, Florida.

Responsibilities:

Work closely with project managers, business analysts, DBA’s to achieve business and functional requirements.

Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.

Worked on Informatica Power Center tool - Source Analyzer, Target Designer, Mapping Designer, Mapplets Designer and Transformation Developer.

Assisted in the design and Maintenance of the Metadata environment.

Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations.

Extensively used Source Qualifier Transformation to filter data at Source level

Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.

Created and monitored workflows and task using Informatica Power Center Workflow Manager.

Responsible for creating business solutions for Incremental and full loads.

Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.

Created high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.

Developed standard and re-usable mappings and Mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.

Performed unit testing, Integration testing and Functional testing of the mappings.

Environment: Informatica Power Center 8.6/7.1, Oracle Oracle10g, SQL, Teradata, DB2, Oracle 9i, Windows NT, UNIX (AIX 5.2), Flat files (delimited), UNIX Shell Scripting, ERwin, TOAD, Windows XP

Coventry Health Care, Newark, DE

Informatica Power Center Developer: October 2009 – February 2011

Description:

Coventry Health Care is a diversified national managed health care company based in Bethesda, Maryland, dedicated to delivering high-quality health care solutions at an affordable price. Coventry provides a full portfolio of risk and fee-based products including Medicare and Medicaid programs, group and individual health insurance, workers’ compensation solutions, and network rental services. With a presence in every state in the nation, Coventry’s products currently serve approximately 5 million individuals helping them receive the greatest possible value for their health care investment.

Responsibilities:

Responsible for designing and development, testing of processes necessary to extract data from operational databases, Transform and Load it into data warehouse using Informatica Power center.

Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.

Worked Extensively on Informatica tools like Designer, Workflow monitor and Workflow Manager.

Worked on all the Transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.

Created connected and unconnected Lookup transformations to look up the data from the source to ETL target tables.

Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.

Used the update strategy to effectively migrate data from source to target.

Created test cases and completed unit, integration and system tests for Data warehouse.

Involved in debugging and validating the mappings and Code Review to rectify the issue.

Extensively used various Performance tuning Techniques to improve the session performance.

Developed, implemented and enforced ETL best practices standards.

Worked on all the Transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.

Debugging and validating and executing mappings and Involved in Code Review and rectify the error.

Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.

The load ready files are loaded into Teradata Tables using Teradata ODBC/Fastload, Multiload connection. The Load Date and Time are also captured in the Teradata table.

Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).

Extensively worked on correcting and reloading rejected files.

Configured and used FTP by the Informatica Server to access source files.

Environment: Informatica (Power Center 8.6/7.1), Power Exchange, Windows, IBM DB2 8.x, Mainframes, SQL Server 2008, Oracle SQL 9i, PL/SQL, Erwin, Enterprise Architect,, ER studio, UNIX Shell Scripting, Putty, WinScp.

Capital One Financial, Los Angeles, CA

Informatica Power Center Developer: December 2008 – October 2009

Description:

Capital One Financial Corporation is an American bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. The company measured in terms of total assets and deposits, Capital One is the eighth largest bank holding company in the United States. As of 2012, The bank has 963 Capital One Bank Branches including 10 cafe style locations for their Capital One 360 brand and 2,000 ATMs. Capital One Financial is a member of the Fortune 500, and also conducts business in Canada and the United Kingdom. The company helped pioneer the mass marketing of credit cards in the 1990s, and it is now the fourth-largest customer of the United States Postal Service.

Responsibilities:

Maintaining the data coming from the OLTP systems.

Developed and maintained complex Informatica mappings.

Involved in analyzing and development of the Data Warehouse.

Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.,

Perform data validation tests using complex SQL statements.

Worked with data warehouse staff to incorporate best practices from Informatica.

Worked with Business Analysts, using work sessions, to translating business requirements into technical specifications, including data, process and specifications.

Implemented Type II slowly changing dimensions using date-time stamping.

Created database structures, objects and their modification as and when needed.

Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

Performed Unit testing and maintained test logs and test cases for all the mappings.

Testing for Data Integrity and Consistency.

Environment: Informatica Power Center 7.1, Informatica Power Center, Power Exchange, Windows, IBM DB2 8.x, Mainframes, SQL Server 2007, Enterprise Architect, ER studio, Oracle, SQL Plus, PL/SQL, Windows 2007

Education:

California State Polytechnic University, Pomona 2008

Bachelor of Science Degree

Electrical Engineering

Los Angeles City College 2004

Associate Degree in Arts of Natural Science and Mathematics

Contact this candidate