SUMMARY:

• Excellent in performing Gap Analysis to check the compatibility of the existing system infrastructure with new Business Requirements.
• Proficiency in preparing Vision Document and User Interface Specification to define system boundary for the project.
• Experience in developing use cases and process flow diagrams using Visio for business analysis.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis Business Monitoring, Product Development, Analysis, Testing, Ad - Hoc analysis and Testing various methodologies.
• Worked collaboratively with Business Process Owners, Development, Business Architecture and Data Migration teams, and Operations management and staff to analyze and document business requirements, document and communicate functional specifications, and deliver screen prototypes, report prototypes, and working business functionality for an enterprise-wide consolidation of three legacy systems.
• Proficient in all phases of Software Development Life Cycle (SDLC) and PMLC.
• Experienced in extraction and documentation of Business process logic/rules from legacy programs to understand the actual business logic in production as opposed to the business rules believed to be in place. Gap analysis.
• Involved in writing Functional and UAT test plans and performed detailed testing on application developments and implementation and a major consolidation of legacy systems.
• Used SQL to query the database and performed data analysis and assisted in developing test case objectives for verifying the accurate functioning of the ERP system
• Skilled in leading teams of diverse backgrounds to make sound business decisions based on analyses of short and long term business needs.
• Proficient in ensuring that business goal are met throughout the product lifecycle.
• Experienced in performing Business Process Reengineering and Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Involved in generating test cases, test scripts and resolving User Acceptance Testing (UAT) issues by communicating with QA team.
• Strong team player with excellent interpersonal skills, including the ability to coordinate and motivate and lead team members.
• Created documents for validation and verification against business unit requirements.
• Expert in creating business Requirements to be implemented in Legacy Billing.

PROFESSIONAL EXPERIENCE:

Confidential, West Sacramento, CA

Sr. Business Analyst

Responsibilities:

• Involved in gathering, documenting and verifying business requirements.
• Organized JAD Sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Project Requirement Document (PRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM), Requirements Management Plan (RMP) and testing documents.
• Lead business analyst for collaborating requirements from CA, MT and NY state Medicaid system used JIRA as a tool to manage the requirements.
• Familiar in reviewing the legacy system and MMIS system documentation.
• Responsible for gap analysis in changing old MMIS and Involved in testing new MMIS.
• Regression Testing of Web applications and applications dealing with MEDICAID and MEDICARE Services.
• Involved in preparing the Automation Design document and framework with the automation team through BPT module of HP ALM/Quality Center.
• Worked closely with stakeholders and SME’s for requirements gathering.
• Involved in Requirements validation for ICD 9 and ICD 10.
• Developed and executed test cases test Scenarios and followed-up defects using HP ALM/Quality Center.
• Checked the page text, titles and forms for ADA compliance.
• Generate all Medicare claims review and transmits to Medicare.
• Worked as team lead and addressed the items in timely manner.
• Developed and executed UAT test cases, UAT test Scenarios using HP ALM/Quality Center and followed-up defects using JIRA.
• Worked on developing the business requirements and use cases for Facets batch processes; automating the billing entity and commission process.
• Extensively interacted with the QA Team in executing the Test Plans, Providing Test Data, Creating Test Cases, and Issuing MR upon detection of bugs and collecting the Test Metrics.
• Wrote Use cases and test cases for testing and the processing of member enrollment and benefits.
• HP ALM/Quality Center was used to create the test plan, store test cases and run the test sets.
• Performed “UAT” for 5010 and ICD 9 and ICD 10 codes.
• Involved in the testing of web portal of New MMIS system.
• Utilized Defect module of HP ALM/Quality Center for Defect Management.
• Followed the RUP methodology for the entire SDLC.
• Using MS-Visio analyzed business requirements and process through Use Cases, Class, Sequence, and Activity diagrams, and adapted UML standards to define modularized Data Process Models.
• Ensured Use-Cases were consistent and covered all aspects of the Requirements document.
• Developed a Business Acceptance testing strategy and plan.
• Created test files and analyzed test results using MS-Excel.
• Created a User Guide and Operations Guide for the Annuities Group and IT.
• Used HP ALM/Quality Center to report and track bugs and impediments.
• Involved in project status meetings, QA review meeting, and System Test meeting.
• Coordinated and facilitated the execution of User Acceptance testing.

