Data Analyst Architect

Cassondra Dixon-Wright

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

404-***-****

Career Summary

Ms. Cassondra Dixon-Wright is a US Citizen who lives in Alpharetta, Georgia, and is Covid-19 vaccinated. She has 12 years of solid Data Governance Enterprise experience using: Collibra, Dataedo Data Catalog and Informatica Data Quality tools. Cassondra has over 20 years of experience Leading Offshore teams. and 22 years of experience as a Leading Product Owners, and Data-Business Analyst. She has experience with SQL, Oracle Servers, Snowflake, AWS, and Data Visualization tools using Power BI and Tableau. Cassondra is available to interview with 1 to 2 days’ notice and can start immediately from the offer.

Highlights:

Expertise in source to target mapping in Salesforce to Enterprise and Corporate Data Warehouse environments

Develop Interface Control Documentations for appropriate Vendor processes and Data Governance Documentation for Enterprise policies and procedures

Attended Data Governance Committee meetings to ensure policies, procedures, and standards were adhered to throughout the Enterprise

Lead Offshore team: 4 Cloud Developers, 1 Data Architect/Data Modeler in Agile facilitation meetings to ensure developers are bringing in data from the data lake into the Atomic base layer and building/developing business models according to what Geico (Business) has asked them to buildout

Performed duties as a Scrum Master in a true scrum leading 5 different offshore teams, comprising 8 to 10 team members each

Trained in Collibra for Data Governance across Enterprise-Cross Verticals

Support and Led offshore testing teams in preparation of testing plans and investigation of erroneous outcomes

Helped to maintain the improvement of Data Quality and Data Governance of Domains

Lead Data Governance Committee meetings to establish and align Data Governance policies and procedures for Enterprise-wide standards

Monitored and refined dashboards and reports, worked with business members to ensure solutions are adopted and fully leveraged according to Data Governance and business rules

Developed a strong understanding of change control and Data Governance for requirement artifacts.

Interviewed and elicited Business Rules and KPIs from Service Providers ensuring appropriate governance and policies are in place for the creation of reports.

Experienced in working in a fast-paced Agile/Scrum environment, software development lifecycle (SDLC)

Research and document sponsor/stakeholder needs in accordance with Project Life Cycle methodology utilizing reporting tools, requirements elicitation methodologies, process models, data models, and prototypes

Highly skilled in working within an Agile/Scrum methodology, Waterfall SDLC environment

Responsible for defining, prioritizing, and managing the product backlog for scrum teams.

Responsible for elicitation of business requirements, functional requirements, and non-functional requirements translating them to user stories, and owning them throughout the development process preparing for Product Backlog along with Acceptance Criteria in Jira and Azure DevOps

Technical Skills

Application Software:

Collibra, Dataedo Data Catalog, Informatica IDQ, Snowflake, DB Visualizer, Spark, Hadoop, Hive,, AWS, Snowflake, Alteryx, PostMan, MOVEit, EDI Batch Processes for 820, 834, 837, Python, Eloqua Marketing, Compass, Salesforce, AppExchange packages, Siebel CRM, Epic Clarity, Healthcare Tapestry Application and Reporting Workbench, HP CC (Cloud), HP Quality Center, Jira, Azure DevOps, Rational Rose UML Modeling, Teradata SQL Assistant 7.1, Power BI, Tableau, BI Publisher, OBIEE, Business Objects, COGNOS, Crystal Reports Versions 8, 9, 10, 11, 12, SharePoint Designer 2007, Incentive v3, CRM Sales Compensation Database, SQL, SQL*Plus, SQL Loader, Oracle Enterprise Manager Toolset, SQL Server, Enterprise Manager, Lotus Notes, SAP R/3, HANA, Microsoft Access, ERP, PeopleSoft8, HL7, Horizon, HealthCare Patient Folder, Horizon Electronic Patient Folder, Workstation, OFED

Core Skills:

Data Governance, Use Cases/User Stories, Acceptance Testing, Technical Business Analysis, Report Creation, Data Manipulation, Data Analysis, Data Quality, Data Profiling, Data Mapping, Data Warehousing, Gap Analysis, Automation and Scheduling of Reports, Report creation, Backlog Grooming, Agile/Scrum methodology, system updates

