Andrew Herron Email & Phone Number

Wixom, Mi, Us

Managed and supported office and warehouse technical needs, including Windows and MacOS desktop systems, thermal printers and shipping scales, IP telephony system, network architecture, and internal IoT network. Maintained on-prem Microsoft ActiveDirectory domain, Microsoft Dynamics NAV 2017 ERP and associated SQL Server 2019 database. Customized NAV reporting and code units where possible. Lead and managed migration of on-prem ERP system to Business Central. Worked with external vendors for NAV development, Shopify customization, and integration middleware. Supported marketing team by monitoring and engaging across several social media platforms. Worked with manufacturing engineer to automate processes using collaborative robots, including building reporting and telemetry systems, developing custom software in Ruby. Assisted in implementing laser engraving system including safety analysis and communication software. Developed Ruby on Rails based system for quality control, job tracking, and reporting.

Ann Arbor, Mi, Us

Developed new, and improved, features for existing software platforms using Java, NetBeans, and MySQL and upgraded software build dependencies to modern versions. Maintained and improved upon AWS-based infrastructure for multiple software deployments managed by Jenkins. Migrated and architected database architecture to move system from Oracle to MySQL.

Kalamazoo, Michigan, Us

Met with clients during initial sales meetings to understand technical requirements for new and existing projects and transferred requirements to visioning and project estimation. Developed application and database architectures and provided technical analysis during project discovery. Developed iOS application that connected to bluetooth IoT device using React Native.

Somerset, New Jersey , Us

Developed and maintained Logstash and Elasticsearch deployments based in AWS ecosystem and on-premise linux-based systems. Utilized CloudFormation, Lambda (NodeJS), and API Gateway to provide secure methods for ingestion, indexing and searching. Worked with multiple internal organizations to develop cloud strategy and policy for deployment of new technologies. Developed Ruby based ETL software for transformation of medical data into standard format.

Santa Clara, Ca, Us

Maintained existing ETL codebase based on Java and AWS EMR for telemetry analytics dashboard and report generation. Developed ETL and automated report generation using Ruby for near real-time analytics. Designed, developed, deployed, and maintained ElasticSearch cluster for new analytics dashboard utilizing Ruby, AWS EC2 and EMR, and Kibana capable of indexing over 200 million records daily and providing near real-time on- demand reporting. Assisted in architecting systems for digesting telemetry data using Ruby, AWS EMR, Lambda, and S3, and MySQL.

Detroit, Mi, Us

Design and management of cloud-based infrastructure, using AWS and RightScale, and full stack web development, with PHP and JavaScript, customer support, system administration, and team lead duties. Architected, deployed, and maintained MySQL schema, cluster, and data warehouse.

Investigated and began implementation of RETS data feeds for MLS listings.

New York, Ny, Us

Created first systems to consume large amounts of user-generated content from various remote services using Ruby and MySQL. Managed the further development of data consumption services and helped direct the development of SugarCRM into a social media analysis platform. Tested, implemented, and helped develop Java-based natural language processing software. Also responsible for data analysis of user-generated content sources for business intelligence and implementation feasibility using created and existing Ruby-based libraries.

Developed customer-facing web sites and portals using open source technologies, including Ruby on Rails, Python and PHP. Extensive research and analysis of mobile technologies for use in business to consumer communications. Evaluate and test new technologies for viability for application development and deployment. Create Rich Internet Applications using Javascript on the Adobe AIR platform.

Responsible for taking existing affiliate management software, written in ASP, and customizing to client’s needs. Including, integrating Microsoft’s Passport login system, developing AJAX based solutions for single-page interfaces, distributing content from XML feeds, developing SQL databases and stored procedures, and complete interface changes to match client’s existing schema. Managed and developed programs for multi-million dollar companies, including being the technical single point of contact, determining price quotes for custom work, and delegating custom work as resources required. Researched and developed new technologies such as Python and Ruby for new product feasibility. Developed web-based applications to streamline workflow processes and reduce waste of company resources, including intranet site to build reports for clients, reports on client performance and management. Offered technical support on software and existing custom programming, both internal and external. Also worked on network management and systems maintenance as needed.