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.
Abdullah L.
@AbdullahLasharii
0.0
0
0.0
0.0
0%
MS Excel | Automation Expert | Data Analyst | CA |
$5 USD / Hour
・
Pakistan (1:20 PM)
・
Joined on November 22, 2024
$5 USD / Hour
・
✍ CHARTERED ACCOUNTANCY (ICAP):
As a sophomore at the Institute of Chartered Accountancy of Pakistan (ICAP), I specialize in financial analysis, tax strategy, and compliance solutions, tailored to enhance business performance and ensure regulatory compliance.
✍ ADS (PUNJAB UNIVERSITY):
Pursuing a degree with subjects like Computer Science, Statistics, and Economics, focusing on integrating analytical skills and computational expertise to provide data-driven insights and solutions for technology and business analytics.
✅EXCEL EXPERTISE
➤Formulas:
- Expert in advanced formulas: SUMIFS, COUNTIFS, VLOOKUP, INDEX-MATCH, ARRAY FORMULAS, etc.
- Skilled in dynamic, nested formulas and robust error handling.
➤Conditional Formatting:
- Create custom rules to highlight trends with color scales, data bars, and icons.
- Develop dynamic criteria-based rules and integrate formatting with charts.
➤Data Validation:
-Ensure data integrity with custom rules and dynamic drop-down lists.
-Design error prompts for guided, accurate entries.
➤Dynamic Charts:
-Build auto-updating charts and advanced types like Ternary and combo charts.
-Create interactive dashboards with slicers and buttons.
➤Excel VBA:
-Automate workflows, create advanced solutions, and design interactive VBA forms.
✅ DATA ANALYSIS EXPERTISE:
As an adept data analyst, I specialize in transforming complex data into actionable insights for informed decision-making. My expertise spans a range of powerful tools:
PYTHON: Proficient in using libraries such as Pandas, NumPy, and Matplotlib for data manipulation, statistical analysis, and visualization.
POWER BI: Skilled in creating interactive dashboards and real-time business intelligence reports.
TABLEAU: Experienced in developing dynamic visualizations to effectively communicate data trends.
SQL: Expert in extracting, manipulating, and analyzing data from relational databases.
EXCEL: Advanced capabilities in data handling, including PivotTables, conditional formatting, and data validation.
R: Competent in conducting statistical analysis and visualization with extensive package support.
✅ AUTOMATION EXPERTISE:
As an experienced automation expert, I specialize in streamlining processes and enhancing efficiency through cutting-edge automation tools. My expertise encompasses:
▶️ POWER AUTOMATE: Expert in designing and implementing workflows that seamlessly integrate Microsoft services and external applications, automating tasks to enhance productivity.
✴️ ZAPIER: Proficient in creating automated workflows that connect various apps and services without the need for coding, efficiently managing complex multi-step processes.
♾️ [login to view URL]: Experienced in building detailed automation scenarios using a visual interface, improving workflow efficiency and operational performance.
By leveraging these tools, I deliver tailored automation solutions that transform business processes, enhance productivity, and drive growth.
✅ Excel to Outlook Calendar Sync(Power Automate): Automated event transfers from Excel to Outlook Calendar, reducing manual entry.
✅ YouTube Data Extraction (Make.com): Automated email and social media handle extraction from YouTube descriptions.
✅ Airtable Logo Integration (Zapier): Integrated real-time company logos into Airtable based on company names.
✅ Dropbox File Notification (Make.com): Notified admins when files were added to Dropbox, ensuring privacy.
Oct, 2024 - Present
•
2 months, 6 days
Data Analyst
Jan, 2021 - Present
•
3 years, 11 months
Self-Employed
Jan, 2021 - Present
•
3 years, 11 months
✅ Conducted comprehensive data analysis to extract actionable insights and support strategic decision-making.
✅ Developed and maintained advanced dashboards and reports using Excel, and Tableau.
✅ Ensured data integrity through meticulous data cleaning and preprocessing.
✅ Collaborated with clients to understand their requirements and deliver tailored data solutions.
✅ Managed multiple projects concurrently, ensuring timely and accurate delivery.
Jan, 2021 - Present
•
3 years, 11 months
Education
University of the Punjab, Lahore
2023 - 2024
•
1 year
ADS (Computer Science, Statistics, Economy )
Pakistan
2023 - 2024
•
1 year
SKANS School of Accountancy
2021 - 2024
•
3 years
Chartered Accountancy ( CA )
Pakistan
2021 - 2024
•
3 years
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.