Dennis R. Friedrichsen
dennis@dennisfriedrichsen.com · Eau Claire, WI
Professional Experience
January 2014 – October 2020
Programmer/Analyst Senior
- Redesigned existing data warehouse to reduce data latency from 48 hours to as little as seconds
- Implemented SQL Server AlwaysOn Availability Group environments using Windows Server 2012 and SQL Server 2014
- Prototyped cloud solutions using Azure SQL DB, Azure Storage Accounts, AzureML, Hybrid On-prem/Azure SQL solutions
- Designed, developed, and deployed reports in Power BI to support Executive Leadership and Board of Directors
- Authored C# code using .NET for use in Windows Azure App Services using DDD and OOP Design Patterns
- Implemented support scripts for ETL environment using Powershell
- Experienced with data modeling and relational theory
- Developed ETL in T-SQL
- Backup DBA for Netezza and SQL Server
June 2011 – December 2013
Programmer/Analyst
- Designed and wrote ETL for data coming from various sources in a home-grown data procedure engine
- Maintained existing PL/SQL ETL code for Oracle
- Leveraged Microsoft technologies including SQL Server Data Tools, SSIS and SSRS
- Wrote SQL queries for Oracle, Netezza and Microsoft SQL Server databases
- Programmed Windows Services and console applications in C# using Visual Studio 2008 and 2013
- Used various software tools including WinSQL, TOAD for Oracle, Aginity, Netezza Performance Server, Microsoft SQL Server Management Studio, Microsoft Visual Studio 2008 - 2013, Microsoft Team Foundation Server
July 2008 – August 2010
Software Quality Assurance Engineer
- Updated existing test plans for new features to a mature software product
- Communicated directly with industry professionals regarding improvements to existing applications
- Developed and executed automated test scripts in C#
- Familiar with many different media types including AVCHD, HDV, FLAC, XDCAM, XDCAM-EX, Sony MXF, MP4, MPEG-1, MPEG-2, AVC, and WMV
- Familiar with various optical drive hardware, audio interfaces, video cards and recording devices
- Tested client installs with Windows XP, Windows Vista and Windows 7
- Tested localized products in English, Japanese, German, French, and Spanish
- Product testing team lead for 1.5 years
July 2003 – January 2008
Quality Assurance
- Created test plans and test cases, and executed test scripts for new major development and support patches
- Actively participated in all phases of the development cycle for a complex client-server software model
- Developed and executed automated test scripts using HP/Mercury Interactive's WinRunner
- Wrote code in the M programming language to perform white box testing on an Intersystems Caché database
- Tested client installs on Microsoft Windows 2000, XP and Vista using VMWare Workstation
- Tested server installs on Red Hat Enterprise Linux, Solaris, OpenVMS, and HP-UX operating systems
- Participated in a small group that maintained a company-wide MediaWiki installation
- Analyzed data sets using MS SQL and KB SQL
- Tracked defects in Epic's home-grown tracking and reporting EMC2 system
- Organized testing efforts of large groups ( >30 people)
- Earned company-wide and several division-wide awards for ideas and innovations
- Managed 2 other employees
June 2001 – January 2003
Peer Advisor and Witte Residence Hall Advisor
- Provided academic advising for new and transfer students to the University of Wisconsin - Madison
- Gained critical communication skills by working with a diverse group of students and professional advisors
- Expanded advising services into Witte Residence Hall, and assisted in the creation of its new satellite office
September 2001 - October 2002
Tutor
- Tutored student athletes in a one-on-one and group setting
Education
Special Student: January 2004 - May 2006
Coursework: Electron Pushing Mechanisms, Data Structures, Machine Organization and Programming, Programming Languages and Compilers, Theory and Design of Programming Languages
Cumulative GPA: 3.765/4.000
Honors
Dean’s List, 4 semesters
Awarded Henry Vilas Scholarship
Awarded Department of Chemistry Scholarship
Research Experience
Organosilicon Research Center, UW-Madison
March 2002 - June 2003
Advisor: Dr. Robert West
- Synthesis and characterization of silafluorenes
- Fluorescent materials and multiple bonds to Si
Department of Chemistry, UW-Madison
September 2001 - December 2001
Advisor: Dr. John L. Schrag
- Investigation of properties of Tiron (CAS No: 149-45-1)
- Analysis by potentiometric titration and 23Na NMR
Publications
Toulokhonova IS. Friedrichsen DR. Hill NJ. Muller T. West R. Unusual reaction of 1,1-dilithio-2,3,4,5-tetraphenylsilole with 1,3-dienes yielding spirosilanes and elemental lithium. Angewandte Chemie-International Edition. 45(16):2578-2581, 2006. (abstract)
Committees
General Education Committee, UW-Madison
January 2003 - May 2003
Student Member
- Appointed with recommendation of supervisors at Cross-College Advising Service
- Committee submitted a report to the University Academic Planning Council
- Ensure that every UW-Madison graduate “acquires the essential core of an undergraduate education”
Seminars
"Systematic Software Testing", presented by Claire Lohr. SQE Training. July 2008.
“Getting Things Done”, presented by Ana Maria Gonzalez. The David Allen Company. December 2007.
