Olanrewaju Abraham

Sr. Business Analyst

Email ID: adqkof@r.postjobfree.com Contact: 469-***-****

Professional Summary

Qualified professional with 7+ years of extensive in healthcare domain and expertise in Software Development Life Cycle including analysis, testing and implementation of software applications.

Extensive knowledge of Medicaid (MMIS), Medicare, Procedural and Diagnostic codes, and Claims Process.

Experience in working with project team in identifying and interpreting state Medicaid and Medicare policies, defined algorithm research & assisted in development of new healthcare analytics.

Experience with HL7, EMR and EHR projects. Expertise in using SQL- Data analysis and reporting.

Expertise in documenting the evaluation test cases, study of various ETL tools like Informatica.

Good Knowledge in generating COGNOS reports using SQL Queries for database management.

Expertise with HIPAA, EDI transaction sets 837, 835, 834, 820, 270, 271, 276, 277, 278, EMR and EHR.

Well versed with ETL process Extract, Transform and Load of data into data warehouse.

Experienced in interacting with business users to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), General system Design, Functional Requirement Document (FRD) and Software Requirement Specification (SRS) across the deliverables of a project.

Experienced tracking, documenting, capturing, and communicating requirements using Requirement Traceability Matrix (RTM) which assisted in controlling numerous artifacts produced by teams across deliverables for a project.

Expertise in SWOT analysis, Risk Analysis and mitigation plan, Cost benefit analysis and ROI analysis.

Experience in configuration of claims adjudication systems, i.e., MMIS, MITS, Facets.

Possess keen knowledge in generating reports in Crystal reports, Excel Reports and Cognos.

Experience in claims processing and Evaluated solutions to reach stakeholder expectations.

Experienced in conducting walkthrough of deliverables, component validation, solution evaluate, requirement.

Experienced in Microsoft Word, Excel, PowerPoint, VISIO, and MS Project.

Expertise in Agile methodology in gather requirements and working with the development and testing team. Produce requirements and system work products including and data flow diagrams, Use cases/User Stories.

Comprehensive experience in Business analysis, Gap analysis, Change Management analysis, Testing Analysis, development of business requirements specifications, and project planning working with project managers and business sponsors.

Expertise in coordinating with the teams distributed at different geographic locations for various releases.

Expertise in identifying Actors, Activities and Workflows and developed use case diagrams using Rational Rose. Prepared use case diagrams and followed Rational Unified Process at every stage of the process.

Experienced in building Unified Modeling Language (UML) diagrams including Use Cases, Activity Diagrams, Sequence Diagrams, Class diagrams, Data Flow Diagrams, and transforming the requirements gathered into functional specifications focusing on Workflow Analysis and Design, User Interface Design, Data flow, Process flow and ER Diagram.

Expertise in developing Test Plan, Test Conditions, and Test Cases ensuring adequate testing of software both before and after completion conducting and documenting UAT.

Extensive experience with OLTP/OLAP System and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional modeling.

Good Knowledge in data Extraction, Transformation and Loading ETL using various tools such as SQL Server Integration Services SSIS and SQL Replication.

Good understanding of Object-Oriented Programming, Data Modeling, Data Mapping and Data-warehousing.

Extensive experience in retrieving data and data validation using SQL queries like Joins, Views, Sub queries and Aggregate functions like max, min, sum, and average with good understanding of Stored Procedures, Functions and Triggers. Expertise in implementing basic SQL queries for testing and data validation.

Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Experience in working with QA team and reviewed their work from time to time to make sure the work done is in alignment with the desired specifications.

Experience in Agile methodology and Programming concepts of system development and fully coordinated Project Scope, RACI activities.

Created Requirements traceability matrix mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.

Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Access.

Strong Knowledge of UML, RUP, Agile Technologies, JIRA, Safe and Rational Requisite Pro.

Technical Skills

Domains

Healthcare, Finance, Retail

Requirement Management

HP ALM, Blueprints, Doors, ERP, TFS

Document Creation/Management

MS Office Suite – Word, Excel, Outlook, Publisher, PowerPoint, OneNote,

MS Project, Adobe Acrobat, Lotus Notes

Content Management

MS – SharePoint

Database Management

MS-Access, SQL, MySQL, Oracle, Erwin, Guidewire, Informatica, ETL, STIBO

Business Modeling

Enterprise Architect, Balsamiq, MS-Visio, Rational Rose, Pencil

Business Intelligence

Cognos, Business Objects, Crystal Reports

Testing

Selenium

Bug Tracking/ Quality Control

JIRA, Rally, HP Quality Center

