February 2018 - Present

Austin, Texas

Senior Data Analytics Consultant

Working with customers to identify opportunities and scenarios where Power BI and Azure Data Services can benefit their business.  Delivering short and long term data analytics projects utilizing strong business, technical, and data modeling skills.

  • Constructed an ETL solution to organize 60,000+ financial operations spanning 26 years into a data warehouse

  • Produced a tabular model for 900 investment funds and 11,000 underlying holdings

  • Wrote complex financial calculations that can be dynamically generated across an array of portfolios, currencies, and time periods

  • Created dashboards and visualizations that illustrate fund performance and identify key areas of investment opportunity

  • Built an ETL/dashboarding solution from manufacturing safety data that generates KPIs for 319 users across 10 locations and 38 departments

June 2016 - February 2018

Austin, Texas

Business Intelligence Engineer

Utilizing Agile methodologies to deliver business intelligence solutions within a legal software product portfolio. Driving strategic alignment among cross-functional teams, and balancing long-term vision with short-term execution.

  • Architected ETL solutions from complex data structures for legal matter management semantic model

  • Designed automation strategies that handle schema customizations created by end users

  • Built comprehensive financial and analytical dashboards and integrated into front-end applications

  • Engineered solutions to manage dynamic row-level security for groups and users of data warehouse

  • Created data integration solutions and performance enhancements for enterprise ETL system


May 2013 - June 2016

Austin, Texas

Business Intelligence Consultant

Working with clients to understand their desired end-state architectures, and performing complex analysis to craft targeted technical strategies. Leading teams to balance workloads, solve technical challenges, and deliver end-to-end business solutions.

  • Produced a tabular model for $376 million in medical claims and eligibility records with 0.8% margin of error

  • Designed budgetary reporting solution that tracks $1.2 billion of annual transactions across 26 departments

  • Architected ETL solution that organizes 400,000+ financial transactions into a 5-tier reporting framework

  • Engineered dashboard that provides comprehensive financial and operational analytics for $220 million business unit

  • Defined top 2% of 3+ million leads by calculating purchase pattern probabilities from $1.2 million historical sales


December 2007 - May 2013

Round Rock, Texas

Metrics & Reporting Advisor

July 2010 - May 2013

Providing actionable business intelligence to the Dell Services Chief Sales Office. Creating enterprise data warehouse solutions that deliver robust financial and operational data analytics.

  • Designed and created dashboard that provides aggregated account performance metrics to 3200+ service leaders

  • Led 5 developers to successfully redesign 13 Crystal Reports in Reporting Services, 2 weeks ahead of schedule

  • Produced report that calculates usage metrics for 893 reports, providing valuable insight into 60,000+ target audience

  • Managed the expedited development of resource utilization report, providing daily billable hours to 4000+ audience

  • Generated executive dashboard that organizes 156 performance metrics into 5 levels of granularity for service leaders

Metrics & Reporting Senior Analyst

July 2008 - July 2010

Supporting business performance reporting for large enterprise accounts in Dell Global Services Operations. Managing regular deployment and delivery of automated reporting solutions to more than 250 accounts.

  • Created an automated reporting solution for 255-slide Account Summary, reducing processing time by 90%

  • Conducted the deployment, launch, and training of data collection portal for 500+ account leaders in 12 countries

  • Maintained 97% on-time delivery rate of 230+ monthly reports for 5 Large Enterprise accounts

  • Reduced average processing time of daily reports by 2 hours while maintaining data integrity

  • Upheld accuracy rate of approximately 94% for reports regularly delivered to customers and internal clients

Reporting Analyst

December 2007 - July 2008

Driving registration and certification within the Dell PartnerDirect Premiere Channel. Organizing program data into reports, projections, and dashboards in order to target leads and generate sales.

  • Created partner registration report that projected monthly and quarterly benchmarks for 12 sales teams

  • Tracked PartnerDirect Certification progress of 450+ Small & Medium Business customers

  • Reduced processing time of daily reports by 80% while maintaining data integrity

  • Delivered weekly sales analysis to 150+ representatives for quarterly sales competitions

  • Maintained data integrity of PartnerDirect application database with 8000+ records


hp_logo.jpg

October 2005 - August 2007

Fairfax, Virginia

Help Desk Analyst

June 2006 - August 2007

Supporting the Joint Automated Booking System for the Department of Justice. Remotely solving issues and providing technical assistance to the 10,000+ users of an international prisoner-tracking software system.

  • Achieved 96% average success rate in solving inbound technical problems for end users

  • Produced weekly report that projected peak help desk call volumes, resulting in 14% increase in technician utilization

  • Increased close rate of after-hours tickets by 50% with creation of remote troubleshooting manual

  • Transformed 4.1 million lines of raw data into itemized chronology of help desk calls, allowing managers to predict peak volume times and adjust schedules

  • Reduced new employee training hours by 25% with creation of overview guides and process flowcharts

Installation Engineer

October 2005 - June 2006

Installing and configuring prisoner intake systems at Department of Justices sites across the country. Training staff on new procedures, retiring legacy systems, and driving end user adoption.

  • Setup hardware and configured software systems at 37 sites in 18 states

  • Conducted training seminars on prisoner intake software, with 98% customer approval rate

  • Repaired workstations and calibrated biometric devices

  • Integrated devices, tested network connectivity, and reimaged hard drives

  • Coordinated hardware shipments and schedules for training staff