Business Analyst Process
Resume:
Ibrahim Mohammed
*******.********@*****.***
Chicago IL
Sr. Business Analyst
SUMMARY:
Over 9+ Years of Business Analyst with a robust comprehension of Business Requirement gathering, Business Process flow, Business Process Modelling, Data Analysis, Data Mapping, application upgrades and Business Analysis.
Proficient in MS Office tools (Visio, Project, Macros, Word, PowerPoint, Outlook and Excel), Prezi for online presentations and utilizing online tools for animated video development for presentations. Capable of navigating project tracking tools like SharePoint.
Accomplished communicator with strong organizational skills, adept at team coordination, project management, time management and delivering exceptional customer service while paying meticulous attention to details.
Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose.
Demonstrates advanced research, writing and analytical skills, excelling under pressure and adhering to directives.
Utilized SQL to extract and analyze data from relational databases, facilitating data-driven decision-making for key business projects.
Implemented cloud-based solutions using Microsoft Azure and AWS, integrating .NET applications with cloud services like Azure Functions, App Services and SQL Database for enhanced scalability and flexibility.
Automated compliance monitoring using tools like AWS Security Hub, Azure Policy and SIEM solutions to track ISO control adherence in cloud environments.
Executed complex SQL queries to identify trends, patterns and insights from vast datasets.
Self-motivated and independent thinker, operating efficiently under deadlines and targets without requiring constant supervision.
Skilled in Agile/Scrum and Waterfall Methodologies for Software Development Life Cycle (SDLC cycle). Proficient in working with technical teams to translate business requirements into software applications in the fast-paced Healthcare IT industry.
Extensive experience in Medicaid and Medicare claims processing, Membership Eligibility and Enrollment and comprehensive understanding of HIPAA regulations.
Well-versed in Project Management tools like MS Project for status reporting and planning. Thorough knowledge of Medicaid Management Information Systems (MMIS), HIPAA standards, HEDIS standards, Electronic Data Interchange (EDI), ICD-9, ICD-10 and FACETS/QNXT for claim processing.
Conducted JAD sessions, meetings, workshops to gather requirements from various stakeholders and SMEs.
Built strong relationships with stakeholders across multiple departments to understand and prioritize change requirements.
Developed and facilitated effective change communication strategies to ensure smooth transition and buy-in from all stakeholders.
Expert in creating business process flow diagrams using MS Visio and developing functional business requirements and process flows. Proficient in Business Process definition, Risk Analysis and Use Case Analysis.
Skilled in Business Analysis using Functional Flow charts, Check sheets, Interrelationship diagrams, Workshops and Brainstorming Sessions. Proficient in User Acceptance Testing (UAT) & release management.
Expertise in SQL queries using SQL Developer.
Supported People Operations by integrating business rules for onboarding, off boarding and employee role assignments using HR tools like Workday and MSL.
Managed end-to-end data mapping and validation for employee records between internal platforms and external HRIS systems.
Worked on end-user documentation, training manuals and how-to guides for new system features and workflow changes.
Experienced on Creating dashboards and scorecards using Tableau and Excel to monitor key performance indicators (KPIs) tied to business operations.
Participated in Agile grooming sessions to refine backlog items, clarify scope and assign priority for upcoming sprints.
Experienced in creating UML diagrams (use case diagrams, sequence diagrams, state diagrams, activity diagrams) on platforms like Lucid and Visio to enhance system understanding.
Capable of crafting SQL queries for data validation and retrieval. Quick to grasp new computer applications and software, with a willingness to learn statistical/analytical tools like SAS and SPSS.
Competent in creating user stories, maintaining dashboards, tracking project progress and logging bugs on Jira.
Proficient in creating and managing documentation on Confluence.
Skilled in delegation and providing clear guidance to administrative, clerical and technical personnel.
Guides the user community to coordinate quality assurance and acceptance testing efforts to verify functional system behavior.
Proficient in Google Suite for documentation, meetings and project progress tracking, ensuring seamless collaboration among team members.
SKILLSET:
Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Salesforce.com, Rational Clear Quest, Mercury Test Director, MS Project, MS Visio, MS Office Suite, Bloomberg, VBA for Excel, SQL, PL/SQL, VB.NET, C++/CLI, Adobe Acrobat, Photoshop, AutoCAD, 3D MAX, Jira, Trello, Confluence, Google Suite.
Databases: Oracle 8i/9i, MS SQL Server, MS Access
Environment: Windows, UNIX (Sun Solaris, AIX, HP-UX), Linux, Mainframe
WORK EXPERIENCE:
Client: Optum/UHG – Eden Prairie, MN Aug 2023 – Present
Role: Sr. Business Analyst
Responsibilities:
Gathered business requirements through interviews and document reviews, fostering effective communication with business owners and SMEs.
Facilitated Technology Integration by bridging core workstreams and product teams, specifically with the Internal Provider Finder (IPF), crafting system requirements for Project success.
Created technical EPICs and user stories during the PPP phase, collaborating with business owners for validation and due dates.
Collaborated with Solution Architects to develop EPIC diagrams, illustrating the architectural landscape for seamless integration.
Conveyed EPICs/user stories with comprehensive diagrams to product teams, aiding accurate estimation and reporting to business.
Deployed and managed cloud-native security solutions such as AWS IAM, Azure AD and GCP IAM.
Leveraged Azure cloud services for scalable deployment, enhancing application reliability and security.
Also gathered requirements for metrics to be tracked on the site for CMS and DAM.
Meticulously outlined data mapping with source and target fields and adeptly used Tableau for data reports.
Implemented data validation checks using SQL to ensure consistency and accuracy of data entries.
Assisted in data cleanup initiatives, writing SQL scripts to identify and rectify erroneous entries in the database.
Used Rational Rose to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML.
Collaborated with cross-functional teams to develop comprehensive change management strategies tailored to organizational needs.
Implemented change initiatives by establishing timelines, key milestones and KPIs to measure the success of the change.
Liaised with third-party vendors for change requests, translating them into relevant EPICs/user stories.
Accept requests from managers to assign specific manager and/or role to a new employee (nurse) in the Master Staff List (MSL) and update the specific SQL table(s) as well as sync up other related tables using advanced SQL queries
Documented all change management processes, decisions and outcomes for future reference and organizational learning.
Configured Azure DevOps pipelines for automated CI/CD deployments.
Implemented Azure Functions for event-driven serverless computing.
Regularly reported on the status of change initiatives, providing updates to senior management and key stakeholders.
Used Sqoop to load structured data from SQL to Hadoop databases in Hadoop Distributed File System (HDFS) from GHP SQL databases
Used Hive to run HQL (Hive Query Language) to process data for data analytics and reporting purposes in Hadoop that are migrated from SQL tables
Compared HQL queries and SQL queries for any inconsistencies so as to sync the queries to update the tables during the transition window.
Developed recurring operational reports and analytics to help leadership track SLA adherence and user adoption.
Coordinated with the HR tech team to design workflows for benefits enrollment, employee status tracking and access provisioning.
Developed user stories and test scripts for enhancements in HR systems involving position management and headcount reconciliation.
Conducted live and virtual training sessions for cross-functional teams on newly implemented tools and system upgrades.
Developed communication plans to guide business users through major software transitions and new feature rollouts.
Developed and executed detailed test scripts to validate business logic, field mappings and user access levels.
Worked closely with QA engineers to ensure comprehensive test coverage for all business requirements.
Played a key role in member enrollment, claims processing and payor workstreams.
Crafted narratives for EDI transactions (276, 277, 837), aligning with MITA goals for data exchange.
Led weekly calls with internal teams and vendors, discussing updates and compliance.
Worked on Azure SQL Database for storing and retrieving Medicaid/Medicare data.
Collaborated with test coordinators and prepared non-technical EPICs for outreach workstreams.
Worked with business owners and stakeholders to understand and develop BRD (Business
requirement documents) for CMS and DAM (Adobe AEM) implementation
Managed utility services and implemented Log Service for real-time data analysis.
Developed user stories using Agile principles, contributing to successful project completion.
Environment: Agile Methodology, SharePoint, MS Office (MS Word, MS Excel, MS PowerPoint), MS Project, MS Visio, JIRA, Windows, Google suite.
Client: CVS Health - providence, RI Jan 2021 – July 2023
Role: Sr. Business Analyst
Responsibilities:
Collaborate with CMS business project sponsors to define scope of projects and timelines associated with completion of project.
Sorted, scanned, assured the quality of uploads and reassembled all the documents once uploaded onto Salesforce.com
Prioritize and manage projects and initiatives in accordance with the requirements of CMS business needs.
Act as a Coordinator of On-shore & Off-shore resources.
Conduct meetings and facilitate collaborative discussions for requirement changes and new functionality needs as per Salesforce specifications.
Also gathered requirements for metrics to be tracked on the site for CMS and DAM
Worked on the EDI 834-file load to Facets through MMS (Membership maintenance sub-system)
Worked with FACETS edits and EDI HIPAA Claims (837/835/834) processing.
Worked on different 5010 HIPAA EDI transactions and code sets including 278 (Referrals), 834 (Enrollment), 270/271 (Eligibility), 276/277 (Claim status), 837 (Claims), 835 (Claims Payment).
Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for Medicaid Claims.
Played the role of a Business Analyst in a Waterfall SDLC environment by participating in meetings and planning of the project.
Developed UML Diagrams such as Process Flow, Activity Diagrams and Data Flow Diagrams.
Was involved in executing SQL queries on Oracle, Hadoop, SQL server tables in order to view successful Created reports to retrieve data using stored procedures that accept parameters depending upon the client requirements.
Managed requirement activities using an iterative and incremental methodology such as User stories and Acceptance Criteria.
Analyzed the “As is” and “To be” system documents to show the current and proposed functionalities of the system using MS VISIO.
Developed and maintained Requirement Traceability Matrix (RTM).
Prepared SWOT analysis and impact analysis for project.
Created Used Case documents and captured the process flows for various claims processes, Providers processes and Subscriber processes.
Worked With HIPAA compliant ANSI X12 837 formats for both professional claims and institutional claims.
Liaised between IT and business units, translating business requirements into SQL queries to fetch relevant data.
Conducted SQL training sessions for junior BAs, enhancing the team's overall data querying capabilities.
Matched the requirements for programs such as Medicare and Medicaid which are part of the Social Security Act.
Worked with business owners and stakeholders to understand and develop BRD (Business
requirement documents) for CMS and DAM (Adobe AEM) implementation
Assist with project implementation and control monitoring process related to quality assurance (QA) and user acceptance testing (UAT).
Logged and tracked bugs through JIRA and collaborated with developers to ensure timely resolution.
Facilitated daily stand-ups and sprint retrospectives to identify pain points in the QA cycle and improve process efficiency.
Designed FAQs, support guides and change impact summaries for users post-implementation.
Led “office hours” sessions during UAT and go-live phases to troubleshoot user queries and collect real-time feedback.
Participated in UAT sessions for new Workday modules (Time Tracking, Recruiting), gathering feedback and documenting change requests.
Worked with finance and operations teams to build business cases for automation initiatives and process enhancements.
Conducted impact assessments and feasibility studies for various change initiatives, including headcount optimization and cost savings.
Supported UAT by hosting working sessions, answering functional queries and validating test outcomes with business users.
Prepared and maintained Request for proposals (RFP), Request for information (RFI) and Request for Quotation (RFQ) for communicating in-house requirements to vendors.
Gather, document and analyze data and information; develop and execute training materials and training activities to high-level Salesforce operators.
Used JIRA for tracking the project progress and tracking the defects and its fixation.
Define and implement improvements to business process and ad-hoc tasks in the face of ever-changing marketplace and consumer needs.
Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio), .NET, Oracle, HP QC, RUP, UML, SQL, SWOT analysis, GAP Analysis, JIRA.
Client: Mayo Clinic - Rochester MN Sep 2019 – Dec 2020
Role: Business Analyst
Responsibilities:
As a business analyst, responsible for Requirements gathering from various insurance companies to develop a system to check for the outstanding balance from various accounts using the highly efficient Waterfall methodology of software development.
Liaison between the Business needs (business users and sponsor) and the Technical solutions (development and testing staff), ensuring technical solutions satisfied business requirements.
Experienced in creating gap analysis from “As-Is” to “To-Be” process.
Web Page Mock-Ups using MS Visio and thus defining the Business Process Model and Data Process Model.
Developed Informatica mappings, Sessions, Work flows and SQL code.
Ensured that the claims processing is strictly under the HIPPA compliance regulatory document to safe guard patient information.
Part of the team assisting in documentation involved in this project such as Request for Proposal (RFP/RFI), proposal, evaluation criteria, proposal approval, design document, project plan, project scheduling, project report, release document. Deliver Statement of work (SOW).
Define, measure, analyze and improve KPIs for each milestone and project.
Authored Business and Functional requirements (BRD) with data flow diagram, sequence diagram, flow charts, use cases and training manuals for Provider Portal web-based application.
Developed and maintained Requirement Traceability Matrix (RTM).
Developed training material and trained the users on newly developed applications.
Analyzed and wrote technical documentation for risk analysis on customer support issues.
Extensively worked in creating Test Procedures, Test plans and Test Case for User acceptance testing (UAT).
Experienced in Quality Center for Tracking defects and interacting with team members in fixing errors
Prepared and presented monthly collection reports.
Involved in training and quality of the overall workflow process.
Documenting workflow and results of analysis for the aging accounts.
Environment: Waterfall Methodology, SharePoint, MS Office, MS Visio, Microsoft CRM 3.0, Rational Requisite Pro, Rational Rose, HP ALM, Windows.
MetLife Sept 2018 – Aug 2019
IT Business Analyst
Responsibilities:
Acted as a liaison between Business and IT throughout all phases of SDLC.
Facilitated JAD sessions with all the important stakeholders for gathering requirements.
Gathered requirements through one on one meetings with business owners.
Documented all the requirements in blueprint.
Created documents like Requirements Specifications Document, Correspondence Requirements Document, Data mapping document etc.
Acted as liaison between external clients and SMEs to generate and standardize product requirements specification documents such as URS/FRS/Use Cases.
Involved in designing & determined 3-tier architecture for the claim processing system. Assisted team lead in developing Requirements Traceability Matrix (RTM) to trace the relationship between business and functional requirements to test cases.
Peer Review of the documents with the fellow business analysts before handing off to the Solution Architects or the developers.
Prepared and executed different Test Cases and Test Scripts.
Involved in conducting Functionality testing, Integration testing, Regression testing and User Acceptance testing (UAT).
Provided analysis and insight to QA Team in defects and bugs tracking.
Sign Off from the business for the documented BRD's and CRD's.
Uploaded the documents to the project SharePoint site for maintaining records, for future changes and for easy traceability for the team members.
Created Correspondence Requirements Document (CRD), Correspondence Mock ups, Fulfillment Data mapping documents etc. required for the correspondence.
Environment: Agile, Blueprint, Outlook, MS Word, MS PowerPoint, MS Excel, MS Visio, SharePoint, Notepad, OneNote.
Abbot February 2016 – June 2018
Sr. Business System Analyst
India
Responsibilities:
Followed all the phases in the project management life cycle.
Acted as a liaison between the business users and technical teams to build applications based on the business requirements - provided a single point of contact for user communication (managed issue tracking, prioritization and resolution).
Hands on experience with JIRA for issue tracking & User stories / requirements
Created complex reports utilizing SQL Server Reporting Services (SSRS)
Developed and Deployed of SQL Server Integration Services (SSIS) Packages
Organized meetings and worked together with PM across OWM Departments to discuss Project Requirements.
Single-point contact for issues encountered by the client which were managed & co-ordinated via JIRA system.
Gathered Requirement for Data Mart integrating data from UDB/DB2, Oracle, SQL Server, text, Excel and Access.
Assisted in designing and populate OLAP cube & Data Mart.
Implemented CMS (Content Management System) in automating various aspects of Web and Publication Content Creation, Document Management and Delivery.
Worked with OWM Team to write up Requirement Documents (define user and system interfaces - actors with the help of use case diagrams).
Prepared Mock-up reports for the Cognos development team.
Reporting the weekly and quarterly reports to the C-level executives.
Refined the requirements (use-cases) and Business Process Models to detailed level appropriate for technical analysis and system design.
Participated in sessions to define the solution approaches and identifying assumptions, constraints, risk and issues. Analysis and specification of system changes.
Revealed unidentified requirements, evaluated changes to requirements and assessed impact of changes.
Recommended process or system changes intended to eliminate identified risks or gaps.
Worked with Finance and IT department to operate across functions and worked with resources external to the Project Team
Developed functional requirements and specifications.
Provided regular verbal and written status reports to IT management and business community; published meeting minutes and maintained project plans.
Coordinated with the project team and testing team to revise project artifacts (such as use-case specifications, test scripts and so on) to reflect requirement changes.
Worked independently with minimum supervision as part of a dynamic IT team.
Contact this candidate