Shawn Crenshaw Email & Phone Number

Indian Trail, Nc, Us

Chicago, Illinois, Us

In this role, I have been tasked to create a future state data platform that enables speed to insight while providing self-service capabilities to customer success and product organizations. As the owner of the data, it is incumbent upon my team to improve the health and accessibility of the data at Yello. HIGHLIGHTS● Managing a team of 4 data engineers and 1 product data analyst ● Led successful transition of legacy Postgres DWH to data lake house using Starburst● Directed transition from Looker to Sisense Fusion dashboards that led to quicker access to client data● Creation of custom report process to streamline report development and satisfy customer needs● Review RFPs from various vendors to choose BI solution to foster self-service capabilities● Providing reporting and analytical product solutions ● Data architect tasked with identifying the tech stack needed to enhance data analysis and reporting capabilities ● Utilization of JIRA to structure the intake, development, and delivery of Analytical Products

Anaheim, California, Us

In this role, I have been tasked to create sustainable, nimble analytical solutions to drive speed to insights and actions. This will enable collaboration, innovation, and creativity across various teams throughout Channel Bakers. Utilizing data strategies, including DOMO, Amazon Marketing Cloud, S3, and AWS to unlock efficiencies to meet the speed of the business.Currently managing US and Off-Shore team of 17 employees. Providing reporting and analytical product solutions. Accomplishments:Build innovative solutions using Amazon Marketing Cloud (AMC)Implementation of Report Intake Process to improve efficiency and transparency in the request intake processUtilization of JIRA to structure the intake, development, and delivery of Analytical ProductsCreation of dynamic dashboards in DOMO to visualize Amazon Marketing Cloud, Amazon Search and DSP data for various clientsDesign and implement digital shelf reporting product to highlight competitive landscape for various clientsDefine analytical solutions to enable Analytics and Insights department to generate revenue for Channel Bakers

Charlotte, North Carolina, Us

In this role, I have been tasked with building out a team to enable data and analytics capabilities at Caring. Since Data and Analytics are critical to all that we do at Caring to serve seniors, the BI area is crucial to ensuring we remain a trusted source for caregivers. Using technologies such as Snowflake, Looker, SQL, JIRA, Confluence, along with other tools, we will ensure business intelligence at Caring is best in class.● Redefined the identification of the process used to refer care recipients to care providers using data driven analysis and enablement● Created one source of truth data sources for Digital Marketing, Operations and Partner Sales and Support business units. This resulted in elevated trust and utilization of the data sets.● Act as product and project manager for BI by utilizing Agile Scrum methodology to allocate work by 2-week sprints. This included the creation of epics, user stories, and tasks.● Governed access to Looker through the establishment of data governance procedures● Developed roadmaps to shape and guide Business Intelligence department at Caring.com● Designed dashboards to provide insights into previously underutilized reporting areas for Partner Sales and Support business unit● Instituted BI Office hours and bi-weekly meetings with analysts to ensure collaboration and knowledge transfer between BI and business units● Managed FTE by providing consistent feedback and coaching● Crafted documents to enable the gathering of requirements for work needed by the business areas. These documents included, SOWs, BI Onboarding Document, and Presentations.● Led the complete redesign of reporting in Looker for all business areas. This effort resulted in the streamlining of data sources and improved efficiency of data processing.● Point person for relationship with third party BI tool to ensure the correct allocation of users per contract

Hartford, Ct, Us

Design metrics and reporting to track promotions and new hires as enterprise metric lead for Black Insurance Professionals Network Employee Resource Group (ERG)Build Talent Overview Scorecard in Tableau to highlight areas of action for managers to allow for the increase of diversity and inclusion hiring within The Hartford.Utilize predictive models in Tableau to enable managers to mitigate first year attrition within business segments at The Hartford.Direct third-party resources in the design of Enterprise HR Dashboards by crafting HR BI Framework for Tableau dashboard developmentArchitect HR Data and Analytics Tableau site by leading design and structure of projects and workbooksCreate test plans and test cases to ensure data model solution meets the requirements stated for HR Data Structures projectProvide thought leadership to model HR data structure and BI reporting solutions to enhance reporting capabilitiesDirect discussions pertaining to HR data model development for HR Data Warehouse through the creation of data model design documents and data mapping documentsImproved team capacity by 4-6 HRS a month by streamlining HR data request intake process through automation by creation of SharePoint InfoPath form and workflows.Manage ad hoc requests queue to determine prioritization of work flow.Steward access to HR data through data object re-certification campaign.Led the requirements gathering for Agile project to implement enhancements to WebFocus enterprise reports that offer better security, business resiliency and visibility to key employee attributes.Perform gap analysis to guide automation of HR data flow into Personal Lines and Small Commercial OperationsCreate Tableau dashboard to provide operational metrics and analysis of HR data requests

