Resume

Sign in

Data Salesforce

Location:
Alpharetta, GA
Posted:
May 20, 2020

Contact this candidate

Resume:

Cassondra Varie Dixon

404-***-****

LinkedIn: linkedin.com/in/cassondra-dixon-wright-1b06432, not active on LinkeDin.

Location: Alpharetta, GA 30004

Notice Required: Immediately

Candidate’s interview/start availability: 24 hours’ notice for Interview and Can start immediately

Candidate’s current employment: Contract

Summary:

●Over 18 plus years in IT industry as a Lead Scrum/Data/Business Analyst (Data Centric) extensive database experience and highly skilled in working within an Agile/Scrum methodology, Waterfall SDLC environment. Within various platforms such as: AWS Cloudera, Informatica IDQ, Teradata, Oracle, MS SQL Server, Salesforce, Siebel CRM/BRM, Eloqua Marketing

●Expertise in Data Quality Data Governance Analyst, Use Cases/User Stories/Acceptance Testing, Technical Business Analysis, Report Creation, Data Manipulation, Data Analysis, Data Quality, Data Profiling, SAS, Data Governance, Data Mapping, Data Warehousing, Gap Analysis, Automation and Scheduling of Reports, Report creation.

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

Skills:

Application Software: Alteryx, PostMan, EDI Batch Processes for 820, 834, 837, Python, Eloqua Marketing, Compass, Salesforce system updates/AppExchange packages, Siebel CRM, Epic Clarity (Healthcare Tapestry Application and Reporting Workbench),HPCC (Cloud), HP Quality Center, Jira, Informatica IDQ, Rational Rose UML Modeling, Teradata SQL Assistant 7.1, Power BI, Tableau, BI Publisher, OBIEE, Business Objects, COGNOS, Crystal Reports Versions 8, 9, 10 and 11, and 12, SharePoint Designer 2007, Incentive v3 CRM Sales Compensation Database, SQL, SQL*Plus, SQL Loader and Oracle Enterprise Manager Toolset, SQL Server Enterprise Manager, Lotus Notes, SAP R/3 and HANA, Microsoft Access, JD Edwards (ERP system), PeopleSoft8, HL7, Horizon HealthCare Patient Folder, Horizon Electronic Patient Folder, Workstation (McKesson Health Care Applications)

Education:

●DeVry University Graduated- Bachelor’s Degree in computer information systems

Training:

●Database Development, Certificate of Completion Qlik Sense 2.0, Training in Tableau Fundamentals and Advanced, Sept 2014, Trained in Oracle R11/R12 Financial E-Business Suites (AR, AP, GL) 2013, Trained in Informatica Power Center 9, Trained in Informatica MDM Master Data 2015, Trained in Informatica IDQ 2015, Trained in Oracle DBA 8i and 9i 2008, Salesforce Certification Apps Exchange and Salesforce Administration

Experience

IBM-Watson Healthcare (Remote)

Technical Business/Data Analyst Mar 2020 to Mar 2020

●Hosted and facilitated 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)

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

●Gathered business requirements for Executive and Federal Reporting, translating them into Business requirements documentation

E&Y, GA Sept 2019 to Dec 2019

Technical Business Analyst/ Scrum Master

●Gathered 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 environment leading ceremonies, driving backlog grooming, and removing barriers. The focus of this role is driving successful execution

●Focused in driving successful execution of the user stories performing requirements gathering phase and removed barriers and bottlenecks to completion of sprints

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

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

●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, GA Feb 2019 - Aug 2019

Lead Technical Business/Data Analyst

●Hosted and facilitated 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)

●Performed data quality checks verifying 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, BI Architects, Developers to perform quality checks on the reformatted coding; ensure data is complete

●while and making modifications as necessary to transform the raw data into table layouts

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

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

●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, GA Feb 2018 - Dec 2018

Technical Solutions Consultant

●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.

●Experienced in using IDQ tool for profiling, applying rules and develop 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.

●Drive the definition, testing, training, and implementation of functional requirements.

●Upon implementation, drive knowledge transfer 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 analyze d functional requirements using AGILE User Stories to translate them into technical requirements and specifications for 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, test scripts, and perform user acceptance testing for data application projects

●Analyzed 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 re-build existing reports and apply new marketing data mart views, type of reports:

●How many Leads were converted to an Opportunity, How many Opportunities in particular region, Who are the top 10 sales persons in particular region, etc.

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

●Utilized Postman to get/fetch/test/format APIs, Eloqua and Compass marketing to blast email campaigns and run internal ad hoc queries

