The Who & The What

About me, my approach, and the services I provide. 

Concept Driven, Process Savvy

My name is Matthew Moran. I'm a Los Angeles based software developer and technology consultant. While I love Los Angeles, I serve clients in Arizona, New York, Florida, Ohio, The United Kingdom, France, & Australia.

I authored an approach to technology solution titled, Concept Over Process (COP). COP places the emphasis where it should be: on the client's business, NOT on the technology used. It is included in my book, Building Your IT Career (published by Pearson), which is used in colleges around the world to teach business-centric IT. If you'd like a copy of that chapter, just ask and I'll send it to you.

I help organizations by automating business processes, document assembly, and financial reporting. I also provide coaching and training to help your team become better - helping business and data analysts better use the tools at their disposal.

Interested? Contact me.

Matthew Moran
818-584-6288
info@PulseInfomatics.com

Photo Credit: E. Lopez

Services

Some of the tools & technologies I use:
  • Microsoft Visual Studio
  • Microsoft SQL Server (all flavors)
  • Microsoft Access
  • VBA (Excel & Word Automation)
  • Javascript
  • JQuery/JQueryUI
  • PHP
  • MySQL
  • Windows Server: Active Directory
  • Powershell, VBScript, Kixtart, and other automation scripts
  • WordPress
  • Team Collaboration Tools: Glip, Slack
  • CRM Systems: Saleforce, Insightly, Zoho
    I'm not a fan of most CRM's - building my own
  • G Suite (Google Drive, Google Docs, etc.)

Education

Blog entries & tools to make you smarter & better

Is your SAGE 50 Accounting too slow? Virtualization and Terminal Server

Technologies Sage 50 Accounting 2017 & 2018 Windows 2016 Hyper-V Windows 2016 Remote Desktop Server (Terminal Server) Dell Poweredge T330 Server Sage 50 Performance Sage has performance issues going back to its Peachtree roots. It is inefficient on a network and has poor utilities for purging and compressing data. My client was at their wits […]

Continue reading

Parsing Quickbooks Customer (CustomerRet) Response using XML (DOMDocument)

As I indicated in my Quicbbooks Part 1 of never post, I would post some Microsoft Access and other Quickbooks source code and blog entries, rather than do a more detailed step by step explanation. I hope this is helpful. Quick Explanation You can parse Quickbooks response using a ICustomerRetList – and I may post that […]

Continue reading
VBA Solutions - webpage scripting msxml

VBA solution: Scraping website information using MSXML, HTMLDocument, and getElementsByClassName

Summary An explanation of how to retrieve/scrape website data using MSXML and HTMLDocument but not using the InternetExplorer Application Object. The problem with the InternetExplorer.Application object I have a few blog entries demonstrating how to get web site data using InternetExplorer and the HTMLDocument object. However, there are a few problems with this: Microsoft is […]

Continue reading

Campus Mesh WiFi using Sonicwall, Ubiquiti, and Open-Mesh (network integration)

Overview Our client, an RV resort, needs a robust and scaleable WiFi network for guests. Technologies/Vendors SONICWALL Open Mesh Ubiquiti   The Challenge A family of four can easily be responsible for 7 to 10 WiFi connections: 1 smart TV 2 laptops 1 tablet 4 smart phones 8 connections These connections are likely streaming Netflix, […]

Continue reading

Get Multiple Distances Using the Google Maps API and VBA for Excel or Access includes sample file

Automate Everything I hate manual processes. NOTE: If I get one more email from someone nagging me to finish that Quickbooks SDK Tutorial.. I’m going do it!!!  😉 Edit: 7/26/2017 – Okay.. I lied. I cannot get to it per se… but I am posting some code to help with QuickBooks integration from time to […]

Continue reading