Resume

Brian Vesperman

102 S 1st Street  • Madison, WI 53704 • 608-234-7406

bvesperman@gmail.com

Software\Hardware\Data Engineer

Self motivated engineer with experience from almost every level of solution implementation including hardware design, data collection, integration and analysis.

Professional Experience
Design Mill, INC; DUBUQUE, IAApril 2018 – Present
  • Software/Hardware Engineer implemented IoT solutions for edge to cloud deployments. Utilized a combination of commercially available and custom hardware to monitor environmental and industrial control systems.
  • Facilitated technology stack evaluation and implementation. Architected data flow collection systems to store device telemetry from in house servers and third party data providers.
  • Built several server-less micro-services in AWS Lambda to insert data into our big data telemetry server. These micro-services either acted as a pre-processor between pub-sub services, or pulled data from various third party data sources. These third party data sources could be anything from a REST API, CSV file or other ad-hoc data format.
  • Build analytics from Big Data database utilizing PANDAS, AWS Data Wrangler and Microsoft Power BI.
  • Created various CI/CD deployment pipelines via AWS services.
  • Designed a BLE mesh hardware/software solution installed into 120-277VAC lighting systems that provide a positioning system combined with a telemetry back haul to the cloud. Worked with an overseas manufacturer to mass produce various hardware device form factors.
  • Designed, developed, manufactured and wrote firmware for hardware prototypes. Performed power consumption analysis for battery powered devices.

Notable Projects:

  • Monitored warehouse dock door state with a magnetic reed switch.
  • Interfaced with Kelly Dock leveler controller to monitor leveler and vehicle restraint.
  • Programmed a gateway to interface with a TRANE HVAC controller via BACNet to monitor roof top air conditioners operating values.
  • Interfaced a LoRa transmitter to a weather station sensor via Modbus.
  • Interfaced a LoRa transmitter with a photocell to count boxes of product assembled on a factory conveyor.
  • Designed and built a RS-232 relay that backhauled commands through a BLE mesh. This device interfaced to a Rockwell Automation SLC-500 to read register values from the PLC.
  • Created analytics for a prototype smart pallet that monitored environmental values that relayed the telemetry through a cellular gateway. A 4 day trial was performed that allowed users to monitor the conditions inside the trailer carrying fruit across the country in near real time.

Technologies: LoRa, BLE Mesh, Wirepas, NRF52 chipset, C, Javascript, MQTT, Protobuf, Modbus, BACNet, RS-232, I2C, Cassandra DB, Python, PANDAS, Microsoft Power BI, AWS IoT, AWS, Lambda, AWS CodeBuild, BitBucket, Linux, Autodesk Fusion 360

New Resources Consulting, Milwaukee, WIJanuary 2017 – March 2018
  • Senior Application Developer/Architect for a software application to streamline the management of specialty pharmacy patients including clinical monitoring, claims processing and personalized patient service.
  • Interfaced with third party patient assessments system. Implemented workflows defined by specialty pharmacists.

Technologies: Microsoft Azure, ASP.NET Core, MSSQL, Service Bus, Azure Active Directory, jQuery, Bootstrap

Delta Dental of Wisconsin, Stevens Point, WIAugust 2016 – January 2017
  • DevOps engineer. Created automated software pipelines to take developer code checked into source control repository, compile/build code, create snapshots repositories and deploy snapshots to development, quality assurance and staging environments.
  • Build interfaces to several internal REST web services to customize interactions with source control, test server, and repository server.
  • Build Jenkins plugins with Java.

Technologies: Ansible, Ansible Tower, Linux Server Administration, Groovy, Java, XML and JSON web services, Jenkins, Jelly.

Consulting, Madison, WIJune 2016
  • Prototyped a web accessible relay controller that mitigates the flicker caused by wind turbines casting shadows on residential neighborhoods.
  • A trial area was identified and studied to determine the possible incidents of flicker over a calendar year. With the combination of the calendar of possible flicker and the current light levels, the controller would trigger the relay to minimize the possibility of the flicker effect.

Technologies: Lua, Sqlite, ControlByWeb.com I/O controllers

Pinsoft LLC, Oregon, WI2006—2008, 2010—May 2016
  • General Manager over business operations. Hired consultants, structured product feature path, organized employees, and decided what technologies to employ.
  • Designed, developed and supported desktop and web applications. Created integration points with third party service providers. (EFT, Billing Providers, Claims History Reporting)
  • Designed and implemented internet application that allows insurance agents from mutual insurance companies across Wisconsin to query an online database to get up-to-date information about insurance policies and claims as well as submit policy changes and updates online.
  • Converted flat file database to MSSQL 2005 database. Implemented a company-wide issue tracking system that allows all employees to create and track software bugs and enhancements with all software projects.