Professional Accomplishments

Nutrien/Agrium US June 2022 to April 2023

Senior Data Analyst/Data Governance Consultant (Contract)

Provided advisory to define, improve or operationalize data management control frameworks, DQ standards, and governance process utilizing Dataedo Data Catalog

Provided guidance on DQ, CCPA(PII Sensitive data), GDPR compliance efforts and IT Control standards to align with Enterprise Risk Finance and Technology (RFT) Framework and industry standards

Developed expertise on the SAP Master Data Management, CCPA, policies and standards and provide guidance (or highlight risks or issues) to senior management.

Performed current state assessment of Data Quality and IT Controls and provide recommendations to mitigate data risk more effectively.

Recommended an optimized target state to ensure improve coverage and the right controls are deployed in strategic locations.

Recommended appropriate data capture, transport and use controls and collaborate with enterprise technology teams to implement recommended DQ Controls

Partnered with DM team to refine existing DQ Rule to ensure appropriate coverage and granularity.

Supported process to review Key Business elements (KBE), KBE metadata, prioritization, data lineage.

Executed ERFTs Data Quality Framework to assess, measure, monitor and report data quality for key business elements leveraged across key regulatory reports.

Partnering and engaging with the Monitoring, Governance and Issue Management workstreams

Supported audit preparation and provide actionable recommendations to mitigate Data Quality and IT Controls risks highlighted in audit or regulatory findings

Provided guidance on required artifacts and collate DQ information in preparation for audit

Sustainable Controls Design for Issue Remediation

Designed sustainable Data Quality controls as part of issue remediation process

Partnered with business, technology, and issue remediation team to define sustainable Data Quality and IT controls

Provided actionable recommendations to implement controls that prevent, detect and correct DQ related risks

Prime Therapeutics (Remote) December 2021 to June 2022

Senior Data Analyst (Contract)

Collaborated with Data Architects, and BI Developers to understand how data is being populated from Source Data systems into Rebates Application layers and then into Analytics Presentation Layer

Performed Data Quality checks to verify that data provided is consistent with the requirements to build Invoice Summary Reporting

Serves as liaison between the business partners and IT to provide technical solutions to meet user needs and maintain established business relationships

Experienced in working in a fast-paced Agile/Scrum environment, software development lifecycle (SDLC)

Lead the collection, analysis, and documentation of functional business requirements, as well as the business design of functional solutions

Created test plans, test data for extraction and transformation processes, and resolved data issues following the data standards

Wrote User Stories and acceptance criteria in Product Backlog

Created and tracked Incident and Change management service tickets

Created User Stories and acceptance criteria in Product Backlog (Jira platform)

Create and execute communication plans for production release

Mayo Clinic (Remote) August 2021 to December 2021

Senior Business Data Analyst (Contract)

Collaborated with Data Architects, BI Developers, and Data Modelers to understand how data is being populated from Source Data (Clarity/Epic) into the new Analytics Presentation Layer (Tableau)

Performed Data Quality checks to verify that data provided is consistent with the requirements to build

Interactive Care Plan Data Mart

Read and review developers’ SQL code to ensure SQL code is pulling from data sources and tables

Created Source to Target data mapping, performed gap analysis, and data profiling

Deep-dive data validation by comparing patient data sets which lay in the Analytics Presentation Layer with Epic MyChart Patient encounter data sets to see if what is presented in Analytics matched what lies in the Epic MyChart Patient encounter area

Reviewed and tested the data to ensure accuracy and validity of the data prior to uploading the data to the warehouse

Created, revised & executed the following deliverables using industry-standard techniques, as applicable, including but not limited to process maps, data flow diagrams, requirements specifications, project plans, status reporting, use case scenarios, and acceptance testing

Performed business analysis and solutions around data sources using SQL and data profiling tools

Documented technical workflows, runbooks, data sources, job schedules, and other technical documentation

Testing, troubleshooting, solutioning, and debugging production and QA issues

Managed and work on deliverables independently and partnered with technical teams to drive delivery of dev items

