Data Analysis Projects in ChennaiData Analysis Projects in Chennai
Projects
People
Cover image for Optimized WordPress Database (1.2GB →
Optimized WordPress Database (1.2GB → 300MB) – Fixed Critical Elementor Issues 🚨 Fixed a Critical WordPress Database Issue (1.2GB → 300MB) A client’s Elementor website suddenly started breaking — layouts collapsing, 502 errors, and database write failures. After investigation, I found the root cause: 👉 Database exceeded hosting limit (1GB+) 👉 postmeta table alone was ~957MB 👉 Over 800MB was unused orphan data 🔍 What I did: • Analyzed database using SQL (no blind cleanup) • Identified ~94K orphaned metadata entries • Safely removed unused postmeta records • Rebuilt the table to eliminate fragmentation • Optimized database structure ⚡ Results: • Database reduced from 1239MB → ~300MB • postmeta reduced from 957MB → 20MB • Eliminated 502 errors • Elementor saving issues fixed • Site performance significantly improved 💡 Key Insight: Most WordPress issues aren’t frontend problems — they’re database inefficiencies. 🛠️ Stack: WordPress • Elementor • MySQL • SiteGround If your site feels slow or unstable, the issue might be hidden in your database 👀
4
859
Cover image for Engineered a high-performance Python-based trading
Engineered a high-performance Python-based trading signal engine designed to generate precise and reliable trade signals using multi-indicator confluence logic. The system evaluates over 12 technical indicators including RSI, EMA, ADX, Volume, and trend-based conditions to identify strong market opportunities while effectively filtering out noise and false signals. The architecture is built to process real-time market data, validate multiple conditions simultaneously, and trigger only high-probability trade setups. This significantly improves signal accuracy and reduces unnecessary trades. Key capabilities include: • Multi-indicator confluence engine (12+ conditions) • Real-time signal processing and validation • False signal reduction using layered logic • Scalable architecture for integration with trading APIs • Seamless compatibility with automated execution systems (webhooks, APIs) This system can be integrated with platforms like TradingView, Tradovate, or custom trading environments to enable fully automated trading workflows — from signal generation to execution. Designed for traders and firms looking to achieve consistent, rule-based, and emotion-free trading through intelligent automation.
2
147