BI Lead Developer - Data Warehousing & Visualization Expert
Resume:
Oleksandr S. Zhur
Business Intelligence Lead Developer
Email: ******@*****.***, *********.****@*****.***
Tel: +380**-***-**** (WhatsUp, Viber, Telegram)
Location: Croatia, Split
Summary of Experience
• Experience in data warehousing and data visualization using different Business Intelligence Solutions: TibcoSpotfire, MicroStrategy, PowerBI, Cognos, MS SQL Server, Oracle, Postgre, Redshift .
• Data integration with Python, SSIS on AWS platform.
• 20+ years background in OLTP and OLAP solutions design
• Industries: HealthCare, Clinical Researh, Real Estate, Insurance, Gas&Oil, Pricing&Analytics, Beer&Wine,
• I have worked with big companies and perfectly know what BI approaches are needed for each set of business requirements, guaranteeing development services of the highest quality. Experience
EPAM/AstraZeneca 08.2023 – now
Role: BI Solution Architect
Environment: Python, SqlServer2022, Tibco Spotfire, Java Script, IronPython Comments: R&D and development of Application based on Spotfire for detection molecules degradation based on wavelength intensity and molar masses.
Tasks and Accomplishments:
- Close work with data scientists for Requirements gathering. Built Python logic for multiple business tasks:
- Chromatograms peaks detection with scipy.signal.find_peak
- Clustering information with sklearn.cluster.DBSCAN
- Interpolation of data for performance improvement with skipy.interpolate
- Supression data points with scipy.signal.savgol_filter
- Built python/sql server ETL for data sourcing, transformation and load to data warehouse
- Developed interactive spotfire solution for prviding valuable information of degradation peaks/moments detaction and details analysis.
- Spotfire UI styling and customization
EPAM/Syngenta 03.2022 – 08.2023
Role: BI Solution Architect
Environment: Tibco Spotfire, Java Script, R, Python, Postgre, Redshift Comments: Support and maintenance data science Application for controlling Active Ingredient Residue in soil for fitting standards and maximizing possible harvest. Tasks and Accomplishments: BI solution management and development
- Quantile regressions models build on top of statistical data to find data outliers and built boundaries curves. Python modules used: statsmodels.formula.api, numpy, pandas.
- Close work with business owners, data scientists, data providers to gather all the nuances and drive project to successful implementation
EPAM/Regeneron 04.2020 – 09.2021
Role: BI Solution Architect
Environment: Tibco Spotfire, Java Script, R, Python, Postgre, Redshift Comments: Taken part in several projects. Design Spotfire reporting architecture and dashboards development. Tasks and Accomplishments: Design and development Tibco Spotfire dashboards:
Tracking cages for animals and planning ordering.
Taken part in Customized UI development
Interactive dashboards building with wide usage of Python and Java scripts
EPAM/Chevron 08.2016 – 04.2020
Role: BI Solution Architect
Environment: Tibco Spotfire, Hadoop Impala, Java Script, R, Python Comments: Taken part in several projects. Design Spotfire reporting architecture and dashboards development. Tasks and Accomplishments: Design and development Tibco Spotfire dashboards:
Managing Data Lake data preparation.
Data Science algorythms implementation with R language for statistical metrics building.
Equipment Failures Prediction and Confidence Bounds building based on historical data with statsmodels library.
Interactive dashboards building with wide usage of Python and Java scripts
EPAM/Constellation Brands USA onsite 10.2015 – 07.2016 Role: BI Solution Architect
Environment: Microstrategy, Oracle Exadata
Comments: Development BI solution for Beer departmenten that is used globally by thouthands users. Tasks and Accomplishments: Architecture development and control solution development for Beer department BI analytics:
Metadata / Ad-hoc packages development
MSTR Performance architecture design and Exadata best performance approaches implementation
60 Transformations, 6K metrics, ~handred attributes.
Responsible for whole development layers and releases promotion through several SDLC environments. Education
Department of computer science,
Lviv Polytechnic National University,
B.S. in Computer Sciences 09.1993 - 12.1998 Lviv, Ukraine Advanced courses on Oracle Server
(Franko’s National University) 10.2000 - 12.2000 Lviv, Ukraine UNIX FreeBSD 4.4:
Courses for professionals
(Lviv Polytechnic National University) 08.2001 - 10.2001 Lviv, Ukraine Microsoft certified course #70-229: 03.2004 - 03.2004 Kiev, Ukraine
“Design and Implement Databases with Microsoft SQL Server 2000”
(Microsoft Certified Technical Education Center Kvazar-Micro) Advanced courses on Managing and Maintaining 06.2004 - 08.2004 Lviv, Ukraine Windows Server 2003 Environment #70290 and
Network Infrastructure #70-293
(Franko’s National University)
Microsoft certified course: 02.2006 - 02.2006 Lviv, Ukraine SQL Server 2005 for development
(Softserve, Inc)
Oracle9i for Administrators 04.2006 – 06.2006 Lviv, Ukraine
(Softserve, Inc)
Master Python for AI 05.2025 – 05.2025 Zagreb, Croatia Specialties & Computer Skills
MS SQL Server 2000 Certified Database Administrator (MCDBA) Oracle 9i Certified Associate (OCA)
Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) Microsoft Certified Professional in Microsoft SQL Server 2012 (MCP: SQL Server 2012) IBM Certified designer – Cognos 10 BI Multidimensional Reports (IBMBA) Programming languages/ RDBMS /RDBMS tools
Tibco Spotfire (10+ year)
Python 3 (3 years)
MS SQL Server 7/2000/2005/2008/2012/2014/2022 (15+ years’ experience)
Oracle 8/8i/9i server (3+ years’ experience), PL-SQL (5+ years)
MicroStrategy Schema+Olap+Reporting (3+ year)
PowerBi (0.5 years)
Cognos 10 (2+ years)
MySQL (2 years)
HTML/CSS (4 year)
Operating Systems
Microsoft Windows 95/98/NT/2000/7/8/2003Server/2008Server/2019Server (13 years)
Unix FreeBSD (2-years)
Novell 4/5 (2 years)
Hardware Knowledge
Experienced in LAN technologies
3 years’ experience in hardware maintenance
Languages
Ukrainian – native, Russian – fluent, English – fluent, Croatian - beginner Interests
Swimming, nature, new software
Contact this candidate