Matthews, Nc, Us

Use Agile tools, including VersionOne, to track requirements, create user stories and acceptance criteria for Sparkflow projects.Oversee end-to-end implementations of Sparkflow Data Warehouse Designer application at client locationsCreate test cases and test scripts for implementations of Sparkflow Data Warehouse Designer applicationLead Implementation of Mastercard data model development for Capital Bank’s debit card conversion.Perform data mapping of various source data into target dimensional attributesDraft and create process of encrypting sensitive personal data in automated ETL processing through Sparkflow Data Warehouse Designer application.Procure requirements and create requirements document for client Online Banking applications

Charlotte, Nc, Us

Establish Sales and Marketing Data Center of ExcellenceCreate transitional reports using BEX analyzer and SAP Business Objects for CONA system transformation project.Responsible for managing relationship with Distribution, Routing and Equipment Services Departments within Sales and MarketingProvide thought leadership for system transformation project.Lead automation of KPI reporting from Microsoft Power Pivot files to Enterprise Data Warehouse via Tableau dashboards to increase accuracy and efficiency of reporting Develop enterprise dashboards in Tableau to improve decision making for Sales and Marketing executivesLiaison with Enterprise Data Warehouse team to develop custom views and stored procedures for Tableau dashboardsPresent enterprise dashboards in Tableau to field operations managers to enhance tool acceptance and adoptionCraft training materials to supplement knowledge base for enterprise dashboards in TableauCreate Business Requirement Documents to capture business requirements and clarity on business request submissions

Charlotte, Nc, Us

• Design and Craft Project Plans to oversee the development of internal reporting solutions for Centralized Property Preservation organization• Manage Quick Response Team in the assignment of resources in the production of high visibility Compliance and Audit related reports and scorecards.• Decrease timeframe of report completion and delivery to less than two days.• Establish management routine and centralized data repository for completed reports and source code.• Integrate T-SQL and Excel Pivot tables in the design and development of key performance indicator (KPI) Scorecards for Deed In Lieu reporting• Increase accuracy and efficiency of vendor invoice reconciliation through the automation of MS Access database • Perform gap analysis and requirements gathering for the Default Servicing Short Sale LEAN project.• Assist in the rewriting of daily, weekly and monthly key Short Sale and REO reports in SSMS as part of migration to Phoenix ODS • Utilize SQL in the creation and delivery of executive reports to assist in monthly and yearly forecasting for FNMA, FHLMC, FHA & VA investors.

Charlotte, Nc, Us

• Design and implement test cases and test scripts to assist in User Acceptance Testing for on-time implementation of new Learning Management System in Global HR Information Reporting• Assist in developing custom Learning and HR reporting solution utilizing Oracle Business Intelligence• Craft training documents to guide users with usage of Learning and HR reporting solution in Oracle Business Intelligence• Partner with Global Learning organization in developing learning performance metrics for senior management• Utilize SQL in the analysis and retrieval of data from Oracle tables to develop weekly routines to resolve data process issues• Employ Teradata SQL to research and decipher data warehouse tables in the resolution of FTE and Headcount data issues• Analyze and gather business requirements to correct inaccurate data interfaces to Global Finance organization • Owned and maintained FTE and Headcount calculation in HR Information Reporting• Managed integration of FTE and Headcount data for Merrill Lynch, Countrywide, LaSalle and US Trust acquisitions• Led FTE and Headcount calculation modification as a result of pay frequency change involving non-exempt associates• Execute monthly manual adjustments to FTE and Headcount in In$ight to ensure financial accuracy• Create customized FTE and Headcount reports for Global HR executives