Adam Douville

• Develop new ETL (Extract, Transform, Load) flows and data pipelines connecting multiple sources of data into unified databases, while also consistently improving upon existing pipelines
• Assemble large, complex data sets that meet functional/non-functional business requirements
• Assist with process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
• Recommend and built infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, scripting, and cloud technologies (Azure)
• Built business process for managing teams to track work, code, builds, applications, and tests to sustain healthy output and trackable results across the organization.
• Collaborated with DT to migrate from legacy systems to cloud-based Snowflake Data Warehouse, impacting over 1000 users.

• Ensured data consistency and quality in database consisting of a mixture of internal and customer data
• Served as a resource and technical lead for team adoption of new technologies and tools
• Converted all manually processed reports from Excel to Tableau via Teradata, Alteryx, and Tableau.
• Provided insight, suggestions, and technical support for creation of OE and Aftermarket solutions for OTD reporting to executive leadership
• Technical problem solving and automation of existing manual data cleaning processes.
• Developed new ETL (Extract, Transform, Load) flows and data pipelines connecting multiple sources of data into unified databases, while also consistently improving upon existing pipelines
• Provided reports to leadership on data quality and progress towards enhancements in turnaround times and data accuracy for customers such as Boeing, Lockheed Martin, United Airlines, Northrop Grumman and more.

Developed and manage information links, data, models, and interactive visual analytical dashboards.

• Integrated data into composites for insight to decision action.
• Derived, documented & communicated analytical business insight from data.
• Queried ERP systems and database platforms such as Oracle & Teradata for all customer requirements.
• Developed, validated, and maintained predictive and prescriptive analytical algorithms.
• Developed Python Multi-Pareto Frontier model to help VPs decide on Waterline decision making for Commercial and Military engines to remove human bias.
• Interfaced with Module Centers, and Operations Command Center material flow leaders to drive supply chain delivery and quality excellence.