• Design and Implement Multi-lingual Cube with Dynamic Dimension Security and SSAS Stored Procedures in SQL Server 2012 and SQL Server 2016
• Design and implement the database design and Scripts for data migrations, up-gradations and new implementations in SQL Server 2012 and SQL Server 2016.
• Implementing Complex Hierarchies in the Cube as per the requirement of the client.
• Design and Implement ETL and Views to develop SSAS Cube in SQL Server 2012 and SQL Server 2016
• Analysis of IRs and CRs. Writing RCAs for the incidents and suggest permanent solutions
• Implementing Query Optimization techniques using ColumnStore Indexes and In-Memory OLTP in SQL Server 2016 Standard edition for faster response on application end.

• Analysis, Design and development of Cube on InnovaCare data
• Design and develop ETL process for Cubes
• Design complex jobs for data loading in SQL Server Integration Services
• Daily and Weekly Reports email to the Management

• Manage the database department and the team of experienced and professional database administrators
• Designing and Implementing HA / DR solutions like Failover Clusters, Database Mirroring and Log Shipping.
• Design and Analysis for BI solutions and centralized Reporting solutions.
• Full utilization of MS BI stack for efficient and timely deployments for complex cubes and ETL Processes.
• Monitoring the database department performance and take necessary steps to increase the performance and technical abilities of the DBAs within the department.
• Requirement Analysis, Database Designing , Development and Capacity Planning
• Design and Implementing Data Synchronization strategies between Client / Database Server and Database Server / Reporting Server
• Defining and Implementing strategies for Backup / Recovery of Data files and Log files to get the point-in-time recovery
• Preparation of Documents related to the Database Department
• Presentations and trainings to junior resource
• Writing Complex Stored Procedures, functions and queries to implement the business logic of the clients
• Query Optimization and Performance Tuning
• Writing CLR Procedures and Functions
• Implementation and Support for Service Broker in SQL Server 2005 for asynchronous messaging between database servers
• Suggestions to Developers on performance of the applications
• Other SQL Server Administration Tasks Mirroring, Log Shipping and Replication
• Developing Cubes on the clinical dataset of the company using SQL Server Analysis Services and Excel for Enhanced reports
• Design and implementation of Reports in SQL Server Reporting Services for OLTP and OLAP datasets

• Design, Development and Implementation of AskLife Consumer Finance System. Running successfully in all Branches of Pakistan
• Awarded with a DVD Player for the fastest and successful development and Implementation of AskLife. Running successfully in all Branches of Pakistan

• Involved in complete Software development Life Cycle including Analysis and Initiating Technical Design Documents.
• Database Designing and Development
• SQL Server Administration including Backup, Recovery, Log Shipping and Replication.
• Designing and implementing complex Stored Procedures, Views, Triggers and User defined Functions.
• Implementation and support to team members for Database High Availability Solutions and Disaster Recovery Plans.
• Optimization of complex queries and processes.
• Data conversion using DTS and self written T-SQL Scripts.
• Coordinating with different departments to ensure timely and accurate processing of data and related issues.
• Involved in Development and Implementation phase of Lease Business Suite. Lead a team of four programmers and involved in the coordination with top management for Requirement Analysis and Other issues.
• Having sound knowledge of Finance, Treasury, Credit, Recovery and Customer Services.
• Develop sophisticated Programs to get and resolve client queries. Provide information about Re-Structuring of Leases and Revised Rentals of their Lease.

Implementation of BI Semantic Model (BISM) as per the requirement of the client for interactive analysis and reporting. Real time data synchronization between different web based and desktop systems to apply business workflow using Service Broker Technology of SQL Server. Real time Data Movement Monitoring system for the client for up-to-date case statuses and existence in applications stack. Design and development of Centralized Reporting Database instead of making different reports on different databases. Report models in SSRS for client based reports.

Analysis, Design and development of Cube on ePCR data for IOW Design and develop ETL process for Cubes Design complex jobs for data loading in SQL Server Integration Services Daily and Weekly Reports email to the Management

Analysis, Design and development of Cube on ePCR data for Dubai Design and develop ETL process for Cubes Design complex jobs for data loading in SQL Server Integration Services Daily and Weekly Reports email to the Management

Complete BI solution including SSIS packages for ETL and Cubes for Interactive reports. KPIs for Business performance Indicators. Analysis and Re-designing a Normalized ePCR Suite to support multi-language and for better performance. Database Analysis and Design of Dynamic rule based roster management system. Enhancements in CareMonX Admin Application for rule based duty roster and Inventory. Designing of Complex clinical Reports Weekly and Daily Reports email to the Management Design and Implementation of complete logic of single Key methodology between Dispatcher, ePCR, CareMonX Admin and CareMonX Monitoring application.

Database Design and Development of Fleet Management System with prompt alerts using Service Broker and Query Notification Features. FMS system integration with Computer Aided Dispatch System and Duty Management System

Database Design and Development of Duty Planning System. Integration with Inventory Management System and Fleet Management. System integration with Computer Aided Dispatch System and Fleet Management System.

Analysis and designing of ePCR Dynamic Model Suite database. Implement complex logic for parsing Dynamic XML data and in load it in the CareMonX Database for reports. Designing of Complex clinical Reports

Analysis and designing of ePCR SAAS Model Suite database. Implement complex logic for saving data in one common database for different Clients. Tested successfully in different events of Oxygen, e-Picnic, National Ploughing Championship, Marlay Park and Open Golf Killarney Designing of Complex clinical Reports

Design and development of database for InnovaCare IVR system. Data synchronization between IVR and Admin database using Service Broker. Design the logic for Attendance and task mapping.

Database analysis and design. Database design review and updating for optimization. Data migration.

Database analysis, design and development of Donation management and assessment system. Design and developed reports to meet the business requirements.

Database Analysis and Design of Warfarin drug management system. A Mobile SMS Based project. Query Optimization and full database Audit using Service Broker

Database analysis, design and development of Clinic Management System. Integration with CareMonX Inventory System.

Database Design and Development of Employee Management System of the Company. Accounts System is also integrated to generate basic Accounts reports.

Database design and Implementation Mail Merge System for BIZNAV. Runtime query creation with more than 200 criteria created and processed at runtime. Fully optimized with more than 70 columns as bookmarks in the result.

Generic Data Auditing Script for SQL Server 2005 using Service Broker. This facility is provided on demand to the Client. Implemented in major projects of the Company

Design, Development and Implementation of AskLife Consumer Finance System. Running successfully in all Branches of Pakistan Awarded with a DVD Player for the fastest and successful development and Implementation of AskLife. Running successfully in all Branches of Pakistan

Design, Development and Implementation of AskHome House Finance System. Implemented 14 Amortization schedules related to house financing system.

Design, Development and Implementation of ASKAR ACBL Corp. System. Running successfully in all Branches.

Design and Development of Deferred Tax System.

Deals in Booking and reservations of Hotels, Flights, Car Hire, Tours and Cruises.