Resume of Consultant (Data Architect, ETL Desing and Lead)




Title
Consultant (Data Architect, ETL Desing and Lead)

Primary Skills
Data Warehousing (Architec, Modeling, Lead ETL development)

Location
US-CA-Los Angeles

Posted
May-04-07

RESUME DETAILS
MAJD DAYEH

3701 Overland Ave.
# F151 Cell: (818) 554-8056
Los Angeles, CA 90034 Home: (310) 559-8710
mdayeh@yahoo.com


OBJECTIVE

Seeking a Contract position in Data Warehousing, as DW Architect, ETL Architect, Lead ETL, or DW Analyst. Looking in the Los Angeles area. Very experienced in ETL performance tuning.

SUMMARY

Ten years of Data warehouse experience with a wide repertoire of technical qualifications. Proven track record of successes in team development, customer relationship management. Expertise in Data Warehouse Architect, Data Analysis, and Lead Data Warehouse Development this include ETL. Skilled in the QA process for all type of DW projects. Skilled in install and admin Informatica 7.x and 8.x. Skilled in Data Base (Oracle, SQL Server, Informix), ETL (Informatica, Sagent, Data Stage), UNIX

PROFESSIONAL PROFILE

Ten years experience in Data Warehouse (Analysis, Architect, and BI) and ETL Architect and Development using different tools.
• Architect and Build the Data Warehouse for start up companies and mid size companies
• Analyze the data and provide fixes or suggestions to improve the performance
• Installed and Admin Informatica. This include standards and create processes for daily tasks
• Lead the ETL development and reporting team
• Perform QA and Code reviews
• Design and Architect ETL jobs for the DW team
• Provide high level optimization ideas for the ETL team to improve there code performance. This include multi processing.


TECHNICAL SKILLS

Databases: ORACLE (8.i/9.i,10g), SQL Server 7.0/2000, INFORMIX 7.x, INFORMIX SE 4.x, Red Brick 6.x, INFORMIX HPL, MS-ACESS
ETL Tools: Informatica (8.x,7.x, 6.x) , Sagent (V4.5i), DataStage (4.x ,5.x) , C/ESQL Programming, light JAVA/JDBC Programming, Paragren-Siebel One By One Suite (Racer)
Languages: C, C/ESQL, C++, JAVA (JDK 1.1.6), Java scripting
Shells: UNIX Scripting (C, KORN, AWK, BOURNE)
Web Personalization: E.Piphany RightPoint 5.x, MS-IIS Server
First Logic: Name and Address Hygiene to standardize and correct addresses, Merge/Purge
Systems/OS: AIX 5L (Ver 5.2), Sun Solaris 2.6, WINDOWS 9x/NT/2000/XP, IRIX 6.x
Network Programming: TCP/IP, UDP, BSD Sockets
CASE Tools: Visual C++ 5.0 using MFC, Visual Basic 4.0
Platforms: AIX 5L (Ver 5.2), SUN workstation, SGI, PC's, IBM RISC/6000
Applications: MS-VISIO, MS-Office
Configuration Management Tool: UNIX RCS, MS-SourceSafe




PROFESSIONAL EXPERIENCE



24 Hour Fitness Carlsbad, California 5/2007-Present

Informatica Specialist

Responsibilities:
• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model
• Study the relation at the source systems
• Worked as part of the architect team to develop complete star schema (Snow Flake)for the Phase I of the Data Warehouse
• Supervise the installation of Informatica Software
• Set up the Informatica server, this include configuring Informatica for the best performance
• Create the naming standards for the DW team
• Create the Staging and Star physical model in Oracle data base
• Worked on developing all the mapping needed to load the staging area of the DW
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica
• Developed mappings/workflows to load both dimensions/facts and lookup tables for Microstategy
• Perform QA and Code review for my code and other developers code
• Support all Informatica daily admin tasks



LowerMyBills (LMB) Santa Monica, California 8/2006-5/2007
LowerMyBills.com is a simple and intuitive Web site to help every American household save money for the important things in life.
Senior Consultant

Responsibilities:
• Developed QA the mapping that will parse the weblog and load it in the staging area. Old process used to take 3 hours, new process 45 minutes
• Worked on the daily Data Quality issues
• Developed a long term solution for the cost issues. Dropped the number of issues from 30+ to 5
• Work on daily issue in the production environment
• Optimize the current system and load process, try to develop a better techniques
• Support DW team.
• Work closely with the users (Marketing analyst) to support there requirements and provide them with data analysis
• Provide support to analyze the data and define the issues when found
• Architect and Designed SuperDog and SuperDog Phase II Projects. provided support for the development team and monitored the development process
• Re-designed Search Engine process. This process caused a lot of issues for the company, so I provide the team with a better solutions to optimize this process to run faster
• Design all new processes to comply with the new DW generation (UNIX, Oracle, and Informatica)
• Work on new projects using Informatica













