Paruyr Hakobyan

- Leading of BI developers and analytics team - BI project management and planning - Business Intelligence (BI) architecture and technical leadership - Corporate DWH architecture and data integration - Complex analytical reporting and KPIs definition

- Business Intelligence (BI) architecture and development (MS SQL Server 2016/ 2014/ 2012) - Data Warehouse architecture, design and development - Data Integration/migration (ETL , SSIS) with different sources (flat file, Google Analytics, API, mysql, Oracle) - Architecture and development of BI environment (SSAS OLAP, MOLAP, ROLAP, HOLAP) based on Microsoft Dynamics NAV ERP - Large scale database optimization and performance tuning - Power BI, Evidanza data visualization, analytics, reporting

- Database development and architecture (Oracle, PL-SQL) - Database optimization and performance tuning (Oracle 10g,11g) - Software Backend development - Reporting system creation - BI environment creation (Pentaho) - System analysis

-Managing Team of 3 employees - Development of Fraud and RA Controls based on internally developed Database Management System (large scale RDBMSs) - Near real time files analysis, alerting using Microsoft technologies -Automatic daily/weekly/monthly reconciliations between Technical and IT sources using XML,Binary data and Oracle/MS SQL Server database sources -Development of special services for data migration (ETL) and In House reporting system to cover daily/weekly/monthly reporting needs

- development of Fraud and RA controls like Interconnect bypass, prepaid balance reconciliation, home roaming, visitor roaming, international interconnect etc... - Training of RA staff on Revenue assurance and Fraud. Case studies and international best practice share - Assistance and participation in RA System deployment and integration. RA System technical requirements creation. - Creation of RA procedures and processes like Revenue Map, Fraud Risk Map and policies.

Delivery of Training for groups up to 12 people for SQL Server 2008 R2 and SQL Server 2012. Training covers the full cycle of database development, administration and initial BI knowledge.

- Responsible for development of fraud and RA controls based on the local database management system. - Development of Call reselling (interconnect bypass) fraud detection tool based on Microsoft technologies (.net, MS SQL Server). - Development of data migration services (ETL) from Billing system to local DW

- Large scale database development from scratch (complex RDBMS solutions) - Optimization, performance tuning of existing database management systems - Development of ETL and batch process (processes which are being run and dealing with different sources) - Software backend development (using c#.Net) - Development of reporting system (SSRS) - Research and development of BI/DW projects (SSAS)

- Development of financial software from scratch (using SQL Server as RDBMS and Visual Basic for UI and Crystall reports for reporting) Delivered Software for: - Credit-ability analysis - Accounting records keeping (genereal ledger, transactions, balance sheet etc..) - Internal and external (regulatory) Reports generation - Loan registration, interest rate calculation and payments schedule creation