Full stack analyst with a BI Engineering focus for a Series A live streaming marketplace app.Interim Data Team Manager covering for Head of Data on paternity leave. Fully managed the entire data pipeline from vetting and monitoring ETL services, dbt chrons, and Metabase visualization layer for 3 months. Delegated inbound data requests from internal stakeholders between myself and another analyst via Kanban.Migrated databases from Postgres to BigQuery by converting dbt models to become database agnostic. Accomplished via new Jinja expressions to identify database type and insert the proper syntax around existing SQL.Lead all data efforts for a critical company-wide growth initiative. Created a new data pipeline for Facebook Ad performance, integrating it with existing viewership and sales data. Key deliverable was a filterable dashboard that was reviewed company wide on a weekly basis. Outcomes included identifying the most effective campaigns, increasing ROAS, and reducing CPC.Automated Marketing’s email campaign performance analytics by creating a data pipeline for Mailchimp. Result was a user friendly dashboard that tracked and highlighted email performance and resulting user behavior over time, saving the marketing team a full day each week in manual report creation.Identified communities of users and sellers and created new health metrics to track these groups over time, resulting in a novel view of initiative effectiveness. Designed a new purchase attribution model that further informed which type of business activity was driving sales. Both projects informed a key strategic pivot within the company.Further analyzed user purchasing behavior by creating a sankey visualization to describe the user journey to the board of directors. Identified most common user paths to ideal outcomes and identified key points of user dropoff.

Dedicated analyst for all advertising and ecommerce activity. Produced recurring weekly and monthly reporting to upper management on key metrics such as impressions, revenue, CPM, fill rates, click-through rates, sales, cart metrics, conversion rates, margin, customer behavior, etc. Modernized ads reporting by creating a new ETL pipeline. Created a parsing script to ingest granular programmatic impressions from 16+ network partners, as well as our ads server. Consolidated and created a table to store ads data and uploaded to our Redshift based data warehouse. Saved countless hours of manual work on ad hoc requests and allowed new analytics on a regional and series basis.Automated house ad reporting using Python scripts, saving 6 hours of manual work per month. Met with creative team to review trends via click-through, signups, and share of voice to guide effective brand and series marketing.Collaborated with other analysts, data engineering, and product teams to design and track an A/B test for optimal ad load. Modeled impacts of each test case across the service and presented strategic recommendations to executives.Jump started sister company Rooster Teeth’s BI efforts by creating a recurring podcast content analytics dashboard from scratch. Initially began with raw data exports from Spotify, Apple, and other audio platforms; and eventually automated the process by onboarding Megaphone as a central data repository and BI visualization tool.Created narratives for the Rooster Teeth sales, content, and executive teams around key listenership metrics such as audience size & engagement, listening blocks, listenership trends, region & platform consumption, and episodic ratings. Mentored a junior analyst at RoosterTeeth and eventually transitioned over the entire reporting process.Designed cross business line analytics to inform the Ecommerce team on how best to promote sales of physical goods to streaming customers based on watch history and subscription statuses.

Created a new process from the ground up for the Crunchyroll Games division to track, report, and project mobile gaming revenue. Created external facing royalty reports for developer and Japanese IP holder utilizing app store key metrics, such as downloads, active user counts, user engagement, and in-game purchases. Developed a Python based content recommendation algorithm during an after-hours hack night. Vectorized all of our users' watch history and cross recommended shows from similar viewers. Subsequently met with data engineering to pass on the code, portions of which were incorporated into a broader content recommendation engine in use today.Created a new systematic audit approach for millions of monthly recurring subscribers using complex SQL queries of our in-house hadoop cluster. Engaged directly with data engineers to QA unusual payment behavior, revenue recognition logic, and payment provider data ingestion. Passed 2 years of audits with a 99.2% accuracy rate. Established new reporting processes for various global taxation and royalty authorities via SQL scripts and Looker BI dashboards.Served as an interim revenue manager during a ground-up rebuilding of the Finance organization; reporting directly to the CFO for 6 months while we searched for a Controller.Provided ad-hoc analytical support such as sentiment analysis for Marketing.Hired and trained my replacement upon promotion into the BI team.

