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
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 […]
Pulse Founder, Matthew Moran, explains on his blog why we stopped selling social media to focus on database development and high-value information technology services. He also provides some advice on how you can fix your social media.
Aging Post Note: I considered taking this down. At this point, I’m not writing the series. I am busy with a myriad of projects – both programming and in other areas (see my music/writing blog). However, I will publish some VBA SDK code as more or less stand-alone blog entries. I’ll categorize them under the […]