REFORM Home Page Link

About  |  Services  |  Contact  |  HOME  |  Work Samples  |  Request a Quote  |  Services Price List

 

Shonda H.
          Senior Developer/Consultant, Microsoft Certified Access Specialist

CERTIFICATIONS/LICENSES

Microsoft Office Certified Access Specialist
Real Estate Licensee
Certified Interior Decorator

TECHNICAL SKILLS

Database/Application Systems:  VB/VBA, MS Access (Access 2.0, Access 97, Access 2000, Access XP 2002, Access 2003)
Database/Servers:  SQL/SQL Server and ODBC, LIMS, Paradox, dBase
Forms/Reports:  MS Access, Crystal Reports
Web Design/Marketing Tools:  Front Page, Dreamweaver, Flash, Constant Contact E-mail Marketing
Spreadsheet Software:  Excel and Lotus Notes
Programming: ASP, VBScript, JavaScript, CGI/Perl, Visual Basic, HTML, FORTRAN, Pascal, C, COBOL, Assembly Languages
Financial/Management Software:  Peoplesoft, PeachTree Accounting, Quicken/Quickbooks, ACT II
Form Application Software: IFL (FormFlow)
Other Software:  MS Word, MS PowerPoint, MS Publisher, Adobe Photoshop, PowerPoint, PageMaker
Typing Speed:  55+WPM 

EDUCATION

1993   University of Houston, Central Campus            Houston, TX      
Bachelor of Science, Mathematics
Computer Science Minor

1996   University of Houston, Central Campus            Houston, TX
Master of Science, Information Systems
18 of 36 hours completed

SOLUTIONS and WEBSITES

www.scopeitinspections.com 
www.rusticoakpta.org
www.houston-necac.org

www.pearland-classifieds.com  (linux and active web software)

Database-Driven Website:
http://www.garagesaleshopper.com

Property Inspection Report System 
http://www.reformoffice.com/screenview.html

WORK HISTORY

Most Recent and Current Clients  (See References Below.)

May 2004 – Present                   ERA/The Michael Group 
E-mail Marketing, Forms/Graphic Design, Data Storage and Various Administrative Duties for MLS

Jan 2005 – Present                    Exxon Mobil
Report Writing and System Re-design for Content and Contract Management Database.  Calculate commitment amounts and track paid contracts.  Import data from dBase.

Feb 2005 – Present                    Spinnaker Systems, LLC
Report Writing and Security Implementation.  Develop expert-level queries for reports.


 

Nov 2003 - May 2004                  Strategic Mortgage Solutions, Inc.                  Houston, TX  

Contract MS Access Developer/Analyst

Maintain Due Diligence software in Windows XP and Network Environment.  Refined software by improving program flow and usability.  Provided on-site support for server during Due Diligence review projects.  Designed form to export XML documents for third-party software.

 

Nov 2002 - Jan 2003                   Strategic Professional Service, Inc.                 Houston, TX

Contract MS Access Programmer/Developer

New Process and System Design.  Imported Data from PeachTree Complete Accounting Database to Access in order to query information and to present in report formats.  Queried data and exported to excel for storage in client's database.

 

May 2000 - Jan 2002                  Software & Solutions for Enron                       La Porte, TX

Contract MS Access Programmer/Developer - Software and Solutions/Meador Staffing

System Redesign.  Conversion of Lotus and Excel Spreadsheets to a fully automated database system for generating daily reports.  Lotus spreadsheets/data imported from SQL Server and other proprietary systems through ODBC Data Source and stored to Access tables.  Created a new input and processing forms using Access supported by VBA.

 

Dec 1999 - May 2000                 Xerox Asset Management                                Houston, TX

Contract MS Access Programmer/Developer - Ajilon

Maintain and Refine Billing Software.  Immediately assumed responsibility as primary developer/analyst of billing software for 30 different accounts.

Billing Software Support.  Responsible for data validation processes, analyzing billing records and transporting to appropriate SQL tables for billing in PeopleSoft system. 

Billing Algorithm Development.  Develop queries and modules for new accounts.  Determine and develop necessary data validation for new accounts.

 

Jun 1998 - Sep 1999                  Strategic Professional Service, Inc.                 Houston, TX

Contract MS Access Programmer/Developer   

