Uploaded File
Richard
rmemmer@att.net
704-904-6574
2530 45th Ave
Little Rock, AR 72202
SQL/BI Developer
22 years experience W2
0
Recommendations
Average rating
153
Profile views
Summary

  • 10+ years SQL Server
  • 6+ years in SSIS
  • 20+ years in IT
  • Application support 60+ users
  • 10+ years in Report Design & Development
  • SSRS / MDX / SSAS / Access / Pivot Tables / BI
  • 2 years of VB.Net on application that I conceived, designed, and developed
  • C# automation of Pivot Tables
  • Took on unfinished projects and completed them all by going straight to the SMEs.
  • Supported international customers & analysts while developing invoice DB at IGT.
  • Meticulous about documentation, code commenting, and preparing materials for presentation.

Experience
BI Developer
Information Technology
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.
  • Advanced T-SQL Stored Procedures & Functions
SSIS BI Developer SSRS Stored Procedure T-SQL
Remove Skill
BI Developer / Sr. Consultant
Information Technology
May 2016 - Jul 2016
Saint Louis, MO
  • Troubleshooting Cube, Data Warehouse, SSIS packages, and SSRS reports (including modifying MDX).
  • Doing data warehouse interviews with key personnel at the plant in preparation for Phase 2 design.
  • Writing documentation and providing preliminary requirements.
  • Spearheading the use of OneNote as a collaboration tool and knowledge base.
Data Warehousing SSIS SSRS BI Developer CUBE Documentation
Remove Skill
BI Developer
Information Technology
Mar 2016 - May 2016
Indianapolis, IN
  • 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).
SSIS SSRS BI Developer MS SharePoint
Remove Skill
Analytics Consultant III
Information Technology
Nov 2015 - Jan 2016
Charlotte, NC
  • Automated Excel processes with T-SQL & ingenuity.
  • Designed and developed SSIS packages and SSRS reports.
  • Designed and developed new template for package configurations.
  • Spearheaded and developed best practices repository in OneNote.
  • Mentored junior developer.
T-SQL SSRS SSIS Analytics
Remove Skill
Technology Lead
Information Technology
Jul 2015 - Nov 2015
Foster City, CA
  • Project canceled (Hired as SQL Server Data Warehouse Developer / SSIS / SSRS) Hannover Re via Insight Global.
SQL Data Warehousing SSIS SQL Server
Remove Skill
SQL Server/SSRS Developer/Analyst
Information Technology
Jul 2014 - Dec 2014
Charlotte, NC
  • Rewrote ETL procedures—dropping time from 2:37 to less than a second using SQL 2012.
  • 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.
SQL XML SQL Server ETL SSIS SSRS Database Design
Remove Skill
SQL Server Developer/Analyst (contract)
Information Technology
Dec 2012 - Dec 2013
Reno, NV
  • 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.
SQL SQL Server ETL SSIS Database Design
Remove Skill
SQL Server Developer/Analyst
Banking/Financial
Oct 2012 - Dec 2012
Charlotte, NC
  • 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.

C# SQL SQL Server SSIS Data Warehousing Database Design Microsoft Excel
Remove Skill
SQL Server Developer/Analyst
Information Technology
Aug 2011 - Jul 2012
Reno, NV
  • Developed invoicing database for online gaming in 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.

SQL SQL Server ETL Triggers Database Design
Remove Skill
SQL Server Developer/Analyst
Banking/Financial
Oct 2010 - Dec 2010
Charlotte, NC
  • 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.
SQL SQL Server SSIS Database Design
Remove Skill
SQL Server Developer/Analyst
Banking/Financial
Feb 2010 - Jun 2010
Charlotte, NC
  • Developed OLTP database for loan escalation tracking.
  • Anticipated customer concerns and took initiative to develop solutions.
  • Assisted in development of data model.
  • Created all procedures, functions, and triggers, and indexes.
  • Created SSIS packages to pull system of record data and automate daily Excel extracts.
SQL SQL Server SSIS Triggers OLTP Microsoft Excel
Remove Skill
SQL Server Developer/Analyst
Banking/Financial
Aug 2008 - Jul 2009
Charlotte, NC
  • 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 team environment driven by SDLC.
  • Worked with business analysts and others to develop project specifications.
  • Maintained data model in Visio Architect (with some experience in Erwin).
  • Conceived, designed, and developed SSIS solution to compare databases to data model.
SQL Business Analysis SQL Server SSIS Data Warehousing Erwin Data Modler Database Design
Remove Skill
Access Developer/Analyst
Banking/Financial
Nov 2007 - Oct 2008
Charlotte, NC
  • Designed and developed Business Intelligence tool for Oracle database.
  • Conceived solution out of conceptual requirements given no specifications.
  • Exceeded expectations by providing scalable UI driving dynamic reporting.
Oracle Business Intelligence UI
Remove Skill
SQL Server/ASP Developer/Analyst
Information Technology
May 2008 - Jul 2008
Catawba, SC
  • Developed and maintained complex T-SQL stored procedures.
  • Modified ASP web pages and Crystal Reports for production reporting.
  • Supported Accounting to troubleshoot SQL procedures, jobs, ETL, and VB code.
