Edward Muller, CPA

Vancouver, WA

eMuller AT EdwardMullerCPA.com


Programming Languages

C# VBA Visual Basic Active Server Pages Java Script VB Script C/C++ Ajax

Databases

Microsoft SQL Server MS Access My SQL Oracle Paradox Fox Pro

Software

Excel MS Access Word One Note Sage 50 Peachtree MAS 500/200/90 Corel Draw



About Me

My name is Edward Muller.

I am a Certified Public Accountant in the State of Washington who also has 20 years of experience in the software industry. I specialize in the integration and automation of data sources, payroll and accounting applications, and reporting. My combination of CPA and programming skills and experience gives me a unique edge for both financial and business analyst positions.

What I first and foremost offer companies is my proven ability to automate and streamline the efficiency of office processes like payroll processing, data upload, and report and dashboard generation while at the same time communicating with office and accounting staff in terms they understand.

My work history includes experience in all phases of the Software Development Life Cycle from initial assessment of requirements through design, prototyping, testing, debugging, installation packaging, and end-user documentation writing, training, and customer support both over the phone and in the field. I am easily able to communicate with non-technical end users and management in language that they understand.

I have over five years of experience with C# application development and debugging along with experience with all versions of Visual Basic from Version 4.0 to VB.NET and am expert in Visual Basic for Applications (VBA), the macro language behind the whole Microsoft Office Suite, and web application development with ASP.NET. I have also developed applications with ColdFusion, Java, and C/C++.

My database experience includes Microsoft SQL Server, Microsoft Access, Oracle, MySQL, FoxPro, and Paradox. I have designed and modified databases, written complex stored procedures with cursors, performed multiple database migrations and updates, and set up user security access.

  • Certified Public Accountant
  • BA in Mathematics with a concentration in Computer Science
  • 20 years of database experience including MS SQL Server, Oracle, MySQL, MS Access, Paradox, and FoxPro
  • 20 years of experience coding in Visual Basic (versions 4, 5, 6 and VB.NET plus VBA and VB Script / ASP
  • 10 years of experience with Active Server Pages, IIS, and SharePoint
  • Experienced in all stages of software application development from initial design to end-user technical support
  • Excellent written and verbal communication skills

Work Experience

Senior Data Analyst / AFMS, Portland OR
2015 - Present

  • Debugged and modified a live invoice generation system spanning multiple MS SQL Sever databases with an ASP web page front end interface and multiple C# apps
  • Debugged and modified complex, multi-page SQL Stored Procedures and SSIS scripts
  • Automated MS Excel Spreadsheet generation using VBA connecting to MS SQL Server databases
  • Used AJAX utilities to increase user-friendliness of existing company web interface
  • Created and maintained automated invoice entry generation and tracking system for Sage 50 invoices
  • Migrated Peachtree accounting system to Sage 50
  • Investigated and resolved accounting discrepancies
  • Maintained G-Mail system for company
  • Provided technical assistance and troubleshooting support for salespeople in field


Information Technology Specialist / Pacific Bells, Inc., Vancouver, WA
2007 - 2014

  • Managed SQL Server 2005 and 2008 R2 databases for the company.
  • Used DTS, SSAS, SSIS, and SSRS to provide ETL and reporting functionality to the company
  • Created and modified Crystal Reports
  • Performed reports and analysis for ACA implementation
  • Created ETL processes for payroll and accounting systems using VB.NET and ASP.NET
  • Worked ETL processes for Paradox and Fox Pro databases
  • Designed databases, wrote and tuned complex queries and stored procedures
  • Performed statistical analysis and growth projections for budgeting
  • Created specialized accounting and operations reports in Excel for end users
  • Used VB to automate data entry processes and increasing employee productivity
  • Managed Exchange e-mail server for over one hundred users
  • Maintained and updated company website and SharePoint server
  • Purchased, installed, repaired, and upgraded company computers and laptops


Programmer / eBay, Campbell, CA
2004 - 2007

  • Created requirements documents based upon user interviews
  • Created Excel VBA code to generate complex spreadsheets
  • Maintained and enhanced existing Access VBA applications
  • Wrote queries in PL / SQL to run against various Oracle databases
  • Worked with DAO, ADO objects and Active X controls
  • Wrote VB.NET applications


Programmer, APX, Sunnyvale, CA
2003 - 2004

  • Debugged ASP pages
  • Developed VB code to create and FTP Excel spreadsheets
  • Debugged, maintained, and customized ASP pages that read and processed SOAP/XML documents


Trainer, ProMatch, Sunnyvale, CA
2003

  • Taught classes in HTML to other professionals


Programmer, ALZA, Mountain View, CA
2002 - 2003

  • Upgraded existing VB and Visual C++ GUI applications with SQL 6.5 and 7.0 backend databases
  • Developed payroll applications in VB with Crystal Reports
  • Wrote supporting documentation and QA test procedures according to FDA standards


Programmer, APX, Sunnyvale, CA
2001 - 2002

  • Developed and debugged Active Server Pages running JavaScript with a MS SQL-Server backend database for a multi-tiered, real-time commodities exchange software used for electric power trading
  • Developed and debugged complex stored procedures in MS SQL-Server that made use of cursors
  • Used DTS for data transfer
  • Wrote QA documentation and procedures


Web Applications Developer, eStamp, Mountain View, CA
2000 - 2001

  • Developed COM objects with VB 6.0 for a multi-tiered, object-oriented, web-based warehouse management system on Windows NT. Backend databases were Oracle and MS SQL Server 7
  • Wrote stored procedures and triggers
  • Worked with XML/XSL and PERL


Web Applications Developer, ClickNet, San Jose, CA
2000

  • Converted an existing VB 6.0 application to a multi-tiered web-based application using a combination of Active Server Pages, VB 6.0 COM objects, and DHTML (web pages interfaced to a Microsoft SQL-Server database that I helped migrate and modify from an existing MS Access database)
  • Created prototype web-based software using Cold Fusion and DHTML
  • Debugged an existing VB 6.0 GUI program for anti-virus software that accessed a Microsoft Access database using ADO under Visual Source Safe 5.0 on Windows NT, as well as made use of third-party OCXs


Education & Certifications

Certified Public Accountant

State of Washington Issued November 19, 2012 No.: 30959


Bachelor of Arts in Mathematics with concentration in Computer Science

San Jose State University, San Jose, CA


Certificate of Accounting

Mission College, Santa Clara, CA