Mojtaba Roshani

With 6 years of experience in working with business analytics and background of creative design, animation, web design and marketing from United States and overseas, Bachelors in graphic design, 8+ licenses and certificates including an extensive data analytics and Power BI.
I am a quick learner eager to learn new skills to broaden my technical and personal skills. As a freelancer, I learned to be a self-motivated problem solver who build trusting relationships with clients. As an employee, I build strong relationships with the team, communicated my data effectively with the team and the decision makers, trained junior employees, identified problems and provided solutions to the company in setting and reaching aggressive financial goals.

Portfolio

Springboard Capstone 2 – Correlation between global CO2 emissions and global temperature

Springboard Capstone 2 – Correlation between global CO2 emissions and global temperature

Jupyter Notebook, Springboard
Springboard – Capstone 2 – Power BI Rport

Springboard – Capstone 2 – Power BI Rport

Power BI, Springboard
Springboard – Capstone 1 – American Energy Market Operator

Springboard – Capstone 1 – American Energy Market Operator

Springboard, Tableau
AEMR Case Study

AEMR Case Study

Springboard, SQL
Springboard – Capstone 1 – Southern Water Corp – Part 2

Springboard – Capstone 1 – Southern Water Corp – Part 2

Jupyter Notebook, Springboard
Springboard – Capstone 1 – Southern Water Corp – Part 1

Springboard – Capstone 1 – Southern Water Corp – Part 1

Jupyter Notebook, Springboard

Data Skills

Data Analytics

Microsoft Power BI

DAX

SQL

Microsoft Excel

Python

Tableau

Google Analytics

Google Data Studio

Experience

Jan 2017 - Present
Cheap Easy Fast Online Traffic School

Business Data Analyst & Digital Marketing Specialist

Our company is one of the leading driving schools across the states. We have been providing innovative driver training services since 1986.

Launched Power BI reporting dashboard to improve decision-making process for the team:

  1. Offline detailed historical reports
    • Created views and extracted flat file from live and archive SQL server databases
    • ETL process
    • Designed star schema data model with fact table and dimensions
    • Developed reports and dashboard with KPIs and taught the team to visually explore data
    • Trained the team in using the system and better understanding data
    • Updated and imported data weekly and design new reports by request
    • Presented data to key decision makers
  1. Live sales dashboard
    • Designed a cleaned and joined SQL view table
    • Sat up On-premises data gateway
    • Designed reports and a dashboard with different DAX measurements KPIs
    • Converted Time Zone for date column to accurate live data
    • Created bookmarks to highlight a series of insights

Monitored and reported analytical data of 66 sites across 8 states by building Google Data Studio reports and 3rd party services

  • Tracked sites and students by a marketing automation service and Google Analytics
  • Presented data and potential automation with key decision makers
  • Interacted closely with 3rd party services and negotiated deals that benefited our company
  • Launched an animated course that enhanced companies’ sales by 60% upon:
  • Monitored competitors and identified a need for animated course
  • Managed and helped a team of 5 to create a quality animated course in par with our competitors
  • Increased sales around 60% a few weeks after starting the new course
  • Implemented changes to enhance customer experience
  • Sent browser push-ups based on customer’s interactions
  • Sent multiple email campaigns for targeted audience

Successfully leads the company’s efforts in reaching $1 million sales per month after 7 months:

  • Redesigned responsive front-end for the 66 sites
  • Regularly assessed the sales of each site against our competitors and implemented marketing strategies to enhance sales:
  • Enhanced keyword search by monitoring competitors using paid and free services
  • Optimized SEO to improve organic search results
  • Launched and optimized various ‘Google Ads’ marketing campaigns
  • Prepared and studied weekly reports to make cost effective advertising decisions

Jul 2015 - Present
Cybermoji

Founder

Growth marketing consultant for small businesses in the State and Canada

  • Performed keyword research and SEO optimization for driving more traffic to client’s site
  • Identified their key competitors and upgraded or designed responsive websites comparable to their competitors
  • Created and managed social media pages to optimize their presence
  • Consulted them in ways to build meaningful relationships with their potential customers
  • Created and managed Google Business and Yelp pages to ensure client easy access
  • Supported them in efforts to gain reviews from past clients

Managed advertising campaign for local businesses

  • Started and managed Google Ads campaigns
  • Ran various email and text marketing campaigns
  • Worked closely with their marketing department to consult and improve their advertising strategies
  • Video marketing to increase customer engagement
  • Help to start and run a Podcast

Supported and immigrant community in building LMS platform:

  • Installed and customized WordPress site, theme and plug-ins
  • Integrated with marketing automation to improve tracking and marketing campaigns

Testimonials