Avanade Inc.
[Permanent]
Dec 2023 - Present
Senior Analyst / Backend Developer
Tokyo, Japan
- Internal Data Analytics Platform for Semiconductor Manufacturer (Nov 2024 - Present)
- Internal manufacturing analytics platform for data processing, ETL workflows, dashboards, and reporting.
- .NET Core, EF Core, Angular, SQL Server
- Team of 6 to 20, ~115k LOC, 18 dashboard pages, 44 API endpoints
- Built Angular dashboard pages, implemented C# application services, supported ETL and data-processing workflows, and tuned SQL Server queries for aggregation-heavy workloads with indexing and execution plan optimization.
- Enterprise System Design & Digital Transformation Project (Apr 2024 - Oct 2024)
- Web-based system design project that systematized complex client workflows previously handled manually in Excel.
- Requirements analysis, system design, database design, application service design, Waterfall methodology
- Team of 6 to 20 with offshore development teams; 100+ screens and 50+ database schemas
- Led requirements analysis and upstream system design, translating complex client requirements and Excel-based workflows into a practical web system; defined database schemas, application service specifications, and screen designs, and managed delivery progress with offshore development teams.