Richard Biography: https://precisionmatters.life/

History of Impact:

• Developed job-quoting software that created a $200,000 annual profit increase via BOM accuracy
• Developed a program that integrated with accounting software to create $25,000 annual cost savings
• Eliminated 80 hours/month of manual processing of online gaming data in the UK
• Found and fixed reporting that was $3 million off (after fixing performance issues and reconciling data)
• Took an SSRS report running from 28 minutes to less than 2. Another from 2 minutes to 5 seconds
• Automated SSIS packages that eliminated 2 hours of daily manual processing
• Created fuzzy-matching program post-merger to create a system of record for prospective customers
• Saved 10 hours/week by automating Excel Pivot Tables via C# Script Task
• The career of critical thinking and problem solving to improve reporting and data to drive better decisions
• Generated $90,000 labor savings with the implementation of a vacuum manipulator as a Process Engineer
• Designed hopper-bin partitions which reduced component staging by 75%

Repeatedly Rehired:

• Bank of America - 10 times at Bank of America for 7 years. Twice in one group and 3+ years in another
• Wells Fargo - 7 times for 5 years
• IGT - 2 times for 2 years

Microsoft Certified Solutions Expert:

• MCP-70-461: Querying Microsoft SQL Server 2012/2014)
• MCP-70-463: Implementing a Data Warehouse / SQL 2012/2014)
• MCP-70-466: Implementing Data Models & Reports / SQL 2012/2014)
• MCP-70-462: DBA/Administering Microsoft SQL Server 2012/2014 Databases

Technical Skills:

• 23 years in IT (17 in SQL Server, 2 in Oracle)
• Advanced T-SQL Stored Procedures & Functions
• Dynamic SQL
• Extensive CTE usage ∙ Window Functions
• Global & Local Temp Tables / Table Variables / Table Value Constructors
• XML/X-Path/X-Query ∙ Jira ∙
• TRY-CATCH ∙ Full-Text Indexing ∙ GIT ∙ TFS ∙ Batch Processing ∙ PowerShell
• Data Warehousing ∙ OLTP ∙ OLAP ∙ Teradata ∙ IBM Informix SSIS (12 years) ∙ SSRS (6 years)
• SSAS ∙ Multidimensional / Tabular ∙ MDX/DAX (2 years and certified) Tableau/PowerBI (2 years)
• 2 years VB.Net ∙ C# automation of Pivot Tables ∙ Creative use of set-based update construct: @variable = column = expression aka “quirky update” (avoiding row-by-row processing—though well-versed in While Loops & Cursors)
• AngularJS ∙ Angular
• HTML ∙ CSS ∙ JavaScript
• ASP.NET MVC ∙ Entity Framework ∙ Web API
• Wide range of DBA tasks ∙ ASP.Net/Classic
• Access ∙ OLE Automation between Access, Word, and Excel ∙ Crystal Reports
• Application support 60+ users ∙ Supported international customers & analysts at IGT