Environment: MMIS, Tortoise SVN Repository, SDLC, Agile, Windows, MS Visio, HP ALM/Quality Center, XML, Jira, Web Services, UAT, HIPPA, MS Project, SQL, Oracle, MS Office suite, etc.

Confidential, Omaha, NE

Business System Analyst

Responsibilities:

• Understand the data needs of the future system while documenting the existing system like trades. Analyze, define source and Confidential structure and perform gap analysis for data migration
• Works closely with technology and business user staff to complete workflow improvement and document functional specifications for systems
• Serves as a liaison between the Business and Technology Department. Enhanced communication lines between executives, managers, and peers.
• Involve in requirements gathering and system analysis through RUP of an online portal to provide visibility to corporate customers.
• Developing Use Case Models, Entity Relationship Diagrams (ERD), Activity Diagrams, State Diagrams and Data Flow Diagrams (DFD).
• Conduct weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project team.
• Perform design and analysis of modifications to In-Store systems and developed designed and modified operational and financial reports and programs.
• Work closely with user groups to create functionality specifications for new or upgraded systems
• Coordinate activities with other vendors which includes - focus in managing of rating, billing and provisioning errors and ensuring that the business is not hampered due to this.
• Writing PL/SQL code for migrating the data from the legacy systems to internal Database.
• Manage any change requests related to the project plans in order to meet the agreed deadlines
• Prepare interview questionnaires for the clients to gather requirements and prepared Functional Specifications and User Requirements.
• Prepare Use Case Models based on Business Requirement documentation gathered through interaction with users.
• Responsible for maintenance & development of all the IT related entities in the Utility operations like Billing system, SMSC, VMS, Mediation, etc.
• Had a track of SLA'S related to customer call center as well as finance department billing integration and procurement/purchase system
• Monitor loss prevention, inventory control, daily shipments, and invoice verification
• Initiate sub-groups or sub-teams as appropriate to resolve issues and perform tasks in parallel
• Analyze test planning data using reports and graphs generated in Quality Center
• Working closely with business stakeholders in understanding their full lifecycles for merchandising, marketing, and email campaigns
• Arrange weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Partner with IT vendors and other external business partners on development and service relationships
• Provide the status reporting of team activities against the program plan or schedule to the project manger
• Ensure that the deliverables were prepared to satisfy the project requirements, cost and schedule
• Assist in refinement of development methodology and in corporate emerging standards and improvements in the industry.

Confidential, Portland, OR

Sr. Systems Analyst

Responsibilities:

• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Worked with developing team to create advance claim submission process for Medicare and Medicaid patients as well as EDI transaction such as: 837 (P, I, D), 835, and 276/277.
• Ensure HL7 interface integration into organizational systems meets functional requirements and system compliance
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Designed and developed the user interface using UML, JavaScript, HTML and CSS
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Conducted JAD sessions with Subject Matter Experts (SME’s).
• Worked with subject matter experts (SMEs) internally and externally, and participated with software developers in Scrum team meetings, documenting agile software processes.
• Worked as Test Analyst for HIPAA 5010 compliance project in the areas of Membership, Group, Billing, Claims and Providers Modules.
• Conducted GAP analysis to understand new business model and implemented startup of an Agile (Scrum) enterprise wide projects.
• Performed duties as a business analyst in an Agile environment to ensure the successful launch applications.
• Edit claims (EDI Claims) with UML, UltraEdit and design Document.
• Worked closely with the SAs to develop the Test Data, EDI files in the form of XML for Testing purposes.
• Developed test plans based on the business requirements in the Rational Test Manager
• Worked on different 5010 HIPAA EDI transactions and code sets including 278 (Referrals), 834 (Enrollment), 270/271 (Eligibility), 276/277 (Claim status), 837 (Claims), 835 (Claims Payment) Batch and real-time (with MQ series used for real-time).
• Gathered requirement on FACETS EDI 834 and HL7 Benefit Enrollment and Maintenance subsystems.
• Worked on the FACETS front end and backend for testing and for documenting the Business requirement documents.
• Recommended changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA (4010A1)/ EDI formats and accredited standards.
• Involved in UML designing the client side module architecture based on new Angular Framework.
• Worked as a part of Claims Adjudication Team on FACETS.
• Conducted JAD sessions to gather and document requirements that enhance a wide range of functionalities including claims processing, eligibility and enrollment, provider networks, and electronic data interchange for our Facets core application.
• Involved in the error checking of the ETL programs using Informatica session log and workflow logs.
• Validated medical, hospital and dental claims in FACETS, verified codes with description and requirements, verified adjudication process of claims of FACETS.
• Extensive backend testing using SQL queries, generating the reports to ensure the data integrity and validate the business rules.
• Followed AGILE methodology throughout the software development life cycle and analyzed risks that might lead to scope creep between releases.
• Assisted end users and IT staff in the use of data to satisfy informational and reporting requirements and implementing and using SQL and DBMS (Data Base Management System).
• Worked with Source system Subject Matter Experts (SMEs) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Involved in the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Used Test Case distribution and development reports to track the progress of test case planning, implementation and execution results.

