Data Quality Analyst

REGINALD W. REBB

**** *. ******** ***.

Oak Park, IL 60302

Mobile: 312-***-****

******@*****.***

PROFESSIONAL PROFILE

Experienced Data Analyst with a background in managing and analyzing data across various ERP systems, creating/maintaining Excel reports utilizing SQL to perform data quality checks, and collaborating with cross-functional teams to identify gaps in data. Seeking a challenging role in a dynamic organization where I can leverage my skills to drive impactful results.

PROFESSIONAL EXPERIENCE

American Red Cross, (APN Software Services, Newark, CA)

Data Quality Analyst, January 2024 – May 2024

Contractor

oDevelop, document, and maintain data quality goals

oMonitor compliance of data flows against data quality standards

oResolve data quality issues through error detection and correction test procedures

oReview root-cause analysis associated with data integrity issues

oImplement best practices and procedures

oPerform data quality edits and validations to be built into interfaces and systems

oOrganize, direct, manage, and control activities for assigned data quality projects

oFacilitate deep dive sessions regarding common data challenges and trends

Antylia Scientific, Vernon Hills, IL

Data Quality Analyst, August ’16 – May ‘23

oCreate and maintain Excel reports utilizing SQL to perform data quality checks

oAdminister data loads and maintenance of data

oPartner with international sales team to help guide and assist in customer performance, forecasting and rebate eligibility

oCollaborate with business partners to identify gaps in data

oTrain international peers on roles and responsibilities

oDevelop and introduce streamlined processes for saving time in validating and cleaning data

oAdministrator for the Customer Information Management (CIM) database

oMonitoring customer data submissions via AS400 to identify data quality

oReview Quality Control procedures to identify errors in workflow

oValidate logic of customer data to ensure that proper entry standards are followed, correcting records to conform to the standard.

Urban Partnership Bank, Chicago, IL

Business/Operations Analyst, July ’15 – June ‘16

Contractor

oCreate spreadsheets, pivot tables, reports, and dashboard from the data extraction of CRM banking systems (Fiserv, Director and Navigator)

oResponsible for validating good data and purging invalid/bad data. Collect user requirements and conduct project status meetings to ensure project deliverables are met.

oExtensive data cleansing and analysis, using pivot tables, charts, formulas (v-lookups/slicers and macros), data validation, conditional formatting, and graph and chart manipulation.

oCreated and developed a database in Access to be used as a quick reference tool for customer service to provide New Servicer contact information to the Borrower(s) of loan(s) sold in the Loss Share Note Sale Project.

oAnalyzing data to help upper management make critical discussion on their strategic processes for the note sale project.

oDevelopment of project plan, assigning resources to task, tracking progress, and analyzing the workload via MS Project.

oAttend weekly meetings with vendors on the note sale initiative and gathering minutes from those meetings to evaluate progression.

oSteering Committee, Documentation, and Deal Executives on a weekly basis.

oProvide project management and status reporting to the Steering Committee, A&R, Board, and Regulators

oProvide all FiServ data required for a successful bid

Bank of America, Chicago, IL

Operations Specialist III, Jan’15 – July ‘15

Contractor

oTrack and control the safekeeping of physical securities, letters of credit and other valued assets for GCAS and Collateral Groups which result in organized professional records reflecting current holdings for clients.

oSupport domestic and international trade and cash settlement, safekeeping of assets and documents, collection of income (e.g., dividends, interest payments), processing of corporate actions, pledging of securities to third parties, cash payments via SWIFT, and wire and check processing.

oProvide Custody support, which can include registrar/transfer agent services, payment services, and client inquiry/reporting services.

oReceive free receive and deliver instructions and post into Global Plus (proprietary software)

oTransfer securities between existing portfolios

oProcess all vault deposits and withdrawals to GCSO vault; as well as all vault deposits and withdrawals to DTCC vault

JP Morgan Chase, Chicago, IL

Migration Data\Transmission Analyst, Mar. ’11 – Aug. ‘13

Contractor

oDrafted effective and thorough system tests with customers

oGathered data, requirements and tested new requests from customers (such as changes to the profile before and after they go live in production).

oNegotiated quality criteria with customers and clarified use cases for test production environment

