Gary Mcclure

Gary Mcclure Email and Phone Number

Senior Data Engineer @ Lotic.ai, Inc.
Gary Mcclure's Location
Levittown, Pennsylvania, United States, United States
Gary Mcclure's Contact Details

Gary Mcclure personal email

About Gary Mcclure

Over 22 years’ experience in digital, behavioral and television advertising technology, I possess a deep and intuitive understanding of complex data systems. I have built and managed multiple quality data testing teams in fast-paced startup environments, ensuring quality supportable systems for multi-million dollar businesses.Languages: SQL, Unix Shell scripting, Python, rubyOperating Systems: Unix (linux, Sun, FreeBSD), Windows, Mac OSPlatforms and Tools: Hadoop, Hive, AWS, Git, Airflow

Gary Mcclure's Current Company Details
Lotic.ai, Inc.

Lotic.Ai, Inc.

View
Senior Data Engineer
Gary Mcclure Work Experience Details
  • Lotic.Ai, Inc.
    Senior Data Engineer
    Lotic.Ai, Inc. Oct 2022 - Present
    Austin, Us
    ● Developed the data backend for Lotic’s first Retrieval Augmented Generation (RAG) system, collaborating with Data Science and Machine Learning teams. This setup supports 60+ stakeholders and serves ~5000 users, providing accurate behavioral data.● Enhanced user response quality by 40% through advanced text preprocessing, quality assessments, and readability analyses. Engineered data-driven prompts to improve clarity and coherence.● Designed and implemented a Dagster+ system for efficient management of data dependencies, workflows, and scheduling. This system saves up to 12 hours per week (approx. $54,000 annually) and facilitates quick integration of new data sources by data science and machine learning teams, reducing the need for additional data engineering staff.● Built and configured Airbyte servers on AWS to synchronize Postgres databases and Mixpanel feeds into a unified staging database, enabling hands-off production data syncing for timely analysis by the data science and insights teams.● Implemented the Insights Data Warehouse to consolidate user, ML, and AI outputs, reducing analysis time by 95%, from one week to half a day.● Researched and secured approval for the DOMO BI tool, delivering efficient, low-cost reporting and dashboards, enhancing data visibility and decision-making for internal and external stakeholders.● Worked with the front-end team to evaluate and optimize Lotic’s microservice architecture, offering strategic guidance and actionable feedback.● Developed product requirements for seamless external data integrations with Apple HealthKit, improving data interoperability.● Created and led the Lotic Data Literacy Program, advancing data security and privacy practices across the organization.
  • Simulmedia
    Data Engineer
    Simulmedia Oct 2017 - Aug 2022
    New York, New York, Us
    ● Conduct deep Data analysis of new Set Top Box (STB) data, Automatic Content Recognition (ACR) data, and schedule data from data partners to assess quality and usability.● Manage the STB and ACR data validation process with Engineering, Business Operations and Data Science teams. ● Create inline reporting validations for Simulmedia’s reporting platform using SQL, Python and Pyhocon.● Create Data quality alerts for Simulmedia’s data warehouse using SQL, Redshift, Python and Airflow.● Create airflow jobs to export data from business facing API’s into Simulmedia’s data warehouse for use by operations, data science, and business intelligence team using Python, SQL, Airflow and Redshift.● Create custom reporting tools for use by advertiser operations team using Python, Pandas, Flask, web2py, and redshift.● Create new ad performance reports for ad operations using Python, SQL, and redshift.● Migrate all of data operations ETL’s and reporting tools from python 2.7 to Python 3.7.9● Work with engineering in design and coding of STB/ACR ETL’s and joining of STB/ACR data with other data sets using Python, AWS, Redshift, and Pandas.
  • Simulmedia
    Data Operations
    Simulmedia Jun 2014 - Oct 2017
    New York, New York, Us
    ● Manage the engineering relationships between Simulmedia and the various STB data providers, including support escalations, technical questions and data format updates.● Support Technical Operations team with system debugging and problem resolution.● Manage Data migration from a7 platform to Vamos platform● Configure new RDS instances and import existing a7 databases into.● Backup and decommission STB data in Hadoop Clusters
  • Simulmedia
    Qa Manager
    Simulmedia Apr 2010 - Jun 2014
    New York, New York, Us
    ● Implement the quality assurance issue tracking, measurement and reporting system● Build and manage Simulmedia’s Quality Assurance team and processes from 1 employee to a team of 5.● Define and implement the release management process to address software build, packaging, versioning, release notes and installation scripts.● Work with Chief architect and engineering in design of STB ETL and joining of STB data with other data sets using hive, hadoop and postgres● Administer and manage the quality assurance lab. ● Develop and execute software test plans incorporating functional, regression, and stress testing and analyze results and recommend corrective action for Simulmedia’s applications, subsystems and a7 infrastructure. ● Ensure clear, testable requirements with Product Management and Engineering teams. ● Direct automated quality assurance testing program definition, implementation and execution using ruby, selenium and cucumber. ● Guide code reviews, software design sessions, and architectural reviews.● Provide Technical Support to customers and partners.
  • Tacoda
    Sr. Qa Engineer
    Tacoda Jul 2006 - Apr 2010
    Us
    • Led testing of Tacoda’s behavioral targeting data collection engine to insure proper tracking of user behavior across partner’s websites.• Led testing of Behavioral data ETL from initial collection through warehouse ingestion to insure integrity and quality through the entire ETL process using ruby and sql in Oracle and MySql databases.• Provided customers and partners with second level support around site data collection issues and managed communications between, partners, customers, engineering and business around said issues. • Performed test execution and validation activities to ensure implementation deadlines were met.• Automated test scripts when possible using watir and shell scripting to streamline and speed up quality assurance testing activities. • Utilized gdb debugger and strace to debug issues with the UNIX binaries. • Configured Apache web servers for quality assurance test environment.• Automated quality assurance environment monitoring and cleanup using shell scripts. • Automated MSRS Report testing using watir.• Tested JavaScript files used for setting cookies. • Regression tested .net GUI, java based log processing and ETL system, behavioral tracking system using all recent versions of Internet Explorer, Firefox, Opera, Safari, Netscape browsers.
  • Popular Financial Holdings
    Sr. Qa Analyst
    Popular Financial Holdings Jul 2005 - Jun 2006
    Us
    • Reviewed business requirements, functional specifications and design documents to ensure requirement traceability.• Performed test execution and validation activities to ensure implementation deadlines were met.• Assisted Business Analysts in requirements development and future software release design.• Assisted business units in the implementation of standardized quality assurance processes. • Monitored quality assurance activities to ensure complete testing coverage and conformance to established quality assurance standards.• Identified areas for process improvement to further increase efficiencies in the ITS department.• Used Cobit scorecards to monitor and ensure consistency in the ITS governance process. Made recommendations for continual process improvement as necessary.
  • Real Media, Inc
    Qa Lead/Manager
    Real Media, Inc Apr 2000 - Apr 2005
    • Led day-to-day software testing within quality assurance team. • Developed, planned and executed new testing strategies. • Implemented quality assurance test documentation based on IEEE Standard 829-1983 for Software Test Documentation.• Worked to create, refine and execute a more efficient global quality assurance strategy to speed up delivery of software to clients worldwide.• Acted as Build and Configuration Manager, responsible for insuring error-free software builds, stable test environments, version control and final packaging of software on a number of platforms. • Assisted Engineering team requirements development and future software release design. • Served as liaison to management, marketing, documentation and technical support teams for interdepartmental projects and product releases.• Performed White box testing on Multi-threaded apache modules and UNIX daemons.• Utilized gdb debugger and strace to debug UNIX core dumps and other issues with the UNIX binaries• Tested elements, which included Web servers (IIS, Apache, and Netscape), the GUI, the ad delivery engine, and database interfaces (Oracle, MySql, and MSSQL). Software being tested incorporated Visual C & C++ and Embedded C.• Compiled, installed and configured Apache and Netscape web servers for use as test environments. Windows platforms tested include NT, 2000, and 98, while Unix platforms included Sun, Irix, Linux, and FreeBSD.
  • Hydrocarbon Technologies Inc
    Chemical Operator
    Hydrocarbon Technologies Inc Aug 1997 - Apr 2000
    Responsible for the hydrocracking units operation monitoring processes, collecting data, tracking resultsPerformed regular emergency maintenance of hydrocracking units, including supervising high-pressure piping, chemical spill cleanup, securing of gas leaks and maintaining pumpsAssisted in the setup of new system control and data acquisition (SCADA) system.