HELIO, California 3/2006-8/2006
Consultant (Sr. Data Warehouse Architect)
Joined HELIO DW Team March 2006 to architect and develop the DW for the company. In addition set up all the ETL and reporting servers. Lead the Development team.

Responsibilities:
• Architect the DW for HELIO from the beginning. Worked close with the DW manager to architect the DW.
• Analyze the Source systems and provide tips on building the Dimension and Fact Tables
• Install Informatica 8.0 on UNIX
• Upgrade from Informatica 8.0 to 8.1
• Administrate Informatica 8.x
• Install and Administrate Data Analyzer on UNIX
• Helped in the DW development, provided High level supervision for other team members
• Performed Code reviews and QA
• Helped in developing Informatica mappings, PL/SQL code to fix issues in production Database
• Developed processes to verify that the fix applied for the production DW is complete.
• Provided tips for the DW team to improve the performance of there ETL jobs.
• Provide Support for the Data Warehouse team.



HealthNet, California 5/2005-1/27/2006
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:
• Medicare Part D project, Architect, Design and Development
• Developed and QA Claims load from different vendors (Daily and Cycles)
• Supported the {pharmacy team in Data Warehouse Phase II project. This include develop new mappings and update existing mappings.
• Optimize current processes by applying Informatica techniques. Reduced the load time from eight hours to less than an hour.
• Helped in developing Informatica mappings, PL/SQL code to fix issues in production Database
• Developed processes to verify that the fix applied for the production DW is complete.
• Provided Date Warehouse Architect Tips for the Team in addition to the ETL Architect tips.
• Provided tips for the DW team to improve the performance of there ETL jobs.
• Provide Support for the Data Warehouse team.



LowerMyBills (LMB) Santa Monica, California 2003-5/2005
LowerMyBills.com is a simple and intuitive Web site to help every American household save money for the important things in life.
Senior ETL Engineer 4/2004 - Present
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:
• Currently, working 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 the Data Warehouse and ETL to store the Realty Data.
• Product Revenue: retrieve Home Loans Transactions data from Oracle to Data Warehouse using Informatica. Re-Design 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.
• Lead the effort to recover from the hardware failure. Re-loaded one month worth of data into Data Warehouse
• Work closely with the users (Marketing analyst) to support there requirements and provide them with data analysis
• Continue supporting the current system
• Perform high level optimization for daily processes
• Provide support to analyze the data and define the issues when found
• Design all new processes to comply with the new DW generation (UNIX, Oracle, and Informatica)
• Helping in Informatica installation under Unix Environment
• Re-design all the current processes to run on the new system. This include optimize them using the advanced features in Informatica
• Work on new projects using Informatica



ETL Engineer 3/2003 -- 3/2004
Implement High Level ETL processes for the LMB data warehouse using ETL Tools. The data warehouse is used to analyze revenue, costs and click-stream data. Data Warehouse is a SQL server that feed from different sources.
Responsibilities:
• Defined star schema and staging database enhancements
• Design and develop ETL processes to load data from multiple source system databases (Oracle, SQL Server, and flat files) into the DW (SQL Server)
• Developed high performance ETL plans to load large volumes of data (60-90+ million records).
• Designed, developed, and tested the DW to extract data from the Campaign Administration System. This new system builds to help LMB better design its market goals.
• Responsible for supporting and troubleshooting Data Quality and Enhancement Issues.
• Improved the performance of the nightly data load process:
o Optimized Impressions/Clicks load, From 4 + hours to 30 minutes
o Automated error checking mechanisms and reduced the night load fail by 30%.
• Designed and implemented ETL jobs to pull the home loan data from the Oracle system to the DW. This includes transforming the data to comply with the data architect in the DW.
• Update the Company Revenue calculation for home loans to comply with the new implementation on Oracle
• Designed and Implemented new system to calculate cost for the company depending on the number of the daily applications submitted by our customers.
• Lead the team to recover from the Data warehouse corruption. Put the schedule and developed the plan to recover in a short time
• Optimized existing processes, Customer load process used to take 2+ hours using 95% of the system memory, the new plan runs for 10 minutes with other processes
• Designed and developed process to load publisher Impressions and Clicks, also designed and helped in the development to load Publisher Applications into the DW
• Provided on-call support for the nightly load process that run from 12 AM to 9 AM.
• Helping in re-building the new Data Warehouse


Alliance Data Systems (ADS) Gahanna, Ohio 1998--2002
Alliance Data Systems provides private-label 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.
• Developed solutions to improve and enhance existing processes including change control requests and trouble tickets. Used C/ESQL, Unix Commands/Scripting, and DataStage.
• Designed, implemented and automated a model scoring process to help Victoria's Secret better score and identify their customers. This process replaced an existing complex SAS process and reduced the complexity of running the scoring and reduced the run time by more than 50%. Used DataStage 4.x, Unix scripting, and Informix Red Brick 6.x.
• Participated in designing and implementing the Victoria's Secret analysis file, consumer based aggregated file with more than 270 fields and 10 G.B in size, which enhanced the reporting and analysis run time by 80 %. Used C/ESQl, Unix scripting.
• Participated in designing the In-House Email Campaign Management System.
• Designed and implemented real time web campaigns. Developed web site for client demonstrations. Used E.Piphnay, MS-IIS, Java, Java Script.
• Integrated check transactions POS data into our production data warehouse. Used C/ESQL and Unix Scripting.
• Designed and implemented proprietary card splitting process for Lerner NY. This process improved the run time more than 65 % compared to other existing processes. Used C/ESQL and Unix Scripting.
• Assisted in designing and coding of Victoria's Secret Catalog MegaBrand (Phases I & II) project to load and update customers' information. Used C/ESQL and UNIX Scripting.
• Participated in improving the store of loyalty/division of loyalty process. Used C/ESQL and UNIX Scripting.
• Designed and implemented the DMA process to update the production database to preserve the consumer privacy. Used C/ESQL and UNIX Scripting.
Systems Support Analyst 1998 -- 2000
Administered segmentation, aggregation and campaign management tools. Designed and developed C/ESQL code to implement Ad-Hoc requests. Supported Campaign Management Analysis team.
• Provided end-to-end support and training to ADS campaign management and execution team for our direct mail campaign system.
• Administered and utilized Segmentation and Aggregation tool by SIEBEL One by One Administrator. This included building and updating measures and dimensions to cover business requirements and end user needs. My work included extracting data from the main data mart, aggregating and summarizing the information on consumer level, administrating and optimizing the segmentation database for faster query response times including table and indexes fragmentation, resource allocation and performance monitoring.
• Administered and utilized Campaign Management tool by Centrobe Query and Select 2.x and DSI TopDog.
• Coded and executed Ad-Hoc requests using complex SQL, C/ESQL, and Unix Commands/Scripting.
• Automated several production and Ad-hoc process. This improved the performance of the campaign management system and minimized the number of Ad-Hoc requests.
• POS data manipulation.

CENTRAL MICHIGAN UNIVERSITY, LIBRARY SYSTEMS, Mt. Pleasant, Michigan 1997 -1998
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.

CENTRAL MICHIGAN UNIVERSITY,
COMPUTER SCIENCE DEPARTMENT, Mt. Pleasant, Michigan 1997 - 1998
Teaching Assistant
• Taught CPS100 Classes and graded lab assignments and quizzes.


EDUCATION
Master of Science in Computer Science, 2002
Central Michigan University Mt. Pleasant, Michigan

Bachelor of Science in Computer Engineering, 1994
University Of Aleppo Aleppo, Syria


Trainings
Informatica (Power Center 7.x) Advanced Development 2005
Informatica (Power Center 7.x) Advanced Administrator 2005
Informatica (Power Center 7.1) 2004
Software Architect 2002
QA Techniques 2002
E.Piphany (Real Personalization) 2001
Software Engineer 2001
Visio 2000
Informix (Advanced SQL) 1999

Certifications
Informatica (Power Center 7.x) Advanced Development 2005
Informatica (Power Center 7.x) Advanced Administrator 2005
Informatica (Power Center 7.1) 2004
Software Architect 2002
QA Techniques 2002
E.Piphany (Real Personalization) 2001
Software Engineer 2001
Visio 2000
Informix (Advanced SQL) 1999


CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


View all resumes in US-CA-Los Angeles »
View all resumes in US-CA »

View other Consultant (Data Architect, ETL Desing and Lead) resumes, Programmer / Developer resumes