Sr. Business System Analyst Resume
5.00/5 (Submit Your Rating)
Nyc, NY
SUMMARY
- More than 8+ years of proactive IT experience working as Business/System Analyst in Healthcare industry with expertise in Healthcare Systems ITS, Health insurance plans Indemnity plans, Managed Care plans HMO, PPO POS, Government Sponsored Programs Medicare, Medigap, MMIS, FEP SHBP Consumer Driven Health plans CDHP. Medicare Part A, B, C, D and Medicaid systems
- Experienced and in - depth knowledge of all phases of System Development Life Cycle (SDLC) methodologies such as Waterfall, Agile-Scrum, and Waterfall-Scrum Hybrid.
- Skilled in creating operational workflows, data diagrams, and other industry standard documents to represent client's business processes and other needs.
- Extensive experience in Unified Modelling Language diagrams (like Use Case, Activity, Sequence, data flow) and charts (like velocity, burn down charts) respectively using Rational Rose, TFS, JIRA and MS Visio.
- Widespread knowledge of EHR/EMRs Electronic Medical Records, HL7 and its Patient Protection and Affordable Care Act PPACA.
- Familiar with HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278 etc.
- Good knowledge and extensively used RDBM, SQL, along with MS SQL administration, SQL Enterprise Manager, Data analysis and reporting.
- Proficient in all phases of Requirement Management; including gathering, analyzing, detailing and tracking requirements using RTM or JIRA/TFS. Experienced in creating Business Requirements Document (BRD), Functional Requirements Document (FRD) or user stories with acceptance criteria.
- Working knowledge of MMIS (Medicaid Management Information System), HIX (Health Insurance Exchange), EMR (Electronic Medical Record), EHR (Electronic Health Record) and healthcare reforms like the Patient Protection and Affordable Care Act (PPACA), Emergency Medical Treatment and Active Labor Act (EMTALA).
- Familiarity with current technology and industry standards such as APIs, FHIR, JSON etc.
- Facilitated scrum meetings (all phases including the release planning, grooming, sprint planning, retrospectives, daily stand-ups, etc.)
- Extensive Experience in Functional, Integration, Regression, User Acceptance UAT, System.
- Experience in Database design and development using Oracle 10g, and Oracle PL/SQL. Experience in Database Performance tuning and SQL query optimization.
- Experienced with HIX Health insurance Exchange, PPACA Patient Protection and Affordable Care Act, Plan Management, Eligibility and Enrolment process, SHOP Small Business Health Options Program as well as Financial Management.
- Working knowledge of Health Insurance Programs (Medicaid, Medicare Part A, Part B, Part C, Part D) and Managed Care Programs (HMO, PPO, POS), with expertise in paper claim forms (CMS 1500, UB 04).
- Experience in creating Test Plans, Test Scenarios and Test cases and documenting project processes and procedures.
- Experience in EDI automated first-pass claim adjudication, requiring thorough understanding of claim processing, both front and backend operations
- Excellent ability and capability to interact with customers. Self-motivated with effective communication skills and strong background in multiple tasking. Ensure that value is delivered by deriving the need of the client.
PROFESSIONAL EXPERIENCE
Sr. Business System Analyst
Confidential -NYC, NY
Responsibilities:
- Functioned as the liaison between the line of business and the technical teams throughout the project life cycle.
- Conducted Joint Requirements Planning (JRP) sessions with the Subject Matter Experts (SME) and the key stakeholders to understand business requirements and the functionalities in detail.
- Demonstrated understanding of best practices for the architecture, processing, analyzing, modeling, and managing of healthcare data, using Infrastructure as a Service (IaaS) for cloud migration
- Assisted with the implementation and ongoing support of the Health Insurance Exchange HIX environments.
- Extensively working with HL7 messages like ADT, ORM and ORU during while integrating iHelix with the existing applications.
- Involved in implemented SOAP and FHIR based Web Services in Cloverleaf Integration Engine using Web Services adapter.
- Designed Test Plans and Test Cases for User Acceptance testing (UAT) with the help of QA teams.
- Requirements review through rally and system walkthrough with the architect, developers and testing team.
- Utilized Agile Software Methodology using Scrum framework. Actively participated in creating the user stories and prioritizing user stories along with tracking of burn up, burn down charts to estimate sprint delivery.
- Developed User Accepting Testing (UAT) plans and test cases based on the business requirements.
- Analyzed trading partner specifications and created EDI mapping guidelines.
- Facilitated project management using JIRA Task Manager Platform for all sprint related stories and epics with bi- weekly sprint planning and backlog grooming.
- Conducted GAP analysis for identifying improvement areas from on premise data center to the Amazon Redshift.
- Worked on the screenshot and prototype development for the various online screens meant for the EHR project.
- Providing functional support for HR, Payroll, MSS applications and their interface.
- Developed and executed SQL queries on claim records to validate reporting.
- Analyzed the risks involved by conducting SWOT and Cost-Benefit Analysis in Microsoft Office Environment.
- Used Agile and Rational methodology in the project development for Rational Test Suite for various phases of RUP.
- Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for 837, 270/271, 276/277, 835, 834 EDI transactions.
- Maintained Gitlab repositories, JIRA bug tracking system. Created custom JIRA workflows.
- Involved in creating Unified Modeling Language (UML) diagrams including Activity Diagrams, Entity relationship diagrams and Use Case Diagrams.
- Converted HL7 data to FHIR resources (Patient, Medications, Organization, Location and Practitioner) to exchange data with Pharmacy systems Integrated with FHIR. created a RESTful web service for allergies department using FHIR coding standards.
- Collaborated with Systems Architect in constructing the Architecture Diagram depicting the data migration from On-premise servers to Amazon Redshift data warehouse.
- Implemented Transformation rules for migration, facilitated creating ETL jobs using AWS Glue
- Ensured Data Quality and Data Integrity is maintained throughout the Project Lifecycle
- Well versed with EPIC, EMR systems, EPIC bridges, EHRs, Mirth and Production support processing problems by being one of the chief sources and providing alternative solutions using best practice models and principles.
- Knowledge of Cost Accounting software and Oracle based databases
- Being able to adapt and work efficiently in an agile environment where the cumulative Standard Operative Procedure (CSOP) and Policy directives and decision Matrix documents were in process and unstable during the initial phase of the project.
- Worked with testing team of HL7 Message Validation and sending of ADT Messages like ADT A01, ADT A04 and ADT A08.
- Maintained Kanban boards in JIRA, involved in creating Static Prototypes using HTML for an overview of the Graphical User Interface.
- Work with Product Owner and development team to prioritize user stories in the product backlog; as well as, mitigate any issues that impeded the completion of Sprint objectives.
- Main role was to gather requirements Health Insurance Exchange HIX and add those changes to the present system.
- Developed implementation guidelines and principles for practice-based clinical applications, including various practice management and EMR systems.
- Tested the requests and responses provided by the Restful Web Services using Postman plugin for google chrome and standardized them to the format required by the application.
- Continuous communication with the team to track requirements on rally and discuss to fix defects with JIRA tools, and corrected lesson learnt from each sprint.
- Involved in creating requirements that comply with HIPAA, HL7, and ANSI X12 format regulations to protect the privacy of the employee insured under any policy.
- Collaborated with the Quality Assurance team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
Business System Analyst
Confidential -Dallas, TX
Responsibilities:
- Responsible for proactively identifying opportunities for improvement throughout the business which could include working with department management to create a business case detailing the cost/benefit of the improvement.
- Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
- Strong understanding of the business functionalities like Medicare, Medicaid, Tricare, Workers Comp, Commercial Claims, Bulk Billing, Denial Analysis and Insurance specific trends.
- Involved in creating role-based matrix, decision tables when required as per the requirements through the project.
- Worked on HCM setup for company information, location, department, salary grades, job codes, benefit programs, plan types, pay groups and other payroll related issues.
- Facilitated all Aspects of scrum framework, including product backlog, release backlog, sprint planning session, daily scrum meeting, sprint reviews and sprint retrospectives.
- Involved in developing Procedures, Functions, packages and triggers in PL/SQL.
- Worked with testing team for testing the requested web services in JSON format using Apigee and validation of HL7 message via FHIR API using POSTMAN and documented RESTful API and Streaming API with the help of SWAGGER.
- Excellent knowledge and enacting of HIPAA (Health Insurance Portability and Accountability Act) transaction sets such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 835 (payment or remittance advice).
- Prepared UAT Test plan and coordinated UAT with stakeholders and business users.
- Captured all the user stories in Rally the agile based tool.
- Used Jira Agile management tool to maintain team metrics and make visible to team (including burn down charts) and Work as a Jira admin assign new user to project, delete user and Create Project.
- Gained extensive experience with HL7 for various interfaces.
- All MITA business processes were reviewed and a feasibility study was conducted to integrate the EHR Provider Program business process into standard MITA business process.
- Identify and Review the HIX Work track 12 reports and compare with the Contract Reporting section.
- Successfully interpreted data to draw conclusions for managerial action and strategy.
- Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis.
- Experienced with various database objects to write SQL queries on multiple databases like MS SQL Server, MS Access and Oracle databases.
- Strong understanding of various SDLC methodologies such as RUP, Waterfall and Agile with hands on experience in all of them.
- Developed and implementing change control policies and procedures for EMR template change requests.
- Worked on Health Insurance exchanges HIX and analyzed the data and worked with EDI NCPDP considerations and implemented HIPAA regulations.
- Involved on writing PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
- Collaborate with both technical and business stakeholders to understand reporting and data requirements based on customer and internal needs.
- Using Rally tool to capture all the Business and Technical User stories
- Involved in daily scrums and all scrum activities-Sprint Planning, Sprint Reviews and Sprint Retrospectives and works as agile coach throughout the project.
- Modified and translated segments of HL7 messages to properly send to EPIC.
- Conducted Walkthroughs and Meetings involving leads from Development, QA, Database and Technical Support teams to validate the Budget planning for Amazon services.
- Responsible for identification and analysis of errors/inconsistencies in the data and provides timely resolutions.
- Proficiency with Microsoft Office applications (Word, Excel, PowerPoint, and Visio and Project Management Software), and Atlassian (JIRA, and Confluence).
- Analyzed on the technical and functional requirements for FHIR (HL7) conversions to X12 files and electronic payments.
- Reviewed MMIS documents to understand the customer requirement
- Provide ad-hoc and structured reporting document to partners and stakeholders.
- Was involved in maintaining dashboards, reports, visualizations, and alerts that concerned business decisions.
- Involved in creating documents like Root-Cause, Cost-Benefit, SWOT and ROI with excellent track record as a JAD facilitator and knowledge of all the best practices for requirements gathering.
- Prepared data analysis, writing data mapping documents, data transformation rules and maintained data dictionary for business intelligence and data warehouse applications.
- Used industry standards like ISO, Six Sigma and HIPAA within the project
- Single point of contact between business users, development teams and QA teams for sign-offs and finalization of requirements.
- Developed strategies with Quality Assurance group to implement Test scripts in HP/Mercury Test Director for stress testing and UAT (User Acceptance Testing)
- Worked with SME on different subject areas including state reporting, death benefits, Medicare, Bill review and RX eligibility.
- Tested the HIPPA EDI, 834, 270/271, 276/277, 837/835 transactions according to test scenarios and verify the data with Facets on different modules.
- Skilled in using change control and bug tracking tool JIRA for identifying, analyzing, assigning and documenting defects including version and change control.
- Involved in creating sample mappings for the conversion of EDI x12 transactions code sets.
- Assisted clients in resolving billing issues for Medicare, Medicaid, and private insurance.
- Used complex SQL queries to analyze the data pattern to accommodate the various business scenarios.
Business System Analyst
Confidential -Salt Lake City, UT
Responsibilities:
- Collected the EDI files from testers and send it to the suppliers after a high-level validation of the 850 and 844 EDI files.
- Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
- Gathered high-level requirement for all the external projects in a release.
- Performed the requirement analysis, impact analysis and documented the requirements.
- Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
- Involved in generating reports such as burnout chart, velocity chart and defect reports using Rally.
- Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
- Worked on FHIR conversion to be able to provide a 360-patent view from Hospital Discharge to Long-term Care, Home Health or Senior Living.
- Provided business and mapping expertise during a transition of the EDI applications from the GXS Application Integrator (AI) to GIS.
- Prioritized the sprint backlog and came up with techniques/tools to efficiently manage Sprint backlog.
- Involved in developing, executing and managing User Acceptance Testing (UAT), Quality Assurance (QA) in reviewing Test Procedures and Test cases, reviewing and maintaining Test script both manually and Automated.
- Did GAP analysis by comparing the past HIX reports with present Contractual Reports to create the Future Reports.
- Helped lead the transition of Requirements Management in the Business Analyst Team to the agile methodology by creating and managing user stories and Requirements Traceability Matrices in the JIRA toolset.
- Exposed to using ANSI/HL7 coding standards in Medicare and Medicaid domains of the healthcare systems and industry for both Inpatients and out patients.
- Performed Analysis on Data mapping between different data models.
- Provide ad-hoc and structured reporting document to partners and stakeholders.
- Responsible for gap analysis in changing old MMIS and Involved in testing new MMIS.
- Directly interacting with the stakeholders to elicit the requirements and translate them into technical user stories, user stories and acceptance criteria for teams and documenting them in tools like Wiki and Jira.
- Performed Backend testing by using PL/SQL queries to test the integrity of the application.
- Developed Test Cases for unit testing, prepared spreadsheet for testing criteria, including regression, positive and negative testing, process flow testing and screenshot for test results to complete expected and actual results.
- Participated in decision around data warehouse architecture and more specifically data models and database design and code complex programs, database scripts, and ETL packages that meet data flow.
- Facilitated Sprint planning, daily Scrum meeting, Backlog Grooming, Sprint retro & Sprint review.
- Improved TFS (Team Foundation Server) functionality by designing efficient hub of documents related to processing, SQL scripts, SSIS packages, UAT planning, test cases etc.
- Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Worked on Healthcare system implementation including enterprise Electronic Medical Records EMR and Electronic Health Records EHR software.
- Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations if any.
- Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
- Modified and translated segments of HL7 messages to properly send to EPIC.
- Analyzed and documented MMIS Claims business rules, edit rules, audit rules, to create and process unit and string test cases to verify and validate updated programs.
- Maintained a close and strong working relationship with teammates and management staff to achieve an expected QA result for the project team.
Business Analyst
Confidential -Provo, UT
Responsibilities:
- Performed extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows.
- Identified the business users who will use the new application. Summarized the primary job responsibility for each user. Also identified client business needs, problems, and desired outcomes and established a common understanding of the business problems and possible solutions.
- 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
- Responsible for eliciting, analyzing, document, business requirements, functional and non-functional specifications based on DCO sessions with business unit stakeholders and technical team members, SMEs.
- Worked with System Architects, and other project members collaboratively and iteratively to create the content in the artifacts like Application Profile, Application Specifications, Application Requirements.
- Used Agile Workbench to directly capture user stories and used JIRA for issue tracking and generated reports to analyze the performance of the project/team.
- Involved in creating requirements that comply with HIPAA, HL7, and ANSI X12 format regulations to protect the privacy of the employee insured under any policy.
- Assisted Product Owner in define Acceptance Criteria for User Stories, DOD, DOR.
- Involved in creation of Mock-Ups and Wireframes of user interface using Pega's UI Designer for client verification.
- Performing business analysis, software validation and testing for client/server, multi-tier and web-based applications for EMR and commercial business for managed healthcare plans and Industries.
- Involved in designing, documenting and determined n-tier architecture for the claim processing system.
- Worked on HIPAA Standard/EDI standard transactions: 270, 271, 276, 277, 278, 834, 835, and 837 (P.I.D), 997 and 999 to identify key data objects.
- Basic understanding of Healthcare Jargons such as Health Insurance Exchange HIX.
- Used Connect SQL rules to run SQL statements like joins to verify the authenticity of the data.
- Involved in designing an Objected Oriented Security model for different Access Groups and assigned different roles to the Users.
- Defined the Correspondence and Notification needs of the system and identified the triggers for the correspondence.
- Assisted QA team with Test Planning, Writing the test cased and Test Scenarios, Defect Tracking and Test Results.
- Involved in developing, executing and managing User Acceptance Testing (UAT).