Created a star schema design for POS data environment and implemented it in an AAS tabular model to provide a performant and comprehensive self-serve solution.

Streamlined and consolidated high visibility dashboards in order to deprecate old data objects and decrease cloud processing spend.Created and automated a real-time validation process for POS data by leveraging Python, Spark, and Snowflake to decrease manual labor hours and errors, improve data integrity, and gain executive trust.

Developed an API wrapper in Python to collect and flatten json data from several sources to combine into a single data frame. Data was fed into a dashboard that was used by management to track Airtable tickets across the business.Created Jupyter notebook scripts that allowed users to interact with a gooey interface where they could filter on many dimensions and return a list of members for targeted campaigns.

Lithia Motors, Inc. (NYSE: LAD) is a nationwide automotive retailer headquartered in Medford, Oregon. It is the third largest automotive retailer in the United States and currently #294 on the Fortune 500 with 180+ dealerships and $12+BN in annual revenue. Worked with internal business groups, third party vendors, and contractors to implement an entity wide Workday ERP system. Managed and designed all integrations involving the on premises data warehouse.Headed initiative to reduce data warehouse ETL duration to move from a daily data refresh to a three hour data refresh. Used a custom logging system that captured SSIS package component duration to track down long running SQL agent jobs. Built a Power BI front end for a simple interface to visualize trends and KPIs for senior level management to track progress of our efforts.

Established areas of improvement of audit procedures and streamlined testing using Fabsoft, sharepoint, dynamic SQL database and Power BI user interface.Identified high risk stores and participated in high level auditing of over 190 dealerships using a self-made risk formula leveraged with R programming language.Conducted training on new audit tools and programsWorked with internal business groups and external auditors to create, enforce, and test entity wide general IT controls in line with SOX requirements. Upheld data management and governance standards to promote data integrity.Created an audit score database leveraging SSMS and PBI to track and trend individual store and department level management performance.

Managing, supporting, and informing 25 clients consisting of banks and credit unions from sizes 200 million to 4 billion in total assetsDelivering strategic plans and institution analyses to key senior management personnel on and off-site by consolidating and analyzing years of database cycles, macro/micro economic research, and ancillary dataManaging Matrix Marketing program, Appended Data, and Executive Strategic Reviews. All deliverable items for 25+ clients.Daily use of advanced SQL, Microsoft Suite, VBA, geo-mapping software, and in-house database software. Very quickly adapt and learn client institution's core systems.

Supporting, auditing, and analyzing financials of over 30 banks and credit unions from 200 million to ~6 billion in total assets. Presented new strategies and campaigns based on big data analytics to senior executives.Daily use of SQL to query dynamic lists from a robust database to draw further analysis of client dataDesigned, created, and implemented client databases using client's General Ledger and Systems of Records, internal and external. Including database maintenance and updating.Advanced knowledge of big data analytics, extrapolating data from internal, external, and transaction data to form institution strategies aimed towards growth, risk management, and customer acquisition/retention.Staying discrete and keeping delicate client information secure