I’ve been called many things …
I started my post-college career when I was hired as a supply chain intern working abroad for PACCESS Packaging (now BILLERUD) in Bangkok, Thailand. After earning a reputation as the resident ‘Excel guy’ I began helping out with testing custom claims QA software and crafting business reports. Every few years … my curiosity and the needs of the business led me down a beautiful spiral into the world of Business Analysis and Information Technology (see my journey at BILLERUD below). It was here that I developed an appreciation, awareness, and understanding of the many facets of a global supply chain. It’s important to clarify roles, responsibilities, and expectations to ensure processes and practices allow an organization to run efficiently. Could you use more clarity and transparent communication within your team? Drop me a line!
-
Lived and worked for 4 months in Bangkok office
Assigned to business trips in Vietnam (Ho Chi Minh office), China (Shenzhen office), and individually documented and collected money from Supplier representatives at Suppliers Summit in Kuala Lumpur, Malaysia
Tested and documented custom claims software.
Performed, documented, and streamlined management reports in Excel.
Provided a range of support and process improvement.
-
Translated and gathered technical requirements for costing Excel spreadsheet to be developed into a Sharepoint InfoPath web form.
Tested and created user training documentation for SharePoint InfoPath web form.
Streamlined and documented both forecasting and management Excel report processes.
Extended and streamlined Excel savings tool for data-gathering and sales presentations.
-
Promoted to Full-time position encompassing company-wide projects.
Key player in successful ERP Implementation of Dynamics AX 4.0. Provided process mapping and training documentation in MS PowerPoint, Visio, and Word for global operations users.
Individually configured and administered Dynamics AX security before go-live (mentored back-up and provided training documentation).
Developed SSRS reports for global daily operations use allowing them real-time access to AX data as opposed to daily batch reports (Sourcing and Packaging Divisions).
Created Unique Box and Box Fitting Tools in Excel to aid packaging decisions.
Streamlined damaged roll process in Excel and calculations to save order entry time (Paper Division) by creating formulates which auto-calculate.
Provided in-depth analysis, modeling, and reporting for gain-share initiative (Packaging Division). Reports were gathered from external customer’s Access database online and translated into an Excel Pivot report for distribution to stakeholders.
-
Promoted to senior role
Led critical issue-tracking/project management system upgrade with no downtime (JIRA 3.7 -> 4.2).
Extended website to include Brand Portal for supply chain visibility reports by integrating AX 4.0 roles into ASP.NET website.
Created auto-messaging functionality for sales leads and opportunities (Fiber Division) by creating SQL database triggers and creating new user groups in JIRA.
Wrote SQL scripts and stored procedures for ASP.NET Supplier website. Provided comprehensive testing (Unit and UAT) in JIRA (issue-tracking software). Provided training documentation for internal and external users globally (using PowerPoint and Word).
Designed order automation SSRS reports to show the extent that electronic data exchange positively impacted the company.
Individually created Excess Volume Tool in Excel to aid packaging data gathering and decisions regarding best fit.
Developed screens, SQL reports, and extensive training documentation for data gathering ASP.NET website.
-
Promoted to .NET/AX Developer role.
Technical lead of eCommerce project which enabled external customers to order services from our ASP.NET website and have the order flow into Dynamics AX 4.0. Designed SQL database, worked on web front-end, and developed all AX forms and tables.
Played a critical role in the development and implementation of eOrders functionality to allow customers to enter orders into an ASP.NET website and process the orders directly into AX using SQL, C#, and JavaScript.
Developed and integrated multiple AX roles into ASP.NET website.
-
Last IT Software Developer in organization after decision to outsource all IT functions. Planned technology support transition in my new role with new consulting company.