Data Analyst Business Intelligence

Johnathan J. Gilliard

Greater Austin Area, TX 512-***-**** *********.********@*****.*** LinkedIn: linkedin.com/in/johnathangilliard

“Data Mechanic”

Results-focused data strategist and technology consultant specializing in Big Data analytics, Business Intelligence solutions, Cloud Database interactions, Data Visualization creation, Key Performance Indicator Management and statistical modeling. Offering over 21 years of demonstrated experience in delivering enterprise-wide analytics and reporting solutions in industries such as: product supply chain, real estate, software, and various others.

EDUCATION

M.S. An., Business Analytics, April 2016 – June 2017

American University, The Kogod School of Business – Washington, DC

B.S., Operations Research – Mathematical Minor June 1998 – May 2002

The United States Air Force Academy – Colorado Springs, CO

Certificate of Completion & Appointment to the US Air Force Academy July 1997 – May 1998

The United States Air Force Academy Preparatory School – Colorado Springs, CO

TECHNICAL SUMMARY

●Structured Querying Languages (SQL): PostgreSQL, MySQL, T-SQL, PL-SQL, PROC SQL, Google BigQuery, NZSQL, HIVE, PIG

●Business Intelligence (BI): Business Objects, Looker, MicroStrategy, Power BI, Pentaho RD, SAS, SiSense, SPSS, Tableau, Qlikview

●Database: PostgreSQL, MySQL, MS SQL Server, MS Access, Oracle, Force.com,Netezza, Hadoop, MariaDB

●Extract Transform Load (ETL): Boomi, Pentaho DI, Informatica, MS SSIS, APEX Data Loader, SAS DM, Zaloni Bedrock

●Spreadsheet & Statistical: Minitab, MATLAB, SPSS, Excel (XML Miner & Analytic Solver), R, Sumatra-Software, LibreOffice

●Web Analytics: Google Analytics, Google AdWords, Omiture SiteCatalyst

●Web Databases: AWS(EMR, EC2, RDS, S3), Azure, GCP, PostGRE

PROFESSIONAL EXPERIENCE

SPACEIQ 09/2022-Present

Senior Data Analyst (Contractor)

●Performing data mining and visualization activities to identify insights used to drive key business decisions

●Providing trend analysis of Key Performance Indicators (KPIs) and generating in-depth root cause analysis when applicable

●Leveraging expert technical knowledge in database design to optimize reporting and analysis.

●Creating and maintaining product metric implementations and BI tool reporting; utilizing various tools such as: AWS, Azure, Atlassian, DataGrip, Docker, GitHub, JasperSoft Studio, Looker, PostGRE DB, Snowflake, Sublime, Okta

KELLER WILLIAMS REALTY, INC. 02/2020-09/2022

Data Analyst

●Cultivate, Identify, assist in building proactive data validation process and automation to ensure a high level of data integrity

●Investigate data related bugs and anomalies, identifying root causes, and working with the team resolve issues; Communicate and coordinate effectively across Engineering, Product and Business teams when resolving Issues

●Work closely with the Engineering and BI teams to create and maintain frameworks for business processes producing technical documentation as necessary; provide input into Data Management and Governance processes

●Perform data profiling and ad-hoc analysis to identify insights and patterns in Enterprise Data; utilizing various tools such as: AWS, DataGrip, GCP, Tableau, Looker, SiSense, SAP Cloud analytics, BiqQuery, Data Studio

SPECTRUM ENTERPRISE 04/2019-02/2020

Data Engineer (Contractor)

●Develop predictive data modeling from multiple sources based on historic and real time Service data; Optimize the schedule of network maintenance for the best use of resources

●Identify areas where data can be optimized to better facilitate forecasting such as lowest possible repeat downtime and repair schedule to minimize customer impact

●Create “real world” forecasts that are built on long term trends as well as unforeseen emergencies such as

●Served as SME for gathering and analyzing model variables, of utilizing data mining and segmentation techniques, expert problem-solving skills leveraging: AWS, R, Python, DataGrip, Tableau, MS Excel, Neo4j, SalesForce, SquirrelDB

DELL 05/2018-02/2019

Senior Business Intelligence Analyst

●Support reporting and analytics for the Dell University Relations organization; providing expert analyses to uncover hidden opportunities to improve talent acquisition results

●Translate stakeholders’ requirements into reporting deliverables, prepare ongoing standard reports and analysis is support of dynamic business needs

Utilize various software packages and tools for collecting, mining, interpreting and reporting data (MS SQL Server, MS Visual Studio, Excel, Tableau and relevant corporate ETL tools)

USAA / Peyton Resource Group (PRG) 09/2017-04/2018

Decision Science Analyst (Contractor)

