Sr Data Analyst

Johnathan J. Gilliard

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

Data Mechanic

Business Intelligence Tools Big Data Handling Web Analytics Data Ming & Report Development

Data Governance, Modeling & Architecture Project/Program Management Cross-Functional Team Leadership

Results-focused data strategist and technology consultant specializing in big data analytics solutions, statistical modeling, and business intelligence. Offering more than 13 years of demonstrated experience in delivering enterprise-wide analytics and reporting solutions across a broad range of both commercial and military environments by leveraging innovative data-driven design experiments, test hypothesis, statistical modeling, big data/BI solutions, and visualization.

Strengths include exceptional business and technical acumen coupled with a proven track record of developing research protocols, improving data governance systems, accelerating value realization, and spearheading design and delivery of strategic, cost-effective information solutions to achieve business objectives in alignment with organizational goals.

Adept at guiding highly skilled cross-functional teams of architects, engineers, and QA experts to deliver strong client satisfaction, reduced cycle times, added trustworthy insight from analytics, greater business agility, and leaner, faster, better operations. Interact effectively at all levels of the organization to build consensus for enterprise-wide goals.

Technical Summary:

Querying Languages: PostgreSQL, MySQL, T-SQL, PL-SQL, SAS-SQL, SOQL/SOSL

Business Intelligence (BI): SAS, SPSS, MS SSAS & SSRS, Business Objects, Pentaho RD, Tableau, BIRST, Qlikview

Database: PostgreSQL, MySQL, MS SQL Server, MS Access, Oracle, Force.com, AWS, JDBC, MongoDB

Extract Transform Load (ETL): Boomi, Pentaho DI, Informatica, MS SSIS, Visual Studio, APEX Data Loader

Spreadsheet & Statistical: Minitab, MATLAB, SPSS, Excel, R, Sumatra-Software

Programming/Scripting Languages: Perl, Java, Python, Bash, Ruby

Presentation & Mock-Ups: Keynote, PowerPoint, Prezi, Rational DOORS, Visio, iGrafx, Balsamiq, SnagIt, Skitch

Web Analytics: Google Analytics, Google AdWords

Operating Systems: Windows, MacOS, Linux

Customer Relationship Management (CRM): SalesForce, Financialforce, SharePoint

PROFESSIONAL EXPERIENCE

HEWLITT PACKARD ENTERPRISE/INSIGHT GLOBAL INC., Austin, TX 02/2016 Present

BI Developer / Data Scientist

•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

•Presents analyzed data to marketing and sales leadership; giving them actionable information to help make more informed business decisions

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

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

Database Administrator/Analyst

•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.

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

•Administered and fine-tuned databases for performance and stability; provide adjunct support as a backup developer on the testing of processes, architecture and IT systems that facilitate the running of business operations.

•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.

PROFESSIONAL EXPERIENCE (Continued…)

GENERAL ASSEMBLY, Austin, TX 08/2015 08/2

Part-Time Instructor

•Course is designed to teach students how to use large amounts of data to make critical business decisions

•Students are introduced to standard analytical theories and concepts then practice using Excel, PGAdmin and Tableau to extract, analyze, and illustrate real world data

•Students also create data visualizations and dashboards to present and communicate important findings; subsequently employ descriptive statistical analysis to make informed, effective decisions

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

•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.

•Optimized company’s database schemas, wrote stored procedures, and directed manipulation of database 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.

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 project whereby information is: 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.

PROFESSIONAL EXPERIENCE (Continued…)

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.

•Employed 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 dashboards.

• 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 Instillations 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.

•Verified and validated accuracy of multiple database systems, including MS Access and Oracle, to assist in updates of these systems; detected problems and potential inefficiencies then implemented processes to streamline data efforts.

EDUCATION

THE UNITED STATES AIR FORCE ACADEMY

Bachelor of Science in Operations Research;

Commandant’s List & Athletic Director’s List

THE UNITED STATES AIR FORCE ACADEMY PREP

Air Force Academy Appointment; Prep School Top Performer

SPECIALIZED & TECHNICAL TRAINING

•Apple Corporate Training=> SAP Business Objects Familiarization Course (Version 4.X)

•Booz Allen Hamilton=> Consultative Approach to Problem Solving / Project Financial Management

•Carnegie Mellon University=> Implementing Goal Driven Measurement

•Code School=> The Magical Marvels of MongoDB / Try SQL / Try Python /Try R

•Defense Acquisition University=> Six Sigma: Concepts & Processes / Lean Six Sigma: Concepts

•SAS Institute Inc.=> SAS Programming II / SQL Processing w/ SAS / SAS Report Writing / Optimizing SAS

•SPSS (an IBM Company)=> Introduction to PASW Statistics / Introduction to PASW Modeler and Data Mining

•uDemy=> R Basics / Python Programming / Scraping and Data Mining for Beginners and Pros / Google Analytics Training / Big Data and Hadoop Essentials / Basics of Bash Scripting / Data Visualization Essentials for Presentations / Ruby Programming / Master Data Management

•USAA Corporate Training=> Business Management Fundamentals / Agile Product Owner Training / SAP Business Objects Familiarization Course (Version 3.X & 4.X)

Contact this candidate