Oldcastle Glass Perrysburg - Accounting Department Website
Description
While working as an accountant at Oldcastle Glass Perrysburg, and on my own initiative, I learned the necessary tools and technologies to develop a departmental website that streamlined the month-end closing cycle by many hours every month.
Technologies Used
- Java
- PostgreSQL
- MySQL
- Tomcat
- JBoss
- JEE/J2EE
- JSP/Servlets
- HTML
- Fedora Linux
- Apache POI
- Eclipse
- Netbeans
Results
- Automated repetitive and error-prone tasks, saving hours of processing time during each month-end close cycle.
- Extracted journal entry information directly from Excel spreadsheets and uploaded it to the AS/400 for posting.
- Reduced the time required to create the Profit and Loss Statement from 30+ minutes to a few seconds.
- The creation of other reports experienced similar gains in processing time.
- The creation of detailed and customized reports, otherwise unavailable from the AS/400's accounting software package.
- Prior to leaving, I was developing a modest data warehouse for the Accounting department and plant’s use.
1-Click Deployment
A 1-click deployment is not applicable for this project.
Diagram
A diagram is not applicable for this project.
Video
A video is not applicable for this project.
Images
Images are not applicable for this project.
Code
The source code is not available for this project.
Write-up
My work at Oldcastle Glass Perrysburg was a great experience in applying technology to automate repetitive and error-prone work flows. I was the primary beneficiary of my efforts, and that gave me the motivation to not give up during difficult and challenging phases of the development process.