We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

0/5 (Submit Your Rating)

Bronx, NY

SUMMARY

  • Over Eight years of experience as a Business Systems Analyst/System Analyst in Health Care, and Insurance industry.
  • Broad domain exposure in the areas of EDI, HIPAA Testing privacy with multiple transactions related to claims, payments, registration etc and extensive knowledge in Medical Management Information Systems (MMIS) and National Provider Identification.
  • Well Familiar with current industry standards, such as HIPAA, SOX, ISO, Six Sigma, and Capability Maturity Model (CMM).
  • Strong experience of working with Medicare and Medicaid insurance data, Medicare parts (A, B, C & D) and insurance claims.
  • Excellent experience and exposure in gathering Business and Functional Requirements, Business Scope and Vision Document, developing Business Requirement document, Functional specification document, communication plan, Use cases, conducting Gap Analysis and Risk Analysis.
  • Extensive experience in UML diagrams (Sequence diagrams, Activity diagrams) and writing Use Cases, Business process, work flows, process flows using Microsoft Visio.
  • Involved in Software development processes using SDLC, RUP and RAD and proficient in applying RUP in all the four phases of development.
  • Conducted JAD sessions and interviews. Adept in implementing requirements, creating project status reports and presentations.
  • Extensively worked with Enterprise Content Management and Data models and Meta data definitions for content management.
  • Good project management skills including business analysis, strategic planning, problem solving and decision making abilities. Can work under pressure, enjoy working with teams and yet flexible to take independent responsibilities.
  • Adept in conducting Use Case Analysis, Impact Analysis and Requirements Traceability.
  • Strong knowledge of Data Modeling, Data Warehousing and Data Mapping.
  • Experience in RDBMS and Data Ware housing experience in design, development, testing, implementation and support of enterprise data warehouse.
  • Experience in development of ETL mapping scripts.
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.
  • Well versed with ICD9, ICD10, CPT, HIPAA, claim adjustments, claim processing claim review, identifying claims processing problems, their source and providing alternative solutions.
  • Developed Test plans, Test cases and Test scenarios to be used in testing based on business requirements, technical specifications and or product knowledge.
  • Experience in working with Microsoft Office suite (word, excel, Access, Visio, PowerPoint and outlook) for documentation, analysis and presentation

TECHNICAL SKILLS

Operating Systems: Linux, HP UNIX, Sun Solaris and Windows 2000/XP/Vista

MS Office Tools: MS Word, MS Excel, MS Access, MS PowerPoint 2003/07, MS SharePoint

Languages: SQL, PL/SQL, JAVA

Packages: MS Office, MS Visio, MS Project

Tools: CVS, Subversion, Rational Rose, HP Quality Center, Win Runner, Load Runner, FileZilla

Databases: Oracle, MS Access, SQL Server 2000, Sybase

Methodologies: Rapid Action Development (RAD), Joint Application Development (JAD), Rational Unified Process (RUP), Unified Modeling Language (UML), System Development Life Cycle (SDLC), Waterfall Model.

PROFESSIONAL EXPERIENCE

Confidential, Bronx, NY

Sr. Business Systems Analyst