Fiserv-First Data (Remote) April 2021 to August 2021

Senior Data/Product Owner (Contract)

Identified, researched, analyzed, and wrote data-related requirements to ensure client and market needs are met

Worked closely with clients and internal departments to clearly understand and address business problems and issues

Responsible for mapping legacy client data (accounts & points; programs & rules) to the PLP Platform and developing data validation metrics to objectively confirm data moved correctly onto the PLP platform

Analyzed data-related requirements associated with product enhancements and/or features to be implemented on the PLP platform

Conducted Data validation of large-scale conversions within the Financial Services industry, SaaS, Loyalty, or Commerce related products and markets

Supported new and ongoing Loyalty Product new feature development or enhancements for Loyalty, Fulfillment, and Engagement products that support national and multinational Retailers and Financial Services organizations

Conducted client-facing and acted as the key collaborator for data migrations across the business, product, technical, and operational functional groups

Assessed, defined, and executed data-related business requirements in an Agile development environment

IBM Global Services - Geico (Remote) November 2020 to April 2021

Senior Data Analyst-Data Governance Consultant (Contract)

Lead Offshore team: 4 Cloud Developers, 1 Data Architect/Data Modeler in Agile facilitation meetings to ensure developers are bringing in data from the data lake into the Atomic base layer and building/developing business models according to what Geico (Business) has asked them to buildout

Trained in Collibra for Data Governance across Enterprise-Cross Verticals

Support and Led offshore testing teams in preparation of testing plans and investigation of erroneous outcomes

Elicitation of business requirements, functional requirements, and non-functional requirements translating them to user stories and owning them throughout the development process preparing for Product Backlog along with Acceptance Criteria in Jira

Salesforce Product Owner will be responsible for defining, prioritizing, and managing the product backlog for scrum teams

Performed as a Lead Product Owner specializing in Salesforce Cloud platform implementation

Partnered with the IT Product Manager and Business Owners to help understand their priorities and vision for the near-term and long-term roadmaps

Strong knowledge of Salesforce.com capabilities (both functional and technical) and integration capabilities

Creation of Gherkin statements within datavault2 testing/behave environment

Utilized Alteryx for importing Excel spreadsheets, data flow, and cleansing of data

Data Lineage - Source to Target mapping of existing systems utilizing Collibra

Performed Data Quality checks to verify that data provided is consistent with the requirements to build Cloud Data Warehouse and populate Analytical Reporting Area

Utilized such tools as Snowflake (Cloud Data Warehouse), Hadoop, Spark, Cluster Scheduler UI, Jenkins

Utilized DB Visualization tool to query the database to check for any data inconsistencies in the data warehouse

Perform root-cause analysis of production issues utilizing DB Visualizer

Utilized Snowflake to create row-level security by first identifying PII information, segregating the tables which contain it, out from their original schema, and into a new PII_SEC table to hold PII data, then creating a Secured View of that data, then granting privileges to that table/view

Elicitation of functional requirements and technical business rules to help sources sitting in data lakes ingest data thru downstream pipelines thru middleware to target base tables and then into a presentation layer

Utilized Data Vault2 as an ELT tool for cleansing data and ingesting data into Snowflake Pipeline

Utilized Python to create SQL scripts for ingestion of data to conformed, integration, and presentation zones and used to test data both using python datasets and SQL in Snowflake

Utilized Collibra for creation of Data Dictionary, STM (Source to Target Mapping), data catalog, data definitions, business glossary

IBM-Watson Healthcare January 2020 to November 2020

Technical Business-Data Analyst/Product Owner (Contract)

Lead, facilitated, and managed JAD discussions with healthcare data carriers to (1) manage data intake, and (2) ensure all client data requirements are discussed and confirmed

Documented and transcribed Agile Use Cases/User Stories/Test Cases from the Business Client (State Government Systems)

Taken lead as Product Owner, managed product backlog, and gathered reports showing project implementation milestones

Worked closely with Data Warehouse Architects, Data Architects, Business Intelligence Architects, and Cognos Reports Development team to ensure requirements are met and understood so development can build out what Business has asked

Helped Data Warehouse and Data Architects design and develop State Healthcare Data Warehouse

