Work for a small IT contracting company (IPSQL) to provide SQL Server and PostgreSQL assistance. Looking to provide services surrounding PostgreSQL verisons > 9.6 and SQL Server > 2000. Can provide the following services: - Migrating from On-Prem to Cloud (AWS/Azure) - Upgrading via Lift and Shift or In-Place. - SQL Server Database Administration ranging from 2000 to 2022. - PostgreSQL Upgrades ranging from 9.6 to 14. - Backup configuration - PostgreSQL/SQL Server - Performance tuning of both SQL Server and Postgres. - Log Analysis - High Availability Solutions for both SQL Server and PostgreSQL. - Replication/Log shipping provisioning. - SQL Server / Postgres Server Configuration setup to include best practices. - Can undertake on either Linux or Windows. Am also available looking to provide on-call servicing for small-medium businesses. Can provide a free 30 minute session to discuss your business needs. Contact me on +44 7477 686243 or via email at ianporritt@googlemail.com

MS Access and VBA developer with 10+ years of experience designing, fixing, and enhancing desktop database applications. I specialize in reports, automation, SQL-backed systems, and maintaining or modernizing legacy MS Access databases for businesses. I help clients replace spreadsheets, fix broken databases, automate workflows, and generate accurate reports using MS Access, VBA, and SQL Server. My focus is on reliability, performance, and easy-to-use solutions that work without complex setups. What I can help you with: Custom MS Access database development Fixing errors, bugs, and performance issues in existing Access databases Automated reports, invoices, and label printing Barcode and QR code integration (inventory, attendance, tracking) MS Access frontend with SQL Server backend Data automation, validation, and optimization Multi-user LAN deployment and shared databases Examples of systems I have built: Hospital and clinic management systems Inventory and stock control databases with barcode scanning Quoting and invoicing systems Attendance and asset tracking solutions Donation, fund, and record management systems Reporting and forecasting tools using Access and SQL Why clients choose me: Over 10 years of hands-on MS Access and VBA experience Strong focus on fixing and improving existing systems Clear communication and practical solutions Cost-effective alternatives to expensive software Long-term support and maintenance If you need an MS Access or VBA developer to build, fix, or improve your database, feel free to message me to discuss your project.

