Ryan Nolan Email & Phone Number

Orlando, Fl, Us

Orlando, Florida, Us

• Built Risk and Underwriting Automation tools through Python with the help of Streamlit, Pandas, redshift connector, and Seaborn Libraries. These tools saved our Risk Analysts hours by automating spreadsheet calculations, combining multiple spreadsheets, formatting, and searching for specific data.• Created visual and tabular dashboards for underwriting and risk monitoring through Looker Studio and DBT Cloud. • Wrote complicated SQL queries in Mode/Redshift that involve 20+ tables, rank functions, sub queries, and common table expressions.• Helped refine Periodic review requirements throughout the merchant portfolio to reduce risk. • Pulled data and created presentations for Executive Leadership based on metrics for Risk and Underwriting teams. These include: chargebacks, refunds, transactions, stale rate, pend/approval/decline rates• Developed an Internal Risk and Underwriting tool that takes input from a calculator and feeds the data into our Redshift DB. This was achieved by utilizing the redshift SQL connector. From there created reports to give to managers. In the past, this was two spreadsheets and no data was captured• Created new internal database tables to store merchant profile groups and internal underwriting stats

This is my data YouTube channel where I can showcase my skills in SQL and Python. I publish 2 to 3 videos each week as I learn more about Machine Learning, Deep Learning, and LLMs.15k Subscribers

• Wrote Spotting Fakes: A book on teaching card collectors how to spot fake sports cards (1,000+ Copies sold)• Travel across the country to Buy/Sell/Trade at sports card shows. • Run a 10,000 subscriber YouTube channel which includes editing/filming videos, and creating graphics.• Run Social media accounts: Instagram & Twitter which both have over 8,000 followers• Built Wordpress Website and Optimized it for SEO. Has 5,000+ visitors a month

Lathrop, California, Us

• Built out a brand-new software pricing model based off market research and data analysis.• Created a standard process for giving discounts to larger customers.• Optimized and converted inline SQL to Stored procedures within SQL Management Studio.• Wrote code and built out reporting for customers, executives, and internal team members through MSSQL, Visual Studio, and Power BI.• Manipulate and process qualitative and quantitative data in SQL, Excel, and Power BI for executive team members and accounting to visualize tax return numbers and customer data.• Grabbed return datasets through relational databases for IRS summons.• Taught Junior Data Analyst and Accounting team members MSSQL.• Updated SQL tables, audited accounting & reporting data for accuracy• Built complex tax logic driven queries in SQL using joins, subqueries, and unions.