Greater Chicago Area
Engineering organizations generate massive volumes of structured QA/QC data, but almost none of it is used to drive operational decisions. I build intelligence layers on top of engineering review workflows that convert checklist-driven QA/QC processes into measurable performance systems. This is a structured decision architecture that: * Makes the operational impact of review latency and rework measurable * Exposes systemic defect patterns across projects, teams, and design phases * Transforms checklist-driven reviews into structured performance data across quality, accuracy, and throughput * Standardizes fragmented review workflows into a consistent, measurable system across teams and individuals The result is a persistent operational intelligence layer that enables leadership to reduce rework, improve quality, and increase throughput without adding headcount. My work combines event-based data modeling, structured SQL pipelines, and opinionated analytics frameworks to turn QA/QC from a passive checkpoint into an active performance driver. Focused on engineering design environments where structured submissions move through formal, multi-step review workflows.
• Developed SQL queries, performed ETL, and engineered Power BI dashboards, providing actionable insights into cost allocation and highlighting key opportunities for optimizing insurance recovery. • Served as a primary resource for dashboard updates, troubleshooting, and presentations to stakeholders, including executive leadership, in relation to mass tort claims, settlements, dismissals, accounting, and insurance. • Executed full claims cycle for 5 clients including accounting, legal document review for settlements and dismissals, data validation, user support, and report generation. • Led training of team members on the entire claims process and ensured quality control through detailed work reviews. • Automated report generation in Microsoft Access using VBA and SQL. Allowed users to generate 40 dynamic, monthly reports with one click, instead of manually generating each report. • Co-led client transition to KCIC’s Ligado platform. Cleansed, parsed, analyzed, mapped and validated data; partnered with development team to create new fields to meet client’s unique needs; managed client expectations.
• Engineered labor forecasting dashboard in Power BI and Excel with data aggregated from multiple sources. • Led weekly meeting to demo recent updates to the labor forecasting dashboard. • Designed Entity-Relationship Diagram of all data sources and tables for CME’s migration to Google Looker. • Served as a primary resource for portfolio managers reporting needs in Power BI and Excel. • Performed data validation, investigated data discrepancies and partnered with stakeholders to resolve the root cause.
Client Responsibilities • Developed a cloud-based SAAS product that improved decision-making around cloud resource usage and user activity/errors by performing ETL and engineering a dashboard with AWS Cloudtrail, SQL, and QuickSight. • Presented dashboard and ETL process at an AWS User Group event in Chicago. • Contracted by Amazon to support the QuickSight community by resolving data analysis issues, earning recognition as a top 3 contributor. • Designed and deployed over 50 customized Amazon QuickSight dashboards for clients across healthcare, education, and banking industries, which streamlined reporting processes, enhanced decision-making, and drove operational efficiency. Internal Responsibilities • Wrote technical documentation on various product offerings and designed marketing materials. • Enhanced the West Loop Strategy website using webflow.
Client Responsibilities: • Orchestrated urgent COVID-19 response efforts by swiftly implementing enhanced reporting processes for essential medical supplies and capacities and delivering key software upgrades to support frontline healthcare operations. • Diagnosed and debugged critical software issues for two healthcare systems and resolved the root cause of gaps in functionality and existing issues in the software. • Lead education sessions on Epic data structures, application build/functionality, troubleshooting tools, building technical reports, creating searches, and changes to the software to improve client IT teams’ efficiency. • Partnered with R&D to deliver code fixes and feature enhancements. • Coordinated and led client IT/Operations teams in preparing for quarterly software upgrades, implementing new features, and integrating third-party vendor solutions. • Developed queries and reports of healthcare patient data, helping streamline client processes and prioritizing software fixes. • Reduced issue and project resolution timelines by introducing a weekly report of all software issues, enhancement/upgrade projects, and third-party integrations to be certain everything was documented and resolved. Internal Responsibilities: • Educated and provided support to Epic engineers on dental application. • Co-produced a five-year development roadmap for Epic’s dental application. • Designed and programmed (using HTML and CSS) an internal website containing information on dental application functionality, troubleshooting guidance, and resources. • Served as secondary contact for vendor/customer relations and integration support for dental imaging.