Freelancers using SQL in PunjabFreelancers using SQL in Punjab
AI Automation Engineer | Full-Stack Apps & Integrations
    $•••••
    Earned
    66x
    Hired
    4.9
    Rating
    179
    Followers
AI Automation Engineer | Full-Stack Apps & Integrations
Senior .NET Developer | ERP & SQL Server Expert
New to Contra
Senior .NET Developer | ERP & SQL Server Expert
Cover image for An imported item’s purchase price
An imported item’s purchase price is only part of its inventory cost. Transport and other related expenses also need to be allocated accurately. This Landed Cost Allocation screen is part of the custom ERP import module I developed using VB.NET (http://VB.NET) and Microsoft SQL Server. It allows users to select an import shipment receipt, allocate each expense across received items, and review the allocated total and remaining difference before finalizing. In this example, a PKR 22,000 transport expense is distributed across three items in proportion to their base values, with no unallocated balance. The module supports Base Value, Basic Unit Quantity, and Manual allocation methods, helping businesses handle different costing requirements within an integrated inventory and accounting workflow. Need a similar import-costing module or an enhancement to your existing .NET business software? Let’s discuss your requirements. #ERP #VBNet #SQLServer #InventoryManagement #LandedCost
1
1
122
Cover image for Eyecon | Optical Management System
Eyecon
Eyecon | Optical Management System Eyecon is an intelligent ophthalmic clinic and optical retail management system designed specifically for optometrists, ophthalmologists, and eyewear retail stores. The platform combines clinical eye refraction management with optical product inventory and a fully integrated point-of-sale environment, enabling clinics and optical shops to manage patient prescriptions, eyewear products, and sales operations from a single centralized system. The system maintains a complete history of patient eye prescriptions, including refractive measurements such as Sphere, Cylinder, Axis, and additional optical parameters used in professional eye testing. Eyecon incorporates intelligent logic to analyse stored prescription data and assist practitioners in determining appropriate lens power values based on previous refraction records and standard ophthalmic practices. Beyond the clinical environment, Eyecon includes a comprehensive optical retail module that manages frames, ophthalmic lenses, contact lenses, sunglasses, and eyewear accessories. The integrated inventory engine tracks product availability, product specifications, and stock movement while seamlessly connecting with the POS module used for retail sales. The POS module allows optical stores and clinics to sell eyewear products while automatically linking patient prescriptions with the appropriate lenses and frames. Sales transactions update stock levels in real time while maintaining accounting integration for financial tracking. Built as a cloud-connected Windows desktop application, Eyecon allows multiple branches or clinics to operate with a centralized database hosted on a remote server. This architecture ensures secure data storage, synchronized operations, and accessibility across different clinic locations. Key capabilities include: • Patient eye refraction record management • Intelligent prescription analysis and lens power assistance • Optical product inventory management • Integrated optical retail POS system • Prescription-to-product workflow automation • Stock tracking for frames, lenses, and accessories • Accounting and financial integration • Cloud-connected multi-clinic architecture Eyecon bridges the gap between clinical ophthalmic practice and optical retail operations, providing a unified platform that improves efficiency for eye clinics and optical businesses
0
39
Cover image for The Import
Module integrates import documentation,
The Import Module integrates import documentation, shipment management, expense accounting and goods receipts into a controlled workflow that supports accurate landed costing and inventory valuation. Project Brief overview Developed by Solution Hall, the Import Module manages the import process from initial setup and import files through shipments, expense recording and partial or full goods receipts. It distinguishes capitalizable costs from period expenses and tax-related amounts, with flexible methods for allocating eligible costs to imported goods. By linking these activities with accounting and stock records, the module strengthens financial control, improves cost visibility and provides reliable information for business decisions.
0
40
Cover image for Enterprise-Grade ERP Payroll System with
Enterprise-Grade ERP Payroll System with Automated Tax Engine, Compliance Reporting & Full Accounting Integration. This Payroll Module is a fully integrated ERP-based payroll and statutory compliance system designed for medium to large organizations. It covers complete employee master management, configurable salary structures, allowance and deduction policies, automated withholding tax calculation using fiscal-year annualization (July–June), and dynamic slab-based tax configuration. The system generates structured monthly salary sheets using a master–detail architecture with posting controls, approval workflow, and automatic accounting integration. It intelligently tracks YTD salary and tax deductions to ensure accurate mid-year adjustments and regulatory compliance. In addition to payroll processing, the module includes a comprehensive Withholding Tax Register (paid/unpaid tracking), Tax Payment Voucher system with CPR and bank instrument management, and automated generation of statutory withholding tax certificates (Rule 42 compliant). The entire module is built with strong database normalization, audit trail control, and finance integration, making it suitable for manufacturing, trading, and corporate environments requiring accuracy, transparency, and compliance-driven payroll automation. Withholding Tax Register: This module produces the Payroll Withholding Tax Register, showing employee-wise taxable salary, tax deducted, tax paid, and outstanding tax payable with flexible paid/unpaid filtering. The Withholding Tax Register module is designed for statutory reporting and tax compliance by maintaining a clear, auditable trail of payroll income tax deductions and payments. It generates an employee-wise register that includes key identity fields (Employee Name, CNIC, NTN), transaction references (date, type, voucher no., serial no.), and complete tax impact (Taxable Amount, Tax Deducted, Tax Paid, and Tax Payable). The register supports practical operational controls such as filtering by employee and cost center, and it provides separate views for Paid vs Unpaid tax. For paid entries, it applies a date range to produce period-based compliance reports, while for unpaid entries it intelligently lists all outstanding liabilities regardless of date to help finance teams track pending tax payments. By linking tax entries with tax sections and enforcing consistent section mapping, this module ensures accurate classification, improved reconciliation, and readiness for government filings and internal audits.
0
70
Hi, I'm Muhammad Abaidullah, a Full Stack Software Engineer.
New to Contra
Hi, I'm Muhammad Abaidullah, a Full Stack Software Engineer.
Cover image for | Enterprise School Management &
| Enterprise School Management & Digital Assessment System | Developed and enhanced an enterprise-grade, scalable School Management System designed to streamline academic operations, digital assessments, and institutional reporting. The system was built using Angular (TypeScript) for the frontend, .NET for backend APIs, and MySQL as the database. Key Features: Role-Based Multi-User System Principal dashboard for institutional insights, reports, and monitoring Teacher portal for generating tutorials, worksheets, and assessments Student portal for attempting quizzes, submitting responses, and tracking progress Digital Assessment & Content Management Tutorial and worksheet assignment to specific classes and sections Teacher-driven paper/quiz generation and class-level distribution Student submission workflows with evaluation tracking Advanced Reporting & Analytics Student Profile Reports and Master Reports with filtering (class, subject, date range) Teacher and Student activity history tracking Performance insights including assigned, completed, and pending work Export functionality (PDF/Excel) for institutional reporting Teacher Evaluation System Configurable assessment forms for teacher performance monitoring Structured evaluation criteria with result tracking Complaint & Feedback Management Built-in complaint portal with categorized tracking (received, satisfied, unsatisfied) Transparency in issue resolution workflows Administrative Controls Student migration between classes/sections Section and session management Teacher account and class assignment management School profile configuration and institutional settings Learning Resources Module Centralized access to tutorials and educational content for different classes Scalability & System Enhancement Refactored and optimized existing architecture for better scalability Improved performance and modularization of features Enhanced user experience across dashboards and workflows
0
68
Cover image for Developed an enterprise-grade, scalable web
Developed an enterprise-grade, scalable web application for academic institutions to manage digital paper generation and assessment workflows using Angular (TypeScript) for the frontend and .NET for backend APIs, with MySQL as the database. The system supports a complete multi-role ecosystem including Admin, Principal, Teacher, and Student portals. It enables centralized management of schools, classes, subjects, and academic content, while providing seamless paper generation, assignment, and evaluation processes. Role-based access control ensures secure and efficient operations across different user levels. Key features include: Multi-role system (Admin, Principal, Teacher, Student) Manual and automated paper generation workflows Class, subject, and school management modules Paper assignment and online quiz/assessment system Student attempt and submission tracking Principal dashboard for paper history, reports, and analytics Lesson planning and academic content organization Centralized admin controls and system configuration This project demonstrates strong expertise in full-stack development, system architecture design, and building enterprise-level academic management and assessment solutions.
0
93
Cover image for Developed an enterprise-grade, scalable web
Developed an enterprise-grade, scalable web application for real-time monitoring and management of oxygen tank fleets using Angular (TypeScript) for the frontend and .NET for backend APIs, with MySQL as the database and deployed on Microsoft Azure. The system provides live telemetry dashboards, tank inventory tracking, alarm monitoring, and user activity auditing. It includes role-based access control, configurable alert mechanisms, and detailed reporting modules to ensure operational efficiency and safety compliance. Key features include: Real-time telemetry monitoring with status classification (Normal, Warning, Critical) Tank fleet management (mobile & stationary units) Role-based permissions and user management Alarm system with notifications, response tracking, and logs Login audits and session tracking for security Cloud deployment on Azure ensuring scalability and reliability This project demonstrates strong experience in full-stack development, cloud deployment, system design, and building enterprise-level monitoring solutions.
0
90
Cover image for I developed Works ERP, a
I developed Works ERP, a complete web-based workshop management system designed to streamline inventory control, production tracking, stock movement, reporting, and administrative operations for a manufacturing/workshop environment. The system includes a full Production Module where users can issue raw materials for finished products or parts, receive production against issued batches, manage material returns, review production losses, and configure product/parts recipes. It helps maintain accurate production quantities, pending batches, received quantities, shortages, and material usage. I also implemented Reports & Stock Balance Modules including stock ledger, production summary, raw material stock balance, product stock balance, machine spare parts stock balance, and parts stock balance. These modules allow users to track item-wise stock movement, current balances, production history, quantities, prices, and total stock value with filters and searchable reports. The Admin Operations Module includes user management, permission controls, login audits, and login session tracking. It provides role-based access control, user activity monitoring, and secure permission handling for different application features. Additionally, the system includes a Drawing Module for assigning and managing drawing numbers, die numbers, revision history, and references for finished products and parts. This project was built to improve workflow accuracy, reduce manual inventory errors, provide real-time production visibility, and give management better control over workshop operations through a clean and professional web interface.
0
80
Full-Stack Engineer, AI Expert & Tech Enthusiast!
    5.0
    Rating
    22
    Followers
Full-Stack Engineer, AI Expert & Tech Enthusiast!
DevSecOps Engineer & Linux Administrator | AWS | Docker
    5.0
    Rating
    3
    Followers
DevSecOps Engineer & Linux Administrator | AWS | Docker
Cover image for The Objective: Design and deploy
The Objective: Design and deploy a fault-tolerant database architecture to eliminate single points of failure, ensure zero-downtime failover, and optimize performance for mission-critical applications. The Execution: Architected a secure 3-node PostgreSQL cluster on Linux. Configured Pgpool-II for intelligent connection pooling and read/write query routing, drastically reducing primary server load. Implemented automated health checks and failover mechanisms to ensure instant, zero-intervention replica promotion if the primary node goes down.
0
86
Cover image for Designed and implemented a CI/CD
Designed and implemented a CI/CD pipeline to automate the build, testing, and deployment process of a web application. Integrated GitHub with Jenkins to trigger automated builds on code commits. Containerized the application using Docker and deployed it to AWS EC2. This reduced manual deployment efforts and improved release consistency and reliability.
0
96
Cover image for A high-traffic SaaS client required
A high-traffic SaaS client required a comprehensive security overhaul of their production infrastructure. The goal was to systematically reduce the attack surface, mitigate vulnerabilities, and enforce strict access controls without disrupting live system performance. This project involved a top-to-bottom audit and the implementation of robust hardening techniques across the network, OS, and application layers to ensure resilience against zero-day exploits and unauthorized access
0
90
Cover image for Deployed the MindMesh full-stack app
Deployed the MindMesh full-stack app to a production-ready environment. I provisioned a secure Ubuntu 24.04 LTS server on DigitalOcean and used Docker to containerize the Node.js backend, React frontend, and PostgreSQL database. For routing, I configured an Nginx reverse proxy and managed DNS via Name.com (http://Name.com) to connect the custom domain. Finally, I implemented email authentication (DKIM, DMARC) for reliable delivery. This showcases my DevOps expertise in transforming local code into a highly secure, scalable, and live architecture.
0
94
Transforming Data into Actionable Insights 🔍
Transforming Data into Actionable Insights 🔍
Full-Stack Developer building fast, scalable web apps.
    12
    Followers
Full-Stack Developer building fast, scalable web apps.
Cover image for Laravel Visitor Personalization Platform

Developed a
Laravel Visitor Personalization Platform Developed a Laravel-based visitor personalization platform that delivers customized landing pages based on user behavior, traffic source, and campaign rules. The system dynamically displays targeted banners and promotional content while tracking visitor data such as device, browser, IP address, language, and conversions. An integrated admin dashboard allows marketers to manage campaigns, define personalization rules, monitor performance, and analyze visitor engagement through real-time analytics.
1
216
Cover image for Laravel Landing Page Variation Platform
I
Laravel Landing Page Variation Platform I developed a custom Laravel based Background Variation Management System that dynamically serves category specific landing page backgrounds and tracks visitor behavior. Built cookie based visitor identification, daily background rotation logic, multilingual routing, and analytics tracking. The platform records IP address, browser, device, language, and session data, enabling detailed performance insights. Designed a scalable architecture for managing visual experiments and improving landing page engagement.
1
181
Cover image for Shopify B2B Trade Portal with
Shopify B2B Trade Portal with Tiered Pricing & Customer Segmentation Built a Shopify B2B trade portal MVP for a luxury home-goods brand using the Dawn theme. Created a custom trade registration form that automatically tagged customers by business type and configured four groups: designers, retailers, furniture stores, and wholesalers. Integrated wholesale pricing with group-specific discounts and struck-through retail prices inside the main storefront. Set up product-access controls using customer tags, created sample product locks, resolved theme compatibility issues, and provided testing accounts and admin guidance.
0
61
Cover image for Korely Voiceperi – AI Voice
Korely Voiceperi – AI Voice Assistant Platform Developed Korely Voiceperi, an AI-powered voice assistant platform that enables businesses to create intelligent voice agents trained on their own business information. Built with React.js, NestJS, and PostgreSQL, the platform allows users to configure their business profile, knowledge base, and call handling preferences, allowing the AI assistant to answer customer calls with accurate, context aware responses. Implemented business onboarding, AI agent configuration, knowledge management, and real-time call workflows with a strong focus on scalability, reliability, and security. Integrated Retell AI for AI-powered voice call orchestration and ElevenLabs for high quality, natural sounding speech synthesis, delivering human-like conversational experiences and 24/7 automated customer support while reducing operational overhead.
2
1
307