●Leverages expert business/analytical knowledge to lead discussions with cross-functional teams to understand and collaborate on highly complex business objectives and influence solution strategies

●Identifies and gathers the relevant and quality data sources required to fully answer and address the problem for the recommended strategy through testing or exploratory data analysis. Integrates/transforms disparate data sources and determines the appropriate data hygiene techniques to apply

●Applies sound data analysis to arrive at conclusions, makes 'insight to action' recommendations and answer business objectives to drive the appropriate change; utilizing SAS, Aginity, Hadoop, R and SiteCatalyst software

CDS GLOBAL, INC. / DEAN & EDWARDS, Austin, TX 10/2016 07/2017

Big Data Developer (Contractor)

•Worked directly with the Big Data Architecture Team actively creating the foundation for the Enterprise Analytics initiative in a Hadoop-structured Data Lake using AWS in the cloud (e.i. – EMR, EC2, RDS, S3)

•Improved and optimized a new internal search system; deploying a hybrid solution which combines Hadoop & Elastic search

•Was responsible for full stack development, design and build systems to ingest and process large data sources using SQL, Hive, Javascript, NoSQL, Hadoop, and Elastic ecosystem tools

HEWLETT PACKARD ENTERPRISE/INSIGHT GLOBAL INC., Austin, TX 02/2016 09/2016

BI Developer / Data Scientist (Contractor)

•Provides expert data analysis on a regular and timely basis identifying "Top Customers" from an opportunity perspective

•Reporting Specialist assisting the marketing and sales groups within Hewlett-Packard (HP) Enterprise; pulls (and process when applicable) data from SAP, SalesForce.com and MS SQL Server instances

•Creates reports, dashboards and “White Space Analysis” of both current and perspective customers within QlikView, SalesForce.com and Tableau for a specific global market share; utilizing total area market (TAM) data

APOLLO ENDOSURGERY, Austin, TX 08/2015 12/2015

Database Administrator/Analyst

•Setup, monitored and maintained data integrations with international 3rd-parties for Enterprise Data Warehouse; setup, troubleshooting and monitoring for EDI systems with international partners

•Maintained all data connections, SFTP flow setup, ETL processes, structuring for reports and dash; facilitated business operations primary support for the Sales Reporting functions to ensure timely, accurate and consistent reports

•Developed new data gathering ideas and administered a broad array of corporate reporting systems Salesforce.com, Google Analytics, Google AdWords, SSRS, BIRST, Tableau to streamline dissemination of information

HOMEAWAY.COM / INTERSYS CONSULTING, Austin, TX 04/2015 08/2015

Data Analyst (Contractor)

•Assigned to complete a full audit of end-to-end data flow to understand what the business definitions are for elements, metrics and how the required information is captured within the E-commerce ecosystem

•Gathering information from stakeholders then documented “AS-IS” processes as well as captured overall data lifecycle; identified inefficiencies and formulated data backed recommendations for process improvement

•Navigated intricate database schemas that create complex web-based user interfaces; manipulated database contents from MS SQL Server, Tableau and Google Analytics, included streaming of data into database and extracting for use in reporting user interfaces

ACCEND / DRILLMAP, Austin, TX 12/2014 02/2015

Data Systems Engineer

•Optimized the company's database schemas, wrote stored procedures, and directed manipulation of databases to facilitate these functions. Created and modified unit tests for software applications that drove the company’s applications

•Designed database schemas that performed well in complex web-based user interfaces; manipulated database contents from Perl, Bash and Java code, including streaming of data into database and extracting for use in reporting user interfaces

•Designed, developed, and maintained data that fed software applications and drove company applications; which aggregates and visualizes energy data using an array of software, including Pentaho, MySQL, Perl, Ruby, and Bash

MOZIDO / INSIGHT GLOBAL INC., Austin, TX 05/2014 12/2014

Business Intelligence Developer (Contractor)

•Worked within SCRUM Team to create relevant reports and metrics that helped users understand impact that mobile application has on customer businesses, primarily using Pentaho (PostgreSQL and PL/SQL)

•Developed data warehousing and data mart components including ETL, XML, Meta Data, Facts and Dimensions employing Star and Snowflake Schemata as well as Logical Data Model, Product Data Management, Entity–Relationship Model

•Created relevant design documents to support clients understanding of reports and metrics; uses “soft” skills to influence and recommend how the relevant documents should be interpreted (including data dictionaries and mappings)

CATAPULT SYSTEMS, Austin, TX 02/2014 04/2014

Senior Consultant

•Led and developed data warehouse and business intelligence solutions, utilized Microsoft BI platform and product stack SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), PowerPivot, Power view

•Data mart/warehouse modeling based on business requirements and optimization of data models for business intelligence implementations; maintaining existing data warehouse and business intelligence implementations

