Mar `15 – Oct `15
User Activity Tracker
DBA, Data Scientist
• Design cubes with the minimum dimensions as small as possible to be applicable to serve the maximum reports' types. • Develop queries (Google BigQuery Language) to perform Tableau's cubes processing. • Develop reporting on the Desktop Tableau with deployment to Google Cloud.
Web Interface for getting and analyzing information about user activity, storing information in the Google Cloud (Google BigQuery) and making reports using the Online Tableau Service.
Technologies Stack:ETL Node.js R
Oct `05 – Oct `07
Healthcare Business Intelligence Suite
• Designed, implemented and supported clients’ MS SQL and MS OLAP databases. • Designed ETL processes. • Designed reports’ and details’ analytics using XML and XSLT.
Web-Based Analytical Suite, which includes Revenue Cycle Analytics, Profit Margin Analytics, Self Pay Analytics, and Registration Quality Analytics for one of the largest healthcare service companies (USA)
Technologies Stack:ETL .NET MSSQL
Feb `07 – May `07
Predictive Analytics Service
• Mathematical Modelling.
Web API, allowing to analyze the financial status of the client based on his credit history, marital status, family, etc. during a short time and answering the question: Is the client self-paid or not?
Technologies Stack:.NET Mathematica
Jul `05 – Nov `05
Universal EDI Server
DBA and Senior .NET developer
• Full database design including schema architecture, tables, views, and stored procedures. • Full design and implementation of the application using Visual C#.NET.
The server recognized any EDI type of documents regardless of its customization. Then it parsed and converted document into relational database. This application is a multi-threading program which uses different threads for acceleration of asynchronous downloading of electronic documents.
Technologies Stack:.NET MSSQL
Nacional'nij Tehnicnij Universytet 'Kharkivskij Polytehnicnij Institut'