Syed Raza A.

Database Optimization Expert

690 dollar
Freelancer
20 years
Ripon, UNITED KINGDOM

My experience

Frazer-Nash ConsultancyMarch 2019 - Present

More

Endsleigh Insurance Services LtdSeptember 2018 - March 2019

Responsibilities:
•    Rejoined Endsleigh Insurance Services to help them designing and building Business Intelligence architecture.
•    Worked with MI Transformation team as Senior Developer.
•    Designed and created MI reports for Senior Leadership Team.
•    Worked on designing new data warehouse. Created SSIS packages for ETL
•    Improved the performance by tidying up code in existing stored procedures and views.
•    Created Tabular, Matrix, Parameterized, Drilldown and Drill through reports.

Technologies Used: SQL Server 2014-2016 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, TFS, GIT and Windows Server 2012.
More

All Response MediaJune 2018 - August 2018

Responsibilities:
•    Created ERD to design normalise data structure.
•    Created Normalised table structure.
•    Created stored procedure to move data from non-normalised to normalised tables.
•    Over 10 billion of records have been moved to normalised tables that has significant impact on performance improvement as well as on server disk space.
•    Worked on Power BI and SSRS reports to create analytics reports for multitude of clients.
•    Improved data import process using SSIS packages.
•    To improve disk management created ndf files onto different hard drives and move across data by dropping and creating clustered indexes on large tables.

Technologies Used: SQL Server 2014-2016 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, Power BI, TFS, Windows Server 2012.
More

Endsleigh Insurance Services LtdAugust 2017 - May 2018

Responsibilities:
•    Worked with MI Transformation team as SQL Server specialist to migrate data from IBM DB2 legacy database to SQL Server 2016.
•    Proposed and implemented SQL Server Reporting Services to fulfil company’s reporting requirements.
•    Created MI Report project in SSDT
•    Redesigned and created SSRS reports to migrate/transform IBM Cognos reports.
•    Deployed SSRS reports on SQL Reporting server.
•    Created Teams and Groups on Active Directory to assign relevant access to different departments.
•    Created complex Matrix and Tabular SSRS reports for management.
•    Created Dashboard and KPIs Reports for different departments including SLT, marketing and pricing teams.

Technologies Used: SQL Server 2014-2016 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, TFS, GIT and Windows Server 2012.
More

IGDMarch 2017 - July 2017

Responsibilities:
•    Designed and created SSIS packages to integrate data between CRM and DNN web application.
•    Setup and maintain database backups using RedGate Tools.
•    Created SSRS reports for management and different departments including Finance, Sales and Analyst Team.
•    Created Dashboard report using Google Analytics.
•    Created web order healthcheck reports to check web orders against CRM.
•    Proposed and created automated data archiving process to archive web application event logs.
•    Improve the performance by tidy up code in existing stored procedures and views.
•    Created necessary indexes to improve data retrieval process.
•    Maintain existing databases and resolve day to day queries.

Technologies Used: SQL Server 2012-2014 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, TFS, RedGate Tools and Windows Server 2012.
More

Johnson MattheyOctober 2016 - March 2017

Responsibilities:
•    Created and maintained disaster recovery maintenance plans on all database servers.
•    Created SSRS reports for production and quality control.
•    Created production plants downtime reports for management to see the performance of each plant.
•    Proposed and created automated data archiving process.
•    Tidy up code in existing stored procedures and views to improve the performance.
•    Maintained Wonderware Information Server for reporting.
•    Created and conducted presentations to brief management for different database projects.

Technologies Used: SQL Server 2012-2014 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, TFS and Windows Server 2012
More

Merkle | DBGApril 2016 - September 2016

Responsibilities:
•    Maintain and enhance existing ETL (SSIS packages).
•    Monitor and bug fixes of daily feed files. Containing huge data over a million records in a file.
•    Improve coding standards and performance tuning of existing stored procedures.
•    Developed Feed File Validation using SSIS package with C# Script Tasks.
•    Design data flow diagrams for big clients.
•    Conducted presentation for data flow and security measures for KPMG auditors.

Technologies Used: SQL Server 2012 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, MS Visual Source Safe and Windows Server 2012.
More

Greenwich Leisure LtdMarch 2016 - April 2016

