William W.

Available Now: Access DB, Microsoft Office, Automation, Google & More

As a freelance developer, I am a specialist in Microsoft Office applications with over 25 years of experience including macro coding with VBA (Visual Basic for Applications). I am also skilled in database design and development with Microsoft Access or SQL Server, and I have very recent experience with Google sheets data management and scripting with Apps Script. Working independently or with your team, I can help you with tasks such as Access database design and development or maintenance, Microsoft Office and Google scripting and automation, creating or modifying spreadsheets with formulas and formatting, and Microsoft Word document organization, formatting and scripting. I can perform conversions such as PDF to Excel with Python and web scraping using Python and libraries such as Beautiful Soup. I am a skilled technical writer and will fully document the work I do, including user instructions, when required. My project portfolio below includes three Access database projects, a Google Sheets project with scripting, two projects with automation for both Excel and Word, two additional Excel and another Word automation project, an Excel design project, an XML conversion project, and a web scraping project. My extensive IT experience includes .NET software development for Windows servers and desktops and SQL databases. In my most recent full time position, I designed and developed an application using OCR to locate key information such as party names on printed real estate and other legal documents handled by city and county clerks. Now in use by many customers, the application facilitates automatic verification of the names submitted electronically with the documents or keyed by a data entry person. The development language was C# and the database is SQL Server running as a service under Windows. The code reads XML output from an OCR process and uses extensive regular expression coding to locate information and format it for database storage. A project in my portfolio below includes automation with Excel of the regression testing for this application. I have developed WPF/XAML desktop applications with C# and with WinForms using C# and VB. I also have developed web applications using JavaScript, AJAX, HTML and CSS with backend database access to SQL server coded using C#. I developed one application with React, a copy of the popular Wordle game, using an external API. Throughout my career I have leaned and applied skills such as software architecture, object oriented design and development, database design, technical writing, and problem solving. If you hire me for your project, I promise that I will always pay close attention to the details and accuracy to make sure that the result meets your requirements. Before starting a project, I will listen or read carefully to make sure I understand those requirements, and my written and spoken communication with you will be in clear and precise English. My hourly rate quoted in this profile is negotiable. If my skills are a match for your needs please send me an invitation and I will respond right away.