Thomas Sloan
Sr. Data Quality And Governance Analyst
Macon,MO
Summary
I am a Detail-oriented Data Quality Analyst adept at performing data analysis and recognizing key problem areas to assist in root cause identification. Exceptionally talented at auditing data on regular basis to provide data integrity and quality. My 12+ year career in data has incorporated everything from data analysis, data stewardship, development, testing, and management to create a holistic view of all aspects of data management.
Overview
12
12
years of professional experience
Work History
Sr. Data Quality and Governance Analyst
JLL
Macon, MO
05.2020 - Current
- Determined root cause of data quality errors and recommended long-term solutions.
- Collaborated with business analysts and software development team to identify and convert business goals into data requirements.
- Developed and executed data cleanup measures.
- Implemented business intelligence solutions to increase operational efficiency.
- Capture, store, protect, and ensure the integrity of data assets.
- Continually improve the quality of data and information.
- Ensure privacy and confidentiality and prevent unauthorized or inappropriate use of data and information.
- Maximize effective use and value of data and information assets.
- Develop and refinement of Data Governance Framework and integration into the Software Development Life Cycle Framework.
- Worked with stakeholders on the creation a RACI document to identify accountable workstreams and reviewed with accountable workstreams.
- Created a pilot program to utilize a detailed checklist and confirm the Data Governance principles are being followed in the software development processes.
Software Development P2
JLL
Macon, MO
08.2017 - 03.2020
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
- Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
- Revised, modularized and updated old code bases to modern development standards, reducing operating costs, and improving functionality.
- Create and maintain global address cleansing ETL.
- Work directly with admin team to troubleshoot and fix any system performance issues.
- Create and maintain automated ETLs to bring source systems into mastered database.
- Create and maintain stored procedures used in ETL and backend processing.
- Provide Guidance and opinions on business plans created for new projects involving the master database.
Data Steward
JLL
Macon, MO
08.2014 - 08.2017
- Established and managed key performance indicators to measure and improve processes, systems and data.
- Developed and maintained product data dictionary to document data source, ownership and accountability details.
- Helped plan and create Property, Company, and Customer master database schemas.
- Created and managed business rules to identify data inconsistencies
- Created and maintained reference tables used in ETL to automatically clean up data entering system.
- Created business requirements and guidelines for data quality and format.
- Generated ADHOC reports to help drive business decisions.
- Created and documented new processes to establish stewarding standards.
- Assisted with hiring of new stewards.
- Trained and mentored all new stewards hired.
- Created and ran weekly data reports to find data inconsistencies that need corrected.
- Worked with stewards to constantly improve UI to make stewardship easier.
- Assisted and provided guidance to source systems on how to property integrate with MDM web services.
- Troubleshooted and fixed bugs found in steward UI.
QA Tester
Mastercard Worldwide
Macon, MO
03.2013 - 09.2013
- Review and approve requirement documents or applications.
- Create test suites using requirements information.
- Execute test suites to check application front end and backend database accuracy.
- Create bug reports and follow up with developers on fixes.
- Create stats for weekly progress meetings.
Data Analyst
Mastercard Worldwide
Macon, MO
03.2011 - 07.2014
- Reviewed, Maintained, and Aggregated merchant information into group sets.
- Maintain personal and business level reward cards by set criteria.
- Worked directly with clients at different banks to ensure rewards program accuracy.
- Trained all new hires on how to perform daily tasks.
- Updated SQL package for application used to review rule sets before implementation to database.
- Used Unix shell scripts to implement SQL rule sets into database.
- Wrote SQL queries used to improve accuracy and cut time during aggregation.
- Create and monitor statistics for personal and team progress on a weekly and monthly basis.
- Location matching for data verification.
- Designed, Created, Tested, and Enhanced previous processes to cut time and effort, and eliminate human error.
Skills
Address Doctor
C#
Documentation
Informatica Administrator
Informatica Analyst
Informatica Data Quality
Informatica IDD
Informatica Power Center
Informatica Web Service Hub
Informatica Workflow Manager
Informatica Workflow Monitor
Jira
Microsoft Access
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
OKRs
KPIs
Putty
Quality Assurance
SoapUI
SQL
SQL Server Management Studio
Toad for Oracle
Tracking/Metrics
Unix
VBA
Data organization
Data analysis
Data Quality Monitoring
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Sr. Data Quality and Governance Analyst
JLL
05.2020 - Current
Software Development P2
JLL
08.2017 - 03.2020
Data Steward
JLL
08.2014 - 08.2017
QA Tester
Mastercard Worldwide
03.2013 - 09.2013
Data Analyst
Mastercard Worldwide
03.2011 - 07.2014