Ryan Davidson
Summary
Data Professional specializing in logistics and financial analysis. Expertise in SQL, Power BI/Tableau, and Python to drive significant cost savings and operational efficiencies.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Condata
03.2022 - Current
- Wrote SQL stored procedures in production environment to audit parcel records, recovering >$500,000 in client spend
- Created pipelines with Azure Data Factory, executed transformation processes with Data Bricks using Pyspark
- Inserted batch data into data warehouse with custom Python ETL scripts using Sqlalchemy and Pandas from various data sources
- Implemented CI/CD practices in agile environment
- Updated continuously changing dimensions within the data warehouse environment, ensuring data accuracy
- Created star schema data models in Power BI to audit Kinancial invoices resulting in >$100,000 refunded to client
- Spearheaded data cleansing of 2 million records via Python (Pandas & PyPDF2), ensuring precise cost auditing.
Senior Business Analyst
Transportation Insight
08.2020 - 03.2022
- Innovated SQL strategies (nested CTE's & window functions) for analyzing shipment density, improving customer satisfaction, and saving over $100,000
- Automated parcel shipment rating comparisons via SQL, uncovering $300,000+ in client savings
- Managed Power BI dashboards and wrote DAX statements, providing data-driven insights to enhance decision-making processes
- Oversaw ETL processes using SQL and Dynamics 365 to guarantee precise cost code reports.
Data Analyst
SpaceX
04.2018 - 01.2020
- Created a $1.1M emergency supply chain from 0-1300 parts, in order to provide 93% on-time delivery for rocket engine test stands
- Saved $10K in lost opportunity costs (re-designing, materials, work order and labor time) by utilizing AUTOCAD (Computer Aided Design/3D modeling) to categorize rocket stand parts not in the inventory directory
- Managed 1,300 parts that kept all rocket stands testing
- Consisted of >3,000 SKU's, $1.1-1.3 M valuation, and in stock health metric of 93%
- Wrote SQL queries that identifies current location, inventory level, safety stock, minimum order quantity, etc.
Education
B.S. in Supply & Logistics Management -
Portland State University
01.2017
Skills
- Data Visualization & Analysis
- SQL
- Power BI (DAX)
- Tableau
- Programming & Scripting
- Python
- Powershell
- Data Warehousing
- Snowflake
- Azure
- ETL Tools
- ETL
- Dynamics 365
- Data Factory
- PySpark
Certification
Microsoft Certified Azure Data Engineer (DP-203), 2024
Timeline
Senior Data Analyst
Condata
03.2022 - Current
Senior Business Analyst
Transportation Insight
08.2020 - 03.2022
Data Analyst
SpaceX
04.2018 - 01.2020
B.S. in Supply & Logistics Management -
Portland State University
Similar Profiles
HILDA OLIVAREZHILDA OLIVAREZ
International Freight Post Auditor at Condata GlobalInternational Freight Post Auditor at Condata Global
Jonathon NanceJonathon Nance
Senior Data Analyst /Lead Data Analyst at Two Kings CasinoSenior Data Analyst /Lead Data Analyst at Two Kings Casino
Gopala ChandraGopala Chandra
Senior Consultant/Senior Data Analyst/Data Science Specialist at Gopala RSenior Consultant/Senior Data Analyst/Data Science Specialist at Gopala R
Sitoshna BhoiSitoshna Bhoi
Senior QA Analyst/Senior Data Analyst at Tata Consultancy ServicesSenior QA Analyst/Senior Data Analyst at Tata Consultancy Services
Kailen ShinmotoKailen Shinmoto
Senior Data Analyst/Data Analyst at PearlX InfrastructureSenior Data Analyst/Data Analyst at PearlX Infrastructure