Senior Full-Stack Developer | AI Engineer | SQL Server & Azure Architect — 13+ Years I build intelligent, production-grade systems end-to-end: AI agents, full-stack web applications, enterprise data warehouses, and Azure cloud infrastructure. Over 13 years I've shipped platforms that handle real money, real users, and real data at scale — across mortgage servicing, legal tech, real estate, and automotive. Most developers do AI or full-stack or databases. I do all three at a senior level, which means I can architect AI systems that actually scale — with proper data layers underneath, real observability, and infrastructure that holds up in production. ━━━━━━━━━━━━━━━━━━━━ WHAT I'M BEST AT ━━━━━━━━━━━━━━━━━━━━ 🔹 AI / LLM Engineering Anthropic Claude (SDK, tool calling, prompt caching, MCP server development), OpenAI embeddings, Google Gemini, RAG pipelines, vector/semantic search, multi-agent orchestration. I build autonomous systems — not chatbot wrappers. 🔹 Full-Stack Web Development Java/Spring Boot, Node.js/Express, Next.js 15 + TypeScript, React, Vaadin, WebSocket streaming UIs, Stripe, OAuth 2.0, real-time progressive rendering. 🔹 SQL Server & Data Architecture Microsoft Certified Professional. Query tuning (execution plans, DMVs, Extended Events), indexing strategy, Always On AG, TDE, partitioning, full-text indexing. Enterprise data warehouses using Inmon methodology with ETL pipelines integrating 30+ concurrent sources. 🔹 Azure Cloud Infrastructure Stood up a complete Azure environment from scratch for a mortgage company: hybrid identity (Entra ID), VPN Gateway, SQL Managed Instance, AVD/FSLogix, Functions, App Services, DevOps CI/CD. Cut cloud costs 30% through PowerShell automation. ━━━━━━━━━━━━━━━━━━━━ RECENT PROJECTS ━━━━━━━━━━━━━━━━━━━━ Autonomous AI Agent Orchestration Platform (2026) Custom MCP server with 15+ tools built on the Claude Agent SDK. SQL Server-backed shared agent memory bank with hybrid search and quality scoring. Claude agents autonomously browse sites, write and test extraction scripts, coordinate workflows, and persist institutional knowledge across sessions — fully unattended. Car-Search.ai (2025) Full-stack automotive search platform indexing 50,000+ UK dealer listings. AI-powered natural-language search using OpenAI embeddings stored in SQL Server. Interactive Leaflet.js map with 1,100+ dealers and proximity radius filtering. Stripe-backed Pro subscription tier with split-panel AI chat. Real-time WebSocket conversation engine with Claude tool-calling. BriefMaker (2025) AI-powered appellate brief drafting system for Florida attorneys, grounded in verified primary sources. Scraped case law from the Florida Supreme Court and all five DCAs plus 1,013+ statute chapters. PDF appellate record ingestion with full-text indexing. Prompt-cached Claude analysis, template-based brief structure, real-time streaming output. Leonard Legal Platform (2026) Complete tech stack for a Florida law firm: 100+ geo-targeted SEO pages, Clio practice management OAuth integration with auto token refresh, Stripe consultation booking, Java/Spring Boot document management app, and social media automation across Facebook and Google Business Profile. Realty Software Solutions (2024) RESO Data Dictionary-aligned real estate platform with real-time MLS sync, RAG-powered property enrichment, Spring Boot + Vaadin application, OAuth 2.0 multi-provider auth, and recursive AI-driven web scraping. Oceanside Mortgage (2021–2023) Zero-downtime migration of mission-critical SQL Server databases and BytePro LOS to Azure SQL Managed Instance. Inmon-methodology enterprise data warehouse with SSIS/SSRS. CRM-to-BytePro middleware via Azure Functions. Direct mail campaign management application. ━━━━━━━━━━━━━━━━━━━━ TECH STACK ━━━━━━━━━━━━━━━━━━━━ Languages: Java, JavaScript, TypeScript, Python, C#, T-SQL, PowerShell Backend: Spring Boot, Node.js, Express, Next.js 15, Django, Vaadin, REST, WebSocket Frontend: React, Next.js, Tailwind CSS, real-time streaming UIs AI: Anthropic Claude SDK, MCP, OpenAI, Gemini, LangChain, LlamaIndex, RAG, vector search Database: SQL Server 2012–2025, Azure SQL, SSIS, SSRS, CLR assemblies, dimensional modeling Cloud: Azure (Entra ID, AVD, Functions, App Services, SQL MI, Monitor), AWS, GCP DevOps: Git, Azure DevOps, CI/CD, PowerShell, Linux, Windows Server Automation: Puppeteer, Playwright, headless browser orchestration Security: OAuth 2.0, RBAC, AES encryption, Stripe, MFA, Conditional Access ━━━━━━━━━━━━━━━━━━━━ HOW I WORK ━━━━━━━━━━━━━━━━━━━━ I treat software like a fiduciary responsibility. My code runs where bugs cost money, violate regulations, or affect real people's lives — mortgage compliance, legal filings, payment processing. Expect clean architecture, SOLID principles, thorough testing, and clear written communication. I'm comfortable owning a project end-to-end or integrating into your existing team. I write honest estimates, flag risks early, and don't disappear mid-project.

