Rick Stepan Email & Phone Number

o Provide application support skills in coding and maintenance activities.o Tasks require expertise in databases, systems and software analysis, design, development, troubleshooting and integration.o Involved with the most complex and critical systems at the Minnesota Pollution Control Agency (MPCA).

o C#, ASP.Net Core, ASP.Net Legacy, ASP Classic, CGIo MVC, Razor Pages, Web Forms, Web Services, Windows Services o JavaScript, JQuery, REACTJS 18 (NodeJS, NPM, TypeScript) o Json, XML, HTML (5), XSLT, CSS (3), Bootstrap (5)o MS SQL 2019 (Tables, Views, Queries, Stored Procedures, Functions), Entity Framework, Entity Framwwork Core, Linqo SharePoint Online (SPFx, Power Automate, Power Apps)o Crystal reports, SSRS, MS Access, MS Excelo Visual Studio 2022, VS Code o Azure DevOps project management (User Stories, Tasks)o Provide Requirements gathering sessions with subject matter users

Minneapolis, Minnesota, Us

C#, ASP.Net 4.8, ASP.Net 6.0, Full-stack development, SQL, XSLT, HTML, CSS, React

Wayzata, Mn, Us

Bloomington, Mn, Us

Wayzata, Mn, Us

Consultant/Developer for RBA's Digital Workplace practice.Skill set: C#, ASP.Net, JavaScript, CSOM, REST, MVC, MVVM, SQL, SharePoint App Development• Consulting as a C# and SharePoint developer with multiple large clients and projects.• Work independently or with large project groups.• Work directly with clients on many of the projects.• Provided Onsite and Remote development.

St. Paul, Mn, Us

A .NET developer building components and solutions for ASP.net, WSS 3.0 and SharePoint 2007 Server platforms.

Plymouth, Minnesota, Us

• Developed a Sales Projections web-based application for Nonin’s Sales Managers.• Developed Sales tracking charts for Sales Manager using Dundas Charts and the Sales Intranet application.• Converted Nonin’s Vendor s Database application from MS Access 2000 to an ASP.net intranet application utilizing SQL 2000 database.• Developed a Single Sign-On (utilizing Active Directory) intranet application to allow single point of entry into the multiple applications Nonin was creating for their intranet. This application also provided Create, Read, Update Delete privileges to registered users to the intranet.• Converted Nonin’s Calibration Database application from MS Access 2000 to ASP.net intranet application utilizing SQL 2000.

New York, New York, Us

• Developed Home Mortgage’s web based incentive plan system, which tracks hours worked and loans processed for a current month and derives incentive pay calculations for different roles within the enterprise. This system provides a What-If web application for team members, a batch process for month-end incentive pay reports and administrative tools for maintaining the system.• Developed Home Mortgage’s web based loan exchange system, a work management (loan processing work flow) system. This system will allow divisions to share work load among staff at other Divisions that may be under capacity.• Designed, developed and implemented a .Net Intranet web enterprise framework for the Mid-Atlantic Division. The framework is a true web application which alleviates the need for an HTML/web designer to be on staff. The website was designed with complete user control of its UI and functionality. Wells Fargo has plans to roll this application out to other divisions.• Provided training and initial support for roll out of web application.• Provided technical architectural consulting for the Mid-Atlantic Division of Wells Fargo Home Mortgage.

Tools used: CGI, C#, ASP Classic, ASP.Net, Web Forms, SQL Database building, SQL Stored Procedures, XML, XSLT, Crystal Reports, JavaScript, AS400, COBOL o Lead analyst/developer in development of an internet-based portfolio accounting system, an internet-based portfolio analytics reporting system, and an internet-based asset/liability management system. o Provided 24/7 support for accounting, analytics, and asset/liability systems.o Developed release support and help desk support, for a client based, report delivery and viewing application. This allowed for revisions to application code and report files (40+ reports) and monitoring of client application issues. Also, provided conversion of SQL files to mdb files for client-based report delivery.o Created a set of Crystal reports with charts that were deployed via the internet for an analytics system and an asset/liability system. Also, converted 40+ R&R reports to Crystal reports for a portfolio accounting system. Also, provided conversions for R&R dBase files to SQL and Access mdb file formats.o Lead analyst/developer in development of an internet-based loan processing package of applications including vehicle valuations, credit history retrieval and evaluation, flood plain reporting and UCC/tax lien reporting. o Developed a customer maintenance and activity system for a major Twin Cities bank on an AS/400 platform utilizing COBOL/400, SDA, RLU, DDS and CL. Also, provided conversion of Vendor data files into bank’s AS/400 database. Conversion files were provided in Excel fixed length and comma delimited formats.o Engineered a new client account system that integrated new account entry and customer information display from several bank office processing systems for a major regional investment bank.

Tools used: COBOL, CICS, SYNON, MSDOS, AS400, VSAMo Primary support was for a 50,000 line COBOL sub-routine “Figuration” that provided financial calculations to the back-office and trading desks of several major brokerage houses. Provided client support, enhancements and debugging support for this calculation module.o Primary support for a CICS application “WhatIf” that provided what-if analysis and regression testing of the “Figuration” module.o Programmed applications on an AS/400, in a large SYNON project for a major Twin Cities corporation.o Implemented a regression test benchmark VSAM file for testing industry standard security calculations, supplied by the Securities Industry Association, against a securities calculation software package implemented in COBOL and CICS.o Developed a PC/workstation user interface to improve the access to a security calculation routines library purchased from a third-party vendor. The interface was implemented in PC assembler and C languages and involved the development of pull-down menus and window structures in MSDOS.o Conducted a comparison between two versions of the same securities pricing calculations, one set implemented in COBOL, the other in FORTRAN, to analyze data results.o Installed a security calculation system in a major brokerage house. The system was written in COBOL utilizing CICS on-line and VSAM files. Trained application personnel at the brokerage house in the maintenance, troubleshooting and enhancement of this system.o Provided help desk support to clients and internal staff for a security calculation system.

Tools used: COBOL, CICS, batch scripting, DYLACORE DYL260/DYL280, IBM 4381 (DOS MVT/VSE and ADR Datacom/DC on-line), IBM 3090 (DOS/VSE and CICS/SIMDC on-line)Position: Online developero Provided programming of new online data capture screenso Provided coding enhancements and debugging of online applicationso Provided development support in the reengineering of an on-line bond trading system for a banking investment service bureau supporting over 140 banks. o Provided development support in the move of application from IBM 4381 with DOS MVT/VSE platform utilizing ADR Datacom/DC on-line, to IBM 3090 with DOS/VSE platform utilizing CICS and SIMDC for on-line.Position: Batch and report developero Provided programming for new batch processes.o Provided coding enhancements and debugging of batch processes.o Wrote custom report programs for bank clients, utilizing COBOL, DYL280 and DYL260 languages.o Provided 24/7 on-call System supportPosition: computer operatoro Provided run support for clients’ evening batch and report processing.o Provided 24/7 System and client support. o Ran daily data backups and restores of system’s content.

Computer Science

Certiifcation, Windows Sharepoint Services 3.0, Application Development - Mcts