Gary Mcclure Skills

Linux Agile Methodologies Testing Databases Sql Hadoop Analytics Product Management Sdlc E Commerce Software Quality Assurance Unix Digital Media Mysql Test Design Web Testing Hive Sarbanes Oxley Regression Testing Quality Assurance Shell Scripting Oracle Set Top Box Big Data

Gary Mcclure Education Details

  • Bucks County Community College
    Bucks County Community College
    Business Administration
  • Kutztown University Of Pennsylvania
    Kutztown University Of Pennsylvania
    Psychology
  • Bucks County Community College
    Bucks County Community College
    General Studies
  • Lycoming College
    Lycoming College
    Biology/Economics

Frequently Asked Questions about Gary Mcclure

What company does Gary Mcclure work for?

Gary Mcclure works for Lotic.ai, Inc.

What is Gary Mcclure's role at the current company?

Gary Mcclure's current role is Senior Data Engineer.

What is Gary Mcclure's email address?

Gary Mcclure's email address is ga****@****ail.com

What is Gary Mcclure's direct phone number?

Gary Mcclure's direct phone number is +164620*****

What schools did Gary Mcclure attend?

Gary Mcclure attended Bucks County Community College, Kutztown University Of Pennsylvania, Bucks County Community College, Lycoming College.

What are some of Gary Mcclure's interests?

Gary Mcclure has interest in Human Rights, Science And Technology, Education, Poverty Alleviation.

What skills is Gary Mcclure known for?

Gary Mcclure has skills like Linux, Agile Methodologies, Testing, Databases, Sql, Hadoop, Analytics, Product Management, Sdlc, E Commerce, Software Quality Assurance, Unix.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.