I’m a Machine Learning & Deep Learning Engineer specializing in Computer Vision and NLP, building production-ready systems for image, document, and text automation. I help businesses extract value from images, scanned documents, and unstructured text using reliable ML solutions. With a Computer Science degree, I apply strong software engineering fundamentals to deliver accurate, maintainable ML systems — not just experiments. 🔹What I Can Help You With • Computer Vision – image classification, object detection, visual inspection • OCR & Document Processing – invoices, forms, PDFs, scanned documents • Natural Language Processing (NLP) – text classification, information extraction, text analytics • Deep Learning Models – CNNs, sequence models, attention-based architectures • End-to-End ML Pipelines – data → model → evaluation → deployment 🔹 Relevant Work • Built OCR + NLP pipelines for extracting structured data from documents • Developed computer vision models for real-world image datasets • Implemented NLP models for classification and text extraction • Designed ML pipelines optimized for performance and scalability 🔹TOOLS & TECH Python, NumPy, Pandas Scikit-Learn TensorFlow, PyTorch OpenCV, YOLO CNN architectures NLP pipelines, text preprocessing Model deployment (API-ready)

I am a Database Developer with over 15 years of experience specializing in MS Access, VBA, SQL Server, MySQL, and Django. I build custom database applications, web-based systems, and desktop solutions that help businesses automate workflows and manage data efficiently. I focus on delivering scalable, optimized, and secure database solutions tailored to business needs. ** Core Skills * MS Access Development * VBA Programming & Automation * SQL Server (T-SQL, Stored Procedures, Performance Optimization) * MySQL Database Design & Administration * Django Web Development (Python Backend) * Database Design, ERD, Normalization * Data Migration & Data Conversion * API Integration * Reporting & Dashboards * Bug Fixing & Database Optimization ** Services I Offer * Custom MS Access Database Development * Convert MS Access to Web Applications (Django / SQL Server / MySQL) * Build Web-Based Database Systems using Django * SQL Query Optimization & Performance Tuning * Database Design & Architecture * Fix Slow, Broken, or Legacy Databases * Data Import/Export, ETL, and Automation * Multi-user Database Systems ** Why Clients Hire Me * 15+ years of real-world database development experience * Strong understanding of business workflows and data structures * Clean, maintainable, and scalable solutions * Fast communication and reliable delivery * Long-term support and improvements

