Sr. Business Analyst Resume
Springfield, IL
SUMMARY
- 7+ years of experience with expertise in Business Analysis/ Data warehousing/Data Modeling and Business Intelligence reporting.
- Expert in creating inbound and outbound connections and associated action lists that facilitate the routing of HL7 interface messages between Meditech and Other Vendor applications using the Client - Server Engine
- Thorough understanding of Integration and operating HL7 interfaces using Ensemble Integration Engine
- Worked primarily on HIS systems such as MEDITECH v5.64 and v5.66.
- Expert in HL7 validation, EMR/EHR system conversion and EDI transactions for claim process
- Experienced in test management and defect tracking tools like HP Quality Center.
- Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
- Extensive experience in configuring data mapping between different Databases.
- Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
- Proficient in discussing and defining project, gap analysis with the clients from both as a business and technical perspective.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, Data Warehousing concepts and web design and development.
- Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
- Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
- Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) Extensive experience in User Acceptance Testing (UAT).
- Thorough knowledge in Scheduling & Tracking projects using MS Project
- Strong strategic thinking, interpersonal and presentation skills; excellent communication, analytical skills and conflict resolution skills
- Transaction Mapping of HIPAA conversion knowledge for 820 Payment Order / Remittance Advice, 834 Enrollment Files, 835 Claim Payment / Advice Files, 837 Claim PD&I Files, 276/277, 270/271 File Transactions in HIPAA Gateway and Batch Jobs Processing in Enterprise Scheduler such as Cisco Tidal.
- Executed Business Analysis & Supply Chain Methodologies and Iterative Software Development Life Cycle (SDLC) especially in relation with all the phases of Enterprise Resource Planning (ERP), Six Sigma, DMAIC, Rational Unified Process (RUP), Agile Processes (SCRUM), CRM (Customer Relationship Management) & People Soft Processes.
- Exceptional Problem Solving and Sound Decision Making capabilities, along with the ability to resolve difficult situations.
- Professional with extensive experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
TECHNICAL SKILLS
Project Methodologies: Rational Unified Process (RUP), UML, Agile, Waterfall
Business Modeling Tools: MS Visio, MS Project, Erwin
Requirement Management Tools: Rational RequisitePro, Infomatica Metadata Manager
Operating Systems: Windows NT/XP/2000, MS Dos, UNIX
Databases: SQL Server, MS Access
Languages: SQL, UML
Quality Assurance: Software Application Testing Life Cycle
Business Applications: Microsoft Office Suite- Word, Excel, Project Outlook and PowerPoint
Testing Tools: Quick Test pro, Quality center
PROFESSIONAL EXPERIENCE
Confidential, Darien, IL
Sr. Business Analyst
Responsibilities:
- Gathered reporting requirements from the data analytics team and prepared business Use Case/Functional Design Documents by interviewing customers, users, Managers and SMEs.
- Worked in Agile Product Development and Enhancement assignments. Worked closely with clients on a daily basis and gathered business requirements, wrote BRD and Functional Specifications for approval.
- Conducted BRD review meetings with business sponsors and client project management and obtain business approval and sign-off.
- Provided input to estimates for project management and change management activities through analysis of requirements effort, resources, and technology.
- Worked with Source system Subject Matter Experts (SMEs) to ensure that the extracts are properly mapped.
- Document business requirements specifications as stories, test cases.
- Document visualizations and get approvals from development team on feasibility of requirements.
- Create & own traceability matrix
- Support and own test case creation.
- Review & support test scenarios and test data creation.
- Extensive data analytics and preparation and delivery of presentations based on data inputs from primary sources.
- Directly worked with Product Management and Scrum Master to set release plans and prioritize product feature scope.
- Teamed up with both internal and external software development groups to provide functional requirements specifications in form of use cases, business process flows, and prototypes and management reporting requirements.
Environment: MS Office (MS Word, MS Excel, MS PowerPoint, HL7 v2.3, EPIC, Centricity, TIBCO Spotfire, Interface explorer.
Confidential, Springfield, IL
Business Systems
Responsibilities:
- Identify and gather business metadata artifacts to establish a baseline collection of resource information.
- Informatica platform for metadata manager and business glossary (v9.1) created business glossaries containing customized categories specific to HFS terminology.
- Developed the data lineage diagram reports.
- Gathered requirements, analyzed and working on the BRD for IES.
- Attended JAD sessions for requirement validation to gather requirement for the new MMIS.
- Perform Data Mapping from client database (CDB) to integrated eligibility system (IES).
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
- Enhanced reporting capabilities by design and implementation of additional actuarial data warehouse tables.
- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
- Worked closely with the development team to verify that business needs are fulfilled and deliverables are produced within specified budget, quality and time.
- Used ERwin for data modeling.
Environment: MS Office (MS Word, MS Excel, MS PowerPoint, Visio,ERwin, Informatica MDM and Teradata SQL Assistant)
Confidential, Anaheim, CA
Business Systems/ Integration Analyst
Responsibilities:
- Build MEDITECH v5.66 modules such as ADT, ITS and LAB and their workflow.
- Gathered user requirements and directed developers for practical deliverables.
- Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
- Enhanced reporting capabilities by design and implementation of additional actuarial data warehouse tables.
- Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
- Conducted Business Impact Assessment and the results were compared with the EHR standards to determine the current level of compliance and developed an action plan for approval by the project steering committee.
- 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 for the EHR and HIPAA compliance.
- Perform integration & system testing.
- Responsible for performing User Acceptance Testing (UAT) for each downstream apps with App Owner.
- Worked with business owners and development team to implement the changes required for HIPAA5010 EDITransactions (837,834, 835,270,271) in various phases of migration.
- Validating HL7 messages, transforming Business Requirements into System Requirements.
- Processing various HL7 v2.4 interfaces through Ensemble Engine as a part of Integration
- Worked with cross-functional teams (MEDITECH vendor, SJH build team and third party application owners) to provide needed assistance to Integration and/or third party applications team.
- Point of contact for open queries within Integration team.
- Performed registration, order entry, reports, validating charges etc. while performing UAT with third party applications.
- Implemented system integration testing using MEDITECH module HL7 messages and sending them though Interface explorer to validate them in Ensemble Integration Engine
- Provided end-user support for a specific application and translates those needs for developing test plans.
- Understand Project, coordinated with application users and other Vendors involvement in Project.
- Manage all communications between application users and Vendor.
- Participate in standardization of interfaces and setup meeting with other teams as and when required.
- Coordinate with Meditech team, Meditech Interface team and Engine migration team for the updates in the Meditech dictionaries, code change.
- Identified interfaces that need to be standardized and consolidated with timeline (immediate, future).
- Identify customs, standardize and categories like: "keep" or "retire" or "migrate to engine" or "comes with standard".
- Work with MEDITECH NMI (Non Meditech integration) Group.
- Analyze & understand the interface specification.
- Prepare interface vision diagrams.
- Project documentation for Ensemble interfaces.
Environment: WinSCP, Interface Explorer, Confidential Compare, Sybase, Ensemble, Meditech, Microsoft Word, Excel, PowerPoint.
Confidential, Eagan, MN
Sr. Business Analyst
Responsibilities:
- Interacted as SBC Health Care Reform Team’s Principle BSA to analyze and configure Health Care Reform system applications in current BCBSMN business and systems.
- Simultaneously gathered functional requirements for Claims (Data) Migration Project for NASCO and STAR Applications at BCBSMN.
- Performed Database Compares for 834 Enrollment Files, 835, 837 PDI Change & Audit Files.
- Conducted JAD sessions with business stakeholders to reach a decision on changing strategies regarding the way business will be conducted on the new platform.
- Analysis and Design of HIPAA X12 834 and 820 EDI Transactions for Health Insurance Exchange (HIX).
- Worked under the supervision of the Team Lead & Project Manager to gather requirements & functional specifications from Solution Architects, Business Users, Business Owners and Subject Matter Expertise (SMEs).
- Created Data mapping documents as per current benefit and coverage structure in SBC Templates and databases.
- Prepared Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according toUMLmethodology thus defining the Data Process Models and uploading documents in ReqPro.
- Performed GAP Analysis of business rules, business and system process flows, user administration and requirements to document the current as-is processes and the future to-be processes.
- Documented Data Sources, Data Types, Dependencies, and Flows and assisted in the Development, Maintenance, Enforcement, and Monitoring of Data Governance Processes.
- Created Translational / Transformation Rules for SBC Data Mapping under BCBSMN Benefit Management track.
- Created Business Requirements Document (BRD) creation for ICD 10 CM & PCS change implementation.
- Gathered and documented BCBSMN’s business requirements and developing, entering and verifying test cases for ANSI 5010 / ICD 10 Code Set Implementation and Configuration.
- Monitoring revenue cycle process and implemented ICD-9 & ICD-10 Mapping and Crosswalk Analysis with implementation of its EDI Codes Sets with Situational / Required Rules.
- Participating in assigned work group meetings and supports the development and maintenance of ICD 10 CM required documentation.
- Streamlined Claims (837 EDI X12) Migration project by gathering functional specifications.
- Documented Business Rules and Business Requirements for Claims Migration Project in order to align Third Party Vendors compliancy with current BCBSMN system by acting as a principle BSA for pre-adjudication process and claims processing for BCBSMN system and functional specifications.
- Performed and executed Integrity Testing, Requirement Testing, Balance Testing, Situational Testing, Code Set Testing, Line of Business Testing, Vendor / Trading Partner Testing according to HIPAA compliance with EDI Transaction as a means of communication.
- Facilitated UAT (User Acceptance Testing) with the stakeholders and the business users, and the errors discovered were fixed and then verified via Regression Testing.
Environment: MS Word, Excel, Rational Rose, Requisite Pro, SQL, MS Visio, PowerPoint, Java Scripts.
Confidential, St Paul, MN
Business Systems Analyst
Responsibilities:
- Gathered and analyzed business requirements by interviewing the Subject Matter Experts (SME’s), asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by business and the technical experts as well.
- Created the Requirement traceability Matrix (RTMs) for tracing the functional and non-functional requirements.
- Conducted analysis of HIPAA rules to ensure that the new applications are HIPAA complaint.
- Working on HL7 standard, LO INC and SNOMED codes to provide framework to carry our transfer of electronic healthcare information.
- Led and conducted JAD sessions to develop architectural solution that meets the business requirements, resolve open issues and change requests.
- Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project.
- Provided assistance to the HIV Surveillance staff with issues related to receiving and importing laboratory data into eHARS (Enhanced HIV/AIDS Reporting System).
- Created an implementation guide for the trading partners on how to do Electronic laboratory reporting to MDH.
- Created an MDH specific HL7 message guide for ELR messages to MDH in compliance to HL7 2.5.1 Implementation Guide for ELR to public health.
- Developed an ELR Registration Form for the interesting trading partners to start the process of ELR and MDH.
- Identified changes needed in the existing Minnesota Electronic Disease Surveillance System (MEDSS) to adopt ELR implementation at MDH through GAP analysis.
- Created implementation plan and test procedures for new ELR messages to MDH.
- Worked closely and effectively with existing messaging and MEDSS staff and other multifunctional terms.
Environment: MS Word, MS Excel, MS PowerPoint, MS Visio, SQL, Java Scripts, Rational Rose.
Confidential, Salt Lake City UT
Business Analyst
Responsibilities:
- Worked closely with software development, design and testing teams to determine best approach for the project.
- Attended Peer Reviews to improve the quality and depth of all deliverables.
- Communicated any requested changes to project scope and coordinates needs with Supervisor / Project Manager.
- Performed Database Compares for 834 Enrollment Files, 835, 837 PDI Change & Audit Files.
- Analysis and Design of HIPAA X12 834 and 820 EDI Transactions for Health Insurance Exchange (HIX).
- Conducted analysis of HIPAA rules to ensure that the new applications are HIPAA complaint.
- Followed the Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping and identified changes to create HIPAA Companion Guide for Confidential .
- Supported Development Team in creation of required design documentation.
- Worked with Testing Manager to review test case scenarios and facilitate completeness of test coverage requirements.
- Helped the testing team in carrying out manual testing and also assisted in writing test cases and a Test Plan.
- Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
- Bugs that would enhance the usability of the application were logged using Rational ClearQuest.
- Interacting with the developers on resolving the reported bugs and various technical issues.
Environment: MS Word, MS Excel, MS PowerPoint, MS Visio Lotus Notes, Rational Rose, Java Scripts.