Data Governance Test Automation

Wellington Nyamangwanda

**** **** ** *** ***, Bristol, PA, 19007

267-***-**** *******@*****.***

PROFESSIONAL SUMMARY

Results-driven UAT Analyst with extensive experience in User Acceptance Testing (UAT), data governance, Collibra, test automation, and process optimization. Adept at identifying system flaws, ensuring compliance, and enhancing software quality through meticulous test planning, execution, and defect tracking. Proficient in SQL, Excel (PivotTables, VLOOKUP, Power Query), Tableau, JIRA, and Collibra to drive data governance and optimize testing strategies. Strong communicator with a proven ability to collaborate with cross-functional teams and stakeholders to deliver high-quality business solutions.

CORE COMPETENCIES

Collibra Data Governance – Managing metadata, data dictionaries, and business glossaries.

UAT & Regression Testing – Developing, executing, and documenting test cases to ensure software functionality and compliance.

Test Automation & Defect Tracking – Leveraging SQL queries and automation tools to enhance testing efficiency.

Data Governance & Compliance – Ensuring data accuracy, integrity, and compliance with corporate and regulatory policies.

SQL Querying & Database Management – Extracting, analyzing, and validating large datasets for testing purposes.

JIRA & Agile Methodologies – Tracking defects, managing test cases, and collaborating in Agile development environments.

Business Intelligence & Reporting – Utilizing Excel (PivotTables, VLOOKUP, Power Query), Tableau, and QlikSense for data visualization and reporting.

Advanced Excel Skills – Performing data validation, trend analysis, and report automation to support decision-making.

PROFESSIONAL EXPERIENCE

JPMorgan Chase, Newark, DE

UAT Analyst – Corporate Finance & Data Governance July 2016 – June 2020

Led Collibra integration efforts, managing metadata uploads, ensuring data governance compliance, and enhancing data lineage tracking.

Developed and executed UAT test cases for Collibra workflows, ensuring proper role-based access controls and policy adherence.

Performed data stewardship activities, validating data dictionaries, business glossaries, and data classifications within Collibra.

Conducted data profiling and metadata management using SQL to support Collibra’s data governance framework.

Utilized JIRA for tracking Collibra-related defects and enhancements, ensuring seamless system implementations.

Automated metadata ingestion processes into Collibra using SQL and bulk data upload tools, reducing manual data entry errors.

Supported data governance initiatives by aligning Collibra policies with corporate compliance standards.

Led UAT efforts for corporate finance applications, developing test plans, executing test cases, and documenting results.

Automated test processes using SQL Stored Procedures, reducing manual workload by 70%.

Utilized Excel (Power Query & Data Validation) to support data analysis and reporting.

Senior Tax Analyst October 2014 – July 2016

Validated tax forms (W9, W8BEN, etc.), ensuring compliance with FATCA regulations.

Analyzed financial data for tax reporting and provided recommendations for process improvements.

Coordinated with AML/KYC teams to ensure regulatory compliance in financial data management.

State of Delaware, Wilmington, DE

Data Analyst January 2022 – July 2022

Conducted data analysis and reporting, providing key insights to drive efficiency improvements.

Developed SQL-based narratives and statistical reports for operational decision-making.

Created Excel-based dashboards for data visualization and streamlined reporting.

Manpower/Estee Lauder, Bristol, PA

Data Logistics Specialist October 2022 – Present

Ensured accurate inventory movement and data entry, supporting warehouse management systems for logistics optimization.

Collaborated with cross-functional teams to identify process inefficiencies and implement improvements.

Utilized Excel functions (VLOOKUP, PivotTables) to track inventory trends and improve data accuracy.

SEI Investments, Oaks, PA

Financial Tax Analyst August 2012 – October 2014

Conducted cost basis analysis for corporate actions to ensure tax reporting accuracy.

Automated reporting and data validation using SQL and Excel, improving efficiency.

EDUCATION

University of North Texas, Denton, TX

Bachelor of Applied Arts in Business Administration

Major: General Business Minor: Management

TECHNICAL SKILLS

Databases & SQL – SQL Server, MySQL, PostgreSQL

Testing Tools – JIRA, Selenium, HP ALM, TestRail

Data Analytics & Visualization – Excel (PivotTables, VLOOKUP, Power Query, Conditional Formatting), Tableau, QlikSense

Automation & Scripting – SQL Stored Procedures, Python (Basic)

Project Management – Agile (Scrum & Kanban), Waterfall

Contact this candidate