Caroline Kastner Email & Phone Number

Boston, Ma, Us

Somerville, Ma, Us

• Developed an analytics roadmap based on annual business goals and stakeholder needs from teams across the business. Released a monthly newsletter keeping everyone informed of recent releases and upcoming projects.• Partnered with leadership and key stakeholders to design and launch complex Tableau dashboards that met both the immediate and longer-term needs of the business.• Acted as Tableau Cloud administrator and trainer for entire organization. Developed Tableau training recordings for new hires to review during their onboarding.• Reviewed and monitored reporting created by the broader business and ensured that accurate data and visual best practices were utilized.• Designed and created an executive summary of annual KPIs that was viewed daily by leadership and shown monthly to the Board of Directors.• Jira administrator and sprint manager for the Data Team with a focus on prioritization.• Architected reporting tables using dbt & Github that joined web traffic, sales, and marketing cost data as the basis for Tableau full funnel and profitability reporting.• Launched Tableau Pulse and dashboard extensions on Tableau Cloud.• Migrated disparate reporting that lived in Google Sheets, Airtable, and Metabase into comprehensive Tableau dashboards that streamlined Marketing and Concert Operations' workflows.• Developed reporting in tandem with product development and marketing experiments so that success could be analyzed and monitored from launch of these initiatives.• Created a full suite of documentation in Confluence related to all things data and analytics, including Tableau dashboard documentation, monthly team newsletters, data table descriptions, data dictionary, etc.

Jersey City, New Jersey, Us

• Developed and managed a global, remote team team of 2 managers and 7 analysts to handle data and reporting needs for all areas of the business, including executive leadership, SEO & SEM, Finance, Product, and Account Partnerships.• Created annual strategy for all data pipelines and reporting; kept the entire org informed of the team's progress through a monthly newsletter and quarterly virtual presentation.• Partnered with key business stakeholders to gather reporting requirements and ensure proper prioritization and scoping of work. Worked closely with the Data Engineering team to ensure new data sources needed for reporting requests were ingested and existing data sources kept up to date.• Tableau Cloud Administrator for 400+ licenses; developed robust Tableau training for Creators and Viewers.• Managed the migration of key reports in Google Data Studio (AKA Looker Studio) into Tableau.• Designed and released essential reporting on KPIs such as web traffic and revenue for the launch of Forbes Marketplace managed pages on usatoday.com and cnn.com.• Outlined career path for Analytics Team from entry-level through management roles and ensured that robust career development conversations happened with all team members at least quarterly.• Launched a team-wide career development initiative where team members could pick from a list of skills or projects to focus on for 10% of their time to ensure that everyone continued to grow their technical and soft skills.• Weekly team meetings always included "show & tell" of everyone's work from the past week and at least 1 team member lead training on a new skill in SQL, Tableau, or Notion.• Launched Notion as company-wide Wiki and documentation tool; created > 1,000 pages of documentation related to project management, Tableau dashboards' documentation, team management (including new member onboarding), career development, reporting best practices, recorded virtual trainings, etc.

• Drive the vision and execution of the BI and Analytics roadmap, focusing on delivering key business impacts to all levels of the organization.• Centralize and prioritize all data needs across the organization from executives, product, sales, and editorial teams• Collaborate cross departmentally to ensure the data platform provides accurate, timely and actionable information to its various data consumers. • Evangelize education and adoption of data and analytics across the organization, through demos, training, and automated alerts.• Comprehensively address high-level and detailed business questions by clarifying requirements, developing hypotheses, and building the report/dashboard/analysis with an eye towards scalability, self-service, and automation.• Proactively seek out and identify business opportunities and pain points, always considering future-state when crafting analytics frameworks.• Flex between strategic problem solver and tactical creator to define and implement end-to-end solutions for metrics creation, data development, standardized reporting, and ad-hoc analysis.• Contribute to a collaborative and inclusive atmosphere, where team members communicate and problem-solve together, built on a solid foundation of trust and commitment.• Strategizes and directs the design, development, improvement, and governance of business intelligence systems, programs, and services to meet Decisionary's informational needs• As Tableau Cloud Administrator, ensures the reliability, security and availability of systems for reporting, analysis, and data extracts. Migrated all users to multi-factor authentication. • Created and maintained robust documentation for everything related to data and reporting, from reporting roadmap to data ingestion schedules to video demos of reporting functionality.• Oversaw Tableau training and reviewed reporting output from other analysts.

Boston, Massachusetts, Us

• Lead planning, strategy and execution of efforts to transform and synthesize data from multiple sources and identify optimal reporting structures to support end-state visualization including platform architecture, roadmapping and tool development• Translate data into digestible and highly visual dashboard applications that elevate analytics into actionable information; implement BI, reporting tech stack and dashboard solutions to optimize critical decision making• Serve as Looker Admin, connecting new data sources, modeling LookML, designing measures and building reports; rolled out a new instance of Looker, and migrated reports/dashboards with connections to new copies of production database • Implemented persistent data tables (PDTs), improving dashboard load time performance from > 200 seconds to < 3 seconds• Designed and built a new standardized, customer-facing, embedded Looker dashboards within the product, prompting customers in implementation to forgo custom dashboards in favor of the newly created one • Worked with back-end engineers to design new sales demo product platform and provided scripts needed to create ideal dataset for Sales Demo embedded Looker dashboard• Created in-depth Looker dashboard suite for Sales team, revealing Salesforce data trends related to qualifying opportunities, sales rep productivity, new rep ramp-up time, and deal segmentation• Implemented Heap on internal platform, defined events, and built first round of reports on user journeys throughout product