𝗜 𝗱𝗲𝘀𝗶𝗴𝗻 𝗲𝗻𝗱-𝘁𝗼-𝗲𝗻𝗱 𝗱𝗮𝘁𝗮 𝘀𝘆𝘀𝘁𝗲𝗺𝘀 𝘁𝗵𝗮𝘁 𝘂𝗻𝗶𝗳𝘆 𝗳𝗿𝗮𝗴𝗺𝗲𝗻𝘁𝗲𝗱 𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗶𝗻𝘁𝗼 𝗿𝗲𝗹𝗶𝗮𝗯𝗹𝗲, 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻-𝗴𝗿𝗮𝗱𝗲 𝗶𝗻𝗳𝗿𝗮𝘀𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲. Whether you are battling 12-hour query runtimes, migrating legacy silos, or building an AI-ready data lakehouse, I provide the architectural strategy and engineering rigor required to scale. With 20+ years of experience delivering high-stakes production systems for global brands like Apple, Overstock, and Medline, I move beyond task-based support to own your technical roadmap. As the Managing Director of ADLAB Solutions, I lead a vetted engineering bench capable of scaling delivery across Data Engineering, AI/ML, and UI/UX—ensuring your stack remains a growth driver, not a bottleneck. ──────────────────────────── 📊 THE IMPACT (By the Numbers) • 1B+ Rows modeled cleanly with 99.9% pipeline uptime. • 35% Avg. Reduction in Snowflake/Cloud compute costs through refactoring. • 150+ Dashboards delivered with 70% latency improvement. • 30+ Hours/Week saved per client through metadata-driven automation. ──────────────────────────── 🛠️ ARCHITECTURAL FOCUS AREAS • Warehouse Modernization & Migrations: Specialized in Teradata/SQL Server → Snowflake, BigQuery, or Fabric. I focus on zero-downtime cutovers and "Set-Based" design to maximize cloud-native performance. • Metadata-Driven ELT/ETL Pipelines: Building idempotent, self-healing pipelines (dbt, Airflow, Matillion, ADF). I design systems that handle schema drift automatically to protect downstream AI and BI models. • AI & Agentic Data Foundations: Architecting semantic layers for Snowflake Cortex, RAG-powered knowledge assistants, and predictive "Nowcasting" systems that combine high-frequency signals with broad benchmarks. • Analytics Engineering & BI Governance: Shipping governed Power BI, Tableau, and Sigma environments. I fix the "Broken Trust" in numbers by implementing Row-Level Security (RLS) and centralized metrics definitions. • Real-Time & Managed Services: CDC patterns for sub-minute freshness (Kafka, GoldenGate) and ongoing SLA-based infrastructure monitoring and administration. ──────────────────────────── 🎯 TRUSTED BY Apple • Teradata • Medline • Overstock • Bed Bath & Beyond • Salt Lake Bees • Poppi • Utah Jazz ──────────────────────────── ✅ THE ADLAB ADVANTAGE • Enterprise Governance: Experienced with remote workstations (VDI), M365/Google security protocols, and HIPAA/regulated environments. • Strategic Roadmap: I identify technical debt and map a cost-efficient architecture. • Managed Delivery: My team executes the build with senior-level oversight. 𝗜𝗳 𝘆𝗼𝘂𝗿 𝗱𝗮𝘁𝗮 𝘀𝘁𝗮𝗰𝗸 𝗶𝘀 𝗳𝗮𝗶𝗹𝗶𝗻𝗴 (𝘂𝗻𝗿𝗲𝗹𝗶𝗮𝗯𝗹𝗲 𝗿𝗲𝗽𝗼𝗿𝘁𝘀, 𝘀𝘁𝘂𝗰𝗸 𝗺𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻𝘀, 𝗼𝗿 𝗿𝘂𝗻𝗮𝘄𝗮𝘆 𝗰𝗹𝗼𝘂𝗱 𝗰𝗼𝘀𝘁𝘀), 𝘀𝗲𝗻𝗱 𝗺𝗲 𝘁𝗵𝗲 𝗱𝗲𝘁𝗮𝗶𝗹𝘀. 𝗜’𝗹𝗹 𝗽𝗿𝗼𝘃𝗶𝗱𝗲 𝗮 𝗯𝗿𝗶𝗲𝗳 𝗿𝗲𝗳𝗲𝗿𝗲𝗻𝗰𝗲 𝗮𝗿𝗰𝗵𝗶𝘁𝗲𝗰𝘁𝘂𝗿𝗲 𝗮𝗻𝗱 𝘁𝗲𝗹𝗹 𝘆𝗼𝘂 𝗲𝘅𝗮𝗰𝘁𝗹𝘆 𝗵𝗼𝘄 𝘄𝗲’𝗹𝗹 𝗳𝗶𝘅 𝗶𝘁.

I help organizations streamline operations, automate business processes, and build scalable solutions using SharePoint and Microsoft 365. My focus is simple: reduce manual work, improve collaboration, and create systems that are secure, structured, and easy to maintain. I have hands-on experience designing and supporting SharePoint Online environments, building custom Power Apps, and developing automated workflows with Power Automate. I work across both business and technical layers — from user-friendly interfaces to backend integrations and governance models. What I Work With - SharePoint Online & On-Premise environments - SharePoint Framework (SPFx) development - SharePoint REST API & Microsoft Graph API integration - Custom intranet portals and modern Hub sites - Power Apps (Canvas & Model-Driven apps) - Power Automate (Cloud Flows & Desktop RPA) - Dataverse & custom connectors - Document management systems with structured metadata - Role-based permission architecture (RBAC) - Microsoft Entra ID (Azure AD) integration - Governance, compliance & retention policies - SharePoint migrations (On-Prem to Microsoft 365) - Tenant-to-tenant migrations - Power BI dashboards & reporting - SQL Server & enterprise data integration - Microsoft Teams integration Solutions I’ve Delivered - Multi-level approval and document routing systems - Enterprise intranet portals with modern architecture - Workflow automation that reduces manual processing - Task and staffing management applications - Custom CRM-style internal systems - Secure document libraries with lifecycle management - Reporting dashboards for leadership teams - Automated business process solutions using Power Platform My Approach I build solutions that are: - Scalable and future-ready - Secure and compliant - Optimized for performance - Designed for user adoption - Structured with long-term governance in mind I don’t just develop features — I design complete Microsoft 365 solutions that align with business goals and support long-term digital transformation. If you’re looking for someone who understands both the technical depth and the business side of SharePoint and Power Platform, I’m ready to help.

