I have performed accounting for a corporation. I have assisted companies manage their accounting using QuickBooks. I have created automated routines to perform accounting reconciliations for companies. I have also organized accounting expenses for companies to render in Excel using drill-down views.
I was a managing partner for a computer consulting company for twenty years. I would oversee a team of developers (up to five at any time). The company would complete projects for various investment banks, sometimes on a concurrent basis.
I have debugged the Open Source IMAP Mail Server called "Cyrus" using the "RATS" (Rough Auditing Tool for Security). I have written XLLs for Excel. I have written Outlook Addins using C.
I have written extended stored procedures for Microsoft SQL Server using C++. I have written lexical text parsers using C++. I have generated regex parsers using C++.
I have worked as a teacher's assistant for two years and instructed undergraduate and graduate students to write programs. My teaching methodology takes students through a series of algorithmic challenges, starting with simple ones (binary search, "game of life", etc.) and working their way up to more complex database projects. I have also worked as a corporate trainer, instructing employees not only how to learn specific programming languages (such as VBA and C++), but also how to tackle algorithms. While a specific computer language can serve as a useful tool to learn, the language itself is not the ultimate goal of programming; the application of logic and problem-solving to computer languages constitutes the science of computer programming.
I have worked as a teacher's assistant at New York University, at the computer center, assisting undergraduate and graduate computer science majors complete their programming projects. I have published an article on extended stored procedures in "SQL Server Magazine". I have acted as an expert witness in litigation for a "year-2000" (Y2K) case for a law firm.
I have implemented and debugged models for financial instruments. I have performed market valuations of equity portfolios using "three dimensional" renderings in a spreadsheet. I have performed bond valuations using Net Present Value summation. I have also implemented portfolio valuations using real-time pricing in Excel.
I have implemented Tomcat Server implementations (that use Java) that were in commercial service for ratings queries. I have performed dynamic web page parsing using the Java package "htmlUnit". I have implemented SQL database applications using specialized JDBC drivers. I am proficient with Interactive Development Environments for Java, including Aptana and Eclipse.
I have customized the "Astaro" Firewall, which is based on a hardened Linux distro originally derived from SUSE. I have set up and hardened Fedora for clients to act as an IMAP mail server. I have installed Red Hat Server for a web server for a ratings agency.
Excel Application Development
I have written an Outlook VBA macro to load CSV data into Contacts in a specialized manner. I have made VBA event routines for processing programmatic mail responses based on customer Email queries. I have put together Outlook VBA macros for reformatting Contact data to remove duplicates.
I have assembled slide shows for economists using various animation effects. I instruct PowerPoint students on how to obtain good graphics and videos for their presentations for little or no cost. I also instruct students on integration of their presentations with Excel. The most important skill in PowerPoint presentations is to keep text to a minimum and let pictures and charts tell the story.
I have used Windows operating systems since Windows 3.1 (the first version of Windows NT). I have done numerous upgrades of Windows XP to Windows Vista and Windows 7. I am extremely facile using the "Windows API" from various programming languages.
I have done extensive Word macro implementations to assist publishing operations with automated document formatting. I have made print-on-demand books using both Word and OpenOffice. I have experience integrating Word with Outlook using mail merge to generate customized email notices. I have constructed document templates to assist with office automation tasks.
I supported Astaro Firewalls, which required significant network troubleshooting since the firewall effectively also acted as a router. I have troubleshooted Windows workstation issues. I have configured a Debian Unix box to act as a wireless on demand router for a LAN.
I have programmed various extensions to phpBB; I have implemented custom calendaring using the SourceForge project WebCalendar. I have debugged various PHP sites.
I have set up businesses to operate on QuickBooks. I have helped businesses compose customized reports using both the Custom Reporting capability in QuickBooks Enterprise, and QDBC in conjunction with Excel macros. I have performed upgrades of QuickBooks systems to newer versions. I have integrated QuickBooks systems with corporate SQL server databases.
I have implemented numerous extended stored procedures in SQL. I have written a magazine article for the trade explaining how extended stored procedures in SQL work. I have set up two way replication using event triggers between SQL servers on a Wide Area Network (WAN).
I have configured OpenBSD Unix to act as a firewall. I have configured FreeBSD Unix to act as a Samba fileserver. I have configured FreeBSD Unix to act as a network monitor node.
I have done extensive and copious amounts of VBA (Visual Basic for Applications) programming. I have implemented reporting tools using VB.net. I have written various Visual Basic applications using the MSFlexGrid control.