Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project
EXPLORE
Data Warehousing Database Administration Microsoft SQL Server SQL SSIS (SQL Server Integration Services)
Profile cover photoundefined
You're now following .
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$25 USD / hour
Flag of PAKISTAN
islamabad, pakistan
$25 USD / hour
It's currently 8:41 PM here
Joined March 1, 2022
1 Recommendation

Mohsan Z.

@Bhatti1987

annual-level-three.svg
4.9 (14 reviews)
3.3
3.3
$25 USD / hour
Flag of PAKISTAN
islamabad, pakistan
$25 USD / hour
81%
Jobs Completed
76%
On Budget
96%
On Time
29%
Repeat Hire Rate

DWH Architect | DBA | ETL | SSIS | ERP | BI| SSRS|

12 plus years of experience especially in Oracle, SQL, MySQL, PostGre, Mongo Server database modelling, design, development, and Administration, Data Mining, Development, DWH, ETL, SSIS, SSAS, SSRS, SQA, Database development & maintenance. Business Intelligence & ETL consultant with sound experience in end-to-end BI implementation. Very strong in Open Interfaces, SQL, PL/SQL, Stored procedures/packages, writing Test Scripts, Windows/Linux environment and both back-end database development and front-end development Sound experience in logical & physical modeling of semantic layer, reports and dashboard development in various BI tools Tableau, SSRS, Power BI, and Microsoft Excel. Strong experience in designing Data warehouse using Star & snowflake schemas. Strong experience to write stored procedures, functions & views according to Dashboards & KPI’s requirements. Having great exposure of Big Data technologies Horton works, Hive, Pig, Sqoop etc Good knowledge of Big Data Analytic s having worked and successfully delivered on Sentiment prediction of Social Data set. • Business Analysis and Requirement Gathering • Effort Estimation and Planning • Solution Design and Architecture • Logical and Physical Data Modeling (Semantic & Core) • Reports and Dashboard Design and Development • Advance Analytics and Big Data
Freelancer SQL Developers Pakistan

Contact Mohsan Z. about your job

Log in to discuss any details over chat.

Reviews

Changes saved
Showing 1 - 5 out of 14 reviews
Filter reviews by: 5.0
$5.00 USD
Mohsin is expert in ssms, query analysis, postgres, excel complex farmulas and etl. Would definitely hire for future fillings.
SQL Database Administration Microsoft SQL Server Data Warehousing
+1 more
S
Flag of Mini C. @Sarachen98
6 months ago
1.0
$5.00 AUD
Bad experience with him
SQL Oracle SAS Database Administration Database Development
User Avatar
Flag of Umar A. @rajaumarali786
6 months ago
5.0
$25.00 USD
He was great to work with. Has mastery of his skill.
SQL Database Administration Microsoft SQL Server Data Warehousing SSIS (SQL Server Integration Services)
D
Flag of Karl F. @donkarlos2035
9 months ago
5.0
$11.00 USD
Completed my project on time,will hire again
SQL Oracle Database Administration Microsoft SQL Server Database Development
V
Flag of Vinnayak S. @vinay98488
10 months ago
5.0
$100.00 CAD
good work thank you.
Data Warehousing Data Analysis Data Integration Data Modernization Data Modeling
R
Flag of Rara H. @RARAHUSSAM
10 months ago

Experience

DBA, Data Scientist, ETL & Data warehouse

Realizing Innovation
May 2014 - Present
Key Responsibilities Include: • Work as Business Intelligence Consultant to support client • Master Data Management • Implementation DWH using SQL Server 2012/2014/2019 • Develop reports and dashboards using various Business Intelligence tools, such as Tableau & Power • Reporting Using SSRS • Work with Team in Requirement Gathering • Work with ETL Team to written SSIS Packages for Data Extraction • Dashboards & KPI’s for clients • Data Mapping and Data Integration of more than 300 applications.

Senior Software Engineer

Khushali Microfinance Bank
Oct 2012 - May 2014 (1 year, 7 months)
•Business Analysis and Requirement Gathering •Effort Estimation and Planning •Solution Design and Architecture •ETL Design using SSIS •Data Science for Business •Transforming raw data into meaningful information for business analysis purposes •Data analysis & Reporting using Tableau •Dashboards & KPI’s for clients •Provide Forecasting on Claims data •Build views & Stored Procedures according to client requirements •Monitoring Dashboard delivery from Development servers to production server

Software Engineer

Ora-Tech Systems
Nov 2010 - Oct 2012 (1 year, 11 months)
• Implement Data Warehouse using Hive • Developed Power Full ETL using Pentaho & load data into Hive Data Warehouse • Import data from Client Databases into Hive using Sqoop • Data Analysis using Hive QL & Pig

Education

MS Project Management

Riphah International University, Pakistan 2014 - 2016
(2 years)

B.E Software Engineering

Air University, Pakistan 2006 - 2010
(4 years)

Contact Mohsan Z. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

SQL_1.png SQL 1 82% us_eng_1.png US English 1 80%

Top Skills

SQL 10 SSIS (SQL Server Integration Services) 8 Database Administration 7 Microsoft SQL Server 7 Data Warehousing 5

Browse Similar Freelancers

SQL Developers in Pakistan
SQL Developers
SSIS Developers
Database Administrators

Browse Similar Showcases

SQL
SSIS (SQL Server Integration Services)
Database Administration
Microsoft SQL Server
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.