Elicitation OFED business requirements for Executive and Federal Reporting, translating them into Business requirements documentation

Established meetings with State Vendors to help update or modify EDI processes and EDI templates used for Claims, Medicare/Medicaid, or Pharmacy claims

Utilized MOVEit to handle Vendor EDI secured FTP transmissions to move data from Source to Interfaces

Utilized tools such as Squirrel Query or SQL Developer to query the database for any inconsistencies in data, data mapping, data analysis

Utilized Alteryx for data preparation, filtering, data blending, workflow designs, cleansing of data for Data Quality issues, data parsing, data manipulation, VLOOKUPs, and appending data

Used Tableau for data parsing, Data Quality, data blending and meshing of CDC URLs blending datasets into tables, and meshing data into Tableau for reporting purposes

Lead Data Governance Committee meetings to establish and align Data Governance policies and procedures for Enterprises

E&Y September 2019 to December 2019

Technical Product Owner (Contract)

Elicitation of business requirements, translating them to user stories, and owning them throughout the development process preparing for Product Backlog along with Acceptance Criteria

Performed duties as a Scrum Master in a true scrum leading 5 different offshore teams, comprising 8 to 10 team members each

Leading ceremonies, driving backlog grooming, and removing barriers. The focus of this role is driving successful execution and implementation of new product features to application modules.

Salesforce Product Owner will be responsible for defining, prioritizing, and managing the product backlog for scrum teams

Performed as a Lead Product Owner specializing in Salesforce Cloud platform implementation

Partnered with the IT Product Manager and Business Owners to help understand their priorities and vision for the near-term and long-term roadmaps

Ability to translate those priorities into features and user stories and acceptance criteria

Strong knowledge of Salesforce.com capabilities (both functional and technical) and integration capabilities

Focused on driving successful execution of the user stories performing requirements gathering phase and removing barriers and bottlenecks to completion of sprints

Facilitated and Lead Stand up of Scrum Project meetings and led efforts in sprint iterations

Worked closely with the Product Owner and the Business/Stakeholders for maximizing business value for the project and articulated customer requirements for the project

Understood how Rest APIs work from the time of request to time of response across all verticals

Utilized SQL to query the database to check for data inconsistencies and do data analysis

Guided, facilitated, and taught Scrum practices to everyone involved in the project, cleared impediments for the team; and ensured that Scrum processes are being followed

IBM/Watson Healthcare February 2019 to August 2019

Lead Technical Business-Data Analyst/Product Owner (Contract)

Lead offshore team of 15 data developers in JAD discussions with healthcare data carriers to (1) manage data intake, and (2) ensure all client data requirements are discussed and confirmed

Documented and transcribed Agile Use Cases/User Stories/Test Cases from the Business client (State)

Lead Data Governance Committee meetings to establish and align Data Governance policies and procedures for Enterprise-wide Data Governance standards

Performed Data Quality checks to verify that data provided is consistent with the requirements to build Healthcare Data Warehouse

Wrote data transformation specifications to load source data into target data warehouse tables

Helped develop Interface Control Documentations for appropriate Vendor processes and Data Governance Documentation for Enterprise policies and procedures

Worked with the Database Programmers/Data Architects, Data Warehouse Architects, BI Architects, and Developers to perform quality checks on the reformatted coding; ensure data is complete while making modifications as necessary to transform the raw data into table layouts

Performed data profiling, data analysis, data mapping, and data mining and identify the root cause of issues using SQL

Assisted the Engineering/Tools team with new business requirements and helped them with Functional/Non-Functional Specifications

Established meetings with State Vendors to help update or modify EDI processes and EDI templates used for Claims, Medicare/Medicaid, or Pharmacy claims

Utilized Tableau and Alteryx for scrubbing/cleansing of data, blending of data, and creation of dashboards and Graphs for Claims Reporting, Intake Summary Reporting, Intake Eligibility, and Assessment Reporting

Assisted in the conversion of internal processes from manual to automated through coding and programming

Reviewed and tested the data to ensure accuracy and validity of the data prior to uploading the data to the warehouse

LexisNexis Risk Solutions February 2018 to December 2018

