The Application Tracker was built in SharePoint as a stop gap, band-aid approach to the need to track incoming Certification Applications. Since it was my original idea I chose to use SharePoint for several reasons.
First was the need for more than one person to be in the system either entering, editing or viewing data. Second the way the State had SharePoint setup it was auto backed up and if something went wrong there were ways to recover data.
It was also as I learned over the couple years it was in use, expandable for data collection. I could also develop reports and export the data for management to get an idea of what was going on and who had what application at what phase in the process. The downside was that the rest of the team was not as diligent in updating as I was so data cleaning had to happen often.
Overall it was a more reliable tool than using Excel and was the only working database the team had for a week during the new system changeover. Many of the data points recorded in the Application Tracker were incorporated into the new system as well.
The compliance tool is actually a series of tools built to support the Provider Settings Compliance Project at the State of Alaska.
First was a spreadsheet template developed to capture the results of a survey, the results of a in person visit to the site location and ultimately used to drive a mail merge process for a series of compliance notifications. As the project moved forward more things were added to track the incoming and out going data.
The mail merge process included conversion of Word documents to fill in PDFs which resulted in another spreadsheet with a custom macro designed to email the PDF files via Excel and Outlook.
The last portion was a data tracking tool to help with reporting on the status of compliance as the number of providers the team was tracking numbered over 800 and kept climbing as discoveries happened.
As a side note the Settings Compliance Project was triggered by the Habilitation Homes Project.
The Certification Checklist is a tool that started as a humble Word Document by a reviewer as a personal tool to aid in processing applications. During a regulation change it became both a mandatory tool and a far more complex tool built originally by another co-worker who moved on.
It was assigned to my care as it was my main tool for the intake process. Many times I was asked to tweak language, update requirements and even program in new requirements. As a result it became a 400 lines of VB.Net code juggernaut.
When I was in the process of leaving the State I asked the team for a wish list of things they'd like me to try to build before I went. My last two days were spend coding a much simpler variation of the checklist and training other team members on how to modify the code.
The last I heard my training and documentation for how to do it was successful as the tool had already started being updated less than a month after I was gone!
The State has several types of providers who were previously “invisible” to management statistically. We knew they exist but really did not know exactly who they were or where the clients were. Frequently, the clients served were placed in a wrong environment and all sorts of havoc would happen when something went wrong.
This project copied some of the functionality of the current database known as DS3. Using a parent/child relationship the agencies were matched with the homes that were contracted with them which in turn allowed staff to see who was placed in which home and contracted by what agency.
A mail out was required to gather all the data and then a massive data entry project proceeded. Procedures and training was provided as the rest of the staff including management needed to know how to connect homes with providers correctly.
Critical Incident Reports or CIRs for short were a result of a Federal level audit. At the start it was paper incident reports faxed, (later securely e-mailed) to the division and I was the one who had to keep track of them.
My system started out as a single sheet of paper which lasted about 7 reports the first day. I moved quickly to a small spreadsheet and it was soon discovered that it needed to be more robust. Once a month, so it didn't skew data collection, I was asked for reports to be generated for management, senior management and the commissioner, from my data. Only after the reports for the month were done was a column or two or more added for the next month. Quarterly and yearly the reports went to federal oversight.
Through this system reports flowed between Provider Certification, Quality Assurance and Adult Protective Services. We knew where an incident was in the workflow thanks to my system.
By the time the division had built a SharePoint, (based on my spreadsheet and reports) I had logged over 3,500 reports of various incidents. Many of which were minor, but several that saved the life of a vulnerable Alaskan.
My employer lost a big lawsuit in 2011 that could have easily been won. The problem, they had no way to prove a document submitted was the original document and what date it was submitted. Enter the date stamping machine and later on the electronic date stamping in Adobe Pro Date Stamping Processes.
Sue's Tiny Costumes is my oldest site. It started in the days of GeoCities as did my skills with website building. I showcase my doll patterns which are very tiny and complex in some ways yet ultimately beautiful. I have used this site to learn how to setup a manual e-commerce shopping cart, learn WordPress and even graphic design. There are 100 patterns and 2 books published and available for sale on the site.
This site is undergoing metamorphasis. This site started out as a Virtual Assistant Company, morphed to a Wordpress site building company and is now a consulting company. It is also one of many sites I use to work on WordPress skills.
Some might think having a hobby up as a project should know that gardening takes planning and budgeting as well as a lot of work and dirt! This year I added a mini greenhouse and have a lot more potted plants than I've had in the past.
I understand most people would discount sewing as a hobby but my hobby happens to be designing, drafting (lots of math) and construction of historic garments. My daughter's Senior Prom Dress was no exception. Normally I do all this work for smaller models... 5 1/2" to 18" dolls but my daughter is one of my original dolls so making this dress was special and a lot of work!
This site started as a joke and has morphed into a tutorials site which shows off my skills in technical writing.
Craft Pattern Emporium is one of my affiliate sites that I only recently launched. It shows off a variety of sewing and crafting tools. One of the sites will eventually become the home of my next book.
This site is dedicated to my love of geeky books, some music and a lot of "more" items. It's primary focus is affiliate items but the overall theme has settled finally on various fandoms such as Harry Potter, Game of Thrones and Lord of the Rings.
I am a major coffee nut! This site showcases at least a little bit of that love via affiliate items and sharing of things having to do with coffee and even a little tea.