Paul Cook-Giles
Senior Application Developer
  • Santa Ana,
  • California,
  • United States of America
Member Since: 2009/01/09
Industry: Computer & IT
Top Skills:
Tech Certifications:
CERTIFIED EXPERT

...thinks that Access is the best computer game ever!

More bio
Activity
Points this month22
Total points247,500
Questions: 15
Solutions: 97
Articles: 2
Videos:
Tutorials:
Posts:
Live: 4
Professional Background
Senior Application Developer
Velapoint Insurance
May 2017 – Present
Irvine, CA
SQL Database enhancement and normalization; Design/build Access user interface for SQL database.  Extensive Transform/Extract/Load processes.  Creation of automated, auditable processes for commission calculation, rate schedule maintenance and publication, creation of reporting functionality.  Expedite/Automate manual Excel processes.  Support user needs for ad hoc reporting tools.
Database/Systems Developer (Applications Specialist)
Word & Brown General Agency
February 2015 – April 2017
Analyze and document existing processes, identify opportunities for improved efficiency, eliminate manual tasks and redundancies, redesign workflows and automate processing.  Create auditable processing.  Design and develop a proprietary database for Commission Tracking using Access and SQL 2008, with extensive VBA coding.  Replace paper reports with PDFs generated and emailed automatically. Recommend enhancements and modification to other proprietary database applications.  Assist in the formulation of procedures and best practices.
More
Education
No Education Background shown
More
Full Biography

You need an Access/VBA/SQL expert to develop and support successful database solutions that will take your business to a new tomorrow.  I'm that guy.

I am a proven end-to-end database developer that can turn your vision into a stable application that will support future enhancements.

Expertise:  user need analysis, business and technical requirement documentation, data modeling,  relational data structures, user interface design, quality assurance, budget, resource management, database consulting, multi-source, multi-relational databases, team management, strategic consulting.

My databases use table driven, user-maintained processes to ensure current requirement are met, without requiring developer expertise to update and maintain variables.  My reports are built on pass-thru queries created on-the-fly and executed by SQL server, which optimizes response time and eliminates processing overhead required by plain Access queries.  Reports can be generated in a variety of user-chosen formats (printed, display-only, output to Excel, CSV, plain text, or PDF).  My forms are interactive, closely tuned to business practices and processes, and allow you and your staff speedy data entry, automated processing.

I'm all about using Access, VBA, and SQL to increase your data accuracy, reduce processing time, and enhance your bottom line.

More
Languages
No Languages shown

Level Progress

Current: Level 11
Paul needs 40,500 points to level up.
LVL 12
  • Overall
    11
  • Microsoft Access
    10
  • VBA
    4
  • SQL
    3
  • Microsoft Excel
    3
  • Microsoft Office
    2
  • Databases
    2
  • Microsoft SQL Server
    2
  • Microsoft SQL Server 2005
    1
  • VB Script
    1
  • Windows 10
    1
  • Visual Basic Classic
    1
  • Microsoft Applications
    1
  • Microsoft Development
    1
  • Microsoft Word
    1
  • Outlook
    1
  • Scripting Languages
    1