● While consulting for a major hearing technology firm, I researched and recommended the purchase of a third party Audiologist mailing list to perform market research. ● Created a geomap showing audiologists they currently had (using fuzzy logic based on name and address to determine who on the list was already a customer) and the remainder which are opportunities. Employed SQL Server, SSIS and Power BI. ● Created an algorithm to find the closet sales representative based on their territory and the address of audiologists that they currently did not have a contract with. ● Based on the data, we loaded x leads into their CRM system daily.● Tracked the results of the calls. Ensured the sales team was making the calls, tracked the results and reported on the success of the program. ● Created dashboards for a major insurance firm using Power BI and SQL Server to manage operations (enrollment and contracts) and claim trends based on demographics, claim type, geography, spend etc.● While consulting for a major financial institution, designed a data mart for four departments from scratch using SQL Server, SSIS, SSAS, SSRS and virtual machines. ● Created a self-service intuitive MSBI model utilizing VSTO Add-in and clickonce deployment that allows power users to publish dashboards / reports with minimal IT involvement.● Optimized / re-engineered existing processes to convert heavily intensive manual processes into automated scheduled jobs.● Developed a cloud based solution employing Azure ADF (converted from a SQL DB) as the backend and Tableau geomap as the front end for a major real estate company to enable them to visualize their properties (size of circle was the price – shading was how long on the market). Loaded in MLS for comparison and used a different color to identify their properties vs the competition.

Saved $10 million by creating a custom Planning, Forecasting, and Financial Reporting System employing Essbase as the backend and utilizing exiting software / hardware. Used by more than 20,000 employees.Project manager / developer for Workforce Analytics self service module. Allows end users to request HR information in a secure, intuitive and auditable manner. Drastically reduced cycle times and allowed HR employees to perform analytics vs simply pulling reports all dayBig Data self service dashboards to allow end users to visually digest their numbers and drill into the details to understand trends.AP and FA self service inquiry systems. Reduced help desk calls by over 70%. Reduced cycle times, saved 3 FTE and at least $ 1 million in consulting fees / software by creating a Legal eMatter system to manage all litigation, reporting, exceptions and actual auto payment to firms. Autopay uses the LEDES standard in formatting from the firms. eInvoice system transformed a paper AP invoice process to a 100% automated, auditable and efficient process. Reduced cycle times dramatically. Over 1 billion dollars goes through this system today (vendor estimate was $13 million). Workforce Analytics self service module. Allows end users to request HR information in a secure, intuitive and auditable manner. Drastically reduced cycle times and allowed HR employees to perform analytics vs simply pulling reports all day. Relationship management system with scorecards for all loan officers.Management / Leadership100% employee engagement scores for my directs and one downZero turnover for my directs and one down (hires during my tenure)100% work / life balance score1/3 FTE vs our peers yet we had superior systems (Agile)Presented quarterly leadership presentations on employee engagement18 consecutive years of a performance rating of 1 (best rating)

Worked with senior management to insure all internal and external reporting requirements were met. Designed and developed dashboards for executives. Managed the forecasting and planning process for the company

Big data analysis on interest rate riskRe-engineered the monthly process to run and create the interest rate risk executive reports from a two person monthly full time job to effectively a push of a button.

Auction site that was the first company ever acquired by eBay. Second largest auction site next to eBay at the time of the acquisition. Designed and developed initital algorithms for the auctions.