Gary Hannon Email & Phone Number

Glen Burnie, Maryland, United States

Columbia, Maryland

Responsible for design, development, and implementation of a process to create dynamic data-driven SSAS partitions for multiple SSAS cubes. The process optimized both cube processing and query performance by building and sizing partitions rather than using the default single partition for cubes. This was achieved by using XMLA queries to analyze key data so that small subsets of data commonly queried result in dramatically improved performance. The system utilized metadata designed to generate the XMLA scripts and DDL commands. The system was developed in SQL Server 2014/2017 using SSAS, XMLA, SSIS, SSMS and Visual Studio 2017/2013. Assisted in the installation of an SSAS 2017 server on AWS. Created the SQL Server instance to house SSAS and performed and the SSAS installation. Restored data from the legacy SSAS 2014 server and successfully processed all dimensions and cubes. QA and parallel testing verified the installation and the server is production ready.Numerous projects to maintain and improve business intelligence applications including: addition of indexes to strategic tables to improve performance; dimension tuning to reduce overnight cube processing times; modified SSRS reports to ready drilldown processing for SSRS 2017; creation of SSIS packages to import data from external pharmacy sources to make available for applications, developers, and data scientists.

Columbia, Md

Responsible for design, development, and implementation of a Medical Research Cube system used by medical researchers to determine patterns of both prescription drug abuse. Responsibilities included database modeling and design, cube design/implementation, ETL with SSIS, QA and overseeing user acceptance testing. Used SDLC for all phases of project life cycle. For data warehouse, identified sources from disparate systems, established relationships among tables with PKs and FKs. BI front-ends available for users included MS PowerPivot, MS Excel, and a variety of third-party BI tools. Cube was additionally made available to SSRS developers. The system was developed in SQL Server 2012/2008 using Visual Studio 2012, SSAS, SSIS, SSRS, and SSMS.Participated in the design, development, and implementation of a financial analysis cube used by C-level executives, finance management, revenue cycle operations personnel, and selected department heads. In addition to modeling, responsibilities included cube design/implementation, ETL with SSIS, quality assurance testing, and managing UAT. SDLC used for all phases of project. Data sources within the data warehouse were identified for inclusion in the cube, and data relationships were established. BI front-ends available for users included MS PowerPivot, MS Excel, and a variety of third-party BI tools. Cube was additionally made available to SSRS developers. The system was developed in SQL Server 2012/2008 using SSAS, SSIS, SSRS, SSMS and Visual Studio 2010/2012.Responsible for the design and implementation of an enterprise data warehouse. By creating numerous SSIS packages and stored procedures, data is culled and aggregated from laboratory and billing applications, external sources, and loaded into the enterprise data repository. Processes feed multiple SQL Server applications, several SSAS cubes, and provide a consistent, common set of trusted data across the organization.

Rockville, Md / Atlanta, Ga

Serving as a hands-on programming consultant and in an advisory DBA capacity, developed applications and reports for SQL Server and legacy databases. Participated in various SQL development projects, fine-tuning database performance, enhancing existing ETL processes, and created/modified SSRS reports and SSAS BI cubes. Using SQL Server Integration Services, enhanced existing DTS processes to produce a more intelligent, robust, and reliable ETL structure and reduced load times from legacy databases by 30%. Created and modified existing SQL Server database indexes for new and existing tables resulting in a four-fold improvement in processing time for selected .Net programs and SSRS reports.Designed, programmed, and enhanced various SQL Server / Visual Studio.NET programs to improve functionality required by new business requirements. Developed functional and design specifications to support these requirements.Created numerous reports using SQL Server Reporting Services to push information quickly to company executives to respond to customer needs and accommodate changing business regulations. Created additional and modified existing SQL Server SSAS cubes to make provision for new product offerings.

Mt Laurel, Nj

$1.2B national direct marketer and distributor of maintenance, repair and operations products.- Implemented various software development efforts on disparate platforms to drive business and reduce operational costs.- Used SQL Server 2008 R2 with SQL Server Reporting Services to design and program various inventory management reports for end users.- Implemented feasibility study to use SQL Server Reporting Services as a platform to replace legacy report development environment.- Developed functional specifications for strategic projects. - Designed systems and created technical specifications for projects to foster organic growth and integrate recent acquisitions.- Involved with all phases of SDLC and managed several cost-saving projects to completion.

College Park, Md

$50M NATIONAL PIANO AND DIGITAL KEYBOARD RETAIL CHAIN AND LARGEST RESELLER OF 4 MAJOR PIANO BRANDS.; Direct software development, hardware and telecommunications infrastructure and guide Strategic Technology Planning IT Department supporting 16 retail locations on the eastern seaboard and the Midwest. Supervise group of 6 staff-members and 1 to 3 consulting staff-members. Report directly to President and CEO. Jordan Kitt's IT generally regarded as the most sophisticated and effective of all U.S. piano dealers.Championed technology projects to drive sales. In conjuction with marketing and sales, designed and implemented e-marketing and targeted mailing systems which measureably contributed to boosting sales revenue by $14M over a three-year period.Implemented an inventory strategy optimization model which resulted in reducing inventory levels by 51% and increasing turns from 1.1 to 1.6 over a two-year period, despite sluggish sales.Led an overhead reduction effort resulting in savings of $1.2M per year.Successfully deployed and maintained mixed Blackberry, Android, and iPhone environment for 50 users using Blackberry Enterprise Server and Exchange Active Sync. Developed metrics to measure corporate and department performance with push reporting to senior executives.For a new acquisition:Revamped outdated IT infrastructure to one based on cloud computing using Google Apps Premier.At multiple sites implemented Fonality cloud based off-premises VOIP phone system using Polycom SIP handsets.Leveraged existing Data Warehouse investments by implementing Business Intelligence and Analytics tools allowing senior executives to identify patterns and trends for marketing and back-end operations using dashboards and scorecards. Systems were developed using SQL Server Analysis Services, SiSense Prism and MS Excel.Spearheaded major rewrite of accounting reporting systems and implemented enterprise data-warehousing, and strategic reporting solutions.

$2M INTERNATIONAL PROVIDER OF PARTS, ACCOUNTING, SERVICE MERCHANDISING AND SALES KIOSK SOFTWARE FOR AUTOMOBILE DEALERS.; Co-founded software development company designing, programming and implementing fully integrated parts, service, accounting software and graphical touch-screen kiosk systems for car dealers. Headed/formed development teams and technical support groups. Directed sales, technical and administrative staff, trained customers/staff and delivered product/sales presentations. Built customer relations and performed business management, budgeting and financial planning. Led design and implementation teams for 5 software products and managed sales, technical and support staff. Supervised 12 staff-members.Co-founded/directed company that was profitable for 18 years, formulating business plan and securing financing.Successfully packaged/marketed 900+ programs and installed/supported programs at 100+ new car dealerships nationwide.Oversaw Pick to Windows platform conversion.Coordinated presentations at 9 annual NADA trade shows.

Promoted consistently from programmer/analyst to direct sales, programming, design and consultant groups for this 250-member firm. Provided expertise on business development, managed projects and recruited personnel for them. Hired/fired personnel, determined employee salary and conducted performance reviews. Prepared/presented applicants to clients and negotiated/maintained customer/employee relations. Provided technical sales support and managed technical staff. Reported directly to the president and supervised 30 staff members.Performed high-level feasibility studies, cost/benefit analysis and wrote numerous functional specifications.Staffed/managed over 200 projects, performing technical interviews on 5000+ candidates over seven-year period.Gained additional and extensive hands-on

Mba, Business Administration And Management, General

Ba