Analytics

Aria Lee

Florham Park, NJ 689-***-**** ***********@**.*** https://linkedin.com/in/arialeehappy/

https://github.com/arialee32708/project-portfolio

Business Data Analytics Manager

Highly analytical and accomplished professional with substantial experience in driving strategic initiatives and leveraging data-driven insights to optimize business processes. Skilled in enhancing debit network routing using BI tools and AI machine learning techniques. Excel in leading diverse teams to enhance operational efficiency and drive sales growth through innovative applications. Adept at overseeing debit routing KPIs and revenue billing processes and optimizing client cost reduction and incentive revenue streams. Committed to fostering a culture of continuous improvement, streamlining processes, and consistently delivering insights that align with strategic business objectives. Proficient in executing complex data ETL, conversion, migration, and integration, ensuring data security and efficient management to support decision-making at all organizational levels.

Areas of Expertise

Business Intelligence Analytics Trends and Predictive Analytics Data Analysis and Reporting Project Management Data Product Development Data Modelling and Visualization Cross-functional Collaboration Data Science and Machine Learning Leadership and Team Building

Technical Proficiencies

Python SQL Oracle Databases Power BI Tableau Cognos SSIS Azure Synapse Analytic AWS Sagemaker Snowflake on Cloud Jira/Confluence (Agile workflows) Cognos Frameworks Manager Model

Professional Experience

Fiserv 4/2021 – 12/2024

Business Data Analyst Manager

Monitored B2B portfolio and customer well-being, extracting valuable insights to drive strategic decisions. Recognized and capitalized on opportunities to streamline and automate billing and client data management processes, enhancing efficiency and accuracy.

Collaborated with Product and Operations teams to optimize debit network routing using BI tools and AI machine learning methods. Provided actionable insights for process improvement and ensured accurate record-keeping.

Addressed inquiries related to network transaction anomaly detection, prevention and monitoring, merchant inquiries investigation, sales forecasts, network rules. Monitored debit routing KPIs and revenue billing.

Managed debit routing orders with a focus on minimizing client network expenses, risk and maximizing incentive revenue.

Created and deployed a robust PNR monthly billing automation system in Snowflake.

Engineered and implemented a prospect merchant’s tool for the sales team, leveraging machine learning and Gen AI technology, resulting in a remarkable 50% productivity increase and driving sales growth.

Achieved significant operational efficiency gains by automating billing processes, minimizing manual labor, and eliminating potential human errors in financial calculations.

Business Intelligence Consultant/Data Analytics Team

Delivered tangible, project-based customer-facing consulting services to Fiserv bank clients, focusing on resolving business challenges through revenue generation, business efficiency, and data security solutions.

Aria Lee 689-***-**** Page 2

Conducted thorough analyses of bank clients' strategic objectives and optimized their data analytics solutions to enhance revenue, reduce expenses, and achieve desired outcomes. Proficient in data ETL (extract, transform, and load), conversion, migration, integration, and the development of reports and dashboards for Fiserv Banking core clients, encompassing data center operations.

Spearheaded Fiserv Bank clients’ Scorecard Project, leveraging SQL Server Integration Services (SSIS) to overhaul ETL solution, automate processes, and enhance efficiency by 30-50%, driving substantial productivity gains.

Steered development of the Fiserv ACH leakage report template project, facilitating seamless migrations of ACH leakage report templates within Cognos business analytics for potential Fintech banks utilizing Cleartouch Core.

Disney Travel Ops 5/2008 – 4/2021

Wholesale Report Analyst

Orchestrated operations encompassing the development, expansion, and upkeep of a client base comprising over 250 international wholesalers' data warehouse. Conducted data ETL and analysis utilizing SQL, Tableau, Excel, Microsoft Access, and Power BI to drive insights and inform decision-making processes.

Provided pivotal sales support by spearheading the development and execution of a quality assurance project for the sales and marketing teams at a Travel Ops company.

Developed portfolio reports, analyzed trends, and drafted communication to teams and partners across all organizational levels, ensuring alignment and effectiveness in strategic initiatives.

Provided support to a specific team that experienced a 4% quarter-over-quarter improvement in sales after implementing targeted interventions and support measures.

Monitored KPIs for the sales team and conducted investigations to identify any instances of underperformance.

