Yuichi Otsuka Email & Phone Number

Philippines

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.

• 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

• 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

Makati, Philippines

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

NCR - National Capital Region, Philippines

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

NCR - National Capital Region, Philippines

• 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.
• 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.
• Software Configuration Management (SCM) and Application Server Management- Streamlining and CMMI Compliance for SCM processes- Project-specific compliance- Post-installation configuration for application servers.
• 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

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

Bachelor Of Science (Bs), Applied Mathematics

Education record