Tetsuya Hayashi Email & Phone Number

Seattle, Wa, Us

United States

• Designed, developed and maintained ETL processes to extract data from operational servers, master data service, and third party REST API sources to support numerous business critical reports for accounting, cash operations, field operations and analyst teams• Extended and developed a tabular model cube to allow business users to build and visualize key business KPIs• Identified data inconsistencies and built data health check system to extract data from 2 sources, compare, and alert… Show more • Designed, developed and maintained ETL processes to extract data from operational servers, master data service, and third party REST API sources to support numerous business critical reports for accounting, cash operations, field operations and analyst teams• Extended and developed a tabular model cube to allow business users to build and visualize key business KPIs• Identified data inconsistencies and built data health check system to extract data from 2 sources, compare, and alert specified users failed results• Collaborated a team of 5 engineers to design a modern data warehouse architecture to meet executive requirements• Migrated legacy reports using the Azure data warehouse Show less

Greater Seattle Area

• Designed, developed and maintained a specialized data warehouse using Microsoft SQL Server to support the most viewed dashboards in MS Bing Ads for analysis by functional teams• Developed custom .NET library that wraps Cosmos VC Client API with client classes to automate Cosmos data pipelines for production reporting environment • Designed, developed and managed reporting data infrastructures from the backend, supporting customer acquisitions and lifecycle states, customer… Show more • Designed, developed and maintained a specialized data warehouse using Microsoft SQL Server to support the most viewed dashboards in MS Bing Ads for analysis by functional teams• Developed custom .NET library that wraps Cosmos VC Client API with client classes to automate Cosmos data pipelines for production reporting environment • Designed, developed and managed reporting data infrastructures from the backend, supporting customer acquisitions and lifecycle states, customer engagements, and marketplace campaign configurations to identify opportunities for improvements in spends• Designed and internally distributed a desktop application that applies threads to enable automatic data pulls of over 150,000 customer accounts, reducing manual pull time from hours to minutes while minimizing server stress • Designed and developed a normalized database system to consolidate and organize previously unenforced business rules and identify violations, producing a clean book of business and incentivizing the sales team to strategically assist recently onboarded customers Show less

Glendale Heights, Il

• Established a dedicated BI department, redesigning and automating new and existing reports for marketing, sales, inventory management, warehouse, and accounting using Microsoft SQL Server, SSMS, and Microsoft Dynamics AX• Developed centralized, web-based dashboards through ETL processes, extracting data from Microsoft Dynamics AX, staging it in a reporting database, and utilizing Logi Analytics for visualization• Developed a program in C# based on the needs of the executive team to… Show more • Established a dedicated BI department, redesigning and automating new and existing reports for marketing, sales, inventory management, warehouse, and accounting using Microsoft SQL Server, SSMS, and Microsoft Dynamics AX• Developed centralized, web-based dashboards through ETL processes, extracting data from Microsoft Dynamics AX, staging it in a reporting database, and utilizing Logi Analytics for visualization• Developed a program in C# based on the needs of the executive team to extract data through the Google Analytics API and visualize on Logi Analytics dashboards in an effort to centralize reporting • Organized and facilitated ongoing discussions with executives and stakeholders for further improvements on the departmental dashboards Show less

Glendale Heights, Il

• Responsible for preparing monthly sales report by product using Microsoft Excel VBA• Managed existing Excel VBA scripts to expand the scope of monthly sales report which led to inventing a new, more dynamic view of the report and presented to the sales team• Organized trade shows by coordinating with trade show host companies, shipping companies and vendors to support the shows• Researched competitors’ lines of products via competitors’ websites and old industry magazines and… Show more • Responsible for preparing monthly sales report by product using Microsoft Excel VBA• Managed existing Excel VBA scripts to expand the scope of monthly sales report which led to inventing a new, more dynamic view of the report and presented to the sales team• Organized trade shows by coordinating with trade show host companies, shipping companies and vendors to support the shows• Researched competitors’ lines of products via competitors’ websites and old industry magazines and bound them into physical folders for use• Responsible for curating quarterly promotional items and holiday seasons for sales team & clients• Managed to package promo items and catalogs for shipments to sales personnel as well as trade shows Show less

Skokie, Il

• Managed a proprietary trading account using FutureSource Workstation• Accountable for executing trades using trend following system and trading systems

Greater Los Angeles Area

• Responsible for designing and developing business models for P&L calculations• Communicated with management team to maximize the functionality of the models

Graduate Certificate In Software Design & Development, School Of Science, Technology, Engineering & Mathmatics

Graduate Certificate in Software Design & Development covers various aspects of software engineering practices from advanced data.

Bachelor Of Business Administration (B.B.A.), Finance, General