Business Analyst Process

Mahesh Babu

Email: *************@*****.***

Ph no: 219-***-****

Sr. Business Analyst

Summary:

●Over 10+ 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.

●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.

●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.

Technical Skills:

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: Berkeley Capital, Beachwood, OH Nov 2022 – Present Role: Sr. Business Analyst

Responsibilities:

●Gathered business requirements through interviews and document reviews, fostering effective communication with portfolio managers, risk analysts, and investment stakeholders.

●Facilitated Technology Integration by bridging core workstreams and product teams, specifically with the Portfolio Management System (PMS), 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 in investment platforms.

●Collaborated with Solution Architects to develop EPIC diagrams, illustrating the architectural landscape for seamless integration of investment data.

●Conveyed EPICs/user stories with comprehensive diagrams to product teams, aiding accurate estimation and reporting to business stakeholders.

●Gathered requirements for key investment performance metrics to be tracked on the investment management platform and data analytics systems.

●Meticulously outlined data mapping with source and target fields and adeptly used Tableau for financial and investment portfolio reports.

●Developed and optimized custom Java integrations for seamless data exchange between trading systems, portfolio risk management, and regulatory reporting platforms, significantly enhancing data synchronization and reducing manual entry errors.

●Enhanced investment platform performance by analyzing and refining core Java applications, improving the efficiency of trade reconciliation and risk analytics workflows.

●Streamlined automated trade settlement processes using Java, improving accuracy and reducing settlement errors, ensuring timely execution of investment transactions.

●Optimized Java-based custom reports within investment platforms, implementing caching and indexing strategies that led to a significant reduction in report generation times.

●Integrated financial modules for risk management, compliance, and portfolio analytics with third-party investment data providers using Java APIs and RESTful web services to enhance cross-functional data visibility and operational efficiency.

●Refactored legacy Java code to improve the performance and scalability of investment management systems, achieving better resource utilization and supporting increased transaction volumes.

●Implemented data validation checks using SQL to ensure consistency and accuracy of financial and investment-related data.

●Assisted in data cleanup initiatives, writing SQL scripts to identify and rectify erroneous entries in the database, ensuring accurate investment records.

●Used Rational Rose to design and develop Use Case Scenarios, Use Case Models, Activity Diagrams, Sequence Diagrams, and State Chart diagrams for investment process modeling.

●Collaborated with cross-functional teams to develop comprehensive change management strategies tailored to investment and financial regulatory requirements.

●Implemented change initiatives by establishing timelines, key milestones, and KPIs to measure the success of technology and investment process changes.

●Liaised with third-party vendors for change requests, translating them into relevant EPICs/user stories.

●Accepted requests from investment managers to assign specific roles and access permissions in the Portfolio Management System (PMS) and updated related SQL tables using advanced SQL queries.

●Documented all change management processes, decisions, and outcomes for future reference and organizational learning.

●Regularly reported on the status of change initiatives, providing updates to senior management and key stakeholders.

●Used Sqoop to load structured financial data from SQL to Hadoop databases in Hadoop Distributed File System (HDFS) from core banking databases.

●Used Hive to run HQL (Hive Query Language) to process data for investment risk analytics and financial reporting purposes in Hadoop that were migrated from SQL tables.

●Compared HQL queries and SQL queries for any inconsistencies to sync the queries and update investment-related tables during the transition window.

●Played a key role in investment account reconciliation, trade processing, and compliance workstreams.

●Crafted narratives for EDI transactions (SWIFT messages, FIX protocol) aligning with financial regulatory and risk management standards.

●Led weekly calls with internal teams and external vendors, discussing updates and compliance with investment regulations.

●Collaborated with test coordinators and prepared non-technical EPICs for investment outreach workstreams.

●Worked with business owners and stakeholders to understand and develop BRD (Business Requirement Documents) for investment data management and compliance reporting.

●Managed financial utility services and implemented Log Service for real-time trade and portfolio analytics.

●Developed user stories using Agile principles, contributing to the successful completion of investment projects.

Environment:

Agile Methodology, SharePoint, MS Office (MS Word, MS Excel, MS PowerPoint), MS Project, MS Visio, JIRA, Windows, Google Suite, Tableau, SQL, Java, Hadoop, Hive, Sqoop, SWIFT, FIX Protocol, RESTful APIs.

Client: CVS Health - providence, RI Jan 2020 – Oct 2022

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.

●Analyzed healthcare claims and member data to identify cost-saving opportunities, improve operational efficiency, and ensure compliance with payer regulations, resulting in a reduction in claim processing time.

●Conducted gap analysis for existing payer processes and identified potential enhancements, leading to an optimized member journey that decreased onboarding time.

●Developed and implemented requirement-gathering processes for claims processing systems, working with stakeholders to define specifications that improved claim adjudication accuracy.

●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).

●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: Vanguard, Malvern, PA Jul 2017 – Dec 2019

Role: Sr 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.

DISH Network, Englewood, Colorado Oct 2015 – Jun 2017

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.

Loginsoft LLC, Hyderabad, India Nov 2013 – Aug 2015

Business Analyst

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