|
Projects/Work Assignments
April 2009 – June
2010 Reliant Energy Houston, TX
-
Increased speed of Tax
Exemption Database updates from 30 minutes to less than 1 minute through
the use of proper recordsets (ADO vs. DAO)
-
Automated process for
assigning work to database users.
-
Automated update
process for importing new data through download from Oracle Tables.
-
Added auto kick-out and
inactivity montior shutdown procedures.
-
Added security and
version check for database users.
-
Migrated backend
database from Access to Microsoft SQL Server which greatly increased the
speed of the database even through the use of a VPN connection.
February 2008 –
Present Borden Insurance Corpus Christi, TX
CondoTrack
(Microsoft Access) – New Process and System Design. Redesign based on
existing database which involved creating custom interactive buttons and
graphics. Creating new reports, screen layouts and data processes.
January 2008 – Aug
2009 HealthCare Cost Solutions, LLC/Garland, TX
Instrument Database
(Microsoft Access) – Data Manipulation and Reporting. Handles on-going
projects and required tasks as needed.
December 2007 – December
2008 Reliant Energy Houston, TX
(1) Implement requested enhancements to Survey Database.
Created solution for TIFF image conflict due to Acess 2003. Added
procedures to capture how much time users are in DB for productivity
reports. (2) Created new Claims Database based on previous manual
operations which involved creating user levels and determined user screen
functionalilty based on claim statuses. Also designed Claims Databse as a
SQL-Ready database through use of ADO objects and strict rules for queries.
(3) Created a central database for Marketing to track key business
terms for existing partnerships and capture prospect funnel to track
prospect list and timeline to close. Created Gantt Chart Reports to
represent timelines.
Aug 2008 –
Present Alexander Middle School PTA (Volunteer)
Pearland, TX
Website (www.alexanderpta.org) and E-mail Newsletter (175+
Subscribers). Sends PTA information to subscribers and updates website
accordingly.
Jun 2007- May
2009 Rustic Oak Elementary PTA (Volunteer)
Pearland, TX
Website (www.rusticoakpta.org) and E-mail Newsletter (450+
Subscribers). Sends PTA information to subscribers and updates website
accordingly.
July 2007
Loan Extraction Database
Created advanced functions to an existing application for
extracting probated properties meeting specified criteria based on
market/appraised values and type of property. Required coding of math
functions to compile the extraction sample based on given percentages.
March 2007 – June
2007 Universal Plant Services/Certified
Created a payroll data entry system to prevent duplication of
processes to input/import data into on-line accounting system (Paydata).
Upgraded existing Safety Database processes and reports.
Jan
2007 Priority Ministries
Data Manipulation: Extraction of on-line store data from an
excel file and conversion into specific spreadsheet format. Website
Newsletter Archiving & Design of Photo Borders
Nov 2006 – Jan 2007
Pine Hollow HOA
E-mail Marketing & Website Maintenance: Enhancements –
Faster Page Loads using CSS
July 2006 –
Present Sagemont Church (Volunteer)
E-mail Marketing: Women’s Ministry Newsletter (800+
Subscribers)
May 2004 –
Present GRM Real Estate Company
E-mail Marketing,
Forms/Graphic Design, Data Storage and Various Administrative Duties for MLS
Jan 2005 – Dec 2007 R&E Cosmetology
General Bookkeeping/Quicken: Purchase Receipts,
Sale, Tuition and Rental Income, & Expenses
Jan 2005 – Jan 2006 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.
Apr 2006 – Aug 2006 Affordable IT
Access Database Support and
Development.
eBay Listing Agent (The
Busy Mom Shop) – 100+ Feedback score of 100% Positive
|