Stack Developer Machine Learning

Majid Assadi, BSc.

Application Design and Development

Phone Number: 647-***-****

Email address: *****.*****.******@*****.***

North York, ON, M2M 2K9

PROFESSIONAL SUMMARY

I am a full stack developer, and my main expertise is in designing and developing, Frontend and Backend web-based applications using Azure DevOps, React, Delphi, C#, .Net framework- Core, Microsoft SQL server, Azure Data Studio, Microsoft Report Builder (RDL), Web API, Agile methodology, and Machine Learning.

TECHNICAL SKILLS

Languages:

Methods:

Tools:

Web:

O.S.:

React, C#, JAVASCRIPT, SQL, HTML, CSS, JSON, AJAX, XML,

Client-Server, Web API (Backend), Web UI (Frontend)

Azure DevOps, Visual studio, VS Code, SQL Server Management Studio, Microsoft Report Builder (RDL), Azure Data Studio, Git, SourceTree, Jira, IIS

Managed (.NET), Unmanaged (DLL), Azure Cloud

Windows

PROFESSIONAL EXPERIENCE

Senior Database/Application Developer, Navvia. Toronto April 2022 – Aug 2025

Navvia is a leading BPMN company founded in 1999 with the vision of providing organizations with the software, templates, and services to simplify the design, documentation and implementation of ITSM and business processes.

As a DBA I improved SQL server performance by:

oCatching all the slow queries and rewriting or converting them to stored procedures and table-valued functions

oAdding options to stored procedures and parametrized queries to force the SQL server to recompile and run the most optimal execution plan

oAdding necessary indexes and removing not useful indexes on each table.

oWriting special queries to find and safely remove all orphan records in all tables

oCreating a special stored procedure, that dynamically creates an Elastic pool, to restore data from a Point-In-Time transactional Backup and synchronize the tables in Production. For example, if a customer was accidentally deleted from production, this procedure would restore the customer’s data from backup and update the related tables in production to the given Point-In-Time.

oOther stored procedures such as those that would safely remove an organization and all its depended information without leaving any orphan records.

oJob created to run once a week, the task was to run a stored procedure that defragment all fragmented indexes.

As Database Developer I created:

oDeveloped ACID compliant stored procedures for New Diagram Processing software (Version 1).

oCreated all the stored procedures and table-value functions that “API Dashboard” application need (select, insert, update, and delete), these procedures have many steps and all of them are created in a “try catch” transaction block, to rollback in case of any issues

oCreated around 30 stored procedures for the company’s new product “Cyber Security Assessment” that is currently under final testing and will be released in September of 2025

oMoved the company’s Reports system from SSRS (SQL Server Reporting Service) to a 3rd party’s (Bold Report) software

As Developer:

oUsing C#, Visual Studio, and SQL server Enterprise manager, I have fixed bugs in our existing software to make it more robust. This software is a webform application

oTo migrate our database and application to Azure as Azure hyperscale SQL database and Azure App service, we needed to migrate SSRS to Power BI too, but using Power Bi was very expensive solution, I implemented a new report server platform (Bold Report) and migrate SSRS to this software with a fraction of cost, and then we migrate to Azure.

oI have created two separate applications for the above mentioned Diagram processing software (Version 1) in C#, .Net Core for an API backend, and .Net Core MVC for its frontend, JavaScript and 3rd party’s (Sync fusion) software.

oUsing Microsoft Report Builder software and Bold Report Designer, I’ve created all the reports (RDL files) for the company’s new product (Cyber Security Assessment)

oI created a new application using C#, .Net Core, JavaScript, 3rd party’s (Sync fusion), and React called DASHBOARD to enhance the user interface of the current main application.

,

Database/Application Developer, Reamined Systems Inc. Toronto April 2000 – Feb 2022

Reamined is a government affiliated company that provides Online Property Tax Analysis (OPTA) for Ontario’s Ministry of Finance and Municipal Affairs.

•Created Web API (Backend), Web UI (Frontend), and used complex structured JSON. Visual Studio 2019, C#, Web API, SQL server, Stored Procedure, Table Valued Functions, JSON, and AODA compliant

•Worked with a variety of databases, mainly SQL Server.

•Created databases, tables, indexes, triggers, stored procedures, and functions.

•Used sets of triggers on major tables to keep a record of the changed data in a separate table in XML format. A Stored Procedure runs on this table to find who changed the data, what the changed data was, when and why it was changed, as well as the tool that was used to make the change. Further processes are determined based on the changed data.

•Used Import Export Utility, write scripts to transform loaded data (ETL) to make it usable for other systems.

•Used SQL Profilers to identify Slow Queries and make changes to optimize them

•Used complex stored procedures to create an auto form filling process on received transactions, that reduced 3.2-3.7 FTEs (2mts of work by 3 people per task, 7-8 tasks per year) to 56-64 hours of automated process each year

•Used sets of triggers to save changes made in more than 10 large tables to a transaction table and made it possible to go back in time and view all those changes

•Created an application that calculates statistics to create an optimal number of Tax Calculation processes to run simultaneously, while checking the CPU and Memory of the local and SQL server to not exceed the thresholds (Delphi)

•Created a Web based Data Status report used by ministry of Finance and Municipal affairs to check the latest progress of Data preparation in each municipality. To create this, I used Visual Studio 2019, C#, .NET framework, SQL server, Stored Procedure, Table Valued Functions, and AODA compliant

•Created windows and web-based (Unmanaged) applications to track and report the state of all data processing steps for each municipality (Delphi)

•Created an application to check the integrity of a large, distributed dataset. This application uses statistical calculations to set the number of processes needed to run simultaneously. While all these processes check the CPU and Memory of the local and SQL server to ensure thresholds are not exceeded, it is the first created process will act as the control process. Each time this application is executed for the province, it processes over 150,000,000 records. Furthermore, each year, 6-10 million of records are added to these databases. (Delphi)

•Created a customized ETL application to load transactions with different structures and types (e.g., JSON, Text, Excel, Flat File, etc.) to databases. (Delphi)

•Created a sample SOAP application to present transaction transferring in XML (Delphi)

Team Leader, NAMAVARAN Consulting Corporation May 1996- May 1999

•Used Primavera and Microsoft Project to control the construction of the biggest Alumina Powder factory in the Middle East with 4100 activities (21,900,000 M/H in 4yrs)

•Created Material Classification & Standardization of machinery, spare parts, general items, and assets for Gol-e-Gohar Iron ore company with more than 100,000 items and Machineries

OTHER PROJECTS

C# .Net Technical Team Leader, IRC-RHCE Corporation

Designed and developed an integrated client/server systems including Production Planning, Inventory management, Sales, Purchasing, Preventive Maintenance, Office Automation, and Financial Accounting.(Delphi) Also designed and implemented a web-based Integrated Industrial System, used C# in .Net environment to replace this client/Server version.

CERTIFICATES AND EDUCATION

Certificates:

Machine Learning, SCS-3253_021

MCAD, MCP, MCSD, MCPD

MCTS (.Net WebApp.), MCTS (.Net Win App.)

MCITP (Db Admin), MCITP (Db Developer)

https://mcp.microsoft.com/Anonymous//Transcript/Validate

Transcript ID: 818791 Access Code: majidassadi123

Education:

Bachelor of Science in Operation Research, SBU University

Contact this candidate