
Tigran Karapetyan
Verified Expert in Engineering
SQL Developer
Yerevan, Armenia
Toptal member since June 18, 2020
Tigran is an expert database developer with over a decade of experience primarily with .NET development including ASP.NET Core, WPF, and Entity framework. Tigran always strives to exceed the client's expectations, tries always to be in regular contact, is transparent with work and deliverables, and is eager to answer all of the client's questions.
Portfolio
Experience
- Databases - 10 years
- SQL - 10 years
- C# - 7 years
- ASP.NET Core - 5 years
- ASP.NET Web API - 5 years
- .NET Core - 5 years
- Oracle PL/SQL - 2 years
- Design Patterns - 1 year
Availability
Preferred Environment
Microsoft SQL Server, Visual Studio
The most amazing...
...thing I've made was a dynamic SQL-based system for a digital marketing company—it analyzed and generated various, difficult SQL queries based on the client.
Work Experience
Senior .NET Developer
Macadamian Technologies
- Participated in developing inner core services that connect multiple 3rd-party services.
- Tracked and fixed bugs using Azure as a reporting and task management tool.
- Created back-end APIs and endpoints for the inner core service.
- Participated in healthcare project development with WPF, Entity Framework, and MS SQL using Onion architecture.
Back-end Developer
Freelance Agency
- Participated in the back-end development of an internal app that manages all the internal processes for the company providing security services.
- Designed and implemented a solution for common use-cases that reduces repeated functionality development from two hours to 30 minutes for each API.
- Designed and created a unit tests module with mocking of database operations.
- Created and deployed an automated mapping module between different layers of models in a replacement of an existing one with manual mappings and repeated code.
Senior Database and .NET Developer
Rosgosstrakh Armenia Insurance Company
- Contributed to developing and maintaining a large database with hundreds of tables and hundreds of million records. The project includes database design, queries and stored procedure development, query optimization, reporting, and data analysis.
- Collaborated on the modernization of a database-oriented ASP.NET Web Forms application, where about 80% of the business logic was implemented on DB using SQL procedures.
- Split the existing large project into architectural layers and upgraded them to newer technologies and frameworks on a layer-by-layer basis.
- Created a universal client tool for importing the data from several specified business models in different formats such as Excel and XML. Performed some business operations on the imported data.
Back-end Developer
Cargomatrix Corporation, Armenian Branch
- Developed the back end for a universal application and website for cargo companies.
- Built the back end of an API for an application chat module using ASP.NET Core Web API and Entity Framework Core.
- Architected a chat module database used in a project.
Database and .NET Developer
Rosgosstrakh Armenia Insurance Company
- Maintained an existing database-oriented ASP.NET application, where about 80% of the business logic was implemented on DB using SQL procedures.
- Developed a fully operative SMS service using a third-party API with access management for some of the system users to manage texts, data bindings for some of the text data to be bound from the database, and dynamic text formatting.
- Automated compensation management according to the company's business processes.
- Optimized many of the queries and custom reports at the application database.
Senior Developer of Reporting Systems
Beeline Armenia | Part of a Group of Companies Veon (formerly Vimpelcom)
- Developed custom reports using PL/SQL queries and stored procedures.
- Optimized many of existing reports in working reporting systems.
- Analyzed existing ETL processes to find out data integrity violations and corrupted data.
- Analyzed data losses or inconsistencies to find sources of corrupted data.
- Automated a weekly reporting to generate reports for weekly revenue and traffic.
Computer Network Administrator
National Library of Armenia
- Maintained the computer network with over 80 users.
- Trained the staff for upcoming applications.
Experience
Ticketing System (ASP.NET Core MVC)
Tasks Accomplished:
• Integrated Microsoft Graph API (get ticket-related emails from Office 365 mailbox, attach MailMessage file to a particular ticket, send emails).
• Integrated Exact Online (Exact.com/software/exact-online) API to sync some data between the system and Exact.
• Implemented authentication and role-based authorization using the ASP.NET Core Identity framework.
• Developed and introduced a version control and continuous integration rules for a small team using GitLab.
.NET ORM Tool to Run Database Stored Procedures
Online Analytics Database Tool
Data Analysis for an Auditor Company
WPF Application for an Auditor Company
Education
Master's Degree in Programming and Information Technologies
Yerevan State University - Yerevan, Armenia
Bachelor's Degree in Informatics and Applied Mathematics
Yerevan State University - Yerevan, Armenia
Skills
Libraries/APIs
AutoMapper
Tools
Visual Studio, Microsoft Visual Studio
Languages
SQL, C#, T-SQL (Transact-SQL)
Frameworks
ASP.NET Core, .NET Core, .NET, Entity Framework Core, ASP.NET, ASP.NET Web API, Windows Presentation Foundation (WPF), Entity, .NET 5, .NET 6, NUnit
Storage
PL/SQL, Databases, Microsoft SQL Server, Oracle PL/SQL, SQL Server Management Studio (SSMS), Oracle 10g, Oracle 11g
Paradigms
Object-oriented Programming (OOP), Design Patterns
Platforms
Windows, Linux, Xamarin
Other
Microsoft Graph API, Combinatorics, Combinatorial Optimization, NP-complete Problems, Graphs
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring