C#,NET VBA Developer

CAREER OBJECTIVE

A motivated and versatile professional with over a decade of experience in IT support, .NET, VBA, numerous scripting languages and other development. Proficient in C#, VBA, MacroScheduler, WIS scripting, SolarWinds Samanage APIs, Microsoft Office, Excel, Word, Outlook, and more. Skilled in analyzing, diagnosing, and troubleshooting data issues; combined with my critical thinking, eye for efficiency and creative solutions, make me an asset to any team and demonstrates a passion for learning and implementing new technologies.

EXPERIENCE

SENIOR OPERATIONS SPECIALIST

OEConnection January 2010 - Present

Worked with ITSM and ITIL Service Management team for incident and problem management to determine root cause and tracking of Problem Management.

Developed Excel Reporting tool for managing Problem, Incident, KB Solution, and ISO Application tracking.

Refactored and rewrote the existing C# console automation integration.

Developed, maintained, and updated C# library for integration of SolarWinds Samanage ITSM API.

QA DEVELOPER

SmartCo Services, LLC (now an OEConnection Company) January 2010 – Present

Triage internal and external tickets, diagnosed, debugged, tested, documented, and pushed updated code and applications.

.NET DEVELOPER II

SmartCo Services, LLC (now an OEConnection Company) January 2010 - Present

Developed, improved, deployed, and supported customer-facing data integration applications for OEM Car Dealers for automated data extraction and entry.

Create reporting and diagnostic SQL queries.

IT SUPPORT, LEVEL 2 TECHNICAL APPLICATION SUPPORT

SmartCo Services, LLC (now an OEConnection Company) January 2010 – Present

Provide technical and application customer support, analyze, diagnose, and troubleshoot production data issues.

VBA DEVELOPER

Freelance Programming Consultant February 2007 - February 2021

Assisted Director of Finance for a multi-national company, Vice Presidents of an insurance company, and other business principals with productivity and reporting solutions, macros, Excel usage, hints and tips, email, and reporting tools.

Successfully completed various projects found on multiple freelance sites and other sources, including proposal generator for financing company, questionnaires, clinical progress note system, unpaid co-pay tracking system, Auction Tool to track multiple Live and Silent Auctions, file compression add-ins, file linking add-ins, data entry, data cleaning and optimization, web site programming and fixes, troubleshooting of clients existing Word or Excel based applications, and many other various small projects, functionality enhancements, and user interface improvements.

VBA DEVELOPER, EXCEL DEVELOPER

Software Efficiency Training (SET) Consulting February 2007 - January 2010

Designed and developed Excel-based reporting systems, interactive dynamic pivot tables and charts, invoice backup generator, productivity, and functionality enhancements to complex financial projections models, converting mathematical formulas to VBA functions.

Completed multiple various small tasks and jobs, including building components for larger projects, web-based Word and Excel template updaters, installers, troubleshooting, testing, and debugging of client projects.

OFFICE MANAGER

Town of Stoughton, MA Youth Commission August 2005 - January 2007

Updated and maintained organizations paper and electronic files, policy, and training manuals.

Processed invoices and reimbursements for submission to the accounting department.

Scheduled travel arrangements; scheduled and chaperoned outing and trips.

Created board meeting agenda, attended board meetings, took minutes, and distributed formal minutes to board and Town records.

Developed first General Ledger spreadsheet for weekly and monthly budget tracking and grant financial activity tracking and grant compliance.

Designed, created, developed, and maintained two associated websites. Developed flyers and brochures, created quarterly newsletters, and prepared mass mailings (postcards, invitations, group flyers, and other packets).

Provided administrative support for associated grant funded organization.

SKILLS

VBA

Excel

C#/Visual Studio

MacroScheduler

Samanage

SolarWinds API

NET Development

Microsoft Office

Software Integration

Debugging and Troubleshooting

Debug Code Issues

Bug Fixes

Code Refactoring

Write Computer Programs

Update Applications

Agile Development Methodologies

Expertise in Programming Language

Critical Thinking

Code Fixes

AWARDS

Awarded a leased vehicle for saving the company ~$250k/year creating software to replace a 3rd party vendor.

Contact this candidate