• Manage entire back end infrastructure for ADP Health Compliance reporting function including Oracle DB development (object creation and maintenance, ETL, user output, developing reporting inputs, etc.).• Responsible for entire end-to-end development of Tableau reporting (requirements gathering from end users, ETL development, Oracle database development, Tableau workbook creation, end-user validation and testing).• Developed standardized ETL processes to accommodate multiple upstream data sources (various database platforms, user-supplied .csv and Excel files, SharePoint, etc.) and various destination DBs to enable rapid build out and easy maintenance.• Provide integration support for data from internal and external sources into the ADP Affordable Care Act Health Compliance product to help companies efficiently manage their ACA compliance and related workforce management.• Analyze, test, manipulate and load .xml and .txt files into the product.• Create and analyze test .xml and .txt files to understand complex data interactions within the product.• Participate in client calls to provide feedback on files received.• Develop client-facing and internal validation tools using Oracle SQL*Plus, command line scripting, .xml output and Excel. Tools used by entire service organization to ensure client compliance with ACA regulations and accuracy of client and employee IRS forms.• Develop and train tools used by Data Integration Services team to improve efficiency across the entire team.• Assist entire organization as Excel subject matter expert on complex spreadsheet questions.

• Created and directed a process to efficiently collect annual budgeting inputs from 28 different sales units and store the inputs in a SQL Server database for easy reporting, analysis and modification.• Identified products with missing or inaccurate standard cost data through query of completed sales orders and the item cost ledger.• Created automated reporting of Year over Year changes in standard cost by product. By relating this to Year over Year changes in quantity sold, enabled easy identification of what drove changes in total cost.• Developed process in DB2 database to validate that completed sales orders were accurately recording to the general ledger. Process enabled detailed reporting of completed sales to SKU and Customer that tied completely to published financials, thus eliminating frequent monthly variances that had persisted for several years. Process was contained within DB2 stored procedures and automated to run each day.• Developed Microsoft SQL Server database used by entire organization for reporting and analysis of Profit and Loss.• Database included "push button" processes for allocation of high-level costs to product and customer.• Database included actuals, budget and forecast with flexibility to grow to as many scenarios as necessary.• Extended database to non-technical users so they could easily provide input for their budget and forecast entries.• Enabled database-centric calculation of change in sales due to volume, price and mix to help identify effectiveness of pricing and promotional policies.• Developed detailed reporting of over the counter returns to identify products with opportunity for quality improvement.

• Manage integrity and availability of data used and produced by Finance in North America.• Created SQL and Excel-based tool used to analyze Period over Period product manufacturing cost changes.• Created SQL and Excel-based price/volume/mix tool to analyze effectiveness of efforts to improve pricing policies. Tool provided data at the customer and SKU level for easy identification of customers with high promotional spend and SKU's which could be retired.• Analyze data input from multiple departments to develop financial forecasting models; report forecast data for North American sector to global headquarters and enable use of data by senior management to support financial discussions and decisions.• Created SQL Server slowly changing dimensions to monitor changes to master data tables in both JD Edwards and FOCUS.• Created SG&A (general and administrative) cost allocation rules to assist with major system conversion, from JD Edwards to SAP.• Developed and maintain, with high degree of integrity, SQL Server database for North American operations that consisted of financial plan, forecasts, and actuals for all revenue and costs.• Enabled significant cost savings through development of database-connected Excel tools for more than 25 cost center managers. Expanded database to encompass GP2 (manufacturing cost variance) and GP3 (cost to serve) including historical versioning of category codes.• Created database to unite data from forecasted and actual financial statements into one common format that facilitated variance analysis.• Managed North American database used to process over $100 million in annual capital spending requests and approval workflows. • Trained coworkers in the use of Excel, Access, and SQL; provided ongoing coaching and responded to questions and problem issues.• Utilized VBA, pivot tables, ODBC queries, array formulas, vlookup, etc. to create and maintain applications and to improve on their efficiency.

Successfully pursued my childhood dream of playing golf professionally after achieving a national amateur ranking of second in the United States. Reached a peak world ranking of 1149. Competed successfully in several PGA and Nationwide Tour events.Key Achievements• Participated as a professional golfer on various tours including the PGA and Nationwide tours.• Developed and maintained a database-driven business website to communicate schedule, results, statistics, news and other relevant information to investors and fans. Used SQL, MySQL, PHP, HTML, CSS and other technologies for web development and maintenance.• Managed my professional golf business including sponsorship funding, financial performance, budgeting, public relations and marketing.• Created and managed a charitable partnership with the Capital Hospice to provide donations as a percentage of my earnings.

Responsible for data needs of Marketing organization at major telecommunications company. Created customer contact, order and billing reporting. Mentored other users on reporting tools including Microsoft Excel, Access and SQL. Provided frequent ad-hoc reporting and analysis using SQL, Microsoft Access and Microsoft Excel.Key Achievements:• Worked with Information Technology team to enable order entry reporting and integrated this data with customer contact, sales and billing. This reporting became the benchmark to evaluate prospect and customer profitability.

Provided critical weekly and monthly reporting on customer install and disconnect volumes to a distribution of over 2,000 users using Microsoft Excel and Microsoft Access. Produced ad hoc reporting to Marketing and Finance.Key Achievements:• Played a key role in the integration of install/disconnect and customer billing data. Streamlined the data extraction process from over 40 hours to 1-2 hours per week using Microsoft Excel and Lotus 1-2-3. This data identified high-value customers for enhanced customer service.• Utilized SQL, Microsoft Excel and Access to query, analyze and report key customer data for the consumer markets division.

• Managed the day-to-day operations of three public and one private golf course.• Responsible for performance versus a budget, employee staffing, customer relations, Point Of Sale development and financial reporting.• Created and maintained Microsoft Excel-based staffing, payroll and budgetary performance reports.• Integrated data from the Point Of Sale system with existing Microsoft Excel-based reports.• Taught golf lessons.