Robert M. Ebel
New Market
Summary
Senior IT Professional specializing in Business and Systems Analysis, Product Ownership, Project Management, and Software Development. Extensive collaboration with stakeholders, software developers, and customers on software development and data analytics projects. Experience spans multiple industries including FinTech, Payment Processing, Software Services, Healthcare, and Government.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Business Systems Analyst
GainWell Technologies
Irving
04.2023 - Current
- Elicit user requirements by conducting brain storming sessions for the GainWell Medicaid claims.
- Write User Stories using Azure DevOps pertaining to the client request for new implementation files.
- Meetings with the business stakeholders, SME’s, testers and development teams.
- Create SQL queries to investigate claim status for inclusion into the user stories;(ServiceNow)
- Conducted System Integration Testing (SIT), User Acceptance Testing (UAT) and developed test conditions and test cases.
- Recommendations on how to automate existing Excel spreadsheets using macros.
- Provide Visio diagrams to identify client customization flows.
- Data mapping, transformation, data cleansing and test script development.
- Collaborate with cross functional teams to coordinate client integrations and requirements approval.
- Create reporting from SQL Server (SSRS) for Medicaid claims analysis.
Business Systems Analyst
Horizon Blue Cross Blue Shield
Newark
04.2022 - 04.2023
- Gathered business requirements and met with business stakeholders, SMEs, and Developers for NovaWell behavioral healthcare project.
- Developed SQL queries as a prototype for inclusion into user stories.
- Conducted meetings with the credentialing vendor for technical requirements.
- Created Visio workflow diagrams and Technical Requirements documents.
- API customization including data mapping with testing and documentation.
- Gathered business requirements for the UBYP, Spanish Surveys, and SundaySky projects.
- Met with business stakeholders, held daily standup meetings, and addressed the product backlog in an Agile/Scrum environment.
- Provided technical and business analysis for reporting irregularities and created a new reporting dashboard.
- Managed the priority of projects and allocated Developer workload.
- Developed SQL queries as a prototype for inclusion the user stories.
- Updated Visio workflow diagrams related to production as well as user stories and features into Rally.
- (Contract)
Business Systems Analyst
DENSO Manufacturing
Alcoa
02.2022 - 04.2022
- Created financial dashboards and analyzed datasets in Domo BI (SaaS), Adobe Workfront (WFM) software, and SQL Server.
- Gathered report/dashboard requirements for BOM (Bill of Material) data.
- Documented and analyzed the project request board for prioritization and clarity; met with stakeholders to review project requests.
- Workfront data analysis and problem resolution recovery.
- (Contract)
Systems Analyst/Product Owner – Operation Business Solutions
ABB Optical
Coral Springs
07.2021 - 12.2021
- Researched, documented, and analyzed marketing and sales data from the Sales Strategy system.
- Gathered requirements from Executives to automate sales reports.
- Wrote user requirements and reviewed with Developers.
- Administered HubSpot CRM to add users, research data for analytical reports, and monitor workflows.
- Managed the Digital Price Monitor weekly reporting.
- Worked on automating the Verify reports to reduce the manual labor to maintain reports.
- Responsible for researching a vendor offering a lesser expensive software for conducting surveys.
- Develop market and financial reporting using PowerBI.
Business Systems Analyst – Virtual Strategy
East Tennessee Children’s Hospital
Knoxville
04.2021 - 07.2021
- Managed the Virtual Strategy implementation for telemedicine products, TytoCare and Teladoc.
- Gathered requirements for TytoCare School Program and performed training, testing, and implementation.
- Met with stakeholders for new requirements pertaining to individual practice.
- Provided training to users of the TytoCare equipment.
- Developed Physician status reports, Director feedback, and updates on the program.
- Maintained project segments using eProject software.
- Developed PowerBI reports for Teladoc patient visits and maintained MS Access database for school/clinician scheduling.
Product Owner / Project Manager / Business Analyst
Elavon / U.S. Bank
Knoxville
06.2015 - 10.2020
- Obtained Safe Certified 4.5 Product Owner/PM and Lean Green Belt pre-certification.
- Worked on domestic/foreign projects using Agile / Scrum.
- Projects incorporated a variety of systems with involvement in mapping using Visio.
- Produced high-level business requirements, functional design documents, Visio process flows, Gantt charts, data models, and more.
- Worked on a project involving Salesforce CRM to analyze data, modify parameters, and test.
- Performed requirements gathering from end users and Developers.
- Develop reporting for the Trips application thru PowerBI.
- Peoplesoft financials working with requirements gathering, analysis, meetings and prioritization of stories.
- Worked on projects involving card brand management, EDI financial transaction processing and Axis encryption/decryption.
- Analyzed ACH records and digital transaction processing from merchant terminal thru credit card product transmission.
- Managed projects through SDLC from initial requirements gathering, assignment of stories, testing, and implementation.
- Scheduled and hosted discovery meetings with stakeholders, Managers, and Developers.
- Served as Product Owner for Trips Airline System for cost analysis, reporting, airline ticket analysis, and documentation.
- Held product backlog meetings including SME’s, Business, and Developers.
- Managed Trips airline stories and Appstream application stories (VersionOne).
- Coordinated Development team testing, development, and integration (local/offshore).
Business Analyst
AllMeds
Oak Ridge
10.2014 - 06.2015
- Supported customized medical software to physician offices and clinics.
- Communicated to contracted physician offices and developed implementation plan for conversion.
- Provide reporting, mapping, and program support using SQL Server.
- Developed testing and data mapping based on the customization.
- Develop SSRS reporting for Tennessee State requirements.
Business Analyst
NISSAN
Smyrna
10.2013 - 10.2014
- Work on highly visible project to change the vehicle identification code (VIN) format to ISO standards for compliance with foreign exports.
- Assign individual Detail Design Documents to the programmers and Business Analysts for review.
- Review the Detail Design Documents for any corrections and coordinate program changes with offshore development team (India).
- Research program code for corrections to the Detail Design Documents and modify / define the test cases.
- Contact the business users and assist them with reviewing the Detail Design Documents.
- Meet with users and business owners to discuss system testing and changes.
- Maintain meeting minutes for Unit Acceptance Testing (UAT) and System Integration Testing (SIT).
- Recommend system integration changes.
- Meetings to strategize testing procedures and Business Analyst responsibilities.
- Verify Detail Design Documents (DDD) and Unit Test Requirements (UTR) status to the Tracking Spreadsheet that is used to monitor status, dates, and assigned Business Analysts.
- Maintain a report listing of the new call module parameters.
- Maintain a functional specification document outlining the code researched in each program.
Education
Bachelor of Science - Business Administration
Carson-Newman University
Jefferson City, TNAssociate Science - Computer Science
Allegheny Community College
Skills
- User requirements gathering
- SQL development
- System integration testing
- Data mapping
- Reporting and analytics
- Agile methodology
Certification
- SAFE Certification Product Owner / Product Manager
- Lean Green Belt pre-certification
Military Service
U.S. Naval Reserve, Knoxville, TN, Second Class Petty Officer – DP2 (Honorable Discharge)
Timeline
Business Systems Analyst
GainWell Technologies
04.2023 - Current
Business Systems Analyst
Horizon Blue Cross Blue Shield
04.2022 - 04.2023
Business Systems Analyst
DENSO Manufacturing
02.2022 - 04.2022
Systems Analyst/Product Owner – Operation Business Solutions
ABB Optical
07.2021 - 12.2021
Business Systems Analyst – Virtual Strategy
East Tennessee Children’s Hospital
04.2021 - 07.2021
Product Owner / Project Manager / Business Analyst
Elavon / U.S. Bank
06.2015 - 10.2020
Business Analyst
AllMeds
10.2014 - 06.2015
Business Analyst
NISSAN
10.2013 - 10.2014
Bachelor of Science - Business Administration
Carson-Newman University
Associate Science - Computer Science
Allegheny Community College