Senior BI Engineer & Analyst
Namshi.com
Total years of experience :14 years, 3 Months
Data mining, engineering and analysis
Data architecture (DDL, DML concepts, automation, warehousing, etc.);
Moving data processing and storage into cloud (MySQL, MS SQL, Big Query: sql, t-sql, c#);
Data models development (OLAP tabular);
Optimization of the current SSAS Tabular models (revising DAX formulas, MDX and moving calculations to the cloud);
Optimization of SSIS jobs (revising and connecting to the cloud data sources: Google Cloud Platform, AWS, c#, python);
Administration and troubleshooting of MSSQL, SSAS, SSIS;
ETL development and troubleshooting (python, ssis (c#), sql);
Data mining and engineering for further analysis with R (python, sql, t-sql for ERP and Google Analytics);
Requirements analysis;
Direct communication with the users and stakeholders;
Reports development and end user support on using BI models (MS Excel, Power BI, Microstrategy, Tableau, SSAS, etc.);
Re-engineering, digital transformation (big query, Microstrategy)
Deep data analysis for business departments on different events: from campaigns to internal processes
Technical support for the asset performance management (APM) software (sw) installation, utilization, customization and version upgrade.
Requirements analysis:
Documentation reading;
Direct communication with the stakeholders;
Setting up environments and third-party components (SSAS, SSRS, network, security, applications, databases, etc.);
ETL (Datastage, SAP to MSSQL);
Application sw business logic customization on a database and application levels (SSAS, SSRS, VB.net, SQL, T-SQL, PLSQL, HTML);
Creating cubes, data structures and hierarchies, measures, dimensions, kpi, etc.;
Creating dashboards and graph data visualization;
Creating or editing SSRS reports;
Testing the sw after a fix/script application;
Test plans design;
User technical training and UAT sessions delivery;
SW client operational support;
Technical software engineer consultant for Qatargas (Qatar), Sahara Petrochemicals (KSA) sw versions upgrades projects and SIBUR (Russian Federation) initiation of the APM sw installation and utilization project.
Requirements analysis;
Software design documentation writing;
Database design (architecture): DDL, DML concepts, automation, etc.;
Writing and maintaining program code to meet the business requirements on a database and application levels (.NET, SQL, TSQL, MS SQL Server);
Data reporting and visualization tool design & development (MS SQL Server, Excel, VBA, VB.NET, Open office):
Defying measures and dimensions;
Defying data hierarchies;
Programming the tree-view (drag and drop) visualization of production data,
Graphical representation of the financial data;
ETL tool design and development for data collection and procession;
Testing, debugging, diagnosing and fixing errors;
Creating user and training documentation, conducting formal user training;
Acting as a central reference and information source, providing guidance and assistance in the system project decision making process;
SAP (Budgeting and Purchasing) administration and user technical support;
Leading the projects for the department additional software implementation.
Remote job
Development of the first on market integrated social net marketing communication with the current and perspective clients for the low-cost airline:
Requirements analysis;
Organizing teamwork to formulate and document the rules of the client communication;
Collaboration with the airline PR & Marketing department and other stakeholders;
Creating client FAQ list;
Client support;
Design and development of BI indicators to measure social net integrated marketing communication.
Design and development of BI information system for collecting, processing, storing and visualizing the on-line games data.
Requirements analysis;
Documentation reading;
Direct communication with the stakeholders.
Identifying and analysing technology limitations and gaps in existing processes (ETL - .txt to MySQL, ETL health checks, TSQL, Python);
Data cleaning and analysis (blanks, consistency, relevancy, measurements, dimensions, etc.);
Data architecture (DDL, DML concepts, automation, etc.);
Data procession algorithms design and analysis (storage procedures. etc.);
Design, development and customization of data structure for the BI Tool (Tableau) to be able to process results rapidly (data warehouse development);
Writing and maintaining program code to meet business requirements - Database design and development (TSQL, DBA, MySQL, PostgreSQL);
Automation of the data procession (events);
Testing, debugging, analyzing and fixing errors;
Data visualization for different management levels (Tableau): dashboards design, graph design;
Writing and updating system documentation.
Construction Holding ERP information system (budget, engineering documentation, purchasing, etc.) design, development and user support.
Requirements analysis;
Documentation reading;
Direct communication with the stakeholders;
Alien code reading (VB.NET, C#, VBA, MS Visual Studio);
Algorithms analysis and design (database, application);
Business logic customization (TSQL, .NET, MS, VBA, SQL Server);
Testing, debugging, analyzing and fixing errors;
Test plans design; User technical training and UAT sessions delivery.
Total score 115.75 (Average score 4.2; Overall score 143)