Data warehouse specialist Resume

This is a free Data Warehouse Specialist Resume that covers objectives and tips to gets you the best Data Warehouse Specialist Jobs. The professional resume help and actions words will help you to write winning resumes. This curriculum vitae guide teach you how to write Data Warehouse Specialist Resume.

Usage: This Sample Data Warehouse Specialist Resume helps you to understand Data Warehouse Specialist Job Description, Duties Of A Data Warehouse Specialist for free.

Contact Information:


Career Objective:

An experienced and trained Data warehouse specialist seeking for a suitable position in the said field

Experience:

Data Warehouse Specialist, Gamma Tech., TX, USA, Feb-2005 to Present

  • Reviewing and assessing existing data processing methods and techniques
  • Working with the development teams, system analysts to ensure optimal data warehouse environment
  • Define the sources to target data mappings based on KLC finance business rule
  • Develop ETL processes based on star-schema
  • Developing and maintaining the Metadata repository
  • Setting up user roles and security access to reports
  • Maintaining the data dictionary
  • Create ad-hoc and pre-formatted report
  • Ensuring the recoverability of the database warehouse structures
  • Provide test plans, test conditions, and test data
  • Provide progress reports and project status to the Project Manager
  • Mentor/Training KLC employees to use Discoverer ad-hoc reporting tool

Platform:

  • UNIX, Windows XP
  • Databases/Tools: Oracle Database 10g, Oracle Warehouse Builder, Oracle Discoverer, Oracle Reports, Oracle Portal, Oracle
  • Application Server, Brio, Hyper ion, Informix, SQL-server
  • Architecture: Client-Server System
  • Software Design Tools: Erwin 3.5, MS PowerPoint, Excel
  • Programming Languages: SQL, PL/SQL, Java, JSP, JavaScript, HTML, Unix

Shell Script

DBA/Data Warehouse Specialist, Zenith Media, New York, NY November-2000-Jan-2005

  • Reviewing and assessing existing data processing methods and techniques
  • Revising existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage
  • Working with the development teams, system analysts to ensure optimal normalization and maintain and change the logical database structures
  • Refine the source to target data mappings and academic transformation rules
  • Develop ETL mappings
  • Developing and maintaining the Metadata repository
  • Creating and managing primary objects such as tables, views/materialized views, dimensions and indexes
  • Setting up user classes and authorities
  • Setting up table-, database-, system-, folder-, and report-level security
  • Maintaining the data dictionary
  • Ensuring the recoverability of the database warehouse structures
  • Provide test plans, test conditions, and test data
  • Provide progress reports and project status to the Project Manager
  • Mentor University’s employees during the development process

Platform:

  • UNIX (AIX 4.3/5), Windows NT
  • Databases/Tools: Oracle Database 8/9i, Brio, SAS, Oracle
  • Warehouse Builder, Oracle discoverer, Oracle Designer. Oracle
  • Enterprise Manager, Oracle Application Server
  • Architecture: Client-Server System
  • Software Design Tools: Erwin 3.5, MS PowerPoint, Excel
  • Programming Languages: SQL, PL/SQL, Java, JSP, JavaScript, HTML

Education:

  • Masters of Science Degree in Computer Science (May, 2000) (Specialty: Data Warehouse), University at Buffalo, State University of New, York, Buffalo, New York
  • Bachelor of Science Degree in Computer Science (May, 1997)

Related Resume Adverstiments