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

How to migrate SQL Server instances with permissions to a new server

We recently virtualized a client’s server environment. We’ll write more about virtualization, general concepts, at a later date. As part of that, we had to migrate 3 SQL Server instances to a new server. This was made significantly simpler with a Powershell Script. DBATools – Powershell Scripts to Migrate SQL Instances Download and install the […]

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 […]

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 […]

Sites & Technologies

I use these tools and find them helpful.

GLIP
Similar to slack or hipchat but I like the interface better.

 

Google App (so many)
Drive (docs, sheets, forms, etc.), Keep (a simple list tool), Alerts, Analytics, gmail, calendar, etc.
If you are using hotmail, yahoo, or AOL. STOP IT! 😉

... more coming soon...

Oh.. I'm an Android, not an iPhone. Ask me why if you wish.