Greg Vaughan Email & Phone Number

Honolulu, Hi

Client engagements:Concurrent Technologies Company- Data Warehouse Lead (7/13 – present)• Refactor and migrate an existing SQL Server 2008R2 Kimball Data Warehouse to a SQL Server 2014 platform (SSAS/SSRS/SSIS). Work includes SQL performance evaluation/optimization and development of prototype PowerBI/PowerView/ Analysis Services BI Semantic Layer (BISM) reporting solutions.• Developed and deployed Microstrategies 10.x semantic layer project and reports/dashboards for evaluation against existing and future state Microsoft Sharepoint BI reporting portal capabilities. Presented recommendations and alternatives to project sponsors for approval.• Lead a team of 5 developers to architect, design, develop and integrate new data sources and requirements into clients existing Kimball data warehouse. CXT Solutions – DBA Consultation (2/17 – present)• Performed diagnostics and analyzed operations to resolve SQL Server 2012 performance issues for commercial shipping application customers. Auditing and evaluation included use of SQL Server Dynamic Management Objects and system performance and resource monitoring tools for baselining key hardware, cpu, and memory metrics. Database design and server configurations were also evaluated.• Presented summarized findings, recommendations and a prioritized action plan for devops and engineering team performance remediation. MediaSense Consultants, LLC – Systems analysis/consultation (8/15 – 11/15)• Evaluate and advise existing consultant staff in development of a cloud based SQL server reporting solution to meet Community Health Center regulatory reporting requirements. Present solutions proposal to client sponsors.

Honolulu, Hawaii

• Transformed data management landscape by pioneering first enterprise Business Intelligence department for Hawaiian Airlines: Responsible for all decisions concerning purchasing, staffing, organizational structure, contract management, technical direction and departmental budget for a team of 25+ on-site/offshore dba and development resources.• Established credibility with key stakeholders and executives by streamlining communication strategies, increasing transparency, and driving operational, tactical and strategic roadmaps.• Spearheaded efforts to transform corporate culture concerning the consumption and management of data through educational presentations and corporate training sessions on data management principles and methodologies.• Fostered a dynamic and collaborative team culture by encouraging open communications, actively mentoring and coaching staff, and celebrating success.• Implemented Agile/RUP project management methodologies, software and processes to increase development efficiencies and speed up ‘time to value’ for business partners.• Created future-state vision and drove triage efforts to migrate existing legacy and business data assets to new ‘best practices’ enterprise Business Intelligence architectures. This vision included master data management, data governance, and data quality/stewardship programs as well as the creation of architectural standards and the technology centers of excellence.

Honolulu

• Architected, designed, and drove development of an enterprise data warehouse consisting of military injury, casualty, mishap, deployment, patient movement, and military civilian workforce claim data marts (DSES). Responsible for all phases of development including source analysis, ETL scripting and package development, data modeling (Toad Data Modeler), report creation, documentation and training. The solution utilized the SQL Server 2008 R2 Microsoft Business Intelligence stack including SQL Server Database Services, Integration Services, Analysis Services, and SQL Server Reporting Services integrated with Microsoft SharePoint Services 2010. • Developed advanced reports and SSRS report models for scheduled and on-demand report consumption from the DSES SharePoint Portal. Reports and models developed utilized Microsoft Report Builder 3.0, Excel Services and Performance Point Services (Dashboard Designer) and were based on relational and OLAP data sources. • Architected, developed and documented a SSIS data processing model for monthly loading of staging and data warehouse database structures. This included the development of a standard SSIS ETL framework utilizing error/execution logging, record outlying, and standard configurations to maximize efficiency and reusability.• Established programming standards, workflow processes, and naming conventions for SQL development for all work pertaining to Camber DSES data warehouse development. This included establishing database server standards and configurations as well as managing permissions and monitoring server usage and performance.• Led quarterly technical review presentations to analysts, program management, and program sponsors at the Office of the Secretary of Defense demonstrating developed technical solutions and summarizing project progress.• Developed and assisted in maintenance of legacy DSES system SQL stored procedures in support of DSES program initiatives.

Senior Business Intelligence Database developer and manager of a team of junior developers responsible for all Claims Department Business Intelligence and reporting.

• Architected and implemented a global CRM SAP BW 3.5 system: As lead for a team of 7 developers (on-shore/off-shore) I was involved in all aspects of development/design including data sourcing (R/3 and non-SAP sources), loading (process chains and infoPackages), modeling (infoObject development), and reporting. • Debugged, designed, extended and built SAP CRM 4.0 Business Content and custom extractors for full and delta extraction to SAP BW: Worked with our team to deliver a set of interim R/3ABAP reports prior to BW system implementation.• Built ABAP routines for transfer/update rules for ODS/ Infocube loading. • Created Process Chains with selective deletion routines for full cube regional full cube loading for SAP BW worldwide instance.• Created BEx Web reports with complex calculations and variable selection screens.• Designed, developed and implemented secure data OLAP Warranty Reporting solution using Microsoft SQL Server/Analysis Services 2000, Oracle 9i and Office XP/2003 Web technologies. Created, reviewed, and supported Informatica Powercenter 6/7 mappings/ maplets and SQL Server DTS Packages/Jobs for daily, weekly and monthly system loads. Graphical User Interface utilized DHTML and Jscript developed in Visual Studio delivered over secure sockets in corporate portal. • Developed and implemented a reporting solution using Informatica 6.2 mappings and a Business Objects 6.0 universe on an Oracle 8.0 and SQL Server 7.0 database. Involved with every aspect of development from requirements analysis and data migration to data universe/report design and end-user training.• Developed dynamic and static PL/SQL packages and procedures for extraction, transformation and loading of Oracle 8.0 database.• Assisted in development of Active Server Pages utilized to access database information via the web.

Master Of Business Administration (Mba), Mis

Bachelor Of Science (Bs), Environmental Engineering Technology/Environmental Technology