SUMMARY
Innovative Business/Technology Leader
I possess a rare combination of sound business acumen, entrepreneurial experience, and coding skills. My greatest asset is my keen ability to learn highly complex subjects at a rapid pace. My inquisitive and adaptive nature keep me on the absolute cutting edge of relevant technologies and management concepts.
My entrepreneurial spirit and vision drive me to succeed and overcome any obstacles with determination and perseverance. I have excellent team building skills founded by employee empowerment and “lead by example” work ethic.
Recent projects and the power of data-driven insights have ignited a new passion for Business Intelligence and Data Science. I have a skill for creating attractive and unique data visualizations, transforming the data into a compelling story, and the intuitive foresight to ask the right questions.
EXPERIENCE
Lake Companies, Inc.
Senior Developer
April 2019 – Present
Fact-Trak Business Intelligence Product
Demonstrated new Business Intelligence Methods to team including Tabular Modeling
Created Multi-Dimensional Reports with Power BI
Created Sales Prototype
Created Bookings Prototype
Created Operations Prototype
Trained team on Kimball DW techniques
Worked on team evaluating migration from Multi-Dimensional to Tabular Data Models
Created end to end Business Intelligence Prototypes including:
oDesign of Tabular Data Models
oCleaning and Formatting of Data
oPower BI Visualizations demonstrating all features
Methods Machine
Software Systems Development & Support
January 2019 – April 2019
CSI Administrative duties and Financial Report Creation.
Financial Report creating included extracting, formatting, creating data models for the Finance Department with internal and customer data.
Infor
Senior Software Engineer, CSI
January 2018 – November 2018
Helped Integrate Process Manufacturing Product bought from EVS in Core CSI ERP System.
EVS, LLC
Software Developer
May 2017 – January 2018
CSI Process Manufacturing
Fixed pressing issues that prevented PMF software from being usable which mostly revolved around the Mongoose Event System and other bugs.
Took ownership of the monthly build process.
Focused on understanding and documenting current software state at a deep level to have a foundation for the product roadmap and software future state rather than focusing on pushing out monthly builds.
Organized current and historical issues to understand real underlying problems in the software.
Evaluated build process changes to match new Infor CSI folder/asset requirements
Worked with resellers Solutions X and Decision Resources to understand customer issues, fix pressing problems and help setup sales demo workflows.
Experimented with new collaboration methods to help colleagues better understand CSI Process Manufacturing Software.
Rewrote SQL logic to replace some antiquated CSI stored procedures that create a performance bottleneck.
Migrated Sales Demo setup from version 9 to 9.0, including syncing forms with Form Sync utility.
Optiva Integration Project
Wrote SQL Integration between Infor Optiva Process Mfg. System and EVS Process Mfg. System.
Includes SL Item Creation, PMF Item Extensions, PMF Formula automation, and PMF Mfg. Spec automation.
Integration also includes automation of SL Jobs and SL BOMs to accommodate the flow between Optiva and PMF.
Used the Integration project to test numerous scenarios of multi-layered Formula/Items through the PMF flow.
Documented and outlined potential improvements and tighter integration with standard Syteline while working with clients BPFI, General Plastics, and reseller Solutions X.
Business Intelligence Projects
Demonstrated and explained Microsoft BI stack to partners. Including Power BI, SASS, and Azure PAAS offerings. Explained and demonstrated using data models for true Business Intelligence. Demonstrated at a high-level BI infrastructure design. Created sales demonstrations for multiple clients.
DSW BI Sales Demo – Sales demo that included real data from company’s POS, turned into a data model with product hierarchy.
Lodge Warehouse Metrics Demo – BI demonstration using JSON data feeds from EVS MOBE3 WMS system.
Support Lodge Analysts/BI Contractor in accessing MOBE3 data – help BI Consulting firm handle and understand incoming JSON data feeds from EVS MOBE3 WMS system.
Canyon Bakehouse Sales Demo – created business intelligence demo using real customer ERP data, and custom hierarchies/features developed from studying customers website and source data.
Setup Canyon Bakehouse Power BI Gateway – setup initial data gateway allowing the customer to have access to their ERP data from external Power BI tool.
RealD BAI Automation Design
Designed banking automation based upon the BAI specification from client banks into ERP cash management system using Python Pandas and Regex expressions.
New Data Discoveries
Business Intelligence Consultant Jr. Data Scientist
March 2016 – May 2017
Microsoft Certifications
MCSE: Data Management and Analytics — Certified 2017
MCSA: SQL 2016 Business Intelligence Development - Certified 2017
Helping companies to solve problems with Data
Current Project
Creating Power BI Dashboards for Marketing Funnel and Financial Accounting
Integrating data from legacy systems for use in dashboards
Creating automated data enrichment & lead nurturing automation to clients CRM system using 3rd party data APIs
Designing and creating holistic BI infrastructure for multiple manufacturing dashboards.
Business Intelligence
Setup & install Office 365 Enterprise with Azure AD & Salesforce connection
Setup SQL Server 2016, and Data Warehouse on Azure.
Preformed cloud integration of data sources
Train client on using Microsoft BI including Excel, Power BI, and SSAS
Implementing an e-commerce suite for a non-profit company.
The implementation includes content management system, website, email marketing and web analytics.
Data Science
Competing in Kaggle Data Science Competition, Group Bimbo Inventory Demand.
Currently ranked in the top 50%, Kaggle Inventory Demand Prediction as a solo competitor.
Competed in Microsoft Azure ML Data Science competition, “Decoding Brain Signals”, finished 91 out of 688 participants.
Creating NFL prediction engine and visual dashboard for Fantasy Football
Acquired Skills: Python (libraries: core, numpy, pandas, stats, matplot, bokeh, seaborn, sqlachemy, opencv, azure, pymssql), Advanced Statistics, Data Mining, Azure ML, Azure Cloud.
ILC Dover
Associate Programmer
June 2013 – March 2016
About ILC Dover
ILC Dover is known to produce space suits for NASA; we leverage our vast materials, engineering, process, and design experience to create high-performance systems for a wide range of industries.
Integrated Financial Data from a subsidiary into ERP System using new Data Science skills and BI techniques.
Used BI technology to automate the financial close process
Modeled income statement, balance sheet, and cash flow and cross-validated data sources to ensure data accuracy
Integrated and validated general ledger data into new Syteline ERP System
Explored and presented Salesforce data model to Senior Executives including the CEO
Assisted in training of Sr. Developers in Agile Methodologies
Used Business Intelligence (hierarchies) and Data Science techniques (feature engineering & classification) to bring more meaning to current data
Demonstrated Business Intelligence and ETL by hand-coding complex multi-layered SQL queries and views
Acquired Skills: Advanced SQL, Feature Engineering, Absorption Accounting, Financial Accounting, Enterprise Agile, Salesforce data model
Initiated Action to help our company move to data-driven.
Designed Business Intelligence (“BI”) architecture
Researched BI platforms and presented options and opinions on best implementation choice
Presented Big Data, Business Intelligence & Analytics to Accounting, Program Management, and IT
Showcased conformed dimensions and time series forecasting by creating BI prototypes
Discovered data quality problems and reporting errors during prototype creation
Outlined data management strategies
Researched and created all KPI to match our company strategic goals
Utilized Power BI API to create dashboards based on Salesforce data
Presented Modern Data Warehouse / BI concepts to Sr. Developers
Broke down department silos by turning compartmentalized data into relational database for use with data models
Acquired Skills: Data Warehouse, Advanced Data Modeling, Financial Analysis, SSAS, SSIS, SSDT, Tabular Data Model, Kimball Data Warehouse, ETL, Excel BI, Power BI, SharePoint Online, Enterprise Accounting
Grayling Industries, Inc., (subsidiary of ILC Dover)
Associate Programmer (Developer / Analyst)
September 2014 – January 2015
Spear-headed source control implementation, documenting data sources and creating transparency in reporting
Learned MAS 200 (Sage), ERP System in eight weeks
Improved transparency to all stakeholders by creating flowcharts documenting all application systems and reports
Interviewed business units to determine software development priorities
Designed Enterprise Agile Concept to improve software development efficiencies aligned with company strategy
Modeled financial and operational metrics
Research and learned many manufacturing-related subjects including Standard Costing, Six Sigma, and Lean Manufacturing
Designed FDA Lot Trace Infrastructure using existing ERP System and resources
Acquired Skills: MAS 200 ERP, Improved SQL, Standard Costing, Six Sigma, Lean Accounting, Integrating Reporting, Managerial Accounting, Agile Development, Enterprise Architecture
Learned Syteline ERP System, T-SQL, SQL Server, VB.NET, Source Control, and Visual Studios. Produced production quality code within six months, solving the most complex ERP problems within the first nine months.
Designed companies Team Foundation (TFS) Source Control procedures in my first month
Created complex stored procedures and database views using T-SQL and SQL Server Management Studio
Built ERP Scripts with modular VB.NET code
Analyzed business processes and wrote functional specifications
Researched ERP System from both the developer and user perspectives
Created SSRS reports and ERP Data Views
Utilized Agile/Kanban and Microsoft OneNote to help manage efficient development
Acquired Skills: Syteline ERP, SQL Server, T-SQL, VB.NET, VB6, Visual Studios, Source Control, Database Design, Functional Specifications, Waterfall Development, Agile Development
Smartis, Inc.
Founder – Strategic Management – Sales/Marketing
January 2004 – January 2012
Pioneer in home technology packages to the mass-market. Smartis was a leader in residential and small commercial technology solutions. Finalist for national awards from the Consumer Technology Association, formerly “CEA,” Mark of Excellence Awards, two consecutive years. Multiple local award winners, including HBA/DE Regal Awards.
Services:
Smart Home
Home Theater
Audio/Video
Security
Surveillance
Network Infrastructure
Built company from the ground up with Co-Founder. Learned new evolving industry simultaneously while improving sales, marketing, accounting, and finance skills.
Grew revenue from $0 to $980,000 per annum by the 4th year
Implemented “Blue Ocean Strategy,” created a new market segment
Used “Lean Startup” methodologies to maximize profitability through marketing, operations, and supply chain
Created the business plan and raised startup capital
Oversaw overall company operations
Managed financial analysis, planning, and forecasting
Designed employee training programs to simplify complex installations
Implemented multi-tiered marketing plan that included home builders, direct customers, and small business clients
Conducted investor presentations for initial financing
Setup financial KPI metrics and ratio analysis
Oversaw and delegated accounting functions
Created pricing calculators based upon business model, value streams and customer lifetime value to determine profitability
Setup operational KPI metrics and delegated operations management
Consulted Leviton Manufacturing on smart home new product development
Managed builder sales teams and created user-friendly marketing material
Negotiated material price contracts with major vendors
Consulted insurance companies for electronic home claims
Acquired Skills: Excel, Salesforce, Outbound Marketing, Inbound Marketing, SEO, Local Search, Accounting, QuickBooks, Strategic Management, Operations Management, Sales Management
EDUCATION
A.A.S Web Development, Summa cum laude, GPA 3.94
Delaware Technical & Community College
January 2012 – May 2013
Student Achievement Award Winner
Who's Who Among Students in American Universities & Colleges Award Winner
Phi Theta Kappa Honor Society
2013 "Cyber Quest" Cybersecurity Competition
Completed degree program in 16 months
Self-taught MBA equivalent
Autodidact, self-directed learning
January 2003 – Present
My LinkedIn profile includes my Smarterer scores in the below categories. Smarterer was a crowdsourcing skills assessment bought by Pluralsight (which I am a subscriber). They closed Smarterer at the end of 2015 but have plans to re-introduce the platform as a part of Pluralsight online learning platform.
Strategic Management
Operations Management
Financial Accounting
Marketing
Financial Analysis
Data Warehouse
Data Modeling
CERTIFICATIONS
MCSE: Data Management and Analytics — Certified 2017
MCSA: SQL 2016 Business Intelligence Development - Certified 2017
CompTIA Net+ Certification (2013)
Microsoft Certified Professional (MCP) (2001)
CONTACT INFO
Scott Hargett
adi55b@r.postjobfree.com