Resume

Sign in

Data Support

Location:
Alpharetta, Georgia, United States
Posted:
February 11, 2019

Contact this candidate

Resume:

Cassondra Dixon

404-***-****

ac8gkr@r.postjobfree.com

summary

Over 16 plus years in IT industry as a Business Intelligence Reports Analyst extensive database experience and highly skilled in working within an Agile/Scrum methodology, Waterfall SDLC environment. Within various platforms such as: Informatica MDM, Teradata, Oracle, MS SQL Server, Siebel MYCRM, Eloqua Marketing

●Expertise in Data Quality Data Governance Analyst, 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

●Application Software: Eloqua Marketing, Compass, Siebel MY CRM, Epic Clarity (Healthcare Tapestry Application and Reporting Workbench),

●HPCC (Cloud), 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 Supply Chain R/3 Supply Chain and HANA, Microsoft Access, JD Edwards(ERP system), PeopleSoft 8, HL7, Horizon HealthCare Patient Folder, Horizon Electronic Patient Folder Workstation (McKesson Health Care Applications)

Experience

LexisNexis Risk Solutions

Technical Business Analyst-(Marketing Data Mart Implementation) Feb 2018 to Dec 2018

●Utilized Tableau and Power BI reporting tools to create: Sales PipeLine Dashboards(Number of Leads Converted to Opportunity, Number of Prospects in a Sales Pipeline)

●Proven ability to work efficiently in both independent collaborative environments with Excellent interpersonal and communication skills.

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

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

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

●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

●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 collaborative environments with Excellent interpersonal and communication skills.

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

● Ability to manage multiple priorities and meet deadlines

●Utilized Power BI or SQL statements to analyze data gaps between source to target environments.

●Utilized Eloqua and Compass marketing to blast email campaigns and run internal ad hoc queries

McKesson – Alpharetta, GA

Business Consultant (Contractor) June 2017 to Dec 2017

●Gathered business needs/wants and translated those needs into measurable requirements that can be coded, tested, and successfully implemented and adopted for products/applications:

●Acted as Liaison between business Partners and Stakeholders to create specifications and identify business requirements for systems and solutions to meet business needs

●Defined, analyzed and proposes business solutions based on the business needs

●Created graphical reports in Excel to track number of assets associated to a Business Owner, Business Owners by Region associated to an Asset, etc.

● Reviewed and validated test plans, ensuring that the end result meet the specified business requirements

●Supported QA activities as needed

●Collaborated with technical delivery and solution engineering teams on the details of technical solutions to validate that the strategic business needs are met

●Validated and ensured that the proposed solution meet the stakeholders’ needs

●Lead cross-functional integrated teams to address business and adoption issues (e.g., user experience, data flow, process flow)

●Participated in the development process or other steps of the product life cycle

●Served as a key resource by providing input into the development of new feature/release education

●Collaborated with regulatory SMEs to understand how regulation affects products and documents regulatory requirements

●Conducted completed business requirements review with stakeholders and documents the acceptance of those requirements

AFLAC - Columbus, Ga

MDM Senior Business Solutions Consultant (Contractor) Oct 2016 to Jan 2017

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

●Created reports in both Tableau and Oracle ODI for Domain Data Managers to track Data Stewards daily performance (scorecards)

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

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

●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

●Leads in the development of project deliverables, such as requirements and interface specifications, business architecture models, and use-case scenarios specifications

●Conducts systems analysis with a focus on business process models and use cases

●Collects research on the competition in terms of best practices, business processes, and procedures; pays particular attention to market strategies and product development makes recommendations for buy vs. build decisions

●Performs other related duties as required

Beaumont Hospital/ (Dell IT, Modis IT) - Alpharetta, Ga

Epic Clarity Report Writer(Contractor) June 2016 to July 2016

●Extracted data from Epic Clarity Database to created SQL command to build into Crystal Report and or Tableau and Qlik-Sense 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

●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

Verizon Telematics - Dunwoody, Ga (Permanent)

Senior Business/Data Solutions Consultant May 2014 to Jan 2016

●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 and OBIEE reporting tools

●Documented and reviewed data mapping between systems

●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, swimlanes, UML processes

●Experienced in working 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

●Support multiple initiatives simultaneously

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