Environment: Facets, Requisite Pro, Rational Rose, Medicare, UML, ANSI, EDI, Informatica, Medicaid, XML, Agile, Sybase, PL/SQL, HTML, MS Office, MS Visio, MS SQL, EDI, UML, UAT, Etc.

Confidential, Minneapolis, MN

Sr. Business Systems Analyst

Responsibilities:

• As a Business Analyst, I worked with Supply Chain Team (and with internal and external customers) in managing and developing material planning for our facility, while developing strategies to achieve continuous optimized cost reduction.
• Conducted meetings/interviews and JAD/JAR sessions with stakeholders to collect business requirements, analyzed the root cause of the problems and developed use cases using MS Visio.
• Deliver requirements under the Agile Scrum SDLC methodology to meet a very fast release schedule.
• Identified potential business problems and UAT implementation problems.
• Managed the Supply Chain SharePoint site. Proactively pursued opportunities to enhance the user friendliness of the site, the quality, quantity and relevancy of the content.
• Created and maintained the library of Supply Process documents (training and reference documents, process descriptions) and a one stop repository for all Supply Chain KPI’s.
• Wrote Use Cases, prepared use case diagrams and followed Unified Process at every stage of the process.
• Worked on Teradata Work Flow designer and Work Flow Monitor to execute transformations and schedules and to validate the log files.
• Analyzed data requirements, data accuracy and created specifications for the ETL team to load data into the Confidential database and insisted them with source to Confidential mappings and with the tables, columns and other database objects.
• Created interactive Dashboards in Tableau with data back ends in SAS, SQL Server and Hadoop.
• Transferred data (ETL) to Data warehouse Environment and responsible in working on Data warehouse reports for non-critical data for supply chain processes, master data and production data
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Figured out the requirement of training in various departments of the hospital based on their daily work.
• Extracted data from ETL mappings and other ETL Processes (EDW) and statistical modeling.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle (SDLC)
• Worked extensively with MDM and IDS team in the process of data cleansing, data conversion and data migration. Also merging of provider records from various resources into one golden record in MDM.
• Conducted business process mapping (BPM) and Reengineering, technical gap analysis and developed test scenarios, which resulted in successfully implemented clients to new systems.
• Involved in production support, analyzed issues and communicated with the development team
• Identified Actors, Activities, Artifacts and Workflows and developed use case diagram using Rational Rose.
• Helped testing and developer team to develop several ETL applications to Extract, Transform and Load data into tables as part of Data Warehouse testing using various tools like Teradata, etc.
• Writing Complex SQL queries and optimizing SQL Queries.
• Designed dashboard to represent Teradata for the enterprise audit database based on ETL.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Work in Agile, Scrum, and sprint environment in order to change the requirements and features set.
• Conducted JAD/JRP and Elicitation sessions for user interviews to gather requirements.