Responsibilities:

  • Extensively involved in gathering requirements from clients and created Business Requirement Document (BRD) and facilitated in creating System Requirement Specifications (SRS) Document.
  • Analyzing Business requirements and segregating them into high level and low level Use cases, Activity diagrams, State chart diagrams using Visio according to UML methodology.
  • Applying RUP methodology with its various workflows, artifacts and activities throughout the software development life cycle from Inception to Transition phase.
  • Involved in JAD sessions with SMEs and business users to analyze and gather the requirements for UI.
  • Responsible to insure that EDI Process is HIPAA (Health Insurance Portability and Accountability ACT) compliant and worked on ANSI X12 standards.
  • Working on EDI transactions: 270, 271, 835, and 837 to identify key data set elements for designated record set.
  • Active involvement in daily triage calls discussing blocking issues, defects and troubleshooting if and when required.
  • Created Views, Alerts and Custom Lists in SharePoint.
  • Developed collaborative, portal, and Content Management solutions using SPS 2003 by analyzing user requirements and processes.
  • Expert in understanding the root cause of the defect and overall impact on validation cycle execution.
  • Responsible to run specific and customized SQL queries in brokerage data warehouse Production for the business requirement proposes along with Service Oriented Architecture (SOA).
  • Analyzed the impact of ICD - 10-CM/PCS coding system and Identified General Equivalence Mappings to facilitate the conversion from ICD-9-CM codes to ICD-10-CM/PCS codes to ensure that both the application and Health Record comply with new regulations.
  • Acting as the primary liaison between the business stakeholders and technical teams to make communication and development efforts more effective.
  • Involved in creating test cases for system testing (Development environment), Integration testing, Regression testing and User Acceptance testing.
  • Good knowledge of using SQL and PL/SQL to access databases (Oracle, Sybase).

Environment: Windows NT/2000, MS SQL Server, Rational Unified Process (RUP), UML, Rational Rose & Requisite Pro, Mercury Quality Center, Clear Quest, MS Office Tools, MS Outlook.

Confidential, Tarrytown, NY

Sr. Business Systems Analyst

