I worked for a long time at a civil engineering firm that designed much of the built world that I enjoy, such as sidewalks, a faucet with water, and wastewater reclamation. As a professional services firm, they have a need to invoice their clients in order to generate revenue for what they do. We had …
Git and GitHub
As I explore various positions in the tech industry, I find that my self-taught skills don’t translate that well to qualifications for positions. I am familiar with programming and have created a number of solutions, but I never created a repository of my work. I want to fill that gap and decided that Git and …
Project Folder Automation
The company had a problem. Multiple file servers, one for each office location, meant there were multiple places a project could live. Organizing thousands of active projects was no easy task, especially if employees from multiple offices were working on the project. The structure for storage of these projects was hard to understand for the …
Report Automation
I have used SQL Server’s TSQL to generate Excel spreadsheets from Vision data, our ERP, and then deliver the document to various employees. The data in the document is customized to that individual and there are multiple types of audiences that have different reasons for the report, thus need a customized version of it. Even better, Vision …
ERP Data to Active Directory
The ERP I work with is called Vision and is created by Deltek. This holds all the data for all departments in the company, including employee data. Active Directory (AD) is Microsoft’s repository of usernames and passwords that can access a network. But AD stores information about the employees which is then used for display in Outlook …