Technologies: SSIS, SQL Server 2005, SQL Replication, ETL, C#, JavaScript, TopSpeed, MySQL, Visual Source Safe, MSSQL, Data Warehousing, Clarion, TopSpeed, REST web services

The Warranty Group, Chicago Il2008 – 2010
  • Implemented cross company business financial reporting system. Constructed high data volume, high speed computational and reporting methodologies to meet the needs of the actuary, underwriting, customer operations and financial teams of a company that specializes in underwriting, administration and marketing of warranty and service contracts.

Technologies: C#, MSSQL, Integration Services.

Pinsoft LLC, Oregon, WI2006 – 2008
  • Designed and implemented internet application that allows insurance agents from mutual insurance companies across Wisconsin to query an online database to get up-to-date information about insurance policies and claims as well as submit policy changes and updates online. http://www.pinsoft.net/agentaccess.
  • Converted flat file database to MSSQL 2005 database. This database has greater performance, reliability, data replication and warehousing features that the previous database did not support.
  • Implemented a company-wide issue tracking system that allows all employees to create and track software bugs and enhancements with all software projects.

Technologies: SSIS, SQL Server 2005, SQL Replication, ETL, C#, JavaScript, TopSpeed, MySQL, Visual Source Safe, MSSQL, Data Warehousing

Wisconsin Center for Education Research (WCER),
Wisconsin Madison		2003 – 2008
  • Developed the Web Alignment Tool (WAT), a software tool that implemented Dr. Norman Webb’s computational model of information collection and data analysis for aligning state education standards to standardized tests.  http://wat.wceruw.org
  • The WAT automated a process that took one week to complete one study into a process that now outputs instant reliable results. This reduced the cost of performing the alignment process and has then been implemented in over 30 states including the country of Qatar
  • Developed the DELTA Event Participation Database (DELTA-EPD), a software tool that tracks UW-Madison graduate and post doctorial students and the professional development programs offered by the School of Education. http://delta.wceruw.org
  • Implemented and executed Dr. Rob Meyer’s Value-Added regression model to evaluate the Puerto Rico Math and Science Partnership (AlACiMa).

Technologies: SAS, R, MSSQL, SQL Server 2000/2005, DTS, C#, ETL, ASP.NET, JavaScript, XML

Education
University of Wisconsin Platteville, Platteville, WI, 1998-2002
B.S., Software Engineer, Mathematics Minor

PERSONAL EXPERIENCE
Sector 67 Member, Madison WI2012-Present

Maker-space member.

3D Printer upgrade:

  • Took the components of my Makerbot Thing-o-matic and designed and created a larger volume printer.
  • Designed a new plywood structure in an open source modeling software called OpenSCAD. This allowed me to model the structure and quickly test my design by exporting the plans into a DXF file and cutout with the use of a laser cutter.
  • Designed supplemental parts in OpenSCAD to be 3D printed. Parts include, pulleys, platform alignment mounts, bearing mounts and various other component mounts.
  • Sourced supplemental mechanical parts, nylon belts and electronics.
  • Modified software to work with the larger build volume and alternative machine motion.
  • CNC milled aluminum component on a Tormach CNC machine. The part was designed in  Autodesk Fusion 360.

Integrated Door and Machine RFID authentication system:

  • Designed a Raspberry Pi based machine that unlocks doors and equipment based on members RFID tags.
  • The Raspberry Pi regularly queries the member list from a WordPress site and locally stores the list in a SQLite database on the device.
  • The device waits until the user runs their RFID tag against the RFID reader, if the number is in the approved SQLite list, then the device will trigger a relay to let the user through the door.
  • An alternative device is used on the laser cutter. The device monitors approved users for the laser cutter, as well as tracks how much time the user is using the laser cutter and will update member billing to reflect usage.

CNC Panel routed projects:

  • Constructed a bedside table and chest of drawers from designs from AtFab.co. The designs are basic DXF drawings. I needed to clean up the designs, route them out of the correct thickness of plywood, sand, paint and assemble.
  • Designed magnetic plywood gears of various diameters for a children’s play area for a corn maze. The gears were designed in OpenSCAD via a parametric script. The gears are magnetically attached to a steel wall. Children can rearrange the gear to create a string of wheels that they can play with.