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 background for a Data Engineer or Analytics Engineer role.Projects:(1) Dashboard DeveloperIndustry: InsurancePrepared the semantic layer (Model View) in Microsoft Power BI. Data is coming from Oracle SQL and Excel.(2) Data Analyst / Dashboard DeveloperIndustry: FoodUsed 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 AnalystIndustry: E-CommerceUsed 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 AnalystIndustry: LogisticsDetermined 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 AnalystIndustry: Poker and Fantasy FootballIdentified potential winning teams by analyzing previous match performance and current team strength of schedule.

• 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

• 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 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

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