Dean Cox Email & Phone Number

Kirkland, Wa, Us

Los Angeles, Ca, Us

Data Analytics TeamResponsibilities:ad-hoc analyses for executives, data visualizations and statistical analysis in Sigma, DBT model building, extracting and cleansing data in Snowflake, gathering requirements by developing relationships with Stakeholders, and mentoring fellow analysts- Led and presented post-COVID analyses to executives, providing pricing insights for our customers utilizing advanced SQL like CTEs and Window functions and data storytelling in Sigma, resulting in a 15% increase in payments revenue- Became the data domain expert by collaborating with 12 managers on monthly business reviews, resulting in 50+ new metrics to track objectives that align with OKRs- Constructed an executive dashboard in Sigma, reducing the time it took to update the Board from 2 hours to 15 minutes by collaborating with data scientists- Formalized data governance in Atlan by defining glossary items attached to Snowflake, Sigma, and DBT metadata, creating a centralized location for data definitions and lineage- Mentored Product Analysts to improve their SQL and data storytelling skills, leading to stronger data consistency and skill growth across departments

Seattle, Washington, Us

Sales TeamResponsibilities:Dashboards and Visualizations in PowerBI, ad-hoc reports and dashboards in Salesforce, gathering requirements from stakeholders, data education for sales team, ETL pipeline from Redshift through Workato/Databricks into Salesforce, data enrichment by connecting to external APIs, user solution-building in Google Sheets Achievements- Created a "Prospect Dashboard" for our sales team using Power BI, resulting in over 20% higher revenue per agent onboarded.- Reduced data processing time by over 50% by designing and implementing data pipelines through ETL from Databricks into Salesforce using Spark SQL and Python.- Developed over 20 automated custom reports by leveraging SQL and Salesforce data.- Engineered a user-friendly Zendesk de-duplication workflow by creating webhooks via Google Sheets scripts and communicating with Zendesk API.- Developed strong skills in SQL, data modeling, ETL, and data management through work experience.

Hedehusene, Dk

Operations TeamResponsibilities:Automating daily/weekly reports through advanced excel/VBA and securing data through governance. Performing root cause analysis on inventory. ad-hoc analysis requests from top client and developing relationshipsAchievements:- Planned and maintained an "Inventory Variance" dashboard which reduced inventory discrepancies from 8% to 1%, saving 15 hours per week, through root cause analysis.- Acted as the lead for ad-hoc analytic insights for a Fortune 100 client and developed relationships with their managers and analysts, delivering timely communications and accurate reporting.- Instituted a KPI data model to track employee productivity, resulting in a 24% decrease in time between loading/unloading docks, by utilizing macros and VBA in excel.- My experience in inventory management, analytics, and data modeling has allowed me to make valuable contributions to the companies I have worked for

Humble, Tx, Us

Finance TeamResponsibilitiesaccounts receivable, forensic accounting, credit analysis for debtors, training sales/operations on Salesforce, weekly reports for CFO/CEO on bad debt and resolutionsAchievements- Researched customer profiles and found ways to reduce bad debt by over 12%. - Presented my findings to the CFO and helped implement new protocols, resulting in a major improvement for the company.- Took charge of the Accounts Receivable team and tackled a redundancy issue by cutting over 50% of the time spent posting daily EDI invoices - all while handling invoices worth $250K+. - Coordinated training for new software transitions, including Salesforce.

Humble, Tx, Us

Bachelor Of Business Administration - Bba, Marketing

Data Analysis

Salesforce Certified Administrator, Https://Trailblazer.Me/Id/Decox1

Elite Diplome In Culinary Arts Cuisine