Freelance Database Specialists in Lahore

Freelance Database Specialists in LahoreFreelance Database Specialists in Lahore

Projects People

Advancing Data Solutions

proLahore, Pakistan

AI & Data Engineer|Data & AI Architect| AWS|Azure |Snowflake

AI & Data Engineer|Data & AI Architect| AWS|Azure |Snowflake

Cover image for Oracle to Amazon RDS PostgreSQL
Designed

Oracle to Amazon RDS PostgreSQL Designed and Implemented a secure, scalable architecture to migrate an on-prem Oracle database to Amazon RDS for PostgreSQL. Data Flow: Modeled end-to-end flow, used AWS Glue (SCT) for schema conversion and DMS for full-load and CDC. Stored artifacts in S3 and loaded into RDS. Services: Glue for conversion, DMS for Migration , S3 for artifacts, and RDS as target. Security: IAM roles with least privilege, KMS for encryption at rest. HA & DR: Architected in us-east-1 with Glue, DMS, RDS, S3, and monitoring via CloudWatch.

0

209

Cover image for Batch ETL Data Warehouse Modernization
Led

Batch ETL Data Warehouse Modernization Led modernization of a legacy batch ETL pipeline into a scalable AWS-based data warehouse. Replaced manual SQL jobs with an automated system loading diverse sources into Amazon Redshift. Ingestion: Daily CSVs and API data land in S3; S3 events trigger Lambda to launch Glue Crawlers and update the Data Catalog. Transformation: Glue PySpark jobs join and cleanse sales, inventory, and customer data, apply quality checks, and move errors to a quarantine path. Output: Partitioned Parquet files stored in S3 for loading into Redshift.

0

202

Cover image for Real-Time Analytics Platform on AWS

Real-Time Analytics Platform on AWS

0

7

Cover image for Real-Time Analytics Platform on AWS

Real-Time Analytics Platform on AWS designed to ingest, process, and visualize high-volume streaming data from IoT devices and application logs. Ingestion: Device telemetry (IoT Core) and application logs are published into Amazon Kinesis Data Streams, followed by lightweight routing and enrichment using AWS Lambda. Processing & Storage: Amazon EMR performs heavy data transformations via Spark Structured Streaming, landing the curated output into Amazon S3 as partitioned Parquet files. AWS Glue then handles batch transformations before loading the data into Amazon Redshift for the analytics workload. Orchestration & Serving: AWS Step Functions coordinate the batch processing workflows. Finally, Amazon QuickSight generates actionable business dashboards while Amazon CloudWatch monitors operational metrics and alarms

0

255

Database Specialist(2)

Muhammad Asim Mughal

Lahore, Pakistan

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

111

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

39

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

62

Database Specialist(5)

proLahore, Pakistan

Full-Stack Engineer, AI Expert & Tech Enthusiast!

5.0: Rating

22: Followers

Full-Stack Engineer, AI Expert & Tech Enthusiast!

Cover image for Filmpire - Movie Discovery Platform

Filmpire - Movie Discovery Platform

0

17

Cover image for My Retire Score® — AI Retirement Readiness Platform

My Retire Score® — AI Retirement Readiness Platform

0

15

Cover image for Streamly — Bulk Meta Ads Campaign Management SaaS

Streamly — Bulk Meta Ads Campaign Management SaaS

0

20

Cover image for Gymlytic - SaaS Gym Management Platform

Gymlytic - SaaS Gym Management Platform

0

10

Database Specialist(1)

abdullah masood

Lahore, Pakistan

AI & Full-Stack Engineer | Building Production AI SaaS, APIs

New to Contra

AI & Full-Stack Engineer | Building Production AI SaaS, APIs

Cover image for 🚀 Building a Graph-Based Fraud

🚀 Building a Graph-Based Fraud Detection System with Neo4j A single transaction may look normal. Its connections can tell a different story. I’m building a learning project using Neo4j and Cypher to explore relationships between customers, accounts, transactions, and devices—and flag patterns worth investigating. 🔍 Patterns I’m exploring: • Multiple customers sharing the same device • Unusually large transactions • Rapid transactions within a short period • Multiple accounts sending money to one account • Circular transfers between connected accounts The focus is explainability: showing the relationships behind each flag so the suspicious activity is easier to understand. Through this project, I’m strengthening my graph data modelling, Cypher queries, and rule-based detection skills. Next: FastAPI integration, transaction risk scores, fraud alerts, and an interactive monitoring dashboard. 🛠️ Currently a learning prototype, with more updates coming as I build. What would you investigate first: shared devices or circular transfers? #Neo4j #GraphDatabase #FraudDetection #Cypher #BackendDevelopment #LearningInPublic

1

292

Cover image for 🚀 Introducing GraphBridge – Turn

