SELECT FROM WHERE JOIN GROUP BY ORDER BY HAVING INSERT UPDATE CREATE

Senior Database & Reporting Specialist

Abbas
Rasool.

5+ years engineering SQL Server systems, Crystal Reports, and VB6 applications that enterprises depend on — not just run.

Query Result — 1 Row
1experience5+ years
2stored_procs50+
3reports30+
4locationKarachi, PK
5statusAVAILABLE

// about.me

01

The Engineer Behind
the Query

I've spent over five years inside the engine rooms of enterprise systems — designing databases that don't just store data, but serve it reliably at scale. My work lives at the intersection of legacy precision and modern performance: SQL Server schemas built to last, Crystal Reports that give executives exactly what they need, and VB6 applications still running mission-critical operations across industries.

I work directly with clients — from requirements gathering through production support — because good technical work starts with understanding what the business actually needs, not just what they asked for.

📅
0
Years of Experience
0
Stored Procedures
📊
0
Enterprise Reports
0
Delivery Rate
📍 Karachi, Pakistan 🎓 BA — University of Karachi ✉ abbas@abbasrasool.com 🌍 Open to Remote & On-site

// technical.stack

02

Built on Precision

SQL Server & T-SQL

95%
Complex JOINsCTEsWindow FunctionsStored ProceduresUDFsTriggersIndexesQuery OptimisationExecution PlansDynamic SQLTRY/CATCHNormalisationData MigrationSSMS

Crystal Reports

92%
Report DesignParameterisedCross-TabDrill-DownSub-ReportsFormula FieldsConditional FormatEmbedded ChartsSchedulingRDC & ActiveXSQL Data SourcesPerformance

Visual Basic 6.0

88%
Desktop AppsADOCOM/ActiveXMDI ArchitectureRDC IntegrationDynamic UIError HandlingDLL DevelopmentFile I/ORegistry OpsLegacy Refactor

Professional Capabilities

💬
Client Communication
Requirements to delivery, full cycle
🔍
Root-Cause Analysis
SQL and VB6 production debugging
📋
Technical Docs
Specs, reports, changelogs
🤝
Team Collaboration
BAs, QA, PMs
🚨
Production Support
Live triage and incident resolution

// environment.stack

03

Tools & Versions

🗄️
SQL Server
2008 / 2012 / 2014 / 2016 / 2019
SSMS
v17 — v19
📊
Crystal Reports
v8.5 / v11 / v13 (SAP)
💻
Visual Basic 6.0
SP6
🔗
ADO
2.8 — OLEDB / ODBC
🪟
Windows Server
2008 R2 / 2012 R2 / 2016
📦
SQL Server Agent
Job Scheduling & SSIS
🔧
T-SQL
ANSI SQL-92 Compliant
🖥️
COM / ActiveX
VB6 Runtime + RDC
📁
Source Control
Git / SVN

// featured.work

04

Selected Deliverables

Enterprise Financial Reporting Suite

Crystal Reports

Designed and deployed 12 interconnected Crystal Reports covering P&L statements, balance sheets, and cash flow analyses. Parameterised by date range, department, and cost centre with drill-down from summary to transaction-level detail.

Reduced monthly close reporting time by 40%
Crystal Reports v13SQL Server 2016Stored ProceduresScheduled Delivery

Inventory Management System

VB6 + SQL

Full-featured MDI desktop application for warehouse inventory tracking — stock-in/out, reorder alerts, batch-level FIFO tracking, and integrated barcode printing. Connected to SQL Server via ADO with real-time dashboard.

Handles 10,000+ SKUs across 3 warehouses
VB6 IDEADOSQL Server 2014MDI ArchitectureCOM/ActiveX

Patient Records & Billing System

Full Stack

End-to-end system for a healthcare provider — normalised patient database, appointment scheduling, prescription records, and automated billing reports. Crystal Reports integrated into the VB6 front-end via RDC for invoice and insurance claim generation.

Serving 200+ daily patient visits
SQL Server 2019Crystal Reports RDCVB6Stored Procedures

Sales Analytics Dashboard

SQL + Reports

Built a comprehensive analytics layer on top of raw sales data — complex T-SQL queries with window functions for YoY comparisons, regional breakdowns, and product performance. Cross-tab and chart-enabled Crystal Reports deliver executive summaries weekly.

Enabled data-driven decisions for 5 departments
T-SQLWindow FunctionsCTEsCrystal Reports Cross-Tab

// work.history

05

Where the Work
Got Done

Jan 2021 — Present

Senior SQL & Crystal Reports Specialist · VB6 Developer

Bestow Software Solutions, Karachi

SQL Server 2008–2019SSMSCrystal Reports v8.5–v13VB6 IDET-SQLWindows Server

// learning.path

06

Education & Credentials

Degree

Bachelor of Arts (BA)

University of Karachi

2018 — Present (Final Year)

Pursuing a broad-based arts degree while simultaneously building a 5+ year professional career in enterprise database development and reporting systems.
Certifications

Technical Proficiencies

Self-Directed & Production-Validated

Ongoing

SQL Server performance tuning, Crystal Reports advanced design, VB6 enterprise architecture. Validated through 50+ production deliverables across healthcare, manufacturing, and finance sectors.

// client.voices

07

Trusted by Teams

Abbas transformed our monthly reporting from a 3-day nightmare into a 2-hour automated process. His Crystal Reports expertise is genuinely senior-level — he understood our business logic before we finished explaining it.

FK
Farhan Khan
Finance Director, Manufacturing Co.

We had a VB6 application that three previous developers couldn't stabilise. Abbas came in, diagnosed the root causes within a week, and delivered a rock-solid version that's been running 18 months without a single crash.

SA
Sarah Ahmed
CTO, Healthcare Systems Ltd.

What sets Abbas apart is his ability to translate complex SQL performance issues into language non-technical stakeholders can understand. He doesn't just fix queries — he explains the why and prevents recurrence.

RH
Rizwan Hussain
Project Manager, Bestow Software

// get.in.touch

08

Let's Work Together

Whether you're dealing with a slow-running report, a legacy system that needs new life, or a database that needs rebuilding from the ground up — I've solved it before. I work directly with clients and I respond fast.

abbas@abbasrasool.com
📍North Nazimabad, Karachi, Pakistan
🌐Open to Remote & On-site Opportunities
Available for Projects
0 / 1000

// Response within 24 hours — guaranteed.

Message Sent!
Thank you! I'll respond within 24 hours.