Macros For Work

Below is a list of macros that I've created to help automate and/or manage tasks in the actual workplace. Looking back, I'm proud of the work I've done, as these projects have spared so many people, myself included, from unnecessary hours of labor. I will not make these macros available for download.

Knowledge Management Tool (NetSuite)	Consolidated drill down results from a NetSuite Solution Search across different teams. Made assigning and tracking solution reviews a lot easier. Had a feature that isolated solutions for each assignee into individual worksheets. This was especially useful since each team would have around 400-800 solutions to manage and distribute among so many knowledge management contributors. Also updated this tool so it could be compatible to reporting from a web tool.
PL/SQL Query Generator (DXC)	Allowed for generating long PL/SQL queries that could be used for manipulating data from SQL tables, then gathering summarized stats to compare old and new data. Because of the nature of the long queries that were used for work, composing the queries was prone to human error, and subject to multiple edits until desired results were captured. This eliminated hours of work for a single table into 5 minutes. Doing multiple tables for an entire week was simplified into working for 30 minutes.
Change Management Tool (DXC)	Allowed users to create checklist templates. Worksheets with checklists can then be generated with the click of a button. The worksheets can be used for easier tracking. The tool also served as a repository for projects/changes and statuses of tasks from various departments.
Report Formatter (DXC)	Used to generate and format tables/visualizations of reports on projects and NNIT testing. This significantly reduced the amount of time to create reports.
Incident Management Tool (DXC)	Used to login to a website and scrape table data onto Excel. The data then gets formatted and compiled into a single report that gets sent via SMTP.
SAP Table Comparator (DXC)	Allowed users to login to different SAP boxes and download data from a specific table from each box. The data was then compared to check for any discrepancies. The downloaded data made it easier to locate any erroneous data so that data quality teams could more easily make the correction. Manually the entire process could take 2-4 hours of work, but this was reduced to 30 minutes to an hour.
Screen Capture Tool (DXC)	Allowed users to login to different SAP boxes and capture screenshots from different tables. The tool reduced manual work that could take 30 minutes to something that could be done in 5 minutes.
Mission Report Generator (Church)	Generated 10 KPI reports with 6 months worth of data. Generated reports could create visualizations/charts. Was also used to detect anomalous data, and identify KPI achievers or candidates for recognition. This reduced manual work that could take 4-8 hours to 10 minutes.
Mission Letter Generators (Church)	These were several macros (1 for each letter template). The macros allowed users to create/edit letter templates and enter a small database for variable data. Clicking a button resulted in generation of dozens of letters (1 letter for each database entry). This significantly reduced manual work that could take an entire day to 30 minutes.