Ceren Dogan
San Francisco,CA
Summary
Detail-oriented Data Analyst with proven experience in grant reporting, program tracking, and data quality management. Proficient in Python and SQL, with strong skills in streamlining reporting workflows, maintaining accurate case and deliverable records, and translating complex data into clear insights for internal teams and external funders.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Management Associate
ASIAN PACIFIC ISLANDER LEGAL OUTREACH
San Francisco, California
01.2023 - Current
- Manage large datasets to ensure 98% accuracy and compliance for multi-grant reporting.
- Design dashboards and tracking systems to monitor performance metrics and outreach outcomes.
- Execute recurring funder reports and documentation within strict deadlines and standards.
- Collaborate with cross-functional teams to resolve data discrepancies and optimize reporting workflows.
- Transform raw data into executive-ready reports to demonstrate program impact and results.
Bill Management Analyst
BERKSHIRE HATHAWAY
San Francisco, CA
10.2018 - 06.2021
- Created and presented reports and dashboards in Excel to optimize operations, resulting in a 15% reduction in expenses.
- Maintained a 99.85% data accuracy rate through rigorous cleaning and aggregation of large-scale billing datasets.
- Optimized data workflows to solve complex billing concerns, saving the department approximately 30 minutes daily.
Education
M.S. - Business Analytics
California State University, Sacramento
Sacramento, CA, USA08.2025
Data Analytics Fellowship -
COOP Careers
San Francisco, CA01.2022
B.A - Economics
San Francisco State University
San Francisco, CA, USA12.2017
Skills
- Programming: Python, SQL, R
- Data analysis: Pandas, data cleaning, data wrangling
- Machine learning: Scikit-learn, classification, regression
- Predictive modeling: Feature engineering, selection, tuning
- Natural language processing: Text preprocessing, sentiment analysis
- Web scraping: BeautifulSoup
- Data visualization: Tableau, dashboards
- Cloud computing: AWS, Amazon S3, SageMaker
- Data pipelines: Development and automation
- Version control: GitHub
Projects
Stock News & Market Movement Prediction (End-to-End):
- Developed an automated system to predict S&P 500 direction using NLP and ML, deployed via a Streamlit dashboard.
- Engineered a daily data pipeline using GitHub Actions to automate scraping (NewsData.io, yFinance) and preprocessing.
- Applied VADER and LDA Topic Modeling to extract sentiment features for a Random Forest classification model.
Best Buy Market Analysis & Price Prediction:
- Scraped 5,000+ product records using BeautifulSoup to analyze pricing trends and savings distributions., Conducted statistical testing using Pearson Correlation and VIF to handle multicollinearity and optimize features.
- Implemented Lasso Regression for feature selection and compared Decision Trees and SVM for price outcomes.
Tableau
https://public.tableau.com/app/profile/ceren3839
Certification
- AWS Academy Cloud Foundations Certificate
- COOP Data Analytics Certification
- Project Shine Coach Certification
Languages
- Fluent in English
- Fluent in Turkish
Timeline
Data Management Associate
ASIAN PACIFIC ISLANDER LEGAL OUTREACH
01.2023 - Current
Bill Management Analyst
BERKSHIRE HATHAWAY
10.2018 - 06.2021
M.S. - Business Analytics
California State University, Sacramento
Data Analytics Fellowship -
COOP Careers
B.A - Economics
San Francisco State University