- Qualified professional with over 15 years of extensive experience as a Business Analyst, Database Administrator and System Analyst in the Healthcare and Financial Industries.
- Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
- EDI files successfully verified and processed into respective Database.
- In-depth knowledge about HIPAA compliance, PHIPA, Medical plans such as measurement based care and treatment plans.
- Successfully produced Business Requirement Document (BRD) and its approvals.
- Knowledge of Microsoft Dynamics, MS SQL Server, Sybase, MySQL, Oracle use in web content management.
- Strong skills in conducting JAD sessions UAT Test plans, scripts creation, co-ordination and execution.
- Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
- Experienced in preparing Business Process Re-Engineering Models.
- Single point of contract to communicate Business and Technical requirements.
Hi, I’m
Olajumoke Ajayi
Ajax,Ontario
Summary
Overview
16
years of professional experience
Work History
Child Development InstituteToronto, ON
Business Analyst/Application Development Senior Analyst
04.2015 - Current
Job overview
- Four Mental Care Health Institution is in the process of integrating, upgrading & enhancing the existing user interface and organizations web portal and referral workflow & waitlist systems to improve performance, user interface and excellent delivery of mental health services across Ontario.
- Responsibilities: As the Business Analyst in-charge of the 4-agencies collaboration.
- Conducted weekly meetings for deciding the Policies and Procedures to be followed while upgrading systems.
- Performed the requirement analysis, impact analysis and documented the requirements.
- Documented the requirements for waitlist system, referral workflow management module and enhanced the encrypting standards that are required for the application.
- Documented the current business flows for Utilization Management (UM), Case Management (CM) and Treatment Management (DM).
- Created and managed Business Requirement Document, Use Cases for the upgraded functionality.
- Worked in mainframe environment and used SQL to query various reporting databases.
- Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications.
- Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
- Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
- Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture).
- Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
- Planned and documented procedures for data processing and prepared data flow diagrams for the application.
- Analyzed and translated business requirements into system specifications utilizing UML methodology.
- Interacted with line of business managers and coordinated the transition into the security database to ensure business compliance with HIPPA.
- Collaborated with testing teams for running detailed UAT tests before roll out.
- Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
- Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
- Designed and developed project document templates based on SDLC methodology.
- Performed Unit Testing and User Acceptance testing and documented detailed results.
- Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.
- Environment: Windows 2000/XP, Microsoft Office SharePoint 2007, Rational Requisite Pro, MS Office, SQL Server, Agile, MS Project, MS FrontPage 2003, MS Access, EDI, Documentum 2.0, UML.
HGS CanadaRegina, SK
Business Analyst
09.2018 - 12.2018
Job overview
- Major Technical Support company for Rogers Telecommunication.
- The project was to develop an application for the HGS Canada to use as a central hub for storing reports from different departments of the Rogers Telecoms.
- Major modules included Enrolment/Registration, Billing and Reports.
- This System was being developed using HIPAA guidelines and regulations which keeps track of Healthcare transactions like Eligibility Request/Response, Request and Response for Claims Status, Prior Authorization, and Claim/Encounter.
- Responsibilities:.
- Gathered business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME's).
- Conducted group (JAD) sessions with business units and stakeholders to define project scope and deliverables.
- Validate the Business-to-Business data exchanges between data exchange partners; validate the internal processing of the MMIS, or other transaction processing system.
- Provide technical support for the Minimum Data Set (MDS) and the Outcome and Assessment Information Set (OASIS) Systems to enable the electronic transmission for patient data for the purpose of payment and quality of care analyses for the Medicare and Medicaid Programs.
- Responsible for creating use cases, system architecture document, supplemental requirements document, architecture diagrams; verifying technical production infrastructure; designing and executing performance tests; and documentation.
- Worked on Medicare Advantage (A, B, C), Medicare Part D (MA-PD), Medicaid Options (Under 65 and Over 65) and Managed Care (Care, Disease and Case Management and also in Insurance regulations and Claims Processing and claim scrubbing in HMO, PPO, Medicare and Medicaid.
- Assisted in loading managed care contract rates into managed care contracting information systems.
- Also, worked with other departments to provide managed care information and identify improvement opportunities.
- Also performed complete reconciliation of the Explanation of Payments (EOP) and check remittances as they received from Managed Care Contracts.
- Entered Minimum Data Set (MDS) into computer database and transmitted them to the Medicare website.
- Designed and maintained managed care contract databases to streamline collection, analysis, and dissemination of contract information.
- Developed and wrote test script walkthroughs with developers and Quality Analyst.
- Conducted meetings to understand the workflow, their processes and assisted in gap analysis to derive requirements for existing systems enhancements.
- Environment: Windows 365, Microsoft Office SharePoint 2016, Rational Requisite Pro, MS Office, SQL Server, Agile, MS Project
Hartford Green ConsultingLagos, Nigeria
Business Systems Analyst
01.2017 - 04.2018
Job overview
- Uniprise Technologies is a part of Presbyterian Healthcare System, a Fortune 500 company and a leading player in the Health Insurance and services market.
- UHCI specializes in Network based care co-ordination health care services for small groups, government and specialized groups and commercial employers.
- The system streamlined patient registration, patient scheduling, medical insurance checking, claims processing, and reporting.
- The purpose of this project involves population of the Enterprise Data Warehouse (EDW) which is used in critical reporting and analysis.
- The data is pulled together from multiple, disparate systems.
- I was also involved in certain modifications to the claims processing system.
- Responsibilities:.
- Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validated the needs of business stakeholders.
- Conducted user interviews and documented business and functional requirements.
- Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose.
- Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
- Defined, developed specs for federal reporting specific to Medicare Advantage.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
- Maintained on-going technical assistance and provided help desk support to customer's mainframe systems software that included problem determination and resolution.
- Completed the documentation of temporary access claims scenario's for the source system.
- Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
- Documented Pension Benefit processing.
- Designed High level design, for New process, integrating with legacy and Facets.
- Documented requirements, associated change requests with requirements and connected requirements with Use cases.
- Environment: Windows 2016 Professional, MS Excel, Oracle, UML, Rational Rose, Clear Case 2002, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.
Pensions Alliance LimitedLagos, Nigeria
Business Analyst/Data Analyst
04.2007 - 12.2016
Job overview
- Pensions Alliance Limited is one of the foremost pension fund administrator established in Nigeria.
- It consisted of different modules like customer enrollment, operations, Investment, Financial control, Benefit payment and IT departments.
- There are different projects that I participated in either as Lead or member during my almost a decade as an employee. Projects vary from Feature upgrades to an existing system and building a brand new system either by outsourcing or building in-house.
- Responsibilities:
- Served as sole database administrator for Sybase and MS SQL running on various operating systems for over five years with Develop, implement, and maintain database and/or data warehouse applications working with tools and platforms such as SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) Visual Studio (with SQL SERVER DATA TOOLS)
- Saved the Organization a lot of money during the Economic meltdown by proposing to generate and print client statements in-house, this was done by using Management Studio for Queries and Design, SSIS for Data Migration and Crystal Reports for Client’s statement design. The organization was about to save a lot of money, statement delivery was faster and error-free and clients were happy.
- Created of Tables, views, stored Procedures, Functions, General backup, documentation and general MS SQL server security, My SQL 5.1 and Sybase database
- Managed the Business Continuity Sites using Database Replication/Mirroring and as well as DB cloning to pull and push date from on-site to the BCP site
- Staff in-charge in-charge data migration from Fund Fusion (backend Sybase database) to Enpower (Backend MS SQL)
- SQL Query writing and optimization as well as Database tuning using Database Performance tool like Profiler to determine Query performance
- Managed 3rd Party applications like Microsoft NAV, Verity Teleform, Bloomberg
- Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
- Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
- Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models..
- Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
- Created Process Flow diagrams, Use Case Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
- Wrote Test Cases and performed User Acceptance Testing, documented the in detail defects using the Defect Tracking report.
- Used Test Case distribution and development reports to track the progress of test case planning, implementation and execution results.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.
- Carried out defect tracking using Clear Quest.
- Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
Education
North American College of Information TechnologyCanada
No Degree from Business Administration
12.2020
University Overview
Meridan TechnologiesNigeria
No Degree from C# And Web Application
12.2016
University Overview
Ladoke Akintola University of TechnologyNigeria
MBA from Business Administration
09.2014
University Overview
Ladoke Akintola University Of TechnologyNigeria
Bachelor of Science from Computer Science
09.2005
University Overview
Skills
Tools: MS SQL Server, Rational Rose, MS-Excel, MS-PowerPoint, MS-Visio, Jira, Fresh Service, Oracle, Sybase, My SQL, R Studio, MS Power BI, SSIS,FreshService, SSRS, MS-Office, Rational RequisitePro, Rational ClearQuest
Methodologies: Agile-Scrum, Hybrid (Agile Waterfall), RAD, Waterfall Requisite Pro, Rational Rose, Agile, PL/SQL, HTML, MS Office, MS Visio, EDI, UML
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
There’s no shortage of remarkable ideas, what’s missing is the will to execute them.
Timeline
Business Analyst
HGS Canada
09.2018 - 12.2018
Business Systems Analyst
Hartford Green Consulting
01.2017 - 04.2018
Business Analyst/Application Development Senior Analyst
Child Development Institute
04.2015 - Current
Business Analyst/Data Analyst
Pensions Alliance Limited
04.2007 - 12.2016
North American College of Information Technology
No Degree from Business Administration
Meridan Technologies
No Degree from C# And Web Application
Ladoke Akintola University of Technology
MBA from Business Administration
Ladoke Akintola University Of Technology
Bachelor of Science from Computer Science