Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
Mohsan Z.
@Bhatti1987
4.9
16
4.1
4.1
87%
DBA |.NET |DWH |ETL |SSIS |SSAS |SQL |Oracle |BI
$35 USD / Hour
・
Pakistan (2:07 AM)
・
Joined on March 1, 2022
$35 USD / Hour
・
Business Intelligence & Full Stack Consultant
(14+ Years of Experience in Database Modeling, Software Development, SQA & Big Data)
Core Expertise:
Database Management: Oracle, SQL, MySQL, PostgreSQL Server, DB2 – database modeling, design, administration.
Software Development: Proficient in Angular, C#, .Net, MVC, PHP – handling both back-end and front-end development.
ETL & Data Integration: Extensive experience in ETL processes using SSIS, SSAS, SSRS for OLAP solutions.
Data Warehousing: Designing data warehouses (Oracle & SQL Both) using Star and Snowflake schemas for optimal data storage and retrieval.
Business Intelligence: End-to-end BI implementation using Tableau, Power BI, SSRS, and Excel for dashboards, reports, and KPIs.
Project Delivery & Domain Expertise:
International Projects: Successfully delivered projects from scratch to live in the US banking, healthcare (US & UK), and Saudi construction sectors.
Management Systems Development: Handled over 300 different management systems and consolidated them into a single data warehouse for executive decision-making.
Key Systems Developed:
HR Management System
Payroll Management System
Financial Management System
Inventory Management System
Hospital Management System
Logistics Management System
Telecommunication Management System
Oil & Gas Management System
Banking Management System
Judiciary Management System
Residential Management System
Security Management System
Housing Management System
Construction Management System
Project Management System
School Management System
Accelerated Promotion Management System
Ticket Management System
Nestle Management System
and many more
Technical Skills:
Programming & Scripting: SQL, PL/SQL for stored procedures, functions, and packages; Windows/Linux environments for database development and deployment.
Big Data Technologies: Strong exposure to Hortonworks, Hive, Pig, Sqoop; expertise in sentiment prediction for social data sets.
Data Modeling: Logical and physical data modeling of semantic layers, combining various sources for a cohesive analytics platform.
Advanced Analytics: Deep knowledge of business analysis, solution design, architecture, and advanced data analytics.
I would like to express my gratitude for the excellent work done by our DBA. He delivered all tasks on time and ensured that everything ran smoothly. His attention to detail and commitment to quality were crucial to the success of the project. I highly recommend his work for any future endeavors.
I would like to express my sincere gratitude to the professional who assisted me in restoring the database. His work was extremely professional, and he demonstrated exceptional attention and dedication throughout the entire process. He clearly knows what he is doing and possesses extensive qualifications as a database administrator (DBA). I am 100% satisfied with the support received and impressed with his high level of competence and commitment. Thank you very much for all the help provided!
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.
May, 2014 - Present
•
10 years, 7 months
Senior Software Engineer
Oct, 2012 - May, 2014
•
1 year, 7 months
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
Oct, 2012 - May, 2014
•
1 year, 7 months
Software Engineer
Nov, 2010 - Oct, 2012
•
1 year, 11 months
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
Nov, 2010 - Oct, 2012
•
1 year, 11 months
Education
Riphah International University
2014 - 2016
•
2 years
MS Project Management
Pakistan
2014 - 2016
•
2 years
Air University
2006 - 2010
•
4 years
B.E Software Engineering
Pakistan
2006 - 2010
•
4 years
Qualifications
B.E ( Software Engineering
2010
Air University
Graduated with a comprehensive understanding of software development, programming, and system design. The program equipped me with practical skills in software architecture, database management, and full-stack development. I gained proficiency in various programming languages, algorithms, and data structures, and worked on hands-on projects involving application development, systems integration, and software testing.
2010
Certifications
SQL
US English
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.