Benjamin Van Doren Email and Phone Number

• Designed and maintained automated integration packages (SSIS) utilizing system APIs to move SCADA data into production and economic systems which effectively eliminate the need for manual daily uploads• Developed ETL packages that created and populated additional reporting layers in the EDW including vendor supplied well data, integration error logs, and production based ownership interests to help analysts provide more accurate economic and financial reports• Administer Spotfire and SSRS by supporting user license roles and library management, including the creation and upkeep of information links, subscriptions, and data sources• Using advanced methods in SQL Server Reporting Services (SSRS), created dynamic, interactive reporting tools not available in the source systems including generating Joint Interest Billing invoices, end-user amendable well downtime report, and server administrative reports• Utilized predictive analytic methods within SQL Server Analysis Services (SSAS) to identify and report data discrepancies and vendor software bugs leading to multiple custom hotfix updates• Created an integrated solution to automate the building, delivery, and exporting of Positive Pay files that eliminated the bulk of a manual bank reconciliation process

• Controlled technical ownership of data imports and automation within Performance Management reporting tracking the activity of approximately 3,000 reps• Originated, maintained, and adjusted SQL code to track new metrics, create ad hoc reports, and fulfill discovery requests• Supported end users by documenting, investigating, and resolving issues related to data alignment, missing data, and configuration changes• Developed and maintained professional relationships with external vendors and consultants to enable seamless data imports, data exports, and report delivery• Performed quality assurance reviews and tests as an integral part of User Acceptance Testing by validating technical requirements of new databases and metrics

• Employed advanced data mining, statistics, and predictive modeling to provide insight on Sales & Marketing initiatives• Created a system-focused Sales & Marketing dashboard and presented trends in weekly region-level leadership meetings• Led cross-market effort to analyze bundle product offer strategies and reported findings to corporate decision makers• Developed team members by conducting weekly training sessions in advanced SQL and report automation using SQL Server & SQL Report Builder 3.0• One of six employees chosen for the initial launch of enterprise-wide SAS Grid

• Designed, developed, and deployed automated scorecards to track statistics and key performance indicators at the representative level to aid management in coaching and driving performance• Piloted data collection and managed reporting for the launch of the wireless product segment within the Sales Operations division by rapidly learning OBIEE platform• Assumed the Project Manager role of optimizing and mapping departmental database structure by creating VBA methods to search, discover, and eliminate redundancies leading to an improvement in optimization of 30%• Analyzed compensation data and sales performance to find trends, highlight behavior reinforcement, forecast future payouts, and test viability of payout or bonus• Employ advanced predictive modeling techniques and data mining practices to create ad hoc reports intended to aid upper management in conveying past and future performances of strategy initiatives

• Responsible for a 0.6% increase in overall operational efficiency of affected accounts by originating weekly inventory management reports using stochastic forecasting models• Directly involved in increasing district sales by 17.8% and overall gross margin by 2.1% over an 18 month period by increasing pricing analysis accuracy through the restructuring of templates and processes• Managed multiple national accounts worth approximately $156M in sales by corresponding with clients, internal sales staff, and senior level management• Conducted pricing analysis and set price structures for new and existing accounts through the analysis of income statements and expense profiles