Looker
Hi, I’m
CHIYOMI SONODA
Data Warehouse Engineer
Bakersfield,CA
Summary
Innovative and highly skilled Data Warehouse Engineer / Business Intelligence Developer with 7+ years of experience in designing, building, and optimizing scalable data infrastructure. Proficient in data modeling, ETL development, and leveraging big data technologies to drive insightful business analytics. A results-oriented professional ready to bring exceptional data expertise and innovation to maximize organizational success.
Overview
11
years of professional experience
1
Certificate
6
Languages
Work History
Verstand AIMcLean, VA
Data Warehouse Engineer
08.2022 - Current
Job overview
- Revamped and automated ETL pipelines by seamlessly integrating diverse data sources such as CockroachDB, Apex, Hybris, and more. Orchestrated the extraction, transformation, and loading of data into BigQuery, streamlining subsequent analysis and reporting operations.
- Led the migration of data transformations through dbtlab, implementing collaborative development best practices including code reviews, pull requests on GitHub, and automated testing.
- Architected and executed an interactive transaction for migrating legacy inventory transformations to the current dbt Cloud system, resulting in a significant time and cost reduction of at least 40%.
- Established data quality standards and implemented data profiling techniques to proactively identify and rectify data anomalies, achieving a remarkable 25% enhancement in data accuracy.
- Implemented robust processes and procedures to handle consumer data access requests, deletion requests, and opt-out preferences in full compliance with CCPA guidelines.
Verstand AIMcLean, VA
Business Intelligence Developer
09.2021 - 08.2022
Job overview
- Created real-time interactive dashboards using both Power BI and Looker, empowering business executives to enhance sales and optimize customer service through insightful identification of cancellations and curbside latency.
- Performed thorough analysis of business requirements, system capabilities, and product performance, facilitating the identification of product requirements, troubleshooting of issues, and delivering comprehensive end-user training.
- Developed an effective methodology enabling top executives to prioritize critical analytics requirements and translate them into actionable tasks within a stringent 5-day timeframe.
- Implemented optimized star schemas and snowflake schemas, streamlining data retrieval for analytical reporting and boosting report generation efficiency by an impressive 20%.
- Designed and executed role-based security models within the business intelligence (BI) environment, ensuring controlled user access and safeguarding sensitive information in alignment with stringent business requirements.
Dignity Health Management Services OrganizationBakersfield, CA
Data Analyst II
03.2019 - 08.2021
Job overview
- Developed an extensive portfolio of over 200 SSRS and Power BI reports, significantly reducing the development cycle time by at least 40% and delivering substantial business value.
- Collaborated closely with business users, analysts, and stakeholders from various domains, including claims, authorizations, enrollments, pharmacy, and laboratory, to gather comprehensive requirements and develop reports tailored to their specific needs.
- Exhibited a strong aptitude for identifying and defining data-related problems, formulating analytical approaches, and devising innovative solutions to tackle complex business challenges effectively. For instance, by automating authorization work flow, it resulted in the reduction of processing time by at least 30%.
- Proficiently applied data cleaning, data wrangling, and data preprocessing techniques to ensure high data quality, resolve inconsistencies, and proficiently handle missing values.
IKEALebec, CA
CDC Flow Planner and Capacity Team Leader
01.2017 - 03.2019
Job overview
- Led and managed a team of 13 flow planners, capacity planners, and article administrators, providing guidance, coaching, and performance management.
- Oversaw end-to-end logistics operations, including transportation, warehousing, and inventory management.
- Implemented strategic initiatives to optimize supply chain processes, resulting in 20% reduction in lead times and 30% cost savings.
- Leveraged data modeling and statistical analysis skills to identify trends, draw meaningful conclusions, and drive data-driven decision-making. Proficient in analytical tools such as SQL, Brio, R Studio, and Excel, enabling effective analysis and reporting.
IKEALebec, CA
Customer Distribution Logistics Analyst/Super User
05.2016 - 01.2017
Job overview
- Utilized R Studio and Oracle SQL to conduct comprehensive data analysis, identifying trends, patterns, and areas for improvement in logistics operations.
- Applied predictive modeling, forecasting, and simulation techniques to optimize supply chain operations, enhance decision-making, and improve operational efficiency.
- Led project planning initiatives, defining project scope, objectives, and deliverables, and developing comprehensive project schedules and resource allocation plans.
IKEALebec, CA
Accounts Payable and Payroll Specialist
06.2014 - 05.2016
Job overview
- Proficient in generating financial reports related to accounts payable and payroll, such as aging reports, cash flow statements, and expense analysis. In addition to tax regulations, wage and hours laws, and internal control procedures.
- Oversaw the day-to-day processing of payroll for 500+ employees, including review of timesheets and computing pay in accordance with FLSA.
IKEALebec, CA
CDC Article Administrator and Capacity Planner
11.2012 - 06.2014
Job overview
- Systems training and technical support, utilizing SQL reports for capacity issue diagnosis, mapping optimization, and business operations analysis.
- Monitoring of daily achievements, tracking key performance indicators (KPIs), project management, and improvement planning to optimize warehouse shipping efficiencies.
Education
Boston UniversityBoston, MA
Masters of Computer Information Systems from Data Analytics
07.2015 - 06.2017
University Overview
- [3.74] GPA
University of California of IrvineIrvine, CA
Bachelor of Science from Applied Mathematics
09.2008 - 06.2012
Skills
Data Warehousing and ETL
Data Quality and Governance
Data Pipeline Orchestration
Dimensional Modelling
Teamwork and Leadership
Project Management
Root Cause Analysis
Coaching and Mentoring
Software
Google BigQuery
Dbt Cloud
PowerBI
Apache Airflow
Github
Google Cloud Storage
Certification
LookML Certification
Timeline
Data Warehouse Engineer
Verstand AI
08.2022 - Current
Business Intelligence Developer
Verstand AI
09.2021 - 08.2022
Data Analyst II
Dignity Health Management Services Organization
03.2019 - 08.2021
CDC Flow Planner and Capacity Team Leader
IKEA
01.2017 - 03.2019
Customer Distribution Logistics Analyst/Super User
IKEA
05.2016 - 01.2017
Boston University
Masters of Computer Information Systems from Data Analytics
07.2015 - 06.2017
Accounts Payable and Payroll Specialist
IKEA
06.2014 - 05.2016
CDC Article Administrator and Capacity Planner
IKEA
11.2012 - 06.2014
University of California of Irvine
Bachelor of Science from Applied Mathematics
09.2008 - 06.2012