Software & Programming Expertise

I'm a power user with a wide range of Mac, iOS, and Windows software, with particular expertise in Excel and VBA.  At StackOverflow I contribute as Tony M, doing my best to guide others who are just entering into programming. I have written dozens of programs, some with over 10,000 lines of code. For example,  I wrote code to control the production of specialized engineering drawings when I worked for 2 years as a mechanical engineer with 2D and 3D CAD software. Then, as a nanotechnology researcher I found that existing software was inadequate to handle the cutting edge work we were doing, so I wrote custom software to handle it myself.

Last year I learned how to program iOS devices using Swift and Xcode. I immediately applied these skills to write an iOS audio book app for the group I volunteer with. It streams 44+ hours of audio in different languages, and includes an integrated chat feature with both the audio and chat functions hosted in a Firebase backend. 

Data Science

Statistical analysis has always been one of my strengths, but as the era of big data emerged I realized it was worth keeping current with newer approaches.  So I began studying Python in relation to Data Science, and as I became more and more interested in the subject eventually decided to take a course from John Hopkins University.  Since the course is based on R, I found myself learning yet another language.  Actually, there wasn't that much new to learn since both Python and R share so much with what I’ve experienced already. Here are links to certificates for the courses:
R Programming and The Data Scientist Toolbox.

Web development

I started website development using programs like Canvas, Dreamweaver, or the developer tools in browsers. But more recently I’ve been using Brackets and Blocs, and focusing on responsive websites. For example, if you’re viewing this on a computer screen, narrow the window to see it adapt to the tablet and then phone views. But regardless of how convenient or attractive a website looks, the chief thing that will bring users back is the content.  My organic chemistry course demonstrates rich content — enough to occupy students for a year — but to make that content engaging requires quality illustrations in various media formats.


Mastering Software Tools to Present Rich Content

To produce quality illustrations for websites, publications and instructional materials, I use graphics design (Gimp, Artworks, Canvas), video editing (ffmpeg, iMovie, VLC), audio editing (Audacity), 3D rendering (SketchUp), and molecular modeling (Avogadro) software. 

Finally, I’m thoroughly familiar with Google Docs, Sheets, and especially Maps, but when limited by them, I have used the Google scripting tools or Google Earth Pro.  I often write custom VBA code to handle repetitive or complex tasks in Word, Excel, and PowerPoint, and lately I’ve been transferring those skills to Python. I know the power of regex (regular expressions) in Python and advanced find and replace tools within software like WordBrackets, Atom, and NotePad++.

If you don’t see the comment area at the bottom of this pageit may be because of an ad blocker. This site has no ads, just the Disqus comment system. Try reloading without the ad blocker.[…more][less]