Sql Server Information Technology
Resume:
Hasham Bin Niaz [pic]
Address : R-**, Sector **-A-2, Buffer Zone, North Nazimabad
Karachi, Pakistan
Email Address : ******.****@*****.***
Skype : hashamniaz
Phone Number : +92.333-***-****
Career Objective
To pursue a Team Lead position in a progressive and well reputed
organization offering professional working environment coupled with
opportunities of growth and development, also to work with a team and
provide motivation in order to contribute towards the success of the
organization
Professional Experience
March 2013 - BI Consultant
Till Present Royal Cyber (Pvt.) Ltd, Pakistan
Industry Information Technology / Software
Services
Projects BI solutions for multinational clients
using MS SSAS 2012, Share Point 2013, Performance
Point Services, Power View, MS Reporting Services
ETL solutions for multinational clients,
provide data warehouse solutions using MS SSIS
Job Role Developed customized BI solution using MS
SQL Server, MS SSAS as backend layer & Share Point
2013, Performance Point Services, Power View & MS
SSRS as front end layer for Analysis.
Create end to end BI solution from Data
Warehouse to Cube, and Providing Analytical
Dashboards & Reports
Responsible for creating interactive user
Reports / Dashboards using Performance Point Services
& Power View through Cubes
December 2011 - BI Analyst Programmer
March 2013 Centegy Technologies (Pvt.) Ltd, Pakistan
Formerly Known as Sidat Hyder Morshed Associates
Industry Information Technology / Software
Services
Projects BI & ETL solutions for national /
multinational clients, provide data warehouse
solutions using MS SSIS
Developed Dashboards using MS Reporting
Services
Job Role Developed BI solution using MS SSAS
Responsible for ETL setup using MS SQL
Server SSIS and DTS packages
Responsible for creating interactive user
reports / Dashboards using MS Reporting Services &
Performance Point Services
Responsible for creating reports through
Cubes
Responsible for creating data warehouse
solutions
August 2009 - Associate Programmer Analyst
December 2011 Shams Software Services, The Shams Group (U.S.A)
Industry Information Technology / Software
Services
Projects TSG Purge Tool is an intelligent
archiving process based on Meta data it generates the
list of tables, SQL code which needs to be executed
for purging and also perform the logging of whole
process very effectively using MS SQL Server.
Job Role Responsible for ETL setup using MS SQL
Server SSIS and DTS packages
Responsible for data extraction from
MEDITECH to MS SQL Server
Responsible for Integration between
Clients Product to MEDITECH via HL7 Message Protocol
Responsible for maintaining E.H.R Web
Based
System & addition of new modules as per need of the
Health Care industry using Dot Net Nuke
Providing effective solutions for Health
Care industry that are reliable and cost effective as
well using ASP.Net and VB.Net
Developing interactive user reports
through MS Reporting Services
Providing Back-End supports to client
present in U.S.A. and to concur the issues that are
arising in Health Care Industry using MS SQL Server
Need to upgrade the Product Version to
meet market requirements and also provide upgrade
solutions for previous versions
Responsible for Query Performance and
Tuning
Directly reporting to Project Team Lead
December 2007 - Country MIS Coordinator
April 2009 Fraud Risk Management Unit, United Bank Limited
Pakistan
Industry Banking
Projects F.R.M.U. Web Based informative system which can hold
record of fraudulent customers and provide these
details to Banking Staff to mitigate the risk factor.
Provide effective reports which help the management
in making new policies.
Job Role Responsible for maintaining F.R.M.U. Web
Based
System & addition of new modules as per need of the
department using ASP.Net and VB.Net
Creating different forecasting MIS that
highlights the arising fraud trends in the market
using SSRS
Fraud & Forgeries reporting to S.B.P regarding
consumer fraud cases
Fraud reporting to Audit & Compliance
Division regarding consumer products
Fraud Reporting to VISA International
regarding Credit/Debit cards
Directly reporting to Country F.R.M.U
Head
Achievements
October 2012 - Microsoft Community Contributor Badge
Professional Awarded by Microsoft Community Contributor Team
https://www.microsoftcommunitycontributor.com/current-recipients.aspx
August 2012 - Amongst Top 5 Answerer - SQL Server Reporting
Services
Professional MSDN Forum
May 2012 - Specialization In Configuring and Deploying
Microsoft's
Professional Private Cloud
Awarded by Alan Le Marquand - Dean
Microsoft Virtual Academy
November 2011 - Amongst Top 5 Answerer - Transact SQL MSDN Forum
Professional
October 2011 - Amongst Top 5 Answerer - Transact SQL MSDN
Forum
Professional
April 2011 - Microsoft Community Contributor Award
Professional Awarded by Nestor Portillo - Director - Community &
Online Support, Microsoft
Microsoft Community Contributor ID: (4032800)
May 2008 - Performance Award at United Bank Limited
Professional Awarded by Khawaja Asif - Group Head -
Consumer Bank
Professional Expertise
Skill Skill Level Years of Experience
MS SQL Server Advanced More than 5 Years
MS SSIS Advanced More than 5 Years
MS SSAS Advanced More than 4 Years
MS SSRS Advanced More than 5 Years
Performance Point Services Advanced More than 1 Year
Power View Intermediate Less than 1 Year
Dot Net Nuke Intermediate More than 2 Years
ASP.Net Intermediate More than 2 Years
VB.Net Intermediate More than 2 Years
JavaScript Intermediate More than 2 Years
XML / XSL Intermediate More than 2 Years
Education
March 2007 Bachelor of Science in Computer Engineering
Sir Syed University of Engineering and Technology,
Karachi
Pakistan
Personal Information
Birth Date 29th June 1984
Gender Male
Nationality Pakistani
N.IC. Number 42101-1110445-9
Postal Code 75850
Contact this candidate