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