Syeda Nimra Fatima

Project 1: Middleware Migration to Azure

Aim: Migrate existing functionalities, including payment and order management systems, from Middleware to Microsoft Azure for an Australian retail company

Approach :

• Developed Azure Functions using C# with HTTP, Timer, and Service Bus triggers.
• Integrated Azure Key Vaults and exposed Azure Functions through API Management (APIM).
• Built APIs for PostgreSQL procedure-based systems, optimizing SQL procedures for order management.
• Automated build, test, and deployment with GitHub Actions, including Azure resource deployment using Bicep files and ARM templates.
• Created and triggered workflows in GitHub Actions for continuous integration and deployment.
• Created logical models and wrote C# modules based on requirements.
• Tested and debugged modules to ensure error-free deployment.
• Set up dashboards and alerts for post-deployment validation.

Tools and Technologies: C#, .Net, GitHub Actions, ARM Templates, Bicep, Azure (Functions, Service Bus - Topics, Queues, and Subscriptions, KeyVaults, APIM), Oracle, PostgreSQL, Visual Studio.

Project 2: Order Management System for a Retail Client

Aim: Develop an efficient order management solution for a prominent Australian electronics retail chain with 150+ stores, utilizing cloud technology to handle a large volume of online and in-store orders.

Approach:

• Developed an order management system using a microservices architecture, enabling modular scalability and independent deployments.
• Developed key functional modules such as packing, picking, consignment, and customer communication, improving overall order processing efficiency.
• Leveraged Azure Function Apps to build modular components and APIM for interaction with PostgreSQL and external systems.
• Automated build, testing, and deployment processes across multiple environments (DEV, TST, UAT, PRD) using GitHub Actions for CI/CD, including Azure resource deployment via ARM templates.
• Improved system performance, achieving a 98% SLA improvement, while optimizing and streamlining warehouse operations.

Tools and Technologies: C#, GitHub Actions, ARM templates, Microsoft Azure (Azure Functions, Azure Service Bus, Azure Topics, Queues, Azure Subscriptions, Application Insights, Dashboards, KQL, Azure Alerts).

Project 3: Quality Management, Testing and Audit Application

Aim: Develop an application that integrates form creation, role-based access control, dashboards, and an alerting mechanism to streamline internal processes and provide oversight for admins.

Approach:

• Contributed to backend development, including requirements gathering, architectural design, and documentation.
• Implemented RESTful APIs with Django Rest Framework for user authentication, CRUD operations, and dashboards.
• Created role-based access control and managed PostgreSQL databases.
• Set up automated backups with pgAgent and deployed the application on Amazon EC2 and Hyper-V.
• Enabled users to create custom forms and reports, with dashboards providing dynamic insights.
• Developed an alert system for anomaly detection and resolved vulnerabilities identified in assessments.

Tools and Technologies: Python, Django, Django Rest Framework, PostgreSQL, VS code, Hyper-V, AWS EC2 instance, ZAP, Apache, Nginx.

Project 4: Transport Management System

Aim : To Integrate the New Transport Management System into existing Order Management System and Point of Sale for an Australian Retail Client, driving API Integration and establishing best practices, while managing various integrations and deployments on Azure.

Approach :

• Designed and implemented API integrations between the TMS, Order Management System, and Point of Sale, ensuring smooth data flow.
• Developed optimized .NET services, enhancing real-time shipment tracking and transport coordination.
• Engaged with stakeholders to gather requirements, demonstrate features, and refine system functionalities.
• Implemented robust logging and monitoring to track API interactions and ensure system reliability.
• Utilized Azure Service Bus for asynchronous messaging, improving the efficiency of data exchange.
• Followed Kanban agile methodology for efficient planning, development, and deployment.

Tools : C#, .Net, Microsoft Azure (functions, APIM, Service Bus), PostgreSQL, Postman, Git

Project 5: System Insight Service

Aim : Developed a Windows Service application to retrieve, process, and store system information, ensuring seamless data and cloud-based storage integration.

Approach :

• Designed and implemented a Windows Service application to automatically retrieve system information (CPU usage, memory, disk details, etc.).
• Created an MSI setup package for easy deployment and installation as an executable service on servers.
• Configured the service to run in the background, periodically collecting and storing system logs in Azure Blob Storage.
• Integrated with Azure Blob Storage, ensuring secure and efficient storage of system logs and performance data.
• Deployed and tested the application on multiple servers, ensuring reliability and scalability.
• Impact: Provided a scalable and automated solution for system performance monitoring, enabling real-time tracking, historical analysis, and cloud-based reporting.

Tools and techniques : C#, Windows Services, MSI Setup, Azure Blob Storage, .NET Framework

Project 6: Master Data Management System for a Generator Manufacturing Company

Aim : Worked on the creation of a .NET system to manage customer, dealer, and vendor data across multiple subsidiaries. The project integrated data from the company's ERP system to improve data accuracy and streamline operations.

Approach :

• Developed a .NET-based solution to consolidate customer, dealer, and vendor profiles across multiple business units, ensuring unified data management.
• Designed and implemented a process to extract data from SQL Server Management Studio (SSMS) and load it into an Azure Storage account for scalable storage and further processing.
• Implemented features for data validation and synchronization to prevent duplication.
• Optimized the user interface for file loading, which initially took 1 minute to load due to deep folder structures and inefficient indexing. By unbranching the folder hierarchy and implementing indexing strategies, the load time was reduced to just 10 seconds, significantly improving user experience and system performance.
• Collaborated with cross-functional teams to gather requirements and ensure smooth implementation.

Tools and Technologies : C#, ASP.NET Core Web API, Entity Framework Core, SSMS, Azure Blob Storage, Data Validation.