Nick Yarovoi
MeBe Clinical Services
Data Analyst
Data Analyst
Inquisitive, detail-oriented, and creative Data Analyst with 4+ years of experience extracting actionable insights and driving successful business solutions proficiently using Python, SQL, Tableau, and Excel. Demonstrated expertise in applying statistical methods, conducting data modeling, and utilizing machine learning techniques to uncover valuable patterns and trends. Skilled in data visualization, effectively communicating complex findings to diverse stakeholders. Adept at independently managing projects and collaborating with cross-functional teams to deliver high-quality analytical solutions.
• Engineered the Projected Revenue project, achieving a $5.2 Mean Absolute Error (MAE) per Session in contrast to the previous $18.7. This improvement in accuracy elevated our planning capabilities and provided a robust foundation for future strategic decision-making.
• Established a robust data and reporting infrastructure using Tableau and Microsoft SQL Server for real-time insights into product performance and key business metrics.
• Implemented Python scripts to automate daily tasks across multiple teams and departments, resulting in a significant reduction in processing time from 3 hours to just 5 minutes
• Developed and executed strategies, including the implementation of a performance-based bonus structure, to optimize conversion rates by reducing unconverted sessions and increasing revenue generation. Additionally, leveraged Python to implement an SMTP server, set up an EC2 server on AWS, and automated email-sending processes with notifications. As a result, the conversion rate improved by 25%, leading to a significant increase in revenue generation.
• Designed and developed a highly efficient Payroll script that significantly reduced bi-weekly processing time and validation from 5 hours, previously requiring a team of three people, to 2 minutes, now managed by a single individual.
• Designed and implemented daily exception reports to proactively identify and rectify data errors and anomalies, resulting in a substantial increase in overall data accuracy.
• Implemented a client and employee identification system aimed at reducing session cancellation rates and driving revenue growth.
• Developed an innovative Client Lifetime Value (CLTV) calculation methodology that greatly assisted the company in devising targeted marketing campaigns.
• Maintained a 100% success rate by consistently surpassing deadlines, and efficiently completing tasks across Finance, Operations, Revenue Cycle Management, Marketing, Scheduling, Accounting, Payroll, and other departments, ensuring timely insights for critical decision-making.
• Designed and implemented a powerful Search Tool and Rate Tracker Tool utilizing Python (NumPy, Pandas), Flask, and Microsoft SQL Server. This innovative solution significantly optimized the search process, significantly reducing the time required to retrieve essential information.
• Developed and implemented Macros using VBA across various departments, leading to a substantial decrease in data cleaning, processing, and validation times.
• Conducted monthly internal CCA Team audits to meticulously assess and validate the efficiency and accuracy of the billing system, consistently achieving a flawless 100% accuracy rate.
• Developed and deployed multiple Python scripts for automating key business processes, resulting in remarkable improvements in accuracy, decreased latency, and significantly reduced processing time.
• Proactively identified potential risks and diligently offered practical suggestions for their resolution.
• Demonstrated expertise in troubleshooting and resolving data exceptions, anomalies, and errors.
• Engaged in daily collaboration with Billing Analysts, Account Specialists, Management, and various internal departments to address data requirements and proactively resolve billing issues.
Intensive program focused on gaining technical programming skills in Excel, Python, HTML5, CSS3, JavaScript, Bootstrap, SQL, Web Scraping, Machine Learning, etc.
University - University of California (UCSD) ExtensionMicroeconomics, Macroeconomics, and Statistics.
University - Donetsk National University (DonNU)
Skills - Python (Programming Language), Convolutional Neural Networks (CNN), TensorFlow, Keras, Classification, Seaborn, Matplotlib, NumPy, Pandas
Link - https://www.kaggle.com/code/nickyarovoi/top-1-housing-prices-competition-regression
Skills - Python (Programming Language), Scikit-Learn, Machine Learning, Regression Models, Seaborn, Matplotlib, NumPy, Pandas
Link - https://www.kaggle.com/code/nickyarovoi/top-1-housing-prices-competition-regression
Skills - Pandas, Web Scraping, Beautiful Soup, Folium, Clustering, K-Means, JSON, Machine Learning, Python (Programming Language), Seaborn, Matplotlib, NumPy
Link - https://github.com/Yara1994/Analysis_of_Schools_in_San_Diego_Neighborhoods
Skills - R (Programming Language)
Link - https://github.com/Yara1994/MoneyBall-Project-with-R-Programming-Language