Experienced database and application developer, designing applications for several medical research projects and non-profits for 20+ years. Extensive experience in MS Access front end forms design for SQL Server databases, programming in Visual Basic for Applications, T-SQL and SQL, as well as design and maintenance experience in SQL Server databases. Additional experience developing websites for small businesses. Excellent communication and interpersonal skills. Responsive to needs of clients and application users with focus on flexibility and user support.
Optimized and maintained MS Access 2010 split database, designing and developing forms, reports and queries as needed. Initial work included analyzing and repairing MS Access databases that had been modified by various staff members over several years. Combined multiple databases, updated forms to increase usability, created ad hoc reports, imported and exported Excel files manually and modified forms to enable data export to MS Excel spreadsheets and created user manual.
Migrated Access 97 Home Repair database to a SQL Server 2014 database, using SQL Server Migration Assistant, mapped columns and creating views to improve performance of legacy applications. Worked with staff liaison and users to convert and upgrade front end forms, reports and queries.
Designed databases in SQL Server 2005, 2008 and 2008R for Aids research projects located in Agincourt, South Africa: community mobilization, study participants tracking and a school attendance database. In addition, designed MS Access 2007 front end data entry forms, graphs, reports and user manuals. Coordinated with project managers, located in Agincourt and University of North Carolina as well as various liaisons located on-site in South Africa.
As a staff Programmer/Analyst for smoking prevention projects, created SQL Tables and Views via MS Enterprise Manager. Converted existing Access 2.0 forms, reports, tables and queries to Access 2000 for front end of SQL Server 2000 database. Developed MS Access 2003 tracking and survey forms. Developed extensive system of tracking and call history forms that allowed real time data retrieval and entry during counseling sessions, allowing counselor to view wide variety of linked data. Created quality control forms and reports. Developed double entry/verification forms with random sampling, mismatch recording and summary reports as part of a comprehensive QC system for survey data entry. Developed system of Access 2.0 forms to capture endpoint survey data. Developed Work Requests system for prioritizing departmental requests from users. Liaison for database management dept., representing management in weekly meetings with data operations staff. Database support point person for staff of 20.
Collaborated with LWSD web management and club advisors to create new or redesigned club websites for Juanita High School.
Juanita Rebel Booster Club Auction Reservations Chair