Projects using Microsoft SQL Server in KarachiProjects using Microsoft SQL Server in KarachiA self-service portal that lets a freight forwarder's customers prepare
their own shipping documents online, instead of emailing drafts back and
forth.
The old process: a customer emails their shipping instructions, the
forwarder's documentation team keys them into a draft Bill of Lading, emails
a PDF back, the customer spots a typo, and the loop repeats. Every round
trip is a chance to get a consignee address wrong.
Now the customer logs in and drafts it themselves. They fill the House Bill
of Lading or Air Waybill form directly — shipper, consignee, routing,
flights, charges — save it as a draft, edit it as many times as they need,
copy a previous shipment for a repeat booking, and print a draft PDF to
check. When they submit, the record locks, becomes read-only, and a
generated PDF goes to the documentation team.
Multi-tenant, so each customer sees only their own documents.
Built with C# / ASP.NET (http://ASP.NET) and SQL Server. 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. Inventory Management System to help businesses manage stock and operations with ease. The system includes modules for categories, products, stock history, customers, and suppliers, along with purchase and sales orders to keep track of transactions. It also features detailed reports and analytics, plus a chart of accounts and accounting tools to manage finances in one place. A smart assistant is included to answer queries, generate quick reports, and provide useful suggestions. This system brings everything together to save time, improve accuracy, and make day-to-day management simpler. A web platform that replaced a paper-and-email credit approval process with
a tracked digital workflow.
Before it, a customer's credit request moved through the company as a form
that got signed, scanned, emailed and chased. Nobody could answer "where is
it right now?" without phoning three people.
The system turns that into a seven-level sequential approval chain — sales
person raises the request with the limit, terms, financials and supporting
documents; it moves through sales head, branch accounts, branch head, head
office, SBU head and finally corporate approval. Each level sees exactly
what it needs, every action is timestamped and attributed, and stakeholders
are notified by email as it moves. On final approval the credit facility
goes live automatically.
It also generates the PDF reports management uses to review exposure across
branches.
Built with C# / ASP.NET (http://ASP.NET) and SQL Server. 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. 
