SAMRAN MAQBOOL
Dubai
Summary
Google certified professional data analyst with over five years of proven experience in transforming complex data into actionable insights. I excel in leveraging advanced technical tools like SQL, Python, PowerBI and Tableau etc. to drive data-driven decision making and optimize business outcomes. Adept at delivering clear, impactful visualizations and reports that enable stakeholders to make informed strategic decisions.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Billing Data Analyst
TCP Software
07.2023 - Current
- Automated client subscription updates with bulk API calls, reducing manual errors by 18% and improving processing speed by 75%.
- Improved data retrieval speed by 40% through tailored SQL queries, enabling faster decision making and enhancing billing accuracy by 15%.
- Optimized billing processes resulting in a 28% decrease in invoice processing time saving $200k annually.
Health Ops. Analyst
MILVIK BIMA Pakistan
09.2022 - 07.2023
- Developed a 27 page PowerBI dashboard from scratch, effectively monitoring KPIs for employees across 7 departments resulting in an overall company growth of 11% year on year.
- Boosted overall employee performance by 17% by identifying and highlighting key areas of improvement based on the dashboard.
Strategic Pricing Analyst
SNK Petroleum Inc.
04.2020 - 09.2022
- Developed an algorithm to calculate and update petroleum prices multiple times daily across 57 sites in 7 US states based on 7 variables.
- Enabled 18%-25% year-over-year growth at 10 of the highest volume stations through optimized pricing.
Education
Python Prog. Specialization -
University of Michigan
05-2024
Executive Data Specialization -
Johns Hopkins University
02.2024
Data Analytics Specialization -
Google
09.2022
B.Sc. Engineering -
UET Lahore
10.2019
Skills
- SQL
- Microsoft PowerBI
- Tableau
- Python
- Microsoft Office
- Data Studio
- Looker
- R programming
- Business Needs Analysis
- Technical Analysis
- Project Management
- Data Modeling
- Deep learning
- Software Development Life Cycle (SDLC)
Certification
- PROGRAMMING FOR EVERYONE, University of Michigan, 525XVNRF6UZQ
- PYTHON DATA STRUCTURES, University of Michigan, DE5T5F286GDX
- EXECUTIVE DATA SCIENCE, Johns Hopkins University, Z6UM9B3R7ATL
- MANAGING DATA ANALYSIS, Johns Hopkins University, 95PHHQZWS7NN
- A CRASH COURSE IN DATA SCIENCE, Johns Hopkins University, AFAGHGDJKAF9
- EXECUTIVE DATA SCIENCE (CAPSTONE), Johns Hopkins University, BETH427WFN2U
- BUILDING A DATA SCIENCE TEAM, Johns Hopkins University, J8TAGCFP77UV
- DATA SCIENCE IN REAL LIFE, Johns Hopkins University, WMG5RUJLZ27S
- SHARE DATA THROUGH VISUALIZATION, Google, WFM3BCVQUMLD
- ANALYZE DATA TO ANSWER QUESTIONS, Google, KZKZDH9DXT3E
- GOOGLE DATA ANALYTICS, Google, C2YLMCC6NMVH
- GOOGLE DATA ANALYTICS (CAPSTONE), Google, D9CC48B66N26
- DATA ANALYSIS WITH R PROGRAMMING, Google, FG5MNQQP3WYK
- FOUNDATIONS: DATA, DATA EVERYWHERE, Google, NJFEWVGUCZGE
- ASK QUESTIONS TO MAKE DATA DRIVEN DECISIONS, Google, N8EZ4NSM74NY
- PREPARE DATA FOR EXPLORATION, Google, YTSUSCJKYURZ
- PROCESS DATA FROM DIRTY TO CLEAN, Google, 3C7KM9GYHVML
- PYTHON DATA ANALYSIS, LinkedIn, 743b264198c5cbc90043caddda27900c478b11b0eec347d5293dbfd08676d9b5
- EXCEL: ADVANCED FORMULAS AND FUNCTIONS, LinkedIn, e41434326f77cdc2950796ac0ff030a74c4a3b8e49ca5be6e754b84c95beff6a
- LEVEL UP: ADVANCED SQL, LinkedIn, de1fdb75d832395c2c69c5da0b866c91b1b35ed219327c27a21e326aa976620d
Languages
Urdu
First Language
Arabic
Advanced (C1)
C1
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Punjabi
Proficient (C2)
C2
Turkish
Intermediate (B1)
B1
Accomplishments
- I created the Pricing strategy, brand strategy and the plan to handle new logistical hurdles when SNK Petro. entered the Chicago market with 7 new sites.
- I created and presented an interactive dashboard and detailed presentations over a period of 2 weeks resulting in successful acquiring of a 20% stake in Milvik BIMA by IGI group worth 100 million PKR.
- Successfully migrated data for 100k+ customers from 2 companies (TimeCo & When2Work) acquired by TCP Software within 80% of estimated time.
Projects
- Devise a Strategy To Increase Members:
Analyse the data about customer types to find trends and patterns in order to come up with a plan to get more riders to sign up for the company's annual membership package. (sites.google.com/view/samrans-portfolio/home)
References
References available upon request.
Timeline
Billing Data Analyst
TCP Software
07.2023 - Current
Health Ops. Analyst
MILVIK BIMA Pakistan
09.2022 - 07.2023
Strategic Pricing Analyst
SNK Petroleum Inc.
04.2020 - 09.2022
- PROGRAMMING FOR EVERYONE, University of Michigan, 525XVNRF6UZQ
- PYTHON DATA STRUCTURES, University of Michigan, DE5T5F286GDX
- EXECUTIVE DATA SCIENCE, Johns Hopkins University, Z6UM9B3R7ATL
- MANAGING DATA ANALYSIS, Johns Hopkins University, 95PHHQZWS7NN
- A CRASH COURSE IN DATA SCIENCE, Johns Hopkins University, AFAGHGDJKAF9
- EXECUTIVE DATA SCIENCE (CAPSTONE), Johns Hopkins University, BETH427WFN2U
- BUILDING A DATA SCIENCE TEAM, Johns Hopkins University, J8TAGCFP77UV
- DATA SCIENCE IN REAL LIFE, Johns Hopkins University, WMG5RUJLZ27S
- SHARE DATA THROUGH VISUALIZATION, Google, WFM3BCVQUMLD
- ANALYZE DATA TO ANSWER QUESTIONS, Google, KZKZDH9DXT3E
- GOOGLE DATA ANALYTICS, Google, C2YLMCC6NMVH
- GOOGLE DATA ANALYTICS (CAPSTONE), Google, D9CC48B66N26
- DATA ANALYSIS WITH R PROGRAMMING, Google, FG5MNQQP3WYK
- FOUNDATIONS: DATA, DATA EVERYWHERE, Google, NJFEWVGUCZGE
- ASK QUESTIONS TO MAKE DATA DRIVEN DECISIONS, Google, N8EZ4NSM74NY
- PREPARE DATA FOR EXPLORATION, Google, YTSUSCJKYURZ
- PROCESS DATA FROM DIRTY TO CLEAN, Google, 3C7KM9GYHVML
- PYTHON DATA ANALYSIS, LinkedIn, 743b264198c5cbc90043caddda27900c478b11b0eec347d5293dbfd08676d9b5
- EXCEL: ADVANCED FORMULAS AND FUNCTIONS, LinkedIn, e41434326f77cdc2950796ac0ff030a74c4a3b8e49ca5be6e754b84c95beff6a
- LEVEL UP: ADVANCED SQL, LinkedIn, de1fdb75d832395c2c69c5da0b866c91b1b35ed219327c27a21e326aa976620d
Python Prog. Specialization -
University of Michigan
Executive Data Specialization -
Johns Hopkins University
Data Analytics Specialization -
Google
B.Sc. Engineering -
UET Lahore
Similar Profiles
Adam PoeAdam Poe
Senior Enterprise Account Executive at TCP SoftwareSenior Enterprise Account Executive at TCP Software
Faisal Yar KhanFaisal Yar Khan
Billing Specialist - Time Clock Plus at TCP SoftwareBilling Specialist - Time Clock Plus at TCP Software
Umer ZohaibUmer Zohaib
Strategic Analyst at TCP SoftwareStrategic Analyst at TCP Software