Be proactive
Data Analytics
Objective: As a data analytics specialist, I aimed to transform complex learning and development data into actionable insights by creating interactive, data-driven charts. These visualizations highlighted critical metrics, including training qualifications, pass/fail rates, route and bus qualifications, and workforce development trends across all seven Metro bases.
Integrations: I designed and executed a robust data workflow by integrating the Hastus database with existing PowerBI reports, resulting in a dynamic, interactive dashboard. Built in Microsoft PowerBI, this solution provided real-time insights and trend analysis. I managed data updates, developed new analytical reports, and delivered key findings during monthly business review meetings with executives, directors, and managers.
Scope of Data: The analysis spanned all seven bus bases, encompassing over 50 training programs, 250+ bus routes, 100+ bus models, and a workforce of 3,000 trainees.
Goal: My focus was to provide clear, interactive, and intuitive analytical dashboards tailored to the needs of the General Manager, Directors, 2 Section Managers, 12 Superintendents, 37 Chiefs, and 80 trainers, enabling data-informed decision-making.
Key Analytical Outputs:
Training At A Glance: Prioritized insights on the most critical training programs.
Training Class Details: Comprehensive historical data on all training classes completed since 2015.
Route Qualifications: Detailed metrics covering all 250 route qualifications.
Coach Qualifications: In-depth analysis across a range of over 26 bus brands and models.
Icons & ArcGIS
Problem Statement: As an ArcGIS engineer, I was tasked with determining how to effectively map and highlight critical areas along bus routes, ensuring seamless accessibility and integration across platforms like ArcGIS, Artifacts, eLearning, and video production for enhanced user experience.
Proposed Solution: I engineered a geospatial solution by developing a set of intuitive, ADA-compliant icons that provide instant recognition of key route features. These icons were embedded into an interactive ArcGIS mapping system to optimize route navigation and operator training.
Project Execution: The initiative kicked off with the deployment of custom icons during the initial rollout of the ERQ program. Each icon was meticulously designed to represent specific route elements critical for bus operators. Using ArcGIS, I built an interactive map layering these icons onto designated areas along the routes. Operators could interact with the map—clicking an icon to access linked video footage of the bus navigating that segment, alongside Google Street View integration for virtual route reconnaissance. These geospatial markers were also synchronized with training videos filmed along the routes, enhancing operator comprehension and retention through a multi-platform approach.
Tools Utilized: ArcGIS (for geospatial mapping and analysis), Adobe Illustrator (for icon design), Google Maps (for Street View integration), Vimeo (for video hosting), and a Learning Management System (LMS) (for training deployment).
Technical Designs
Objective: As a technical designer, my goal was to design a modern, publication-ready Trolley Map for Seattle, WA, that enhances usability and supports seamless updates. With Metro Transit still operating wired trolleys, this updated map replaces an outdated, hand-drawn pencil version, bringing precision and flexibility to the design.
Tools Utilized: Adobe Illustrator (for vector-based map design) and Acrobat (for final output and review).