SUMMARY:

• Seventeen years of experience in data analysis, statistics, finance and business process analysis
• Graduated Microsoft Professional Program Data Science (track of 10 courses) scoring average 92%
• Experienced in Python, R, MS Azure ML, Cognos Report Studio, Spark, Hadoop, ETL, Git, Jira, Microsoft Visual Studio, DAX, M language, Saleseforce, PeopleSoft, Tableau, Power BI, IntAcct, expert in MS Office (PowerQuery, PowerPivot, PowerMaps, VBA, SharePoint)
• 3 years of hands - on experience using complex machine learning methods and algorithms: regression (neural net, decision forest), clustering (k-means, collaborative filtering), classification (boosted decision tree, support vector machine), anomaly detection (pca-based anomaly detection), natural language processing (NLTK tokenization, polyglot, spaCy, requests, scikit-learn, beautifulsoup)
• Achieved significant results in creating and improving teh following machine learning experiments: online fraud detection, credit risk, demand estimation, customer behavior prediction
• Strong noledge of Python modules: numpy, pandas, json, scrapy, tweepy, matplotlib, requests, beautifulsoup, prettytable, datetime, math, sklearn, natural language toolkit
• Regular member of Kaggle and Cortana Intelligence competitions leveraging Microsoft Azure Machine Learning Studio.
• Over 2150 case studies successfully resolved on DataCamp, EDX, Udemy platforms
• Proved advanced performance in evaluating and improving financial information systems
• Designed and introduced ROI management tool resulting in 400,000$ yearly savings

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Intelligence Analyst

Responsibilities:

• Created Ice Thickness prediction model with 97% accuracy ratio using Boosted Decision Tree Regression module in Azure Machine Learning Studio.
• Designed from scratch advanced Power BI dashboard aimed to track daily performance of teh underlying ETL process transferring cleaned tables from Coast Guard’s financial database to Azure SQL database used for Business Intelligence purposes.
• Gatheird complex business requirements from financial department defining business problems and data requirements.
• Translated business requirements into specifications that are used by Business Intelligence team to implement innovative reports and dashboards.

Confidential

Telecom Cost Analyst

Responsibilities:

• Initiated changes to improve primary repository of all documents related to telecom costs of goods topic (invoices, contracts, service agreements, etc.)
• Successfully resolved diagnosing issues of raw datasets (outliers, missing values, and duplicate rows) and cleaned data using Python to get it into a form ready for analysis.
• Leveraging Microsoft Power Query and Excel designed dashboard reports and implemented teh feature to drill down invoices to obtain detailed circuit inventory breakdown.
• Introduced innovative approach of converting unstructured data from multiple PDF files into tabled structured CSV files.
• Performed deep analysis of all COG-invoices ensuring accuracy of costs through database audits, invoice reviews, report analyses and comparisons.
• Audited variances in billing and performed periodic audits to ensure integrity throughout teh telecom validation process, interpreted teh results and presented solutions to teh discrepancies.
• Supported other areas such as Finance, Service Operations as a subject matter expert

Confidential

Data Scientist / Business Process Analyst

Responsibilities:

• Created, tested and improved predictive analytics business model using Python, R, MS Azure machine learning, PySpark, Tableau and data mining tools resulting in 200,000$ savings
• Evaluated teh evidence in support of existing marketing strategies for different stakeholders drawing on teh evidence-based framework
• Performed quantitative data analysis using a variety of statistical techniques for fraud detection, credit risk, NLP, demand estimation, customer behavior prediction using MS Azure ML
• Argued teh choice of target audience for marketing campaigns
• Managed attendance, scheduling, budgeting and reporting at clinics/department levels providing financial analysis and timely feedback
• Designed and deployed new segmentation and advanced KPIs that best represent progress against teh objective and build consensus with all engaged departments
• Created, tested and improved predictive analytics business model using MS Azure ML
• Implemented cleaning procedures supporting transformation and integration of teh data using R, Python, Git, DAX, SQL, Jira, MS PowerPivot, Power BI, PowerQuery and PowerMaps

Confidential

Data Analyst

Responsibilities:

• Based on historical trends of workload designed and implemented from scratch advanced statistical model that proactively foresees all bottlenecks for teh most crucial department of CMPA
• Performed capacities planning calculations to define key measures for 3 subdivisions. Achieved high appraisals from teh management team for innovative Gantt Chart style visualization tools
• Developed NLP supervised ML model that identified topics based on term frequencies
• Analyzed performance to identify areas requiring improvement
• Reporting to teh Supervisor of Business Process Improvement Department designed reporting solutions and introduced scorecards with KPIs to ensure and Contact Centre Services business requirements are met. Main tools for creating scorecards and deep diving researches: Cognos report studio, PeopeSoft, MS PowerPivot, PowerQuery, Power BI and Excel, Python, DAX
• Designed and integrated reporting system for newly created Saegis business unit
• Actively contributed to Data Stewardship project

Confidential

Finance Systems Manager

Responsibilities:

• Performed statistical and financial monitoring, fund-based accounting and compliance checks on programs and projects including review and revision of cost allocations
• Designed data mapping and transformation rules for data validations and controls
• Proactively performed data analysis of large unstructured and structured datasets
• Implemented business tools and achieved extensive progress in IntAcct system improvements related to financial reporting resulting in consolidated statements being available directly in Cloud ERP Software IntAcct system upon request
• As a dedicated MS Excel expert, me trained DOT colleagues how to use pivot tables TEMPeffectively while making detailed variance analysis for appropriate projected cost distribution across active project budgets and affiliate core reserves
• Provided prompt and accurate written instructions to country offices pertaining to financial aspects of project proposal development and evaluation

Confidential

Administrative Assistant casual employment

Responsibilities:

• Controlled and coordinated workload distribution among case managers and client service agents
• Designed and implemented measurement framework and management HR reports
• Verified and processed payment documentation for program expenditures

Confidential

Senior Business Controller

Responsibilities:

• Supervised, trained and recruited a team of 2 database analysts & 3 marketing campaigns controllers
• Provided expertise in teh planning, modeling, execution, analysis and insight of digital and direct marketing programs
• Developed, implemented and automated internal control system for eight business units
• Argued teh choice of target audience for marketing communication
• Transformed budget planning into a unified analytical process, resulted in significant improved accuracy of corporate revenue projection
• Improved budgeting preparation procedure, interconnected with financial statements, summaries and management reports

Confidential

Senior Business Analyst

Responsibilities:

• Directed and coordinated financial, marketing and statistical processes using KPIs reports and risk management statements
• Designed tool for calculating ROI of recruitment, resulting in USD 400 k yearly saving
• Supported teh integration of Marketing, Sales and Finance data into a single updated database format, resulted in faster retrieval of higher quality analytics
• Designed and executed teh business controlling Excel based tool of retail chain (71 shops), which covers teh biggest cities of Ukraine
• Improved financial decision support system by enhancing forecasting and budgeting implementing systematic variance analysis and comprehensive sales report analysis with following counsels
• Supervised a team of three finance analysts
• Developed and implemented classification system-database
• Supervised MIFO and ROI projects that every Bertelsmann’s profit center must implement