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.
Photo Credit: E. Lopez
Some of the tools & technologies I use:
- Microsoft Visual Studio
- Microsoft SQL Server (all flavors)
- Microsoft Access
- VBA (Excel & Word Automation)
- Windows Server: Active Directory
- Powershell, VBScript, Kixtart, and other automation scripts
- 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.)
Blog entries & tools to make you smarter & better
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 […]
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 […]
Someone reading my part 1 of ??? tutorial on Quickbooks – sorry.. read the notes. 😉 – was struggling to find how to add checks. I wrote them this morning about what to look for in the On Screen Reference OSR for the Quickbooks SDK. iCheckAdd Under the Onscreen Reference, there is a iCheckAdd message. […]
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, […]
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 […]
File Download: Microsoft Access/VBA Sample File Edit: 7/23/2017 – an improvement to this solution. This will require some refactoring. A week or so ago a reader asked (on this blog post), if we could place the file online that performs the operation in this blog post (and video). I’ve included it below as a download. The […]
A project outline. Creating ACA form 1095 data using SQL Server, Excel, and VBA automation.
Summary: Our client wanted to extract data from a web portal. We wrote a VBA script to the requested information and store it in an Access database. The example below demonstrates the same technology, but the data is stored in Excel. Edit: 7/23/2017 – An improvement on this solution. Edit: 9/9/2016 – I posted a download […]