Doug Macleod Email & Phone Number

Irving, Texas, Us

Support production Data and systemsDevelop utilities for migrating, integrating and maintaining on prem and cloud data sets in the MDM customer space.Work with data stewards and to identify problems and specify solutions

Irving, Texas, Us

Assist in the design of customer master mdm system. Wireframe UX requirements and map to data objects. Assist in mapping canonical legacy structures to new data objects. Map and specify transformation logic for data.

Flossmoor, Illinois, Us

Develop predictive models for clients in cpg retail and distribution. Write data pipelines in python, AWS Lambda, Glue and AWS pipeline and on on premise linux/postgres. Using a variety of tools for data ingestion and publication (pySpark, EMR). Develop all data models.Develop interface specifications and code batch interfaces and streaming for uploads and downloads. Develop various validation, filtering and mapping routines for internal pipelines and post model data visualization, data marts and data warehouses.

Rosemont , Il, Us

Application Design and Data Architect for iOS development of custom field sales order entry application for beer distributors that processed about 3 $B in sales annually. Also responsible for development and maintenance of cloud based backend that integrated iOS devices with various ERP systems. Responsible for functional specification, system testing and writing test scripts in Objective C, as well as Bash shell,Postgres SQL functions development database administration. Debug production issues, including using stack traces and logging to isolate Java source code or data integration issues. Wrote and maintained extensive integration ETL scripts in PL/SQL.

Other engagements included retail and insurance industries using SQL Server and Oracle.Provided specifications and S.O.W.'s for enhancements and managed projects to time and budget.

Product Development and SupportDevelop, host and support RouteXL, an independent distributor route management,inventory and billing system utilized by the largest national bottled water deliveryorganization. The system is offered on an SaaS (Software as a Service) basis.Developed order entry and tracking systems for use on Nextel 8088 and Palm Treodevices. “Sell Phone” was for small to mid size consumer product distributors. Mostrecent experience includes developing iPhone app for cooking that includes extensivemedia manipulation, email, back end server integration and other data capture andsharing.ConsultingProduct Development and SupportDevelop, host and support RouteXL, an independent distributor route management,inventory and billing system utilized by the largest national bottled water deliveryorganization. The system is offered on an SaaS (Software as a Service) basis.Developed order entry and tracking systems for use on Nextel 8088 and Palm Treodevices. “Sell Phone” was for small to mid size consumer product distributors. Mostrecent experience includes developing iPhone app for cooking that includes extensivemedia manipulation, email, back end server integration and other data capture andsharing.