Environment: Quality Center, ET DWH, SQL Server, Hadoop, MDM, Oracle, XML, Excel, MS Access, Excel, Visio, Windows, Teradata, Etc.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Defining the scope of the project and identifying the major actors.
• Extensively done GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Facilitated numerous Joint Application Development (JAD) sessions utilized for the creation of design documents, gathering requirements, reviewing functional specifications and system specifications for applications.
• User Acceptance Testing: test scenario/test case preparation, defect management, overall UAT execution oversight, management etc.
• Worked with technical team and business stakeholders to formulate and validate project & business requirements/scope.
• Established a Business Analysis methodology around Agile (SDLC) methodology and Participated in managing UAT along with Business SMEs.
• Worked with application development team on Test issues and conducted daily status meetings with Development and User Team during UAT.
• Created and maintained schedule for employee training oracle or PowerBuilder and used SAS Enterprise Guide.
• Prepared and managed UAT Materials UAT Test Cases to include various steps involved for UAT and to have proper coverage of requirements.
• Responsible for gathering requirements from users, mainly pricing and Mainframe professionals.
• Responsible for decomposing High Level Business requirement into functional specifications.
• Followed Agile Methodology to emphasize on real time communication over written documentation.
• Documented the Use Cases and Activity diagrams using MS Visio to understand the requirements and communicate them to the development team.
• Analyzed and implemented business rules through an agile software development process, using pair programming, unit testing, short iterations, and close customer relationship.
• Involved in the creation and maintenance of the Workflow plans and artifacts.
• Reviewed, analyzed and modeled Test plans and Test procedures based on RUP methodology.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Created test scenarios based on user stories and requirements - conducted UAT workshop.
• Worked with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data and data validation using SQL and test scripts using Application Lifecycle Management.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Created test scripts for Security, Positive, Negative and User Acceptance Testing (UAT)

Environment: Requisite Pro, MS Visio, Agile, Oracle, Clear Quest, Oracle SQL, Rational Requisite Pro, UNIX, HP ALM/Quality Center, Etc.

Confidential, Woonsocket, RI

Sr. Business Analyst

Responsibilities:

• Involved in gathering and documenting the requirements that were critical to the business process and using those requirements to design application software using a Use Case approach.
• Worked with SMEs in revenue cycle management to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering
• Experienced in leading meetings of cross functional teams which included Vendors, Pharmacists, IT, Patient accounting/Revenue Integrity and Finance.
• Ensure business and functional requirements are comprehensive and documented.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis.
• Conducted JAD Sessions for understanding the workflow.
• Acted as primary communication channel between business areas and Data Warehouse group. Provide support to Data Warehouse users to ensure that their needs/business requirements are being met.
• Worked on reports using Business Objects Web tool for testing the Data and functionalities of the reports.
• Worked with mobile web and mobile app team for any impact it may have.
• Worked on different applications and Conducted Gap Analysis between “As is” and “To be” process for the applications. Participated in the Logical and Physical Design sessions
• Responsible for owning complete requirements related activities on assigned project and related deliverables
• Assisted product owner in management of product backlog and prioritization of requirements and defects based on phase objective
• Walked all project stakeholders through requirements and obtained their sign offs on the requirements/User stories
• Responsible to ensure that the Pharmacy purchases are invoiced under the appropriate cost centers and financial accounts.
• Worked with the QA team to derive Test Strategy and in reviewing test case

Confidential, St. Louis, MO

Business Systems Analyst

Responsibilities:

• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios
• Translated business requirements into usable functional requirements
• Performed Data Gap Analysis in current data warehouse with respect to the product level data
• Participated in requirements analysis using a Use case driven approach and produced detailed use cases and functional specifications for all the interfaces
• Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications
• Worked for ensuring that the final data warehouse implementation will meet the user expectations
• Conducted and participated in JRP/JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS) analyzed the feasibility of their needs by coordinating with the project manager and technical lead
• Analyzed various business problems and technical problems related to data consistency/data integration of third party market data vendors to come up with tactical and strategic solutions by means of weekly meetings, conference calls, escalations, follow-ups and presentations to ensure effective project management.
• Responsible for data profiling, data analysis, data mapping and data modeling.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects,
• Performed Business Process Modeling (BPM) using Visio and customer data analysis.
• Identified and documented risks and their impacts and provided recommendations to mitigate the risk.
• Executed SQL Queries for test data using Business Objects
• Worked with Business Analyst to create hierarchies and design reports using OBIEE (Oracle Business Intelligence Enterprise Edition).
• Worked in mainframe environment and used SQL to query various reporting databases
• Documented and tracked all product defects with use of SQL (reporting).
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
• Writing Complex SQL queries and optimizing SQL Queries
• Develop test plans, test cases, procedures, and documents given business requirements and design documents

Environment: Windows, AML/Quality Center, XML, UML, HTML, RUP, ETL/Data ware house,UML, SQL, Rational Tools, MS Visio, MS Word, Excel, PowerPoint, Access, BPM/MDM, Etc.