Profileimage by Michael Petranech Senior VBA MS Office Suite Programmer from Delavan

Michael Petranech


Last update: 02.04.2018

Senior VBA MS Office Suite Programmer

Company: Office Automation, LLC
Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Native or Bilingual)


Computer Programming Vba Programming Language Uso del Teclado (Informática) Creatividad Macros


I run a computer programming shop in Southern Wisconsin. Wait keep reading. you'll be surpised how programming can work for you.

Programming can make your computers far more productive and useful so you get what you want from them. Further, and this is very cool, programming can eliminate hundreds of thousands of keystrokes, mouse operations, and other repetitive computer tasks! Some performed on a daily basis.

This can all be accomplished in Excel, Word, Outlook, and the entire Microsoft Office Suite by creating complex macros and using creative programming techniques.

Project history

Cigna Health Insurance / Global Health Service Company            VBA Excel and Access Programmer – MS Access Reverse Engineering Specialist
Contracted as a developer to expand existing toolsets with the creation of the
Market Reporting Database to include deeper dimensionality (specifically Market,
Case, and Buying Group) to support new business needs.
Office Automation--Consulting business owner/operator              Automation of office procedures using MS VBA and Visual Basic
Intervention tracking and reporting
MS Access database for Wisconsin Public School system
Analyze requirements with users.
Using VBA and MS Access created UI and supporting VBA code
Gathered test data, populated and implemented test procedures
            Verified outputs
Packaged for multi-user distribution
  • Store student to intervention-instructor and attendance data
  • Developed complex time reports on students
  • Attendance reporting
  • Email capable
Intra-plant work order messaging system
System for sending and receiving messages between shop floor workstations
Storage of messages for reporting and time calculations
            Used HTML, JavaScript, Excel, VBA and DOS batch files.
            Network administration to set permissions, create groups, drive mapping, etcetera
SPX corporation/Waukesha Cherry Burrell Visual Basic-VBA Developer-MS Access Developer & Administrator – Programmer Analyst –
Desktop Application Developer.  Estimated 500 users.
Incorporating a wide variety of IT technologies, analyzed-designed-wrote-tested-implemented 100’s of solutions for a vast mixture of business needs throughout a global corporation.
Environments: MS Office, AS400-DB2, SQL Server 2008 R2, DOS, WWW, Citrix, RDP
Smart Card Solutions       C Programmer
Created and maintained an enormous variety of very complex programs for distribution to support
            the, at the time, emerging field of Smart Cards.
Followed detailed specs to maintain code written in C.
Environment:  DOS text editor and command line compiler

Local Availability

Only available for the countries USA
Profileimage by Michael Petranech Senior VBA MS Office Suite Programmer from Delavan Senior VBA MS Office Suite Programmer