Sylvia M. Thornton Owes

ad3dcr@r.postjobfree.com

817-***-****

Certifications

Data Science Analytics Certification (in progress)

Certified Mediator

Certified Mediator (Dispute Resolution, Arbitration, Conflict Resolution)

Scrum Master Train

HITECH Certification

TTools

Balsamic

HL7

LOINC

SNOMED

JIRA

TFS

RALLY

SQL

ETL

JSON

Rally

Squirrel SQL

Tableau

Ab Initio DQE

Pentaho Report Design

Pentaho Data Integration

SSMS

Teradata

Oracle

PostgreSQL

HP ALM

Microsoft Office

Education

MS Healthcare, MSHCI Grand Canyon University Phoenix, AZ 2013

BS Computer Science

University of Dayton, Ohio 2010

Qualifications

●IT Consultant System Analyst with over 12+ years of experience performing analysis of business processes.

●More than 2+ years of experience leading business analysts and project teams at Healthelink, Lumeris, Community Health Services and State of Missouri.

●Ability to effectively communicate across multiple levels (executive sponsors to team members); Ability to communicate technical issues to non-technical individuals.

●Experience in creating Wireframes using Balsamic

●Experience in Data Modeling and Data Mapping for application data structures

●5 +years working with Health Level Seven (HL7) Ver 2.3, 2.4. Experience in working with healthcare data exchange formats such as XML and CCD documents.

●Knowledge working with healthcare data standards such as LOINC and SNOMED.

●Knowledge and experience with Agile methodologies. Experience in Agile Testing Environment. Agile development tools (TFS, JIRA, RALLY, Highmark Change and Configuration Management).

●Proficient in SDLC (Waterfall) procedures from basic design procedure to intricate testing in UAT, System, QA, and implementation phases.

●Thorough understanding of HIPAA regulations to ensure that data privacy and security provisions are being utilized appropriately to Safeguard medical information.

●Use SQL as the preferred tool for analyzing data and injecting dat from May different data sources

●Project experience with systems that leverage data from multiple sources across an organization.

●Extensive experience with systems that leverage data from multiple sources including working with data analytics using Data Analytics and Data Integration tools.

●Deep understanding and adoption of Data Quality and Metadata. Experience in data mining, and data transformation/manipulation.

●Knowledge and understanding of data governance challenges and approaches: metadata, data quality and data stewardship.

●Building analytic measures on populations and writing programs to calculate healthcare results.

●Experience with ETL programming, database analysis and reporting.

●Experienced in delivering business solutions to support the strategic directions of organizations by participating in major installations, upgrades, conversions, and GAP analysis.

●Experience in developing complex SQL logic for BIG DATA

PROFESSIONAL EXPERIENCE

EVOLVE, CA 05/2023-06/2023

System Analyst

●Short term contract which involved developing wireframes for an UI pharmaceutical application.

●Modified the existing Functional Design Spec (FSD) to describe the functionality of each wireframe being added.

●Developed user stories to define the functions that will be needed base on the FSD.

HIGHMARK HEALTH, PITTSBURGH (contract though Insight Veteran Sourcing) 12/2021-9/2022

System Analyst

●Extensive experience and knowledge of source-to-target data mapping and data modeling processes for a large Dental project in which initial claims data coming from an IBM data file and converting the information from a X12 format to a excel spread sheet in order to identify the information that would be map to a TERADATA database.

●Developed working specifications for developers to move denormalized data to normalized.

●Created or modified specific tables and developed sql script on the Oracle and Teradata platform to load the tables with the claim data in a temporary workspace prior to the data being loaded into production.

●Utilized the Mainframe as the main source to obtain claim information for dental, medical and Rx to build worktables into Teradata/Oracle

●Work with data warehouse for maintaining client information.

●Identifying and developing recommendations for business process and workflow issues for new clients onboarding.

●Developing test cases of QA testing

●Developed. Business Requirements and Technical Requirements for the purpose of bringing on new clients.

●Extensive SQL development on Teradata platform and Oracle platform

●Work with Product Owner to identify the product requirements for the development team and create user stories for the backlog which will be prioritized based on a set of customer requirements

●Performed gap analysis on in coming data on an ORACLE platform using SQL

●Develop QA and User Acceptance Plan (UAT) document for testing and business.

●Conduct JAD with business and other stake holders to capture the requirements.

●Participate in requirement gathering sessions and document requirements /functional specifications.

TRANSAMERICA, DES MOINES, IA (contracted through Apex Systems) 5/2021 – 6/2021