Technical Business-Data Analyst/Product Owner (Contract)

Proven ability to work efficiently in both independent and collaborative environments with excellent interpersonal and communication skills

Expertise in source to target mapping in Salesforce to Enterprise and Corporate Data Warehouse environments

Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact, and Dimensional tables and DW concepts, HPCC Cloud technology, Data Lakes, and Clustering of data

Created test plans, test data for extraction and transformation processes and resolve data issues following the data standards

Salesforce Product Owner will be responsible for defining, prioritizing, and managing the product backlog for scrum teams

Performed as a Lead Product Owner specializing in Salesforce Cloud platform implementation

Partnered with the IT Product Manager and Business Owners to help understand their priorities and vision for the near-term and long-term roadmaps

Ability to translate those priorities into features and user stories and acceptance criteria

Strong knowledge of Salesforce.com capabilities (both functional and technical) and integration capabilities data standards

Utilized Alteryx for importing data and cleansing/scrubbing of data, data blending, data charts/graphs, used as a workflow tool

Experienced in working in Digital Marketing Department where Google, Facebook, and all digital feeds were ingested into Cloud Data Lake and then ETL and populated into downstream systems to ingest

Coordinated and prioritized all escalated activities, including testing, project management, and implementation of system upgrades, enhancements, and bug fixes

Experience in developing Transformations, Mapplets, and Mappings using Informatica

Worked with Eloqua to understand Campaign logic so ask to re-configure campaigns, email blasts, and lead time

Drove the data definition, created a data dictionary, training, and implementation of functional requirements

Upon implementation, drive knowledge transfers to production support teams

Created, revised & executed the following deliverables using industry-standard techniques, as applicable, including but not limited to process maps, data flow diagrams, requirements specifications, project plans, status reporting, use case scenarios, and acceptance testing

Document marketing processes through swim-lane diagrams, develop user stories and use wireframes for requirements elicitation

Created and analyzed functional requirements using Agile User Stories to translate them into technical requirements and specifications for the development team

Worked and communicated with technical teams (database developers, database architects, QA, infrastructure) to ensure specifications are understood and followed

Create and execute communication plans for production releases

Developed test cases, and test scripts, and perform user acceptance testing for data application projects

Analyzes complex cross-functional business processes and defines integrated requirements

Facilitated and Led efforts utilizing Agile Methodology to drive the design of integrated solutions (process, technical & organizational)

Proven ability to work efficiently in both independent and collaborative environments with excellent interpersonal and communication skills

Salesforce system configuration, roles, and responsibilities, AppExchange packages

Communicate effectively orally and in writing and adapt to the needs of the target audience

Utilized Tableau to rebuild existing reports and apply new marketing data mart views, type of reports:

how many Leads were converted to an Opportunity, how many Opportunities were in a particular region, who are the top 10 salespersons in a particular region, etc.

Created SQL statements to analyze data gaps between source to target environments

Lead Data Governance Committee meetings to establish and align Data Governance policies and procedures for Enterprise-wide standards

McKesson February 2017 to December 2017

IT Hardware Asset Analyst (Data Governance) (Contract)

Maintained and tracked all company’s IT hardware assets and total maintenance life cycle from procurement to the hardware being sunsetted/retirement

Ensured all Assets were accurately registered or deregistered

Kept procedures updated to effectively asset life cycle management (acquisition, deployment, utilization, de-installation, reallocation, decommission, and disposal) of IT assets

Coordinated and prioritized all escalated activities, including testing, project management, and implementation of system upgrades, enhancements, and bug fixes

Helped to maintain the improvement of Data Quality and Data Governance of Domains

Identifies opportunities to improve ITAM processes as they related to creating and management of data and how it affects all downstream processes

Tracked and identified IT Asset Owners/Management and CMDB Managers to ensure the integrity of hardware data

Developed ad hoc reports and created dashboards for Asset tracking reporting

Identified any opportunities for process improvements and/or enhancements

Utilized Atrium Discovery tools to automate asset discovery and identify systems in the network

Attended Data Governance Committee meetings to ensure policies, procedures, and standards were adhered to throughout the Enterprise

