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
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
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
October 2005 - August 2007
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
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