Marcus Stone Email & Phone Number

New York, Ny, Us

• Lead a small team of data analysts to support Disney+, Star+, and ESPN+ Lifecycle Marketing & Experimentation initiatives in order to increase subscriber engagement, reduce churn, and improve subscriber retention• Implemented statistical methods in Python to analyze and measure the impact of marketing campaigns on user engagement, acquisition, and retention• Designed and built data pipelines to extract, transform, and load large volumes of data from various sources using Python and SQL• Led multiple successful experiments that resulted in improvements in subscriber engagement, acquisition, and retention, which drove decisions in the marketing and messaging strategy• Developed and maintained automated data workflows to ensure accuracy, completeness, and timeliness of data for reporting and analysis• Communicated insights and recommendations to stakeholders and senior management through statistical impact analysis and measurement, automated dashboards and reports, and presentations

New York, Ny, Us

New York, Ny, Us

• Developed automated ETL pipelines and solutions utilizing AWS, APIs, Python and Airflow to load product consumption data from various digital and mobile analytics tools (Adobe Analytics, Conviva, Airship, Kochava, mParticle, Segment) into our Snowflake Cloud Data Warehouse as well as various systems utilized by multiple business units.• Partnered with various product and business units to define core KPIs and establish reporting structure and cadence across multiple products focusing on user acquisition, user attribution, user consumption, retention, cohort analysis and revenue generation.• Provided expertise in our analytics capabilities and bridged the gap between business objectives and technical implementation teams to develop our mobile tagging strategy needed to enhance analytical insights as well as creating an internal customer data platform and identity mapping tool. This included translating business requirements into technical specifications, prioritizing product backlog, establishing project roadmaps, data modeling, data governance, ETL/ELT development, and implementing QA standards.• Collaborated and built trusted partnerships with Senior Leadership, Business Leads, Product Owners, Web & Mobile Developers in order to set priorities and direction for the overall product analytics roadmap and strategy across various brands and platforms.• Developed, enhanced and maintained automated Python jobs, SQL scripts, Airflow DAGs for semantic layer views and tables from various sources of structured and unstructured data in Snowflake allowing for an optimal and efficient end-user experience in our BI tool Looker.• Designed and built interactive dashboards and automated executive level report for multiple brands in Looker

Richmond, Virginia, Us

Summary: Worked on an in-house health insurance claim validation software application for a Fortune 500 company spanning across two scrum teams. I owned roles in both teams as a data engineer and product owner. I served a senior leadership role on the project and my responsibilities included: enforcing agile methodologies, prioritizing project backlog, defining project roadmap, driving technical architecture discussions, analyzing and creating solutions for multiple data and business complications, and contributing to development work for data ingestion from multiple source systems into Hadoop.• Developed data pipelines utilizing Python, SQL, Spark, API’s and Airflow DAGs to ingest data from various data warehouses (Teradata, Oracle, SQL Server) into big data platforms (HDFS/Hive/HBase) and systems of record.• Designed foundational data models needed for our claims validation system by joining complex data sets from various subject areas (Medical Claims, Pharmacy Claims, Provider information and Membership information) to adhere to business requirements, insurance standards and compliance.• Designed and developed a BI solution in Tableau leveraging data from big data platforms to create efficient real- time reporting dashboards to display business defined KPIs from the claim validation system.• Ensured standards and best practices were followed for all ETL and data modeling changes in the enterprise data warehouse and the data model built for the analytics and reporting solution• Drove ongoing product enhancements and optimizations to algorithms by identifying analytics insights from data generated by the claim validation system resulting in more revenue generation and cost savings• Translated business requirements into technical specifications in order to establish

Charlotte, Nc, Us

Summary: Primarily responsible for the development, calibration and validation of risk rating models for probability of default, loss given default, and exposure at default within the Wholesale Division of Credit Risk Management.-Implemented SAS and C# models defined by the statistical quantitative team utilizing data from SQL server and Hadoop-Built automated data ingestion processes for external data from one of the major credit bureaus in the US. This utilized the ETL tool Abinitio as well as similar functionalities within SSIS. This was a critical component to new predictive analytic models for defaults -Ensured that the assigned credit risk rating methodology for each portfolio was in compliance with all regulatory and legal requirements -Managed the UAT process for each custom built model within the Moody’s Risk Analyst application -Developed custom data validation scripts within SAS that were used for automated testing of the ETL procedures-Responsible for automating and scheduling risk rating jobs on a defined cadence through the use of linux crontab and shell scripts-Worked with credit risk managers for different lines of business as well as the statistical quantitative team to define requirements for risk models as well as customizations to user interfaces for multiple risk management applications

Jacksonville, Fl, Us

Summary: Business Analyst for multiple IT projects within the Capital Markets and Mortgage Lending departments; primarily focused on two major initiatives including a mortgage portfolio securitization application and an upgrade project to a loan origination system. -Led system integration analysis, requirement analysis, design, testing, support and debugging activities with key business and technical stakeholders including architects, developers and analysts.-Led data modeling and research alternatives for the development of business requirements. Performed data analysis with high complexity in support of ad-hoc executive requests. Developed SQL, SAS queries, Tableau Data Extracts and reports for analyzing and presenting mortgage data needed for the securitization process.-Managed all phases of testing including development of test plans, scenarios, data, and test scripts for facilitation of System Integration Testing (SIT) and User Acceptance Testing (UAT).-Developed custom VB Scripts for our retail loan origination system to integrate government tax rates for individual municipalities.

New York, New York, Us

Summary: Technology associate within Citi’s technology leadership development program. Focused primarily on project management, requirements gathering, and executive level reporting.-Worked closely with the Executive Management and business users to gather, analyze and create the Business Requirements documents and functional requirements to be provided to development teams.-Developed custom built dashboards utilizing ODBC, SQL Server, and PHP as well as Cognos to display real-time metrics of application performance for department directors-Managed multiple system integration projects throughout the full project life cycle for an initiative focused on consolidating in-house applications.

Masters, Information Systems

Bachelor Of Science, Finance

Nanodegree, Data Engineering