We provide IT Staff Augmentation Services!

Senior Business System Analyst Resume

SUMMARY

  • Six years of extensive experience in the field of Business System Analysis, working with the technical staff to implement management and staff's business requirements into the web/ software application in Healthcare Industry.
  • Healthcare Business System Analyst specializing in systems implementations, configuration, business process management, process optimization and data analysis
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
  • Strong Knowledge of UML, FRS, and proficient in creating Use Cases, Sequence Diagrams, and Collaboration diagrams, Activity Diagrams, Class Diagrams etc.
  • Proficiency in analysis, design, development, testing, implementation, and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
  • Project Management, Business Analysis, Business Process Modeling, Data Modeling, Process Analysis, GAP Analysis, System Analysis, SRS (System Requirement Specifications), Process Reengineering, Uses Cases, Data Mapping, User Interface Specifications, Expense Management, Change Management, Testing (Test Cases/ Test Scripts/Test Plans) (Manual Testing & Automated Testing tools), Risk Management, Quality Assurance (QA), Documenting Process Flow, Re - Valuation (Pricing / Mark to Market) and Process Mapping.
  • Experience in analyzing large-scale data to identify new analytics, insights, trends and relationships with a strong focus on data clustering.
  • Proficient in agile practices and SAFe framework and created Agile documentation like backlogs, user stories, scrum board etc.
  • Experience in Medicaid Management Information System (MMIS). Expertise in various subsystems of MMIS, Provider, Recipient, Procedure Drug and Diagnosis (PDD), Explanation of Benefits (EOB).
  • Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
  • Defined/Developed/Tested Maps to customized daily load into FACETS for processing the transactions detailed Use Case to describe the functionality of the system including transactions, delivered Inbound/Outbound Facets interfaces.
  • Identified gaps between current policies and procedures and new HIPAA compliance and developed an action for the migration process.

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, .NET. XML, SQL.

Data Base: MS Access, Oracle (SQL Series), Teradata

Reporting Tools: Crystal Reports, SSIS, Web Services (API’s)

Operating Systems: Windows 8/7, Mac, Linux

Software: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Project, MS Office FrontPage, Lotus Notes, Visual Studio 2010.

Performance Testing Tools: Virtual User Generator, Load Runner

BI Tools: SAS, Cognos /reporting dashboards

Processes/Technologies: Rational Unified Process (RUP), Agile SCRUM, Waterfall, UML & Microsoft Office SharePoint

Automation Tools: Requisite Pro, Win runner, QTP, Jira, HP Quality Center/ALM, Junit

PROFESSIONAL EXPERIENCE

Confidential

Senior Business System Analyst

Responsibilities:

  • Involved in development & documentation of Software Requirements Specification (SRS) and using Rational Rose.
  • Gathering/validate requirements, writing the Business Processes Model notations (BPM), Procedures, Technical Documentation.
  • Worked on JIRA SAFe product ALM Platform with the Scaled Agile Framework to develop a tool and process configuration for clients
  • Performed business process GAP analysis and identified the areas to improve the efficiency of the business process. Created business process mapping document, analyzed the as-is business processes, and created a to-be process using MS Visio.
  • Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagram, ER diagrams Data Mapping
  • Remote install and configure Oracle APEX listener and Application Express on customer servers. Mentor customer development staff on developing APEX applications to integrate with Oracle EBS software. Develop documentation on best practices with APEX and Oracle PL/SQL development. Also developed sample applications for company to demonstrate APEX features.
  • Involved in the project for implementing Best Practices for Business Analysis in the organization and instrumental in the transition plan for Agile Development methodology using SCRUM.
  • Scaled Agile Framework for the Enterprise SAFe Leading transformation.
  • End-to-end performance tuning of Hadoop clusters and Hadoop MapReduce routines against very large data sets.
  • Develop implementation guidelines and principles for practice-based clinical applications, including various practice management and EMR systems.
  • Created and tested Scripts for the premium calculations and Claims limits and deductibles (Claims calculations).
  • Strong Data Warehousing ETL experience of using Informatica, Power Center Client tools
  • Participated in functional design sessions, creates, and executes SQL test scripts, and aids in the solution of data issues.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
  • Monitored claims operations metrics to ensure the operational effectiveness of the captive insured's business units and stakeholder medical malpractice claims operations.
  • Worked as a part of scrum team, in an agile methodology with sprint cycles, daily stand ups and story implementation. Large cross functional project and support teams.
  • Also working to develop best practices documentation for Oracle APEX usage in the group I am presently attached to with FDIC.
  • Evaluated business process requirements to ensure proper system configuration i.e. identifying key decisions, process changes, pain points, interface issues, training considerations, etc.
  • Managed/coordinated key claims operations projects including creating and maintaining project plans and schedules from concept to final implementation.
  • Experienced with various SDLCs like Waterfall, Agile, SAFe, Iterative, SCRUM methodologies for project delivery.
  • Developed application using Oracle APEX to validate the addresses based on the address type. Used ELS web service calls to implement the validations. Created PL/SQL procedures to call from Oracle APEX using On-Demand application process.
  • Created test plans and executing testing for application enhancements for captive claims operations.
  • Managed the team of consultants responsible for developing on-demand Medicaid Management System MMIS reports.
  • Writing Epics and user stories, managing sprints and backlog grooming, and tracking project progress in JIRA.

Confidential

Business System Analyst