🚀 Introducing GraphBridge – Turn JSON into Grafana Dashboards One thing I've noticed while working on different projects is that applications already have valuable metrics, but getting those metrics into Grafana often requires exporters, custom integrations, or additional setup. I wanted something much simpler. So I built GraphBridge. The idea is straightforward: Your Application ↓ Send JSON ↓ GraphBridge ↓ Prometheus ↓ Grafana Instead of writing custom exporters, your application simply sends JSON metrics to GraphBridge. For example: { "active_users": 85, "orders_today": 42, "revenue_today": 9840, "failed_jobs": 3, "latency_ms": 210 } GraphBridge automatically converts the data into Prometheus metrics, making it immediately available for Grafana dashboards. Current features ✅ JSON Webhook API ✅ REST API polling ✅ JSON & CSV data sources ✅ Prometheus /metrics endpoint ✅ Docker Compose deployment ✅ Auto-configured Grafana dashboard ✅ Example integrations for Laravel, FastAPI, Node.js, and custom applications Possible use cases • Application monitoring • Queue & background job metrics • Business dashboards • API performance monitoring • FFmpeg streaming statistics • IoT sensor metrics • Internal analytics • Custom operational dashboards The goal is simple: Send JSON. Visualize everything. This is the first public MVP, and I'm planning to continue improving it with additional integrations and monitoring templates. I'd love your feedback and suggestions! ⭐ GitHub: https://lnkd.in/dAYdNJxg

1

212

Cover image for A Kubernetes deployment should be

A Kubernetes deployment should be easy to trace: what changed, who changed it, and why. That’s what interests me about GitOps. With GitOps, the desired state of your infrastructure and applications lives in Git. Changes go through commits and pull requests, while a controller such as Argo CD or Flux continuously reconciles the running environment with that desired state. A typical workflow looks like this: • Build and test the application through CI. • Push the Docker image to a registry. • Update the image version in the Git configuration. • Review and merge the change. • Let the GitOps controller reconcile the cluster. The benefits go beyond automated deployments: ✅ A versioned history of configuration changes ✅ Reviewable changes before deployment ✅ Visibility into configuration drift ✅ A repeatable way to manage environments One important detail: reverting a Git commit can restore an earlier configuration, but database migrations and changes to application data still need their own recovery plan. For me, GitOps connects development and operations through a workflow both teams already understand: Git. Are you using Argo CD, Flux, or CI-driven deployments for your Kubernetes workloads?

1

298

Cover image for Production Kubernetes & Cloud Deployment

Production Kubernetes & Cloud Deployment

1

250

Database Specialist(1)

Lahore, Pakistan

No Code Developer

New to Contra

No Code Developer

Cover image for NestFind is a rental property

NestFind is a rental property listings platform built in Bubble. Landlords can post properties and tenants can browse, filter by location, price, and bedroom count, and contact landlords directly. I handled everything from database design to UI and workflow logic. Features include dynamic listings, availability status, contact forms, and a fully responsive layout for desktop and mobile. Built using repeating groups, conditional visibility, dynamic filtering, and multi-role data handling — core Bubble skills clients look for.

0

39

Cover image for Designed a premium dark-themed website

Designed a premium dark-themed website UI for a pain management and orthopedic clinic. The design features a bold hero section ("Step into a Pain-Free Future"), a stats bar, a trusted specialists section, a comprehensive "Our Benefits" services grid, a "Why Choose Us" section with spine imagery, star-rated patient testimonials, an appointment booking form, and a newsletter footer. A dark background with gold/amber accents was used to convey professionalism, authority, and trust in the medical space.

0

59

Cover image for :Designed a full-page telemedicine website

:Designed a full-page telemedicine website UI for a virtual healthcare platform. The design includes a hero section with a strong CTA, stats bar, "Who We Are" and "Why Virtual Care" sections, a services carousel, a 5-step "How It Works" flow (sign-in to prescription), emergency care banner, patient testimonials, and a newsletter footer. The layout uses a teal/white color scheme for a clean, professional medical aesthetic with a focus on user trust and easy appointment booking.

0

47

Cover image for Matrimonial App

Matrimonial App

0

4

Database Specialist(1)

Lahore, Pakistan

Full Stack Dev | ASP.NET, Angular, SQL Server

Full Stack Dev | ASP.NET, Angular, SQL Server

Cover image for Motor Vehicle Registration System (MVRS) Development

Motor Vehicle Registration System (MVRS) Development

0

4

Cover image for Digital SME Lending Platform Development

Digital SME Lending Platform Development

0

9

Cover image for Real-Time Vehicle eAuction Platform Development

Real-Time Vehicle eAuction Platform Development

0

8

Placeholder project card media

View more →

Database Specialist(1)

Lahore, Pakistan

Software Engineer

Software Engineer

Cover image for E-challan System

E-challan System

0

18

Cover image for Hotel Management System

Hotel Management System

0

10

Cover image for hannangujar - Overview

hannangujar - Overview

0

7

Placeholder project card media

View more →

Database Specialist(3)

Lahore, Pakistan

Expert Web & AI App Developer with a Qualified Team

Expert Web & AI App Developer with a Qualified Team

Cover image for FeedbackSync.ai - AI Project

FeedbackSync.ai - AI Project

0

29

Cover image for Craftly.ai

0

28

Cover image for Web Dashboard Tools

Web Dashboard Tools

0

32

Cover image for YOGF

0

23

Database Specialist(1)