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
From the blog
I try to share information about what I do and how I do it.
You may visit the blog here.
- Parsing Quickbooks Customer (CustomerRet) Response using XML (DOMDocument)
- VBA solution: Scraping website information using MSXML, HTMLDocument, and getElementsByClassName
- Quickbooks SDK iAddCheck using VBA. Add a check from Excel or Access
- Campus Mesh WiFi using Sonicwall, Ubiquiti, and Open-Mesh (network integration)
- Get Multiple Distances Using the Google Maps API and VBA for Excel or Access includes sample file
- Retrieve Data from Website in Microsoft Access or Excel using VBA
- Affordable Care Act Form 1095 Reporting
- Programatically retrieving data from a website into a database
- Founder’s blog – why we stopped selling social media
- Connecting Microsoft Access and Quickbooks using the Quickbooks SDK part 1 of 3
Sites & Technologies
I use these tools and find them helpful.
Similar to slack or hipchat but I like the interface better.
... more coming soon...
Oh.. I'm an Android, not an iPhone. Ask me why if you wish.