Apu Patra
πŸ‘‹

Welcome! I'm Apu Patra

Web Developer  Β·  WordPress Expert  Β·  Database Admin
Based in Kolkata, West Bengal, India

πŸ†
20+
Years Exp.
πŸš€
100+
Projects
🌐
10+
Live Sites
πŸ€–

Apu's AI Assistant

Online β€” Ask me anything
πŸ‘‹ Hi there! I'm Apu's AI assistant. I can answer questions about his skills, projects, experience, and how to hire him. What would you like to know?
Just now
Apu Patra

Apu Patra

Web Developer Β· WordPress Expert
Database Administrator Β· Kolkata

Available for Freelance
🟢 Available for Freelance

Apu
Patra

Web Developer · WordPress Expert · Data Admin

20+ years of database mastery fused with modern web development. Building powerful WordPress solutions and pixel-perfect frontends for clients across India.

0
Years Exp.
0
Projects
0
Live Sites
Apu Patra
Apu Patra
Kolkata, West Bengal, India
WordPress PHP JavaScript MySQL Figma
🏆
WordPress Expert10+ live websites
📊
20 YearsDatabase Admin
About Me

Building Digital Experiences

I'm a Database Administrator with 20+ years of expertise in post-exam result processing, OMR data analysis, student RTI handling, and large-scale data reporting for government institutions across India.

I've combined this deep data expertise with modern web development skills β€” building WordPress plugins, responsive frontends, and complete digital solutions. I use AI-driven prompt engineering to accelerate development.

As a freelance developer, I've launched 10+ live websites for clients spanning paramedical, interior design, catering, and travel industries.

📍

Location

Ramchandrapur, Kolkata - 700104

📞

Phone / WhatsApp

+91 80173 98335

✉️

Email

apupatra2009@gmail.com

💼

Availability

Open for freelance & full-time

Experience

Professional Journey

Full-Time · 20 Years

U.M.C Technology Pvt. Ltd.

Data Administrator · 2005 – Present
  • MSME-registered software company serving central & state government educational and recruitment departments
  • Managed post-exam result processing, OMR data analysis, student RTI handling & reporting
  • Collaborated with Burdwan University, Jadavpur University, JEXPO, NMMS, MAKAUT, Kolkata High Court
  • Expert-level FoxPro 9, SQL, MySQL, MS Access for large-scale data management
Freelance · Ongoing

WordPress & Web Development

Freelance Developer · 2023 – Present
  • 10+ production-ready websites for clients in education, hospitality, travel, interior design
  • Custom WordPress plugins — billing systems, video downloaders, exam tools, PDF generators
  • Responsive frontends with HTML, CSS, Bootstrap-5, JavaScript, jQuery & React
  • SEO optimization, Figma UI/UX design, and ongoing client support
Portfolio

My Projects

Client · Paramedical NGO

SSMT Skill Institute

Custom billing plugin with token auth, receipt generation, WhatsApp sharing & Excel export.

WordPressPHPPlugin Dev
Client · Interior Design

Shades Luxury Interiors

Premium interior website with custom WP theme, portfolio gallery & luxury aesthetic.

WordPressCustom ThemeUI/UX
Client · Catering

Red Letter Catering

Crossfade hero slider, animated counters, mobile canvas menu — dark & light versions.

HTML/CSSJavaScriptAnimations
Client · Travel Agency

Subha Yaatra Holidays

SEO-optimized travel website with tour pages, gallery sliders & JSON-LD structured data.

WordPressSEOJSON-LD
Personal · Auto Dealership

Car Selling & Services

Fully responsive dealership site with Bootstrap-5, jQuery & AOS animations.

Bootstrap-5jQueryAOS
Personal · IT Company

IT Solution Website

Modern IT company website with Bootstrap-5, AOS Animation — fully responsive.

Bootstrap-5AOSResponsive
Personal · E-Commerce

E-commerce Website

Responsive shop UI built with HTML, CSS, Bootstrap-5, jQuery and JavaScript.

HTML/CSSBootstrap-5jQuery
Personal · UI/UX Design

Mobile App UI Design

Figma prototype with complete interactive mobile UI/UX design and navigation flow.

FigmaUI/UXPrototype
Client · Medical Equipment E-Commerce Store

Institute Of Health Wellness

Responsive shop UI built with Wordpress Woocommerce Themes.

WordpressWoocommerce ThemesRozo Pay Payment Getway
Client · Catering

Swastick Catering

Crossfade hero slider, animated counters, mobile canvas menu — dark & light versions.

WordpressElemontertContact Form
AI-Powered Development

Vibe Coding

Vibe Coding is my personal approach to modern software development β€” where I describe what I want to build in plain language, and AI tools help me generate, iterate, and refine the actual code in real time. Instead of spending hours searching documentation, I focus on ideas, logic, and outcomes.

I combine my 20+ years of domain expertise in databases, government data systems, and web platforms with AI tools like Claude, ChatGPT, and Copilot to turn complex requirements into working applications at a fraction of the traditional time. The result? Production-ready systems delivered faster, with fewer bugs, and more client satisfaction.

Every project below started as a conversation β€” an idea or a client problem β€” and became a fully functional, live application through structured AI-assisted development cycles. From concept to deployment, I handle the architecture, review every line of logic, and ensure each product meets real-world requirements.

01
Understand

Deep-dive into client needs & define clear requirements

02
Prompt

Craft precise AI prompts describing logic & structure

03
Review

Audit generated code, fix edge cases, refine output

04
Deploy