Responsibilities:
•    Working on a data migration project. Migrating data from IRIS Payroll system (Earnie) to HR Core system.
•    Created File format documents to extract database as per the requirement.
•    Created SSIS packages for ETL to migrate data from source to destination.
•    Designed and developed SSIS Packages to import/export data from MS Excel, SQL Server and Flat files.

Technologies Used: SQL Server 2012/2008 R2 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, MS Visual Source Safe and Windows Server 2012
More

Entity UKJanuary 2016 - March 2016

Responsibilities:
•    Have successfully completed a data migration project. Migrated data from legacy system to a new bespoke system.
•    Created SSIS packages for ETL to migrate data from source to destination.
•    Implemented SSRS reporting services.
•    Created custom and parameterized reports using SSRS.
•    Designed and developed SSIS Packages to import/export data from MS Excel, SQL Server and Flat files.
•    Have written complex SQL Queries, Stored Procedures, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Technologies Used: SQL Server 2012/2008 R2 Enterprise Edition, SQL Server Data Tools (SSDT), SSIS, SSRS, TSQL, MS Visual Source Safe and Windows Server 2012.
More

Fundraising Initiatives LimitedJanuary 2015 - October 2015

Responsibilities:
•    My role Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source to destination systems. The project involved designing a new database schema, migrating data from SQL Server 2008 R2 to SQL Server 2012, performing analysis and then generating various types of reports.
•    Have successfully completed data migration project where the data from legacy system SQL Server 2008 R2 migrated to SQL Server 2012. Have written SSIS packages for ETL processes and used data transformation to map the data correctly between the databases.
•    Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures.
•    Wrote efficient stored procedures for the optimal performance of the system.
•    Monitored performance and optimized SQL queries for maximum efficiency.
•    Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
•    Created indexed views and appropriate indexes to reduce the running time for complex queries.
•    Generated custom and parameterized reports using SSRS. Created reports that call sub reports in SSRS.
•    Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
•    Actively involved in developing Complex SSRS Reports, Matrix/Tabular Reports, Charts and Graphs.
•    Responsible for creating datasets using T-SQL and stored procedures.
•    Used various transformation tasks to create ETL packages for data conversion. Created several packages in SSIS.
•    Responsible for rebuilding the indexes and tables as part of performance tuning.
•    Used SQL Server Agent for scheduling jobs and alerts.
•    Transformed data from MS SQL Server 2008 R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
•    Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients
More

Workplace Giving UK LtdJuly 2012 - December 2014

Workplace Giving UK helps employees and employers support good causes in the most tax-efficient way by giving directly from their pay.
My responsibility was to ensure all new project requirements are fulfilled and to maintain all deliverables. I was also responsible to co-ordinate all development.
Responsibilities:
•    Introduced MS SQL server reporting services and SQL server integration services within the organization.
•    Managed the migration of large complex datasets from legacy systems using ETL.
•    Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SSRS.
•    Generated Reports using Global Variables, Expressions and Functions for the reports.
•    Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes.
•    Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
•    Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.

Technologies Used: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008,.NET Framework, C#, ASP.NET,CSS,T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2012.
More

Premier Contact LimitedMarch 2010 - June 2012

Premier Contact is part of the award winning Fundraising Initiatives Limited. PCL provide a range of telephone fundraising services; from new acquisitions, re-activations and upgrades, through to lottery player recruitment. Package options are tuned to the requirements of the campaign, no project is too small.
Responsible for the database analysis, design as well as management. The database designed to manage charities’ profile, contracts, charges and campaigns for a diverse range of clients and having experience of the full development lifecycle.
Responsibilities:
•    Introduced MS SQL server reporting services and SQL server integration services within the organization.
•    Analyzed & designed the business rules for data cleansing.
•    Extracted data using SSIS packages (ETL) from different server locations and data sources.
•    Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
•    Deployed generated reports of each quarter onto the Report Server to access it through browser.
•    Responsible for generating annual reports based on the growth of sales with respect to customers.
•    Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T_SQL code and SQL joins for applications.

Technologies Used: MS SQL Server 2008, Reporting Services (SSRS), Integration Services (SSIS), Microsoft Performance Point Server 2007, T-SQL, MS Access and Excel, Visual Source Safe.
More

Fundraising Initiatives LimitedJune 2007 - February 2010