●Utilized Informatica IDQ for Data Profiling, duplication of addresses, customer names, etc.

●Analyzed flat file imports for standardization and data integrity

●Sampled and compared data within new and existing subject areas

●Assisted in performance testing on new or existing deliverables

●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

●Gather functional requirements and business case, define scope, and specifications for development

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

●Worked with Oracle database administrators and architects to improve overall performance and eliminate report/query redundancies and bottle necks.

Mag Mutual Insurance - Atlanta, GA

Senior Business Systems Consultant (Contractor) Jan 2014 to May 2014

●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 solutions with business strategies

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

●Assisted the Business with day to day processing of data and delivery of information from within the Data warehouse (source systems) to Oracle and SAP Supply Chain 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

Senior Teradata Consultant (Contractor) Jul 2013 to Dec 2013

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

●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

Senior Business Systems Analyst BI(Contractor) Jan 2013 to July 2013

●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: SAP Supply Chain HANA, Data warehouse, Power Pivot

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

T-Mobile, Atlanta, GA

Senior Business Consultant (Contractor) Jan 2012 to Dec 2012

●Created solution designs, sequencing diagrams, swimlanes 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

●Frequented interaction with the business to integrate knowledge of the business and functional priorities.

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

●Availability to provide 24 X7 support as required

●Worked in an Oracle, SqlServer OLAP, SAP Supply Chain, HANA and Unix environment utilizing command line and GUI SQL tools.

●Also provided expertise in Sarbanes Oxley and Change Management and Methodologies.

●Ability to Forecast and plan for supporting both applications functionality and capacity requirements in a rapidly growing, changing and complex environment.

Streamline Health, Atlanta, GA

Senior Business Consultant (Contractor) Jun 2012 to Oct 2012

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

●Identifies solutions to non-standard requests and issues.

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

Senior BI Developer (Contractor) Mar 2009 to Dec 2010

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

●Actively participate 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 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

●Acquired good sound problem solving, prioritization, and time management skills

●Ability to work with technical and user staff in a technical role on their projects

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

●Moved Dashboards, Graphs and Charts to SharePoint Designer 2007 so Business Users and Stakeholders to view and run reports.

Centers for Disease Control, Atlanta, GA

Senior Data Governance Consultant (Contractor) Jan 2008 to Apr 2009

●Act as a Liaison between Business and Technical staff gathering requirements for Business Intelligence queries and reports, ensuring proper usage, data quality and security of the information provided by Business Users.

●Created Ad hoc and specialized reports for Business Users utilizing such tools as TOAD, Business Objects XI and Crystal Reports 10 and moved this reports to SharePoint Designer 2007 for viewing.

●Created Functional and Technical business requirements for purposes of testing flow of data from Data Warehouse to Interfaces to Application to actual report itself.

●Recommended business solutions that satisfy sponsor/stakeholder needs continually exploring and assessing options for value-add for clients

●Creation of Data Flow charts, mapping of data from resource to destination.

●Responsible for monitoring daily log feeds from financial systems checking for errors in batch flow processes.

●Estimate activities required to perform requirements gathering and acceptance testing improving accuracy over time

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

●Responsible for simplifying and standardizing business processes and IT department solutions.

●Cross-functional support role that interfaces with multiple departments and locations within client’s environment.

●Provided support and maintenance including end-user support, service incidents/problem resolution, and system support process which include daily job monitoring, coordination with other IT teams and communication with impacted users.

●Assisted in troubleshooting and solving SAP Supply Chain BI/BW related issues.

●SAP Supply chain modules * MM, WM, IM, Purchasing, PP, BW, SRM

●Planned and executed unit, string testing, integration, cutover and acceptance testing to support system initiatives.

●Provided solutions in SAP Supply Chain BI for end users by helping with enterprise information analysis and design, work with data team to execute design with SAP Supply Chain.

●Created complex SQL statements to check data integrity within tables and fields.

●Utilized BO to create reports and dashboards for Business Users and Key StakeHolders.

Fiserv, Norcross, GA

Senior BI Analyst (Contractor) Jan 2007 – Dec 2007

●Interviewed and gathered Business Rules and KPI’s from Service Providers ensuring appropriate governance’s and policies are in place for creation of reports.

●Created Queries from scratch in Access Database in preparation for Reports Development.