Test live, gather feedback, iterate to perfection

πŸ€–Claude AI πŸ’¬ChatGPT πŸ–₯️VS Code + Copilot ⚑Cursor IDE 🎨Figma AI 🌐WordPress
Web Tools Platform · Vibe Coded

GoAndUse β€” Online Tools Hub

A comprehensive collection of everyday web utilities β€” built entirely through AI-assisted development. Users can access multiple productivity and utility tools without signing up, directly from the browser. The entire platform was designed, structured, and deployed using vibe coding workflows, iterating rapidly from prompt to working product.

HTML/CSS JavaScript Claude AI Vibe Coding
Launch App β†—
Office Management System · Vibe Coded

SMF Mail Tracking System

A full-featured office letter & file tracking system built for the State Medical Faculty of West Bengal. Manages incoming mail (R-XXXX diary numbers), dispatch records (D-XXXX format), chain-forwarding between departments with stage tracking, auto-fill subject linking, and finalization flags β€” all accessible via a front-end admin panel without touching the WordPress dashboard.

WordPress Plugin PHP MySQL JavaScript Claude AI
Launch App β†—
Institutional Web Platform · Vibe Coded

SSMT Space

An institutional web platform built with a vibe coding approach β€” translating complex institutional requirements into a clean, user-friendly digital experience. The project demonstrates how AI-assisted development can produce polished, professional results for real clients with tight timelines, using iterative prompting and rapid prototyping cycles.

WordPress PHP Bootstrap ChatGPT Vibe Coding
Launch App β†—

Expertise

My Skills

Frontend

HTML & CSS95%
Bootstrap 590%
JavaScript72%
jQuery75%
React65%

Backend & Database

SQL / MySQL92%
PHP70%
FoxPro 995%
MS Access95%

Tools & Platforms

WordPress95%
Figma / UI-UX78%
Adobe Photoshop70%
AI Prompt Eng.85%
Google AdSense & SEO

AdSense Approved & On-Page SEO

Google AdSense βœ“ Approved

I built QuestionPaperHub.com β€” a dedicated portal for Bengali-medium students and educators across West Bengal β€” offering free access to previous years' question papers, model sets, and exam resources. The site was carefully planned from day one with AdSense eligibility in mind.

Every page was crafted following Google's content quality guidelines β€” original, helpful, well-structured content that genuinely serves users. Within a short time of launch, the site earned full Google AdSense approval β€” a testament to clean code, solid on-page SEO, proper navigation, and authentic content value.

On-page SEO was implemented thoroughly: keyword-rich title tags, optimised meta descriptions, structured H1–H3 hierarchies, internal linking, fast page speed, mobile-first design, and semantic HTML throughout. Search engines can crawl, understand, and rank every page with ease.

Unique, original content for every exam & subject page β€” no duplicate or thin content
Proper meta title & description tags targeting high-intent student search queries
Clean URL structure β€” readable slugs, logical category hierarchy
Optimised heading hierarchy (H1 β†’ H2 β†’ H3) on all pages for clear content structure
Internal linking between related exam papers β€” boosts crawl depth & page authority
Mobile-first, fast-loading pages β€” Core Web Vitals optimised
Google Search Console & Analytics integrated for performance tracking
AdSense ad units strategically placed β€” policy-compliant, non-intrusive layout
questionpaperhub.com
QuestionPaperHub Website
AdSense Approved
πŸ“„
100+
Question Papers
🎯
SEO
Fully Optimised
πŸ’°
Ads βœ“
AdSense Live
πŸ”

Keyword Research & Targeting

Identified high-volume, low-competition Bengali student search terms β€” exam names, board names, subject combinations. Each page targets specific, intent-matched keywords that students actually search for on Google.

🏷️

Meta Tags & Title Optimisation

Every page has a unique, keyword-rich title tag (50–60 chars) and a compelling meta description (150–160 chars). Click-through rates are maximised by writing tags that match search intent and stand out in SERPs.

πŸ—οΈ

Content Structure & Headings

Semantic HTML with proper H1 β†’ H2 β†’ H3 hierarchy on every page. Content is grouped logically so both users and search engine crawlers understand the topic, sub-topics, and page purpose instantly.

⚑

Performance & Core Web Vitals

Optimised images (WebP, lazy loading), minified CSS/JS, proper caching, and a clean mobile-first layout. Fast load times and high CWV scores are maintained, directly supporting both rankings and AdSense eligibility.

Learning

Education & Certifications

🎓
2000

Higher Secondary Education

W.B.C.H.S.E — West Bengal

Completed with honours in Business Administration & Accounts.

💾
2009

Computer Application Course

Brainware Computer Academy

4-month program covering VB.Net and MS Access database management.

🗄️
2005 – Present

Enterprise Database Mastery

20 Years Professional Practice

Deep hands-on expertise — MySQL, FoxPro 9, SQL, OMR data analysis at institutional scale.

🌐
2024 – 2025

Web Design Certification

Moople Institute — 18-Month Program

HTML5/CSS3, JavaScript, PHP, Bootstrap, React, WordPress, UI/UX, Figma, Adobe tools.

Get In Touch

Let's Work Together

Have a project in mind? WordPress website, custom plugin, data solution, or a full web presence — I'd love to hear about it. Based in Kolkata, available for remote and on-site projects across India.

📞

Phone / WhatsApp

+91 80173 98335
✉️

Email

apupatra2009@gmail.com
📍

Location

Kolkata, West Bengal — 700104
✅ Message sent! I'll reply soon.