Calculated high-level operational metrics for all lines of business and developed a dashboard on a web application to display the metrics using StreamlitCreated a Python program to scrape credible websites for reviews of Discover using BeautifulSoup4 to analyze customer sentimentAssisted auditors with finding cases of non-compliance of privacy preferences across all of Discover’s lines of business utilizing SQL saving auditors 40 hours of manual workTested customer privacy opt-out preferences to ensure that sharing and communication was discontinued as prescribed by national regulationsEnsured that Discover is correctly calculating customers' Cashback Debit Rewards and funds are being made available to consumers as prescribed by Regulation CC compliance

Tested for possible exceptions for credit bureau reporting across multiple Discover business unitsUpdated legacy SQL code to capture previous false positive exceptions and reduced them by 10%Ensured Discover sent accurate data to credit bureaus in a timely manner through appropriate backend controlsChallenged the predefined rules in Splunk and Exabeam platforms for potential risks or lack of controlsCurated source data for metadata and column relationships, increasing readability and understanding of the data for end usersCreated tables using DDL SQL code and deployed data into created tables using TOML files in Snowflake development and production environmentsBuilt data structures for the Recovery and Collections teams, saving 100 hours of data preparation for business analysts

Determined new pricing for dental procedures using internal metrics and external factorsUtilized SQL and SAS EGP to run analysis on several KPIs to determine the effect of pricing and insurance changes on officesWorked with marketing teams to determine the need and effectiveness of promotions locally, regionally, and nationallyDeveloped Tableau dashboards for stakeholders in order to get pricing information presented to them in an understandable and quick mannerPerformed an analysis of over 1,000 dental offices that led to a nationwide change in our pricing and insurance acceptance strategy leading to a 10% increase in revenue

Tracked and updated landlord, tenant, investment, and economic activity in local databaseProactively updated and maintained our database ensuring accurate and current dataUtilized Python to automate metric calculation for monthly and quarterly reportsConducted quantitative analysis on real estate trends in the Chicago marketCompiled, analyzed, and interpreted data required to write our quarterly market reportsCreated PowerBI dashboards to track historical trends and on-going activity in the Chicagoland market as well as track company performance

Reconciled client position and transaction files for financial accuracy and identified inconsistencies in datasets sent from the custodianConsulted clients in regard to best practices, policies, and procedures related to data reconciliation reducing incoming data issues by 20%Ran monthly and quarterly performance reports across 13 datasets to investigate accounts with unusual performance numbers

Conducted analysis on Excel to address a customer's assets to be able to import raw data to softwareContributed to office reorganization to maximize productivity and support administrative efficiencyProduced professional and error-free spreadsheets and tax forms Supported compliance department by compiling paperwork