System Analyst

●Act as the liaison between IT capabilities and business objectives to facilitate, manage, and prioritize improvements through process

●Conduct in-depth analysis to interpret and recommend best solutions to align IT and business initiatives.

●Developed user stories and conducted peer views based on requirements.

●Work with data warehouse for maintaining client information.

●Participated in, or facilitated, sprint planning meetings, sprint reviews, retrospectives, and assisted in backlog grooming.

●Experience and knowledge of source-to-target data mapping and data modeling

●Participate in requirement gathering sessions and document requirements /functional specifications.

UNITED HEALTH, RALEIGH, NC (contracted through ApexSystems) 11/2020 – 5/2021

System Analyst

●Work within the Agile team to craft high quality API user stories for user interfaces by understanding developer’s and business needs.

●Hands-on experience with grooming backlogs prioritizing and evaluating the work generated by software team.

●Experience with Agile issue tracking in Rally

●Play a leadership role by preparing End 2 End Testing for production implementation.

●Develop test plans for quality testing.

●QA/UAT and Operational Readiness

●Develop QA and User Acceptance Plan (UAT) documents for testing and business leads.

●Participate in quality management reviews of the designs and prototypes requirement under Microsoft AZURE environment to ensure requirements were full filled

WELLS FARGO, DALLAS TX contracted through (Apex System) 02/2019 – 09/2020

Senior Consultant (contract)

●Worked on the E1 project that focused on centralizing the many data marts throughout Wells Fargo into one big data lake.

●Responsible for transforming the raw data available into developed, enriched, and polished information for the data lake.

●Involved in the processing of ingesting many data sources into a data lake.

●Managed a team of developers and users using agile methodology to move data into a HADOOP environment.