CRM

Salesforce, Pega, Dynamics 365

Languages

UML, HTML, CSS, XML, JavaScript, APEX, Visualforce

Operating Systems

Windows, Mac OS, Unix and Linux

Other Tools

PeopleSoft, PEGA, and Insurity

Methodologies

Agile-Scrum, Waterfall

Education

Bachelor of Science: Mechanical Engineering Technology, Kwara State Polytechnic, 2008

Certifications

Scrum Master Certification

Certified Service Now Administrator

ITIL v3

Professional Experience

Client: Darisen LLC, Houston, TX June 2019 – Till Date

Role: Sr. Business Analyst

Responsibilities:

Assisted in developing tailored enterprise architectures that are fully consistent with CMS requirements.

Participated with others in the planning, development, implementation, maintenance, and evaluation of business application systems as assigned.

Assisted in interfacing EMR system with decision support analytics that summarize patient profiles.

Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases. Work independently in the development, testing, implementation, and maintenance of systems of moderate size/complexity with a fast turn-around.

Involved in implementation of EDI Transactions (835,837) and facilitated Electronic Data Interchange.

Worked on EDI automated first-pass claim adjudication, requiring thorough understanding of claim processing, both front and backend operations.

Designed and documented Business Process Re-engineering, Business Process Modeling, Historical Data Reports Analysis accompanied by conducting and facilitating elicitation sessions such as questionnaires, Interviews sessions, Brainstorming sessions, Focus group sessions, Requirement workshops, Interface analysis, Document analysis, and JAD sessions with internal as well as external stakeholders

Proficient in authoring Project Charters, Business Requirement Documents (BRD), Functional Specifications Documents (FSD), Software Requirement Specification (SRS), Use case Document, and Software Design Specification (SDS).

Performed HL7 standards analysis and documented the enhancements to meet the end state requirements.

Created data model diagrams to perform detailed data requirements analysis and create design specifications and operational documentation. Creation of Test Scenarios for approved business requirements.

Expertise with QNX Claims Workflow (HCM), for claim pricing, member administration and billing management.

Reviewed MMIS documents to understand the customer requirements.

Performed Gap analysis between customer requirements and the MMIS solution.

Reviewed Unit testing results, creating Test Plan, performing System Testing, Partner Plan Testing, and supporting User Acceptance testing.

Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process.

Gathered technical requirements form development for testing Agile methodology.

Gathered Requirement from the Client to fulfill the Application need for FACET Implementation.

Created Implementation plans and post implementation activities.

Planed and controlled of the testing activities and tasks.

Identified gaps between standard FACETS functions and client requirements to write requirements for FACETS extensions

Environment: MS Office, JIRA, SharePoint, Agile-SCRUM, MS-Visio, SQL, STIBO STEP, Balsamiq, Confluence

Client: Agilent Technologies, CA Nov 2017 – May 2019

Role: Business Analyst

Responsibilities:

Conducted requirements gathering meeting for all extracts with business team.

Created FRD by mapping requirements back to system tables and fields with appropriate logic.

Collected HEDIS data through surveys, medical record audits, and claims data.

Worked with the MMIS application development team on dependencies with the ongoing project.

Involved in reviewing MMIS documents to understand the customer requirements.

Performed Gap analysis between customer requirements and the MMIS solution.

Worked with technical engineering team and other stakeholders in creating data mapping documents to gather data from various sources and match with output field layout.

Scheduled, Facilitated, and managed JAD sessions with business team members.

Worked with PM in making the Project Charter describing the business need of the project and reviewed the scope document and provided inputs. Utilized ETL to work with various databases and Data Modeling.

Performed GAP analysis to derive requirements for existing systems enhancements.

Conducted detailed and comprehensive business analysis with the Agile methodology.

Worked with Data Architects and ETL Leads and was responsible to perform detailed data requirements analysis and create design specifications and operational documentation.

Organized requirements into High level Use Cases and Low-level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using MS Visio.

Collaborated with vendor teams to resolve various issues with being faced by development teams.

Created data mapping to increase efficiency of data usage for transactional and analytical processes.

Worked within project team to identify and interpret state and Medicare policies as applicable to customer defined algorithm research as well as assist with internal development of new healthcare analytics.

Used SQL to generate day to day reports end using the Share Point viewer.

Collaborated with Development and QA team to review User Stories and answered regarding requirements.

Worked closely with QA team on UAT and reviewed their work from time to time to make sure the work done is in alignment with the desired specifications.

Served as single POC for reporting related queries/concerns.

Resolved P&L discrepancies through daily interaction with Front Office, erroneous trade bookings investigation and internal allocation charges.

