Serob Zargaryan Email & Phone Number

Remote

- 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

Armenia

Participating in current and development team outsourcing works for “GoalLine Solutions” projects:- Data migration of Old / Current databases to new production database (SQL Server 2016, Azure SQL Database, 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

Armenia

- Design and implementation BANK API to integrate IDBANK (LSBank Automation System) and IDRAM payment systems (PL/SQL, SQL, XML, XSD, ABS, Oracle 11g all supported database object types and system packages, GIT, JIRA, TOAD, PLSQL Developer).- Architecture design and implementation "Client data tree reflection" modul(Oracle 11g, PL/SQL, SQL, XML, ABS)

- Took part in migration of Taxpayer3 system oracle production database to Oracle Exadata (Oracle 11g, PL/SQL, SQL, TOAD, PLSQL Developer).- 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- Risk monitoring system of “Cash register”- Risk monitoring system of “INVOICE”- Architecture design and implementation of E-Ledger project for Taxpayer Republic of Armenia (Include all system architecture, DB architecture, Core implementation, business logic, Chart of accounts, migration from old system to new and calculation of taxpayer personal account card (PL/SQL, SQL, XML, Oracle 11g all supported database object types and system packages, GIT, JIRA, TOAD, PLSQL Developer)).- Data analysis of tables which have up to 100 million rows(PostgreSQL, PL/pgSQL, SQL, XML, XSD)

0010, Nalbandyan 48, Yerevan, Armenia

Took part in the formation of a database of programs for DAD(MSSQL SERVER 2008 , Oracle11g, PL/SQL, T-SQL, SQL )

Yerevan, Armenia

Took part in the development of software that interprets and transfers MySQL DB data in the new LiteInsurance DB (MSSQL SERVER 2008, MySQL, T-SQL, SQL).

Yerevan, Armenia

Architecture design and implementation of different util programs: MSSQL SERVER Databases versions converter, Translating Program (C# 2008, MSSQL SERVER EXPRESS,2008 R2, SQL, XML, XSD, RESX, ACCESS, EXCEL).Migration of old internal system DB data (ACCESS, EXCEL, XML) to new system DB (LiteInsurance ) (MSSQL SERVER 2008, T-SQL, SQL).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(C# 2010, MSSQL SERVER 2008-2010).

Buzand 1/3 Str., Yerevan, Armenia

Took part in design and implementation of different modules in LSBANK and LSLOANS projects (Loans, Deposits, Transfers, BlackList, Terrorists & FRJA)Builder C++, ORACLE 10g, ORACLE 11g , PL/SQL, SQL, XML, PLSQL Developer, Starteam.