Zultec Barcode Solutions — Barcode, PDA & WLAN-Based Business Solutions
As Team Leader / Senior Software Engineer at Zultec, I designed and guided the development of mobile and barcode-based solutions connecting handheld PDAs, barcode scanning, WLAN/WiFi connectivity, applications, and enterprise databases.
The solutions were developed using C# with Visual Studio 2005, .NET Compact Framework, Windows Mobile 6.0, WindowsCE, and SQL Server Mobile 2005, with integration with SQL Server and Oracle databases where required.
I guided developers in implementing mobile applications on handheld devices and PDAs for a range of operational environments, including:
• NJ Autos, Pirani Group — WiFi-based real-time transfer of workshop-floor data from handheld PDAs to SQL Server, with barcode scanning of engine and chassis information through quality checking and dispatch.
• Yunus Textile Mills (YTM) — Barcode-based verification to prevent incorrect items from being packed and incorrect cartons from being dispatched.
• Central Library System, NED University — Barcode generation and circulation for more than 65,000 books and 11,000 members, including issue, return and reservation using Oracle 10g and Oracle Forms/Reports.
• Defense Central Library (DCL) — PDA-based physical stock taking to identify lost books, duplicate entries and uncounted inventory, with transfer of collected data to Oracle 10g.
• Pakistan State Oil (PSO) — Barcode-based physical inventory of fixed assets to trace mislocated and lost items.
• NSD — WiFi-based real-time data exchange through handheld PDAs across warehouses containing more than 300,000 inventory items, including barcode-based issue and return.
This work combined mobile application development, barcode technology, PDA-based data capture, WLAN connectivity and database integration to support accurate and traceable operational processes across automotive, textile, education, library, oil & energy, and warehouse environments.
0
43
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.
0
50
MAJU Outcome-Based Education (OBE) System
Designed and developed the database for an Outcome-Based Education system at Mohammad Ali Jinnah University (MAJU), with the frontend subsequently implemented in both PHP and C#/.NET.
The system models the relationship between:
PEO → PLO → CLO → Assessment
It provides detailed assessment of courses by CLO and PLO for individual students and supports the management of outcome-based education across university programmes.
Key areas represented
Degrees — BS, MS and PhD
Programmes
Programme Educational Objectives (PEO)
Programme Learning Outcomes (PLO)
Course Learning Outcomes (CLO)
CourseCLOAssessmentStructure
CourseCLOAssessment
Grade Sheets
Transcripts
Major programmes included areas such as Computer Science, Software Engineering, Computer Engineering, Data Science, Artificial Intelligence and Business Administration, along with Biotechnology and Bioinformatics-related programmes. Programme availability varies by degree level.
Database & Technology
Database: MariaDB
SQL: SQL
User Interfaces: PHP and C#/.NET
.NET: .NET Core, C#, Entity Framework Core, ASP.NET (http://ASP.NET) Core Identity
Reporting: RDL Reports
Supporting Tool: Excel VBA
The same MariaDB database was used by both the PHP and .NET user interfaces. The PHP version was developed earlier and was practically used with real data; the .NET Core version was developed later.
This project demonstrates database design for a complex academic information system where educational objectives, learning outcomes and student assessment are interconnected through a structured relational database.
0
52
Thesis Evaluation Management
Designed and developed a database-backed web application for managing the thesis evaluation process at an academic institution.
The system manages student and thesis information including registration number, degree/programme, thesis title, supervisor and co-supervisor. It also manages thesis submission according to prescribed templates and verification requirements, including formatting, plagiarism and other guidelines.
Students who qualify proceed to thesis defense before a panel comprising the supervisor and internal and external members. The system maintains the status of the thesis through these stages and supports final publication after successful evaluation and prescribed formatting.
My contribution: Database design and application development.
Technology: MariaDB, C#, .NET Core, Entity Framework Core, ASP.NET (http://ASP.NET) Core Identity and RDL Reports.
0
68