Created Requirements traceability matrix mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.

Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Access.

Created RTM for the project to ensure that all requirements defined for a system are evaluated.

Environment: MS Office, JIRA, SharePoint, Agile-SCRUM, MS-Visio, SQL, Salesforce, informatica, Team Foundation Server, Guidewire Claim Center

Client: McKesson Specialty Health, AZ July 2015 – Oct 2017 Role: Business Analyst

Responsibilities:

Assisted in developing tailored enterprise architectures that are fully consistent with CMS requirements.

Assisted in interfacing EMR system with decision support analytics that summarize patient profiles. Domain

Directed and participated with others in the planning, development, implementation, maintenance, and evaluation of clinical or business application systems as assigned.

Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.

Involved in implementation of HIPAA EDI Transactions (835,837) and facilitated Electronic Data Interchange.

Experience in EDI automated first-pass claim adjudication, requiring thorough understanding of claim processing, both front and backend operations.

Utilized ETL to work with various databases and Data Modeling.

Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Worked closely with Data Architects and ETL Leads/Managers and was responsible to perform detailed data requirements analysis and create design specifications and operational documentation.

Created data model diagrams to perform detailed data requirements analysis and create design specifications and operational documentation.

Reviewed MMIS documents to understand the customer requirements

Performed Gap analysis between customer requirements and the MMIS solution.

Development and Test team coordination on solution implementation.

Creation of Test Scenarios for approved business requirements.

Reviewing Unit testing results, creating Test Plan, performing System Testing, Partner Plan Testing, and supporting User Acceptance testing.

Creating Implementation plans and leading implementation and post implementation activities.

Planning, monitoring and control of the testing activities and tasks.

Understanding of Software Development Life Cycle (SDLC), Rational Unified Process (RUP), Agile/Scrum methodology, Object Oriented Analysis and Design Concepts (OOAD), Business Process Re-engineering (BPR), Test Lifecycle, Data Modeling.

Worked closely with Product Manager, System Analyst and Development team to sign off feature file test cases as part of Agile ATDD (Acceptance Test Driven Development) process.

Opportunities to adopt agile process earlier than scheduled and Adhere to Agile Methodologies through entire software development process.

Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process.

Participated in all phases of the SDLC in Agile and Waterfall environments.

Gather technical requirements form development for testing Agile/Waterfall methodology.

Environment: MS Office Suite – Word, Excel MS project, Microsoft Visio, Microsoft Share Point, Cognos, UML, JAD, GAP, PL/SQL, Agile Scrum, Jira, PEGA

Client: Express Scripts, NJ Dec 2013 – June 2015

Role: Business Analyst

Responsibilities:

Created an in-depth understanding of client business strategy, operations, and requirements.

Directs and completes the analysis of overly complex Service issues and process that focus on healthcare and healthcare maintenance needs.

Documents operating models, innovative approaches to business solutions.

Facilitated process sessions to map existing customer service operational processes to define current business activities for the development of future state processes.

Made recommendations for improvements to GHP operation / IT process standards/methodologies.

Participated in meets with decision makers, systems owners, and end users to define business, financial, and operations requirements and process goals.

Worked in Facets online modules such as Billing, Provider, Claims and Membership modules.

Assisted the Project Management team in development of Business Cases and Budgets with cost/benefit dimensions of proposed IT projects that will be used by management and executive levels for funding and scope decisions.

Conducted the analysis of current business processes and functional requirements.

Prepares appropriate documentation to communicate and validate the information.

Performs cost-benefit and return on investment (ROI) analyses for proposed changes to aid management in making implementation decisions.

Facilitated the analysis and definition of efficient, cost-effective process initiatives that support client business processes and functional requirements.

Utilized ETL to work with various databases and Data Modeling.

Evaluated the functionality of the existing collateral management system.

Worked with client to determine user requirements and goals at requirement elicitation stage using Agile Methodology.

Documented Requirements for Management Reporting out of Clear Quest using Crystal Reports.

Provided subject matter expertise to cross-divisional, common business areas.

Researched, analyzed, and reviewed the effectiveness and efficiency of existing processes and develop strategies for further leveraging of the processes.

Provided on-going analytics with respect to process improvement, process alternatives, client value realization.

Communicated process changes, enhancements, and modifications verbally or through written documentation to management, peers, staff, and other employees so that issues and solutions are understood.

Environment: MS Office – Word, Excel, Access, and PowerPoint. UML, Axure, Waterfall Methodology, Balsamiq, Team Foundation Server, PeopleSoft

Contact this candidate