●Help ensure that standards were met, and secure development practices were adhered to doing the Systems Development Lifecycle (SDLC) based on the following (Training, Defining, Designing, Developing, Testing, Deploying and Maintaining

●Worked with development teams to assist in resolving compliance issues that prevented an application from being deployed into a production environment.

●Ensure Data Governance standards are incorporated.

●Supported the Software as a Service (SAAS) model environment.

●Provided analytical reporting to management staff base on the data generated on Application defects.

●Identified problem within General Ledger accounts, determined root cause analysis, investigated information, performed impact analysis, and formulated, executed plans to develop solutions.

●Issue resolution - Proactively troubleshoot data quality issues by identifying the root cause of data discrepancies and determining and implementing recommendations for resolution.

●Responsible for creating a SharePoint site to manage General Ledger variance issues for users and stakeholders to view.

●Developed job-aided documentation and operational manuals for the SharePoint site.

●Assisted in UAT testing on data products that were being loaded to the Data Lake for production consumption.

●Wrote test cases and test scripts for acceptance testing purpose.

●Responsible for supporting specific data domains and data quality domain managers that were identified as moderate to high-risk scope and complexity based on Data Governance requirements.

●Responsible developing and updating data dictionaries according Data Governance requirements.

●Worked as a liaison among stakeholders to elicit, analyze, communicate, validate and document requirements for data quality, policies and information systems. Also worked to produce project artifacts that satisfy project objectives including running data reports related to Regulatory Risk.

●Created documentation related to data mapping, data profiling, data mining, data cleansing.

●Develop user stories in JIRA for future sprints.

●Application usage included Ab Initio DQE to perform data quality, profile data and Tableau to create data quality rule status reports.

CENTENE, AUSTIN TX 04/2018 – 02/2019

Senior Analyst

●Provided advanced analytical support for business operations in all or some of the following areas: claims, provider data, patient data, clinical data, pharmacy, and external reporting.

●Extracted, loaded and reconciled large amounts of data across multiple system platforms and source.

●Reviewed data to determine operational impacts and needed actions; elevate issues trends, and areas for improvement.

●Developed reports using Teradata and Oracle that were delivered for management.

●Performed root-cause analysis of data irregularities and presented findings/proposed solutions to leadership.

●Developed complex SQL reports for state compliance purpose in Oracle and Teradata platform.

●Maintained and performed troubleshooting of existing scripts and reports developed using SQL and Excel.

●Ensured compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis.

●Performing data modeling for Medicare data when r new clients were onboarded.

●Assisted in reading and interpreted standards / requirements and / or technical specifications in order process CMS STAR rating and HEDIS rating properly prior to uploading the NCQA.

●Experience and knowledge of data mapping and data modeling processes

HEALTHLINK, Buffalo, NY (CONTRACTED THROUGH CTG) 09/2017 – 04/2018

Senior/Lead Analyst / Data Analytics Analyst

●Worked with provider data, patient data, clinical data, and external reporting. Identified and assessed the business impact of trends.

●Overseed a small group of business analyst to ensure daily process were carried out

●Extracted, loaded, modeled, and reconciled large amounts of data across multiple system platforms/sources.

●Developed reports for management using Pentaho Data Integration tool and Pentaho Report Design.

●Modeled data using MS Excel, PostSQL, and data warehouse analytical tools, Kibana and Analytic Data Platform tool. Developed JSON query for data analysis.

●Document requirements based on client’s need.

●Created training documentation and technical design specifications. Assisted with training and mentoring other business analysts.

●Worked with CCDs and HL7 data to ensure that the data lined up with the information presented in Mirth Results. Researched data for patients through MIRTH Results

●Experience with data mapping and data modeling processes

Saga Technology, Dallas, Texas 09/2016 – 09/2017

SWA Dallas, Texas (contract) 06/2017 – 08/2017

Business Consultant IV Expert / Senior Business Analyst

●Participated in a short-term data transformation assignment to help build user stories bac log under an Agile framework, so developers would have enough work and the team could met the deliverables set by the client.

●Created user stories utilizing JIRA.

●Established the interviewing approach and coordinated the interviewing process.

●Interviewed the business community to identify user requirements.

●Reviewed existing documents that may contain requirements or background information

●Documented requirements and assisted in clarifying discrepancies in requirements.

●Prepared requirements documents and obtained appropriate approvals.

●Collaborated with business and ETL resources to define data migration focused business transformation rules.

●Experience with data mapping and data modeling processes

LUMERIS, ST. LOUIS, MO (CONTRACTED THROUGH VERACITY SOLUTIONS, currently closed) 09/2016 – 04/2017

Product Owner / Business Analyst

●Led an initiative to work with business owners, stakeholders, management staff of IT department and developers to reduce the product backlog and developed new workflow processes that would improve how issues are documented and resolved.

●Facilitated daily stand-up meetings with IT Managers to address concerns, issues, and backlog prioritization. .

●Worked with business owners, senior management, and other business units to develop a clear understanding of the organization's business objectives and goals and to understand application performance and customer feedback for continuous product improvement.

●Ensured product vision was understood by all development team members. Translated the business stakeholders’ requirements into a prioritized product backlog which was utilized by development teams.

●Participated in technical logic and design discussions to create user stories and acceptance criteria for the product backlog.

●Managed all new initiatives and prioritization within a project tool, AHA.

●Worked closely with developers and business analysts to ensure that deliverables were met. Escalated items to team lead or managers, as necessary.

●Conducted follow up with end users to ensure successful implementations. Solicits end users for product functionality feedback.

●Provided regularly, verbal, and written status reports for tracking the progress of projects which included backlog tracking. Provided timely communication to the end users.

●Developed metrics that were used to monitor the progress of depleting the backlog.

●Assisted the team with resolving issues and risks that affected the operational processes. Responsible for ensuring that issues involving federal and state regulations and guidelines are escalated accordingly.

●Performed gap analysis on eligibility files that were created in a custom format or X12 format.

●Performed

●Work as a Product Owner to identify the product requirements for the development team and create user stories for the backlog which will be prioritized based on a set of customer requirement

TEKSYSTEM NASHVILLE, TN 10/2015 – 08/2016

CIGNAM NASHVILL TN (CONTract through Teksystems)

Senior System Analysis

●Acquired understanding of NCQA and HEDIS standards and requirements.

●Worked with SQL Server Management Studio for the purpose of doing data evaluation

●Read and interpret standards / requirements and / or technical specifications in order process CMS STAR rating and HEDIS rating properly prior to uploading the NCQA.

●Prepared BRD’s and training documents for QSI.

●Developed SQL scripts to identify errors and resolution for data loaded into QSI within the Oracleeplatform

●Experience and knowledge of source-to-target data mapping and data modeling

Community Health Services NashvileTn(CONTract through Teksystems)

Informatics Management Director / Senior Business System Analyst

●Participated in development planning sessions, weekly team status meetings and create/update appropriate project management documentation as required. Interact extensively with and build strong relationships with vendors, hospital leadership and other IT leaders.

●Worked with team members on system design, functional specifications and developed documents for implementing strategies based upon analysis of specific operational needs.

●Participated in the deployment of McKesson Patient Folder One Content (MPF) and interfaces.

●Responsible for conducting training on McKesson Patient Folder One Content

●Responsible for validating data conversion information from HPF to MPF.

●Performing gap analysis on HL7 feeds being imported into MPF

●Knowledge of the different types of medical records created.

●Responsible for all phase of IT testing and working with new facilities that will be transitioning over to McKesson One Content V16.2

●Experience in Business Process Modeling

●Responsible for setting up users for functionality access for specific tasks within an application. Commonly called user roles.

●Responsible for training of staff DSC/QCI for scanning center

●Worked closely with IT staff for validating ADT feeds coming from downstream ancillary systems.

●Responsible for the testing and validating MPF workflows and the process around the different types of triggers and routing of documents as the flow through MPF

●Performed training for CHS facility staff on MPF functionality as a coder, user, physician and other roles.

●Performed training CHS staff on STAT, which is the document tracking system for medical documents that are being transported from one location to another.

●Provided onsite go-live support

DELL CORP. (contract through RADIANT) 02/2014 – 09/2015

Senior Business System Analyst

●Participated in development planning sessions, weekly team status meetings and create/update appropriate project management documentation as required. Interact extensively with and build strong relationships with vendors, hospital leadership and other IT leaders.

●Participated in process development representing system functionality, consulting with user community on improvement opportunities and liaison between users, IT technical staff and vendor relationships.

●Provided technical analysis and implementation leadership during the full lifecycle of application interface implementation for both HL7 real-time interfaces and batch file transfer interfaces.

●Provide analytical guidance and expertise in developing technical specifications/requirements and documentation for real-time interfaces and batch file transfers.

●Developed training user guides for patient access system, McKesson Horizon Patient Folder (HPF) and Cerner Power Charts.

●Worked with HPF team to identify the HPF ADT feeds that would be passed from upstream and downstream systems.

●Worked with coders to address scanning issues within HPF and correct folders for receiving the scanned documents.

●Assisted users in troubleshooting issues for Power Charts, HPF and 3M/360, Patient Access

●Developed, coordinated, and executed detail QA and UAT test plans, test scripts and test case for quality assurance testing on HP Application Lifecycle Management quality center

●Prepared training materials, conduct user training

●Coordinated conversion/integration for the HIM department at the hospital locations.

●Performed impact analysis.

●Prepared workflow documentation for the hospital workflows using Visio.

●Performed business process modeling.

●Worked with outside vendors on interface engine specifications and developing architecture drawing.

●Provided onsite go-live support.

●Maintained the detailed project schedule through a master schedule, reporting back to the PMO in order to maintain integrity of the schedule.

●Worked with the PMO team to establish milestones and coordinating the effort with the implementation team

●Experience and knowledge of source-to-target data mapping and data modeling

STATE OF MISSOURI (contract) 12/2013 – 02/2014

Business System Analyst / Scrum Master

●Worked on a State of Missouri project as a business system analyst in the area of Medicaid service performing business process analysis.

●Identified, documented and conveyed systems architecture in a SOA Architecture environment

●Analyzed and documented systems to determine how functionality supports State requirements for business transactions and processes and ensuring compliance; possess an in-depth knowledge of State operations and its corresponding system supports those operations.

●Critically evaluated information gathered from multiple sources, reconcile conflicts, and decompose high-level information into details that the team can easily comprehend.

●Participated in design and development meetings with project teams to provide perspective on the needs of the business users and help to resolve issues arising during the project.

●Assisted in the design of the data integration strategies and methods for developing a data warehouse from several normalized databases.

●Worked with developers to identify data mapping of legacy data to current data model by utilizing excel spreadsheet developing technical requirement documents.

●Monitored and assisted the efforts evolved for ensure that all issues were addressed during the development phase for building the data warehouse.

●Reviewed informatic processes to ensure that it would execute repeatable and be reusable for the fast and effective provisioning of test data to support release and project schedules

●Facilitated ongoing meetings with developers to ensure that any issues and concerns were acknowledged and addressed during the development phase of the project.

●Worked with software developers and other end-users to ensure technical compatibility and support of the system requirements and technical specifications.

●Experience and knowledge of source-to-target data mapping and data modeling

●Assisted in the performed build, tested and deployed activities in an agile environment.

●Lead overall ETL processes and architecture, performed build, tested and deployed activities related to BI and data warehouse implementations

●Developed use case, user stories and test scripts for CURAM health care application and interface processing using JIRA.

●Translated client requirements into concise, highly technical specifications and serve as a technical resource to explain the requirements in technical and non-technical settings.

●Used SharePoint as a repository of documents.

●Facilitating and leading discussions with software developers during the development process to respond to feedback and questions from developers.

CAMBIA HEALTHCARE(contract) 08/2013 – 12/2013

Sr. Business System Analyst

●Worked on the Health care Exchange project under the Affordable Care Act.

●Responsibility included gathering requirements to implement an auto load process that would capture providers submitting claims who were not currently a participating provider within an insurance network.

●Worked with a payer system to streamline for the purpose incorporation into the Healthcare Exchange project.

●Facilitated structured requirements sessions to elicit requirements, process flows, data flows, business rules, risks and assumptions.

●Assisted in the design of the data integration strategies and methods for developing a data warehouse from several normalized databases.

●Worked under an Agile Methodology to create user stories for the purpose of outlining the development processes.

●Used Rally as the repository for storing all documents and user stories.

ITT-TECT, Arlington, Texas 04/2013 – 08/2013

Part-Time Adjunct Teacher

●Planned, course instruction based on the approved syllabus/course outline provided to assure course content and learning objectives are met

●Designed, administered, and graded examinations to assess achievement of course objectives as identified in the syllabus and as approved by the Academic Dean.

●Utilized various teaching styles and methods to accommodate diverse learning styles of students

●Conducted tutoring sessions to help improve the understanding of class material

United Health Care, Dallas, Texas 05/2012 – 04/2013

Sr. Business Analyst /Technical Project Manager

●Used Oracle server to write SQL scripts to perform gap analysis on HL7 VER 2.4 messages that were sent outbound through a Cloverleaf Secure Courier or Iguana interface engine. Validated results against client specification interface.

●Developed SQL queries for reporting

●Worked in the business analysis phase of the system development cycle and consulting with users to define business processes and the information systems that support those processes in the client implementation phase. Extensive client analysis to prepare detailed specifications used in the Systems Analysis function.

●Assisted in the creation of UAT plans.

●Supported the Software as a Service (SAAS) model environment.

●Worked with clients to identify different HL7 Ver 2.4 feeds that are sent inbound and outbound to Epic, McKesson, and Meditech and Cerner ancillary systems.

●Knowledge on HIPAA EDI Transactions like 837, 835, 834, 277, 299

●Performed gap analysis of HL7 data feeds from various Epic, McKesson, Meditech and Cerner modules.

●Created data flow diagrams that depicted future interface specification for describing details of inbound and outbound data for Epic, McKesson, Meditech and Cerner.

●Liaison between developer and customer to address questions regarding data mapping.

●Worked closely with hospital clients to deploy software to client sites.

●Interacted with team members such as Project Manager, Technical Assessment Team Engineering Team and customers.

●Worked with clients to ensure compliance with regulatory requirements such as, HIPPA, etc., as well as internal policies and processes.

●Used Team Foundation Server (TFS) as a repository for scrum documentation.

●Derived current and future state data flow diagrams.

Premera Blue Cross 05/2011 – 03/2012

Business Analyst/Data Analyst

●Designed, developed, configured, and tested changes to ETL process and created business statistical analysis reports using SQL*Server Management Studio a Oracle platform.

●Utilized SQL*Server Management Studio for creating tables and importing data from an XML format file into the tables.

●Worked closely with Technical SME's to help facilitate requirements gathering sessions, reviewed input from SMEs and wrote detailed requirements for all aspects, including data mapping, application dependencies, and procedural changes required of those using the test environments

●Involved in the installation of Camouflage application used for masking the sensitive data in healthcare based on the HIPAA Privacy rules and HIPAA Security Act.

●Responsible for the development of business requirements for an eBusiness project which include Ecommerce project using Agile/Scrum methodology.

●Developed business requirements and technical requirements for converting transaction records from 4010 to 5010.

●Used Team Foundation Server (TFS) as a repository for Scrum documentation build and HP Test Director for developing test cases and test scripts.

●Assisted in the design of wireframes for Ecommerce initiative.

●Worked with other departments to help prioritize projects and assist in developing accurate User Stories in support of the development cycle and employ scrum teams to implementation of the user stories.

●Responsible for reviewing data structure for Siebel (CRM) system, FACETS (health care billing system), Provider Information Management System (PIMS) in order to identify the personal healthcare information (PHI).

●Used SQL*Server Management Studio to conduct data analysis for existing sensitive data with all environments.

●Utilized Visio to develop a descriptive architecture and functional document of the company's process in order to understand and communicate new processes with the client.

●Assisted in release management duties in regard to managing, planning, scheduling and controlling software build through different states and environments.

Contact this candidate