- Participating in current and development team works of accounting software for tax reporting of "Fozzy Group" - SSIS tasks - Creating reports (T-SQL, SQL, JSON, XML) - I have use (TOAD, SSMS, VS, SSDT, GIT, JIRA, o365 tools) - Data analysis - Database optimization

- Data migration of Old / Current databases to new production database (SQL Server 2016, T-SQL, SQL, TOAD, SSMS) - Data Pull / Pump - DBs sync from Server to Server - Creating reports (T-SQL, SQL, JSON) - I have use (TOAD, SSMS, Azure DevOps, GIT, JIRA, o365 tools) - Data analysis - Database optimization

1. Bank API - API to integrate IDBANK (Oracle LSBANK) and IDRAM payment systems. 2. API for credit conveyor - API to integrate IDBANK Internet Banking and credit conveyer. 3. Client data tree reflection: - Client data's trees' reflection - Customizing the crosstab data to the new DB data

- Slow working queries optimization - Text search optimization up to 100 million rows containing tables.

1. E-Ledger: - E-Ledger project for Taxpayer Republic of Armenia - E-Ledger calculator for Taxpayer of RA which include all business logic and calculation of taxpayer personal account card - Design and develop - E-Ledger system architecture - E-Ledger DB architecture - Chart of accounts - Core implementation (Core implementation done in such a way that one can change calculation without code changes, only configurations) - From old system to new migration and all types of calculation. 2. Big data: - Long time of work experience with 1.5-2TB databases - Database optimization (partition, indexes and queries) - Data analysis of tables which have up to 1.5 billion rows - From OLTP to OLAP synchronization of billion rows via jobs hourly and daily 3. Monitoring system: - Risk monitoring system of HDM - Risk monitoring system of INVOICE 4. Warehouse to Warehouse: - ETL tool: Daily copy and synchronization of warehouse via PL/SQL code. 5. Data analysis: - Data analysis of tables which have up to 100 million rows

- I took part in the formation of a database of programs for DAD

- I participated in the development of software that transfers MySQL DB of last program in the new Lite Insurance DB

1. LiteInsurance and LiteInvestment Software Programs: Being the Leading developer in LiteSoft company, operations of the other members of the team were performed under my direct supervision, help and advice and of course the almost all works on base parts of mentioned programs was performed by me: which include all the business logic of insurance and investment companies. Creating scripts for corresponding the programing logic of LiteInsurance program and scripts for existing data transporting in insurance companies. 2. Translating Program: C# WIN & WEB applications for translating from Armenian to Russian and English. 3. MSSQL SERVER Databases versions converter Software: We need 2008 R2 express free version for demo programs and because MSSQL SERVER doesn't account fully the interdependence of existing objects in Database in generated SQL script, so we needed to write this program for reducing the version.

1. LSBANK Software Program. Participated in current and development team works of LSBANK project: - Provider software block of Anelik transfers for Anelik, VTB and Arcakh banks individually, through which money transfer realized with almost all countries. - Black List block (BlackList, Terrorists & FRJA(ԴԱՀԿ) with childpages), which controls authenticity of the persons participating in any kind of transactions by preventing them with unfair customers. Meanwhile perform an assumed responsibility in the fight against terrorists. - team works in a number of other software such as loans, deposits and other software blocks. 2. LSLOAN Software Program. Participated in current and development team works of LSLOAN project, as well as in organization of LSLOAN transferring scripts for transferring existing data from MDF loan company.

1. NGO-target accountancy code development. Design and development of accountancy intended for Non-Governmental Organizations. 2. Server and Clients system operated in Internet Area. System specific features: - Information exchange is performed in a specific formatted way(manner) - Clients operate in a closed private system - One can become a member of the network, if has -- a Client appropriate code version -- a permit of the system administrator - in case of the connection failure the loss of information is excluded. 3. Database interconnection system. I have the designed and developed interconnected data base projects designated for automation of project activities controlled by USAID, UNHCR, WFP and similar international organizations. The following was performed in the framework of the company main activities: - Coding of applications centralized management by about 20 departments with simultaneous use capability, each one within its own authorities; - Insurance of system safety; - Insurance of each department data confidentiality; - Synchronization of system main server operation with other 10 servers located at regional centers of RA; - All these projects include HTML Help system 4. Archive Program. - The Program has been successfully executed proving its feasibility and efficiency. The Program developed has ensured maximum saving of employee time: 220 working hours per month, as well as sparing hard disc space of Archive computer. The Program identifies all the newly modified files and makes archiving, it has a simplified interface and a Log file for Computer Administrator. 5. Office Traffic Management Sowftware Program. The Program has been successfully executed greatly facilititating the prompt arrangements for making up vehicle schedules per each of more than 10 Office Departments within 2-4 hours based on the Department size reducing working hours and employee efforts on this activity that would linger 10-15 working days per month.