Viacheslav Martinez

Working with data cloud based on Hadoop. Creating of functional specification Creation of data mappings, datamart propitious. Functional testing Communication with business users, elaboration of business requirements

Creation and approval of functional and business requirements (FSD, BRD), automation of bank reporting for the Central Bank of the Russian Federation. Data warehouse (SAS-based) implementation (based on Oracle DBMS). Consultations and interaction with software engineers regarding algorithms realization issues. Data correctness checking (testing scripts in PL/SQL). Working with SAS, SAP BO. I also take part in the process of software design (stored procedures for DB2)

Corporate reports design in SSRS based on SQL and MDX queries (for the financial and marketing departments). OLAP-cubes design and optimization. Stored procedures and MDX performance optimization, SSIS, assemblies, DWH architecture. Budgeting automation. Requirements specifications creation and approval.

Implementation of MS PerformancePoint projects (budgeting automation – expense items fact/plan) OLAP cubes design. MS SQL 2005,SSAS- queries in MDX, VBA, reports development in SSRS, SSIS. Data loading automation from the branches of the company.

Banking software modules development (management companies, bailees). MS SQL Server 2005, Power designer. Mortgage module development. Communications with customers regarding errors and change requests.

MS SQL Server 2000/2005. Stored procedures development. Developing of Excel reports (pivot tables) based on stored procedures. VBA scripts. Creation of WEB-reports based on Visual Studio .NET. Automation of sending of reports by sale results to the company branches. Took part in the implementation of Navision ERP system.