Database Developer Net

Majid Assadi Page *

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 C#,

.Net framework, Microsoft SQL server, Web API, Agile methodology, and Machine Learning.

TECHNICAL SKILLS

Languages:

Methods:

Tools:

Web:

O.S.:

C#, JAVASCRIPT, SQL, HTML, CSS, AODA, JSON, AJAX, XML, DELPHI Client-Server, Web API, SOAP (Backend), Web UI (Frontend) Visual studio, VS Code, SQL Server Management Studio, Git, SourceTree, Jira, IIS

Managed (.NET) and Unmanaged (DLL)

Windows

PROFESSIONAL EXPERIENCE

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

• 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 Majid Assadi Page 2

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

• 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.

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

• Created a sample SOAP application to present transaction transferring in XML 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. Also designed and implemented a web-based Integrated Industrial System, used C# in .Net environment to replace this client/Server version, you can access some videos that explain the features of this web-based system on http://wbiis.com.

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