Richard
rmemmer@att.net
704-904-6574
3100 Post Oak Blvd #520
Houston, TX 77056
Senior SQL Server / BI Developer
16 years experience W2
0
Recommendations
Average rating
366
Profile views
Summary

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

Experience
Education
Bachelor's in Industrial Management
Purdue University, West Lafayette, IN 1995
Minor: Manufacturing Management
Skills
BI Developer
2022
8
MS Power BI
2022
8
SQL
2022
8
SSIS
2022
8
T-SQL
2022
8
SQL Server
2022
6
Documentation
2020
4
ETL
2022
3
SQL Server Developer
2013
3
SSRS
2020
2
Analysis
2013
1
AngularJS
2020
1
ASP.NET
2020
1
Billing
2020
1
Data Access
2020
1
Data Warehousing
2016
1
DBA
2020
1
IBM API Connect
2020
1
JIRA
2020
1
MVC
2020
1
Tableau
2020
1
Training
2020
1
Triggers
2012
1
Turnover
2020
1
VirtualBox
2020
1
Windows
2020
1
Windows Server
2020
1
Analytics
2016
1
Application Support
0
1
Approach
2012
1
Business Analysis
2009
1
C#
2012
1
Crystal Reports
0
1
CSS
0
1
CUBE
2016
1
Erwin Data Modler
2009
1
Git
0
1
HTML
0
1
Informix
0
1
JavaScript
0
1
MDX
0
1
Microsoft Excel
2016
1
MS SharePoint
2016
1
MS TFS
0
1
MS Visio
2009
1
OLAP
0
1
OLTP
2010
1
Oracle
0
1
PowerShell
0
1
Problem Solving
2016
1
Regulatory Reporting
2014
1
Scala
2010
1
SDLC
2009
1
SSAS
0
1
Stored Procedure
0
1
Teradata
0
1
VB.NET
0
1
XML
2014
1