Changing How the World Works.
 
 
  • Feedback:   (5.00 of 5)
  • Percentile: 99%
    Based on 1 feedbacks
Total oDesk hours:
0
Location:
Farmington, United States (GMT-07:00)
English Skills: (self-assessed)
5.0
Member Since:
October 10, 2007
Last Worked:
 
Current Assignments:
0
Total Assignments:
1
oDesk Ready:  
Yes
 
 
 
 

Mark P. - Database/Application Developer - Freelance Programmer / Developer, United States

Provide superior service by consistently exceeding customer expectations.  This is in an effort to grow Effective Inc into an industry leader in the realm of customized business software solutions.

See All Work History & Feedback (1 items, 1 with Feedback)
Recent Work History & Feedback
Buyer ID From/To Job Title Hours Feedback
11491 10/2007 - 10/2007 Access 2003 write fields into html —
See All Tests Taken (4 items)
oDesk Tests Taken
Name of Test Score Percentile Date Taken Duration
MS Access 2007 Test 4.20 98% TOP 10% 3rd Place! 12/19/2007 29 min
Visual Basic 6 3.40 87% TOP 20% 10/11/2007 35 min
oDesk Readiness Test for Independent Contractors and Company Managers 4.60 78% 06/06/2008 37 min
MS SQL Server 2000 3.10 67% 10/11/2007 36 min
Recent Candidacies
Job Opening Title Initiated By Date
Database Software Application to Manage Inventory Buyer November 16, 2008
Easy game in c++ without graphics for $1000 Buyer October 26, 2008
Job Category Interests

Software Development

