Home

Mohar - Business Analyst - Healthcare, E-commerce, Banking & Insurance

[email protected]

Location: Dallas, Texas, USA

Relocation: Hybrid/Onsite inside state or Remote

Visa: H4EAD

Professional Summary: Over all 8 years of professional experience as a Business System Analyst in Healthcare, E -Commerce, Banking and Insurance domains, with solid understanding of Business Analysis. Hands-on experience in understanding the As-Is business and propose the best possible solutions for the To-Be business operation to be performed. In-depth knowledge and experience with all the phases of Software Development Life Cycle (SDLC) Analysis, design, development, testing, implementation and maintenance of applications. Experience in different SDLC methodologies like Waterfall, Agile-Scrum. Extensive experience in working with Quality Analyst team in area of preparing Test cases, defect tracking & User Acceptance Testing (UAT). Performed GAP Analysis - 5 WHY s, SWOT Analysis. In-depth knowledge and experience in BPMN and BPMN Notations and flow charts. Experience in developing Business requirement documents, Functional requirement documents, technical specification documents, User requirements documents. Demonstrated strength in supply chain planning demand planning supply network collaboration, sales and distribution. Experience in Managing Product backlog and sprint backlog, creating user stories, Epics, Tasks, Bugs. Hands-on experience in conducting the Sprint planning, Daily SCRUM, Sprint Review, Sprint Retros and backlog grooming sessions. Create and maintain back log items in JIRA and facilitate sprint and Release planning sessions. Translated high-level requirements into high-level user stories and epics over two sprints on TFS Team Foundation Server. Experienced in Amazon Cloud (AWS) (EC2, Auto Scaling, EBS, S3, Glacier, Storage Gateway, Snowball, Amazon Connect, Data Transfer, Data Pipeline, VPC, Cloud Front, Route 53, Elastic Load Balancing, RDS, Aurora, DynamoDB, Red Shift, Data Migration Service, Elasti Cache, Cloud Front, Cloud Formation, CloudTrail, Elastic Bean Stalk, Ops Works, IOT,AWS Management Console etc). Heavily worked with different modules of QNXT Claim Processing and Billing module. Experience in writing User Stories, creating TASKS, BUGS using JIRA. Experience in conducting Joint Application Development (JAD) sessions, Brainstorming Sessions, Workshops and Interview sessions for requirements analysis with product sponsors & development team. Experience in defining requirements, managing and tracking the requirements and approving releases using Azure DevOps. Provided project leadership and solution expertise during complete life - cycle implementations of SaaS based HRIS products resulting in on time delivery and future releases of these products. Proven ability to improve the effectiveness of User/Employee development through the implementation of SaaS based solutions. Create customized dashboards, charts, and query work items using Azure DevOps. Interacted and coordinated between end-users, Development team and suggested key enhancements and changes to the business flows. Full understanding of the ETL (Extract, Transform and Load) solution concepts and functional knowledge and extensive experience of Informatica. Extensive experience of Data Warehousing using Informatica/Data Stage, Project Planning and Requirements and Data Warehouse Deployment. Having knowledge in GAAP and IFRS Experience in using business modelling tool such as MS Visio to generate data flow diagrams, Process Maps & Flow charts. Good knowledge on HPALM, Bugzilla, QC tools. Experience of working in utilities, Finance, Banking, and supply chain. Experience in working with UI/UX designing team and development team and knowledge of UI/UX design methodologies such as wire frames, Prototyping, Use cases, Workflow diagrams & Activity diagrams. Experience in data analysis, data mapping, and logical data modeling. Created entity-relationship (ER) diagrams and used SQL queries to filter data within database and data mapping and basic data profiling as per the need for requirements. Proficient in SQL queries to create user reports, data validation and data flow testing for business processes. Hands-on experience in performing the GAP analysis, creating work breakdown structure (WBS), RTM s. Ability to prioritize workloads, time manage workday effectively, multi-task, work on a team and a good team player. Service as aliases between supply chain, marketing, sales, Finance and IT teams and providing analysis to confidential. Effective management of project scope and ensure deliverables are met and business objectives are achieved in line with the overall business strategy. Manage and handle change requests by performing impact analysis on the business and technology fronts and submit it for approval from the Change Control Board (CCB). Strong experience in collaborating with QA team for test planning, test execution, issue resolution and report generation. Thorough knowledge in using SaaS, UML, XML, SOAP, HTML, Java, JSON, Java script. Experience in writing the test cases and executing the user test cases. Hands-on experience in validating the test cases for integration testing, regression testing and UAT s. Dedicated and self-motivated achiever who is committed to success and adept at juggling multiple tasks. Enthusiastic in learning and grasping new things quickly and can adapt to change easily. Technical Skills: Requirements Management Tools: Power Designer, Rational Rose, MS Visio, Balsamiq SDLC Methodologies: Scrum (Agile), Waterfall Business Modeling Tools: Smart Draw, MS Visio, Snag it. Project Management Tools: Azure DevOps platform, JIRA, Confluence, MS Office Suite-Certified Expert - Word, Excel, PowerPoint, Access, SharePoint, ServiceNow, Browser Stack, Sauce lab Defect Management Tools: Bugzilla, Quality Center/ HP ALM, JIRA, Azure DevOps. Operating Systems: Microsoft Windows 8.1, 8, Vista, XP, Unix, Mac OS X, iOS, Andriod Data Analysis Tools: Tableau, MS Excel (VLOOKUP, Report and Dash Boards, Pivot Tables) Cognos, TOAD, DBeaver, Power BI, GIT Requirements Management Tools: Rational Rose, MS Visio, BOX, MS Word, Excel, JIRA - Atlassian Professional Experience: Nationwide Life Insurance, OH Oct 2021 - till date Role: Business System Analyst Project Description: Nationwide Mutual Insurance Company and affiliated companies, commonly shortened to Nationwide, is a group of large U.S. insurance and financial services companies based in Columbus, OH. Responsibilities: Responsible for the management of the software process from requirements gathering, documentation, management approval, Scheduling business meetings. Led requirements elicitation and gathering from the business partners for the Sales Management System and build data integration with the AIMS application, and other internal/external applications. Identify and create requirement documents elaborating the business and system requirements for multiple applications. Conducting requirement elicitation Workshops, Brainstorming sessions, Interview sessions to gather requirements. Led financial analysis and reporting efforts, ensuring compliance with GAAP standards. Created Use cases, selected the workflows related to the Use cases, and created User stories, Epics, Tasks, Bugs and supported them with wireframes and mockups as per the need. Work with the PO to prioritize the requirements and check, validate the acceptance criteria of all the user stories and prioritize and create the product backlog (PBI). I analyzed and documented the supply chain end to end AS-is Business processes, in collaboration with stakeholders. Participate in SaaS vendor RFI/RFP and vendor selection process by mapping the product feature to the WB users Business function and process and vendor reference check, Convert existing invoices and matters to the Councel Link SaaS System. Wrote AWS, Linux-admin and Business operations manual. Attend weekly Business meetings and update the team with the business requirements with all the supporting details and screen shots, mockups, or any missing information. Prepare user stories, Epics, Task, Bugs briefs and specification for all the functional requirements identified and linked to subsequent test cases and test scripts and support them with wireframes and mockups. Gather functional requirements, user requirements, technical requirements, system requirements, Gather the information related objects, fields, parameters to generate complex reports for the Producers/Wholesalers/Internal and External customers using Business Objects, SMS, Web-focus and other internal/external applications. Conducted financial analysis and prepared monthly financial reports in accordance with GAAP. Define requirements, manage and track the requirements and approve releases using JIRA. Create customized dashboards, charts, and query work items using Azure DevOps. Participated in weekly review meetings to report the documented test metrics and defects found in the System. Design innovative cloud solutions using Azure Cloud, SAP and SaaS HR solutions like SuccessFactors and third-party interfaces with payroll, outlook, time, benefits, expenses and contingent workers. Attended meetings with Executives from Honeywell and Involved in evaluating the cloud providers (Azure, AWS, PCF, Apprenda, Enterprise Hybrid Cloud) as per the management, TOGAF guidelines, Work with stakeholders to develop SQL report requirements including rationale, structure, criteria/values to be reported, timeframe, and runtime parameters. Requesting and validating webservices and REST API using POSTMAN tool. Helping the QA team test web services validate the request and response XML, SOAP calls. Perform GAP analysis along with the technical lead, to bridge the GAP in the process related workflows. Managing change management document and implementing the changes in the business requirements performing GAP and feasibility analysis. Track and Manage SaaS application deployment, Win10 Upgrade, Office 2016 Upgrade and Testing, UAT etc. Ensure daily communication between Stakeholders, data mapping and create DDL Requirements, Development, and Testing. Assist internal infrastructure team with QNXT schema questions/solutions. Involved in testing QNXT member, provider, claims processing, utilization management, contracts and benefits. Handled multiple and to end SAFe and Agile SCRUM projects including, execution, monitoring and controlling. Experienced in integration with QNXT. Designed test scripts for testing claims in development. Test and report on QNXT application functionality and defects. Experience in Property and Casualty, Underwriting, Guidewire, Rating, Reinsurance and Life Insurance Raise ServiceNow Incidents and tickets and check, update and follow up with team to work on the Incident, based on their Priority levels. Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance. I provide support and advise to the supply chain SME and contributed to organizational BA best practice. Worked with retirement/pension planning advisors and SMEs to capture data and features needed to be added and write SQL queries for data mapping, validation and analysis. Perform usability testing for mobile apps using browser stack tool for Android, iOS, Mac, Windows. Communicated the complex requirements to both technical and non-technical audiences. Coordinate and collaborate with the cross functional teams to finish the dependency tasks. Help and supported team if any PROD issues, by collaborating, coordinating and clarifying the queries with SME s, Architect and cross functional teams as and when required. Handel change in the requirements, do impact analysis, update the change request document and coordinate with team for the change in the Business requirements. Schedule show & tell for the work finished and take approvals, update the Business documents. Environment: Agile methodology, java, GIT, UML, SaaS, MS Office, BOX, MS Visio, SQL Server, TOAD, DBeaver, POSTMAN, Web API, SharePoint, Andriod, iOS, Browser stack, JIRA, ServiceNow, Snowflake environment, Netezza environment. Drew Shoes Columbus, OH Jan 2020 - Sep 2021 Role: Business Analyst Project Description: Drew Shoe Corporation has more than 135 years of history and is located in Lancaster, Ohio. The Drew brand specializes in shoes for feet that require special care, including diabetic, arthritic and other types of medical conditions. The scope of the project is to rewrite the web application supporting the latest technology. Make the UI user friendly with advanced search features. Responsibilities: Gather & analyze requirements using various techniques, review designs and create design documents, study current business practices & requirements and suggest viable solutions to meet business requirements. Prepare detailed design documents for product development and change requests covering solutions. Utilized agile software development methodology to manage and control software and product development. Documented business functionality requirements in User Stories, Epics, tasks. Collaborate with the Product Owner on project/roadmap planning, facilitated daily stand-up meetings, reviews, retrospectives, sprint and release planning, demos and other Scrum-related meetings. Create and maintain back log items in Azure DevOps and facilitate sprint and Release planning sessions. Grooming the user stories in Azure DevOps and defining the user acceptance criteria for the requirements. Work closely with the Development team for implementing solutions and with the Quality Control team to ensure product quality, follow-up and provide post-implementation support to ensure smooth integration of products. Maintain status of various change requests for BA related activities and track & report incidents in the production environment. Expertise in interpreting and applying GAAP standards to ensure compliance and accuracy in financial reporting. Liberty Mutual offers a comprehensive array of property and casualty insurance products along with loss prevention, risk and disability management services. Coordinate and collaborate with the cross functional teams to finish the dependency tasks. Prepare test scenarios and test data for execution, run test cycles in the programming as well as online test regions to meet different test scenarios. Analyze problems and resolve critical issues on priority having strategic impact on applications by applying / following business / technical support concepts, departmental procedures, etc. Assist lead mission-critical implementation initiatives, oversee all phases of project cycles and revision of operational procedures in accordance with new functions & requirements. Perform GAP analysis along with the technical lead, to bridge the GAP in the process related workflows. Attended JAD sessions with the stakeholders as a scribe and captured business rules, system rules and process flow for each requirement. Created Requirements v/s Requirement Matrix in Excel Spread Sheet template. Communicated with various functional and development teams regarding data errors, system errors, and various other support issues. Gather feedback from the product owners after the demos and handle any requirements churn. Creating Test script for UAT and coordinating UAT s. Environment: Agile methodology, Azure DevOps, Sauce labs, java, GIT, UML, MS Office, SaaS, MS Visio, SQL Server, Use Cases, Rational Clear Quest, and DB2, Power BI, POSTMAN, Web API, SharePoint. Royal Medical & Technical Consultants Inc, IL Oct 2017 - Dec 2019 (Windsor School of Medicine) Role: Business Analyst Project Description: Royal Medical and Technical Consultants provides professional consultancy services in relation to students attending Windsor University School of Medicine which is located on islands of St. Kitts and Nevis. Royal Medical and Technical Consultants provides the best guidance to explore new avenues to study at Windsor University School of Medicine in their career life and learning centers in the field of Administration, Academics, Web Management, Development of Notes, Handouts and Web Based Teaching Resources. Maintain the student data information, validate data to process Transcripts, MSPE s for the medical students. Updating and maintaining the evaluations from PED, ACG, MCH of clinical rotations and OSCE exam scores uploads. Upgrading other internal applications and streamlining to a single platform. Responsibilities: Understand the Business operational goals, conducted feasibility and performed scope analysis for the proposed enhancements, and made recommendations to the Business users. Conduct business meetings with the stakeholders, Business Unite managers, Clients and SME s to gather as much as possible information regarding the project and the project needs. Attending Backlog Grooming along with the Product Owner and SME, Plan, prepare and prioritize the User Stories and support them with wireframes and mockups. Plan and conduct sprint planning, review and retro meeting. Coordinate and collaborate with the cross functional teams to finish the dependency tasks. Conduct show and tell with the stakeholders and take signoffs. Take updates from the Scrum team on the day-to-day tasks in daily standups and coordinate and help the team if any blockages. Responsible for creating detailed user stories, Epics, Tasks, Bugs, Acceptance criteria using gherkin format and created both positive/Happy path and negative test scenarios. Organizing and validating the data for processing MSPE and Transcripts required for medical student education purpose. Supervised QNXT benefit Configuration and Test Teams. Analyze and validate the clinical student s academic data such as documents modules, medical cases and student s fee statements data. Created and triggered the automation jobs using Jenkins to get the cucumber html reports and used JIRA for defect tracking. Create and maintain back log items in JIRA and facilitate sprint and Release planning sessions. Developed SQL queries to query the database find out correct data for testing and to test the backend process of the application. Assisted internal infrastructure team with QNXT schema questions/solutions. Prepare counseling charts, store and maintain the data required for marketing purpose as per medical school s requirements, as per the requirement under the guidance of technical lead, as per the requirement. Reporting any defects and Observation on daily basis. Summarizes testing and validation results and communicates with project team members regarding status. Environment: Agile methodology, Python, PyCharm, MongoDB, MYSQL, SaaS, Selenium, GitHub, JIRA, Confluence, SOAPUI, SQL Server 2000, 2005, 2008R2, MS Access, WinScp, Web Services, FTP Clients, and other internal application. Halo Communications, Columbus, OH Sept 2015 - Sept 2017 Role: Business Analyst Project Descriptions: Halo s mission is to streamline communication, so clinicians can focus on care. The Halo Clinical Communication Platform enables mobile collaboration for healthcare by consolidating secure messaging, on-call scheduling, VoIP and mobilization of critical alerts, all powered by the Halo Clinical Workflow Engine. HIPAA-Secure Communication, Secure Physician Messaging (messaging between the hospitals professionally), App-Based Patient Management, Healthcare Mobile App Communication, Physician Alignment, Call Center Integration, Increasing Organizational Billing Capture Revenue, Physician On-Call Management, On-call scheduling, Scheduling appointments and reminders. Responsibilities: Assisted in the assessment of Business processes related project goals and delivery of comprehensive project estimations and timelines. Conducted meeting with the business unit managers, stakeholders, SME s and Business Requirements, Functional and Technical meetings with the business Partners. Conducted Joint Application Design (JAD) session, interviews sessions, brainstorming sessions with stakeholders, clients and SME s to gather the business requirements. Translated business user concepts and ideas into comprehensive business requirements and design documents. Involved in all technical discussions as a representative from Business to make sure all business Requirements are being met by the impacted applications. Performing as a chain management Business Analyst in healthcare focusing on process improvements analyzing, and interacting chain management, finance and sales team in the project. Created Use cases, selected the workflows related to the Use cases, and created User stories, Epics, Tasks, Bugs and supported them with wireframes and mockups as per the need. Work with the PO to prioritize the requirements and check, validate the acceptance criteria of all the user stories. Create and maintain back log items in JIRA and facilitate sprint and Release planning sessions. Conducted a detailed GAP Analysis to provide Impact Assessment on various departments. Modeled the AS-IS process flow and the TO-BE process flow and analyzed the gap and developed the action steps to fill the gaps. Created interactive dashboard using advanced excel, QlikView, and SAP to provide complete end to end visibility od supply chain process. Worked as a part of the technical team in understanding the business requirements and translating them to technical documents. Analyzed the reporting requirements from the business users and converted them into technical specifications. Conducted Impact Analysis when there was any change in the requirements and updated the Business Requirements Document (BRD) and Systems Requirements Specification (SRS). Designing Functional Specifications for the target physical database. Used Performance Monitor and SQL Profiler to optimize queries. Coordinate and collaborate with the cross functional teams to finish the dependency tasks. Participated in Test Plan, Test Scripts and Test Scenarios, and user design documentation. Participated in testing activities, development of Test cases and bug tracking, preparing RTM s and performing user acceptance testing. Perform usability testing for mobile apps using browser stack tool for Android, iOS, Mac, Windows. Communicated the complex requirements to both technical and non-technical audiences. Provided business and IT senior management timely and concise project status updates. Assisted Lead Project Managers in some of the Project Management tasks such as gathering approvals for the artifacts, making sure the artifacts meet all the quality standards. Environment: Waterfall and Agile methodology, Java, Andriod, iOS, Browser stack tool, SaaS, GIT, node JS, Azure DevOps, SQL, MS - Office, MS-Visio, MS Word, MYSQL, Selenium, SharePoint, BOX, GitHub, JIRA, SOAPUI, Internal applications. Education: Master in English, Burdwan University, 2012. Keywords: quality analyst business analyst user interface user experience javascript business intelligence sthree information technology hewlett packard purchase order microsoft Illinois Ohio