Tetsuya Hayashi Email & Phone Number

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.
• 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
• 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 managed reporting data infrastructures from the backend, supporting customer acquisitions and lifecycle states, customer engagements, and marketplace campaign configurations to identify.
• 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.
• 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.

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

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