Gary Lock Email & Phone Number

Phoenix, Az, Us

• Independent Data and Analytics Consultant• Extensive work with the Microsoft Power Platform, Microsoft Fabric, and Azure• Integrated and developed Power BI reporting for many software systems such as Microsoft Dynamics 365, NetSuite, SAP, QuickBooks, Planview and ProjectPlace• Applied extensive technology and business experience working with companies in manufacturing, powersports, aerospace/defense, importing/distribution, and retail

• Architect and Lead Developer on Power BI Report Server deployment for a publicly traded bank. Tabular cube and report development focused on lending, credit and branch analytics.• Power BI and Enterprise Data Warehouse Developer for an international CPG company specializing in decorative and functional hardware. Development included large multidimensional cube, Power BI reports, SSRS reports and ETL routines using SSIS.• Lead Business Intelligence Architect and Developer on Power BI Adoption engagement with international agricultural cooperative.• Delivered training and workshops focusing on Power BI training and adoption.

Cincinnati, Oh, Us

• Architect and Lead Developer on business intelligence project with nuclear/electric utility. Incorporated ABB Ventyx Asset Suite data into new data warehouse including daily snapshots. Dimensional modeling and development of large multidimensional cube. Dashboard and report development using Microsoft Power BI and SSRS 2016.• Performed pre-sales activities focusing on full Microsoft BI stack including SQL Server 2016, Azure SQL, Power BI and Advanced Analytics.• Delivered training to clients covering topics such as Power BI Embedded, Data Governance and Power BI Dashboard in A Day• Team Lead and Mentor

Austin, Texas, Us

• Full stack MSBI development including SSIS, SSAS / Tabular and SSRS• Integrated Zuora subscription billing platform with internal systems: Salesforce, Microsoft Dynamics GP and custom e-commerce platform (Zuora SOAP, REST and AQuA REST APIs)• Developed customized (REST) Web API to serve as a centralized interface between product platform, CRM and ERP systems• Salesforce Developer (Apex Classes, Apex Triggers and Visualforce Pages)• Hyperion Administrator for HFM and Planning applications

Cincinnati, Oh, Us

• Employed Microsoft BI stack (SQL 2012) to design, develop and implement a Customer Data Mart at a national window manufacturer. Consolidated and aggregated data using SSIS from nearly 80 affiliate locations into a single data warehouse / mart. Used Analysis Services to develop multidimensional cubes containing business critical metrics and KPIs. Developed dashboards and reports using SQL Reporting Services. Project was on time and within budget.• Principal Consultant and member of development team on project with international clothing company. Developed data warehouse to consolidate operational and financial data from Dynamics AX and TradeStone Software systems. Successful solution included full stack MSBI development, extensive database development and tuning, custom C# MS Office ribbon.• Performed pre-sales activities focusing on Microsoft BI stack including SQL 2012 and 2014, PowerPivot, Power BI and SharePoint 2013

York, Pennsylvania, Us

• Worked with clients as well as project implementation team to identify requirements of Business Intelligence environments• Implemented base Dynamics AX cubes (2009 and 2012) along with customized cubes based on client needs• Developed ETL packages using SSIS and setup clients with complete BI solution using SSAS• Developed dashboards and reports using TARGIT Decision Suite, SQL Server Reporting Services and MS Excel / Power Pivot• Provided technical support and training to clients remotely as well as on-site

Scottsdale, Az, Us

• Developed data warehouse and executive dashboard using SSAS, SSIS and SSRS. Data sourced from multiple systems including NetSuite OpenAir SRP system, Microsoft Dynamics SL and Microsoft Dynamics GP. Reports include AR Aging, Employee Utilization / Realization and Project / Task summaries• Served as primary developer on acquisition integration team. Activities included ETL, business process improvement, and development of Windows service interface console using C#• Hyperion implementation team member. Developed integrations between accounting systems (Dynamics SL & GP) and Hyperion. Successfully implemented Hyperion Planning, Workforce Planning and Financial Management. Automated data loads and backups using SSIS and MaxL scripts• IT administrator for multiple systems including Microsoft Dynamics SL, Microsoft Dynamics GP, Hyperion Planning and Hyperion HFM.• Developed custom C# / ASP.NET applications including Collection Notes tracker, Invoice interface using OpenAir API and Hyperion automation management console.

• Developed and managed complex SQL scripts used for consolidated invoicing and carrier reconciliations• Created custom coding for real-time reporting of employee benefits, payroll deductions and employee invoicing• Developed reports using Crystal Reports 2008

Milwaukee, Wisconsin, Us

• Microsoft Dynamics NAV 2009 implementation Information Systems Lead. Integrated several third party software solutions with NAV, migrated system critical reporting tools from Dynamics SL to Dynamics NAV including Crystal Reports, SQL Server 2000 to SQL Server 2008 and numerous MS Excel macros / VBA packages. Implementation on-time and within budget.• Managed environment of 40+ users as Microsoft Dynamics SL 6.0 ERP Administrator. Administered role-based security model, developed front-end customizations using VBA and provided expertise in Financial, Inventory and Work Order modules in a lean manufacturing environment.• Administered SQL Server 2000 & 2008 including over 50 databases and 150 GB of data; Developed and managed views, stored procedures, SSIS, and SQL Agent jobs necessary for timely business information. Setup replication of live environment for reporting and analysis. Developed business critical BI cubes using SSAS.• Project Manager / Lead for HighJump Direct Store Delivery Route Accounting software implementation. Gathered requirements, developed specifications, created integration mapping between ERP and DSD solution, performed system testing and integration testing. Implementation on-time and within budget.• Maintained SharePoint / BrightWork project management portal including updates to web parts and modifying of xml reports.

Us

St. Petersburg, Florida, Us

Bachelor Of Science, Business Administration; Finance; Accounting

Master Of Business Administration, Mis, Advanced Mis And Management