Networking & Information Systems
Skills
Skill Experience Level Last Used Description
MS Access Application Development 12 yrs 5.0 2007 Expert in the area of small business solution development using all versions of Microsoft Access.  Have designed and created multiple solutions for small businesses in various industries.  Expert in database planning, design and development.  Expert in VBA (language used for more complex Access solutions).  Have created integrated solutions involving autmated e-mail, faxing, reporting etc.  Can prvovide customer references upon request.
MS SQL Server 2000 7 yrs 4.0 2007 Have worked on multiple medium to large projects with SQL Server creating full DB design and data structure layout.  Also utilized triggers, user defined, stored procedures, views etc.  Proficient in T-Sql.  Can provide professional references upon request.
VB 6.0 7 yrs 5.0 2007 Have participated in multiple medium to large projects invloving VB 6.  Experience incudes User Interface layout, design, and development, as well as database connectivity, application security etc.  Can provide professional references upon request.
Certifications
Date Earned Name Score Percentile Organization Description
No Certifications
Employment History
From To Company Title/Role Description
01/1997 Present Effective Solutions, LLC OwnerConsultant / Independent Contributor As a consultant, I have used all versions of Microsoft Access as well as Visual Basic 6 and SQL Server to develop business critical applications for multiple businesses including a large tracking application used in the trucking industry. These applications possess tracking, scheduling and reporting capabilities as well as integrated faxing and e-mail functions. I have also developed sophisticated cross-referencing software used in the boat repair business. While consulting, I am completely responsible for working with the client to understand business needs and full design and development, testing, implementation and training for the software I develop.
11/2004 Present SabiOso Application Engineer / Independent Contributor Currently working on application development project for the US Forest Service. Responsible for database design and implementation. Including table structure, stored procedures, triggers views, etc. Other responsibilities on project include implementation of automatic encryption and decryption of exported and imported application data as well as design and implementation of application security. While working at SabiOso, I have demonstrated the ability to adapt quickly to constantly changing customer requirements and have been able to offer guidance and support to other developers on the project team.
10/2000 08/2004 Wells Fargo Service Company PC Lan Engineer 3 / Independent Contributor Member of Mortgage Applications Engineering team. Was responsible for engineering and developing application packages using Wise Package Studio for software distribution to mortgage team members' PCs. I worked with customers/end users to ensure all needs are met. I have provided troubleshooting/maintenance support for many Access databases within Wells Fargo for departments including Private Client Services, Deposit Risk Operations, and Retail Program Office
01/2000 10/2000 First Security Information Technology System Specialist / Independent Contributor Member of Client Server Application Development Team. As an applications developer, I was responsible for working with other developers in creating enterprise wide applications.  I participated in the full development life cycle.  These consisted of Java and Visual Basic for the user interface and SQL Server for the DB end. I was primarily responsible for creating the database architecture/design, developing the database with its stored procedures, queries, views etc. As a SQL/Remedy ARS Developer/Administrator I was responsible for developing and maintaining remedy applications used by the information technology company such as Helpdesk applications as well as Service Level Agreement and Asset Management apps within the Remedy ARS system. Participate in application development projects through all phases of the development life cycle providing database planning and also development of the actual database back end in Microsoft SQL. Also responsible for support assistance with other applications related to the different banking lines of business
12/1998 01/2000 First Security Information Technology Technical Specialist III / Team Lead Team Lead of Baseline Support Team. I lead a team of 12 technicians and was In charge of all support of desktop PC hardware and desktop OS for all of First Security (over 9,000 PC’s). In addition, responsible for support of all desktop applications. Coordinate and schedule resources for support teams. Work with department managers for project planning and delivery. Have built and managed network servers (NetWare and NT). Troubleshoot and Resolve mainframe connectivity problems.
12/1996 12/1998 First Security Information Technology Technical Specialist II / Independent Contributor Member of Desktop Support Team. Responsible for general troubleshooting and support of desktop computers throughout the corporation. Problems included mainframe connectivity, printing, network connectivity and access, etc
12/1988 08/1996 Salt Lake Nut Company Technical Operations Manager / Manager Installed and managed a Novell NetWare 3.12 LAN. Designed and programmed accounting and production software packages. Resolved all computer issues both hardware and software related. Maintained financial records, processed payroll and filed tax reports.
Other Experience
General Skills Summary
  • For the past ten years I have had the opportunity to work heavily with all versions of Microsoft Access. 
 
  • While working as a consultant, I have created and supported several different Access databases. I have produced a business critical load tracking application in Microsoft Access used by a trucking company based in Bountiful, Utah. The application possesses tracking, scheduling, and reporting capabilities as well as integrated faxing and e-mail functions. I recently completed a project migrating this Access database application to SQL Server with a VB front end as well as integration with an imaged document management system, which I developed. I created a sophisticated cross-referencing Access database used in the boat repair business. This application enables the business to better handle parts inventory and quickly research obsolete parts by locating the new part numbers that supersede the previous part numbers then retrieves information from all vendors. This allowed the business to provide instant information to customers and improve service levels. Barcode reading features were included to better track parts receiving and inventory control.
 
  • While working with First Security Bank, I inherited a database created to provide risk tracking abilities for the Risk Management department. The database went through extensive modifications to improve performance and features. I later migrated this application to SQL Server maintaining a front end written in Access. The application underwent further modifications to commercialize the product for sale to other banking institutions. I supported database administrators at other banks during their implementation processes.
 
  • While working at Wells Fargo, this same risk management database evolved with the merger with First Security. The application was re-written in Java for the front end, and a new back end database was developed in SQL Server to support the new Java application. I worked with Java developers providing SQL server expertise by designing the database model and building the physical database on SQL Server including: all tables, stored procedures, triggers etc.  In addition, I developed a complex issue tracking database used by the project management team to facilitate issues management.  Also within Wells Fargo, I consulted with many internal departments resolving various challenges with numerous Access databases.
 
  • While working at SabiOso, I have been involved in the development of a large incident management system commissioned by the US Forest service. My responsibilities in the development of this client server application include data modeling, database design and development, as well as work on the application client and user interface using Visual Basic.  The database development required the use of tables, views, triggers, stored procedures, and user defined functions that I provided in support of other developers on the development team. I created processes utilizing the Data Transformation Services to import data acquired from other government systems for integration into the incident management system created by SabiOso. More recently, I have been involved in a project to create a web application that will provide similar incident management functionality on an enterprise scale.
 
  • All of the above systems were provided with security preventing data corruption and database misuse.
 
  • I possess expert skills in VB and have completed all courses required for MCSD certification. I have extensive experience with VBA using it in all of my Access development. Most recently, I have been working with Java technologies and frameworks.
 
  • I have the ability to parse through and interpret large amounts of data, as well as provide recommendations for data organization.
 
  • I have experience with Oracle, PostgreSQL, Firebird, as well as several other open source database solutions. I believe that, with my experience with so many different database platforms, I can adapt swiftly to any environment and quickly be a major contributor to the success of any company that I work with.
Education
From To School Degree Area of Study Description
01/1989 12/1995 Weber State University Bachelors Accounting
No items in portfolio
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
11491 10/2007 - 10/2007 Access 2003 write fields into html —
oDesk Tests Taken
Name of Test Score Percentile Date Taken Duration
MS Access 2007 Test 4.20 98% TOP 10% 3rd Place! 12/19/2007 29 min
Visual Basic 6 3.40 87% TOP 20% 10/11/2007 35 min
oDesk Readiness Test for Independent Contractors and Company Managers 4.60 78% 06/06/2008 37 min
MS SQL Server 2000 3.10 67% 10/11/2007 36 min