Hi👋 I help businesses turn scattered marketing and business data into automated dashboards and reporting systems that improve decision-making. Whether it's PPC, SEO, social media, CRM, e-commerce, Digital PR or multi-client reporting, I build analytics solutions that replace spreadsheets with clear, actionable insights. My services include - ✅ Building marketing and business dashboards for Google Ads, Meta Ads (Facebook & Instagram), GA4, Shopify, WooCommerce, Klaviyo, HubSpot, Google Search Console, SEO, social media, CRM, and multi-client reporting using Looker Studio, Tableau, and Power BI. ✅ Building centralized data warehouses in BigQuery, MySQL, and Snowflake by integrating APIs, ETL/ELT pipelines, CRMs, e-commerce platforms, marketing platforms, and spreadsheets into a single source of truth. ✅ Validating data quality, completeness, and consistency across multiple data sources to improve reporting accuracy, reconcile KPIs, and build confidence in business metrics. ✅ Developing automated reporting systems that generate daily, weekly, monthly, quarterly, and yearly reports for marketing performance, executive reporting, client reporting, and operational analytics with minimal manual effort. ✅ Creating business intelligence dashboards and interactive visualizations that track KPIs across PPC, SEO, paid social, e-commerce, CRM, sales, and customer analytics, transforming complex data into clear, actionable insights. ✅ Analyzing marketing and business performance to identify growth opportunities, optimize advertising spend, improve ROAS, increase operational efficiency, and support data-driven decision-making. ✅ Forecasting business trends and building predictive models using Python for sales forecasting, demand planning, customer behavior analysis, budgeting, and business performance prediction. Some trusted brands I've worked with include - ⭐ Localbird Airbnb Rentals Company - Designed and implemented an ETL pipeline and centralized reporting system in BigQuery, integrating live data from WooCommerce, Dokan, and HubSpot. Developed executive dashboards in Looker Studio using complex SQL queries to monitor bookings, revenue, host performance, website visits, conversion rates, new sign-ups, and other operational KPIs. ⭐ Vysta Paid Media Group - Built an automated Google Ads → BigQuery → Looker Studio reporting pipeline using SQL, enabling stakeholders to monitor advertising spend, revenue, ROAS, and campaign performance across multiple client accounts through a centralized dashboard. ⭐ Zerabox Services - Developed a Looker Studio marketing analytics reporting template, integrating Google Ads, Microsoft Ads, and GA4 data to evaluate campaign effectiveness, advertising spend, conversion performance, and overall marketing ROI. ⭐ Originality.ai Led a Digital PR research project by collecting and analyzing five years of LinkedIn long-form posts using Python and Google Sheets to identify AI-generated content trends, engagement patterns, and content performance. The research was later published by WIRED. ⭐ Thinking Heads Group - Developed interactive Tableau dashboards to visualize survey responses for Banco de Crédito e Inversiones (BCI), Chile, helping stakeholders measure brand reputation, customer perception, and public sentiment through survey score analysis. ⭐ Coolmore Logistics - Enhanced an existing Tableau dashboard by implementing dynamic Month-to-Date (MTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) functionalities, improving reporting flexibility, visual appealing and making operational insights more meaningful. ⭐ Housenumbers - Built SQL-powered reporting solutions and interactive Google Looker Studio dashboards to monitor mortgage loans, lending activity, closed and open files, close rates, and other key business performance metrics. ⭐ FATJOE Supported multiple Digital PR campaigns as the Data Analyst through data collection, web research, data analysis, and performance reporting, providing writers and marketing teams with reliable, data-backed insights. I'm open to discussing your business projects, turning complex data into simple reporting systems that are reliable, scalable and long-term for better decision making. Hit me up, my response rate is less than 4 hours. I look forward to working with you! 😎

