Learn Data Skills
Beta
Mohsin Mukhtiar

Mohsin Mukhtiar

Certified

BI Developer

Sadleirs | Perth Western Australia

Technologies

My Portfolio Highlights

My New Track

Data Scientist

My New Project

Dr. Semmelweis and the Discovery of Handwashing

My New Certification

Data Analyst Associate

Data Engineer | BI Developer | Azure ☁ | Power BI/DAX | SSRS/Data Factory | ETL/ELT | Python | MS Fabric | Writer@Medium

My Work

Take a look at my latest work.

course

Writing Efficient Python Code

project

Cleaning Bank Marketing Campaign Data

course

Streamlined Data Ingestion with pandas

PythonSQLPower BI
workspace

The Android App Market on Google Play

2Upvotes
workspace

Predicting Credit Card Approvals

2Upvotes
certification

Data Analyst Associate

workspace

Mohsin's Data Analysis Project - Bee friendly plants

1Upvotes

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst

Associate

Other Certificates

Dbt Labs Dbt Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Sadleirs | Jan 2023 - Present

Business Intelligence Developer

• Developed Business Intelligence dashboards and reports using Power BI, SQL Reporting Services, and other reporting tools • Extracted, consolidated, cleansed, and transformed data sources ready for analysis • Designed and developed data models and Power BI data sets • Reconciled data against source systems to verify data integrity • Communicated effectively with non-technical users to gather reporting requirements and demonstrate solutions • Assisted in defining and supporting a data governance strategy for the business • Advance Excel skills and experience working with a variety of business systems both cloud and on-premise • Proficient in SQL development, including SQL Server Reporting Services, SQL Service Integration Services, and database administration • Familiarity with cloud-based data analysis solutions and Azure PaaS development Knowledge of Python and experience with Azure Dev Ops • Experience in ad-hoc data extraction to support business decisions and system migration efforts • Developed and supported Excel workbooks used within the business • Expertise in data engineering skills such as data modeling, data integration, ETL, and data warehousing.
Show More

Openn Negotiation | Jun 2021 - Dec 2022

Data Analyst & Application Support

• Maintenance and delivery of Power BI report, dashboard and data management solutions for both long- and short-term project engagements using DAX and Power Query M. • Responsible for providing updated stats to Sales, marketing and finance department using Excel, Power BI, SQL and Metabase. • Assisted in setting up Snowflake data warehouse integrating Hubspot, Mailchimp, Stripe and Openn’s App data using Fivetran, Hightouch and dbt. • Developed and implemented issue tracking system and stock purchasing request approval system integrating GitHub, Microsoft Forms and teams using Microsoft Power Automate. • Responsible for reporting market share analysis and comparison of Openn data with real estate market from Propic.com.au, CoreLogic, realestate.com.au and domain.com.au. • Documented contracts (terms of use and authority to conduct sale) with each update in compliance with state laws liaising with lawyers. • Provide tier 1 and tier 2 support using Freshdesk and GitHub. Also, assist Product Manager in testing upcoming app update’s release candidate. • Collaborate with Head of Product in implementing group level permissions to users by removing individual level permissions enforcing security and integrity for accessing data. • Managing users to the LastPass (password management app) via Azure Active Directory • Configured and setup Power BI during AWS Aurora database shift.

Curtin University Student Guild | Aug 2020 - Jun 2021

Teaching and Learning Assistant (ITISA)

• Prepare Material: Prepared course content, created reports, and corresponded with team for the skill development events specially focused to develop skills in IT/IS students. • Conduct Event: Delivered presentation about the importance and application of Microsoft Visio in an academic and enterprise environment. Creating BPMN diagrams, Floor Plans, Network Diagrams, and System Sequence Diagrams to increase participants professional skills. • Planning and Organizing: Determining in advance of the events about what is going to be covered in the session and how it will be presented, keeping the course on track and resulted in successful launch of event. • Communication and Interpersonal skill: Lectured a university level class of 30 students. Actively listened, interacted and helped them by resolving the problems encountered in understanding a concept.

JW Solutions | Jan 2020 - Jul 2020

Business Intelligence Analyst

• Converted data into actionable insights by predicting and modelling future outcomes. • Built reports and dashboards using Power BI and Tableau for business KPIs that reduced manual reporting by 5 hours weekly. • Cleaned and prepared data for the clients using Python, SQL and Excel. • Provided data reporting using SQL querying to gain insights into various parts of the business. • Documented functional requirements that can be communicated to the technical team.

Teltonika | Jan 2017 - Sep 2018

Corporate Sales Executive

• Communication and Techncal Sales: Achieved the yearly target and successful implementation of the system with the help of exceptional client dealing and communication skills resulted in onboarding major companies nationwide. • Internet of Things (IoT) Products: Presented benefits of Internet of Things (IoT) products (Automation Solutions) including hardware and software specifications in the meeting with clients which increased lead generation by 25%. • Return on Investment Plan: Calculated return on investment plan for automation solution using unit consumption and price of product as variables which was printed on annual report of the company resulted in increase of sales by 30%. • Client Support: Received and logged phone calls, emails, and online chat sessions by applying excellent verbal and non-verbal communication skills resulted in client relationship management.

My Education

Take a look at my formal education

Professional Year Program, Data AnalyticsNIT Australia | 2022
Master of Commerce, Information System and TechnologyCurtin University | 2020
Bachelor of Business Administration - BBA, MarketingIqra University (Official) | 2016
High School & Intermediate, Pre-EngineeringCadet College Petaro | 2011

About Me

Mohsin Mukhtiar

Passionate Data Scientist and BI Developer experienced in Python, Power BI, and SQL. Transforming raw data into actionable insights for informed decisions.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free