•Monitored meetings in preparation of project planning directly with clients, business users and sponsors; including requirements, architecture review and project milestone sessions

UNITED ALLERGY SERVICES / ROBERT HALF TECHNOLOGY, San Antonio, TX 09/2013 12/2013

Data Management and Integrations Consultant (Contractor)

•Developed reporting processes via a simplistic database (MS Access) interface that allows for ease of production and real-time assessment of information subsets extracted from SalesForce.com (and FinancialForce)

•Work with Subject Matter Experts to design, develop, test and deploy database(s), extrapolating information from SalesForce.com (and FinancialForce.com)

•Created data flow for the project whereby information was: extracted from SalesForce.com transferred into Informatica, translated from Informatica into MS SQL Server and finally processed by MS SQL Server then imported by MS Access.

APPLE / APEX SYSTEMS INC., Austin, TX 01/2013 05/2013

Supply Chain (Business Intelligence) Analyst (Contractor)

•Employed dynamic hypothesizes and sound analytical methodologies to evaluate supply chain opportunities in terms of cost, lead-time and quality tradeoffs; resulting in recommendations to senior leadership

•Worked closely with Logistics, Finance and Process teams to identify supply chain cost challenges and opportunities by product, by route to market and distributor driving actions to realize Return on Investment (ROI) opportunities

•Implemented a broad range of software and business applications in order to gather, evaluate and present findings; plus recommendations to executive decision makers Business Objects, MySQL, SQuirreL SQL, Excel for Mac, Keynote

USAA / CLARITY SOLUTION GROUP, San Antonio, TX 05/2012 01/2013

Business Intelligence Advisor/Data Modeling Analyst (Contractor)

•Worked with Business, IT, and cross-functional project teams to drive technical and functional designs for BI solutions; derived/defined business requirements, developed data modeling concepts, and setup enterprise-wide data architectures

•Leveraged understanding of multiple data structures and sources within USAA data architecture (ie. SAS Server, SAP, etc.) to perform complex data manipulation employing data mining, analytical tools and mathematical techniques

•Used SAS Enterprise Guide and related statistical tools (i.e. SPSS, R,TOAD and other SQL software) to mine, analyze and model data; then deciphered and articulated the message in the complex data sets to USAA stakeholders

BOOZ ALLEN HAMILTON INC., San Antonio, TX 11/2011 05/2012

Lead Operations Research Analyst

• Served as team lead for Air Force Intelligence and Cyber market; led growing existing work, developed new clients, implemented tools to aid in decision analysis allowing output to be easily captured and reported using dashboard.

• Lead for Business Intelligence, oversaw implementation of Cross Industry Standard Process for Data Mining Methodology (CRISP-DM) upon existing processes to identify deficiencies and develop methods to improve productivity

• Assisted clients by ensuring decisions were quantitatively and qualitatively supported by rigorous statistical methods; presenting refined results from statistical software (SAS, SPSS, etc.) and streamlining business decisions

BOOZ ALLEN HAMILTON INC., DC Metro Area (DC, MD, VA) 03/2008 11/2011

Operations Research Analyst / Systems Engineer

• Provided Systems Engineering insight and expertise to support refinement of current and established engineering policies and procedure within NAVAIR exploiting statistical software such as MS Excel, Minitab, SPSS and SAS

• Led four person team providing analysis support for the Portfolio Management Decision Support System (PMDSS) delivered to Office of Chief Naval Operations Warfare Integration (OPNAV N8F) to aid in vital budget decisions

• Researched, derived, and analyzed factors and influences to Total Ownership Costs within Naval Aviation Enterprise (NAE) acquisition programs lowering acquisition costs; utilizing statistical software and math methodologies to aid in analysis.

UNITED STATES AIR FORCE/ Various Military Installations 05/2002 03/2008

Production, Operations Research, & Lead Operational Test Analyst; 2nd Lt (O-1), 1st Lt (O-2) & Capt (O-3)

•Executed test programs with a budget in excess of $10.3M; led 4-person team providing operational testing analysis for Cargo, Tanker, Utility, and Special Operations Aircraft; avionics and munitions.

•Created tracking matrix in MS Excel® to organize, analyze, and prioritize allocations of surveyed assets across Iraqi Theater; using MS PowerPoint® provided visual representation which improved decision making by leadership in theater

•Developed and implemented demographic analysis tools using MS Excel, MS Access, and Base SAS that monitored, evaluated, and proved feedback of production data for enlisted and officer personnel requirements Air Force wide

•Extracted, Transformed and Loaded (ETL) data used to perform market share analysis, “ad hoc” queries, and forecasted effects of end strength results in Base SAS, to support Air Force Recruiting Services’ mission decisions

Contact this candidate