Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

Shahin Jafari

Brisbane,Australia

Summary

Experienced Data Analyst and Power BI Specialist with over 10 years of hands-on experience delivering end-to-end business intelligence solutions across hospitality, retail, and enterprise sectors. Proven expertise in designing scalable dashboards, automating data workflows, and integrating VoIP and CRM systems to drive operational efficiency. Adept in SQL Server, Power BI, DAX, and cloud data platforms. Seeking a data-driven environment where I can contribute to strategic growth and digital transformation. Currently based in Brisbane, QLD, and available for in-person or hybrid roles.

Overview

12
12
years of professional experience

Work History

Power BI Consultant & VoIP Integration Specialist

Self-Employed
07.2014 - Current
  • Delivered end-to-end Power BI dashboards for over 100 restaurants, streamlining operations, and enhancing financial decision-making.
  • Designed custom KPI models and drill-through reports for clients, including Sepidz Software Group, DeyFC, and Sarv Faraz Aryan, leading to data-driven insights and measurable business improvements.
  • Developed ETL pipelines, performed advanced data preparation and cleansing, and optimized T-SQL queries for complex relational datasets, ensuring performance, accuracy, and scalability.
  • Integrated Asterisk-based VoIP systems with Power BI to generate real-time call analytics dashboards and customer insight reports.
  • Built and deployed AGI/AMI scripts to support dynamic call routing, IVR logic, and CRM integrations for client telephony systems.
  • Configured analog VoIP gateways (e.g. Grandstream GXW4108) and implemented API-level connections to external platforms.
  • Created training materials and dashboards for non-technical staff to promote data literacy and reporting independence.

Senior Data Analyst & VoIP Developer

SEPIDZ Software Group
07.2013 - 01.2025
  • Developed and maintained advanced reporting systems using Power BI and SQL Server.
  • Led VoIP system integrations using Asterisk, AGI/AMI scripts, and CRM/accounting APIs.
  • Designed IVR logic tailored for restaurants and enterprise clients.
  • Collaborated with developers to automate client reporting workflows.
  • Trained staff and supported rollout of BI dashboards and VoIP infrastructure.

Education

Bachelor of Science - Information Technology

Ghiasodin Jamshid Kashani
Iran
07-2015

Master of Business Administration (MBA) -

Griffith University
Australia

Skills

Data & Business Intelligence:

  • Power BI (Advanced – dashboards, DAX, KPI design, data modeling)
  • SQL Server (Advanced – T-SQL, stored procedures, performance tuning)
  • Excel, MySQL, ETL pipelines, data cleansing

VoIP & Telephony Systems:

  • Asterisk (Advanced – Dialplan, AGI, AMI)
  • VoIP-Power BI integration, real-time call analytics
  • Analog gateway setup, CRM & API integration
  • Maintenance & repair
  • Project management

Programming & Web Technologies:

  • SQL (Advanced), PHP, R (project-based experience)
  • HTML, CSS (personal projects)
  • Basic Python (for data scripting and automation tasks)

Tools & Platforms:

  • Git, VS Code, Postman
  • Power Automate, Microsoft Azure (currently learning)

Creative & Visual Tools:

  • Adobe Photoshop (Advanced)
  • Adobe Premiere Pro (Advanced)

Affiliations

Comprehensive Power BI Reporting for Restaurant Chains
  • Freelance / Self-Employed (Multiple clients – 100+ branches)
  • Tech Stack: Power BI, SQL Server, Excel, DAX
  • Designed and implemented a full-scale Power BI reporting system featuring 100+ custom visuals across sales, accounting, customer behavior, and inventory.
  • Included real-time dashboards, predictive sales models, RFM/CLTV analytics, COGS estimation, and payroll reporting.
  • Improved decision-making and reduced reporting workload by over 60%.
Custom VoIP Automation for 40+ Clients
  • Freelance / Self-Employed (Restaurants & Enterprises)
  • Tech Stack: Asterisk, AGI, AMI, SQL Server, PHP, REST API
  • Built AGI-powered IVR systems for routing based on CRM/accounting data, blocking flagged customers, and integrating with existing platforms.
  • Enabled API-based and direct database communication, automating contract verification and call routing.
VoIP-Integrated Call & Sales Intelligence Dashboard
  • Freelance / Self-Employed (Restaurant Clients & Call Centers)
  • Tech Stack: Asterisk, AGI, AMI, MySQL, SQL Server, Power BI
  • Linked VoIP events and sales history to track lost revenue per missed call, operator performance, and queue activity.
  • Used login duration and response times to support payroll calculations and operational efficiency.
Voice-Controlled Irrigation System via VoIP
  • Freelance R&D Project (Agricultural Clients)
  • Tech Stack: Asterisk, AGI, Speech Recognition, MySQL, Relay Modules
  • Created a voice-activated IVR system for remote drip irrigation management, logging user commands and triggering hardware relays.

Timeline

Power BI Consultant & VoIP Integration Specialist

Self-Employed
07.2014 - Current

Senior Data Analyst & VoIP Developer

SEPIDZ Software Group
07.2013 - 01.2025

Bachelor of Science - Information Technology

Ghiasodin Jamshid Kashani

Master of Business Administration (MBA) -

Griffith University

Similar Profiles

CREATE PROFILE
Shahin Jafari