AFLAC October 2016 to January 2017

Senior MDM Business Consultant (Contract)

Liaison between the business partners and IT to provide technical solutions to meet user needs and maintain established business relationships

Experienced in working in a fast-paced Agile/Scrum environment, software development lifecycle (SDLC)

Lead the collection, analysis, and documentation of functional business requirements, as well as the business design of functional solutions

Created test plans, test data for extraction and transformation processes, and resolved data issues following the data standards

Experienced in using IDQ tool for profiling, applying rules, and developing mappings to move data from source to target systems

Coordinated and prioritized all escalated activities, including testing, project management, and implementation of system upgrades, enhancements, and bug fixes

Experience in developing Transformations, Mapplets, and Mappings using Informatica

Designer to implement business logic

Strong knowledge and Experience in using Informatica Power Center 8.1/8.5/8.6/9.1 ETL tool

Strong data analysis to ensure accuracy and integrity of data in the context of Business Functionality

Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact, and Dimensional tables and DW concepts

Works closely with the QA testing team to write appropriate User Stories for acceptance testing scripts

Work closely with MDM Informatica Architects to fully understand and “read” ETL processes and process flows for business requirements and understand the business rules that are coded within the ETL load processes

Created Source to Target mapping from Application (Salesforce) to Oracle Database to Data Warehouse System to Data Marts

Write SQL statements to query databases to double check that load processes have full populated database tables and fields

Lead Data Governance Committee meetings to establish and align Data Governance policies and procedures for Enterprise-wide standards

Participates in identifying opportunities that impact business strategy and performance issues

Leads the development, writing, and communication of business requirements for the design and implementation of business solutions for initiatives with high visibility

Utilized Architect for the creation of business requirements (BRDs) and Use Cases, business processes, swim lanes, and sequencing diagrams

Beaumont Hospital/ (Dell IT, Modis IT) June 2016 to July 2016

Epic Clarity Report Writer (Contract)

Extracted data from Epic Clarity Database to create SQL command to build into Crystal Report and or Tableau Environment. Types of Reports: Predictive Reports, Forecasting Reports, Revenue Cycle Reports, Claims, Inpatient/Outpatient Reports, Utilized Reporting Workbench for “Real-time” Reporting

Worked as a Liaison between Business and IT eliciting business requirements in Use Case and User Story style for reporting purposes

Coordinated and prioritized all escalated activities, including testing, project management, and implementation of system upgrades, enhancements, and bug fixes

Documented and reviewed data mapping between Source to Target systems

Monitored and refined dashboards and reports, worked with business members to ensure solutions are adopted and fully leveraged according to Data Governance and business rules

Converted existing reports from Crystal Reports into Tableau or Qlik Sense reports

Verizon Telematics - Dunwoody, GA May 2014 to January 2016

Sr. Business-Data Solutions Consultant (Contract)

Lead an offshore team of 4 developers, 2 data architects, and 2 data modelers, worked in a fast-paced Agile/Scrum environment, software development lifecycle (SDLC)

Implementation of Informatica MDM master data, worked alongside Enterprise Architects, Solutions Architects, and Database Developers for implementation of MDM across all databases

Created Schema, Conceptual, Logical, and Physical Data Models in Customer Master Data, CRM, BRM systems

Developed dashboards and reports utilizing either Tableau, OBIEE, or Google Analytics

Developed an understanding of the current end-to-end BI platform architecture to help support deployed solutions

Provided data for analysis by operations staff, internal executable level, and/or outside partners

Worked with Oracle database administrators and architects to improve overall performance and eliminate report/query redundancies and bottlenecks

Created Source to Target mapping from Application (Salesforce) to Oracle Database to Data Warehouse System to Data Marts

Salesforce Product Owner will be responsible for defining, prioritizing, and managing the product backlog for scrum teams

Performed as a Lead Product Owner specializing in Salesforce Cloud platform implementation

Partnered with the IT Product Manager and Business Owners to help understand their priorities and vision for the near-term and long-term roadmaps

Worked side by side with Solution Architects in creating solution designs utilizing tools to build sequencing diagrams, swim lanes, and UML

Contact this candidate