Professional Projects
In my professional career, I’ve tackled complex data challenges using tools like Python, SQL, and Power BI to deliver actionable insights and drive efficiency. These projects demonstrate my ability to solve real-world problems with innovative solutions, from automating data workflows to identifying and improving pain points. While respecting confidentiality, this section provides an overview of the methodologies, tools, and insights I’ve brought with my work.
In my professional career, I’ve tackled complex data challenges using tools like Python, SQL, and Power BI to deliver actionable insights and drive efficiency. These projects demonstrate my ability to solve real-world problems with innovative solutions, from automating data workflows to identifying and improving pain points. While respecting confidentiality, this section provides an overview of the methodologies, tools, and insights I’ve brought with my work.
Confidence Scoring for Location Assignments
Confidence Scoring for Location Assignments
Problem: Our company's system assigned locations where an asset would stop but it often resulted in assigning the incorrect location.
Problem: Our company's system assigned locations where an asset would stop but it often resulted in assigning the incorrect location.
Solution: I developed a Python system that cross-referenced raw data, our location data, and the system's assignment to produce clean movement data and assign a confidence score to each location. This system quantified the system's accuracy and highlighted areas for improvement.
Solution: I developed a Python system that cross-referenced raw data, our location data, and the system's assignment to produce clean movement data and assign a confidence score to each location. This system quantified the system's accuracy and highlighted areas for improvement.
Impact: Provided leadership with measurable insights into the reliability of the assignment system, enabling targeted improvements in operational processes.
Impact: Provided leadership with measurable insights into the reliability of the assignment system, enabling targeted improvements in operational processes.
Geospatial Analysis of Asset Movements
Geospatial Analysis of Asset Movements
Problem: Tracking asset movements within specific geographical ranges was challenging due to the large volume of raw GPS data and the lack of tools for regional filtering.
Problem: Tracking asset movements within specific geographical ranges was challenging due to the large volume of raw GPS data and the lack of tools for regional filtering.
Solution: I queried asset movement data from the company's relational database using SQL, leveraging latitude and longitude information to identify movements within defined areas, such as a 150-mile radius of Fresno, CA. After cleaning the data, I visualized the results in Power BI using advanced mapping tools like ArcGIS.
Solution: I queried asset movement data from the company's relational database using SQL, leveraging latitude and longitude information to identify movements within defined areas, such as a 150-mile radius of Fresno, CA. After cleaning the data, I visualized the results in Power BI using advanced mapping tools like ArcGIS.
Impact: Provided actionable insights into asset usage and movement patterns, enabling more informed operational decisions.
Impact: Provided actionable insights into asset usage and movement patterns, enabling more informed operational decisions.
Automation of Asset Tracking Reports
Automation of Asset Tracking Reports
Problem: Generating asset tracking reports required extensive manual cleanup of thousands of Excel rows, resulting in a time-consuming process.
Problem: Generating asset tracking reports required extensive manual cleanup of thousands of Excel rows, resulting in a time-consuming process.
Solution: I developed Python scripts to automate data cleaning, transforming a time-intensive process into a one-day workflow. The scripts identified and resolved inconsistencies in raw data, leaving only minor adjustments for final review.
Solution: I developed Python scripts to automate data cleaning, transforming a time-intensive process into a one-day workflow. The scripts identified and resolved inconsistencies in raw data, leaving only minor adjustments for final review.
Impact: Drastically reduced the time and effort required to produce asset tracking reports, increasing efficiency and accuracy while freeing up resources for more strategic tasks.
Impact: Drastically reduced the time and effort required to produce asset tracking reports, increasing efficiency and accuracy while freeing up resources for more strategic tasks.