Lisa Ogle

**** ******** **., *********, ** *****

Cell: 615-***-****

Email: adgu5n@r.postjobfree.com

EDUCATION:

MBA/TECHNOLOGY – University of Phoenix, Nashville, TN

Graduated 2007

BACHELOR OF SCIENCE – Tennessee State University, Nashville, TN,

Graduated 1998

CERTIFICATIONS:

Certified Scrum Product Owner®

20190330

20210330

SUMMARY OF EXPERIENCE

HealthCare industry since 2001, Agile and Waterfall Methodologies

11 yrs. Technical Business Analyst, Data Analyst

Understanding and moderate query abilities with Relational Databases

Product Owner Clinical Data for Corporate Warehouse

Relational Database experience with Teradata SQL, SQL Server, Oracle SQL Developer, Toad, Access, SAS, Microsoft Office – Word, Excel, PowerPoint and Visio, Excel formulas, Pivot Tables and V-Lookups

SDLC Implementations and Integration, Creation of Functional and Non-Functional requirements

User Stories, UAT Testing, QA Testing

Work Experience:

JDC-GROUP, Client – Nissan North America Corporate, Franklin, TN

Senior Technical Business Analyst

February 17, 2020 - Present

Digital Parts Analyst

Participate Daily Scrum

Track Parts Activity via SQL Queries

Review Discrepancies with Team and Business Partners

Resolve Technical Issues working with IT and Business Partners

Validation reviews for any issues associated with resolutions

Testing and Participate with implementing new vendors

Track trends in Parts Activity discrepancies via creating custom reports

Tools used Oracle SQL Developer, MS Access, Excel

Create SQL to monitor Parts Activity Issues

Create Excel spreadsheet tracking trends using VLOOKUP’s and other excel formulas

POPULUS STAFFING, Client - Change HealthCare, Nashville TN

Technical Business Analyst CPSO Consultant

October 23, 2019 to January 31, 2020

Dental Ops Division

Credential Manager Software Implementation Project

Work with Business for Functional and Non-Functional Requirements

Map data for Electronic Submission and Requirements

Gather Requirements for Dashboard Data for Overview of “In Network Payer/Provider View”

Create Data Dashboard Mockups

Participate in Meetings to refine requirements

Work with Team on execution plan for delivery

Work with Business to assess reporting requirements and needs

Used PostgreSQL querying data creating reports

Map Data for reporting based off requirements

Familiar AWS Cloud

EMIDS TECHNOLOGIES, Franklin TN, Technical Business Analyst – Consultant

May 14, 2019 to August 9, 2019

Business Analyst for Provider Database Project

Business Analyst for Recruiter System Project

Mapping Data from existing source to new Data Source

Data Profile using DBeaver

Validating Data using SQL Server and SQL Developer

Requirement Gathering

Documentation for Business Processes

Scrum Meetings

Work closely with Developer to present requirements for development

AWS

CIGNA HEALTHSPRING, Nashville TN (Partial Remote), Technical Support Senior Advisor

March 26, 2018 to April 20,2019

CCMS Letter Coordinator

Used SQL Server to validate Data

Intake New Letter Requests

Open HPSM Tickets

Create Change Requests

Work with Business Owners on Changes, New Requests and Updates

Maintain Several Excel Tracking Documents

Maintain Folders with all artifacts of letter changes or creations along with all correspondence

Coordinate with Deployment and Development UAT Testing and Promotion to Production

CIGNA, Bloomfield, CT, Information Informatics Specialist

(Remote Nashville, TN) January 2015 to March 25, 2018

FDS Behavioral Core, EDM Factory Model Capacity Analyst, (Post Re Org),

Factory Model Business Analyst for UMCM Clinical CCW Enterprise views

Work with development team to prepare views for Enterprise use

Create and maintain View Crosswalks

Data Dictionary-Data Mapping

Book of Business Testing

Host Meetings for SME Testing

Create CBT Training for Views

Requirement Gathering

Used Teradata SQL for Data Validation in CCW

CIMA BUSINESS SUPPORT, Bloomfield, CT (Remote Worker), Product Owner, Clinical SME

UMCM Clinical Team

SME on UMCM Clinical Data for CCW

Mapping Data from legacy to new

Supported Reporting Teams gathering and prioritizing Reporting needs for Operational Reporting, Dashboards, and CAC Reports etc.…

Created Tracking process for ensuring all Clinical Code Sets are processed as needed via ECSM or Reference Tables and submitted properly.

