Oleksandr Vasylenko
Data Modeling Developer
Alex has over 15 years of database development experience working in various roles (ETL, business intelligence, analyst) in large corporate data warehouse projects. Over the course of his career, he has developed strong analytical skills and the ability to get necessary data from any data source in any required form.
Portfolio
Experience
Oracle - 15 yearsData Modeling - 15 yearsDatabase Modeling - 15 yearsSQL - 15 yearsSAP BusinessObjects (BO) - 10 yearsQlikView - 4 yearsOracle Business Intelligence Enterprise Edition 11g (OBIEE) - 3 yearsLocation
Availability
Preferred Environment
GitHub, Visual Studio Code (VS Code), SQL
The most amazing...
...thing I've coded was a mathematical model to build a social network simcard to determine churn possibility & distinguish alpha leaders for marketing promotions.
Work Experience
Big Data Architect
Xenial
- Designed, developed, and optimized data warehouses.
- Worked on the full cycle of ETL; including development and performance optimization and custom data transformation.
- Architected database designs.
- Wrote business reports and developed dashboards.
- Trained, mentored, and implemented best-practice policies for the team.
Senior QlikView Developer
Citigroup
- Developed QlikView dashboards as part of a larger effort with a team using Scrum methodology.
- Spearheaded requirements analysis.
- Built QVD feeds.
- Created data models and visualizations.
- Provided thorough documentation for solutions and processes as well as implemented data quality assurance.
Senior BI Presale Developer
Oracle
- Provided technical support for presale activities.
- Developed and demonstrated various types of proof of concept (POC).
- Created customer presentations and demonstrated the products while attending forums and conferences.
- Developed and conducted workshops and trainings.
Database Developer
Teradata
- Implemented a social network activity project.
- Created technical specification designs.
- Wrote solution documentation.
- Designed and verified ETL scripts.
BI Architect
Teradata
- Implemented data warehouses.
- Created BI architecture designs.
- Built data models.
- Designed and developed a business objects universe.
- Developed web reports.
- Planned and reviewed tasks.
BI Developer
Teradata
- Implemented data warehouses.
- Conducted requirements analyses.
- Designed the technical specifications.
- Tracked and fixed bugs.
- Wrote solution documentation.
- Created data models.
Freelance Engineer
Freelance Work
- Provided data for analytical departments.
- Gathered user requirements.
- Developed reports.
- Worked with billing statistics.
- Created data models.
- Implemented SQL tuning and developed with PL/SQL.
Database Developer
Citia BTC
- Implemented an automated budgeting system for the bank.
- Implemented a mathematical model.
- Worked on database development.
- Designed ETL scripts and specifications.
Experience
QlikView Monitoring Dashboard
Skills
Languages
SQL, Bash Script, Python, Bash, C#, C#.NET, HTML, CSS
Tools
Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Shell, GitHub, VirtualBox, uDeploy, Oracle Application Express (APEX), Amazon Elastic Container Service (Amazon ECS), Tableau
Platforms
Oracle, QlikView, Linux, MacOS, Visual Studio Code (VS Code), Oracle Data Integrator (ODI), Oracle Database, Amazon Web Services (AWS)
Storage
Database Modeling, PostgreSQL, PL/SQL, Amazon S3 (AWS S3), MongoDB, Teradata, Redshift
Other
SAP BusinessObjects (BO), Data Modeling, Shell Scripting, Oracle VM VirtualBox, SAP BusinessObjects Data Service (BODS)
Paradigms
Agile, Scrum, Kanban, REST
Frameworks
.NET
Libraries/APIs
API Development
Education
Master's Degree in Applied Mathematics
National Technical University of Ukraine “Kyiv Polytechnic Institute” - Kyiv, Ukraine
Bachelor's Degree in Applied Mathematics
National Technical University of Ukraine “Kyiv Polytechnic Institute” - Kyiv, Ukraine