Sonya Liu

Software Application Developer

Developing retail data management services using .Net, Blazor and Microsoft Azure Stack as part of the software team

Categorization System

• Architected and developed a scalable product categorization system using .NET 6 and Blazor Server, integrating with Azure cloud services
• Implemented a hierarchical category management system that enables creation and maintenance of complex parent-child relationships between product categories
• Developed real-time collaborative editing capabilities using Azure SignalR, allowing multiple users to simultaneously work on category management

Query Management System

• Developed a centralized system to manage database queries, making operations consistent across all enterprise applications.
• Designed a flexible query templating system allowing applications to define custom filtering and sorting parameters
• Built a .NET 6.0 API layer with Azure SQL Database integration and Application Insights monitoring, with automated validation and error handling

Retail Product Categorization Automation

• Developed a hybrid search system to automate retail product categorization, using Python and Pandas for data cleaning and organization
• Implemented OpenAI embeddings to enable accurate similarity matching across product categories
• Integrated Pinecone vector databases for efficient query processing and scalable search functionality
• Collaborated with cross-functional teams to ensure the solution aligned with business needs and enhanced operational efficiency

Software Application Developer

Developing web applications using .Net and Microsoft Azure Stack as part of the IT Operations team

Image Server

• Designed and implemented a responsive Single Page Application utilizing Blazor Server, JavaScript and Bootstrap
• Developed secure web APIs that allows users to access images through encrypted links
• Leveraged Telerik UI components in Blazor to create visually compelling and user-friendly data presentation

Sales Order Management System

• Used Azure durable Functions and logic app for Implementing Web APIs which maps quotes from Salesforce CPQ to cloud storage
• Utilized ADO.NET for data connectivity and manipulation
• Leveraged the Test Explorer in Visual Studio for organization, execution, and debugging of unit tests
• Assisted in cloud transformation, migrating legacy ERP data to Azure storage

Changepoint/Outlook Calendar Sync

• Leveraged Microsoft Power Automate to develop a workflow allowing users to synchronize work tasks from Changepoint with Outlook
• Implemented Azure Durable Functions to manage tasks from Changepoint, integrating it with Graph API for manipulation of calendar events
• Implemented Microsoft Graph for user authentication, while also facilitating the extraction and update of user data

• Assisted in creating a website that streamlines user interactions by facilitating online submission of permit requests
• Developed Web pages with ASP.NET MVC 5.2.3.0 and Razor is utilized as view engine
• Created stored procedures and written queries for Oracle database
• Designed and developed adaptive web pages at client-side using HTML5, CSS3 and validations using jQuery