Michael J. Cavanaugh
Mesa, AZ 85202
***************@*****.***
PROFESSIONAL EXPERIENCE:
BrindleApps, LLC - Present
Along with custom website and software development, I am presently building an affiliate/freelance marketing system and training system. Recently certified Developer for HTML5, and CSS. Presently finishing certifications for both JavaScript and React.
Arizona Department of Agriculture June 2016 – November 2019
Senior Lead Applications Developer
I was brought in as a classic ASP pro shortly after the Arizona Weights and Measures Division was folded into the Arizona Department of Agriculture.
I was presented with a 2003/IIS 6 Classic asp system that contained over 240 Crystal Reports within it.
This system manages licenses for such things as all fuel dispensers and scales in the entire state of Arizona.
To upsize this website to a modern web server for security purposes – and state policy, I re-wrote all reports in SSRS from Crystal Reports.
Much of this project consisted of converting VBScript SQL to T-SQL.
These were complex reports, some of them containing scientific formulas from our metrology laboratory.
I did all Business Analysis functions on this system, as there was no documentation because it was initially developed by a single vendor.
As a major part of this effort – I created a go-between C#/MVC site using Bootstrap, JQuery JavaScript, CSS, HTML5 and Ajax to manage access to the new SSRS reports server as well as portions of a new modern UI.
This was necessary, because the classic asp site (750 pages) was initially developed 20 years ago, with very little security, and a dated UI.
This also provided a platform to upsize the Classic ASP site to a modern MVC site (piece at a time).
I also re-wrote a FoxPro invoice printing system, and converted the FoxPro based invoices into SSRS Reports/PDFs.
Invoices and licenses can now be sent out via email/PDF.
My project had ended when it was outsourced for $9 million contract as part of the state’s cloud initiative.
Since I already re-wrote 1/4th of the system (the entire reporting system), I estimate my actual value I provided was worth approximately 2 million dollars.
I also got them ready to be moved to Azure (by moving the application to a 2008 or later server).
I am also a state vendor.
SP Express (With Robert Half), Phoenix AZ July 2015 – Oct 2015
.Net Developer
Working in an ecommerce/fulfillment/fulfillment environment that presently utilizes FTP and .csv files to communicate with customers.
In the time I was there, I have created a new, and first working example of a RESTful API utilizing WEB API 2/HTTP as the tool.
Additionally, I created a separate client/testing website in MVC5.
My efforts have put the company in a much better strategic position based on the new software I have created for them (with verbal instructions only).
This is because they have already been provided a working example of an API that hits both their Oracle and SQL databases.
The API was created using MS WEB API 2.
The client software/website I also wrote in C#/MVC5/EF6/T-SQL/Oracle/PL-SQL) allows internal and external users to select the API endpoint/URI they would like to access.
The information is returned by the endpoint to the calling client in the form of a JSON object containing one or more records.
The client application (utilizing an encrypted secret token/AES encryption) then displays the information in a DataTables grid so that testers and users can review the accuracy of the AJAX JSON results from the API controllers calls.
I have used JavaScript, jQuery, and Bootstrap extensively on both websites that I have created.
Salt River Project (with Envision), AZ Jan 2015 – April 2015
.Net Developer
Utilizing C#/VS2013/SQL Server, Enhanced a new Webforms application called GenData, in support of SRP's power generation services.
Tools used were VS2013/C#, SSRS and SQL Server.
Each task assigned was completed before the deadline, and all code was peer reviewed.
One of the tasks I performed was to create a “rolling-lockout” feature for the entire Gen-Data application.
This prevented users from editing data older than 2 months in all areas of the application.
Another was to set up their first “ReportViewer” based SSRS report within the Gen-Data application.
SRP/Power Generation Services can now create site-hosted SSRS reports based on the “First” working example I provided.
Finally, I wrote software that filters grid-view columns according to data that does or does not exist in the database.
For the “gridview” filter columns, I utilized JavaScript to implement a scrollbar at the top of all panels. Lastly, I performed a variety of new enhancements and fixes as assigned via TFS.
Also, a simple form of Agile was utilized (i.e. a backlog, TFS to manage each task, and approximate sprints of 2-3 weeks for each major task/mini-project).
U-Haul Corporation, Phoenix, AZ Feb 2014 – Dec 2014
Software Developer – Web Team
Performed new software development, as well as system maintenance tasks as assigned for C#/MVC applications utilizing the latest tools, patterns and standards.
Databases were SQL Server and Oracle 10.
Worked solely on rewriting an application called Corporate Records from VB.NET to MVC/C#.
During this effort, I utilized JavaScript and AJAX extensively.
The application contains over 60 views (and was put together in about 4-5 months).
The application utilizes a combination of existing stored procedures imported into Entity Framework for the legacy database, as well as additional LINQ queries added to the new MVC application.
In addition, information is retrieved via WCF services.
This new software was successfully moved to the corporate beta site.
I also enhanced an application called Chargebacks - which manages credit card chargebacks.
Additionally, I wrote a new Personnel Action monitoring system in MVC/C# utilizing LINQ to SQL only (and no Stored Procedures).
The application reports the status of HR information from multiple data sources, as well as who accessed those sources.
The Arizona Lottery, Phoenix, AZ July 2012 – Feb 2014
LAN Manager and Application Developer
Directly manage a four-person team - a PC Tech, two Network Techs, and Web Developer.
Responsible for enhancing and maintaining ASP.NET applications.
With the help of a consultant I managed, we ported three websites over to .NET 4 from .NET
and Classic ASP 3.0.
I was directly responsible for the support and 24/7 operation of Arizonalottery.com
Additionally, I was responsible for maintaining C++ code that feeds the lottery websites.
Arizona Department of Transportation (ADOT), Phoenix, AZ July 2011 – March 2012
Software Developer
Responsible for taking over the maintenance of an application called Consultant invoicing. This application was written in ASP.NET/C#, with many reports created in SSRS.
It’s a mission critical application used to pay all contractors who work on our highway system for the entire state of Arizona.
Tools were ASP.NET, Classic ASP 3.0, C#, JavaScript, TFS, VS2008, SQL and SSRS.
Office of the Arizona Attorney General, Phoenix, AZ March 2011 – June 2011
Information Technology Specialist III
Performed database maintenance as well as help assist attorneys and law enforcement when they are having issues with their computers, as well as the sensitive information on them.
Duties also involved shooting and editing videos utilizing the MAC and Final Cut software.
In addition, performed various sensitive/confidential IT tasks in support of the office for executive management - the Attorney General and Chief of Staff.
Arizona Department of Health Services, Phoenix, AZ Dec 2010 – March 2011
Software Developer Info Technology Specialist III
Worked to bring the MEDSIS (disease management software) system in-house from an outside contractor/vendor.
Tools were ASP.NET VS2010, C#, and SQL Server 2005.
Duties involved reverse-engineering the existing system, as well as preparing to do major system maintenance (i.e. cleaning up data tables containing duplicates, etc.).
Arizona Department of Education, Phoenix, AZ Jan 2006 – Dec 2010
Lead Software Developer
Team lead for three developers who worked on the SAIS system.
Solely developed and delivered Structured English Immersion (SEI) Budget software (using C#, ASP.NET, JavaScript, and SQL 2005) for use by all the school districts in the state. The software gathers budget requests from Arizona school districts and accounted for more than $40 million that was submitted.
This project was an emergency which was produced working days, nights and weekends for two months - saving the State the potential to be fined $1-2 Million per day.
The software was delivered on time as promised.
This effort saved the state approximately $300 million dollars due to a lawsuit that was won in the 9th Circuit court – due to the software I created, which proved the truth – with regards to actual school district budgets (for ELL learners).
Created the State Tutor Fund Software using C#, and ASP. Net1.1. Presently being used by the State for teachers to track hours and submit billing for students that need tutoring – specifically, those who need help passing the AIMS test.
Responsible for enhancing the Student Accountability Information System, as well as fixing tickets/bugs related to this system.
This is the largest system in the Department of Education and gathers student attendance, as well as other information for the purpose of funding all the schools in AZ.
This system was built using heavy VB6 Com+ (over 100 components - some ASP.NET as well), utilizing SQL 7000/2005 and MSMQ.
Multiple technologies are mixed in (such as generated XML documents with business rules implemented using XSL).
The web front ends consist of Classic ASP 3.0 with JavaScript for validation, along with some .NET 1.1 and 2 portals/sites.
U-Haul Corporation, Phoenix, AZ Dec 2001 – Sep 2005
Programmer/Analyst
Re-wrote the Accounts payable front end in ASP.NET 1.1.
Received two letters of recommendation from U-Haul for my 5 years of work there.
Created Phone Management Software (TOPS – Telephone Order Processing System).
Tools used to build this were Visual Basic 6.0, ASP, JavaScript, SQL, and SOAP/Web Services.
Also (in 6 months) developed an accounts payable system in ASP.NET C# that interfaces with an Oracle database (using OLEDB).
Data was retrieved and saved utilizing web services.
Utilized nightly batch/EDI to gather information (via thousands of text files) from distributed PC clients into various corporate mainframes and web servers.
EDUCATION:
Glendale Community College, 2005
Associate of Applied Science, Computer Information Systems