Search This Blog

My CV




Atif-ullah Sheikh

                            
Objective
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 my experience, knowledge and expertise.

Working Experience

















































































































































































































































































































































Education









               
Program Architect
Feb 2015–ToDate          The Resource Group, Lahore

Major Responsibilities are as under;

§  Bot Development using SIML, C# and WCF with SQL Server 2012 as Database to maintain chat log and user Surveys.
§  Lead Development team to Plan, design and implement new modules in the current system.
§  Lead Database team to Plan, design and implement the database design and Scripts for data migrations, up-gradations and new implementations.
§  Design and Implement Multi-lingual Cube with Dynamic Dimension Security and SSAS Stored Procedures
Implementing Complex Hierarchies in the Cube as per the requirement of the client.
§  Design and Implement ETL and Views to develop SSAS Cube
§  Lead the team of developers to develop In-house BI Application and Cube browser.
§  Implementing Query Optimization techniques for faster response on application end.



Database Consultant / Architect – Microsoft Practice
Nov 2013–Jan 2015       Ovex Technologies, Lahore

Major Responsibilities are as under;

§  Design and Implementation of High Availability solutions for SQL Server 2012 / 2008 R2 with Windows Cluster and AlwaysOn Availability Group.
§  Conduct Client Demos for HA / DR solutions of SQL Server with Azure as a part of the solution.
§  Troubleshooting already deployed SQL Servers
§  Design and development of Secure BI Semantic Models in Analysis Services
§  Prepare training material for utilizing BISM with Excel using PowerPivot and PowerView
§  Research on upcoming technologies and business areas like Big Data and HDInsight. Deep knowledge of MS Big Data, HDInsight cluster and MapReduce Jobs.



Assistant Director Projects / Team Lead Database Department
Jan 2008–Oct 2013        Valentia Technologies / F3 Technologies  

Major Responsibilities are as under;

§  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


Major Projects in F3 Technologies
TCP OPAT Solution

§  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.

Business Intelligence CareMonX ePCR Suite - NHS Client

§  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

BI CareMonX ePCR Suite -  PHECC And Dubai Client

§  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

Business Intelligence InnovaCare

§  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

CareMonX ePCR Suite for NHS, PHECC, Dubai Ambulance. Czech and Zagreb

§  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.

Fleet Management System for FALCK

§  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

Duty Planning System for FALCK

§  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.


CareMonX ePCR Dynamic Model

§  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

CareMonX ePCR SAAS Model

§  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

InnovaCare Home Worker Attendance System (IVR)

§  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.

TCP Hemophilia Drug Management System

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

Heart File Donation Management System

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

Warfarin Drug Management System

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

Clinic Management System

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

Employee Management System

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

Mail Merge System

§  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.
§  Database Design and Development of Log-Book Management System

Generic Auditing in SQL Server via Service Broker

§  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


SQL Server Administration

§  Analyzed, Designed and Implemented the Policies related to the Database Backups, Recoveries and Disaster Planning.
§  Planning and Implementation of Clusters, Database Mirroring, Log Shipping and Data Migrations.
§  Implementation of BLOCKKK for database encryption.
§  WMI Alerts
§  SQL Server Jobs scheduling
§  Designed and developed Data Auditing tool using Service broker

Achievements in F3 Technologies
§  Above The Best Support Team Award For the Year 2011 - 2012
§  Above The Best Project Lead Award For the Year 2011 - 2012
§  Microsoft Community Contributor Award 2011 from Microsoft
§  Winner of Above the Best Software Engineer Consolation Award (2009-2010).
§   Part of the Winning Team of Best Team award (2009-2010) for delivering the project on tight deadline.


Asst. Manager MIS.
Jan 2003–Dec 2007       Askari Leasing Ltd.                        Rawalpindi

Major Responsibilities are as under;

§  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.

Major Projects and Achievements in Askari Leasing Ltd.

Lease Business Suite

§  Design, Development and Implementation of Lease Business Suite.
§  Implementation in 5 branches of Askari Leasing Ltd.

AskLife Consumer Finance System

§  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

AskHome House Finance System

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

ASKAR ACBL Corp

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

Deferred Tax System

§  Design and Development of Deferred Tax System.

Others

§  Design, Development and Implementation of different projects for the Finance, Treasury, Credit, Recovery and Customer Services Department.



Senior Programmer
Jan 2000–Dec 2002       Cygnet IT Consultants                    Rawalpindi

§  Programming is the Primary Job. Responsibility to lead the team of three developers. Also prepare the technical reports of the system and design documents of the software and make/suggest changes if necessary.

Major Projects and Achievements as Senior Programmer
§  Textile Mill Automation.
§  Holiday Planning Software. Deals in Booking and reservations of Hotels, Flights, Car Hire, Tours and Cruises.
§  Sales, Purchase and Inventory System for the local Market.
§  Customer Services Support System Development.



MBA in Finance and IT
University of Arid Agriculture, Rawalpindi

§  Completed my MBA as a regular student with Job in Askari Leasing Limited.
§  Received an Appreciation Letter and cash prize from the Management for achieving the degree with CGPA 3.2


Bachelor of Computer Science.
The National College, Rawalpindi

§  Received a shield for the Final Project of Real Time Systems.
§  Received a certificate for the Project of Software Engineering.


Bachelor of Arts.
Punjab University, Rawalpindi.



Skills


Languages
Visual Basic 6, Visual FoxPro 7,Delphi 5/6,  Java and Borland C and Basic Exposure to VB.NET, ASP.NET and C#
Report Writers
SQL Server Reporting Services, Crystal Report 5/7/8 and Report Builder 5 for Delphi 5/6.
Databases
SQL Server 2000 / 2005 / 2008 /2012, SQL Azure, Inter Base 6, MS-Access,  FoxPro, Oracle
Platforms
Hyper-V, Windows Azure, Windows 8, Windows Server 2012, Windows XP, Windows 9x, Windows 2000, Windows NT, Linux (Red Hat version).
Web Development
Web Services, ASP, XML, HTML, DHTML, VB Script, JavaScript and ASP.NET
Applications
MS Word, MS Excel, MS PowerPoint, MS Visio
Networking
Sufficient knowledge of LAN, WAN and  VPN 
Others
A quick learner of new technologies
Web address
Publications at SQLServerCentral.com
MS Transcript
Transcript ID: 975864
Accsee Code: atifsheikh1977