Analyst

RICHARD B. RAYNOR

PROFESSIONAL SUMMARY

IT Professional experienced in Data, Business, Quality Analytics, and Auditing across multi-disciplinary areas, including financial, operational, compliance, capital project & IT audits. Experienced in SOX 404 testing, Contract Management, General Ledger Accounting, Budget Analysis, and Financial Statement preparation. Experienced in AML/ATF transaction monitoring & investigations. BRD and FSD of BSA regulatory compliance matters for financial institutions, including required documentation for client onboarding & screening.

Expert with MS Excel spreadsheets, graphs, charts, pivot tables, VLOOKUP’s, macros, Visual Basic & SQL Queries. Strong interpersonal, communication, and organizational skills; prepare technical reports and presentations. Detail-oriented, accustomed to handling multiple tasks, and an effective team leader.

PROFESSIONAL EXPERIENCE

VWR / AVANTOR SCIENCES, Radnor, PA July 2018 – August 2025

Product Master Data Analyst

Coordinated requirements from vendors/suppliers, Marketing/Product managers, sales support teams, warehouses, and other internal departments regarding product information and pricing.

Researched and audited product and supplier data within VWR systems, requiring modifications to and communication of results to other functional teams within the organization.

Assumed ownership and responsibility for data accuracy, completeness, consistency, and integrity of product and supplier master data fields.

Worked with large amounts of data and utilized multiple systems to research, audit, and analyze information.

Maintained accurate tracking of open and closed requests to ensure smooth workflow and accurate reporting.

Performed regular quality audits to maintain data integrity.

Product Add Forms – interacts with VWR marketing, supply chain, pricing, and regulatory teams, along with contacts at suppliers to shepherd and complete the product add process. Apply proper coding where needed.

Product maintenance – works with other functional teams on the discontinuation and attribute changes of products, including description changes, warehouse ties, internal coding, etc., to maintain current and accurate information.

Product pricing – works with marketing, pricing, sourcing, and purchasing teams to maintain accurate supplier pricing in the system.

Regularly audited, researched, analyzed, made modifications, and communicated about the above tasks.

Developed and maintained strong relationships with other functional teams and have regular interactions regarding product and supplier issues.

Performed other duties as assigned.

CONSULTANT January 2010 – February 2018

Client: Lowes Corporate Headquarters, Mooresville, NC (August 2017 – February 2018)

Quality Analyst / Business Data Analyst (Contractor)

Assisted in the conversion of the store planning system by evaluating the quality results of the store planning system before conversion to ensure all planograms are accurate and executable at the store level.

Obtained and documented business requirements by working with the Planogram Specialist / Visual Space Planner and stakeholders to understand their needs

Wrote and executed test cases, test scripts, data sets, and user procedures. Ensured testing results corresponded to Business and Functional Requirements.

Obtained all information necessary to enable planogram mapping system production to create and manage planograms at the store level using Space Planning Software

Generate test status report (execution results) within HP ALM/Quality Center and manage triage meeting with BA, Dev, and Managers

Performed extensive Functionality testing and Regression testing of Quotes, New Business, and Policies by adding coverages, Limits, sub-limits, and deductibles against created policies.

Created all planograms assigned to planogram standards, including items, fixtures, displays, signage, graphics, and special instructions, and ensured planograms are submitted for approval on the assigned date to enable the reset schedule timeline

Client: Wells Fargo Charlotte, NC (February 2017 – July 2017)

Quality Analyst (Contractor)

Performed QA Validation of Capital Investment Customer profiles for compliance with the Bank’s AML policy.

Modified Customer CIP/CDD Standards and related Procedures for adherence to the AML policies and regulations.

Created test plans and test cases based on requirements.

Analyzed & gathered business requirements, software requirements, functional specifications, and design documents to create Test Plan and Test Cases.

Designed manual test cases and converted them into an automated suite using SOAPUI

Conferred with line of business managers & analysts to assure customer documentation process is effectively performed.

Client: Bank of America Charlotte, NC (November 2016 – January 2017)

Business Analyst (Contractor)

Researched and analyzed information on existing customers who have been alerted and escalated as prohibited entities. Based on research, provided determination as to whether the entity was operating in prohibited activities and, as needed, confirmed for closure or recommended transfer to an alternative line of business.

Client: Wells Fargo Charlotte, NC (May 2016 – November 2016)

Business Analyst / Quality Analyst (Contractor)

Support audit activities for Wholesale Banking, which included: Capital Markets, Commercial Real Estate Lending, Corporate and Commercial Banking, Insurance, Structured and Asset-Based Lending & Servicing, and Asset Management

Assisted in the design of audit coverage and executed and/or led audit testing where necessary.

Understanding Software Requirement Specification and identifying the required Test Scenarios for the Projects.

Participated in many different projects simultaneously while also engaging in emerging risk/business monitoring.

Audited execution with a focus on audits where processes may rely heavily on application technology controls.

Provided risk assessment and, specifically, risk assessment for trading and securitization risks.

Designed and/or applied data analysis audit techniques.

Profound experience in developing, implementing, and executing test plans, test cases, and test scenarios manually.

Coordinated with other internal audit teams, including technology audit and data analysis audit team members.

Effectively documented risk assessment and audit execution in accordance with audit policy.

Identified emerging risks and recommended adjustments to audit coverage.

Identified financial processes and internal controls that are required for compliance with the Sarbanes-Oxley Act (SOX).

Client: Bank of America, Charlotte, NC (March 2016 – May 2016)

Testing Specialist (Contractor)

Client: M&T Bank, Wilmington, DE (March 2015 – March 2016)

BSA Compliance Analyst / Test Analyst (Contractor)

Client: Citibank, New Castle, DE (May 2014 – March 2015)

AML Senior Compliance Analyst (Contractor)

Client: KPMG / JP Morgan Chase, Newark, DE (November 2013 – April 2014)

QA Lead (Contractor)

Client: American Water Service Company, Cherry Hill, NJ (January 2013 – November 2013)

Accountant (Contractor)

Client: HSBC Bank, New Castle, DE (November 2011 – June 2012)

AML Compliance Officer (Contractor)

Client: Next Era Energy (Florida Power & Light), Juno Beach, FL (May 2011 – September 2011)

Accountant (Contractor)

Client: Palm Beach Clerk & Comptroller’s Office, West Palm Beach, FL (September 2010 – May 2011)

Auditor/Accountant (Contractor)

Client: U.S. Census Bureau, Green Acers, FL (January 2010 – September 2010)

Field Operations Supervisor (Temporary)

EDUCATION

B.S. Accounting, Pennsylvania State University, State College, PA

SKILLS SUMMARY

Microsoft Office (Excel/Access/Word/Outlook/PowerPoint), SQL, and Visio flowcharting program. SAP, PeopleSoft, QuickBooks, SAP, HP-ALM, QTP/UFT MAS, Hyperion, J.D. Edwards, & Peachtree Accounting Systems. Paychex & ADP Payroll Systems. SharePoint, Mantis, Actimize, WorldCheck, LexisNexis & Thomson Reuters Clear systems for financial services.

Contact this candidate