Educational progression through all primary SQL functions using PostgreSQL. Simple queries, complex queries, subqueries, nested queries, Aggregate functions, Data type functions, window functions, CTE's, Temp tables, and more.

Emphasis: Tourism
Minor: Hospitality Management. 
In depth focus on Outdoor Leadership and Recreation Management with experience in Hospitality Management and Services Marketing

Bike

Moto & Powersports

Music

Outdoor

Snow

Tech

Founder, Matrices Analytics LLC | Business and Data Analytics Consulting | Data Analysis | Data Engineering | Business Intelligence

As a seasoned expert in the data arena with management and directorial experience, I am committed to transforming complex business requirements into actionable solutions that drive positive business outcomes. My thoughtful and strategic approach to defining and deploying analytical products and processes ensures seamless alignment between product teams, procurement, channel marketing, and financial functions. I excel in collaborating with cross-functional teams, leveraging data and insights to facilitate rigorous analytics programs, high impact prioritization, and stakeholder inclusion. Always focused on continuous learning and improvement, I guide teams through successful implementations while celebrating key milestones and delivering substantive business outcomes.

• Utilized Open AI GPT models, Google Vision, and Claude to test statistical success rates and model sensitivity for a new GenAI data tool.
• Co-invested in a Pre-Seed Startup, focusing on AI/ML consulting remotely from Boulder, Colorado.

Freelance AI/ML Consultant

Founder

Established and led a high-performance team managing US Authorization program and Unilateral
Minimum Advertised Price (UAP) Policy. Incorporated use of Snowflake DW into the product
tracking and product data management used by the finance team in collaboration with Pricing and
Product managers. Leveraged 3rd party SaaS platforms for analysis, workflow, and decisions
required over different time horizons. Hosted reviews of pricing data with pricing, product, and
channel management teams to ensure strategic alignment. Evaluated impact of gray market
sellers and delegated the results for enforcement to external legal team. Initiated automated data
review process flagging changes and errors to ensure complete and accurate data for supporting
documentation.

• Negotiated SaaS contract reducing annual cost by 15% with favorable billing structure
• Managed product data, pricing updates, and service providers, improving market visibility
by 200%+
• Strategic Retail partners reported 3% to 6% retail margin improvements
• Partner outreach improved authorization program participation by 30%
• Policy and Agreement enforcement methods yielded 90% reductions to gray market sellers
and price erosion events

Systems: PriceSpider PROWL, TrackStreet, JDE E1, Snowflake, Power BI, Microsoft 365
productivity suite

Manager, Reseller Authorization & Pricing Policies

Influenced and consulted on eight-figure revenue management spanning two product
departments, eight product classes, 70+ vendors, and 400+ SKU’s distributed across 180+
locations. Revenue management through planning, forecasting, and intensive data analysis.
Engaged with end-to-end S2P processes to manage risk and ensure supply chain efficiencies.
Procured in-season product through True Replenishment Inventory Management (TRIM).
Analyzed and reported demand, sales, and inventory behavior to VP stakeholders. Special project
technical SME, driving the exploratory analysis of data within ServiceNow, Snowflake PostgreSQL
data warehouse, and development of reporting for Merchandising organization in collaboration
with Business Intelligence.

• Developed and automated PostgreSQL product life cycle report for the 40+ member
Replenishment Analyst team for daily use in managing replenishment. Estimated to save
~3200 work hours/year.
• Optimized international code compliant financial, product, and inventory practices for LP Gas
product (hazardous material) to address the double digit % losses, recapturing over $1
Million in lost sales.
• Unified cross functional team communications around LP Gas by hosting cross functional
strategy sessions and proactively identifying responses to product triggers reducing group
work load by an estimated 400 hours/year.
• Built Dashboard and Reports for LP Gas inventory, revenue, and demand incorporating
weight metrics and KPIs to align internal strategy with International fire code capacity limits
resulting in centralized material for financial and product planning.

Systems: ServiceNow, Blue Yonder ASR, Snowflake, PostgreSQL, Excel, DBeaver, Sigma, Tableau,
Aptos, SAP, Analysis for Office, and Microsoft 365 productivity suite.

Replenishment Analyst

Key account management for 60%+ of domestic revenue sources across 2 market channels and 3 marketplaces. Development, administration, and enforcement of domestic reseller, online reseller, and MAP policies. Manage domestic product data, and sales data for internal reporting, and data delivery via FTP to 3rd party reporting group for external reporting. Creation, management, and maintenance of cyclical sales and marketing collateral. Data platform administration (NPD Group and SPS Analytics), managing license use and users, standardizing available reports and reporting structure, and training users on platform form and function. 

    • Analyzed SMU revenue revealing historical inaccuracies in remitted royalty fees resulting in an undisclosed credit for the historical inaccuracy going back 5 years and estimated reduction of future royalty fees by ~$100K annually.
    • Standardized 3rd party market intelligence reporting revealing market segment penetration shifting Marketing spend from Specialty retail to eCommerce. Ecommerce market channel increased +6%, channel penetration +1%.
    • Collaborated with cross functional teams to establish Amazon FBA consignment key account reducing marketplace resellers from 40+ to 1 and contributing an account margin 14% above company margin.
    • Partnered with Controller and HR to establish automated reporting expediting the MTA commission calculation and payout process, and revenue reporting for corporate affiliate programs.
    • Excelled as Excel SME saving 40+ work hours/month between the sales, HR, operations, and accounting teams.

Systems: Microsoft Dynamics AX, Excel, Microsoft 365 productivity suite, SPS Analytics, NPD DecisionKey, MySQL (community version), Python, PowerBI, DAX, DeltaMaster.

Sales Coordinator/Data Analyst

Lead the warehouse team in the US distribution of Deuter and Ortovox product. Pick, Pack, Ship! Process international containers. Align warehouse practices with routing guides for larger retail partners.

•	Obtained Hazardous Materials shipping certification
•	Improved shipping rates ~2% through relationship building and negotiation
•	Built Excel report to combine UPS and FedEx Tracking data, and communicate Tracking data to Sales and Marketing teams (built 2018, still active report)

Warehouse Lead

Assist in the setup and launch of new retail location with significantly increased retail space, and dedicated rental space. Manage Square POS system, setting efficient layout, updating item information, receiving product shipments, stocking and merchandising retail space, running the register, and assisting with rental outfitting.

•	Generate Top Sellers report, upload item data into Square POS, rental and retail sales
•	Merchandise Retail space, Replenishment purchasing

Assistant Manager Retail/Buyer

Staff scheduling, run register during peak hours, customer service, setup or perform special requests (e.g. equipment tuning, ASTM tests). Replenish stock, up-sell rentals.

Estimated seasonal growth of 8%, highest profitable Breckenridge store winter '15/'16

Assistant Store Manager - Breck Sports - Peak 7 (Crystal Peak)

Assist managing Icebreaker concept store in the Solaris Plaza of Vail Village. Customer service focus, Sales, Profit and Loss reporting, corporate defined store merchandising.

Team earned multiple platinum service award nominations, and 100% Secret Shopper scores. 

Assistant Store Manager - Icebreaker Vail Village

Find out detailed information about Daniel Noirot, Founder, Matrices Analytics LLC | Business and Data Analytics Consulting | Data Analysis | Data Engineering | Business Intelligence in Boulder, Colorado

Daniel Noirot: Founder, Matrices Analytics LLC | Business and Data Analytics Consulting | Data Analysis | Data Engineering | Business Intelligence in Boulder, Colorado