McKesson – Alpharetta, GA Feb 2017 to Dec 2017

IT Hardware Asset Analyst

●Maintained and tracked all company’s IT hardware assets and total maintenance life cycle from procurement to 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 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, Columbus, GA Oct 2016 - Jan 2017

Senior Business Solutions Consultant

●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 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 develop 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 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, 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.

●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 creation of business requirements (BRDs) and Use Cases, business processes, swim lanes and sequencing diagrams

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

Epic Clarity Report Writer

●Extracted data from Epic Clarity Database to created 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 gathering 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 - Jan 2016

Sr. Business/Data Solutions Consultant

●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, Google Analytics

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

●Translate business requirements and use cases into system requirements documents

●Facilitate meeting sessions with both technical and business participants

●Worked side by side with Solution Architects in creating solution designs utilizing tool to build sequencing diagrams, swim lanes, UML processes

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

●Worked in fast-paced Agile/Scrum environment, software development lifecycle (SDLC)

●Support testing teams in preparation of testing plans and investigation of erroneous outcomes

●Perform root-cause analysis of production issues

●Queried data using databases in a business environment with complex data sets

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

●Monitored and refined dashboards and reports, worked with business members to ensure solutions are adopted and full leveraged; Created UAT Testing scripts and Test Cases

●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 bottle necks.

Mag Mutual Insurance - Atlanta, GA Jan 2014 to May 2014

Sr. Business Systems Consultant

●Interfaced with executives, senior management, and clients within and outside the organization.

●Utilized such tools such as QlikView and Tableau Analytics tool to isolate company’s data quality issues and then set business rules around these issues.

●Responsible for system testing and assisting in the client’s user acceptance testing (UAT).

●Responsible for leveraging and transitioning fully implemented projects to the client services team for long term implementation support

●Acted as Liaison between Business and IT Partners across multiple business functions to align Business Intelligence technology and Salesforce Systems solutions with business strategies

●Granted, permissions and assigned roles for User setup in SalesForce system

●Lead JAD sessions to gather and document technical solutions for Business gave presented further findings to IT staff to implement

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

●Assisted the Business with day to day processing of data and delivery of information from within the Data warehouse (source systems) to SalesForce to Oracle and SAP Master databases for Customer, Claims and Policy database information.

●Created Schema, Conceptual, Logical and Physical Data Models

●Responsible for the collection, analysis, design and documentation of functional requirements.

●Created regression and unit test scripts for any and all new BI dashboards, scorecards, and reporting brought into production environment

●Developed a strong understanding of change control and data governance for requirement artifacts.

●Provided Subject Matter Expertise in one or more core functional areas

●Utilized SQL or Oracle Database 2010 to create forms, queried database to create reports for Business Users to use for everyday processes.

●Utilized SQL to resolve data processing errors and batch processing errors

Coca-Cola - Marietta, GA Jul 2013 to Dec 2013

Sr. Teradata Consultant

●Acted as Liaison between Business and IT partners across multiple business functions to align technology solutions with business strategies.

●Responsible for creating Test Scripts for Integration testing from one platform to another, utilizing HP ALM Quality Center

●Assisted the Business with day to day processing of data and delivery of information within Micro-Strategy reporting systems, SAP (Supply Chain) and HANA database for Coca-Cola Bottler information.

●Salesforce User setup: granted access, roles and permissions to EndUser for access into Salesforce system

●Responsible for the collection, analysis, design and documentation of functional requirements.

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

●Queried databases did inserts, updates and deletes. Examined and reconfigured Store procedures. Modified existing code to stored procedures and Views

●Documented the alignment of data distribution thru gap analysis, ERD diagrams,

●Physical and logical data modeling documentation.

●Created SQL statements to troubleshoot any data processing and/or batch issues

UPS, Alpharetta, GA Jan 2013 to July 2013

Sr. Business Systems Analyst

●Salesforce system configuration, roles and responsibilities, AppExchange packages

●Liaison with External and Internal business partners across multiple business functions to align technology solutions with business strategies.

●Supported one or more highly complex Master data processes, requiring design or integration of technical solutions that may cross multiple functions of the business and backend data source systems.

●Created dashboards or reports for Stakeholders, Executives, Operational Center

●Leads project team members through the process of developing and maintaining requirements from analysis to deployment.

●Responsible for the collection, analysis, design and documentation of functional requirements.

●Presents business and functional requirements documentation for review and sign-off.

●Developed a strong understanding of change control and data governance for requirement artifacts.

●Coordinates feasibility studies and proposals for evaluation by appropriate users and managers.

