Profileimage by Ageev Sergey MS SQL Developer    .Net Developer from

Ageev Sergey

available

Last update: 13.11.2018

MS SQL Developer .Net Developer

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional) | Russian (Native or Bilingual) | Czech (Elementary) | Ukrainian (Native or Bilingual)

Skills

  • MS SQL Server/T-SQL – complex queries, stored procedures (with static and dynamic SQL), table-valued, scalar, CLR functions, DDL and DML triggers, transactions, creation tables, views, schemas, users accounts, change rights, using system views for diagnostics, shrink logs, creation and tuning jobs, maintains plans, optimization, using indexes, rebuild and reorganize indexes, database migration. Expirience – 8 years.
  • C# - C#.NET/ADO.NET/Windows Forms. Expirience – 4 years.
  • HTML, CSS, PHP, JavaScript (jQuery)/Ajax, XML – creation Web Pages. Expirience – 6years.
  • BI – 1year

Project history

Project “A2800”
Project Description:Finalization of software for a control system that calculate the rolling plan (regime of drafts) for plate mill. The results of calculations are displayed on the website through which user can do interventions to control system for recalculation of rolling plan.
Customer:PJSC AMK
Involvement Duration:6 months
Project Role:Junior software engineer
Responsibilities:
  • Code development.
  • Development build and deployment  of system.
  • Product support and documentation maintenance

Project Team Size:2 team members
Tools & Technologies:Web Services, SQL Server, VSS, C, C++, VB, CSS, SDD, XML, Apache
Project “Production Planning”
Project Description:Planning of Production program. Calculation day production for plate mill using several criterions: technological delays, features of each profile (using hold or not, dimensions, mechanical properties). Creation in fast report or export to Excel various reports – day planning, month order book, order directions, stock of blanks etc. Add page for planning of the slab landing.
Customer:PJSC AMK
Involvement Duration:3 years
Project Role:Middle Software engineer
Responsibilities:
  • Development of sql stored procedures for coding of technological model, creation tables for store resulting data or using as reference.

Project Team Size:3 team members
Tools & Technologies:MS SQL Server 2005, MS SQL Management Studio, Visual Studio 2008, 2010, Windows Forms, T-SQL, VB.NET, Fast Report, Excel
 
Project “Calc heating time”
Project Description:Calculation of slab time heating program. Using the model for slab heating we can calculate required heating time, exclude overheating of slabs and increase mechanical properties of the good plate. The program has three tabs: first – settings for calculation, second – table data with time heating for zones and total and also linear charts where set and calculated zone temperatures are showed.
Customer:PJSC AMK
Involvement Duration:3months
Project Role:Middle Software engineer
Responsibilities:
  • Architecture and design
  • Code development
  • Modeling

Project Team Size:2 team members
Tools & Technologies:C#.NET, Windows Forms, Visual Studio 2010. MS SQL Server 2005, T-SQL, Stored Procedures, Creation tables. ADO.Net, Git



Project “Planning Slab Charge”
Project Description:Set of a list of slabs ordered according to criteria for charging in a heating furnace
Customer:PJSC AMK
Involvement Duration:6months
Project Role:Middle Software engineer
Responsibilities:
  • Architecture and design
  • Code development
  • Modeling

Project Team Size:2 team members
Tools & Technologies:C#.NET, Windows Forms, Visual Studio 2010. MS SQL Server 2005, T-SQL, Stored Procedures, Creation tables. ADO.Net, Git
Project “RBF Neural Network”
Project Description:Freelance work
Customer:Clients of the site Kursovik.com
Involvement Duration:25 days
Project Role: Design Radial Basis Functions Neural Network controller that set value to automation object
Responsibilities:
  • Architecture and design
  • Code development
  • Modeling

Project Team Size:1 team member
Tools & Technologies:C#.NET, VisualStudio 2010, MS SQL Management Studio, MS SQL Server 2014
Windows Forms
Project “Inventarization”
Project Description:Design the forms for working with Inventarization documents for revision a good quantity on the market
Customer:Employees of the trade center 
Involvement Duration:1 year
Project Role: Design the forms for working with Inventarization documents for revision a good quantity on the market
Responsibilities:
  • Architecture and design
  • Code development
  • Modeling
  • Report Design

Project Team Size:2 team member
Tools & Technologies:C#.NET, 2017, MS SQL Management Studio, MS SQL Server 2016,
Windows Forms, Custom Entity Framework
Project “Furniture Service”
Project Description:Design the application to perform delivery, lift and additional services for clients.
Design DWH, OLAP cube for performance Furniture Service data.
Customer:Employees of the trade center  
Involvement Duration:120 days
Project Role: Design the forms for application
Responsibilities:
  • Architecture and design
  • Code development
  • Modeling
  • Report Design

Project Team Size:2 team member
Tools & Technologies:C#.NET, 2017, MS SQL Management Studio, MS SQL Server 2016,
Windows Forms, Custom Entity Framework

Local Availability

Only available in these countries: Ukraine
Profileimage by Ageev Sergey MS SQL Developer    .Net Developer from MS SQL Developer .Net Developer
Register