Gary Mcclure Email & Phone Number

Morrisville, Pa, Us

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.

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.

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

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.

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.

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.

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

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.

Business Administration

Psychology

General Studies

Biology/Economics