Jonathan Bonilla
C:201-245-7631 | E: johnb0521@hotmail.com
Professional Summary
Innovative Applications Administrator with over 5 years of experience. Skilled in designing, developing, and implementing cutting-edge software solutions and rolling out ERP upgrades and implementations to drive business growth.
Work History
IT Applications Administrator - ERP/WMS Dec.2020 - Present
Schuman Cheese
- Tested and configured the integration between ERP (Sage X3) and WMS ensuring adherence to company specifications with the goal to minimize errors between the systems.
- Ran through use cases of various departments within the company, documented findings, and reported any issues to Project Manager.
- Learned the functions of the ERP and met with various departments to understand their needs within the ERP to create roles and groups to apply to users.
- Developed import and export templates to convert data from legacy ERP to new ERP to prepare for go live.
- Performed backups of databases for consultants to transact and run scripts on for pre go live.
- Became an SME in various functions of the ERP and provided training and documentation to end users in multiple departments.
- Manage and mentor a direct report on the WMS which allows work to be delegated and tackle tasks more efficiently.
- Programmed various applets, web forms, and console apps using VB.NET to provide solutions for different areas in the company as needed.
IT Operations Analyst May 2017 - Dec. 2020
Schuman Cheese
- Created and managed accounts in WMS and ERP (Dynamics GP 10) business applications.
- Tested and documented Warehouse Management System (HighJump) for bugs and worked closely with consultants to report findings in regard to WMS upgrade.
- Train end users, from managers to direct reports on new system.
- Created reports for management in cross-functional departments and ad-hoc reports for end-users in Excel, SSRS and other BI reporting programs.
- Develop queries, stored procedures, and views in Toad/SQL Server to use for live dashboards and raw data reports.
- Maintain data integrity between relational databases by updating, inserting, and deleting records in tables as necessary.
- Executed a refined operational process pertaining to the manufacturing process of cheese to enhance the operation and business workflow from the making of the cheese to invoicing.
Education
Bachelor Of Science in Computer Science, New Jersey City University
- Graduated summa cum laude - 3.9 GPA
Core Competencies
Leadership, ERP systems, WMS systems, Warehouse management, Analysis skills, SQL, Communication, Coding.
Personal Projects
- Built a custom PC and upgrade parts as needed.
- Programmed an applet using JavaFX in Eclipse (IDE) that allows for data to entered in textboxes and stored to a database. The data can then be exported as a text file which follows a certain template with identifiers for each row of data. The data mainly focused on the Customers, which had a parent customer and many different Bill To and Ship To sites. This project largely came to be because of the need of data conversion scripts needed to go from my companies legacy ERP to Sage X3.
- Learned and implemented AWS technology to display and host my resume on the web using their Cloud Infrastructure. (www.jonathanbonillaresume.com)
- Programmed a web app in python using various libraries, including the OpenAI library, to take natural language and convert it to SQL. User inputs ("show me all records in "x" table), then the request gets processed by the AI GPT 3.5 Turbo model and the data gets returned in table format within the web app. For the database I used SSMS (Microsoft SQL Server) and hosted it in Azure. The data gets populated in the backend by the same Java program mentioned previously. (https://sl-ai-db.streamlit.app)