• Responsible for all revenue streams of a large mobile payment & loyalty start-up during a time of triple digit growth. Product expert and primary operational point of contact for Account Management and App Support Team• Interfaced directly with key clients to resolve high priority issues and provide critical reporting. Compiled data via SQL querying of a Redshift based payment network; and tailored deliverables for end-users via Excel.• Independently planned, designed, and implemented a user-friendly, fully interactive dashboard to provide ad-hoc reporting to non-technical internal users. Continuously improved the dashboard via direct feedback from stakeholders. Usage of dashboard spread company-wide as a result of proven effectiveness.• Drove process improvement across the Finance organization to significantly reduce collection time, improve client billing accuracy, and ensure timely movement of funds.• Formulated and updated a transaction fee pricing model using aggregated interchange data of all transactions across the network. Verified adjusted rates aligned with company policy and contractual obligations.• Interviewed, hired, developed, and mentored two full-time interns, a new associate, and a peer to myself. Resulting in the doubling of the Finance team size. Fully delegated previous position duties between interns and associate.

• Joined as the third member of the Finance team and 70th employee, working directly with the CFO and Director. • Responsible for accounting and journal entry creation for all daily receivables and payables. Maintained detailed schedules for and tracked amortization of fixed assets, prepaid assets, patents, and debt. • Created monthly reporting packages and financial statements for Board and Investor review, in addition to weekly ad-hoc reporting requests using SQL • Collaborated closely with Account/Project Managers to ensure appropriate revenue recognition of all app development projects and billing of contractual fees.• Key contact during four external financial audits by a Big 4 Accounting firm and the MA Department of Revenue• Headed monthly “Listen & Learn” sessions for incoming new hires, detailing scope of Finance operations, inter-departmental interactions, and basics of stock options.• Independently organized, created, and presented a company-wide workshop on personal finance concepts, investing basics, as a result of popular demand and FAQs. Fostered an internal personal finance discussion group via Slack; resulting feedback led to a second workshop on credit scores.

• Performed audits for public and private companies in a variety on industries including: Retail, Technology, and Private Equity. Experienced with companies of all sizes; ranging from start-up to industry leaders.• As part of an IFRS component audit of a new client: performed internal control testing as well as interviewing clients to understand and document key business processes.• Tested revenue and cash as part of a carve-out audit of a large health industry client.• Provided assurance over construction costs as part of several attestation engagements for green energy companies applying for government credits• Provided coaching to interns and other associates• Extensive experience in physical inventory audits in a variety of industries• Coordinated the assignment of audit work to PwC teams in India and reviewed deliverables received

• Worked client side on the DineEquity engagement, Internship transitioned into contract basis work• Member of Core HR team – Responsible for discovering antiquated processes via subject matter expert interviews and researching pros, cons, and costs of process workflow improvements• Interacted with high level managers at a peer level to create presentations used in executive HR decision making• Impacted long-term company objectives by providing quality assurance and SharePoint support for three refranchising projects beyond regular working hours

• Trained new reps and worked as a team to achieve company sales goals• Explained technical aspects of contracts, plans, and technology in layman’s terms• Stayed up to date with quickly changing technology through research• Brainstormed and implemented creative solutions to customer’s difficult technical issues• Opened, closed, and handled all aspects of the store on weekends

• Completed 130+ hours of tax training prior to beginning the 2010 tax season• Filed 20+ tax returns with the IRS for individuals with a variety of incomes and living situations• Ability to ask for sensitive personal information in a discreet manner• Put clients at ease by answering complex tax questions in an efficient and easily understandable manner

• Audited inventory and accounts payable for SEC client Torotel Products Inc.• Assisted in composing The State of Kansas 2011 CAFR by gathering and analyzing annual reports of state universities• Sat in on client phone calls and discussed tax implications of complex transactions for B.L. Rieke Home Builders