●Created Schema, Conceptual, Logical and Physical Data Models

●May assist in the RFP process by preparing the technology requirements documentation and participating in the evaluation and selection of products/services. Investigates, resolves and escalates problems.

●Systems: Salesforce, SAP (Supply Chain), Data warehouse, Power Pivot, Tableau

●Worked alongside with DBA’s and plotted out Data Mapping from source to destination

T-Mobile, Atlanta, GA Jan 2012 - Dec 2012

Sr. Business Consultant

●Created solution designs, sequencing diagrams, swim lanes utilizing Architect

●Participated with both the architectural and development design teams to thoroughly understand data issues involved in daily load processes.

●Provided Subject Matter Expertise in one or more core functional areas

●Application support in (Message Processing, Mediations, Provisioning, Billing, Web, Middleware, Retail Activation Systems, Payment Processing)

●Protected and insured the stability of the operational systems as well as maintain the integrity of the data they contain.

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

●Maintained cross-business responsibilities by providing end-user support to multiple organizations within the company when issues arise

●Assisted in determining the impact of operational issues and provide input into their resolution via data extraction and quantification.

Streamline Health, Atlanta, GA Jun 2012 - Oct 2012

Sr. Business Consultant

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

●Queried Oracle databases did inserts, updates and deletes. Examined and reconfigured Store procedures added new codes to stored procedures.

●Utilized Tableau Reporting tool to streamline data quality issues and gaps in data, to help drive business rules needed to change processes in data flows or workflows

●Helped resolve application issues, management of revenue cycle data from client extraction uploads, transforming using STRM and third-party tools, and load into STRM system to achieve maximum client satisfaction.

●Provide Business Analytic and real time solutions and access to Key Performance metrics that enable healthcare organizations to identify and manage opportunities to maximize financial performance.

●Organizes, sorts, and filters data in order to distinguish patterns and recognize trends.

●Works with Project Team so solve Client Business needs

●Worked tickets, troubleshooting application and or database issues.

●Analyzes the client extracted data, maps, and integrates the disparate data using proven SQL Server 2010 methodology.

●Validates that all functions perform according to the relevant specifications.

●Conducts moderately complex analyses and solves moderately complex issues.

●Establishes team standards and templates to ensure consistency and supportability of solutions, as a team.

●Works with all team members to gain insight into the business need(s) and draws upon all skills/subject matter experts to ensure the solution corresponds with the team focus and direction

COX Communications, Alpharetta, GA Mar 2009 - Dec 2010

Sr. BI consultant

●Design and develop OBIEE user interface objects (e.g. reports, dashboards, etc.)

●Design and develop OBIEE metadata/logical data models

●Utilized TOAD to Query data in Oracle 11g database environment

●Translate BI requirements into analytic BI subject areas

●Determine requirements for aggregate tables

●Worked with customers and business Architects to understand and develop reporting and BI requirements.

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

●Actively participated in design and analysis sessions to ensure sound team decision- making

●Support system and user acceptance testing activities, including issue resolution.

●Complete technical documentation to ensure system is fully documented

●Mentor and train IT staff by sharing best practices and lessons learned from past implementation efforts

●Converted all reports in Scout Application to either Tableau or OBIEE Reports and Dashboards.

●Managed tickets and work orders queued in Remedy Ticketing Systems to ensure that customers receive regular updates and optimum support.

●Wrote queries to perform data quality checks after ETL process was kicked off to ensure tables and fields were populated accordingly

●Demonstrated good phone skills, professional courteous demeanor, and a friendly helpful attitude

●Was a liaison between the Business Services Group, Service Desk Support and the Business Application Services support team.

●Demonstrated excellent business judgment in relation to business value to drive effective prioritization decisions

●Utilized Microsoft Squirrel to running queries in database environment and create some views within database as well.

Military Service February 1982 to December 1986

United States Army, Specialist 4(P) from

Education & Additional Training

DeVry University Graduated

Bachelor’s Degree in computer information systems

Training:

Database Development

Certificate of Completion Qlik Sense 2.0

Training in Tableau Fundamentals and Advanced, Sept 2014

Trained in Oracle R11/R12 Financial E-Business Suites (AR, AP, GL) 2013

Trained in Informatica Power Center 9

Trained in Informatica MDM Master Data 2015

Trained in Informatica IDQ 2015

Trained in Oracle DBA 8i and 9i 2008

Trained in: Salesforce App Builder Certification and Salesforce Administration

Trained in: Salesforce Workbench Developer(SOQL query)



Contact this candidate