Uploaded File
Richard
rmemmer@att.net
704-904-6574
3100 Post Oak Blvd #520
Houston, TX 77056
Senior SQL Server / BI Developer
14 years experience W2
02/25/2023
0
Recommendations
Average rating
297
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
Senior SQL Server / BI Developer
Banking/Financial
Aug 2021 - present
  • Developed ETL for a migration project
  • Automated data processes with T-SQL 2016 and ingenuity
  • Designed mapping for the new system to link to legacy applications
  • Convinced company to move to Project Deployment model for SSIS (currently setting that up)
  • Assisted analysts in improving their query writing
  • Worked with AWA automation for the process of packages
T-SQL SSIS SQL Server SQL MS Power BI ETL BI Developer
Remove Skill
Senior SQL Server / BI Developer
Healthcare
Jan 2019 - Sep 2020
  • Developed back-end work and reports for multiple projects (Turnover, Medication Reconciliation, Personal Care Services, Home Care Home Base, Arrow Solutions, Billing, etc.)
  • Developed Tableau, SSRS, and PowerBI reports
  • Automated data processes with T-SQL 2016 and ingenuity
  • Created SSIS packages (including automating Hospice billing files via PowerQuery—which required some ingenuity to solve a key issue that often caused the failure). Never happened again.
  • Created JIRA solution to improve my task tracking—customizing it to meet my needs (including integrating its operation with OneNote for more detailed documentation). That took some out-of-the-box thinking to open directly into Office OneNote (as it can’t be done directly). I went around it.
  • Inspired weekly Lunch & Learn to proactively elevate the team’s abilities
  • Developed AngularJS/ASP.NET MVC application for a personal project—like training to assist in web development at work
  • Implemented Data Access Layer using Entity Framework with Web API to connect, retrieve and update the data from SQL Server
  • Set up domain controller using VirtualBox with 5 members running Windows Server 2016 (5th being Core). All of which is to cover every detail in pursuit of 70-462 DBA certification
Windows Server Windows VirtualBox Turnover Training Tableau T-SQL SSRS SSIS SQL Server SQL MVC MS Power BI JIRA Documentation DBA Data Access Billing BI Developer ASP.NET AngularJS IBM API Connect
Remove Skill
Lead Technical Consultant
Professional/Consulting Services
Apr 2018 - Jan 2019
  • Created and maintained Tabular cubes—including solving a major performance problem
  • Leading offshore support team on BI Stack, Power BI, and Power Pivot
  • Wrote extensive documentation in OneNote to consolidate material in a more useful manner
  • Working on OneNote structure to organize support work and develop best practices
  • Completed knowledge transition of projects from prior consulting company
T-SQL SSIS SQL MS Power BI Documentation BI Developer
Remove Skill
SSRS Reports Developer
Professional/Consulting Services
Jan 2018 - Feb 2018
  • Hired for an SSRS 2016 migration
  • Project delayed for 2 months
T-SQL SSRS SSIS MS Power BI BI Developer SQL
Remove Skill
BI Developer
Healthcare
May 2017 - Jul 2017
  • Migrated MDX-based PerformancePoint reports to SSRS
  • Automated SSIS package to produce parameters for data-driven subscriptions
  • Solved performance problem of a report taking over 2 minutes and took it to 4 seconds
T-SQL SSRS SSIS MS Power BI BI Developer SQL
Remove Skill
BI Developer / Senior Consultant
Professional/Consulting Services
May 2016 - Jul 2016
  • Troubleshooting cube, data warehouse, SSIS packages, SSRS reports (including modifying MDX)
  • Doing data warehouse interviews with key personnel at the plant in preparation for phase II design
  • Writing documentation and providing preliminary requirements
  • Spearheading the use of OneNote as a collaboration tool and knowledge base
T-SQL SSRS SSIS SQL Problem Solving MS Power BI Documentation CUBE BI Developer Data Warehousing
Remove Skill
BI Developer
Professional/Consulting Services
Mar 2016 - May 2016
  • Developed new SSRS reports and fixed existing ones (including one that ran in 28 minutes and dropped it to 2)
  • Assisted others in solving problems in SSIS packages
  • Initiated our ongoing discussions to formally establish and refine best practices and standards
  • Uploaded SSRS reports to SharePoint (though we later converted to Report Server)
T-SQL SSRS SSIS SQL MS SharePoint MS Power BI BI Developer
Remove Skill
Analytics Consultant III
Banking/Financial
Nov 2015 - Jan 2016
  • Designed and developed SSIS packages and SSRS reports
  • Automated Excel processes with T-SQL 2016 & ingenuity
  • Designed and developed a new template for package configurations
  • Spearheaded and developed best practices repository in OneNote
  • Mentored junior developer
