I have 15 years of experience working with Visual Basic and now VB.Net to turn Microsoft Office products into rock star appealing business productivity applications that manage, download, extract, transform, and report data for my clients and employers. Also, I have worked with legacy VB applications to maintain or integrate new features or convert to newer C# modern style with the best, modern coding practices.
I decided on my career to say goodbye to VB and focus on C# .Net as my primary programming language of choice. Hence, I do not offer any sample demo VB code on my tech portfolio. It is my career preference to work primarily with C# .Net and I can help your team maintain existing VB code and lightly integrate new features in VB by converting from C# to VB. I believe the future is now C# and prefer to work on C# projects or bringing business problems from VB to modern C# solutions. However, in practicality, many business IT solutions are a mixture of VB and C#. The beauty of .Net is the interoperability of both languages and I have experience with both.
Employer Project Experience
Below are a few project examples that I have detailed my experiences.
Substation Modeling Template
Developed a user-friendly Excel template for modeling entire new substations with data entry validation, macros, and smart automation features that converted and exported station model details to database SQL script files. Users would follow a step-by-step process in manually entering data while the application intelligence related to the data entries would expedite the substation model creation process versus using the existing EMS vendor on-screen modeling displays that were time-consuming and more prone to validation errors.
Integration & Maintenance
I have a lot of experience working with legacy applications built-in VB that was developed 10+ years ago, or even a year ago, that are used today and need updates to solve a problem or integrate a new feature. In some cases, I have developed complex C# code and used a Microsoft C# => VB code converter to backward translate for the VB application. Also, I have made lightweight updates to add new methods (yeah I know.. Sub or Function) or enhance existing ones. Also, I have made the existing VB applications interoperate with the new C# libraries to solve business problems.
Microsoft Office Applications
I started my experience with VB in programming Microsoft Office applications to solve business problems. For example, I would program an Excel workbook that would connect to a database, download data, and process that data in a results summary or dashboard display. The user display in Excel would have buttons that control the application and provide real-time production monitoring if desired. Also, I made Microsoft Access applications that provided reports, data monitoring, and business analysis by connecting to multiple databases internally or outside the company, to run the queries, analysis, and reports. Since most users had Microsoft Office applications installed, many of my employers preferred this as an application solution instead of custom software independent of Microsoft Office.