Syed Raza Ali

WORK HISTORY

EDUCATION

ABOUT SYED RAZA ALI

A professional Solutions Architect/SQL Data Engineer/Business Intelligence Developer, delivering results by directing and managing business software and programmes, with particular experience in software development and database management. My recent roles in the Insurance, Financial, Retail, Manufacturing, Digital Media, Travel and Tourism, and Government sectors have provided me with both the technical development and analytical skills for a multitude of client requirements.• Highly experienced SQL Server and Business Intelligence Developer with comprehensive expertise across the full Microsoft SQL Server stack Demonstrated proficiency in T-SQL development, including the design and optimisation of complex stored procedures, user-defined functions, triggers, views, and advanced query logic.• Proven track record in query performance tuning and optimisation using tools such as SQL Profiler, Execution Plans, and Index Tuning Wizard. Strong background in relational database design, normalization, data modeling, and ensuring data integrity across enterprise systems.• Extensive experience in ETL processes using SQL Server Integration Services (SSIS) and legacy Data Transformation Services (DTS) for data extraction, transformation, and loading across diverse data sources. Skilled in automating workflows using SQL Server Agent, job scheduling, alerts, and package deployment.• Advanced knowledge of SQL Server Reporting Services (SSRS) for designing and delivering dynamic, parameterized, drill-down, cascading, and sub-reports, including charting and visualization using expressions, global variables, and custom functions.• Experienced in migrating legacy reports from Crystal Reports (v8.5–XI) to SSRS, and in data migration projects involving platforms such as Azure, Salesforce, and Microsoft Dynamics.• Proficient in database administration activities, including installation, upgrades, configuration, monitoring, backup strategies, and recovery operations. Strong grasp of software development life cycle (SDLC) principles, with hands-on involvement in all phases from design and development to testing and deployment.