Objective

Seeking position as Senior Data warehouse Specialist, this include Architect, Data Model, Analysis or ETL

Summary of Qualifications

• Worked on all phases of data warehouse development lifecycle Requirement gathering, Business Analysis, Implementation, and Unit and System testing
• Demonstrated expertise utilizing ETL tools, including Informatica 7.x, 8.x, 9.x , Sagent, and DataStage. RDBM systems Teradata, Oracle, SQL Servers, Informix, and Sybase . Very experienced in UNIX command and scripting
• Team lead and player with excellent communication and problem solving skills

Professional Experience

Confidential

Sr. Data Warehouse/ETL Lead

Responsibilities:

• Worked on Quality Council CORE Data Mart
• DW projects to enhance the existing DW
• EPIC 2010, apply all the changes needed in Stage and DW to comply with EPIC 2010 upgrade
• Upgrade the DW with new data feed from EPIC
• Work on EDW data load, involved in the Architect, and work on ETL

Environment: Informatica PowerCenter 9.5, Oracle 11g. Modeling tool Oracle Designer , Informatica B2B data exchange 9.1 and 9.5 , Informatica Metadata Manager 9.1

Confidential

Sr. Data Warehouse/ETL Consultant

Working park time with Habitat

Responsibilities:

• Understand the new requirement and provide feed back on the data model for the new project
• Provide tips for the development of the new project
• Support the ETL team when needed

Environment: Informatica PowerCenter 9.x. Teradata 13, 13.10 , SQL Server 2008, Oracle 11g. Modeling tool ERwin

Confidential

Sr. Data Warehouse/ETL Consultant

Build the first DW for Catasys and create all the ETL processes

Responsibilities:

• Create Requirement Document: Understand the business roles, gather the business requirement for the project, then create the project Requirement document
• System Architect. Create the system architect document for the project
• Data Warehouse Architect. Creates the DW architect diagram
• Logical and Physical Data Models. Creates logical and physical model for the Data Warehouse
• ETL packages. Create ETL packages to load the data to stage, then DW using SSIS
• Optimize the SQL Server DB for best performance
• Unit test and QA
• PRODUCTION. Copy the DW to create production copy, then migrate the data and ETL
• Data Marts. Create Data Marts and Aggregate table

Environment: SSIS and SQL server DB 2005 and 2008 . Modeling tool MS Visio

Confidential

Sr. Data Warehouse/ETL Consultant

Responsibilities:

• Implemented DW and Informatica best practices
• Developed and Unit test 1.1 release for the EDW, Worked on GL ENTRY process and GL Sources
• Analyze and create ETL Design Document for EDW Release 1.2
• Architect and redevelop GL ENTRY process Improve the performance and usability
• Worked on other components for Release 1.2 GL ACCT, GL BUDGET and others
• Provided feedback on the DQC process from the DW stand point and ETL
• Support other ETL developers
• QA and set up automated processes to provide DW load quality check

Environment: Informatica PowerCenter 9.x. Teradata 13, 13.10 , SQL Server 2008, Oracle 11g. Modeling tool ERwin

Confidential

Sr. Data Warehouse/ETL Lead

Continue working on EPIC project Enhancements .

Responsibilities:

• Provided support for Architect or Modeling for new projects
• Architect and Developed CFSPatient Satisfaction Dashboard load into the Data Mart
• Analyze and upgrade Census Data Mart project Daily Admissions, Daily Patient Movement, and Daily Discharge . Created automated scripts to test the targets after loading the data
• Developed mechanism to flag records in hospital patient information Cancelled patients and other logics
• Analyze and fix existing processes. Visit Summary, Charge Detail , to improve the performance and the usage of the system resources
• Analyzed and developed CONCUITY project to provide analytical data to third party
• Worked on CSLink, massive change to the DW source system Data types and Size
• Mentor other team members

Environment: Informatica PowerCenter 8.6.1. Oracle 11g. Modeling tool Oracle Designer

Confidential

Sr. IT Integration Specialist Architect, Modeling, ETL

Worked on Sales revenue Integration Service project at ASP Johnson Johnson company.

Responsibilities:

• Analyzed the requirement for the SRIS Sale Revenue Integration Service project and provided the system architect
• After getting the approval on the system architect, worked on the DW architect and modeling
• After getting the approval for the Logical and Physical data model, worked on Detailed Design document
• Started the Development of the ETL and Unit Test
• Mentor Sr. ETL developer to take over the project
• Ensure SOX compliance by enforcing corporate CAV process. This included Archiutec and design the CAV process and tables

Environment: Informatica PowerCenter 8.1.1 and 8.6.1. SQL Server 2008 as db. Ensure SOX Compliance. Modeling tool MS Visio

Confidential

Sr. Data Warehouse/ETL Lead

