Professional Summary :

• Over Six years of Experience as a Business Analyst, proficient in developing business processes and system solutions for HealthCare Insurance industry.
• Strong knowledge of the Software Development Life Cycle methodologies like Agile and Waterfall models.
• Experienced with Iterative approach for Software Development as per Rational Unified Process RUP . Involved in inception, elaboration, construction transition phases using rational tools like Requisite Pro, Clear Case and Clear Quest during various phases of RUP.
• Experienced in developing different type of documents like BRD, FRD, File Transfer Specification and different diagrams like Use Case, Flow Chart, Traceability Matrix, Data flow diagram.
• In-Depth Knowledge in facilitating Joint Application Development JAD , Rapid Application Development RAD and Joint Requirement Planning JRP sessions, interviews, workshops and requirement elicitation sessions with end-users, clients, stakeholders and development team
• Expertise in UML class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams as a business analysis methodology for application functionality designs using IBM's Rational Rose.
• Drafted requirement gathering sessions, Feasibility studies, cost/benefit analysis and Impact Analysis in organizing the software requirements in a structured, base lining acceptance criteria
• Importing data from SQL to Excel to perform in depth analysis on the data.
• Extensive experience in Functional, Integration, Regression, User Acceptance UAT , System, Load and Black box testing.
• Worked on healthcare standards such as HIPPA 5010, 4010, ICD-9 and SOAP.
• Performed data mapping and created workflow to load the data from the external source to the Enterprise Data Warehouse.
• Analyzed data flow and business requirements to create High Level Design document.
• Knowledge of system implementation and data processing through SQL. Strong knowledge of databases and data modeling and data mining.
• Experience writing queries in SQL server and SQL developer to retrieve data.
• Highly experienced in implementing Agile Scrum methodology.
• Drafted the guidelines and artifacts of the Rational Unified Process RUP to strategize the implementation of Rational Unified Process, in different iterations and phases of the Software Development Life Cycle
• Experienced in UML, modeling Activity, Use case and Sequence diagrams using tools such as Rational Rose, Microsoft Visio.
• Knowledge of health care services regulatory environment including HIPAA, MMIS and EDI.
• Through understanding of Practice Management Systems Patient Registration, Scheduling, Eligibility Verification, Billing, and Claims Scrubbing and EDI exchange.
• Appraised the AS-IS and TO-BE business processes Gap analysis and experienced in converting these requirements into technical specifications for preparing test plans.
• Guided to organize, document and track changes and defects using Rational ClearQuest and JIRA
• Participated in formal review meetings with project teams and developers to report, demonstrate, prioritize and suggest resolution of issues discovered during testing
• Formulating Test Distribution of test effort, documenting the progress and updating team members with the Project Team and Configuration Management Team for build release
• Facilitated UAT with the stakeholders and the business users
• Created and documented traceability matrix to help the test team and the analysts trace the requirements during the testing phase.
• Excellent Communication, Presentation and Management skills with experience in conflict resolution, creative problem solving techniques and working in a challenging environment.

Technical Skills:

Professional Experience:

Confidential

Senior Data Warehouse/Business Systems Analyst

Confidential is one of the leading healthcare providers in the country. Worked as a Sr. Business Analyst, working closely with project team to identify user's business requirements, interpret complex business needs and translate them into system requirements, write business specifications and forward to technical staff for system integration.

Responsibilities:

• Worked with QA team to test the application quality and perform UAT, conducted root cause analysis for UAT environment
• Provide the overall coordination and support of all internal Electronic Data Interchange EDI objectives and tasks
• Followed the UML based methods using Rational rose to create use cases, activity diagram, sequence diagram, collaboration diagram that include functional and non-functional specifications to hand off to development teams.
• Provided regular verbal and written status reports to IT management team.
• Participated in various sessions to define the solution approaches, and identifying assumptions, constraints, risk and issues.
• Refined the requirements Use Cases and Business Process Models to detailed level requirement appropriate for technical analysis and system design.
• Participated in Daily Scrum Meetings.
• Documented data mapping rules for movement of data between applications.
• Created different Traceability views to maintain the Traceability of the requirements.
• Tracked, reviewed, and analyzed defects using Rational ClearQuest.
• Reviewed and finalized the User Requirement Specification URS , Functional Requirement Specification FRS , Technical Specification, and Detailed Design documents.
• Worked on HL7 to provide framework to carry out transfer of electronic healthcare information.
• Revised the Use Case, Collaboration, Object, Sequence, Activity, and State Diagrams using Rational Rose.
• Conducted requirement gathering sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Involved in testing different interfaces and web application for FACETS.
• Propose strategies to implement HIPAA 4010 in the new MMIS system eventually move to HIPAA 5010 using EDIFECS for achieving compliance.
• Applied RUP within the different groups involved in the project to configure and develop processes, standards, and procedures.
• Initiated walkthroughs and interviews with the Subject Matter Experts SME and stakeholders to keep track of user requirements.
• Investigating and resolving data issues across platforms and applications, including discrepancies of definition, format and function.
• Designing and creating the architecture of data warehousing star schema logical database model.
• Designing and architecting end-to-end ETL process including data Extraction, Transformation and Loading from source systems using Informatica.
• Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community.
• Worked with the client architecture team in defining tools, processes and technologies to be leveraged on the data warehouse.
• Was heavily involved in implementing changes to Data Warehouse.
• Served as Subject Matter Expert SME for refining and finalizing all business and technical requirements pertaining to MMIS.
• Provided a single point of contact for user communication, managed issue tracking, prioritization and resolution.
• Acted as a liaison between the business users and technical teams to enhance the applications based on the business requirements
• Participated in all the phases in the project management life cycle
• Applied the SQL scripts to the test database and execution of the scripts on the database.
• Created Business Functional Requirement Document BRD and FRD and Physical and Logical Data models for Claims process from legacy system.
• Performed impact analysis by identifying the functional business areas and supporting information technology that will be impacted by the conversion from ICD 9 to ICD 10.
• Performed GAP analysis of 4010 and 5010 EDI transactions using implementation guides to identify the changes in the segment and data elements.
• Facilitated JAD sessions taking into consideration the agenda and meeting minutes with stakeholders to analyze system needs and integrate requirement to develop a consistent navigation structure.
• Knowledge of CMS reporting requirements for Medicaid.
• Responsible for the Claims Adjudication System Managed Care application training for all departments administration of control files.
• Responsible for Interface analysis and design between batch files passing through firewall to obtain information from MMIS or particular application.
• Project management, update and controlling to ensure on time delivery using MS Project.

Environment: Windows NT, MS-Visio, Oracle, SQL, MS Access, MMIS, Test Manager, Office, MS Project, Requisite Pro, EDI, HIPAA 5010 and ICD-10, Rational, HL7, ClearQuest.

Confidential

Senior Business Systems Analyst

Confidential is one of the nation's leading operators of general acute care hospitals. Project was to develop online software pharmacy and clinical applications that would cater to client focused initiatives with regard to the HMS applications..

Responsibilities:

• Analyzing and drafting the system requirements specifications and mappings for the, Claims Flow, Billing and Payment release 2 and EDM related projects
• Prepared demo on MS SharePoint MS Project Server for various Business to get new approvals like the Therapist and Nursing divisions.
• Used Rational Clear Quest to track required changes and Rational Clear Case to maintain different versions of the project documentation Change Management .
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall
• Developed Test Plans and Test Cases according to Business Requirements
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis
• Documented Test plans, Test cases, Test scenarios using Rational Test Manager
• Conducting a root cause analysis of critical issues, identifying the cause and coordinating with the development and business staff to rectify the issue, drafting and documenting the scope of testing efforts needed for each report development.
• Identifying duplicate, redundant and bad patient, billing and claims data across several systems and data layers/databases, updating business process flows, data mappings, and reporting issues through the defect management system MQC
• Involved in reviewing and analyzing and participate in evaluating requirements for successful testability.
• Participate in presenting technically complex issues to the management
• Working and coordinating with the to Batch operations, reports development and testing staff in rectifying production problems leading to successful resolutions of critical and priority tickets
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Assisted with project planning, requirements development and completing ad hoc change management activities.
• Responsible for co-ordinating integration of HIPAA, Medicaid solutions.
• Charted out project plan with project manager and ensured the compliance of EDI transactions.
• Assisted in prioritizing, scheduling and categorizing tasks to continuously track work progress.
• Documented the Traceability Matrix for tracing the test cases and requirements related to them.
• Performed Unit Testing and User Acceptance testing and documented detailed results.
• Provided input scope, goals, risks, constraints, timelines and interfaces to PM for project planning and control
• Used Rational Rose to model the process using UML to create behavioural and structural diagrams
• Created Use Cases / Activity Diagrams , Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model
• Performed Project Management activities and acted as a Technical Resource from a system requirement standpoint, to both business users and the technical team.
• Developed business process models in RUP to document existing and future business processes
• Staged projects and document types, requirement types, requirement attributes, enabling email for discussion groups in RequisitePro.

