Atifullah S.

Expert SQL Server admin and developer

Lahore , Pakistan

Experience: 15 Years

Atifullah

Lahore , Pakistan

Expert SQL Server admin and developer

42000 USD / Year

Immediate: Available

15 Years

Now you can Instantly Chat with Atifullah!

Chat Now

About Me

To gain maximum knowledge in the field of programming especially in database and Business Intelligence. Always looking forward for a challenge to design and develop ERP solutions with the latest Microsoft BI stack support with the combination of m...

Skills

Positions

Backend Developers

Portfolio Projects

Description

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.

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less

Description

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.