Cedars upgraded There on line systems for the Hospital, Clinics and all other departments from PCX to EPIC. EPIC has it's own on line data storage that will become the new DW source. My main responsibility at cedars was working on the EPIC project as architect, analyst and lead developer to update the existing DW to be able to store the new data, this includes architect and build ETL processed to bring the data to the DW

Responsibilities:

• Analyze and rearchitect the existing DW to comply with EPIC project
• Verified all Epic ETL design documents and provide feedback when needed
• Developed and Unit test staging environment ECODESR, HBSR, Supervise the development of HBSR
• Performed Admin tasks on the Informatica server, this included creating accounts, assigning privileges, and creating shared and reusable objects .
• Improved the performance of patient process, was taking 3 Hours for 500K records, to 20 minutes . Improved the transaction process was taking 2 hours for 400K records, improved to 18 minutes for the same number of records . By applying DW and ETL best practices
• Used Pushdown optimization to improve the performance when loading the DW to push the transformation logic into the Source / Target database.
• Developed UNIX shell scripts to perform various tasks checks on the trigger files, and archive data files, etc.
• Created migration documents, led the processes of migrating the code from DEV to TEST then PROD
• Recognized for completing tasks in a very timely manner and provide high quality code

Environment: Informatica PowerCenter 8.1.1, Push Down optimizer, Oracle 11g, SQL, PL/SQL, XML, Toad 9.5, Business Objects XI, Unix, Windows XP,Informatica Data Analyzer.

Confidential

Sr. ETL Architect

• Designed and developed Informatica objects to support the company's needs, this includes Unit testing and QA
• Upgraded from Informatica 7.x to 8.1, then to 8.5
• Analyzed and implemented different projects for different clients. Started by gathering the requirements, writing the design documents and conducting all required development, including the UNIT testing and QA
• Supported development, production and business groups by providing technical tips
• Identified some bottlenecks with the mapping and improve the performance by using Pushdown optimization.

Environment: Informatica PowerCenter 8.1.1, Informatica Power center 8.5x, Sybase, SQL, Push Down optimizer

Confidential

Lead Informatica Specialist/ Data Warehouse Architect

Responsibilities:

• Spearhead creation of complex data model structures focused on imminent organizational development and established architectural frameworks for risk mitigation and everchanging business needs
• Installed and setup Informatica v 7.x then Upgrade to 8.x, include setting up user accounts, folder, standards, and configuring Informatica server to support the company needs
• Perform Admin tasks
• Gathered the requirements for the Data Warehouse projects
• Provided tips and suggestions for both Logical and Physical Data Models
• Completed design and modeling process of the first Phase of the Data Warehouse
• Worked on the design for ETL processes and distributed the work between the ETL developers
• Lead the development team during the development process, this include providing Informatica and ETL support
• Snow flaked some of the dimension tables to support MicroStrategy tool
• Responsible of building and executing QA and code review processes for the ETL team. This includes QA of the logic of the ETL processes when loading data into the dimensions and facts.
• Optimized the data warehouse to achieve the best performance to support loading and reporting

Environment: Informatica PowerCenter 7.X and 8.x and DataStage 7.x , Oracle 10G, SQL and PL/SQL, Push Down optimizer. Windows servers, people Soft DB

Confidential

Senior Consultant Data Warehouse/ETL

Responsibilities:

• Supported all Informatica daily admin tasks, provided suggestions to improve the server performance. Also provided Production support during the day and at night
• Developed QA process to load the web logs into the Data Warehouse using Informatica. The new processes achieved improvement in the process performance comparing to the existing process in Sagent , runtime dropped from 3 hours to 45 minutes
• Attended daily and weekly meetings with the business team to discuss all data quality issues and communicated between the marketing team and the Data Warehouse team
• Led and worked on fixing the data quality issues, this includes code fix and data fix. Issues dropped from 60 issues to 5 after 3 weeks
• Performed the design for SuperDog and SuperDog Phase II Projects. provided support for the development team and monitored the development process
• Redesigned Search Engine process. This process caused a lot of issues for the company, so I provided the team with a better solutions to optimize the process running faster
• Gathered requirements for new projects, created Architect and Design documents
• Used MicroStrategy to QA Informatica processes and find data quality issues

Environment: Sagent, Informatica PowerCenter 8.x, Oracle 11G, SQL Server and Teradata. Push Down optimizer. UNIX. Modeling tool ERwin

Confidential

Consultant Sr. Data Warehouse Architect/ETL Lead

Responsibilities:

