Developing a Full Stack (Front-end and Back-end) Modern Serverless Fast Multi-function Web Portal that includes CRM and ERP system for Strata Management Community. The front-end is NextJS (Framework for ReactJS Library) and Back-End is NextJS API. The database used is SQLServer2022. Other tech libs used along-side are TypeScript, Prisma ORM (for SQLServer), Tailwind, Radix CSS, NextAuthJS. The functionalities include Customer Management, Products and Inventory, Sales, Logistic and Procurement, Reports, File management, Integration and job scheduler. Security modelling is crucial: User authentication is handled by NextAuth, this includes: OAuth 2.0 Google Identity Provider, Open ID Connect (SqlSelver) amd JWT to secure the API

Develop & maintain Multiple Body Corporate Management Web Portals. The portals are built on top of Kentico (ASP.Net) CMS framework. Database used is SQLServer. The functionalities include multiple sites, Owners Corporation Management, Jobs Tracking, Accounts Payable and Cashbooks. Payment Gateway and Budgeting. SOA Environment. Develop Secure REST API using ASP.NET Core 2.1, .Net 6, VS2022, Identity Server 4, OAuth 2.0, OpenID Connect, 2FA Enabled and JWT Access Token, Office365 SharePoint Doc Lib Integration (Graph API). Utilising SQLServer Data Tools for BI ETL Process (SSIS), Data migration and files migration, Managing Development Projects, Mentoring & Leading the Team in Agile environment.

SSIS/ETL Developer. Integrating or developing automatic processes between financial system (Sage) and Legacy Software with Dynamic 365 - Operation and Finance (ERP). Technology involved: SQL Server 2016, VS2017 and using OData Service Provider and Recurring Integration in Data Management to integrate with Dynamic 365 - ERP (Operation and Finance). In Recurring integration Script Task is used to call D365 API to transmit D365 Entity details in XML format. The task is to transmit Employees, Logistic, Procurement and Journal data from the Legacy systems to D365. When designing the processes there are a lot of validation steps to consider as the business processes are complex

- Microsoft .Net Software Development. ASP.NET MVC Core - Entity Framework 6.0- Angular 6.0 and Typescript- Domain Driven Design - WebServices and Systems Integration- Web API (Rest) and System Integration- Salesforce CRM integration with Microsoft.Net- SQLServer OLTP Development (SQL Scripts, Store Procedures, Views) - Business Intelligent Development - SSAS (OLAP - SqlServer Analysis Services) - SSRS (SqlServer Reporting Services) - SSIS (SqlServer Integration Services) - MDX Scripts- Agile Methodology (JIRA)- Repository: SVN, Git, Microsoft Visual Studio Team Services- BPMS (Business Process Management System) Life CycleProjects done in 2018: Project 1: StarTrack Consignment Note. Integrating the inhouse Legacy software (Asp.Net MVC) to generate and print the Con Note label via StarTrack Services. Project 2: Braintree (Paypal) payment gateway. Allowing APT to make transaction on the cruise ships. The integration helps helps finance department to channel payments to correct Journal. It is a multi currencies system used in AU, EU and Asia. (ASP.Net, Membership Role based security model)Project 3: Angular 5.0 Integration with ASP.Net Core MVC/API. Implementing JWT Securiy Token at the API Level with Asp.Net Identity at the UI level to authenticate users to enter the website and call the API. Angular services are used to call ASP.Net Core API.App Support: AngularJS (Angular 1) app. Tour Personaliser. An App that consumes Asp.Net REST Web API with SQL Server Database. Sample project done in 2017: Mobile apps with ASP.Net WebAPI + SQL Server 2012 BI Suite (SSIS, SSAS, SSRS). Project Description: "Digital Concierge". Integration between a mobile app and ASP.NET WEB API. The app can view pax & tours info & itineraries and fills out surveys. The survey answers are pushed into SSAS Database. SSIS is used to perform ETL process to prepare the Datawarehouse. SSRS queries are written using MDX quering the SSAS cubes

- Software Development: Agile, Supply Chain and ERP, Web Portal: Asp.Net Front-End, SQLServer Back-End, E-Commerce Websites- Database Design, Development and Implementation: SQLServer T-SQL- ERP: Pronto- MVC.Net Framework- Domain Driven Design- Responsive Design (Bootstraps)- .Net 4- VS2010/VS2013- Javascript Framework: Angular- SQL Server 2008Responsibilities:- Supporting and Developing Online Catalogue and Inventory System written in ASP.NET and SQLServer Backend.- Supporting and Developing over 70 E-Commerce Store websites around Australia. Websites are written in ASP.NET and SQLServer Backend.- Supporting and Developing Integration Process between the Inventory System and E-Commerce Websites.

- Software Development and Support of Retail, Consumer or Public Websites and The Online Booking Engine, CMS (Content Management System) using ASP.NET 3.5, Windows Services to run auto processes- Database Development and Support : T-Sql Stored Procedures- Reporting using SSRS- CSLA Business Object Framework- Cruise Control and Ants.Net (Continuous Integration Tool )Responsibilities:- Supporting and Developing Jetset and Travelword Online Ticket Booking Engine. (ASP.NET, SQLServer 2008). This included Payment Gateway Integration and Credit Card Validation against Fraud based on GeoIP location.- Supporting and Developing Jetset and Travelworld Online Product Inventory System. (ASP.NET, SQLServer 2008)

- Software development and Support of a Property Management System using ASP,NET 3.5., Web Services - Database development and Support: T-SQL Store Procedures and Reporting

- Software Development and Support of a Customer Provision System for M2 Telecommunication consuming Optus's Webservices (SOAP), M2 Billling System, Finance Calculator for KRW.- The Technolgy used is ASP.NET and SQL Server

- Software Development and Support of the front end and back end applications of EAN barcoding database, membership and barcode testing results.- Database Development and Support : SQL Server Administrator, T-SQL Store Procedures