SQL Visual Basic Crystal Reports SQL Server ETL T-SQL
Remove Skill
SQL Server/Excel Pivot Table Developer/Analyst
Banking/Financial
Jun 2006 - Jun 2007
Charlotte, NC
  • Created standardized stored procedure model for Pivot Table reporting.
  • Utilized Dynamic SQL to eliminate repetitive queries and hardcoded reporting.
  • Created entirely new report design that users preferred as dept. standard.
  • Automated DTS jobs and reports to require virtually no manual involvement.
SQL Stored Procedure SQL Server Database Design Microsoft Excel
Remove Skill
SQL Server/Oracle/VB.net/Access Developer/Analyst
Banking/Financial
May 2003 - Jun 2006
Charlotte, NC
  • Created entirely new project by redesigning Pipeline OLTP database.
  • Provided dynamic data entry & reporting environment through VBA and SQL.
  • Modeled data sources to consolidate into new Prospect database (marketing utility).
  • Developed SQL Server back-end for both databases (used nationwide and overseas).
  • Designed matching functionality for merging data using SQL Server Full-text engine.
  • Migrated SQL Server database to Oracle post-merger.
  • Wrote stored procedures / functions / cursors to handle external data sources.
  • Automated Trend Analysis and SMART/CIBR Matching reports via Excel OLE.
SQL Stored Procedure SQL Server Oracle Database Design OLTP Microsoft Excel
Remove Skill
Access Developer/Analyst
Education
Mar 2003 - Apr 2003
Rutherford College, NC
  • Developed highly complex inventory control database.
  • Automated import of forecast & inventory Excel files in various country-based formats.
  • Coded interface to control data quality during import and scrubbing process.
  • Structured mapping tables to generate advanced and streamlined reporting capabilities.
Microsoft Excel
Remove Skill
Access Developer/Analyst
Banking/Financial
Sep 2002 - Nov 2002
Charlotte, NC
  • Rehired for high-visibility project to create Performance Analytics reporting tool.
  • Utilized Automation between Access and Excel to create and populate 240 workbooks.
Microsoft Excel
Remove Skill
Lead Access Developer/ Analyst
Banking/Financial
May 2002 - Sep 2002
Charlotte, NC
  • Redesigned existing database to create a more robust and scalable application.
  • Automated multiple processes and databases into a more streamlined operation.
  • Supported end-users, developers, and managers to optimize program design.
  • Created documentation for operation and development.
Database Design Project Management
Remove Skill
Access Developer/Analyst
Banking/Financial
Sep 2001 - Mar 2002
Charlotte, NC
  • Redesigned reporting database that uses Oracle via SQL Pass-Through Queries.
  • Streamlined database by 90% to improve accuracy of data and scalability.
  • Utilized modules to normalize and update data based on structured documentation.
  • Created user-friendly interfaces and standardized application with naming convention.
  • Developed & wrote procedure for processing quarterly marketing data via Access.
SQL Oracle Database Design
Remove Skill
President / Access Developer / Analyst
Information Technology
Jan 2001 - Sep 2001
Charlotte, NC
  • Designed & Developed Job Quoting Software for Manufacturing & Repair facilities.
  • Created unique, complex but user-friendly functionality utilizing VBA, DAO & SQL.
  • Authored Online Help File, also being used for Instructional Booklet.
  • Developed marketing materials and strategy.
  • Customized software for individual companies to meet specific needs.
Database Design
Remove Skill
Access Developer/Analyst
Banking/Financial
Feb 2000 - Jan 2001
Charlotte, NC
  • Redesigned 95% of existing Project Mgmt. database to create a robust application.
  • Designed & Developed complex functionality using extensive VBA, DAO & SQL.
  • Utilized security for securing & manipulating DB, automating tasks & user awareness.
  • Developed Document Management System via OLE Automation & Microsoft Word.
  • Provided end-users with dynamic interfaces for intuitive querying of forms & reports.
  • Created an automated & secure Recognition database for voting on project managers.
  • Wrote Online Help File for Project Management database.
Project Management
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Industrial Management
Purdue University
Certifications
Microsoft Certified Professional MCP-70-461
Skills
SQL
2015
9
Database Design
2014
8
SQL Server
2015
8
Microsoft Excel
2012
4
Oracle
2008
4
SSIS
2017
4
Stored Procedure
2017
4
OLTP
2010
3
ETL
2014
2
Data Warehousing
2016
1
Erwin Data Modler
2009
1
Project Management
2002
1
SSRS
2017
1
Triggers
2012
1
UI
2008
1
Analytics
2016
1
BI Developer
2017
1
Business Analysis
2009
1
Business Intelligence
2008
1
C#
2012
1
Crystal Reports
2008
1
CUBE
2016
1
Documentation
2016
1
MS SharePoint
2016
1
SSAS
0
1
T-SQL
2017
1
Visual Basic
2008
1
XML
2014
1