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.
热门文档