The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Zultec ERP — Enterprise Resource Planning System
I worked as Team Leader / Senior Software Engineer on the development of the Zultec ERP System from June 2006 to March 2010.
My primary contribution was the analysis, design and database development of the Non-Financial Modules of the ERP, including:
Procurement Module
Inventory Module
Sales Module
Production Module
Services and Maintenance Module
User Security Management Module
I independently carried out the analysis and design of these modules, developed logical and physical database models, and created the integrated database in SQL Server 2005. I also guided developers in the implementation of the User Interface and system functionality using C# and Visual Studio 2005.
A significant part of the work involved Business Process Analysis and Documentation. User requirements were gathered and documented, Business Process Flow Diagrams were developed, and Business Process Reengineering was suggested for important processes.
The Non-Financial Modules were integrated with Financial Modules developed by another team, including:
Accounts Receivables Module
Accounts Payable Module
General Ledger
Fixed Assets Module
Human Resource Module
Payroll Module
The ERP incorporated processes covering procurement, sales, inventory, production, services and maintenance. It supported activities such as customer quotations, sales orders, purchase orders, Goods Receiving Notes, Delivery Notes, production job orders, raw-material tracking, finished-product tracking, repair and service job orders, and warranty claims.
The system also incorporated Standard Item Codes, Bill of Material and Chart of Accounts, providing standardization across the organization. Multi-warehouse and multi-currency functionality was also employed.
My Key Contribution
Database Design • Business Process Analysis • ERP Integration • UI Guidance • Reporting • Documentation • Technical Leadership
Technology: C# • Visual Studio 2005 • SQL Server 2005 • Crystal Reports • Visual SourceSafe 2005
This project represents my experience in designing and integrating an enterprise ERP database around real business processes, while working closely with developers and other technical teams.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
I designed an employee intake and routing workflow that collects incoming requests through a structured form, organizes the information in Excel, and uses Power Automate to route each request to the appropriate person or team. The system helps reduce manual follow-up, keeps requests organized in one place, and creates a more consistent process for tracking status, ownership, and next steps.
Business OperationsBusiness Workflow AutomationOperations ManagementMicrosoft ExcelMicrosoft Office 365Microsoft Power Automate
Project Title: Hotel Revenue & Margin Optimization Engine
Role: Data Analyst / BI Developer Tools: Tableau, SQL (SQLite)
The Overview Most hospitality businesses celebrate top-line gross revenue but lack visibility into the millions bleeding out through third-party OTA commissions. I built an end-to-end data pipeline and interactive executive dashboard to transition a hotel’s focus from Gross ADR to true Net Profitability.
The Problem The client had a pipeline of 119,000+ bookings generating $26M in gross revenue. However, they had no automated way to track the $3.8M lost to commission leakage, nor could they pinpoint which customer booking behaviors were driving these losses.
My Solution I engineered a Dynamic Pricing & Revenue Engine designed for senior leadership:
Data Modeling (SQL): Wrote complex queries utilizing Common Table Expressions (CTEs) and Window Functions to dynamically calculate Net ADR and aggregate commission costs across multiple distribution channels.
Executive Dashboard Design (Tableau): Developed a low-cognitive-load, Dark SaaS-themed UI. I applied strict semantic color coding (Teal for retained profit, Muted Coral for commission loss) to instantly guide executive attention to critical margins.
The Impact & Insights
Isolated exactly where the $3.8M in revenue leakage was occurring.
Revealed a major vulnerability in "Long Lead" bookings (90+ days in advance), empowering the management team to adjust dynamic pricing and minimum length-of-stay restrictions.
Provided an interactive, filterable tool for regional managers to assess profitability between City and Resort properties in real time.
Need clarity on your business data? I combine hands-on operational hospitality experience with advanced data analytics to build tools that drive strategic decisions. If you need to uncover hidden revenue or upgrade your reporting infrastructure, let’s collaborate.
Alshaeb was a personal project to showcase my design philosophy towards a business stores website front, the project had a managerial dashboard to manage inventory and items showing on the website as well as pricing and sales on items, the website was built with 2 themes light and dark, aswell as multiple languages for translation
