Sean Brooks Email & Phone Number

Denver, Colorado, United States

• Guided a team of 3+ analysts that produced scaled, self-serve dashboards using Oracle Analytics Cloud that empowered stakeholders to make data-driven decisions pertaining to product analytics, operational efficiency, resource management, corporate financials and more for a $300M+ in annual revenue organization.• Crafted and managed the development of a data model, ETL process, and suite of dashboards that automated the monitoring of the migration of $100M+ in cloud resources from AWS to OCI and identified a chargeback error resulting in $3M in savings.• Leveraged Python, Tableau, and SQL to effectively allocate $300M+ in labor and cloud costs across a suite of products, resulting in $10M in cost savings through decisions to deprecate underperforming products.• Generated quarterly roadmaps, prioritized workloads, and facilitated weekly status meetings using Agile methodology and Jira to ensure alignment with organizational objectives and successful project execution.

• Led team of 5+ reporting analysts and warehouse developers responsible for designing and creating reports, dashboards, ETL processes, and structuring an efficient data warehouse responsible for corporate reporting and analytic needs focused on operational efficiency and data asset health• Designed and implemented a robust operational data process with flexible and efficient data models and dashboards with SQL, Python, and BI Tools that served as the go-to solution for product delivery and increased delivery time by 15%, while reducing error rates by 10%.• Served as Project Manager for the successful migration of operational dashboards from Tableau to OAC(OBIEE) resulting in significant improvements in reporting efficiency and reliability.

Broomfield

• Partnered with Product Managers to define, develop and track quantitative success metrics for products and features with $100M+ in annual revenue.• Managed the organizational migration of our product telemetry solution from Google Analytics to a custom-built alternative. This project involved utilizing agile methodology, making key solution decisions, overseeing project management, and leveraging Jira and status meetings to ensure seamless execution.• Developed scalable, self-serve dashboards for the Product Team, enabling them to analyze client behavior and refine products, thereby maximizing over $100M in annual revenue.

Greater Denver Area

• Leveraged SQL, Python, and SAS to analyze direct-mail and on-line campaigns to present results and modeling improvement recommendations to clients. Datalogix was acquired by Oracle for over $1.2 Billion.• Proactively developed an automated solution with Python, SQL, and PowerBI that segmented clients' customer files using advanced analytics, enabling the go-to-market team to effectively upsell solutions.• Addressed clients' ad-hoc questions on campaign performance, managing end-to-end analysis delivery, including problem-solving, design, data collection, analysis, recommendations, presentation, and client relationship management.

• Managed team of 4+ responsible for data engineering, reporting and ad hoc analysis pertaining to multi-channel (retail, catalog, web) testing, pricing, merchandising, marketing, inventory planning, and customer loyalty programs for an organization with $500M+ in annual revenues.• Designed and developed an automated A/B testing solution using Python, SQL, Excel, and BI Tools (Reporting Services),enabling Coldwater Creek to swiftly test and implement retail and ecommerce promotions and pricing strategies. This solution ensured statistical significance and reproducible results, significantly enhancing decision-making efficiency.

Sandpoint, Id

Analyst in charge of generating, presenting, and reporting, weekly, monthly, and annual retail sales forecasts to senior executives and functional teams.

Sandpoint, Id

Analyst in charge of generating and presenting analysis with actionable recommendations to senior executives regarding pricing, merchandising, retail operations, marketing, web, direct mail, email, inventory planning, and customer loyalty programs.

Riverwoods

• Managed team of three Senior Statistical Business Analysts/Programmers and an external data processing vendor responsible for the statistical modeling and decision making of 50 million direct mail credit card solicitations per month.• Served as subject matter expert for credit card acquisition, statistical modeling, and offer determination that included A/B testing implementation and analysis.• Designed an accelerated process to launch marketing campaigns that resulted in a 25% reduction in campaign delivery time.

Riverwoods, Il

Lead SAS and SQL programmer in charge of executing the statistical modeling and offer determination for credit card acquisition using various sources of business intelligence such as marketing databases, customer demographics, mail lists, and credit bureau lists.

Lincolnshire, Il

Lead SAS Programmer for Target’s Benefit Delivery Team (Pension and 401(k)) in charge of developing, auditing, and monitoring all batch schedules, programs, and information delivery. Managed team’s programming workload, while also acting as coach and mentor for other analysts on the team.Identified and redeveloped system intensive code saving hours of processing time. Designed and taught several classes to new analysts.

Certificate, Data Engineering

Topics and Classes: Python, MySql, Database Design, GitHub, Docker and Containers, APIs, Swagger, Postman, Strapi, Flask, Bootstrap.

Masters, Computer Science

Bs, Finance, Economics