Independent Application Developers Network




David F. Wiley
We Search For You
Carson City, Nevada


Overview: Member of:

  • International Institute of Business Analyst (IIBA)
  • IEEE Computer Society
  • Association for Computing Machinery (ACM)
  • Information systems Security Association (ISSA)
  • David Wiley has taught Databases at Phoenix University and Keller Graduate School.
His Expertise is:
  • Custom Software Development (VB, VB.Net, VBA)
  • MS Access Application & Database Expert, Access to Database Migration, Cloud migration,
  • Data design, data modeling, data management, and data visualization
  • Database Design, and Development,
  • Dashboards, Process Automation, Office Automation
  • Access 911 Support Services
  • VBA Programming
  • Excel to Access
  • Requirements Development and Prototyping
  • Power BI
  • Reports Design and Development

About David F. Wiley: David F. Wiley is a professional Software Engineer with 30 years of experience in data-intensive applications.

Mr. Wiley has a BS in Computer Science and an MS in Software Engineering. David Wiley also has expertise as a Security Officer. Security regarding Personal Identifiable Information (PII), applications processing, handling and importing and maintaining PII information. David Wiley is responsible for the Limited Death Master File Certification and HIPPA certification. His expertise expands to the NIST framework.

Projects:

For the last 15 years, while at LifeStatus360, David designed and developed the databases and processes used for death audit and life audit comparisons and processing.

The applications developed were:
  • Design and Development of Microsoft Access Hybrid: Access Front End and using SQL Server, MySQL, and MariaDB as the backend.
  • Dashboard for the daily import of customer files, sending via SFTP to data provides, importing results, and sending the result notifications to the customers.
  • Automated daily processing of over 15,000,000 million customer records against various death and obit databases and produced the results and reports.
  • Extract, Transform, and Load (ETL) of vital statistics, obit, and Limited Death Master files into the central databases.
  • Automation of the daily processing of customers' PII data against databases.
  • Special projects
  • Mimicking mainframe Reports and files (Import and export)


Map (click)
Badges


Videos

Title: Application Prototyping using MS Access
Recorded: 01/28/2022

For the client, prototyping creates an expecation that something will be done, and a belief that what is presented will be delivered.

Contents: Definitions, Why prototype, What is prototyping, Types of prototyping, Levels of fidelity, Prototyping steps, Exclusionary method, Prototyping tools, Advantages/Disadvantages, Collaboration, Q&A


Click here to watch

Title: Microsoft Dataverse
Recorded: 01/21/2022

Microsoft Dataverse plus Business Analysis using Access

Topic1: What is Dataverse, Microsoft Power Platform, Data Connectors, Data verse Family, Why use Dataverse, Metadata, Power BI, Logic and Validation, Productivity Tools, Security, Tools, Reporting, Getting Dataverse, Alpha and Dataverse, Controlling Costs

Topic 2: Business Analysis using Access


Click here to watch