●Heavily utilized Excel Charts and Pivots Table and Access Database for creation of Director’s Reports.

●Created Power Point presentation of Reports for distribution to Directors, Service Level Providers and Service Managers.

●Types of Reports created: Incident Management, Incident Volume, Incident Duration, and Time to Incident Engagement, Time to Incident Restoration, Impact Duration, Service Desk, Mainframe Outages, and Change Management etc.

●Daily Data Entry of Incident Level outages and updating of Excel Spreadsheets for further data analysis.

●Data Mapping of Remedy Ticketing to backend Oracle 11g databases.

AT&T, Atlanta, GA

Business Consultant (Contractor) Feb 2005 – Dec 2006

●Business requirement gathering and functional specification development

●Created Dashboards for Key Stakeholders and Business Users.

●Assist in technical specification development and application testing;

●Systems analysis: Design technical solutions from functional design specifications

●Developed Use Case and Process Diagrams, Functional and Non-Functional Requirements

●Provided support for data quality issues pertaining to Siebel eCRM

●Performed Business Analysis and Data Analysis

●Involved in Data relationships, Data Re-engineering, mappings and definitions

●Developed and adapted technical solutions/options into detailed technical design documents, ensuring all functional requirements are met in the technical design

●Designed and tested changes to software applications to meet both functional and technical requirements; Data Elements and Usage

●Utilized TOAD to query Oracle Database for data analysis and gap analysis for testing purposes.

●Utilized such tools as Visio for data mapping, ERD Diagrams, schema diagrams etc.

●Worked Query Data with drill down analysis and evaluate data quality

●Expert in SQL Querying, Oracle, MS Access and MS Excel

●Acted as liaison between stakeholders and development/quality assurance team

●Involved in writing complex SQL statements.

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

●Data mapping from Source to Destination databases, understood ETL processes and character length and elements involved in ETL processes.

Kaiser Permanente, Atlanta, GA

EPIC Clarity Report Writer (Contractor) May 2002 – Feb 2005

●Responsible for Business Analysis, Data Analysis, Data relationships, Data Re-engineering, mappings and definitions

●Provided training and professional development on new technologies and applications to staff.

●Acted as Liaison/Business Architect between End Users and Technical Staff to gather and define applications processes and requirements gathering for reports creation.

●Provide data architectural leadership in developing enterprise data/process models, and logical/ physical database designs.

●Applied analytical skills to business requests (which are often high-level or lacking in detail) and communicate these business wants/needs in a clear and unambiguous manner.

●Provide data and database development, maintenance, reports development, and production support.

●Participated in IT and Business project to define system requirements.

●Designed developed, implemented complex logical and physical databases across multiple platforms, technologies and computing environments.

●Wrote and Performed application test scripts to ensure the application is performing according to the designer’s specifications and meets customer needs.

●Creation of Dashboards and Scorecards for Upper Management, Doctors and Executives to review on a daily basis.

●Performed Query Data with drill down analysis and evaluate data quality; Data Elements and Usage

●Lead and supported efforts in implementing, testing, and integration of Epic’s Tapestry Healthcare Application within Clarity Database (Tapestry Managed Care Application Modules: QRM, CRM, Resolute, Inpatient, AP Claims (CMS1500 & UB40) and Radiant)

●Creation of Ad Hoc and specialized reports both in Reporting Services, SharePoint Designer 2007, Cognos, Crystal Reports and Epic’s Reporting Workbench within a Teradata Database system and Sql Server 2005.

●Responsible for analyzing the business needs of clients and stakeholders to help identify business problems and purpose solutions.

●Utilized SQL Querying, Visio, Oracle, MS Access and MS Excel

●Performed data mapping from application interface to database and gap analysis of old database environment to new database environment

●Created Test scripts and test plans, performed unit, functional, and regression testing on applications

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

●Created temporary tables and created views in databases for End Users.

●Wrote complex SQL statements in a Teradata database environment for reporting purposes or data mining.

Education and accreditations

Bachelor Degree in Computer Information Systems

●Devry University Graduated: 2002

Certifications:

●Certificate in Database Development

●Certificate in Business Objects Universe Development 2008

Training:

●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

Military Service

●United States Army, Specialist 4(P) from February 1982 to December 1986



Contact this candidate