Data Manager

Roman Margulis 647-***-****

*

Roman Margulis

647-***-**** *********@*****.***

http://www.linkedin.com/in/romanmargulis

Over 8 years’ experience in Data & Business Analytics. Strong knowledge in predictive modeling and Business Intelligence tools. Successful in developing tangible dynamic dashboards/reports and process improvements/automation. Solid experience in communication with cross-functional teams and executive leadership stakeholders.

A recent graduate from Data Science Program; equipped with advanced modeling techniques to lead an effective data strategy, deliver actionable recommendations, and data-driven solutions. TECHNICAL KNOWLEDGE

SQL SFDC SAS EG Tableau AWS (Cloud) Oracle

Python R SSMS Power BI Hadoop MS Office

SKILLS AND CAPACITIES

Qualitative & Quantitative Analysis Data Science Methodologies Data Mining Dashboard Development (BI Tools) Feature Engineering Data Modeling Data Evaluation Supervised/Unsupervised Machine Learning (AI) Root Cause Analysis A/B Testing Storytelling & Presentation Requirements Elicitation Quality Control System Development Life Cycle (SDLC) Lean-Six Sigma

PROFESSIONAL EXPERIENCE

Manager Marketing Data PLAN INTERNATIONAL CANADA Toronto, ON 09/2017- 09/2019 Spearheaded analytics for Donor Marketing. Translated data/business problems into actionable insights to non-technical audience. Managed large-scale campaign performance reviews across multiple business channels. Created & maintained models/ surveys to track donor behavior and segmentation changes.

● Reduced production time in budget forecasts’ data pipeline by ~20%; automated data feed

(ETL) and results to fit specifications of churn model using Python and Microsoft SQL server

● Successfully automated donor churn reporting and visualization using SQL query in Tableau, effectively reducing administrative work by ~75%.

● Discovered donor delinquency trends in Donor Care Outbound team; resulted in reduction of unnecessary outbound calls by ~10% to low prospect donors using Excel and Tableau.

● Managed design/implementation and communications of new KPI metrics in liaison with IT and Leadership Team. Translated Business/IT requirements to actionable insights.

● Created annual analytics roadmaps, self-serve dynamic dashboards in Excel/ Tableau, and managed data for marketing campaign performance analysis/ROI and A/B testing.

● Mentored data specialists, increased team productivity by ~7% with introduction to SQL, Tableau/Power BI and advanced Excel techniques.

Roman Margulis 647-***-****

2

Manager Wireless Base Analytics ROGERS COMMUNICATIONS Toronto, ON 10/2016 - 09/2017 Supported wireless customer lifecycle strategy and provided recommendations/insights on offer and tactic performance to increase and maintain current customer base.

● Advised on Rogers and Fido Price Plan Changes; tracked client rate-plan upgrades/downgrades to drive actionable decisions by senior leadership team.

● Assessed business impacts, bridged technical gaps between business and IT, discovered opportunities to maximize revenue generation and campaign effectiveness.

● Revealed actionable insights for Prepaid and Postpaid consumer conversion trends with SAS EG.

● Produced automated (ETL feed) Postpaid mix/rate analysis insights to executive leadership; reducing work effort by ~30% using Tableau and Excel.

● Excelled in data visualization techniques using Tableau and SAS for clear key point outputs to Executive Leadership Team.

Senior Analyst ROGERS COMMUNICATIONS Toronto, ON 11/2014 - 10/2016 Driven digital data analytics for "Texture by Next Issue Magazine" digital product within Media Business Unit. Designed, managed usage and forecasting reports/dashboards. Interpreted various metrics/ KPIs to form business decisions, improve customer experience and revenue generation.

● Championed all Texture team reports and data aggregation for Publishing/Media senior leadership team.

● Liaised with cable and wireless divisions to support “One Rogers” campaign by designing. and maintaining semi-automation; aggregating multiple data extracts using Teradata/SQL.

● Produced dynamic dashboards to track product application usage, with in depth analysis trending on user behavior using Tableau and Teradata.

● Aggregated database extracts and helped design data models/dashboards to identify consumer behavior and historic seasonality relative to churn, tenure, app usage.

● Prevented fraudulent activity, saving over $30K in expenses/month by creating new data validation processes.

EDUCATION & PROFESSIONAL DEVELOPMENT

Data Science Diploma BrainStation, Toronto, ON 09/2019 - 12/2019

• Successfully completed a 3-month Data Science bootcamp Capstone Project: An Artificial Neural Network (MLP) timeseries model using Python; Predicting direction of stock price relative to previous closing day. Business Analyst Certification Schulich Executive Education Center, Toronto, ON 09/2011 - 01/2012

• Successfully completed a Masters Certification in Business Analysis Bachelor of Arts, Psychology St. Bonaventure University, St. Bonaventure, NY 08/2004 - 05/2008

• Recipient of the NCAA Division 1 Swimming Athletic Scholarship

Contact this candidate