Maintained Due Diligence software on Windows NT server.  Refined software for user community.  Provided on-site support for server during due diligence review projects.

Completed conversion of MS Access version of Due Diligence software to Visual Basic.  Document and fix code not previously documented. 

Created Quality Control program for mortgage loan review process.  Created event-triggered modules to assign deficiency codes for tracking the loan review process of underwriters, loan officers and loan processors through reports.

 

1998                                         Lone Star Inspections, Inc.                              Houston, TX

Contract MS Access Programmer/Developer   

Created Property Inspection Report System.  The System allows the inspector to input inspection data and output into format required by the Texas Real Estate Commission for licensed Texas Inspectors. I also created a process for transferring individual reports between company sites through use of e-mail.  The system tracks orders and allows them to be assigned to appropriate inspectors.  The most important task was to create a module to accept varying comment data sizes and to reformat any amount of data that the inspector supplied to the inspection form REI7A-0.  This was accomplished by resizing of comment areas and perform page renumbering as necessary. (Entire software developed using MS Access. See http://www.reformoffice.com for more information.)

 

1998                                         ProStaff, IT for Enron International                  Houston, TX 

Contract MS Access Programmer/Developer – ProStaff

Designed Access databases and a front-end for the Asset Management group to collect operation/construction costs.  Programmed queries and code for unique reports necessary to compute cost estimates for future asset planning.

 

1997                                         Harris Webb & Garrison                                   Houston, TX      

Contract MS Access Programmer/Developer – ProStaff

Designed Access database and front-end consisting of forms and reports for collection of equity research data.  Purpose of database was to simplify extraction of comparison data between specific health companies through data entry and query searches.

 

1996 – 1997                              Certified                                                           Pasadena, TX

Contract MS Access Programmer/Developer – FMC

Designed and maintained Access databases for plant operation maintenance schedules and part orders.  Linked documents to database for maintenance schedules and work orders including database translation from scanned Excel spreadsheet formats.

  

1994 – 1996                              Houston Lighting & Power                               Houston, TX      

Forms Analyst/Programmer

Designed electronic forms/systems for company's LANs and stand-alone PCs. Established and implemented procedures for releasing electronic systems. Provided back-up support and problem-solving for help desk support.  Designed user manuals for software packages.  Provided individual and group training for company-wide clients.

 

1990 – 1992                              British Petroleum                                             Houston, TX      

Systems Support - I/S, Geological Software Programmer

Enhanced "In-house" geological mapping system (coded in FORTRAN and Pascal) to provide users with a more useful lease-block option being otherwise offered by outside vendors.  Collaborated with users to develop a quality, systematic front-end program for creating seismic maps and reports.  Designed/created user accounts, groups and server environments for UNIX file servers.  Provided group training and presentation to management using PowerPoint.

REFERENCES

REFERENCES

ERA/The Michael Group - Cynthia A. Savoie, Realtor               cynthia_savoie@yahoo.com
E-mail Marketing, Forms/Graphic Design, Data Storage and Various Administrative Duties for MLS

Exxon Mobile - Henry Ade                                                            henry.ade@exxonmobil.com
Report Writing and System Re-design

Spinnaker Systems, LLC Ana Adame                                     aadame@spinnakersys.com
Report Writing and Security Implementation

 

BACKGROUND SUMMARY

I have over 16 years of professional programming work experience.  I have been an independent contractor since 1996.  I have worked on systems ranging from small departmental databases to company-wide databases running across multiple networks.  I am a Microsoft Access Certified Specialist.

I often work on new development projects and my analytical skills help me to pickup on systems already in development and provide further design input.  I've done much EXPORTING/IMPORTING between Excel, Delimited text fields and Word Documents. My other experience/skills include: creating relational tables, querying tables, designing reports and interactive user screens/forms. 

I’ve provided various training sessions ranging in size from 10 to 100 (company-wide, end-user sessions) trainees.  I was also a teaching assistant and lab instructor in college.  Additionally, I’ve conducted one-on-one designer training sessions with my clients. 

My professional skills include the ability to work step-by-step with the client, user community, management and co-developers through the design process.  My specialties are database querying, data manipulation, system analysis and problem-solving.

 


About  |  Services  |  Contact  |  HOME  |  Work Samples  |  Request a Quote  |  Services Price List

Banner