Solutions Architect - Data Analytics
october 2022 - present
Accountable for end-to-end customer Azure experience. Leading technical and economic value discussions with senior customer executives that drive key decisions and implementation. Ownership of technical envisioning, technical design, project scope, and technical oversight.
Practice Manager - Data & Analytics
june 2022 - october 2022
Managing a team of nine consultants from a variety of diverse backgrounds and experiences. Growing a $13m annual sales pipeline by innovating with data-driven solutions. Creating project success with sophisticated staffing and forecasting techniques.
Sold $1.2 million of business by pursuing leads, scoping effort, writing contracts, and closing deals
Established a system to organize 450+ accounts into 8 verticals resulting in strategic sales alignment
Yielded monthly averages of $930k in revenue and 58% gross margin by fostering team culture
Defined new metrics to prioritize sales opportunities that reduced the average days to close by 24%
Created a solution that merged sales data from D365 and legacy system that resulted in 100% accuracy
Managing Consultant / Technical Lead - Data & Analytics
august 2020 - june 2022
Providing technical and business-oriented leadership for a national data and analytics practice of 50+ resources. Scoping, selling, and supervising enterprise-level data engagements for an $11m annual book of business.
Owned pre-sales efforts that resulted in $19m of contract value, 230 wins, and average deal of $86k
Designed and sold a $220k Azure solution to replace the legacy system of a $315m investment firm
Led a 10-person team in a 5-month effort to earn Quisitive an Advanced Specialization in Azure Analytics
Spearheaded analytics initiatives that resulted in dashboards used to manage a $70m book of business
Directed execution of solution that collates security data from 3 disparate systems for $620m company
Senior Lead Consultant / Technical Lead - Data & Analytics
February 2019 - August 2020
Pursuing growth strategies for a regional productivity consulting group, representing $6m in annual revenue. Leading technical pre-sales efforts, mentoring team members, and delivering high-quality data analytics solutions.
Produced an analytics solution that forecasts quarterly spend for a 14-person team with a $2m budget
Delivered work that earned Catapult recognition as a 2019 Power BI Partner of the Year finalist
Authored best practices for billable hours, which was incorporated as policy across the entire company
Built a model in Power BI that delivers hourly pricing forecasts for 5,000+ customers in 8 regions
Created a solution that plots average incident response times for a police department with 17 divisions
Senior Consultant - Data & Analytics
February 2018 - february 2019
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.
Designed a process control model to detects anomalies in dispatch rates for 183 million hardware units
Developed DAX measures that run 26 calculations across 3.2 billion rows in less than 4 seconds
Constructed ETL solution to organize 60,000+ investment transactions across 26 years into a data warehouse
Produced a tabular model for 896 funds and 11,000 holdings, representing a $47 billion pension portfolio
Built an end-to-end solution that generates manufacturing safety KPIs for 300+ users in 38 departments
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
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
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
Metrics & Reporting Analyst
December 2007 - July 2008
Driving registration and certification within the Dell Partner Direct 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 Partner Direct 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 Partner Direct application database with 8000+ records
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