John Ratcliff
Vice President - SOX & Controls - Data Transfer, Integration & Quality @ BNY
About
Manager and Data Analyst with deep background in the banking industry and skills from certificate in data analytics from Case Western Reserve University. Extensive background partnering with business, leadership, and staff to define needs, evaluate risks, and implement solutions to enhance business operations. Experienced in advanced Excel, VBA, SQL, data mining, analytics, and data visualizations. Skilled in Python, Pandas, Matplotlib, R, JavaScript, D3, Plotly, SQL Alchemy, web scraping, Leaflet.js, PySpark, GeoJSON, and Tableau. Critical thinker and problem solver with history of success presenting to executives and driving collaboration across diverse organizations. Enjoys using data to gain insights and help drive informed decisions and competitive growth.
United States
Greater Cleveland
Information Technology & Services
Alteryx, Test Automation, Java, Market Risk, Data Visualization, SQL, Tableau, Python (Programming Language), Microsoft Excel, Data Analysis, Critical Thinking, Data Science, Data Mining, Machine Learning, Collaborative Problem Solving, R (Programming Language), Business Analytics, Agile Methodologies, Reporting & Analysis, Microsoft Word
Experience
Vice President - SOX & Controls - Data Transfer, Integration & Quality
BNY
Cleveland, Ohio, United States
* Conduct testing of controls, compliance, and data integrity using innovative tools and testing techniques * Identify issues and communicate/consult with various levels of management to ensure corrective actions address root causes
Lead Analyst - SOX Compliance and Controls
BNY
Cleveland, Ohio, United States
* Conduct testing of controls, compliance, and data integrity using innovative tools and testing techniques * Identify issues and communicate/consult with various levels of management to ensure corrective actions address root causes * Provide technical advice/guidance to less experienced Control and Compliance roles as needed
Marketing Director
Uncle Scotty's Favorites
Lebanon, Ohio, United States
Event planning, financial advisor, and senior baker. • Planned and helped successfully manage inaugural concession sales for Polar Express train • Generated over $100k in total sales revenue in the first year over six holiday weeks
Loan Operations Support Analyst
Third Federal
Cleveland, Ohio, United States
Business Analyst supporting mortgage loan origination system with focus on Underwriting department. • Conducted process discovery and documentation of systems utilization for eight departments • Collaborated with team of 10 Business Analysts to support origination system of $14.5B bank
Director of Client Support
PowerSeller Solutions LLC
Managed Client Support team providing hedging software solutions to financial institutions. • Managed a four-person team to support sixty bank, credit union, and state housing agency clients • Performed historical fallout and regression analysis for 20 clients utilizing SQL, Excel, and VBA
Secondary Marketing Manager
Colorado Housing and Finance Authority
Denver, Colorado, United States
Managed Secondary Marketing department with five employees. • Expanded reporting with six new risk reports utilizing SQL, Excel, VBA, and Tableau • Staged eight quarterly servicing tape valuation analyses and presented to Board
Senior Secondary Marketing Analyst
State Farm Bank, F.S.B.
Bloomington, Illinois, United States
Mortgage Backed Securities Trader utilizing Quantitative Risk Management software to hedge and deliver mortgage loans. • Analyzed $750M mortgage pipeline, created reports, and presented quarterly to ALCO Committee • Completed historical fallout and regression analysis resulting in 10 bps increase in profit margins
Vice President Secondary Marketing and Capital Markets
Peoples National Bank
Colorado Springs, Colorado, United States
• Directed three departments with ten employees to price and deliver mortgage loans to agencies • Developed and built five risk management reports for Senior Management and Board
Secondary Marketing Manager
Residential Wholesale Mortgage, Inc.
San Diego, California, United States
• Centralized lock function of 30+ loan originators to corporate office to reduce risk and costs • Authored and implemented new risk management policies, procedures, and reporting
Vice President Hedging and Analytics
W.J. Bradley Mortgage Capital, LLC
Denver, Colorado, United States
• Effected successful implementation of Compass Analytics software platform in four months • Hedged and delivered mortgage pipeline with a $1M increase in annual profit margin
Senior Vice President Secondary Marketing
Aurora Loan Services
Denver, Colorado, United States
• Managed 25 employees in Analytics, Lock Desk, and Loan Delivery departments • Mortgage pipeline analysis and reporting to Mortgage Trading Desk
Education
Case Western Reserve University
Data Analytics
Data Analytics Bootcamp where I learned and utilized intermediate Excel, Python programming, JavaScript charting, HTML5/CSS, API interactions, PostgreSQL/pgAdmin, Tableau, fundamental statistics, machine learning, R, Git/GitHub and more.
Hiram College
Economics
John Ratcliff's Contact Information
Phone
Find the Right Leads
Find Verified Contact Data
What LeadContact does well
Find verified emails, phone numbers, and decision-makers with 98% accuracy.
Find Leads
Find the right people by company, role, industry, location, and more.
925M+ professional profiles
Find Emails
Access verified email addresses for your target contacts.
657M+ emails
Find Phone Numbers
Get cross-validated phone data from multiple top sources.
239M+ phone numbers
More Accurate. Lower Cost.
Find contact data in 1 tool with 98% accuracy
LeadContact integrates leading enrichment tools to deliver more accurate contact data—without paying for each one.
Great conversations start with the right contact.
It’s time to find yours.