oProvided quality check of the customer supplemental setups before going live.

oFocused on day-to-day batch operation tasks and deliverables within R1 (RemitOne) implementation batch processing.

oDeveloped and executed test scenarios to ensure all customers’ requirements were tested including creating formats, test batches which includes different test scenarios, sort patterns and apply custom codes to the customer profile setup (edits, exits) if required.

oPerformed quality assurance audits to the customer profile setup, format, and test file and test scenarios for any discrepancies to find source of error.

oPerformed system testing for new supplemental setups and system production changes

oPerformed system configurations of bank lockboxes to ensure that all data within the lockboxes are transformed accurately and according to business rules and/or specifications.

oDocumented test results and evaluated results to determine defects

oGain awareness of system application and validate requirements against user expectations

oAnalyzed and resolved moderately to complex issues specific to the batch processes that support the clients processing stream.

oSupport developers to design testable code through verification and recommendations

oTroubleshoot and implemented end-to-end test resolutions for quality assurance

oMigrated bank lockboxes from Cash Management Solution (CMS) to R1 (RemitOne) environment after end-to-end testing has been performed, the customers’ data and image files has been reviewed and approved by the customer.

IBM/SPSS, Willis Tower, Chicago, IL

Marketing Asset Manager, Sept. ’10 – Dec. ‘10

Contractor

Provide administrative and database management services to IBM/SPSS in order to manage and catalog marketing collateral assets (e.g. brochures, product spec sheets, datasheets, and white papers).

oManaged workflow of output from Creative Team into a variety of internal document repositories.

oMaintained catalogue spreadsheet of assets, document code numbers and URLs

oGained proficiency in Lotus Symphony as well as a variety of internal, proprietary enablement systems.

Federal Home Loan Bank of Chicago, IL Jun. ’10 – Jul. ‘10

Administrator

Contractor

oContact members of the housing finance institution to review application for loan.

oDisburse funds to members.

RSM McGladrey, Inc., Schaumburg, IL

Report Processing Specialist, Nov. ‘09 – Apr. ‘10

Contractor

Primary responsibilities include the production of financial reports for all Chicagoland locations.

oPrepared correspondence

oProofread documents and financial statements for grammatical and statistical errors

oCross checked numbers between financial statements

oCopied and bind folders for distribution

Fifth Third Bank, Chicago, IL

Jr. Financial Analyst, May ‘05 – Mar. ‘09

Perform finance activities for Investment Advisors (Wealth Management) Division for Fifth Third Bank Chicago, reporting to Divisional CFO. Provide support to the following four business lines within Investment Advisors: Private Banking; Private Client; Institutional Client and Securities. Responsibilities include:

oProgrammed and prepared monthly scorecards using Excel (Input formulas into Excel to assist the CFO in managing the production of the Sales and Investment teams; these reports were done on a weekly, biweekly and monthly basis-using a percent to goal ratio.)

oExtensive Excel work using pivot tables and complex formulas to manipulate large data structures.

oUse of Excel to manipulate large amounts of data in order to perform data analysis, and preparation of a broad range of reports.

oPrepared monthly financial reports and supporting analysis, including graphs, and created graphs to support the monthly scorecards.

EDUCATION

MS in Information Systems, DePaul University, Chicago, IL

Graduated: June ‘08

BS in Applied Science, Robert Morris College, Chicago, IL

Graduated: June ‘05

TECHNICAL SKILLS

oProgramming Languages: HTML, SQL

oSoftware: MS Office (Access, Excel, Outlook, PowerPoint, SharePoint), Navigator, Director

oDatabase: Access, SQL

oAdobe Photoshop, Macromedia Dreamweaver, Flash

oQlik Sense

oShowcase

oAS400

TECHNOLOGY TRAINING

Directions Training: January 2014 – November 2014

2625 Butterfield Road. Oak Brook, IL 60523

Microsoft Windows Server 2008/2012

oMaintaining a Microsoft SQL 2008 R2 Database

oBusiness Analysis

oQuerying Microsoft SQL Server 2012

Related Coursework:

oCreated business application through real-world case scenarios and practice exercised, including gathering application requirements.

oDevelopment tools

oDatabase design

oApplication structure

oQuery design

Contact this candidate