• Installed and setup Informatica 8.x
• Worked as an Admin for Informatica servers Production, Development, QA and UAT
• Installed and Admin Informatica reporting tool data analyzer Similar to MicroStrategy
• Provided technical lead for the reporting team
• Worked close with the Sr. Data Warehouse manager to gather the requirements for the Data Warehouse projects from the OLTP Oracle source DB
• Analyzed the Source systems and provide tips on building dimensions and fact Tables
• Completed the design and modeling process of the first and second Phases of the Data Warehouse
• Completed ETL design documents, provided supervision for the ETL team.
• Helped in developing Informatica mappings, PL/SQL code to fix issues in production database
• Performed QA and code reviews for the ETL code and provided tips for the DW team to improve the performance of there ETL jobs.
• QA the data warehouse to achieve the best performance for all the reports
• Worked on setting up the infrastructure for the reporting tool DA , provided technical tips and supervision for the reporting team

Environment: Informatica PowerCenter 8.x, Oracle 11G, Data Analyzer, Push Down optimizer. UNIX

Confidential

Sr. ETL Consultant

• Joined HealthNet Pharmacy team in May 2005 to architect and develop the Medicare Part D project and other projects assigned to the team.
• Responsibilities:
• Worked on Medicare Part D project, this included writing the specs and the development of the project
• Developed and QA Claim loads from different vendors Daily and Cycles
• Supported the pharmacy team in Data Warehouse Phase II project. This included developing and updating mappings
• Optimized current processes by applying Informatica and SQL skills. Reduced the load time from eight hours to less than an hour by replacing lookup with outer join
• Helped in developing Informatica mappings, PL/SQL code to fix issues in production database
• Provided Date Warehouse design tips for the team, include cleaning there dimensions cleaned half million records were not connected to any fact
• Provided tips for the DW team to improve the performance of their ETL jobs.
• QA Medicare Part D and performed code reviews

Environment: Informatica PowerCenter 6.x, Oracle 10G, UNIX, HealthCare system

Confidential

LowerMyBills.com is a simple and intuitive Web site to help every American household save money for the important things in life.

ETL Engineer Senior ETL Engineer / DW Architect

Involved with other DW team member in: Architect and Develop the new Data Warehouse. Meanwhile Support the current system. Provide support to the DW team. Help in moving the current DW to the new Environment.

Responsibilities:

• Worked on Data Warehouse Next Gen project. Retire the old system Sagent, Windows NT and move completely to Informatica. UNIX . This included moving from SQL server to Oracle DB.
• Realty Project: Architect and Design of the Data Warehouse and ETL to store the Realty Data.
• Product Revenue: retrieve Home Loans Transactions data from Oracle to Data Warehouse using Informatica. ReDesign the old process and develop it. Result is improvement in the run time From 45 Minutes to 5 minutes
• Publisher Upload: Load Impressions and Clicks from Different provider sites to DW. Run time Improved by 80 30 45 Minutes to 5 10 Minutes .
• Completed Phase I of DW next generation project. Moved all CAS pieces from sagent Wind NT to informatica SUN . This resulted with big performance improve from 20 minutes to 4 minutes
• Completed Architect, Design, and Development of Lead Gen transactions load. In this project we pull transactions from Oracle that do not come from Web Logs.
• Campaign ROI new System. Improved run time from 25 45 minutes to average of 8 minutes.
• Support DW team.
• Led the efforts to recover from the hardware failure.
• Worked closely with the marketing analysts to support their requirements and provided them with data analysis and profile
• Performed high level optimization for daily processes
• Provided support to analyze the data and define the issues when found
• Designed all new processes to comply with the new DW generation UNIX, Oracle, and Informatica
• Helped with the Informatica installation under Unix environment
• Redesign all the current processes to run on the new system. This included the optimization using the advanced features in Informatica
• Worked on DataStage DS evaluation.

Environment: Sagent, Informatica PowerCenter 8.x, Oracle 11G, SQL Server. Push Down optimizer. UNIX. Modeling tool ERwin

Confidential

Alliance Data Systems provides privatelabel credit card services, transaction services and marketing database services for some of the most successful companies in North America.

Application Programmer Analyst 2000 2002

Defined functional and detailed designs analyzed systems and developed solutions for highly complex problems that required extensive investigation. Wrote advanced code and performed optimization on processes in both the programming and the database sides. Performed unit and system testing. Provided QA team with required support. Worked with developers to define standard, solved problems, researched and evaluated software/hardware to assist in programming or to use as program platforms. Also was responsible for POS Data Manipulation, as required.

Systems Support Analyst 1998 2000

Administered segmentation, aggregation and campaign management tools. Designed and developed C/ESQL code to implement AdHoc requests. Supported Campaign Management Analysis team.

Confidential

Student Assistant System Administrator and Database Programmer 1998

Design and wrote code to maintain and modify OCLS library database systems using Access 97, and Informix SE 4.x. Administrated AIX 4.x/IBM Risc6000 server operations.

Confidential

Teaching Assistant

Taught CPS100 Classes and graded lab assignments and quizzes.