T-SQL SSRS SSIS SQL MS Power BI Microsoft Excel BI Developer Analytics
Remove Skill
Technology Lead
Professional/Consulting Services
Jul 2015 - Nov 2015
  • Project canceled (Hired as SQL Server Data Warehouse Developer / SSIS / SSRS)
T-SQL SSIS SQL Server SQL MS Power BI Data Warehousing BI Developer
Remove Skill
SQL Server / SSRS Developer / Analyst
Professional/Consulting Services
Jul 2014 - Dec 2014
  • Rewrote ETL procedures—dropping time from 2:37 to less than a second using SQL 2012 features
  • Discovered & resolved incorrect calculations and duplicated staging data
    • Corrected code fixed reporting that was over $3 million off
  • Designed and developed performance improvements to process 60 million rows
  • Developed SSRS report for comparing package version builds across all environments
  • Automated email processing using FOR XML clause to produce output
  • Made modifications to multiple databases and elaborate SSIS packages
  • Migrated SSRS reports and resolved 2005-to-2008 conversion issues
XML T-SQL SSRS SSIS SQL Server SQL MS Power BI ETL BI Developer Regulatory Reporting
Remove Skill
SQL Server Developer
Hospitality and Entertainment
Dec 2012 - Dec 2013
  • Developed ETL and procedures for revenue/survey ranking for Venn analysis of customers
  • Supported database that I helped design and develop in previous contract here
  • Developed enhancements in both SSIS and Procedures
  • Trained support personnel for knowledge transfer
  • Wrote in-depth documentation in OneNote to illustrate ETL architecture and procedures
  • See International Game Technology section below for additional background on development
T-SQL SSIS SQL Server Developer SQL Server SQL MS Power BI ETL Documentation BI Developer Analysis
Remove Skill
SQL Server Developer
Banking/Financial
Oct 2012 - Dec 2012
  • Identified approach to eliminate convoluted straight SQL pulls from source system in SSIS
  • Automated Excel Pivot Tables via C# in SSIS Script Task
  • Performed Lead Developer role in documenting and designing data warehouse architecture
  • Designed strategy for knowledge sharing and implementing best practices
  • Mentored junior developer
T-SQL SSIS SQL Server Developer SQL Server SQL MS Power BI Microsoft Excel Data Warehousing C# BI Developer Approach
Remove Skill
SQL Server Developer
Hospitality and Entertainment
Aug 2011 - Jul 2012
  • Developed invoicing database for online gaming in the United Kingdom
  • Conceived, designed, and developed ETL architecture for handling complex customer files
  • Delicately convinced UK customers to make slight file modifications to allow for automation
    • Customers were under no obligation to assist us, so this was no small feat
  • Interacted with UK finance department to work out specifications
  • Developed procedures, functions, and triggers for ETL and front-end application
  • Co-developed data model, mentored junior developer, and implemented extensive documentation in OneNote along with in-depth code commenting
Triggers T-SQL SSIS SQL Server Developer SQL MS Power BI ETL BI Developer SQL Server Documentation
Remove Skill
SQL Server Developer
Banking/Financial
Oct 2010 - Dec 2010
  • Automated SSIS packages that eliminated 2 hours of daily manual processing
  • Retooled fairly complex workflow to account for failures and out-of-date source files
  • Collaborated with other developers and support personnel for design considerations
  • Troubleshot and resolved mysterious memory issues with package configurations
T-SQL SSIS SQL Server Developer SQL Server SQL MS Power BI BI Developer
Remove Skill
SQL Server Developer
Banking/Financial
Feb 2010 - Jun 2010
  • Developed OLTP database for loan escalation tracking
  • Anticipated customer concerns and took initiative to develop solutions
  • Assisted in the development of data model
  • Created all procedures, functions, triggers, and indexes
  • Created SSIS packages to pull system of record data and automate daily Excel extracts
Triggers T-SQL SSIS SQL Server Developer SQL Server SQL Scala OLTP Microsoft Excel BI Developer MS Power BI
Remove Skill
SQL Server Developer
Banking/Financial
Aug 2008 - Jul 2009
  • Designed and developed procedures to handle high-volume of data (100 million+)
  • Created and maintained fairly complex SSIS packages pulling from multiple source types
  • Implemented SSIS package configurations (Environment Variable and SQL Server)
  • Developed loan portfolio data warehouse in a team environment driven by SDLC
  • Worked with business analysts and others to develop project specifications
  • The maintained data model in Visio Architect (with some experience in Erwin)
  • Conceived, designed, and developed an SSIS solution to compare databases to the data model
T-SQL SSIS SQL Server Developer SQL Server SQL SDLC MS Visio MS Power BI Erwin Data Modler Data Warehousing BI Developer Business Analysis
Remove Skill
Edit Skills
Non-cloudteam Skill
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