Josh Hall Email & Phone Number

Louisville, Ky, Us

Team lead on migration from Redshift to Snowflake. This includes design of internal Snowflake architecture, rolling off Stitch and onto Fivetran, moving historical data from Redshift to Snowflake, and implementing dbt as the transform layer to move from an ETL to ELT process. Team lead on the largest business intelligence project on retainer. Developed and maintained 20+ management level dashboards for multiple subsidiaries. Developed standardized deduplication process using SQL, for all the data sources that flow into the Untitled Platform. Data owner of all Untitled platform data. This involves having a deep level of understanding of each data source, an ERD for each data source, an enterprise data dictionary, and a business glossary. Developed visualizations for 2 of the 4 data sources rolled out in the Untitled Platform beta. Ad hoc analysis of internal and external requests, including vendor evaluation for Untitled’s data stack.

Columbus, Ohio Area

Became primary staff designated to 20+ clients for SAS 99 testing procedures. Responsible for managing all assigned SAS 99 projects from project initiation to sign-off, which included review of 1000+ lines of SQL code for each project. Completed data analytics of time and expense for $2+ billion client. Responsibilities included identifying risk areas, creating a risk and control matrix, creating process flowcharts, identifying relevant analytics, and building the dashboard deliverable.Performed general ledger data dashboarding for clients. This consisted of creating a global common data model (GCDM) that could be stacked on any other GCDM. This would allow for the dashboarding of any general ledger data, from any period, from any ERP system, from any division within a company.

Participated in the end to end process of defining, building, uploading, and analyzing customer audiences for the customer activation team: - Defined and built 20+ customer audiences for customer activation team. - Worked with LiveRamp, Leanplum, and Salesforce to upload dozens of customer audiences and prepare them for marketing distribution. - Performed analysis of customer performance for each campaign that ran during a specified period, typically 5-10.Developed standardized framework in SQL for pulling campaign performance data. Decreased data extraction time by 65%.In depth analysis of outlier or intriguing customer segments. This consisted of extensive use of SQL and Tableau to understand, create data-centric stories, and draw insight from these segments.Exploratory analysis and mapping of new loyalty program data structures (Punchh) in order to understand previous and current program performance comparison.Performed ad hoc analysis and data extracts for data science and loyalty teams.

Louisville, Kentucky Area

Performed root cause analysis on average ticket fluctuation between different customer segments.Performed analysis around checkout fallout in different markets using Google Analytics. Identified greatest fallout points in the checkout process in each market. Created a benchmark to compare checkout fallout per market to identify "good and bad" fallout rates. Performed customer behavior analysis around the introduction of a new user interface, coupled with technological changes to the user experience. Joined an analytic task force to identify customer attrition, customer longevity, ordering habits, and other metrics. Created enterprise dashboards for reporting purposes. Created data-centric "customer stories" to help drive specialized marketing efforts. Performed an extensive amount of ad hoc analysis. Extensive use of SQL (Google Big Query & Oracle), Google Analytics, and Tableau.

Louisville, Kentucky Area

Performed audit procedures for companies in many different industries. Testing areas consisted of: Cash, Accounts Payable, Accounts Receivable, Fixed Assets, Operating Leases, and Payroll.Duties included:Performing reconciliations on testing areas.Testing for accuracy and completeness of assigned areas. Agreeing client documentation to the general ledger and subsidiary ledgers. Performing analytics on testing areas in order to project thresholds for testing area amounts to fall within. Extensive use of Microsoft Excel to create efficiencies in testing as well as troubleshooting abnormalities. Also used Excel to test for journal entry completeness for all accounts.