Who We Are
We are a family of programmers. Programming for us is both a career and a hobby. Andy & Megan both work for the University of California, Davis as Lead Application Developers. Alex, is following right along in his parents' footsteps, and already likes typing on a keyboard.
While we both have experience in complete web application design, we each specialize in different aspects. Andy specializes in interface design and dynamic HTML – making web pages feel like full blown applications. Megan specializes in analyzing and implementing business logic and in object design.
Most importantly, we enjoy what we do and we like to have a little fun along the way.
What We Do
We primarily code in the latest version of ASP.NET with C#. However, we also have experience in other languages such as classic ASP, Cold Fusion, Visual Basic, etc. At our workplace we use Microsoft SQL Server 2012 R2 extensively, with limited coding/connections to Oracle 11 databases. At home we use SQL Server Express as our database server.
Our coding is done by hand to ensure it is efficient and runs well - we don't let WYSIWYG applications write our web pages for us.
The Technologies We Use
We are experienced in many technologies, but are obviously more proficient in some than others. Here is a list of most of the technologies we work with most often. If a technology is not listed it means that we don't use it as often, but we may have a lot of experience using it previously (i.e. ColdFusion) - feel free to ask.
This application was designed and implemented for the University of California, Davis, while Andy and Megan worked for the College of Letters & Science Deans’ Office. The application, collects time reporting information for over 5000 employees, routes timesheets to supervisors for review, and then processes the entries according to University policies and procedures. The system also audits all information that was actually submitted to the payroll system to ensure employees were paid correctly and to catch any typing errors that may have been entered. Payroll processors on the Davis campus have said that using this application saves them many, many hours of manual labor, and also ensures that policies are properly adhered to when processing payroll – something that was not occurring before this application was written. The system has since been adopted by the State of California Drug and Alcohol Program office, and is being looked at by other Universities as well.
The initial purpose of this application was simply to help with advising appointments in the College of Letters & Science Undergraduate Education and Advising office, as students would be lined up outside the door for hours and sometimes never get to talk to an advisor. However, in working with the Undergraduate Education and Advising office, the entire way students make advising appointments was re-created and streamlined. Now students log into the system and can make appointments in advance – so no more waiting for hours only to be turned away because no advisor was available. Additionally, since students are booking appointments in advance, the students can accommodate the appointment into their class schedule, and advisors can review the student file in advance, which makes the appointment more productive. This allows more students to be seen in a day. The system balances appointments across all of the counselors available at a given time, as well as automatically adjusts how many days out a student can book an appointment, based on how full the schedule is currently. So, for example, if the system determines that there are not enough open slots available for the three days currently displayed to give students sufficient flexibility in their schedules, it can automatically open advising slots on a fourth day. Several other University of California campuses have expressed interest in purchasing this application.
Processing payroll and personnel actions at the University of California, Davis, is a complex process. The Payroll and Personnel System (PPS) is very old and has a poor user interface, which makes it especially susceptible to mistakes and even simple data entry errors. Since this is a known fact, there are procedures in place to have employees other than those who entered the data review every data entry trying to spot any potential errors. As you can imagine, this process is also very error prone. The PPS Audit application was written to automate the review process. It processes all data entered into PPS each night against a set of configurable rules to check for common, and less common, mistakes – especially those that might affect an employee being paid incorrectly. The application displays a much more user friendly view of the employee information than PPS, and highlights any audit errors that it found. Payroll and personnel processors can then review those audits and determine if a correction needs to be made to the employee record, or if an exception needs to be granted for a unique circumstance. Many payroll and personnel processors have said that the PPS Audit system provides a much nicer interface to view an employee’s record than the actual PPS application.
This application was written so that new rules could be dynamically added in a plug and play manner. Which rules run and what employees a rule applies to are configurable via xml files.
This application was written by Andy & Megan for family and friends. The purpose was to have a place where a person could submit a gift list of items they would like for birthdays and holidays. Friends and relatives could log onto the site and see the lists, and check off the gifts they intended to purchase. However, the person who owned the list could not see what gifts had been marked off. This allowed people to receive gifts they wanted, rather than the dreaded “wool sweater” and also helped prevent duplicate gifts that had to later be returned or exchanged. The application also allows a person to designate a manager for their list so that the manager can add secret gifts for the list owner – that family and friends can see, but the list owner cannot. This allows people to submit gift ideas for a person, without the person knowing about them – thus still allowing surprises when gifts are opened. The system also reminds people about upcoming birthdays and holidays.
This website was written to have a place to easily store, access, and share all of our favorite recipes we have gathered over the years. It also allowed a photo of each recipe, which helps when deciding what to make for dinner :o). Recipes are browsable by title, category, ethnicity, and also searchable. There are also top recipes based on user reviews.
The current logic will solve most sudoku puzzles but it needs a lottle bit more logic (still to be written) to solve the really hard puzzles.