Umiejętności
CRM
Customer Data Integration
Data Mining
Digital Marketing
Excel Pivot
GeoMedia Professional
System Informacji Geograficznej
GIS Application
GIS Modeling
GIS systems
MapInfo Professional
Microsoft Excel
Microsoft SQL Server
Microsoft Word
SQL
SQL 2008
SQL Injection
SQL PL
T-SQL
Tableau
Teradata
Text Analytics
Text Mining
excel
Analiza biznesowa
SQL Server
Analiza danych
Marketing internetowy
Analityka
Analiza rynku
Bazy danych
Analiza
R
Modelowanie danych
Umiejętności analityczne
usprawnianie procesów
Marketing bezpośredni
Analiza konkurencji
język R
Data mining, stosowana analiza regresji, znajmość programu R-Studio
Optymalizacja zapytań SQL
Teradata SQL Assistant
Wprowadzanie danych
Dane
segmentacja klentów
client's segmentation
client's life cycle
Języki
angielski
dobry
niemiecki
podstawowy
Doświadczenie zawodowe
CRM and Business Intelligence Coordinator - BI, analytics, data engineering, reporting, data mining
CRM & BI
1. Building of multichannel marketing / sales campaigns from the stages of ideas, analytics potential research, selection of
appropriate customers, reporting during the campaign and final, with the preparation of recommendations: e.g.
increasing the effectiveness of Christmas campaigns: increasing the frequency of visits by 2.5% and the basket by 18%
vs. the control group
2. Development customer segmentation models, scorings, customer lifecycle, campaigns based on these models: e.g.
customer selection, targeting in the competition for Trader customers - increasing the effectiveness of the campaign by
5% yoy
3. Building personalized one to one campaigns - dedicated specific offers for specific ones customers.
4. Consent collection project: e.g. collecting consents via email, mobile application, Call Center, in Makro stories -
increasing the share of consents in the selected sample by 26%.
5. Participation in the project of implementing a new CRM system.
6. Reporting service on customer data for internal customers of the organization. Customer data management,
including obtaining consents.
7. Managing and tracking the quality of customer data
1. Building of multichannel marketing / sales campaigns from the stages of ideas, analytics potential research, selection of
appropriate customers, reporting during the campaign and final, with the preparation of recommendations: e.g.
increasing the effectiveness of Christmas campaigns: increasing the frequency of visits by 2.5% and the basket by 18%
vs. the control group
2. Development customer segmentation models, scorings, customer lifecycle, campaigns based on these models: e.g.
customer selection, targeting in the competition for Trader customers - increasing the effectiveness of the campaign by
5% yoy
3. Building personalized one to one campaigns - dedicated specific offers for specific ones customers.
4. Consent collection project: e.g. collecting consents via email, mobile application, Call Center, in Makro stories -
increasing the share of consents in the selected sample by 26%.
5. Participation in the project of implementing a new CRM system.
6. Reporting service on customer data for internal customers of the organization. Customer data management,
including obtaining consents.
7. Managing and tracking the quality of customer data
BI/CRM Expert; Data Steward
Analytical consulting for Makro Cash and Carry's internal clients, including carrying out multidimensional analyzes.
Participation in international analytical projects of Metro Group.
2. Marketing and sales analytics, preparation of reports, dashboards, KPIs; preparing recommendation.
Robert Jeznach
Phone number: (+48) 609144434 Email address: robert.jeznach@gmail.com
LinkedIn: https://www.linkedin.com/in/robert-jeznach/
1 / 33. Building predictive models, targeting, assortment segmentation.
4. Reporting automation.
5. Preparation of algorithms and scripts for customer data validation.
6. Preparation and implementation of procedures regarding the correctness of customer data. Preparation of
algorithms verifying the correctness of customer data - e.g. increasing the purity of email addresses by 2%
Participation in international analytical projects of Metro Group.
2. Marketing and sales analytics, preparation of reports, dashboards, KPIs; preparing recommendation.
Robert Jeznach
Phone number: (+48) 609144434 Email address: robert.jeznach@gmail.com
LinkedIn: https://www.linkedin.com/in/robert-jeznach/
1 / 33. Building predictive models, targeting, assortment segmentation.
4. Reporting automation.
5. Preparation of algorithms and scripts for customer data validation.
6. Preparation and implementation of procedures regarding the correctness of customer data. Preparation of
algorithms verifying the correctness of customer data - e.g. increasing the purity of email addresses by 2%
Database Manager
Management of a three-person department. Developing and managing the budget.
2. Performing analyzes and building processes to optimize the use of databases in marketing and sales campaigns.
Automation of marketing activities: profiling, scoring - e.g. Increasing subscription renewal by 11% yoy
3. Business analytics, formulating hypotheses and their verification, building purchase models - e.g. Increasing the
effectiveness of open training recruitment by 4%
4. Acquiring databases from external suppliers.
5. Management, administration, modernization and updating of the customer base.
6. Participation in project teams, incl. implementation of the CRM system (Microsoft Dynamics), ERP (Enova), online store
(Magento), HBRP website and customer portal.
Data security administrator
1. Development of procedures for the protection of personal data: security policy, safety instructions; trainings. Co
ntrolling and enforcing the rules of personal data protection. Reviewing agreements on personal data protection.
2. Performing analyzes and building processes to optimize the use of databases in marketing and sales campaigns.
Automation of marketing activities: profiling, scoring - e.g. Increasing subscription renewal by 11% yoy
3. Business analytics, formulating hypotheses and their verification, building purchase models - e.g. Increasing the
effectiveness of open training recruitment by 4%
4. Acquiring databases from external suppliers.
5. Management, administration, modernization and updating of the customer base.
6. Participation in project teams, incl. implementation of the CRM system (Microsoft Dynamics), ERP (Enova), online store
(Magento), HBRP website and customer portal.
Data security administrator
1. Development of procedures for the protection of personal data: security policy, safety instructions; trainings. Co
ntrolling and enforcing the rules of personal data protection. Reviewing agreements on personal data protection.
Anailtyk GIS
GISMAR
Conducting works as a subcontractor for the following companies: Intergraph Polska Sp. z o.o.,
Map Factory Sp. J., Plan SA, Argos Translations Sp. z o. o.
- GIS data analytics
- control of vector and raster data for the agricultural parcel identification system LPIS - projects: Data Quality Verifier and WJD2, TERYT 2 - State register of borders and areas of territorial division units of the country
- control of LIDAR data as part of the project: "Implementation of airborne laser scanning (LIDAR) and development of derivative products as part of the project "Comprehensive flood protection Żuławy"
- control of vector and raster data and documentation for the LPIS agricultural parcel identification system - Data Quality Verifier project Control of vector, raster data and documentation for the LPIS agricultural parcel identification system - Data Quality Verifier project
- Control of the orthophotomap - a project of the General Inspector of Supervision and Control
- Translation and verification of translations of GIS data and application documents
Geomedia Toolkit, ESRI Toolkit, Bentley Software Package for Microstation, AutoDesk Software Package including AUTOCAD, Terra Toolkit, Quantum GIS, Global Mapper, Quick Terrain Modeler, MapInfo, MS SQL Server Management Studio, MS Access,
MS Excel, own scripts and applications
Map Factory Sp. J., Plan SA, Argos Translations Sp. z o. o.
- GIS data analytics
- control of vector and raster data for the agricultural parcel identification system LPIS - projects: Data Quality Verifier and WJD2, TERYT 2 - State register of borders and areas of territorial division units of the country
- control of LIDAR data as part of the project: "Implementation of airborne laser scanning (LIDAR) and development of derivative products as part of the project "Comprehensive flood protection Żuławy"
- control of vector and raster data and documentation for the LPIS agricultural parcel identification system - Data Quality Verifier project Control of vector, raster data and documentation for the LPIS agricultural parcel identification system - Data Quality Verifier project
- Control of the orthophotomap - a project of the General Inspector of Supervision and Control
- Translation and verification of translations of GIS data and application documents
Geomedia Toolkit, ESRI Toolkit, Bentley Software Package for Microstation, AutoDesk Software Package including AUTOCAD, Terra Toolkit, Quantum GIS, Global Mapper, Quick Terrain Modeler, MapInfo, MS SQL Server Management Studio, MS Access,
MS Excel, own scripts and applications
Szkolenia i kursy
ABC Administratora Danych Osobowych - Omnimodo
Edukacja
Specjalizacje
IT - Rozwój oprogramowania
Analiza biznesowa
IT - Rozwój oprogramowania
Inne
Marketing
Marketing internetowy i mobilny
Zainteresowania
Datamining, Bazy danych, GIS, Spinning, Wycieczki rowerowe, Pływanie, Spacery po górach
Organizacje
PZW
Inne
Finalista 1 z 10 (2 miejsce)
tel. 609144434
robert.jeznach@gmail.com
tel. 609144434
robert.jeznach@gmail.com
Grupy
Politechnika Warszawska
Politechnika Warszawska jest najstarszą polską uczelnią techniczną. Od ponad 180 lat kształci kolejne pokolenia inżynierów, wnosząc istotny wkład w rozwój nauk technicznych.