Key Projects

Customer Success Dashboard

Developed and implemented a comprehensive Customer Success Dashboard, providing actionable insights and predictive analytics to improve account performance and retention strategies.

Designed a weighted scoring system incorporating NPS score, CSAT score, payment transaction volume, revenue, support tickets survey, and implementation survey to deliver monthly performance overviews for over 200 accounts.

Automated detection of the biggest decliners in transaction volume and provided volume and count forecasts to enable proactive management.

Integrated Revenue Net Dollar Retention (NDR) metrics to track growth and identify opportunities for upselling and cross-selling.

Developed a weekly support ticket report to identify trends and prioritize areas needing attention.

Built and deployed a predictive churn model that highlighted high-risk accounts, enabling targeted interventions to reduce churn.

E-Commence Fraud Detection and Risk Analysis

Developed machine learning model in Python to predict fraudulent transactions and alert system to prevent fraudulent activities.

Performed exploration data analysis on 138K transactions including and preprocessed data by removing duplicates, encoding categorical features, and handling imbalanced labeled data.

Built random forest model, evaluated the models via 10-fold cross-validation and found optimal model parameters via grid search.

Selected the best model based on AUC and designed a real-time alert system to prevent fraudulent activities.

Aria Lee 689-***-**** Page 3

Bank Credit Risk Modeling and Prediction

Applied feature selection methods to improve the predictive model of a financial risk problem.

Trained and deployed various classification models to achieve better performance using different algorithms.

Quantified credit and fraud risks with a variety of data sources to distinguish risk loan applicants.

Maximum PNR Monthly model

Researched optimal solutions to maximize monthly PNR revenue within defined objectives and constraints.

Leveraged Pyomo, a Python modeling library, to augment its functionality, tailored for mathematical modeling and optimization tasks on the Amazon SageMaker platform.

PNR Monthly Revenue Prediction

Devised a machine learning model in Python to predict monthly PNR revenue with average accuracy rate of 98.5% by multiple linear regression model on the Amazon SageMaker platform.

Designed and Implemented Network Routing Anomaly Alert tool

Created an interactive Power BI alert tool to detect anomaly transactions routed to specific networks.

Identified and addressed outliers to empower management with advanced analytics capabilities, aiding in the mitigation of financial losses and fraudulent activity.

Designed and Implemented Power BI Tool for the Sales Team

Developed an interactive Power BI solution for the sales team, integrating seamless monthly data refresh from Snowflake.

Enhanced sales team productivity by providing automated insights, including segment and trend analysis, fostering data-driven decision-making.

Implemented self-service AI functionality, empowering end-users to explore data independently.

KPI Dashboard

Designed and implemented KPI monthly dashboard to provide organizations with valuable insights into their performance, enabling them to drive improvement, enhance decision-making, and achieve their strategic objectives more effectively.

Developed PNR Monthly Billing Automation in Snowflake

Engineered and deployed a resilient PNR monthly billing automation system within Snowflake.

Achieved substantial operational efficiency gains by automating billing procedures, reducing manual workload, and eliminating potential human errors in financial calculations.

Bank Scorecard Project

Implemented SQL Server Integration Services (SSIS), a robust data migration and integration tool integrated with Microsoft SQL Server database.

Improved efficiency by 30-50% through redesigning the SSIS (ETL) solution and automating the scorecard project process.

Bank ACH Leakage Report Template Project

Streamlined the migration process of ACH leakage report templates within Cognos Business Analytics, specifically tailored for potential Fintech banks utilizing Cleartouch Core.

Aria Lee 689-***-**** Page 4

Interactive Tableau Project

https://public.tableau.com/profile/aria6899#!/vizhome/CapstoneonePredictInsurancecharges/Insurancecostsstory?publish=yes

Education

Master of Science (M.S.) in Management/Business Analytics

University of Central Florida, Orlando, Florida

Bachelor of Science (B.S.) in Management

Belhaven University, Jackson, MS

Certifications

Snowflake Hands-on Essentials (Data Warehouse, Data Sharing, Date Applications, Data Lake, Data Engineering) SAS Basics Programmer AI and Data Engineering (Laioffer)

https://www.credly.com/users/aria-lee.020f257a

Contact this candidate