Verified
This profile is verified using an email address.
Ron Newkirk
Hendersonville
Summary
Seasoned professional in Risk and Compliance for Information Technology, specializing in data mapping and quality assurance. Led strategic initiatives that enhanced data integrity and streamlined business testing controls, ensuring compliance with regulatory standards.
Overview
32
32
years of professional experience
Work History
Lead Data Product Management Consultant
Wells-Fargo Bank
Hendersonville
03.2018 - 12.2025
- Analyzed data discrepancies against specifications to identify and resolve data quality issues.
- Developed business rules and data quality rules in Ab Initio to ensure accurate data elements.
- Conducted functional testing for ETL tool conversion to validate data integrity and performance.
OFSAAI Consultant
Hamilton-Ryker IT Solutions
Birmingham
06.2017 - 03.2018
- Executed business testing as Financial Services Data Foundation Solution SME, focusing on ELEMENTS attributes for Lombard Regulatory Reporting and GL Reconciliation applications.
- Designed and configured Data Quality Rules for version 8.0.4, targeting Critical Data Elements to ensure compliance and accuracy.
- Data mapping from client’s source systems in focus to the FSD Product Processors.
- Collaborated with Regions Bank to refine and optimize financial service solutions, enhancing overall client satisfaction.
OFSAAI Consultant
Cognizant Technology Solutions
05.2016 - 03.2017
- Conducted pre-sales activities and early assessments with prospective clients to identify needs and expectations, facilitating tailored solutions.
- Developed data acquisition plans and implementation schedules for data mapping exercises, ensuring alignment with client objectives and timelines.
- Created customized IT solutions to address various client requirements.
- Performed detailed evaluations to clarify client needs and expectations.
- Worked alongside diverse teams to effectively execute project plans.
Lead Consultant - OFSSAI
TATA Consultancy Services (TCS)
06.2014 - 01.2016
- Led multiple client engagements to identify and acquire data from disparate source systems, emphasizing reduction of data redundancy and enhancement of data quality through reusable extract/load/transformation methodologies, resulting in a common data lake.
- The result was a consolidated, reliable and validated target environment which established a single source of data for many lines of business uses, including but not limited to tax compliance, GL reconciliation, asset liability management, and profitability.
- Enabled enterprise-level access to reconciled, verifiable data from the data lake for production reporting initiatives, supporting compliance with monthly and annual regulatory and management reporting requirements.
OFSAAI Managing Consultant
Rolta Americas
10.2013 - 06.2014
- Lead consultant and SME for design and documentation of both development and production implementation of Oracle Balance Sheet Planning (BSP) including Profitability (PFT) and Funds Transfer Pricing (FTP) application modules.
- Identified and acquired detailed data from multiple source systems across various lines of business to enhance data quality and support a data model upgrade effort.
- Trained consultants and client resources while configuring an 'In-House' lab environment for training and demonstration with simulated data and business rules that mirror real-world scenarios.
OFSAA Consultant
eCommQuest/The Hackett Group/Hancock Whitney Bank
03.2013 - 09.2013
- Developed and maintained ETL structures (T2Ts) and designed allocation rules for Oracle application, ensuring robust data flow and compliance.
- Delivered data into the Oracle Staging Environment and conducted configuration and unit testing of custom allocation rules in the DEV environment for accuracy.
- Conducted detailed analysis of source system data, performed unit testing in development (DEV) environment, established change control process for migration to testing environment, and facilitated promotion into production.
- Collaborated with project DBA to resolve system performance and configuration issues, managed migration efforts, and documented full deployment plan and run book for client reference.
Sr. Business Analyst
DataScan Technologies
10.2012 - 02.2013
- Led implementation of enhancement requests by identifying and documenting requirements based on client needs across multiple platforms containing Floor Plan Loan details.
- Conducted in-depth research into internal enhancements, developed mock-ups for Crystal Reporting solution, and negotiated layout and content with clients.
- Served as team SME for general ledger process, specializing in non-accrual transactions, leveraging finance background and expertise.
Business Intelligence Analyst
TEKSystems/Stein Mart
12.2011 - 08.2012
- Oversaw and managed process methodology development for Purchase Order and Pricing of Business Intelligence deliverables within Microsoft environment, collaborating daily with developers and stakeholders throughout iterative delivery methodology.
- Authored design documents and developed testing strategies, conducted training sessions to clarify processes and simplify SQL results validation, and advised ETL group on necessary data anomaly remediation.
- Collaborated with project team as SME during credit card processor change project implementation, focusing on data acquisition and mapping strategies to fulfill Stein Mart expectations.
System/Business Analyst/OFSAAI
Experis Finance IT Consulting/Ally Bank
10.2010 - 12.2011
- Specific focus on installation and stand-up of the OFSAAI solution, including creation of detailed documentation for data requirements, business requirements and business intelligence.
- Led design sessions with developers and business stakeholders to establish detailed requirements and foster ongoing collaboration for Basel regulatory reporting using OFSAA/Reveleus solution.
- Technical implementation lead assigned to multiple financial clients, responsible for process design and development based on business requirements and data delivered.
- Reviewed and designed SQL logic based on requirements and expected results, translated business requirements into system requirements, supported developers, and developed non-functional requirements while collaborating with security layer to meet enterprise standards.
- Led team of professionals responsible for personnel and resource allocation, design of the expected structure of the OFSAA/Reveleus Sustaining Operations team, and creation/tracking of the project schedule and system integration plan.
- Directed Source to Target mapping exercises with SMEs from each source system, maintained thorough documentation and versioning in SharePoint.
- Conducted review assessment of federally mandated rules to ensure the project was in line with documented Basel requirements and participated with the integration layer to confirm delivery of expected data.
Sr. Business Analyst
SunTrust Banks, Inc
02.2006 - 10.2010
- Designed detailed business and technical requirements for the 'Qualifying Capital Calculation' in the Basel II final rule.
- Served as BA on Development team in Finance Risk, translating business requirements into technical requirements for developers during OFSAAI solution configuration.
- Acquired data from source cubes and delivered Excel workbooks as BA on the Enterprise Data Warehouse (EDW) Team, migrating reporting from TM1 tool to relational data stores for executive management intelligence.
- Participated in testing activities, gathered requirements with stakeholders, designed business intelligence, migrated code, managed document versioning control, and vetted change control requests to assign to developers.
- Initially engaged as a Reporting Analyst in the Risk Information Delivery process, with a subsequent move into the Finance Risk Department where I was assigned to stand-up of infrastructure and deliver the OFSAAI (Reveleus) application suite.
Sr. Business /Operations Analyst/Investigator
GE Consumer Finance
09.1993 - 02.2006
- Promoted to lead business analyst for major clients in the charge-back and write-off process, leading the development of custom reporting strategies based on client requirements.
- Managed client reporting needs for Portfolio Application Conversion Team, collaborating with client's SMEs to develop business intelligence and overseeing off-shore developers in delivering artifacts for testing.
- Led technical efforts in Credit Card Authorizations Operation and Fraud Detection Team, reviewing credit card applications for inconsistencies against personal details to enhance application accuracy.
- I conducted client on-site training related to the reporting tools created, back-office processes and was present on-site during all go live activities.
Education
High School -
Bethel-Tate High School
Bethel, OH05-1978
Skills
- ETL processes
- SQL programming
- Data analysis and profiling
- Business intelligence
- Data governance
- Testing and quality assurance
- Agile methodologies
- JIRA project management
- SDLC principles
Timeline
Lead Data Product Management Consultant
Wells-Fargo Bank
03.2018 - 12.2025
OFSAAI Consultant
Hamilton-Ryker IT Solutions
06.2017 - 03.2018
OFSAAI Consultant
Cognizant Technology Solutions
05.2016 - 03.2017
Lead Consultant - OFSSAI
TATA Consultancy Services (TCS)
06.2014 - 01.2016
OFSAAI Managing Consultant
Rolta Americas
10.2013 - 06.2014
OFSAA Consultant
eCommQuest/The Hackett Group/Hancock Whitney Bank
03.2013 - 09.2013
Sr. Business Analyst
DataScan Technologies
10.2012 - 02.2013
Business Intelligence Analyst
TEKSystems/Stein Mart
12.2011 - 08.2012
System/Business Analyst/OFSAAI
Experis Finance IT Consulting/Ally Bank
10.2010 - 12.2011
Sr. Business Analyst
SunTrust Banks, Inc
02.2006 - 10.2010
Sr. Business /Operations Analyst/Investigator
GE Consumer Finance
09.1993 - 02.2006
High School -
Bethel-Tate High School