Steve B.


Steve B.

Tutor

New York, NY 10025

Will travel 10 miles

$65 per hour.

4.73 15 ratings

Excel Applications Tutor

Want to do more than just formatting and formulas? I teach you how to actually write macros for Excel through an immersive approach. I show you how to do things that most people believe are not possible to do with Excel. If you just want to learn the basics of Excel, I will be able to show you all you might need; but if you want to blow the minds of people you work with, I am the tutor you want. I can teach you how to retrieve information from an interactive website and make a chart, all at ... [more]


Microsoft Excel

Excel Application Development


Microsoft Word

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.


Microsoft PowerPoint

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.


Java

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.


HTML

I am knowledgeable about the different W3 (World Wide Web Consortium) standards, including XHTML-transitional. I have a lot of experience with dynamic client-side HTML generation using Javascript. I have implemented browser-only (no server) web applications using HTML and Javascript. I am quite versed in the the Document Object Model, and how to make markup adapt to browser idiosyncrasies using conditional Javascript.


SQL

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).


Finance

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.


Managerial Accounting

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.


Financial Accounting

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.


Web Design

I have implemented a Tomcat application that generated dynamic web content. I have written extensive JavaScript routines to make for extensible web interface capabilities. I have made websites generate content dynamically on a browser-specific basis.


Networking (Computer)

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.


Business

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.


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++.


C

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.


Computer Programming

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.


Computer Science

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.


Linux

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.


Microsoft Outlook

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.


Microsoft Windows

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.


PHP

I have programmed various extensions to phpBB; I have implemented custom calendaring using the SourceForge project WebCalendar. I have debugged various PHP sites.


UNIX

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.


Visual Basic

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.