BI, SQL, ETL, Datawarehouse Developer, Database Modeler
Score
100%Experience:
0 y Score
100%Experience:
0 y Location:
83001 Donetsk Ukraine Last update:
20.04.2021 Availability
Available
Rate
Onsite hourly: N/A
Remote hourly: N/A
Languages
Russian: Native
Ukrainian: Native
English: Basic knowledge
Area Preference
Flexible
Description
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;
-
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;
-
Other skills
Description
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;
-
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;
-