Konstantin Latsenyuk available

Konstantin Latsenyuk

BI, SQL, ETL, Datawarehouse Developer, Database Modeler

available
Profileimage by Konstantin Latsenyuk BI, SQL, ETL, Datawarehouse Developer, Database Modeler from DonetskUkraine
  • 83001 Donetsk Ukraine Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates: not provided
  • Languages: English (Elementary) | Russian (Native or Bilingual) | Ukrainian (Native or Bilingual)
  • Last update: 15.05.2020
KEYWORDS
PROFILE PICTURE
Profileimage by Konstantin Latsenyuk BI, SQL, ETL, Datawarehouse Developer, Database Modeler from DonetskUkraine
SKILLS
Professional overview:
1.    Data warehouse, reporting, budgeting
    - Bank accounting and reporting.
    - Design data warehouses (banks, distribution companies), ETL processes, data integrity;
    - Integration of data warehouses with bank systems;
    - Data warehouse building, design ETL processes using SAS (Data Integration Studio, Management Console);
    - Data marts building, OLAP cubes design, reporting using SAS (Data Integration Studio, Management Console, OLAP Cube Studio, Web Report Studio);
    - Metadata development for IBM Cognos Business Intelligence (versions 8.1 - 8.4), IBM Cognos Express (versions 9.5 - 10);
    - Business model development for IBM Cognos Planning (versions 8.1 - 8.4), IBM Cognos TM1 (versions 9.5 - 10);
    - Budget consolidation models building and financial reporting.
    - Audit data warehouses from other suppliers
2.    Software Development
    - Conceptual system design using CASE;
    - General system architecture development 2-tiered (the client-DBMS) and multi-tiered;
    - Logical and physical database design using CASE (CA Erwin, Sybase Power Designer);
    - Design, develop and test the server side of information systems using procedural SQL extensions (Oracle PL/SQL, MSSQL T-SQL, Sybase Watcom SQL, Sybase T-SQL);
    - Report development;
    - Oracle DBMS administration (7.3-11.2);
    - Database query optimization (Oracle, MS SQL Server, Sybase IQ);
3.    Project management
    - Team management;
    - Using project management systems (MS Project);
    - Using the version control systems (MS Visual Source Safe, StartTeam, CVS).
4. Software & Technologies
    - Datawarehousing (logical and physical model design, ETL, OLAP, Reporting)
    - SAS (Data Integration Studio, Management Console, OLAP Cube Studio, Web Report Studio)
    - IBM Cognos Business Intelligence, IBM Cognos Express, IBM Cognos Planning, IBM Cognos TM1
    - CA Erwin, Sybase Power Designer
    - SQL
    - Oracle PL/SQL, MSSQL T-SQL, Sybase Watcom SQL, Sybase T-SQL
    - Database query optimization (Oracle, MS SQL Server, Sybase IQ);
    - MS Project
    - MS Visual Source Safe, StartTeam, CVS
 
PROJECT HISTORY
www.zept.info
TIME AND SPATIAL FLEXIBILITY
Flexible
GET IN TOUCH

Message:

Sender: