ExpertSoftware Development

SQL

Expert
15 projects · 6 companies

Applied advanced SQL across Oracle, PostgreSQL, MySQL, and SQL Server for CRM systems, data warehouses, and analytics platforms. Optimized complex queries, designed normalized schemas, and built stored procedures handling millions of records daily.

I applied advanced SQL across Oracle, PostgreSQL, MySQL, and SQL Server for CRM systems, data warehouses, and analytics platforms. Complex queries, normalised schemas, and stored procedures handled millions of records daily with sub-second response times.

Query optimisation was a recurring challenge. I used execution plans, index analysis, and query rewriting to reduce slow queries from minutes to seconds. The most impactful optimisation was often adding the right composite index, which could reduce a query from 60 seconds to 200ms.

Data warehouse design followed dimensional modelling principles, with star schemas optimised for analytical queries. The design enabled self-service BI, as business users could query the warehouse without needing to understand the underlying transactional schema.

At FLIR Systems, Lorex Technology, and 1C Platform, I applied advanced SQL across Oracle, PostgreSQL, MySQL, and SQL Server for CRM systems, data warehouses, and analytics platforms. The query optimisation using execution plans, index analysis, and query rewriting reduced slow queries from minutes to seconds, with composite indexes providing the most impactful improvements.

At FLIR Systems, the data warehouse design followed dimensional modelling principles with star schemas optimised for analytical queries, enabling self-service BI for business users. The stored procedures at 1C Platform and Lorex handled millions of records daily with sub-second response times for the e-commerce and surveillance platforms.

Explore the Full Portfolio

This is the complete portfolio of Sufi Khan Sulaiman, a technology leader specialising in B2B commerce and digital automation. Start from the Home page for the overview, then move through two decades of career experience across FLIR Systems, Lorex Technology, and 1c Platform, and the full catalogue of project case studies spanning headless commerce migrations, AI recommendation engines, and multi-channel fulfilment systems.

The skills and certifications page maps the technical and leadership capabilities behind the work, while the articles and the knowledge base break down the thinking into actionable frameworks. For hands-on learning, the tutorials and applications sections cover practical builds from front-end fundamentals to full-stack web apps.

For consulting engagement, the expertise page outlines service offerings, the ecommerce hub covers platform architecture and automation strategy, and the ecommerce guide (PDF) is a downloadable 55-page field manual. When you are ready to talk, the contact page is the direct line.