Разработчик BI

Описание

Andrii Smirkin


PERSONAL STATEMENT
As a certified BI Developer, I have wide experience in modelling, transformation (ETL procedures), designing and development of analytic applications with using of next tools QlikView, Qlik Sense, Tableau. A project implementation usually contains several types of activities and I have experience in all of them. In particular, obtaining and analysis of requirements, collaboration with a client, making documentation, designing, development and implementation of a solution, support. I got wide knowledge in various business domains. For example, retail, accounting, pharmacy, service, production and others.
My main aim is to help companies to be more effective and efficient in a handling information. I am sure that analytics should be simple and understandable. New technologies allow us to achieve this target. I am a skilled expert with comprehensive knowledge in this area and I can implement the most effective analytical tool for the company success.

SKILLS AND KNOWLEDGE

Developing Tableau workbooks
Developing QlikView/Qlik Sense applications
Connection to data sources
Creating scripts for loading data
Forming data warehouses using qvd-files
Building effective data models
Making effective and efficient visualizations
Retrieving information from databases by SQL queries
Data preparation (ETL)
Preparing project description
Communication with customers and coming up with proposals for making more effective dashboards


WORK EXPERIENCE


Senior Qlik Sense developer - from July 2020 to June 2022
Company Name: DataArt.
Location: Kyiv, Ukraine.

Responsibilities:
Checking and clarification of requirements.
Checking availability of required data sources.
Extraction data.
Building data models.
Visualizations implementation.
Testing of applications.
Presentation of solutions (applications).

Senior BI developer - from November 2019 to March 2020
Company Name: Softserve.
Location: Kyiv, Ukraine.

Projects:
ABI: People Advanced Analytics (Qlik Sense)

Responsibilities:
1. Collecting of requirements.
2. Analysis and clarification of the requirements.
3. Building data model.
4. Developing visualization.
5. Testing of application.
6. Client collaboration and communication.
7. Supporting users in testing and implementing processes.


Senior BI developer - from October 2017 to October 2019
Company Name: Infopulse.
Location: Kyiv, Ukraine.

Projects:
MyClients FY19 Phase 2 (QlikView)
OGC Reporting (Tableau)
Tableau Leadership Dashboard (Tableau)
Talent DEEP reporting (Tableau)
BEV (Birds Eye View) (Qlik Sense)
Darnitca BI (QlikView)
Migration from RTrak analytic tool to QlikView

Responsibilities:
1. Collecting of requirements.
2. Analysis and clarification of the requirements.
3. Preparation of POC (Proof of Concept).
4. Building data model.
5. Developing visualization.
6. Testing of application.
7. Client collaboration and communication.
8. Supporting users in testing and implementing processes.

QlikView developer - during July 2017
Company Name: WorldApp www.worldapp.com .
Location: New York, USA.
Current project: Dashboard for surveys analysis.

Responsibilities:

Implementation dashboard according to documented requirements
Processing unstructured data (was used direct access to the data via the internet)
Forming data warehouse
Building data model
Creating visualisation
Checking correctness of data and their accordance to data source

QlikView developer - during May 2017
Company Name: LafargeHolcim www.lafargeholcim.com (I worked as an external employee hired by KOMIX).
Location:
Current project: Pilot project.

Responsibilities:

Implementation dashboard according to documented requirements
Creating visualisation
Development was performed in a team of developers

QlikView developer - from August 2016 to September 2017
Company Name: T-Mobile, www.t-mobile.com (I work as an external employee hired by KOMIX).
Location: Prague, the Czech Republic.
Current project: Migration from Cognos to QlikView.

Responsibilities:

Studying documentation which describes Cognos dashboards and cubes
Studying real dashboards and cubes from Cognos
Making a comparison between the obtained information and documenting it
Forming the list of data sources which are needed for developing QlikView applications
Sending inquires for getting data sources
Developing QlikView applications using the given data sources
Checking functionality of QlikView applications to matching functionality of Cognos reports
Checking correctness of information which is shown in QlikView applications
Communication with my manager who I report to
Elimination of drawbacks of the applications which have been revealed by the customers

QlikView developer (freelancer) - from May 2014 to July 2016
Company Name - self-employed
Location: Dnipro, Ukraine.
Projects:

Effectiveness of formats', ABCE analysis', L4L'. Prostor, the national retailer. www.prostor.ua/ru/
Analysis of sales', Analysis of non-liquid stocks'. Nadiya, the pharmacy network
Analysis of sales', Analysis of assets'. Ne boley, the pharmacy network. www.neboley.dp.ua
Analysis of production'. PullSky, the producer of ceilings. www.pullsky.com.ua

Responsibilities:

Creating connections to different data sources (Microsoft SQL Server, mySQL, PostgreSQL, SQL Anywhere, Firebird, csv, Excel)
Building multilevel data warehouses
Building effective data models for QlikView applications
Creating visualisations
Creating tasks for updating data warehouses and applications
Deployment and supporting QlikView server and AccessPoint
Implementation of access rules for users
Creating documentation

Achievements:

Applications which were developed for Prostor, the national retailer, have helped its Commercial Department reduce time of preparing analytical information for making decisions (from ~12 hours to ~1 hours). It has led to more effective process of management. Moreover, the company didn't have an opportunity to obtain such detailed information so quickly before deployment of the analytic system based on QlikView. The size of the database was around 400 GB.
All the implemented projects have led to reducing time of getting valuable information from their information systems and allowed the companies to achieve needed depth of detailing in reporting.

QlikView developer - from September 2011 to April 2014
Company Name: EUROMIX
Location: Dnipro, Ukraine.

Responsibilities:

Collecting and checking raw data from subsidiaries
Processing collected data and forming a multilevel data warehouse
Creating tasks for updating data in the warehouse and applications
Building effective models for QlikView applications
Creating visualisations
Communicating with inside customers
Maintenance of analytic infrastructure (QlikView-server, Web-server, updating tasks)

EDUCATION

Dnipropetrovsk National University, Department of Physics, theoretical physics, September 1992 - June 1997.
Location: Dnipro, Ukraine
www.dnu.dp.ua/eng

Master's degree in theoretical physics

International Business School, Alfred Nobel University (MBA), September 2012 - June 2014.
Location: Dnipro, Ukraine
www.ibsmba.com

Degree of Master of Business Administration

Training Course: Business English for Effective Communication, September 2014 - June 2016.
Location: International Business School, Alfred Nobel University, Dnipro, Ukraine
www.ibsmba.com/programs/business-english

Certificate of Accomplishment (upper-intermediate level of Business English that was confirmed by successful results of the exams (85%)



PERSONAL INTERESTS
I like playing table tennis, travelling, and spending time with my family. I am a football fan. I practise yoga for achieving harmony. I am keen on studying something new, especially foreign languages.

CERTIFICATES

QlikView Developer (https://drive.google.com/file/d/0BxwiAp93GMNfM21SM3JCc0RwcDg/view?usp=sharing&resourcekey=0-o3qmQKhW6r5NRQjtTcnxfA);