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.

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.

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.

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.

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.