Sample Resume: Data Warehouse Developer

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.

Technical Skills

ETL: SQL Server Integration Services, SQL Server DTS, DataStage
OS: Windows NT/2000/XP, HP-UX, Sun Solaris, UNIX/LINUX
Programming: VB.Net, BVScript, ASP, JavaScript, C, C++, C#, HTML/XML
OLAP/Reporting: Business Objects 6.x, SQL Server Analysis Services, SQL Server Reporting Services
Tools: TOAD, Visual Studio.NET, Informatica, SQL*Loader, Microstrategy, Queryman, FILE AID. QMF
Hardware: NCR 3550/4800/5100/5200/5350, TCAD V2R5 SUN SPARK 3000, IBM 3090, ES-9000, IBM PCs, SunOS 5, IBM AIX 4.3
Software: JBuilder, Microsoft Office Suite, Rational Rose, Trillium
Databases/RDBMS: MySQL, MS SQL Server 2005/2000, Oracle 10g/9i, DB2

Professional Experience

ABC Technology, New York, NY
2004-Present
Lead Developer
  • 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.
DEF Corporation, New York, NY
2003-2004 
Data Warehouse Consultant
  • 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.
GHIJ Inc., Chicago, IL
2001-2003 
Data Warehouse Consultant
  • 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

Master of Science in Computer Engineering
New York University, New York, NYBachelor of Science in Management of Information Systems
University of Pennsylvania, Philadelphia, PA

Post a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>