Learn Data Skills
Beta
Yuichi Otsuka

Yuichi Otsuka

Data Analyst

University of the Philippines | Philippines

Technologies

My Portfolio Highlights

My New Course

Introduction to dbt

My New Course

Introduction to Python

My New Github

Data Model and Transformation using dbt, Snowflake, and Airbnb data

My New Course

Introduction to dbt

Quantitative architect, designing solutions with numbers as building blocks.

My Work

Take a look at my latest work.

github

Data Model and Transformation using dbt, Snowflake, and Airbnb data

course

Introduction to dbt

course

Introduction to Python

Python
github

Data Model and Transformation using dbt, Snowflake, and Airbnb data

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Upwork | Aug 2020 - May 2022

Data Analyst / Data Engineer, Trust and Safety

• PostgreSQL (60%), Snowflake (20%) and Python (20%) to develop and maintain rules-based reports • Rundeck to create and maintain downstream data pipelines for the Fraud Detection Team • Performed threshold analysis using hit and catch rates to manage ticket volume / agent workload • Managed migration of reports from PostgreSQL to Snowflake, ensuring scalability and consistency of data • Used SQL and Python for Exploratory Data Analysis (EDA) to identify new data points for feature engineering • Worked with stakeholders to translate business requirements into data- focused solutions • Updated reports to improve runtime by at least 10% • Collaborated with colleagues for mentoring and mentorship opportunities
Show More

Got It AI | Apr 2019 - Jul 2020

SQL Expert, Querychat

• Client consulting via chat support focusing on SQL, with each session lasting from 30 minutes to 2 hours • Solved SQL questions on demand, with topics ranging from data modeling, error handling, query generation, debugging, and SQL best practices • Worked with structured data, and created data models using Querychat framework • Created articles for writing projects that are SEO-optimized on various SQL topics • Worked with leadership to provide training materials

Self-employed | Aug 2017 - Present

Data Analyst / Business and Technical Consultant

Data Analyst / Engineer with experience in technology-agnostic consulting and data analysis. Worked as a software developer for a CMMI Level 5 company. Proficient in SQL, relational databases, and data warehouses. True believer that data engineering is the future of work. Leverage SQL, cross- functional consulting best practices, and software engineering background for a Data Engineer or Analytics Engineer role. Projects: (1) Dashboard Developer Industry: Insurance Prepared the semantic layer (Model View) in Microsoft Power BI. Data is coming from Oracle SQL and Excel. (2) Data Analyst / Dashboard Developer Industry: Food Used Supermetrics and Microsoft Power BI to collect data from Facebook, Pinterest, and Google Analytics. Automated monthly reports to improve efficiency by up to 50%. Monitored brand growth in terms of Social Media Engagement. (3) E-Commerce Analyst Industry: E-Commerce Used Microsoft SQL Server to generate custom reports to determine trending products based on historical sales, compared sales over time periods, and identified inventory that needed restocking. (4) Logistics Analyst Industry: Logistics Determined a cost-effective model to be used for a Freight Transshipment Facility (serving as a Distribution Center). Used integer programming optimization models in R. (5) Trading / Sports Betting Analyst Industry: Poker and Fantasy Football Identified potential winning teams by analyzing previous match performance and current team strength of schedule.

Z-Lift Solutions, Inc. | Oct 2015 - Jul 2017

Analytics Consultant

Assumed the role of a Business and Technical Consultant to handle various clients in the Healthcare and Airline industries. - Implemented various Analytics Use Cases - Predictive Analytics - Liaised with software vendors for canned Analytics Solutions - Google Analytics, Tag Manager - Salesforce Marketing Cloud - Microsoft R

Z-Lift Solutions, Inc. | Oct 2015 - Jul 2017

Business Intelligence Consultant

Assumed the role of a Business and Technical Consultant to handle various clients in the Retail and Telecom industries. - Implementation of Business Intelligence Solutions - Dashboards and Reports

Azeus Systems Limited | Jun 2012 - Oct 2015

Software Developer

Assumed the role of a Software Developer functioning across various fields in several projects. I have been working with teams across the entire Application Life Cycle (Development, QA, Production), using both Modified Waterfall and Agile Methodologies. Assumed roles in: (30%) Business Intelligence and Database Programming (30%) Build and Release Management (20%) Software Configuration Management and Application Server Management (15%) Database Administration and Reports Development (5%) Web Development • Business Intelligence (OBIEE 11g) and Database Programming - OBIEE RPD Modeling - Oracle BI Answers and Dashboards - OBIEE Row-level Security - Oracle SQL, PL/SQL scripting • Software Build and Release Management - Release QA, preparation, and execution - Build automation (Ant, Hudson, Jenkins) - Configuration change management - Version Control Systems and Methodologies (CVS, Subversion, Git, Eclipse Integration) - Application Database upgrade scripts - Exposure to Modified Waterfall and Agile Methodologies • Software Configuration Management (SCM) and Application Server Management - Streamlining and CMMI Compliance for SCM processes - Project-specific compliance - Post-installation configuration for application servers (Tomcat , JBoss EAP, WebSphere) • Database Administration and Reports Development (Oracle 10g, 11g and 12c) - Database backups (Oracle datapump utility) - Application schema maintenance and upgrades - Oracle BI Publisher • Web development - Proprietary framework

University of the Philippines at Los Baños | Jun 2010 - Mar 2011

Student Assistant

Assist professors in their large classes, perform clerical work, and do other tasks as deemed necessary and appropriate.

My Education

Take a look at my formal education

Bachelor of Science (BS), Applied Mathematics in Operations ResearchUniversity of the Philippines | 2012
University of Perpetual Help System DALTA | 2008

About Me

Yuichi Otsuka

Data Analyst / Engineer with experience in technology-agnostic consulting and data analysis. Worked as a software developer for a CMMI Level 5 company. Proficient in SQL, relational databases, and data warehouses.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free