Waltham, Ma, Us

• Lead analyst for 3-person team that oversaw the creation, enhancing, maintenance, and automation of reporting for the entire business including Finance, Engineering, Product, Commercial, Account Management, and Executive teams• Build a singular “source of truth” using custom AWS data stack (API Gateway, Kinesis, S3, Athena, Redshift, Aurora, Lambdas), API ingestion layer, DBT, and Tableau• Unify and automate ingestion financial information across > 15 data sources, including salesforce.com, Google Analytics, Tune, Excel, and SQL tables• Utilize a disciplined and data-driven approach to analytics, integrating in new technologies, and retiring legacy applications to build new reporting capabilities and deploy dashboard frameworks• Develop data roadmaps including current state assessments, data connection points and project plans required to build accelerators and support foundational capabilities for advanced reporting and A/B testing• Translate high level requests from Category Management and commercial teams into actionable Tableau dashboards used to draw analytical insights, facilitate sound decision making, and serve as the backbone of guiding organizational decisions• Partnered with Salesforce.com administrator to move two revenue product lines from a manually tracked process in Excel into SFDC; set up regular extractions of SFDC data, remediated data discrepancies between Excel and SFDC, and worked this new data source into queries and reporting with all other product lines’ revenue• Integrated user pathing data with pay per click spend and sales to create conversion metrics and identify unprofitable areas• Worked with the Sr. Engineer to design new data source ingestion processes and remediate upstream data collection issues• Created Tableau-generated emails for both critical daily reports and error-only reporting, which alerts business teams when their manual data mapping misaligns with standardized values

Framingham, Massachusetts, Us

• Sole systems and product analyst responsible for developing analytics roadmap, defining future state design, gathering requirements, documentation, and implementing new self-service reporting• Leverage Agile methodologies to improve the planning, prioritization and the tactical execution of project phases; partner with Product Strategists, Product Owners, and Lead Developers throughout project life cycles• Structure governance processes around reporting architecture, technical oversight, and stakeholder engagement; create a disciplined project management environment based on speed of decision making and project visibility • Consult with external and internal clients to design and build comprehensive, easily-digested reporting using business intelligence (BI) tools and multiple data sources, including SalesForce, Oracle, and Globoforce's SaaS platform• Work closely with the Dublin-based Database Administration (DBA) team to enable proper access to new datasets, ensure query optimization, and help QA new environments• Develop internal automation tools to streamline processes and provide timely access to data, reports, and dashboards• Lead company-wide training on Workfront system

Framingham, Massachusetts, Us

• Established new standards, automated processes, and enhanced procedures to streamline communication and interactions across teams, and supported the rapid deployment of data reporting strategies• Managed multiple phases of reporting strategies including business requirement mapping, functional/technical design, data structure analytics, visualizations, standardizations, and user-interface design• Wrote ad hoc SQL queries and created new daily reports to illuminate client trends, provide business insight/transparency to the executive team, and offering empirical data for sound product development• Collaborated with DBA team, System Architects and BAs during product development to ensure data changes and enhancements were accurately stored • Point person for all client-facing reporting and internal cross-client trend identification; designed reporting templates in Jaspersoft and launched automated monthly client reports • Implemented Workfront, a cloud-based project management system, to handle analysis requests from across the organization; trained 50 users

• Developed automated processes and enhanced procedures to streamline data flow and enable data access across multiple platforms; actively developed approaches and frameworks to enhance data quality and integrity• Oversaw multiple aspects of project planning phases including conducting current state assessments, gathering requirements, definitions and functional specifications, analytics, stakeholder engagement, and determining timelines • Created and maintained SQL queries used for transferring data between databases and products; designed customizable, analytical reporting that included exporting and graphing capabilities• Planned and executed a data entry website that fed directly into new and pre-existing database schemas• Led weekly meetings with Sales, CRM, and Product Development teams in U.S., London, and Hong Kong; developed and presented product development strategies at company-wide meetings and executive summits

• Migrated a European, subscription website to Infinata's software platform, including creating and testing data feeds, building the new front-end, developing e-mail alerts, and transitioning existing users to the new product• Acted as Infinata's point person for an offsite server migration of a top-15 U.S. bank's data and marketing reporting systems; worked closely with DBAs and IT personnel• Traveled to London, U.K. semi-annually to meet and strategize with internal sales and marketing teams• Trained new analyst hires in Microsoft Access and SQL• Promoted from Business Analyst in 2008

Oo

• Involved in the planning and development of “Workbench,” a new super-screen platform that brought mainframe information from various systems to Customer Service Reps in a user-friendly, web-based format. Worked with developers and researchers as a Business Unit contact person, determining the content and layout of the new system and then testing operational and data changes.• Point person for site strategy planning and implementation of the call center’s move to Canada. • Acted as department supervisor, answering CSRs’ questions about phone calls and correspondence, handling escalated calls, and providing department-specific procedures’ training.

Waltham, Ma, Us

For this international market research firm, worked fulltime creating “PC Deals,” a weekly web column analyzing the week’s consumer PC offers from major retailers, alerting consumers to price and technology trends, and computer purchasing pitfalls.