数据库软件工程师英文简历.doc

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:  Summary 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. Business: Caterpillar, Inc. Financial Products - Insurance 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. Business: Education Finance Partners, Inc. 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 d