Data Analyst
(- |-https://www.linkedin.com/hafizarsalanjamal/
https://ArsalanJamal.Github.io/
Delhi Colony, Karachi
ARSALAN JAMAL
Skills
•
•
•
•
SQL- (MySQL)
Python (Pandas, NumPy, Seaborn, Matplotlib)
Tableau
Excel (VLookup, Conditional Formatting, Pivot
Tables,Macros,Graphs and Charts,Sort &
Filter,Dashboard etc)
•
•
•
Looker
Power Query
Microsoft Power BI
Projects
DATA SCIEN C E JOB M AR KET DASH B OAR DD – Personal Project –PR IVATE, Online
●
●
●
Utilized Python to analyze 7000 data science job listings and gain insights on what it takes to land a job in analytics
Implemented Power Query techniques to comb through the Data Cleaning and identified the key requirements
Aggregated and visualized the data by using PowerBI,to compile a professional Dashboard
H OL IDAY SALES DASH B OAR D – Virtual Client’s Project – Private, Online
●
●
●
●
●
Performed exploratory data analysis using Python and data visualization techniques
Transformed and processed client’s data using Python and Excel to ensure data completeness and validity
Provided insights on how to improve customer experience and increase revenue
Consulted with clients to determine key metrics for analysis
Identified trends and patterns in customer behavior and sales data
H OUSIN G PR ICE DATA AN AL YSIS – Personal Project – Private, Online
●
●
Utilized SQL to perform Analysis on AirBnB Houses Reviews .
Performed data cleaning and analysis to successfully identified the major Analytics .
WAL L M AR T SALES DATA AN AL YSIS – Personal Project –,Online
●
●
Utilized SQL to extract data from customer sales databases
Transformed and filtered data by using aggregating and filtering function to improve reporting process
Work Experience
SEN IOR ACCOUN TAN T – QVISE Pvt Ltd – Karachi,Pakistan
●
●
●
●
●
●
Manage team for daily bank reconciliation and petty cash operations
Oversee payroll processing and employee database management
Prepare financial statements for external and generate internal reports for stake holders and support auditors.
Manage fixed asset register and conduct periodic audits.
Handle tax compliance, ensure proper records keeping, and data submission to consultants.
Project wise revenue and cost management.
M AN AGER ACCOUN TS AN D TAXATION – MILKYZ FOOD – Karachi, Pakistan
●
●
●
●
●
Jul 2022 - December 2023
Led a team of junior accountants and managed accounting processes
Prepared and reviewed financial statements
Verified accounting vouchers and maintained data integrity
Managed sales tax compliance and filings
Implemented cost-saving measures and ensured regulatory compliance
Feb 2016 - May 2022
Education
B ACH ELOR OF COM M ER CE IN B USIN ESS – University of Karachi – Karachi, Sindh
Majors: Commerce,Accounting,Business.
Jun 2011
PAR T QUALIFIE D ICM AP – Institute of Cost and Management Accountants of Pakistan – Karachi, Sindh
Majors: Accounting, Business, Economics
Jun 2011
Certificates
DATA AN ALYTICS CER TI FI CATE – Digiskills – Karachi, Sindh
Majors: Excel, Power BI, Tableau
March 2024
DATA AN ALYTICS B OOTC AM P – Alex Academy –Online
Other 2024
