Mohammad Omar Email and Phone Number

 Designed and developed a comprehensive Absence Management System o Engineered intuitive user interfaces for time off request management using React 18 and ASP.NET Core 6 Web API in C# 10, and Sql Server, ensuring a seamless experience for requesting, viewing and managing requests. o Developed and implemented dynamic grid filtering options using React JS (department, manager, status) with advanced JavaScript and Tailwind CSS, enhancing user customization. o Integrated role-based access control with ASP.NET Core 6 Web API to cater to varying user privileges. o Utilized Redux and Context API for advanced state management, ensuring consistent and reliable data flow. Optimized System Performance and Scalability o Addressed daily production issues related to PTO balances, payroll processes and accruals ensuring accuracy o Implemented Azure Functions with HTTP triggers and event-based architecture using message queues or Service Bus, facilitating asynchronous processing and scalability. o Leveraged Cosmos DB for seamless data storage and retrieval across various components of the system including web APIs and Azure Functions o Employed SQL Server and Dapper for efficient database management and streamlined data access. o Monitored and diagnosed code issues using Azure App Insights, ensuring system reliability and performance. o Developed robust APIs with integration to Swagger OpenAPI, facilitating documentation, while utilizing Postman for testing

 Involved in the development and enhancement of the Software Suite, PRISM, a web-based product that powers the business of federal government by providing software, data and insights that align the acquisition community, grant makers and contractors to best achieve their mission, in an Agile environment  Providing continuous support as well as implementing new features on PRISM utilizing Asp.Net (Web Forms), .Net 4.8, C# 7.0, Oracle 12 C and Spring.Net Gained experience in creating several RESTful Web API services using ASP.NET Web API to generate data(Solicitation/Contracts Clauses) for GSA E-BUY Utilize Postman to test Web API functionality  Involved in identifying root causes in the software, applying the fix, and releasing the patch to clients in a timely manner  Efficiently use Crystal Reports in conjunction with the web-forms based application delivering comprehensive reporting functionality for variety of data source using C# 7.0, ADO.NET and PL/SQL  Effectively identify solutions for software defects and product enhancement by participating in research/spikes

 Conceptualized, developed, and enhanced various toll system web-based applications utilizing C#/ASP.Net (web form based and MVC 5), WCF, VS 2017 and SQL Server 2019  Developed and Consumed Windows Communication Foundation Services (WCF) which interfaces with SQL Server  Identified solutions for critical software defects such as memory leaks in WCF services and leveraging elegant approaches to solve such issues using IDisposable pattern for garbage collection  Wrote and Improved T-SQL stored procedures for verifying data integrity and exemplify expertise in writing clean, clear, and maintainable object-oriented code  Gained experience within the tolling industry coordinating the implementation of toll systems with emphasis on design, development, and testing  Acquired experience in advanced .Net features including task parallel library (TPL) to compose multi-threaded code, Language-Integrated Query (LINQ) to recover data from different sources, such as LINQ to objects, LINQ to XML, and LINQ to SQL, generics for code reuse and dependency injection for a loosely coupled system

 Took charge of designing, creating, and deploying manufacturing execution systems (MES) scanner Android Enterprise App through handheld Zebra android devices that handle the inventory and orders, generates report, support data sharing and multiple sites Used Xamarin.Android and Microsoft technologies (.Net 4.6) for creating native user interface (UI) along with C# 7.0, Microsoft SQL server 2017 for backend, and Microsoft Azure and Managed Google Play as method to publish the application for the organization Executed Xamarin.Android mobile application, adhering to object-oriented standards, through Model View Presenter (MVP) design pattern using N-tier architecture leveraging C# Partook in planning and creating company’s Manufacturing Execution Systems (MES) by cooperating with end users and other teams to resolve concerns, develop solutions, and execute changes through WinForms 2.0, VB.NET, and T-SQL Assisted in converting current WinForms Desktop applications to Windows presentation foundation (WPF) using Model-View-ViewModel (MVVM) pattern Utilized hands on experience with Object-Oriented programming principles, such as inheritance, polymorphism and abstraction, and design patterns such as Model View presenter and repository design pattern Demonstrate skills in troubleshooting SQL performance concerns, upholding DB schemas, formulating complex stored procedures, developed and deployed quality T-SQL code, views, functions, triggers and jobs

 Maintained active involvement with teams in California and Prague in the development and improvement of the company’s point of sale (POS) desktop application, NCR Back Office, a comprehensive software solution for large size restaurant chain’s back office, in an Agile environment Assumed accountability for the deployment of 3-Tier Architecture Application with user interface (UI), business layer, and data access layer which involved utilizing VB.NET and C#.NET including partial classes, generics, interfaces, and object-oriented concepts, along with LINQ for effective communication between data access layer and MS SQL server and enhancement of stored procedures for faster data retrieval Efficiently accessed and updated database through data adapter, dataset, data reader as part of ADO.NET Conceptualized data structures and stored procedures and configure existing stored procedures on SQL Server 2012 while creating stored procs, tables, indexes, and user-defined functions Directly interacted with clients including Wendy’s, Potbelly, and Sodexo to repair defects/bugs and present prototypes of new features and enhancements in alignment with business requirements to clients and product owners Cooperated in writing unit tests through NUnit for all business classes to complete test coverage of the code base Utilized Git for team collaboration and Team Foundation Server (TFS) for version control as well as C#, VB.NET, and ADO.NET (Net 4.5 Framework) in developing and modifying production software Obtained proficiency in developing .Net WinForms 2.0 using C#, VB.NET, T-SQL, Infragistics and Active Reports 10  Leveraged expertise in coding both client side and server-side application Created user controls and custom controls for common purpose in the POS application to avoid redundant coding

 Executed engineering analysis in RCloud which was a web-based integrated development environment that runs R code in a cloud computing environment, while conducting data analysis using Python and R Designed tools for data scientists and prepared statistical reports for developers from RCloud through Python and R

 Researching data and batch issues to identify root cause, fixing defects and documenting batch jobs. Modifying and developing SQL stored procedures, batch scripts and batch jobs in scheduler (Control M). Developing simple stored procedures and SQL scripts, and fixing defects in stored procedures. Assisting in testing batch jobs including loading data for testing purposes. Ramping up development (SQL, Control M, batch, FTP).