Greg Hill

Experience

• 

  Castelli North America, Inc.

  Sept 2000 - Jul 2003

  Systems Analyst

  • Designed and developed sales and marketing database applications for regional sales representatives using propriety and historical data• Implemented inventory cycle counting and reordering processes• Developed Master Data Management processes to create and maintain clean, accurate data across shared systems for a single source of truth• Prepared and presented sales and marketing presentations to senior leadership and executives• Managed relations with key clients

• 

  Open Waters, LLC

  Aug 2003 - May 2009

  Founder - Owner

  • Developed a third party logistics company which provided scalable order fulfillment services, value-added services including in-house hot foil embossing and personalization, and direct to garment printing• Designed and developed a custom application with inventory, shipping, receiving, picking, reporting, xml web services, and customer communication modules• Deployed and managed in-house IT systems: Red Hat, MS Exchange Server, MS SQL Server, Windows 2003 Active Directory, Avaya Merlin Magix MLX phone system, and SonicWall firewall• Implemented process improvement strategies to reduce process cycle time, reduce fulfillment errors, and increase customer satisfaction• Developed algorithms to detect inconsistencies and errors in customer supplied data that would result in operational delays, revenue leakage, and poor customer experience• Developed and executed sales and marketing campaigns• Led all financial operations• Recruited, trained, developed staff for customer service, receiving, shipping, picking, packing, and reporting roles Show less

• 

  Self Employed - Database Consultant

  May 2009 - May 2014

  Data Evangelist

  • Worked with local small businesses to derive more value from their data by facilitating discussions to define and measure business outcomes with KPIs and rituals to reinforce virtuous feedback loops • Refined business processes: document, design, develop, and implement data solutions• Designed and changed data models to support changing goals • Implemented database back-up and restoration solutions

• 

  Marketing Evolution

  May 2014 - Dec 2017

  • Implemented an operational business intelligence platform; a centralized web-based BI platform with Master Data Management, Entity Relationship Management, a Media Data Mart, Media Plan Optimization, automated ETL, with complete RESTful API. The platform achieved 4x efficiencies in data load times, provided a single source of truth for teams, and generated optimized media plans. Built with Python, PostgreSQL, DynamoDB, Redis, AWS SQS, and S3 on AWS resources• Implemented a GIS microservice for mapping media impression data to US NationalGrid and appended 1st and 3rd party exogenous, segmentation, and geodemographic data• Led DevOps Initiatives: Release management, deployment patterns, networking, backups, and AWS infrastructure as code• Managed Atlassian Jira roadmap, work intake, burndown, and backlog Show less • Led a team of engineers to develop an operational business intelligence platform• Engineered and implemented APIs for media order management, information retrieval and processing using Nginx, Python, Redis, and PostgreSQL• Developed and implemented an internal geospatial application for determining media audience size, composition, category development index and brand development index• Attribution modeling and spatiotemporal modeling to understand omni-channel marketing effectiveness Show less • Full-stack Geospatial application development: Create elegant, beautiful interactive web maps for visual story telling and exploratory analysis. • Spatial Analysis of marketing effectiveness: Geographically Weighted Regression for exploratory analysis, spatial error and lag models for hypothesis testing, and spatial analysis techniques for hot spot analysis. • Data visualization: Use OpenLayers, D3, Highcharts, FusionCharts to generate data driven visualization. • Develop automated ETL and web scraping systems Show less

  • Director of Business Intelligence

    Mar 2016 - Dec 2017

  • Manager, Business Intelligence Engineer

    Oct 2015 - Mar 2016

  • Analyst

    May 2014 - Oct 2015
• 

  Clear Capital

  Jan 2018 - Jan 2022

  • Grew 6 Data Engineers into a team of 19 cross-functional Business Intelligence Developers, Database Administrators, Data Engineers, Software Engineers, and Data Quality Analysts• Led an Oracle 12c to 19c upgrade on new hardware, expanding to a 3 node RAC system, and in parallel managed an Oracle LMS Audit which resulted in zero findings• Decreased processing time of a bulk data delivery product by 80% while scaling the product to 5x growth, and improving match rates from 86% to 98%• Released net new reference data systems orchestrated with Airflow for one data domain Show less • Migrated one on-prem data domain to AWS creating a hybrid environment• Implemented process change and pulled the team into Jira and Kanban with Git version control, rolled out new SDLC processes reducing rework and work in process, resulting in 40% greater successful release frequency• Expanded the data model and service layer of one data domain with an additional 50 features from over 300 individual source systems • Formalized Data Quality measurements, monitoring, support request queue, and roadmap• Developed Terraform modules for repeatable RDS Progress and RDS Aurora Postgres deployments with KMS, and EC2 ASGs, KMS, EFS, S3, and Networking deployments for compute• Developed AWS CLI RDS non-production database refresh routines Show less

  • Director, Data & Analytics

    Oct 2018 - Jan 2022

  • Sr. Data & Analytics Engineer

    Jan 2018 - Oct 2018