My Work

Project Portfolio

A curated selection of database, IT infrastructure, and web management projects.

🗄️
Database
Insurance Policy Database Overhaul
Complete redesign of the insurance policy management database schema at Sun Nepal Life Insurance. Improved data normalization, reduced redundancy, and enhanced query performance for 500,000+ policy records.
SQL Server 2019 T-SQL Schema Design Data Migration
SQL Server
Database Performance Optimization
Analyzed and optimized slow-running queries in the claims processing module. Implemented proper indexing strategies and rewrote inefficient stored procedures, achieving 60% reduction in report generation time.
Query Tuning Execution Plans Index Optimization SSMS
💾
Database
Automated Backup & Disaster Recovery
Designed and implemented an automated backup strategy using SQL Server Agent jobs. Established full, differential, and transaction log backup schedules with off-site storage integration, reducing RTO to under 2 hours.
Backup Strategy SQL Agent Disaster Recovery PowerShell
🌐
Website
Corporate Website Content Management
Managed and updated the Sun Nepal Life Insurance corporate website, including policy product pages, agent portals, regulatory disclosures, and digital marketing content. Improved content structure and SEO performance.
CMS Management SEO HTML/CSS Content Strategy
📊
SQL Server
Financial Reporting Dashboard (SSRS)
Built a comprehensive SQL Server Reporting Services (SSRS) dashboard for financial and actuarial teams. Automated premium collection reports, claims analysis, and policy lapse tracking with scheduled delivery.
SSRS T-SQL Business Intelligence Report Design
🖥️
IT Support
IT Infrastructure Upgrade Project
Led company-wide hardware and software refresh across 80+ workstations. Coordinated vendor management, deployment scheduling, Active Directory migration, and end-user training with minimal disruption to business operations.
Active Directory Windows Server Network Setup Vendor Management
🔐
Database
Database Security & Compliance Audit
Conducted a comprehensive database security assessment covering user access controls, SQL Server login auditing, data encryption at rest, and regulatory compliance alignment for insurance data protection requirements.
Security Audit TDE Encryption Role-Based Access Compliance
📱
IT Support
SunConnect App UAT & System Testing
Performed user acceptance testing for the SunConnect mobile application. Identified critical bugs including data loss on edit operations, documented issues systematically, and coordinated fixes with the development team.
UAT Testing Bug Reporting QA Process Mobile App
📝
Website
Digital Policy Portal Content
Developed and maintained the online policy product pages and digital forms for customer self-service. Improved user experience, updated policy descriptions, premium calculator content, and agent information pages.
Content Management UX Writing Digital Forms Insurance Portal

Professional Gallery

Screenshots and snapshots from professional work and projects.

Interested in Working Together?

I am open to database consulting, IT support projects, and full-time opportunities. Let's discuss how I can help your organization.