Responsibilities:

  • Interacted with department heads to finalize business requirements, functional requirements and technical requirements and created Business process model.
  • Facilitated JRP sessions between technical and regulatory teams for meeting requirements as well as solving problems daily.
  • A Request for Quote (RFQ) is used when you know what you want but need information on how vendors would meet your requirements and/or how much it will cost.
  • Conducted end-to-end source to target validation of a sample of claims, encounters, pharmacy, eligibility, and provider by year.
  • Involved in defining the source to target data mappings, business rules, business, and data definitions
  • Worked in Agile environment allowing teams to deliver project piece-by-piece and make rapid adjustments as needed. Good understanding working in Agile and bringing projects to completion.
  • Interprets Claims Processing Business Rules, tests against MMIS functionality and translates differences into System Enhancements and/or Functional Defects.
  • Developed application using Oracle APEX to validate the addresses based on the address type. Used web service calls to implement the validations. Created PL/SQL procedures to call from Oracle APEX using On-Demand application process.
  • Timeline management of all HEDIS related data collection activities including HEDIS-related quality improvement projects.
  • Created frequency distributions of provider type, claims, aid category, by year, and analyze patterns.
  • Used JIRA to perform test management activities and used JIRA tool to track and maintain different versions of the project documentation.
  • Analyzed large amounts of data sets to determine optimal way to aggregate and report on it.
  • Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand-ups, Sprint Check-In, Sprint Review & Retrospective.
  • Formulated SQL queries, functions, and processes as per customization requirement for APEX.
  • Designed application framework and developed Oracle APEX Application.
  • Provided support to develop the entire warehouse architecture and plan the ETL process
  • Experience in database design, modeling, development, and maintenance including creating ETL procedures using tools like Informatica, Ab Initio, Data Stage, SQL Loader
  • Analyzed and created design document for entire data conversion process, which uses Extraction, Transformation, and loading process (ETL) related to Budget, Forecast, Actuals based on the Profit Center & Cost Center hierarchies to the reports.
  • Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
  • Facilitated JAD sessions for Requirement Validation and requirement gathering for the new MMIS.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Involved in designing & testing the ETL process flow and automated process chain
  • Used Rational Requisite Pro to improve the communication of project goals, enhance collaborative development, reduce project risk, and increase the quality of application before deployment.
  • Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modelled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
  • Fine-tuned search engines pulled data from different databases and migrated data back and forth using SQL.

Confidential

Business System Analyst

Responsibilities:

  • Liaison between the client and development team to support the client’s data analysis and reporting needs.
  • Trained the team on JIRA tool for Agile/ Scrum Methodologies.
  • Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility, ensured consistent application of SCRUM methodologies across the enterprise
  • Perform integration testing for a Medicaid Management Information System MMIS database conversion project.
  • Involved in the project for implementing Best Practices for Business Analysis in the organization and instrumental in the transition plan for Agile Development methodology using SCRUM.
  • Expertise in implementing the agile, Rational Unified Process and Waterfall Methodologies throughout the Software Development Life Cycle of the project.
  • Supported APEX applications and conducted performance tuning for PLSQL.
  • Performed requirements analysis and using Rational Rose and Smart Draw created UML specifics such as data flow diagrams (DFDs), ER diagrams, Use cases, Class, Sequence, Collaboration and Deployment Diagrams.
  • Create various Data Mapping Repository documents as part of Metadata services (EMR).
  • Worked as a part of scrum team, in an agile methodology with sprint cycles, daily stand ups and story implementation.
  • Involved in development of the system for data exchange from EMR, EHR to Electronic Lab Reporting Systems.
  • Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary
  • Contributed with database designs and assisted in increasing response time for APEX reports.
  • Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds.
  • Wrote functional requirements and non-functional requirements based upon the approved business requirements by following UML processes and standard procedures for developing use cases, use case diagrams, and other supporting documentation.
  • Extensive working experience with HL7, EDI X12 transactions, Facets process, HIPAA, Billing Process etc.
  • Designed application framework and developed Oracle APEX Application.
  • Involved in creating test cases for 834, 837, 820, 270/271 transactions and validating the EDI files.
  • Maintain knowledge on working of all HIPPA EDI protocols and map all data for various ERP systems and applications and perform audit on all EDI processes to maintain accuracy
  • Engaged in analyzing requirements, identifying various individual logical components, expressing the system design through UML diagrams
  • Performed felid-by-field mapping of interface between parent EMR system and downstream system.
  • Setting up document hierarchy and standards to define different level of requirement using Rational Requisite Pro.

Confidential

Business System Analyst

Responsibilities:

  • Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus for BRD and FRD and business docs.
  • Involved in preparing several Use Cases, Business Process Flows, and Activity Diagrams using Microsoft Visio.
  • Conducted and analyzed technology processes by requirement performance modeling UML and prepared essential groundwork.
  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed, and sent to an external entity.
  • Performed testing for Medicare, Medicaid, and X-Over claims for Medicaid Management Information System (MMIS)
  • Ability to analyze engineering product support issues described within a bug-tracking system (JIRA) and provide guidance to other Client Services members in an advisory capacity, focusing on the quick resolution of the production issue and using this as a training opportunity for other team members.
  • Facilitated JAD session to find out the impacted area of functionality of Facets due to upgrade and cooperate with developer to come up with solution.
  • Communicate with vendor to regarding new updates on Facets and solution to their existing system
  • Used FACETS Analytics for fast and easy retrieval, display and grouping of information for performing queries and generating reports.
  • Facilitate all agile ceremonies including daily stand-ups, weekly grooming, retrospective, and review and planning session.
  • Experienced working in Facets online modules such as Billing, Provider, Claims and Membership modules.
  • Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
  • Worked on Audit/Edits reconciliation for claims codes to correct any configuration and documentation inaccuracies and updated Audit, Edit and Claim Check Manuals as required.
  • Designed and created SQL Databases tables, indexes, and views, User Defined Functions, Stored Procedures and Triggers based on user requirements.

Hire Now