Sondra R Massey
Chenega
Cartersville
1
Language
1
Certification
17
years of professional experience
Senior Business Analyst – IT Consultant Organization specializing in data governance, MDM, and business reporting. Builds 11–20 Power BI dashboards per year, data dictionaries, and functional and technical design documents that align stakeholders on 51+ attributes, KPIs, and validation rules. Streamlines data quality work by building Microsoft Forms and Power Automate flows, automating Excel macros, standardizing multi-source data, and supporting testing for GDSN and platform migrations.
Work History
CLIA Compliance Analyst IV
1 Year 6 Months- Streamlined reporting processes for regulatory submissions, using Power Automate, enhancing accuracy and efficiency.
- Assisted in the preparation of reports for senior management utilizing Power BI dashboards
- Updated and created Excel spreadsheets with latest data to enhance strategic planning.
- Updated and created automated forms for data collection.
Senior Business Analyst – IT Consultant Organization
3 Years- Experience with MDM/Data Governance, Data Quality, DQ requirements and validations
- Experience with Stakeholders, end users, collaborations with multiple teams, organizing and running meetings
- Met with End Users to determine attributes, metrics and KPI’s required for creation of reports, charts and dashboards.
- Created functional and Technical Design Documentation for proposed projects.
- Implemented macros in Excel to streamline data quality requirements and validation processes, enhancing overall data integrity and efficiency.
- Utilized Power BI to design and develop client-facing dashboards and reports, integrating data from multiple systems to establish a single source of truth, enhancing data accuracy and reliability.
- Collaborated with stakeholders and end users to gather requirements and feedback.
- Determining current/obsolete values for attributes
- Developed functional and technical design documentation for proposed projects, ensuring clear project specifications and alignment with user needs.
- Collaborated with end users to define attributes, metrics, and KPIs for effective report, chart, and dashboard creation.
- Determine standardization of values represented in the same table multiple ways
- Using existing attribute fields to create standardized descriptions
- Created Data Dictionary
- Tableau reports migrated to new tool
Senior Data Analyst – Data Management Organization
11 Months- Determining current/obsolete values for attributes
- Determine relative attributes, deprecate obsolete attributes
- Determine survivability rules for same attribute that comes from multiple sources
- Determine standardization of values represented in the same table multiple ways
- Using existing attribute fields to create standardized descriptions
- Developed comprehensive data dictionary to standardize terminology and improve data accessibility.
- Part of Cross-functional Team tasked with designing a process to bring data from multiple systems into P360 then present business users with Master Item view in Power BI. This project included attribute mapping, data governance implementation, data completeness, product life cycle maintenance for attributes.
- Part of cross-functional team migrating old system data to Oracle during business transformation
- Part of Cross-functional team performing gap analysis of Master Data attributes currently needed and emerging markets.
- Integration of Informatica’s P360 to Power BI for more diverse visualizations.
- Utilized Power BI and Power Query for data modeling and transformation, optimizing data structures for efficient reporting and analysis.
- Created Functional and Technical Design Documentation for proposed projects.
- Created VBA coding/macros to identify attributes that did not match between existing country files; corrected mismatches for data alignment and initial load into P360; and to automate routine tasks such as data backup, archive management, and system maintenance, enhancing operational efficiency and reducing manual effort
- Processed business requests for item information.
- Implementation of P360 and GDSN (Global Data Synchronization Network) go-live for the Netherlands and Spain; data manipulation and clean-up of GDSN information. This included cleaning the GTIN-14 list.
- Cleaned and standardized complex data from multiple sources for consolidation.
- Implemented error handling routines within macros to identify and resolve data discrepancies during loading process, ensuring smoother operations.
- Performed or managed end-user testing pertaining to GDSN compliance and updates.
- Led discussions with End Users to determine attributes, metrics and KPI’s required for creation of reports.
- Data publication to GDSN
- Work with others testing P360 for our needs for publication and attribute content, validation rules for GDSN.
Customer Service Projects Team – Data Steward, MDM, Data Synchronization
3 Years 2 Months- Created and maintained reporting that rolled up companywide KPIs (shipping, returns, open orders, cancelled orders, etc.) and provided ability for further break down into specifics (each Distribution Center performance, Business Segment performance, Brick & Mortar versus e-Comm) by date (from year down to specific dates).
- Used software tools including Microsoft Excel, Word, PowerPoint, Outlook, PowerBI, Salesforce, MicroStrategy, Oracle.
- Data manipulation and clean up during business transformation process for GDSN information; worked closely with PLM for all changes, approved changes.
- Cleaned and standardized complex data from multiple sources for consolidation.
- Authored functional specifications for Oracle interface, facilitating accurate product information extraction for third-party provider uploads.
- Worked closely with Sales and Replenishment Teams.
- Performed or managed end-user testing pertaining to GDSN compliance and updates.
- Met with End Users to determine attributes, metrics and KPIs required for creation of reports, charts and dashboards.
- Worked with Business Intelligence to add or create attributes and/or metrics not available for End Users needs.
- Identified, analyzed and interpreted trends and patterns in complex data sets.
- Located and identified areas for new process improvement opportunities.
- Future planning for Data Synchronization.
- Created training materials and conducted Microsoft Office classes for over 100 customer service personnel, enhancing software proficiency.
- Created and maintained SOPs related to reporting, charts and dashboards.
- Worked with IT to develop SQL statements and reporting for inconsistent data (UPC, GTIN-14 hierarchies) for MDM.
- Worked with QMF program for building SQL reporting that was not included in the Data Warehouse used for MicroStrategy.
Process Engineer
3 Years 10 Months- Designed projects to improve management processes and systems.
- Developed use cases and functional specifications to align project outcomes with business needs.
- Studied and resolved problems that affected quality and efficiency.
- Conducted qualitative studies of work processes and policies to identify areas for improvement.
- Developed use cases and functional specs.
- Tested new systems, interfaces, system modifications.
- Used computer applications to set up process analysis, designs, models, statistical analysis.
- Used data mining tools to improve performance.
- Used tracking metrics to analyze performance.
- Conferred with personnel concerned to ensure successful functioning of newly implemented systems and procedures.
- Assisted in the development of project definitions, cost analyses, risk analyses, work plans, progress reports, presentations.
- Documented findings of study and prepared recommendations for implementation of new procedures and procedural changes.
- Reviewed forms and reports and confer with management and users about format, distribution, and purpose, and identify problems and improvements.
- Designed, evaluated, recommended, and approved changes of forms and reports, including automating reporting using Excel VBA macros.
- Documented findings and prepared actionable recommendations for implementing new procedures and procedural changes.
- Interviewed personnel and conducted onsite observation to ascertain unit functions, work performed, and methods, equipment, and personnel used.
- Compiled statistical reports.
- Migrated reports from Business Objects to MicroStrategy and from MicroStrategy to PowerBI
Education
Bachelor of Science - Recombinant Genetic Technology & Chemistry
Skills
Data Governance/Data Steward
Data cleansing/analysis
Attribute mapping
SQL
Microsoft Excel (Advanced)
Power BI
Tableau
MicroStrategy
VBA
Data dictionary creation
Data profiling
Data quality monitoring
BI dashboard design
Certification
- CMMI-EDM; September 2019
- Certificate: Six Sigma Greenbelt, Fruit of the Loom, Inc., 2013; Kentucky
Languages
English
Timeline
CLIA Compliance Analyst IV
Chenega
03.2025 - CurrentRead More
Senior Business Analyst – IT Consultant Organization
Capgemini
03.2021 - 03.2024Read More
Senior Data Analyst – Data Management Organization
Smith & Nephew (via Kelly OCG)
02.2019 - 01.2020Read More
Customer Service Projects Team – Data Steward, MDM, Data Synchronization
Fruit of the Loom, Inc
12.2014 - 02.2018Read More
Process Engineer
Fruit of the Loom, Inc
10.2009 - 08.2013Read More
Western Kentucky University
Bachelor of Science from Recombinant Genetic Technology & Chemistry
Read More