David Reyes 222 Dice  |  Drive New York, NY 10001  |  000-000-000  |  dreyes@dice.com

Dedicated IT professional with exceptional data warehouse, database, and business intelligence experience

Summary of Qualifications

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Team player with excellent communication and problem solving skills.

Professional Experience

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Conduct code walkthroughs and review peer code and documentation.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Created system for capturing, reporting, and correcting error data.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues.
• Gather requirements and design of data warehouse and data mart entities.

• Conducted cost benefit analysis of various ETL tools and technologies.
• Created UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Played role in design of scalable, reusable, and low maintenance ETL templates.

• Wrote ActiveX scripts to create custom DTS transformations, in addition to using built-in DTS transformations.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Trained end users in using full client BO for analysis and reporting.
• Created classes and dimension and measure objects according to business requirements.
• Generated effective reports using formulae, sections, breaks, alerters, and filters.

Education and Training