Fundraising Initiatives work with charities and non profit organizations in the UK and overseas to increase their supporter bases, boost their donor income and develop new revenue streams. Fundraising Initiatives operates in different countries like USA, Canada, Spain, Holland, Ireland and Sweden.

Responsibilities:
•    Introduced MS SQL server reporting services and SQL server integration services within the organization.
•    Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
•    Upgraded SQL Server 2000 databases to 2005, using Detach/Attach, Backup & Recovery and by Replication.
•    Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
•    Involved in requirements gathering, analysis, design, development, deployment and user training.
•    Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
•    Understood an existing system and designed modifications to the system to support new requirements.
•    Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.

Technologies Used: SQL Server 2005/2008 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008, C#, T-SQL, Windows 2003/2008 Server, XML, MS Excel, MS Access.
More

Seven Technology LtdNovember 2006 - June 2007

Seven Technology is one of Merseyside’s leading software houses. Seven specialize in developing Microsoft based solutions - enabling clients to streamline their ICT systems and develop more efficient business practices.

Responsibilities:
•    Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
•    Determined the SQL Server Installation. Installed SQL Server Management tools.
•    Physical Implementation of database into SQL Server 2005 using T-SQL.
•    Created check constraints to maintain data integrity.
•    Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
•    Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
•    Data migration (import & export/BCP) from Text to SQL Server.
•    Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
More

S.I.Education Society (UK)November 2004 - October 2006

•    Managed the requirement gathering, analysis, design and development of the MIS System of S.I.E.S. (VB.Net, C#, ASP.Net and SQL Server)
•    Developed 5 applications: Invoice Management System, Accounts Receivable Statements, Accounts Payable Management System, Job Information Management System and Employees Information. The system is designed to maintain, Generation of Monthly Salary, Maintain field force employees’ daily allowances, maintains the leaves of employees and around 50 reports etc.
•    Responsible for the development of the official website of the Society (using JavaScript, HTML, Adobe Photoshop, Front Page)
More

Nortel NetworksMarch 2002 - July 2004

•    Responsible for the scope, specifications, timelines, deliverables and cost of the IT & Billing department supporting the GSM 900 project for PTML.
•    Managed the requirement gatherings, ordering, development and commissioning of all the IT systems and corresponding hardware.
•    Liaised with vendors, clients & development teams to ensure the on time and on cost delivery of systems. Designed and maintain project and budget monitoring spread sheets in Ms Excel.
•    Designed, developed and managed POS (Point of Sale System) using VB.Net, ASP.Net with SQL Server.
•    Formulated the processes and methodologies for design, delivery, testing, acceptance and support.
•    Responsible for designing and implementing new prepaid and postpaid packages, whilst keeping the existing packages up to date regarding current market trends.
•    Handled the queries from various different departments.
More

NetProsysFebruary 2001 - February 2002

•    Conducted the analysis, design as well as development of financial software (General Ledger, Trading, Order Management and Budgeting) and web applications for a diverse range of clients and having experience of the full development lifecycle.
•    Supervised development team (4 to 6 developers) as well as managing existing projects.
•    Conducted Visual Basic 6, Ms Access, Excel training courses for trainee programmers and internees.

My stack

Analysis methods and tools

Design Patterns

Open Source solutions

DNN

Embedded and Telecom

Telecommunications

Others

Project Management, Management, Data analysis, Performance tuning, Database Design

Technologies

Web Services, CRM

Languages

ASP.NET, Visual Basic 6, T-SQL, SQL, JavaScript, OOP, ASP, HTML, C#, XML, VB.NET

Databases

Database Administration, Microsoft SQL Server 2005, Microsoft SQL Server 2016, Transact-SQL, SQL Server, SQL Server 2005, Microsoft SQL Server, SQL Server 2008

Computer Tools

MS Office

Web Analysis and Statistic

Google Analytics

Environment of Development

Visual Studio, Visual Studio 2012

Frameworks

.NET

Multimedia

Adobe Photoshop

Business Intelligence

Power BI, Crystal Reports, Data Warehouse, ETL, SSRS, SSIS

My education and trainings

Microsoft Certified Programmer - IIT

MS Computer Science - Engineering - Preston University1998 - 2000

B.Com (Bachelor of Commerce) - Accounting, Auditing, Economics - Karachi University1994 - 1997