Environment: RUP, Mercury Quality Center, Data stage, SQL, Unified Modeling language, Microsoft Visio, MS SQL Server, Business Objects.

Confidential

Systems Analyst

Confidential is an Confidential diversified global insurer and the third-largest property and casualty insurer in the United States. Passenger automobile, homeowners, life, annuity, and other property and casualty insurance products are available via Liberty Mutual Insurance.

Responsibilities:

• Exhaustive management and documentation of project requirements, leading to cost-effective delivery of the business application.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development of a profitable portfolio of business.
• Understand the existing system processes and worked with business process people to develop the mobile application for Property and Casualty Insurance claims system.
• Implemented the Rational Unified Process of Software development with active involvement in defining the iterations through the entire process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
• Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts.
• Facilitated JAD Joint Application Development sessions to identify business rules and requirements and then documented them.
• Participated in designing walk-through with SMEs to baseline the business architecture.
• Used MS Visio to carry out the business modeling, data modeling, and object modeling effort to develop the business architecture for the application for rapid and controlled Application development.
• Played a substantial role in the process definitions and business and functional requirements gathering, in an effort to develop a practical technology solution for automating sales methodology.
• Acted as a liaison between stakeholders: system users, clients and managers, who have a business problem, and software development team to gather requirements.
• Implemented and monitored Individual Development Plans focusing on total performance, including both quality and productivity.
• Documented the errors using ClearQuest and tracked them to completion by communicating and co-coordinating with the development as well as the support group.
• Created UML diagrams Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams thus defining the Business Process Model.
• Responsible for collecting and analyzing the test metrics and then submitting the reports, which kept track of the status and progress of the testing effort.

Environment: SQL, Unified Modeling language, Microsoft Visio, MS SQL Server, Business Objects.

Confidential

System Analyst

Emergency medical services EMS offers an array of healthcare related services to consumers, hospitals, healthcare systems, health plans and local, state and national government entities. EMS provides medical benefit plans, dental coverage, behavioral health coverage, pharmacy benefits and products and services that integrate and analyze information to support consumerism and health advocacy.

Responsibilities:

• Elicited requirements and designed functionalities for case management, claims processing and medical billing.
• Extensively involved in Data Warehousing Environment and tools such as Informatica for Business Analysis
• Conducted detailed walkthrough of business requirements and functional requirements with Business users, Development and QA Team.
• Translated Business Requirements and user expectations into detailed specifications employing Unified Modeling Language UML , MS Visio.
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process RUP methodology in all areas of the software development life cycle SDLC .
• Performed GAP analysis for requirements and used them to draft detailed system specification requirements.
• Drafted various documents such as Use Cases and Activity Diagrams in a format that can be reviewed and understood by both business and technical people.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice.
• Worked with business people to complete sufficient number of recoded medical policies to reflect the ICD-10 based benefits/coverage.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Conducted presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
• Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
• Used Rational Clear Quest to track required changes and Rational Clear Case to maintain different versions of the project documentation.
• Generated detailed Data Mapping document which included source and target column names for the process.
• Conducted in-depth analysis for Inpatient and Outpatient claims data based on user requirements.
• Developed a Copybook for the development team which included data length and data type.
• Managed the change request in Rational Clear Quest and analyzed the impact of the change request on the application in regards to Project Plan, Project Scope and Project Schedule.
• Created Test cases and Test strategy for the functional system testing and automated testing.
• Extensive use of SQL to extract data from different data sources.

Environment: Mainframe RUP, Rational Rose, MS Office Tools, UML, MS Visio, Windows XP, SAS, PL SQL, Rational Clear Quest.

Confidential

Junior Business Analyst

Responsibilities:

• Implemented RUP methodology of SDLC throughout the project.
• Coordinated cross functional task forces to remove impediments.
• Designed and created a database of all the remitter and their means using a SQL
• Identify, gather, analyze, prioritize, and document all the system specific requirements
• Communicate all the requirements to the developers in an understandable manner
• Interfaced with Quality Analyst to ensure unit testing, integration testing, system testing, and user acceptance testing.
• GAP Analysis to figure out what we have and what we ought to have to be at better-off.
• Created a use case using UML.
• Performed a Change Management Role to make software compatible with different means.
• Conducted JAD sessions with stakeholders and business users.
• Implemented knowledge of ERP.
• Interact with the developers and involved in walkthrough meetings with them
• Responsible for weekly status reports.

Environment: Microsoft Office, MS Visio, SQL, JAD, UML, HTML, Oracle, XML RUP.