David Maceachern Email & Phone Number

Courbevoie, Fr

Irving, Texas, Us

Worked with business stakeholders to gather and document requirements regarding analysis needs. Developed and managed ETL pipelines used for updating the monthly marketing database. Extracting data from multiple SalesForce instances via APIs, processing the data with Python. and importing the data to a SQL database. Implemented changes to the ETL process to improve the data quality output. Migrated the reporting engine to a cloud server and connected it to the businesses Tableau server.Noted Accomplishments:• Improved data quality of reports by working with stakeholders to define requirements and develop new datasets for reporting use.• Reduced a manual 40-hour process into an automated 30-minute ETL pipeline by optimizing ETL codebase and further developing pipelines written in Python. • Migrated reporting engine to cloud infrastructure and connected it to the businesses Tableau server.

Stoughton, Massachusetts, Us

Lead extraction, formatting, and loading of data from partner sites into Shields’ databases. Developed Python scripts and processes to automate monthly report aggregation and validate data imports. Standardized file templates and data requirements for import, guided ETL processes, corrected issues, and ensured SOPs included relevant business logic. Collaborated to set operational task priorities, monitored scheduling, and tracked project metadata. Improved and documented processes and workflows.

Wilmington, Massachusetts, Us

𝗖𝗶𝘁𝗼𝘅𝗟𝗮𝗯 𝗠𝗲𝗿𝗴𝗲𝗿 𝗮𝗻𝗱 𝗔𝗰𝗾𝘂𝗶𝘀𝗶𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗖𝗵𝗮𝗿𝗹𝗲𝘀 𝗥𝗶𝘃𝗲𝗿 𝗟𝗮𝗯𝘀.• Worked as lead analyst across multiple CitoxLab sites facilitating the extraction, formatting, & loading of data into CRL’s financial Data Warehouse.• Familiarized sites with data requirements and file templates related to sales orders, revenue, and projects. • Evaluated initial data feeds for import. Worked with sites to correct any issues identified in data feeds and identified additional business logic to add to initial file evaluation SOPs. • Managed project milestones, issues, & status. Updated project leads and customer stakeholders in a weekly cadence.• Coordinated the import, testing, and validation of initial data imports.• Developed reports used for data import validation.• Identified and reported bugs in ETL processes based off of reports.• Authored user requirements and led testing on continuous improvement initiatives on improved validation and notification logic for ETL.• Trained support team on CitoxLab post go live processes.• Worked with CRL’s Data Analytics’ team on lessons learned and best practices. Reviewed and updated documentation to reflect all lessons learned and best practices rules and guidelines. • Reviewed and updated documentation to reflect all lessons learned & best practices rules and guidelines.• Identified data issues and resolutions. • Identified discrepancies in Production vs QA environments.• Identified SSIS validation issues and recommended solutions.

• Automated data transformations using SQL and Python• Developed reports to provide transparency into observable downtime events for Symbotic systems. • Developed reports and dashboards to assist in data input accuracy. • Developed category tree to assist in pareto analysis. • Identified areas for improving and localizing data integration and automation.

Boston, Massachusetts, Us

- Manage the data import process, validation and testing of school district’s data into Ellevation’s platform.- Implement data file mapping, transformation and loading solutions using proprietary and off-the-shelf software tools- Communicate with partner support and clients about data specifications and support them at each step in the data integration process- Maintain schedules for recurring operational tasks, track key client and project metadata and assist in evaluating task priorities

San Diego, Ca, Us

• Collaborated with engineers to improve BI reporting related to sales revenue and inventory- Identified discrepancies in reports and liaised with operations and BI engineers to solve them- Defined what data should be used within the reports and assisted in maintaining their integrity• Recorded and provided reports on all wholesale sales revenue and payment receipts• Created daily inventory reports- Updated format of reports when new products or product details were required• Managed wholesale customer accounts:- Customer disputes, credits, balance sheets• Onboarded new customers:- Familiarized customers with the order process- Worked with operations to ensure orders were shipped to the customer’s expectations- Worked with operations to ensure we remain export compliant when shipping internationally• Traveled to our warehouse to assist in streamlining outbound operations and inventory management• Facilitated the development of sales tools to automate wholesale order processing management• Assisted in sales and customer development• Managed and maintained database of customer contacts

San Diego, Ca, Us

San Diego, Ca, Us

• Key contributor during ERP implementation - Continued to provide feedback and observations to engineering team to improve operational processes• Responded to escalated customer issues and complaints to maintain a Top Rated Seller status within e-commerce channels• Consistently developed new strategies for dealing with fraud• Developed new SOP’s for recurring issues within Gazelle’s systems. Reviewed applicable revisions to SOP• Created and maintained aged retail order reports that required additional monitoring for proper expedition- Managed inventory changes and replacements for orders as needed

Sociology, Criminal Justice

Education record

Education record