Lead Business Analyst Resume
MN
PROFESSIONAL SUMMARY:
- Over 10+ years’ experience as a Business Analyst working in diverse work environment with the healthcare industry.Experience in Business, Data Analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications, Data Warehousing concepts and web design and development.
- Hands on experience in analyzing the business needs, gathering requirements, identifying opportunities for improvement and designing systems and applications for various organizations.
- Solid knowledge and understanding about phases of Software Development Life Cycle (SDLC) including several methodologies like Waterfall, Agile, Spiral, RUP and SCRUM.
- Knowledge about Scrum Principles and worked as a Scrum Master for over 4 years.
- Highly skilled and experienced with gathering requirements, well acquainted with use of several elicitation techniques like JAD, Brainstorming, Focused Group and Prototyping.
- Experienced in creating requirements artifacts, Business Requirement Documents (BRD), System Requirements Specification (SRS), Use Cases, Functional Requirement Documents (FRD) and Change Requests Planning (CRP).
- Organized and facilitated project planning, daily stand - up meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum-related meetings
- Proficient in using Agile Scrum methodologies , performed roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.
- Business Intelligence/Data Visualization Consultant with a skill set of SAP Business Objects, Xcelsius, Crystal Reports XI - 2008 and Tableau 9.2 and Tableau desktop 10.1.
- Supported a COTS Evaluation for the Office of Workforce Diversity
- Proficient with HIPAA standards, EDI Transaction syntax like ANSI X12, EDI transactions using 834, 835, 837, Implementation.
- Experience with creating business process models, work flows, UML diagrams (Use Case, Sequence, Activity Diagrams) using various tools like MS. Visio and Rational Rose.
- Strong Project management skills like scheduling, planning, budgeting with experience in requirement analysis, GAP analysis, SWOT, Risk Analysis & Risk Management
- Knowledge of HIPAA code sets, ICD-9, ICD-10 coding and HL7, Claims etc.
- Acted as Scrum Master for Product teams with a focus on guiding the teams towards improving the way they work.
- Good understanding about Data Warehousing, Data Mapping and Data Modelling and experience in writing SQL queries for Data Extraction and Reporting.
- Used SQL to test various reports and ETL load jobs in development, QA and production environment.
- Worked with several reporting tools like Tableau, MS. Project, data extraction tools like Informatica and IBM Data Cognos.
- Good knowledge about using tools like HP ALM and JIRA for monitoring and tracking defects and identifying and bugs or issues.
- Acquaintance with White Box&Black Box testing, including unit testing, functional testing, system testing, integration testing and regression testing.
- Good knowledge in Software development methodologies such as Agile, Waterfall.
- Experience in working with the Test teams, creating Test Cases, Test Scripts and Test Plans.
- Creative thinker, excellent communicator, strong team player and organized professional.
- Excellent communication, writing and presentation skills. Experience working with Stakeholders, Business Owners and senior management.
TECHNICAL SKILLS:
Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2s
Modeling tools: Ms. Visio, BPMN, UML & Rational Rose, Data Modelling,Data MiningMethodologies: SDLC, RUP, Waterfall, Agile SCRUM
Project Management skills/Tools: Rational Clear Case, Rational Requisite Pro, MS Project, MS excel, Ms. SharePoint, MS. Access, Smart Draw, MS Visio, Rational Rose.
EMR Systems: EPIC (Radiant, Ambulatory, ER) MediTech, Eclinical Works, Athena, NextGen, MediTouch, Amazing Charts.
Business/Reporting Tools: Crystal Reports, SQL Server Reports (SSRS, SSIS),Tableau, MS Excel, MS Power Point, MS Word, MS. Office, SharePoint 2013,2010,2007.
Agile Tools: Jira,Rally
ETL Tools: Informatica and IBM Cognos
Testing tools& Supporting Tools: HP ALM, Test Director, JIRA, Rational Rose, Rational RequisitePro, White Box & Black Box Testing
Languages: HTML, XML, C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, Java, SQL.
Miscellaneous: Lean Management, Six Sigma, RTM, UAT, SWOT, HL7, Gap analysis, Risk analysis & JAD.
PROFESSIONAL EXPERIENCE:
Confidential, MN
Lead Business Analyst/Scrum Master
Responsibilities:
- Responsible for creating data mapping documents, business analysis documents, systems analysis documents and other documents
- Responsible for integrating with Facets Designing test scripts for testing of Claims in Development, Integration and production environment
- Translated requirements into system performance solutions and developed Implementation plan, Test Metrics and defined Metrics Tracking Strategy to be followed after each successive load test.
- Performed extensive data mining and abstracting of financial and clinical information from various sources
- Checked eligibility and case management with IBM Curcam software
- Performed and documented GAP analysis for HIPAA 4010-5010 and ICD9-ICD10.
- Validated all the Medicaid claims for new HIPAA 5010 standard.
- Tested the implementation of ICD 10 and HIPAA 5010 on MMIS system.
- Wrote test script, test plans for EDI 835, 837, 270, 271.
- Recommended a new SharePoint site collection. Design concepts, site planning, meetings, Q&A sessions, developed project plan.
- Responsible for Gathering High and low level requirement for ICD and HIPAA upgrade in MMIS using JAD sessions
- Responsible for analyzing business, functional and IT requirement documents and prepare complete Test Plans including system test plan, integration test plan, QA project plans and resource planning and allocation.
- Analyze claim payments to ensure that the payments follow State Mandates
- Created High and low level Use case diagram for HIPPA and ICD changes in MMIS.
- Worked on developing the business requirement and use cases for Facets batch process, automating the billing entities and commission process
- Troubleshoot any problems found within Facets and when testing the SQL data database while validating the business rule.
- Responsible for designing future state processes for ICD 9-10 Crosswalk Table and drafted High Level Business Requirements for ICD 9-10 conversion mapping.
- Worked extensively on the Procedure and Diagnosis Pricing and worked on the Reimbursement processing.
- Worked on CRM software to analyze customer data and make recommendations on sales, marketing and customer service initiatives to our Business team.
- Conducted Gap Analysis by brainstorming with Project managers, IT lead and Business users to get the low level “To Be”/ proposed environment
- Gained extensive experience in designing/modifying the CICS screens for various areas such as Enrollment, Billing, Provider Record and Reimbursement Status.
- Wrote test script for HIPAA 5010 and ICD 10functionality in MMIS.
- Documented business rules/functional requirements to support system enhancements with the minimal guidance of a senior associate
- Tested new ICD 10 procedure and Diagnosis code in EDI 837 and 835 X12 file format.
Confidential, Rochester,MN
Lead Business Analyst/Scrum Master
Responsibilities:
- Created and developed pre-implementation plans to assess the workflow process.
- Facilitated JAD sessions with the management team, radiologists, IT department and other stakeholders to discuss the requirements, analyze the needs and benefits and discuss the challenges involved.
- Conducted a work flow analysis to assess the current and future states of workflow and identify the best implementation process for CI-PACS in each radiology department.
- Conducted the GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system. Assisted in modeling the AS-IS and TO-BE business workflow
- Developed and followed agile project management plan (Agile Ceremonies). Facilitated build requirements log (product backlog) with cost estimates and priority.
- Conducted Scrum Daily standup, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.
- Responsible for Business, Functional, and Data Requirements for the customization and integration of the COTS Product: Xceediums Password Authority and Application-to-Application (A2A) Authority.
- Has led Business Intelligence reports development initiatives by working closely with Microstrategy, Teradata, and ETL teams.
- Determined the team capacity (velocity) from historical data. Created Work Break down structure (user stories) and corresponding activities (tasks).
- Communicated the progress to senior management thru 'Burn down Charts'. Monitored the Quality thru metrics and mentored team thru the project management processes
- Documented a high-level Business Requirement Document and System Requirement Document based on the information gathered through work flow analysis and JAD sessions.
- Assisted in creating WBS using MS Project to identify and allocate resources for the project
- Conducted weekly meetings with team leads from QA and Development team to explain functional requirement and answer any questions.
- Applied Unified Modeling Language (UML) methodology to create Use Cases, Activity Diagrams, and Entity Requirement Diagram & Sequence Diagrams using MS Visio .
- Ensured the system’s compatibility with HIPAA, security and Clinical Architecture Document (CDA) standards.
- Assisted in process of extracting data from the Clinical Data Repository (CDR) into the centralized system using ETL tool Informatica.
- Wrote SQL queries for data mapping and data integration into the new centralized system.
- Tracked and maintained requirements and changes using Requirement Traceability Matrix (RTM).
- Tracked and reported project milestones and presented status reports to senior management using MS Project.
- Worked with the IT, management team and vendors to obtain the necessary bandwidth and establish a WAN connection for integrating the system.
- Assisted in conducting training sessions using techniques like “train the trainer” for the radiologists and staff.
- Identified Defects using Defect Tracking tool, i.e . JIRA and captured them into defects tracking log-identifying priorities.
- Assisted in conducting Automated Regression Testing using WinRunner tool to verify the functionality of the system.
- Performed UAT along with the QA to assess the final implementation and functionality of the new system.
- Documented the UAT plan and worked with the QA team to ensure every acceptance criterion have been met for the effective operation of the system.
Environment: MS Project, MS Visio, MS Excel, JAD, HL7, HP ALM, Teradata, SAFe, HIPAA, JIRA, UML, Tableau, SharePoint, SQL Server, MS Office,EPIC Radiant, Meditech WinRunner& Informatica.
Confidential, Chattanooga, TN
Senior Business Analyst
Responsibilities:
- Identified and documented the dependencies between the business processes.
- Worked with HIPPA rules and regulations to draft business rules and claim processes.
- Developed logical system architectures and requirement documents and documented algorithms, user interfaces and program flows.
- Transmission of EDI files in ANSI 837.
- Performed SWOT and Gap analysis to evaluate business systems and to develop implementations to align system to overall business strategy.
- Interacted with the client and Technical Team for requirement gathering and translation of Business Requirements to Technical specifications.
- Conducted JAD sessions.
- Participated in daily scrum sessions, bi-weekly sprint planning and weekly backlog grooming.
- Configured SharePoint document libraries, intranet content, and team sites to implement business requirements
- Documented the Use Cases and prepared the Use Cases, Wireframes, Activity, Sequence diagrams and Logical views using MS Visio, MS Office, and Rational Rose for a clear understanding of the requirements by the development team.
- Used QTP to identify the test cases to be automated and performed data driven testing and GUI Check Points.
- Worked with the project manager in coordinating team activities and review meetings.
- Generated weekly reports for the senior management and collaborated between the team lead and development teams for clarification of issues.
- Responsible for overall project development cycle with RUP approach.
- Well versed with HIPAA, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing alternative solutions using best practice model and principles.
- Prepared test plans based on Business Requirement Documents (BRD) in HP Quality Center.
- Implemented the HIPAA privacy and security regulations to enhance the capabilities of the systems to process new products.
Environment: MS Visio, MS Excel, MS Word, Informatica, Windows 7, Share Point, Ultra Edit, Power Point.Microsoft SQLServer, SQL, Rally, Teradata(V5.3.3), Toad (3.8), Caliber, HL7, Toad-11, Tableau(9.0), HP ALM.
Confidential, New York, NY
Senior Business Analyst /Scrum master
Responsibilities:
- Conducted meetings with the Business users, Stakeholders and SME’s to thoroughly understand the scope of the project and the expected functionalities of to-be developed system.
- Facilitated JAD and Focused Group sessions with the Stakeholders and SME’s that helped in synchronizing in their objectives which helped the IT team in understanding the project more clearly.
- Analyzed, gathered and documentedBusiness Requirements Document (high level document) high level project plan and schedule for the project.
- Lead daily stand-ups and scrum ceremonies for two scrum teams.
- Work with product owners to groom the backlog and plan sprints. Track, escalate and remove impediments.
- Report at daily Scrum of Scrum meetings. Track burn down, issues and progress in Version One. Work with component teams to resolve issues.
- Implemented the RUP methodologies and standards throughout the project life cycle.
- Used Rational Rose to create Use Case, Activity and Sequence UML diagrams.
- Developed Flowchart and process diagrams using MS. Visio.
- Engaged with other Scrum Masters to increase the effectiveness of the application of Scrum in the organization
- Created Project plan, schedule and tracked and monitored the progress using MS. Project.
- Analyzed HIPAA 5010 related to 837, 835, 834 transactions and ensured the compatibility of new claim processing system with these transactions.
- Knowledge of ICD 9 and ICD 10 coding and claim processing.
- Implemented and combined all HIPAA standards, Electronic Data Interchange (EDI) transaction syntax like ANSI X 12, ICD9, ICD10 coding.
- Tracked and maintained Stakeholders requested enhancements and change requests using Requirements Traceability Matrix (RTM).
- Used Tableau to generate final reports to study and analyze the current and future business performance.
- Managed the requirements documentation using MS. SharePoint2013 and shared it with the team and business team on a timely basis.
- Assisted in the ETL process for Data Warehousing using Informatica tool by where data was extracted from the repository and was to be collaborated with the new system
- Assisted in the test team in conducting White Box Testing in unit, system and integration testing.
- Assisted the QA in conducting User Acceptance Testing (UAT) and verified the reliability and accuracy of the new system.
- Worked with the QA and test teams in identifying any defects and issues, monitored the status of issues using JIRA.
- Conducted review sessions with the Stakeholders, Business users and management team for the functional performance and accuracy of the system.
Environment: MS Office, MS SharePoint 2013, MS Visio, RUP, Rational Rose,SAFe, UAT, ETL, Informatica, JIRA, Tableau, UML, Gap analysis, MS. Project
Confidential, Philadelphia, PA
Business Analyst/Project Coordinator
Responsibilities:
- Responsible for creating a team that consisted of patient representatives, project manager to discuss issues and causes and identify and recommend solutions through discussions.
- Assisted the project manager in drafting a project charter and vision document.
- Surveyed the patients along with physicians to identify opportunities in reducing wait times.
- Conducted Gap Analysis to understand the current process and determine and recommend solutions to improve the process.
- Assisted the project manager in conducting a “Time Motion Study” to determine the relation between various tasks and the time needed to perform them efficiently.
- Performed a Root Cause Analysis to identify the exact causes of increased wait times in the ED.
- Used Value Stream Mappingusing Ms. Visioand gathered data to identify opportunities in reducing wait time for patients.
- Created Work flow and Process flow diagrams using MS. Project demonstrating the process of emergency department.
- Monitored and tracked the recommended process flow using Baseline Control Charts and recorded the new wait times.
- Created manuals for staff, clinicians, nurses, PA’s and physicians to understand and follow the recommended work order to reduce patient wait times and increase efficiency.
- Successfully completed the project with a result of reduced patient wait times by 30 minutes or 11% which resulted in improved quality of care and 48% increase in the patient satisfaction score.
Environment: Ms. Project, Ms. Word, Ms. Vision, FACETS, Quick Test Pro, Test Director, Windows XP, C#, PL/SQL, Oracle, UNIX, Manual Testing Six Sigma, Gap Analysis, Smart Draw, SixSigma.