Due to this project, we achieved remarkable business outcomes, including a 47% increase in fulfilled orders, a 28% rise in revenue, and a notable 38% enhancement in customer retention rates.

I built RESTful APIs and full-stack projects that seamlessly integrated live data from Shopify to our React app. These projects notably enhanced the efficiency and performance of critical departments
including Customer Service, Order Fulfillment, Accounting, and Sales.

Through the use of webhook services and Shopify’s APIs, we pulled live data from Shopify and stored it in our own MySQL database stored on AWS servers to increase performance over direct requests to Shopify. Using this data, I created custom and intuitive tools that directly communicated with Shopify and allowed our departments to complete their tasks more efficiently.

Order List Screen
Reimagined Shopify’s order list screen to optimize it for our use case, while improving responsiveness and space utilization. Additions included information and links to items such as: tasks, time to collect, vendor info, purchase orders, improved note formatting, filters, calendar

Order Hub Screen
Reimagined the Shopify order overview screen to optimize it for our use case and improve synergy with the rest of our app’s tools. The hub screen houses all the information that would typically be found on a Shopify order + tasks, purchase orders, returns, notes, customers, email tool for customers / manufacturers, tags, and was fully integrated with Shopify.

Purchase Orders
Created a tool to handle purchase orders to track and ensure customer orders are properly fulfilled.

Task Manager
Created a task management system to allow team members to manage their duties (customer service, order fulfillment, sales, accounting)

Vendors
Manage vendor contacts, as well as notate order fulfillment and return instructions and return policies.

Returns
Created a tool to manage damage claims and returns. This tool created a guided workflow to handle damage claims and returns by prompting users for information about the claim based on information they provide.

Sales
Recreated the Shopify analytics screen with an emphasis on team and individual rep performance.
Improved date filtering
View, set goals, and monitor team / rep progress towards goals
Compare performance relative to previous periods
See a complete list of sales made by individual reps

Users
Manage user accounts, access, permissions
Assign users to roles / teams

Admin Panel
Database / dashboard management tools for superadmin accounts
Email template creator / editor for customer / manufacturer emails
Created front-end database management tools to ensure database integrity

Migration Manager
Propagate database updates from the dev database to the live database

Developments
Manage development requests (bug fixes / feature requests)

And more tools…

Implemented an Electronic Data Interchange system to automatically handle electronically transmitted documents to automate inventory management, invoices, purchase orders, shipments, and acknowledgements. Our system handled 810 (Invoice), 846 (Inventory Inquiry), 850 (Purchase Order), 855 (Purchase Order Acknowledgement), 856 (Advanced Shipping Notice), and 997 (Functional Acknowledgement) documents.

A critical step of any EDI implementation is the documentation and communication of the standards that your business uses. To increase the efficiency of onboarding our partners at FactoryPure, we created a documentation website to share the standards that we use, allowing our partners to reference them when integrating with our system.

We also created an EDI playground tool that allows our partners’ development team to test EDI documents to ensure that they are properly formatted and meet our implementation’s specifications. The playground takes in an EDI file as input and outputs a parsed JSON object according to the input received. If the document is malformed, the tool will tell you which segment and element contains the error, which can then be fixed by referencing the guide for that EDI File. If the document does not contain any errors, our partners’ development team can review the output JSON object to ensure that the information in the EDI file will be communicated as expected.