文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > 求职/职场 > 简历封面/模板 > DataWarehouse Engineering&BI Consultant数据仓库工程师BI顾问英文简历
侵权投诉

DataWarehouse Engineering&BI Consultant数据仓库工程师BI顾问英文简历

DataWarehouse Engineering&BI Consultant数据仓库工程师BI顾问英文简历,仅供大家参考!

RESUME OF

Donald McMunn

2589 Jack Teasley Rd

Pleasant View, TN 37146

(615)945-8666

dmcmunn NoS@M_Pls AT ipcdesigns dot com

Work History:

Proven Oracle, SQL Server, Teradata, UDB database, datamart and data warehouse “hands-on” technical team leader with business intelligence requirements gathering, business analysis, information delivery, data modeling, full life-cycle project management, executive presentation and end-user training skills.

Time Frame: February 2007 – Present

Location: Nashville, TN

Duties: Providing architectural consulting, business process documentation, design, development and

implementation of an ETL process to support the development of an actuarial science data mart for the insurance business group to support pricing and reserving for the Fortune 50 company. Source datasets were being produced via SAS scripts against flat files in the mainframe, existing mainframe DB2 operational data store, numerous Excel spreadsheets and MS-Access desktop databases. Destination datamart was delivered in Oracle on AIX servers with a SAN for storage. Tools and techniques employed: Cognos, SAS on MVS, perl, DataStage

6.x Server, custom data profiling queries, Excel, Microsoft Access, mainframe DB2, Oracle, Platinum ER/win on mainframe and desktop for data modeling and reverse engineering, JADD sessions, reverse engineering transformation rules from SAS scripts into DataStage ETL processing, secure ftp and MQ-Series for data movement.

Time Frame: May 2007 – June 2007

Location: Austin, TX

Duties: Review SQL Server 2000 cluster architecture, hardware (SAN, network, memory, backup disk) and OS configuration and make recommendations for performance and stability enhancement opportunities. Deployed automated database growth monitoring and OS monitoring and notification system to notify technicians of

capacity or performance related issues. Developed disk configuration, database physical restructuring and OS tuning recommendations and provided online, monitoring and remote support of production cluster on a nightly basis. Communicated progress and status to the infrastructure director on daily basis. Transitioned support of all artifacts to their new DBA at completion of project.

Time Frame: February 2006 – March 2007

Location: Nashville, TN

Duties: Providing business intelligence, data modeling and data warehouse requirements gathering, data

architecture, conceptual/dimensional/logical and physical database design, development and implementation for the data warehousing and business intelligence market. Using the entire Microsoft SQL Server 2005

development suite: SQL Server, Analysis Services, Integration Services and Reporting Services to deliver

business intelligence for an internet-based, industry leading, healthcare education and training provider. Worked with business experts to learn the business processes to better provide the data architecture for the reporting data warehouse. Designed, developed and implemented the Kimball-based conformed dimension data model through multiple business expert interviews for multiple fact tables with between 7 and 10 different dimensions. Designed, developed and implemented the ETL architecture to support both a bulk data migration facility and the ability to periodically, incrementally update the Kimball-architecture BI data warehouse in a near-real-time manner. This included loading data from over 50 sources in 8 different databases. The resulting reporting data warehouse was 500 GB in size.

第1页

你可能喜欢

  • BI解决方案
  • 命令大全
  • Linux系统命令使用详解
  • unix常用命令
  • 苏教版二年级语文上册教案
  • 项目经理简历模板
  • PE工程师

热门文档

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email