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
Summary: Some of the reasons why you should use SQL Server (or SQL Server Express) to store data for your Microsoft Access projects. Plus, code to simplify connecting to SQL Server and attaching tables without manual linking. The Access DB is miserable but awesome! Can we be honest. It’s slow, clumsy to move around, inherently […]
Summary How to avoid VBA errors with single quotes in a string being passed to a SQL Insert or Update Error. Includes how to passing parameters for an unknown or variable number of variables. Technologies Microsoft Access, SQL Server, ADO Something funny I hadn’t used this in a few years. When I ran across the […]
Whew!!! Long title. I published a simple tutorial on how to create the image below with the text overlay and semi-transparent background. Google Drawings is a FREE app that comes as part of your Gmail address or with your GSuite subscription. Benefits FREE! Cloud-based: any computer, any location, no software to install Allows collaboration: Team […]
Data Migration Sucess Some simple concepts to help you with more successful conversion and migration projects. Front-load the Automation Automation requires more work at the start – on the front-end of a project. Create simple data connection and output tools immediately. Doing so will give your team the confidence to defer to the automation tool […]
Los Angeles, CA – Pulse Infomatics Streamlines the Sales Call and Prospecting Process Pulse Infomatics is preparing to release it’s flagship Sales Prospecting and Call Center software, Hyper Call Q, for limited custom release in January 2017. Hyper Call Q provides a simplified, single-screen and push-button actions, for almost all call resolutions. Additionally, sales reps […]
If you run a wordpress site and want to include simple poll questions or other specialized input forms on your pages or blog posts, consider the Google Forms plug-in from Mike Walsh. I’ve used it for years and it combines the power of Google Forms with WordPress. In your WordPress console, add & activate the […]
Should you learn VBA? Note: A very simple sample file and code can be downloaded just above the video. A lot of “real” programmers dismiss VBA and Visual-basic in general. This is short-sighted for a number of reasons. Building solutions should be about effective solutions, not a myopic focus on the “most powerful tool.” When […]
Let’s start with the, “Why do you care?” question. Short answer: You don’t! You’re a business owner or manager, not a computer tech/system engineer. But… you might care, if you knew a little bit about it. And by that I mean, knowing what it is and more importantly, how it benefits the business using it. […]