When enterprise organisations face critical data architecture decisions where mistakes could cost hundreds of thousands, they need senior technical judgment backed by proven business impact. I combine 20+ years of data engineering expertise with Financial Controller business experience to provide strategic guidance that prevents expensive errors before they happen. Companies hire me when they need someone who's navigated complex technical challenges before and can guide critical architecture decisions. My dual AWS/PostgreSQL expertise plus business background means I understand how technology decisions affect your bottom line. I focus on strategic advisory work where more than 20 years of experience and business judgment prevent expensive mistakes. Companies hire me when they need someone who's navigated complex technical challenges before and can guide them through critical architecture decisions where errors could cost hundreds of thousands. MY TECHNICAL BACKGROUND: I've spent recent years working extensively with AWS cloud architecture - S3, Lambda, Glue, Redshift, Kinesis, API Gateway. I'm also deeply experienced with PostgreSQL optimization, database architecture, and building data pipelines that perform reliably at scale. Other technical areas: Infrastructure as Code with Terraform, real-time data processing, database performance tuning, and Python development for data engineering workflows. WHAT I DO FOR CLIENTS: My clients hire me to prevent expensive architecture mistakes through strategic technical guidance. I focus on three critical areas where senior judgment delivers immediate ROI: - Strategic AWS Cost Analysis - Identify 20-30% operational savings before costly migration decisions - PostgreSQL Performance Risk Assessment - Prevent database bottlenecks that could cost hundreds of thousands in downtime - Technical Due Diligence - Provide independent evaluation for major infrastructure investments and M&A decisions I don't just solve technical problems - I understand how architecture decisions affect your bottom line. My dual background in data engineering and business (Financial Controller experience) means I can translate complex technical risks into clear business impact. Companies typically engage me when they're facing critical scaling decisions, evaluating major cloud investments, or need senior technical judgment for high-stakes architecture choices where mistakes could be catastrophic. WHAT MAKES ME DIFFERENT: I bring 20+ years of real-world experience solving complex data engineering challenges. My background as a Financial Controller means I understand how technical decisions impact business operations, budgets, and ROI requirements. I don't just deliver technically sound solutions - I ensure they make business sense. I've been through enough technology cycles to know what works and what doesn't. My Financial Controller background gives me direct experience with financial data systems, regulatory reporting requirements, and the data integrity standards financial institutions demand. I understand financial workflows, audit requirements, and the critical nature of financial data accuracy. I work with companies that need senior technical judgment for important decisions, not basic implementation work. WHEN TO CALL ME: - You're planning a major AWS migration and want someone who's prevented expensive mistakes before - Your PostgreSQL database needs optimisation and you want strategic solutions, not quick fixes - You're making technical architecture decisions worth significant investment and want experienced guidance - You need senior technical judgment for critical decisions where mistakes could cost hundreds of thousands I work with companies that need senior technical advisory services where 20+ years of experience and business understanding make the difference between success and expensive failures.

An experience IT professional with high energy and drive along with strong Technical and Analytical skills. A truly self motivated and energetic performer with an upbeat, positive attitude. Having ability to make decisions, be accountable, exceed goals and achieve high-quality results. Committed to professionalism, highly organized, able to see the big picture while paying attention to small details. With a strong knowledge on Azure cloud services like SQL Database, Azure Fabric, Synapse Analytics, Analysis Service, Data Factory, Databricks, Storage Account, App Services and Automation Account. Specialties Technologies : SQL Server, Azure SQL, Synapse Analytics, Azure Fabric, Oracle, MySQL, Data Factory, Data Bricks, Storage Account, Logic App, App Service, PowerShell.