Responsibilities:

  • Prepared the appropriate documentation (BRDs and SRSs) to communicate and validate the information.
  • Worked closely with a project team for gathering business requirements and interacted with business users to translate business requirements into technical specifications.
  • Developed functional specifications and system design specifications per trading partner requests.
  • Performs As-Is/Current-State analysis and drafts To-Be/Future-State process based on identified requirementsin Visio as process and/or data flows.
  • Responsible for management of claims fraudand abusedata analysis. Presented quarterly reports/findings to executive staff.
  • Performed as a single point of contact for all extracts (member eligibility, provider, product, medical and pharmacy claims) in documenting technical requirements, detailed data analysis, data mapping and verification andvalidationtesting.
  • Provided comprehensive data selection criteria, and clear data mapping to the development team.
  • DemonstrateduseofUse Cases,UML, Context diagrams, Swim Lane diagrams, Data Flow (DFD) diagramsetc.
  • Executedthe project plan for those areas of the SDLC that span from Planning through Testing.
  • Assisted in moving contractual information needed for claims processing from claims software to intranet site to facilitate claims processing.
  • Extracted large volume of data feed from different sources, performed transformation and loaded the data into various targets.
  • Create data flow diagrams, data mapping from source to stage and stage to target mapping documents indicating the source tables, columns, data types, transformation required and business rules to be applied.
  • Implemented CDC (Change Data Capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
  • Manage work/time to optimize client interactions. Includes: preparing for sales calls to clients, placing outbound calls to existing clients/prospects, setting and holding regular (quarterly) meetings with current and prospective clients, gathering and documenting information to ensure compliance requirements are met, facilitation of appropriate business processes and the monitoring of interactions and next step.
  • Designed Informatica mapping such as pass through split, Type1, Type2, and used various transformations such as lookups, Aggregation, Ranking Maplets, Connected and Unconnected lookup, SQL Overrides etc.
  • Validate ETL mappings and tuned them for better performance and implemented various performance and tuning techniques.
  • CreatedandMaintainedRequirement Traceability Matrix (RTM), tracking relationships between Requirements, Use Cases and TestCases (using Rational RequisitePro).
  • Worked on Microsoft Dynamics CRM integration with Informatica Cloud
  • Worked with HIPAA transactions sets for 4010/ 5010 support in 837I & 837P claims data for ICD-10 compliance.
  • Gathered requirement documents for transition fromICD-9 to ICD-10
  • Audited coverage determinations to ensure Centers for Medicare and Medicaid Services (CMS) policies and procedures were followed appropriately.
  • Performed GAP analysis between areas to flush out requirements and explore opportunities of improvement.
  • Host and/or facilitate team meetings for cross dependencies between tracks.
  • Identify areas of business process improvement and supported in facilitating which resulted in reduce cycle times by 50%.
  • Analyzed different data crosswalks, complicated logic & looks up required by different fields for the source to target transformation.
  • Perform Unit and Regression Testing, for Configuration updates and changes for all aspects of claims processing andpremiumbilling.
  • Provided first-tier production support for allperformancemanagementsystemissues.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Ensured all documents created followed standards and uploaded into TFS andSharePoint.
  • Effectively managed work load on multiple initiatives concurrently, with a very tight timeline.

Environment: HIPAA, Rational Unified Process (RUP), UML, EDI, Oracle, Rational Rose, Requisite Pro, Windows XP, HP Quality Center, MS Office Suite 2010(Excel, Word, PowerPoint),, MS Project, MS Visio, PL/SQL, Query Analyzer, Team Foundation Server, MS SharePoint 2010

Confidential, Rockville Maryland

Systems Analyst

Responsibilities:

  • Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
  • Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
  • Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
  • Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
  • Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
  • Experience in EDI automated first-pass claim adjudication, requiring thorough understanding of claim processing, both front and backend operations.
  • Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.
  • Designed the online screens and reports for the Medicaid Online Electronic Claims Submission System.
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
  • Conductedinterviews, meetings and JAD sessions during the process of Requirement Gathering.
  • Planned and documented procedures for data processing and prepared data flow diagrams for the application.
  • Identified/documented data sources and transformation rules required to populate and maintain Data Warehouse Content.
  • Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
  • Participated in the development of the Data Modeling methodology to be used in the project.

Environment: Windows 2000/XP, Microsoft Office SharePoint, Cobol, DB2, Cognos, Java/J2EE, HL7, Rational Requisite Pro, MS Office, SQL Server, MS Project, MS FrontPage, MS Access, EDI

Confidential, Madison, WI

Sr. Business Systems Analyst

Responsibilities:

  • Involved in gathering Business Level Requirements and reviewed manual testing methods
  • Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
  • Identified the data requirements for the application and wrote the data dictionary for insurance products.
  • Interacted closely with End users from Underwriting & Claims teams and SMEs to understand and gather the business needs and requirements.
  • Responsible for strategic direction of the content from individual sites to be migrated on to the Portal.
  • Use SQL*Loader utility to upload data files into tables, Export and Import Oracle Utilities to move tables between Schemas.
  • Integrated Audience based Web Parts, Reminders, SharePoint custom style sheet, Security groups and permissions.
  • Assigned to take over a floundering content management project using the Team site architecture and bring it to the point where it could be launched.
  • Potential users developed detailed gap requirements to bring the project up to speed including details content data model documentation and application flow.
  • Performing data analysis by identifying the different data sources, creating logical data models and establishing relationship between entities.
  • Developed complex multilevel workflows that will send email notices to the users and approvers using SharePoint Designer.
  • Performed initial manual testing of the application as part of sanity testing
  • Managed the whole testing process using Mercury Interactive Test Management tool Quality Center.
  • Used SQL and MS Excel using macros for all Data validation based on the Business Rules.
  • Created dummy accounts on our system and verified the account generation process and date integrity
  • Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
  • Participated in designing and coding for web forms of the application withASP.NET.
  • Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
  • Created reports using Mercury Interactive Test Director.
  • Developed Shell Scripts to automate loading processes.
  • Created test cases and scenarios for Unit, Regression, Integration as well as Back-end, GUI and Black box testing.
  • Used SQL queries to the integrity of data by querying the databaseInteracted with the development team to assure that all the defects are addressed in time
  • Participated in the team meetings to discuss the issues arising out of testing. Organized meetings to discuss outstanding issues with QA and developers.
  • Wrote test scripts for User Acceptance Testing (UAT).

Environment: Windows 2000/XP, Microsoft Office SharePoint, DB2, Java/J2EE, Rational Requisite Pro, MS Office, SQL Server, MS Project

Confidential, Mayfield Village, OH

Business Analyst

Responsibilities:

  • Conducted user interviews and JAD sessions with end users, stake holders and developers to gather functional and non-functional requirements of the system, and creation of user stories
  • Involved in developing the business model for expediting the claim settlement process
  • Performed document analysis involving creation of Use Cases and Use Case narrations using Microsoft Visio, in order to present the efficiency of the gathered requirements.
  • Defined frameworks for the application development and analyzed the areas of improvement
  • Highly interacted with the development team and claim settlement experts making sure that the development of the project is meeting the business requirements.
  • Involved in the analysis of the functional, technical specifications, data mapping document and conceptual diagrams.
  • Effectively documentedbusinessrequirements forthe subrogation scoring functionality which helpsthebusinessusers in deciding whether to assign theclaimto a subrogation specialist
  • Identified critical areas of business risk and modified the business process to reduce the same.
  • Wrote business requirements specification (BRS) and functional requirements specification (FRS) documents as per the business requirements and process flow.
  • Used SCRUM methodology in supporting system development cycle.
  • Jointly responsible for monitoring the progress of the system development by preparing status reports, charting out schedules, allocating and managing technical and human resources using MS Excel and MS Project
  • Conducted daily interaction with both the development team and stake holders
  • Analyzed the security implementation of the application with respect to users perspective
  • Documented user stories and modeled use case diagrams by utilizing MS Visio
  • Prepared test data for the functional test cases.
  • Evaluated test results and prepared test summary reports
  • Interacted with developers & various members of my team to discuss and resolve defects and their priorities
  • Performed bug tracking using Clear Quest.

Environment: Windows 2000/XP, Microsoft Office SharePoint, DB2, Java/J2EE, Rational Requisite Pro, MS Office, SQL Server, MS Project

Confidential

Functional Analyst

Responsibilities:

  • Acted as liaison between Information Systems group and Business User group.
  • Conducted business requirements,functional and technical walk-through meetings.
  • Met with key business unit stakeholders to gather requirements and needs.
  • Coordinated withSME'sto gather requirements and documentGapsin functionality.
  • Developed written requirements to clearly,define and detail the needs of the business unit. Requirements includedscreen designandprocess flow charts.
  • Created and updateduse cases, use case diagrams and work flows.
  • I wasInvolved in the entire project life cycle fromevaluation, installation, development, testingto production of end user reports.
  • Defineduser and system requirementsfor existing and proposed system during existing system integration andnew system development initiatives.
  • Worked withGUI teamfor designing the screens and assisted in developing mockup screens and prototyping of the user interface and usability testing.
  • Designed theSystem Flow, Data Flow diagrams, using these as the base to obtain requirements and wroteUse Cases.
  • Built catalog usingImpromptu Administratorand created joins, custom folders for easy access and understanding.
  • Assisted the business unit and teammates with resolving production issues.
  • UsedFlat Filesat a very basic level for configuration of data storage.
  • ManagedPortia reportwriting for trading and operations business units. Managed import and reconciliation of historical performance data.
  • UsedMS SharePointfor the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
  • Experienced in creatingtraining materials, SOP and handling documentation.
  • Documented business processes and communicated potential business and systems impact based on analysis of the data.
  • Tasked with documenting, storing, and sharing the issues and documentation usingRational Clear Case.
  • CreatedExport Archivesto deploy reports and packages from development to test environment.
  • Assisted QA Team in designing the Test Cases, and collecting theTest Metrics.
  • Documented functional and technical designs and user guides.
Environment: MS Office, MS Visio, MS Project, MS SharePoint, Rational Clear Case, UML, SQL, Rational Rose.

We'd love your feedback!