Data Analyst 

With a growing demand for data-driven storytelling, I can extract, transform and load data in SQL and Excel to create micro & macro charts, data visualization in Tableau and Power BI to find key performance indicators, average revenue per user, etc. I thrive best in dynamic and diverse operational environment, and remain focused while working under tight deadlines to produce high quality work and balancing competing priorities. Lastly, I am always open to receive constructive feedback and learn new skills to improve my work.

Technical Skills

Python, MySQL, PostgreSQL, SQL, Tableau, Power BI, Excel(Box and Whisker Charts, vlookups, index/match, nested IF statements, Pivot tables),  next.tech, Regression Analysis, Power Point, Adobe Suite, MS Project, Agile, Slack, Zoom, Dropbox, G Suite, Audacity, Final Cut Pro, iTune, Wochit, Presto, Okta, Dropbox, G Suite, Zoom, CMS, DSLR Camera, Marantz, Tascam, ENCO

Projects

• Established three-five top factors AirBnB users should take into consideration while booking their next stay in Milan through analyzing data in SQL using features like cluster charts, regression and correlation coefficient.

• Used standard deviation, Pearson’s R Correlation Coefficient and regression analysis in Excel to create descriptive and inferential analyses to find KPIs, to increase revenue by 10% and find an area to divest of with a chemical corp. and present my work to technical and executives

• Extracted data in SQL to find KPIs and visualize my findings in Tableau to help American Energy Market Regulator to avoid power outages

Employment

Junior Digital Analyst @ Los Angeles Times-Los Angeles, CA                                                                   May 2022-Present

•Create dashboards and self-service tools to enable stakeholders in the company to self-serve data

•Communicate and present findings to multiple stakeholders, including editorial, web analytics, subscriptions, product, and advertising

•Respond promptly to ad hoc data requests

•Work with power users to create reports their teams require

Data Analytics Fellow @ Springboard and Datacamp-Los Angeles, CA                                                   Jan 2021-Feb 2022

• 400+ hours of hands-on course material, with 1:1 industry expert mentor oversight, and completion of 3 in-depth capstone projects.

• Extracted data in Python to find KPIs and visualize my findings in Tableau to help people to make a data-driven decision while purchasing a residential property in Melbourne

Breaking News Reporter @ THE STAR-Camarillo, CA                                                                           July 2019-Jan 2020

• Wrote, edited and produced 260+ stories online and in print using Okta and Presto to educate readers about their communities

• Covered crime stories at the scene of fatal shootings and accidents for a large daily newspaper

• Shot, edited and published pictures, videos and audio stories by Pro Tools to create engaging stories

• Actively monitored scanners and websites like PulsePoint and California Highway Patrol to write new stories

Multimedia Reporter @ CobBird- Los Angeles, CA                                                                                      March-Aug 2018

• Interviewed homeless individuals in Skid Row in Los Angeles to shoot, edit, and produce reports and podcasts on services they received to transition into a stable life

• Booked guests and prepared them to carry out interviews at homeless shelters and advocacy groups

General Assignment Reporter @ Eastern Arizona Courier-Safford, AZ                                              Sept 2016-Sept 2017

• Attended 12 council meetings, 10 crime scenes including two active shootings and 5 educational conferences to write, edit, and produce 100+ stories for a biweekly newspaper

 

News Director & Reporter @ KVSC 88.1 FM-St. Cloud, MN                                                               Aug 2014-Sept 2016

• Wrote, edited, and produced 100+ audio packages and 50+ podcasts for live & online newscasts

• Taped and conducted in-person interviews with officials on and off campus by Tascam and Marantz in order to write stories and produce audio packages

• Directed and trained four assistants to write, edit and produce stories for air and online

 

Reporter & Producer @ St. Cloud State University Television Station-St. Cloud, MN                       Aug 2015-May 2016

• Shot videos, pictures and interviews using DSLR and Sony-XDCAM PXW-Z90V to produce visual stories

• Edited stories in Final Cut and Adobe Premier to produce 50+ stories for online and on-air newscasts

 

Education

• Data Analytics Fellow at Springboard and DataCamp (Tools: Excel, Python, Power BI, Tableau, SQL)   Jan 2021-Jan 2022

• Master’s of Science in Journalism from St. Cloud State University, MN                                                 Aug 2014-May 2016

• Bachelor’s of Art in English Translation from Azad University Khorasgan Branch, Iran                         Sept 2006-Feb 2011  

Accomplishments

• Finalist in the Whickers Radio and Audio Funding Award                                                                                          May 2020

• Fulbright Scholarship awarded by Institute of International Education                                                     Sept 2012-Sept 2013

• Shortlisted for Iran’s National Triathlon Team                                                                                                             Sept 2007

Languages: Fluent in Farsi, English, Dari, intermediate proficiency in Arabic and French

 

Memberships

• AIR Media, Investigative Reporters and Editors, Asian American Journalists Association