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