Excel VBA Developer - Part time/Remote
William W Rutherford
Total years of experience :12 years, 0 Months
- Creating WeeSS (SSVGC tool) to automatically display charts and outputs for selected company against peers and industry group
- Fixing and enhancing current Standard CI report and add tons of features.
- Part-time position with on-demand requests based on availability and need.
- Expanding to cover all 5 types of materials, adding several technologies like calculating Plant ID, Date of production, location details ant other parameters from order number details.
- Create a sister system to the one already working in ASP.NET with SQL and AJAX (using VB.NET and not C#)
- System is to create PDF documents based on user request per the data saved in SQL Server.
- System need to be re-created in a different environment with modifying columns and different structure of PDF.
- Help finding issues in order details with investigation and debugging.
- Teaching users the best ways to use the system.
- Converted from a contract position (Senior Excel VBA Developer) within 1st year
- Creating several tools to automate and enhance process of collecting data using Excel/VBA/J solutions
- Tools like (and not limited to):
1- TeeGen: Generate Tallysheets for each area or city meant for testing, this tool was able to deliver savings of 82% during the first few weeks of run.
2- TeeMan: Add user interface to current Tallysheets to speed up the process of daily input, in addition adding touch-screen-friendly controls to be used during collecting data
That includes design, lead and develop the new interface to be used for entry into the daily system process for links and route info.
The new UI was suggested by me, then designed the whole process to enhance the speed and efficiency of data entry from a spreadsheet user interface to a touch-screen-friendly enhanced user interface with functionality like auto populate, auto predict, multiple edit, batch mode, etc
3- TeeMan v2.0, following the success of TeeMan v1, this version have more features like, the ability to connect to DB and load/submit data directly into DB.
4- TeeRCA: Tool to prepare root-cause-analysis report to be modified by analysts.
5- Retest tools, set of three tools to calculate refresh rate, and other map factors with the ability to interrupt and allow user input as needed.
6- Create and Manage MSQL DB and connect it to several tools in the road to move all data used for Quality testing into online DB.
7- TTR, a set of two tools. ReeTime, to collect data from online sources using APIs along with local files generated by SQL. automatically. And Time2Ree, to analyze this daily data and create matching into categories (Adds, Deletes, Possible candidates), then user will go through these candidates and help in matching features.
8- ConvAN, Open-Office macro tools to convert DBF files with UTF-8 encoding into CSVs, since Excel cannot preserve that encoding.
• Leading the team into creating and enhancing TPSS (Transfer Pricing Sharing System) using Excel/VBA as User interface, JACL as back-end server programming and Oracle database. System uses Oracle IOP (Integrated Operational Planning), Sandbox technology and Excel2003/Excel2010 Sandbox technology
• Adding tons of fixes and features to enhance speed and modifying code to match global standards. Fixes added to more 40+ reports, average performance gained around 83%
• Suggest, design, and apply the enhance to "Upload" functionality, reducing bandwidth used by average 95%, this actually fixed the issue causing server to stop responding
• Enhancing the user experience by adding solution to overcome the limitations of 65k rows in Excel2003, feature named "Pagination"
• Adding other features like "Progress bar", "Tree" structure views, and "Re-sizing" forms to all reports.
• Reduce the number of queries used by Excel to read Tables, Views or Rowsources, by merging these queries to speeding controls interactivity with user actions
• Suggest, Design and apply “Smart-Drop-Downs” allowing users to select from huge list of products by searching, something similar to AutoFilter in Excel2010 but more custom
• Suggest, design and add enhances to system in “Upload” functionality, reducing the size of file (and bandwidth) by additional 40%
• Adding tons of fixes and enhances to speed up report response and modifying code to match global standards. Fixes added to more 40+ reports, average performance gained around 83%
• Enhance SQL queries and Views to reduce time used by reports while reading data or applying changes