DATA mapping from Legacy to Source for new data warehouse build

Used Teradata SQL and Toad for data validations

Assisted with User Migration and Factory Model

Numerous other duties as needed

Assisted with CBH (Cigna Behavioral Health) Gathering data and requirements for CCW mapping data from Hadoop to new tables in CCW

Used Hive to validate data in Hadoop

Cigna Corporate Warehouse Project (CCW)

Product Owner for Clinical Team (Utilization Management and Care Management)

Define, Size and Prioritize User Stories

Create Backlog for Sprints

Gather Requirements needed for Table Builds from Business

Research Stories and Information needed for completing stories

Ensure Artifacts are uploaded into Rally and documentation is available as needed

Attend Daily Scrum Team Meeting to monitor progress and address any issues

(Our Team consisted of Scrum Master, Product Owner, Business Analyst, Systems Analyst, Developer and Offshore QA Team). We were responsible for bringing in and building tables to house the clinical data.

Participate in Sprint Planning, Product Demos, Sprint Reviews

Liaison on PMC Council responsible for reporting team progress to a variety of stakeholders and other Scrum Teams

Experienced with Agile and Agile software

Assisted with any blocks impairing the Team to ensure our goals were met each Sprint.

Communicate and collaborate constantly with multiple partners at multiple levels

Used Teradata SQL for Data Validation

IT Consultant, Technical Business Analyst, Consultant, Nashville, and Franklin TN Area,

March 2013-November 2014 (CHS, Teknetex, Cigna Health Spring)

Senior Business Analyst on Meaningful Use Certified Data Warehouse Project

Evaluate Business Requirements and create technical specifications for Developers

Review Facility Readiness Report and assist developer with incorporating Stage 2 into Reporting Requirements

Meet with SME/Business Owner of Organizational Reports act as liaison between Owner and Dev team.

Write Functional Business Requirements for Data Informatics Team

Data Mapping for SSRS report requests

Write report Specifications

Create Proof of Concept for Business User Approval

Use SQL Query Server to analyze current reports and define gaps

Learn Database Systems, as needed for data analysis and queries

Assist with SSRS Packages, troubleshoot existing reports

Migration Project of 200 reports from one server to new Production Server

Update RDL changes as requested

Systems Sources used ODS, CCMS (McKesson Care Manager System), QNXT

WINDSOR HEALTH, Clinical Systems Analyst Brentwood, TN, February 2012 – March 2013

SDLC Care Manager System Implementation

Work with SME’s and Vendor to Validate Data and Requirements

Map Business Process

Define Gaps in Processes

Create Use Case Scenarios

Perform UAT Testing on System

System support for End Users Health Services Case Management

Monitor and log Defects

Document Functional and Non-Functional Requirements

Case Management Reporting creating ad hoc as well as re-writing from existing reports from a variety of sources using a variety of Reporting Applications (SQL, Biz Obj, MS Access, Excel)

Analyze data for Medicare and Medicaid for CMS reports

Document Letters for Compliance that are used process through Comply Track, IT and Fulfillment

IT Consultant, Technical Business Analyst, Consultant, Nashville, and Franklin TN Area,

December 2009- February 2012

Working as liaison for offshore team located in India (training and helping to set up communication and SOP processes for Provisioning and Helpdesk Support)

Onsite Coordinator for project to offset Provisioning and Support of McKesson Applications

HEDIS Reporting, troubleshooting current reports, reworking reports for Crystal Reports 2008

Trouble Shooting Database Issues with MS Access and other Reporting Issues as needed

Training on Provisioning Roles, and Permissions for HPF, HPP, HMM, HLAB

Set up client environments for testing of 5010 Claims 837P, 837I and 835 Submitter Claims; Use Unix based systems to pull files and review reports

Liaison between Customer and Emdeon

Meet and Map process for Clients to Business Process

Participant on Team meetings to review and create SOP Flow for testing

Set up Testing processes and UAT Testing

Technical Business Analyst on Pharmaceutical Returns Project. Participate in Project Team meetings and IT Project Team Meetings.

Gather use case scenarios and requirements for documentation workbook (High Level, Detailed and Business Rules) from end users, and project team coordinators.

Member of the Training and Validation team responsible for Creating OQ, PQ test scripts and assist FDA Validation team with information for their tests as well.

Analyze goals and improve processes working as a member of the Black Belt Team.

Pull data and reports needed using WINSQL

Create POC for testing and mock run through of system

Contact this candidate