Changing How the World Works.
 
 
  • Feedback: none
Total oDesk hours:
0
Location:
Fort Worth, United States (GMT-06:00)
English Skills: (self-assessed)
5.0
Member Since:
July 21, 2008
Last Worked:
 
Current Assignments:
0
Total Assignments:
0
oDesk Ready:  
Yes
 
 
 
 

Linda Gray - Access Programmer - More than 10 years experience - Freelance Programmer / Developer, United States

Profile             Linda Gray is a Certified Public Accountant with more than ten years of wide ranging experience in Access Development in the Accounting Profession. In addition to this extensive background, her areas of expertise are in Business Process Analysis and Improvement, Reverse Engineering, Data Analysis, Microsoft Office Training, and Database, trouble-shooting. ·         Spreadsheet and Database integration and conversion·         Business Systems...
Skills
Skill Experience Level Last Used Description
Access Guru 10 yrs 5.0 2008  I have more than 10 years full time experience building/analyzing/ and developing databases for many industries.  My projects provide solutions for many areas of the business world, from process automation in Accounting and Finance departments, to Engineering departments etc.
Excel creation and development 12 yrs 5.0 2008 I use Excel in conjunction with many of my databases for a work solution that works for my clients when it is not feasable to convert a spreadsheet into a database.  My experience includes all calculations, summary, VB in macros, data import/export, vlookups/hlookups etc.
Word 11 yrs 5.0 2008 I use MS Word on a daily basis, both in conjunction with my database projects as well as in creating documentation for my projects.  I am familiar with all facets of the software.
Certifications
Date Earned Name Score Percentile Organization Description
1997 Certified Public Accountant [07513]     TSBPA I earned my CPA certification and use the knowledge in conjunction with my Computer skills to provide usable work solutions for my clients
Employment History
From To Company Title/Role Description
01/2000 Present Data Solutions Owner / Executive January 2000 -     Data SolutionsPresent                   Self-employed Consultant (See project detail below resume summary)·         MS Access Database Development and trouble-shooting·         Process Automation·         Spreadsheet and Database integration and conversion·         Business Systems Analyst·         Microsoft Office TrainingMy most recent project experience in Access Development includes: 
1) Development of multi-user GUI environment to facilitate Medical Office remote access to a Patient Management database.  The project also includes automation of complex business rules and financial reporting as well as an interface with Medisoft software that is used to for billing to Medicare, Medicaid and Insurance providers.
2) Automation of complex Cable provider contracts – This project involved interpretation and implementation of vendor contracts for a large scale Cable provider.  Vendor contracts were based on intricate combinations of Channel selection, volume of viewers by region, for specific time periods and rates.  The automation of the contracts provided more consistent and accurate revenue reporting and eventually pulled the company out of bankruptcy. 
3)Dell Computers – Various projects through the company – Including automation of high volume international Inventory reconciliation, large scale volume reconciliation of credit accounts that included development of a Multi-user GUI environment.
4) Financial Reporting Tools – These projects provided faster and more accurate weekly reporting for Finance and Accounting Departments.  The time spent preparing reports was significantly reduced from a two-day per week process to one hour per week.  Subsequently, more time could be spent on actual analysis of the results. 
5) Accounts Payable Analysis – In two of these projects, the Accounting departments were experiencing loss of data in the Accounts Payable process.  Because of the substantial amount of data being processed through multiple software applications, the departments were unable to determine the cause of the problem.  By using Access, I was able to identify the source of the problem as well as develop a strategy to track the Accounts Payable data throughout the process to identify future discrepancies.  Additionally, the accounting departments were now able to track the invoice processing time, thereby salvaging credit ratings and reducing late fees.
6) Financial Analysis – This project was primarily a conversion of Excel spreadsheets used in weekly and monthly financial analysis of expense into database format.  As with many Accounting departments, the Excel spreadsheets had become complex, cumbersome and error prone.  By downloading the expense data directly into a database, rather than manually inputting the information into Excel, the analysis process was greatly simplified.  This in turn, provided more time to for an accurate and timely analysis.
7)  Fixed Asset Tracking and Depreciation – This project was also a conversion of Excel spreadsheets into database format.  The resulting database was able to provide monthly reconciliation’s of Fixed Asset accounts as well as calculate Fixed Asset Depreciation Expense.  The time spent preparing the reconciliation’s and depreciation expense was reduced from one week per month to approximately two hours per month. 
8) Capitalized Work in Process Tracking – This project was restoration and improvement to a damaged database that was developed to track capital projects.  The database had similar functionality to Fixed Asset tracking but was also able to provide budget comparisons, and generate the results in the form of departmental reports.  
9)  Inventory Tracking – This project was a conversion of many complex Excel Spreadsheets used to track inventory into database format.  The end result increased accuracy of inventory tracking and reduced time spent on inventory tracking from one month to one day. 
Education
From To School Degree Area of Study Description
01/1987 12/1991 University of Texas - Austin Other Accounting The time at University of Texas was to turn my degree in Finance to a Double major in Accounting and Finance
08/1983 12/1985 University of Houston - Clear Lake Bachelors Finance
 
  • Project Title: Encroachment Tracking For Energy Company
  • Attachment: none
  • Completed: 07/21/2008
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description:

     In this most recent project, I am responsible for Process Automation using MS Access database and GUI interfaces.  The primary tasks at hand were to implement VBA that allows the users to use a Mailmerge function to automate Legal Documents that were being manually created.  These Mailmerge documents are accessable through the use of Hyperlinks stored in a table.  
    Additionally, a Dialog Box functionality was implemented to select and save other documents that needed stored in a central location with the Legal Documents.
    Lastly, the ability to email multiple attachments was implemented so that the end-user could easily send all related documents from Access.
    Another part of this project is data normalization between the various departments of the compan.
 
  • Project Title: Data Analyst and Process Automation
  • Attachment: none
  • Completed: 09/16/2007
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description:

    In this project, I was mainly responsible for analysis and evaluation of the Marketing data for one of the largest Financial Investment Companies in the US.  The record count of the data averaged 5 - 10 million records that needed to analyzed.
    I was also responsible for creating user-friendly GUI for reporting and file import/export process, ad hoc trouble shooting and training of other Access users within the department as well as finding a user friendly way to provide Security to an Access database without needing to set up Permissions and Admin data.
 
  • Project Title: Automation if Inventory Reconciliation for Fortune 100 Computer Manufacturer
  • Attachment: none
  • Completed: 08/19/2005
  • Category: Software Development > Desktop Applications
  • URL: none
  • Description: In this project, I was responsible for converting a group of complex Excel Spreadsheets that recorded international Inventory into a Database function.  The overall result was an increase in accuracy and tracking of the inventory, and a reduction in preparation of the monthly Inventory summary
Hourly Assignment History
Buyer ID From/To Job Title Hours Feedback
Hourly Assignment History is empty
Fixed-Price Assignment History
Buyer ID From/To Job Title Paid Feedback
Fixed-Price Assignment History is empty
oDesk Tests Taken
Name of Test Score Percentile Date Taken Duration
MS Access 2003 2.60 68% 08/21/2008 38 min
oDesk Readiness Test for Independent Contractors and Company Managers 4.20 47% 08/18/2008 44 min