Data Project

MANJULA.M.S

Mobile: +1-202-***-**** Email:ac8o52@r.postjobfree.com

Professional Summary

Experience as a Business Analyst, Quality analyst, BI Analyst and Data Analysis in IT, Medical Device and Healthcare - Insurance domain.

Experience with BI tools in creating reports and dashboards using Power BI, Tableau and MS Access

Experience with Healthcare – Health care reform, Large groups, Small Groups, Individual groups Medicaid & Medicare – Product development, Product sales, Enrollment, Billing, ID Cards, Claims, Eligibility etc…

Detailed experience with business analysis, business requirements gathering (Functional and Non Functional), evaluating data sources, translating requirements into specifications, and application design using Agile and Waterfall methodologies.

Depth knowledge of various phases involved such as Software Requirements Analysis, Systems Analysis and Design, Documenting and End-user training.

Expertise in creating Business Requirement Specification documents, Functional Specification Documents and User Specification Documents for System Integrations.

Experience with creating Use case Document and User Stories.

Experience facilitating Joint Requirement Planning (JRP) sessions with business user groups, conducting Joint Application Development (JAD) sessions with IT groups and conflict management with project team members.

Strong knowledge and background of Software Development Life Cycle (SDLC) and strong analytical skills.

Experience of working as part of an Agile Scrum teams - attending daily stand up scrum calls, grooming sessions, Participating in sprint planning, sprint review and spring retrospective meetings.

Experience working closely with Product owner, Project Intake team, Business Consultants and assisting Scrum master in the work.

Experience working on Defects, Enhancement Tickets and Service Manger tickets.

Strong understanding on the requirement being gathered and solution being delivered.

Experience with requirement traceability matrix.

Knowledge of systems architectures, servers and applications used across various domains.

Addressed users and stakeholders to identify, elicit, analyze, communicate and validate requirements (Functional and Non-Functional).

Created Product Backlog, Sprint Backlog and managed User stories.

Created Test cases and test scenarios and documented the test results

Authored the SOW (Statement of work) document.

Skilled with elicitation techniques like Interviewing, Brainstorming, Group Discussions and Questionnaire to capture inputs required for functional design which included detailed process maps and UI mock ups.

Aided in creating, updating and maintaining QA Artifacts, Product Backlog, Sprint Backlog, and Reports & Metrics to update stakeholders.

Experience with documenting Technical specifications after the development work is completed.

Experience with estimating points for the user stories based on the amount of work to be done in each sprint.

Experience in handling multiple projects at a time.

Excellent understanding of Data services, Data ETL using SQL query tools and applications.

Strong expertise in developing Use Case Model, Data Flow diagram and Activity diagram using MS Visio.

Experience with System, Regression, Functional, End to End, Positive and Negative testing and monitored the behavior of the applications during different phases of testing.

Experience with User acceptance testing (UAT) and working closely with the quality team.

Experience with documenting testing defects.

Experience with managing the projects across multiple domains and meeting the deadlines.

Proficient in performing Risk Assessment Techniques, Gap Analysis, Impact Analysis and preparing corresponding Remediation Plans.

Proficient in Microsoft Operating Systems, Office including Microsoft Project and Visio.

Highly motivated with efficient in working alone or in a group, with good analytical skills and proven ability to work under pressure to meet deadlines.

Self-motivated and good interpersonal and communication skills and highly efficient to understand and learn client’s business requirements.

Experience is validating if testing is completed and passed for all the requirements from the client.

Technical Skills

Bug Tracking Tools

Jira, VSTFS, RQM

Databases

SQL Server, MS Access

Reporting Tools

Power BI, Tableau

Healthcare

Medicare, Medicaid, HIPPA, Large groups, Small Groups, Individual groups and HCR

Languages

XML, HTML, SQL

MS Tools

MS Visio, MS Excel, MS Office, MS Project, MS Word

Other Tools

Share Point, TFS, Windows, PMT, QDQ, CARS

IBM Rational Tools

Clear quest, Requisite Pro, RTC

SDLC/Methodologies

Agile, Scrum, Waterfall

Testing Tools

Quality Center, Quick Test Professional,

PROFESSIONAL EXPERIENCE

Business Systems Analyst – DXC Technology Company

Domain: Health care

Client: Kansas health care department

Feb 2014 – Present

Roles and Responsibilities:

Documented, coached, and elicited business requirements from subject matter experts by writing user stories resulting in a clearer, more detailed and more complete understanding of project deliverables.

Working closely with the Scrum teams to ensure technical solution meets requirements and functional solution

Performed Document Analysis to analyze as-Is business process, and the To-Be system and assisted in fixing the scope of the project.

Worked with various business units to gather business requirements by process of leading JAD sessions.

Experienced in creating data mapping documents.

Developed Use Case for a clear understanding of the project vision by using MS VISIO.

Experience in conducting UAT and writing test cases for business users for multiple scenarios.

Experience in the Healthcare Medicaid and Medicare – Membership & Enrollment, claims, benefits, eligibility check.

Strong knowledge on BCBS Insurance.

Exposure to Health Care Industry standards like HIPAA, CMS, EDI.

Experience in loading batch files onto the enrollment system.

Experience with job automation setup.

Worked with Project manager on scheduling, completion and approval of deliverables related to every step of SDLC.

Experience in generating reports and sending outbound files to vendors.

Imported data from SQL Server DB, Excel to Power BI to generate reports.

Experience is generating letters for the cancellation and termination of insurance membership.

Experience on dealing with health care reform membership.

Experience in grooming user stories based on priority in the grooming session meeting.

Experience in supporting monthly releases and off releases for every sprint by doing a business checkout on what was developed and code moved to production.

Guide the development teams to break down large and complex user stories into simplified versions for execution.

Prepared analysis documents for the requirements gathered and the jobs set up to run at scheduled time

Prepared Use case documents and helped testers and developers understand the requirements clearly.

Prepared High Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.

Extracted the Business Requirements from the end users keeping in mind their need for the reporting purpose and prepared Business Requirement Documents using Rational Requisite Pro.

Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT) as a part of SDLC.

Reviewed the test cases prepared by Tester and reviewed the test results after the testing is completed.

Experience in extracting the data from tables using SQL queries

Test the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories.

Working Knowledge on EDI Standards

Did support for test preparation of the integration (unit test; Regression Testing; performance test) in collaboration with the Testing Team managing customer expectations.

Used RTC to track complete project, for writing user stories, Acceptance criteria and for updating the tasks for development and testing

Used RQM to save the test scripts executed.

Created the Requirement Traceability Matrix (RTM) defining and tracking each technical requirement in detail.

Business System Analyst –Tata consultancy services (TCS), May-2011 to Sep- 2013

Domain: Insurance

Client: Humana

Roles and Responsibilities:

Worked as IT Business Analyst in Health care insurance domain to gather business requirements and UAT testing of system enhancements.

Facilitated Joint Application Development (JAD) sessions to identify business requirements.

Drafted and reviewed change control processes and approved the change request mechanism.

Facilitated questionnaire sessions to identify business rules, requirements and document them in a format that can be reviewed and understood by both the business users and technical team.

Gathered, analyzed, documented, and communicated business requirements to graphically represent business processes and business data per Agile SDLC.

Experience with JIRA in writing user stories, Bug tracking, Updating test scripts and test results, updating RTM.

Worked on preparing vision document that contains Business Requirement Documents for an annuity plan and supporting documents that contain the essential business elements and detailed definition.

Liaison to IT for business requirements definition (BRD), executing test scripts (UAT), software implementation and upgrades, data loading and data management activities.

Emphasis on SDLC, Business analysis, GAP analysis and Quality Assurance of application software in agile framework.

Experience in gathering requirements to develop different kind of tools related to payroll system, Insurance systems.

Experience in gathering requirements to develop tool for Insurance systems.

Performed manual functional testing to check if the tools are working as per the requirements from client

Represent Channel Operations in Business, Systems Requirements and Technical Design sessions with other stakeholders for a new software package.

Diagnosed and resolved business and technical issues that came up on day to day basis during the development and testing and rollout phase of the Application.

Worked on designing processes & sub-processes & confirming it against the functional requirements by following the Agile SDLC methodology.

Worked heavily on SQL Server database to extract data and build Business reports.

Development of new Reports / Dashboards using Tableau and relevant data source (Excel, SQL Server etc.)

Created the relational Database and document database specifications, database constraints and Involved in creating database.

Traced system specifications and test scenarios back through the business requirements to demonstrate that systems were "fit for purpose".

Developed and managed Agile "stories" as part of the software development process.

Developed and Maintained Master excel for requirements and information gathering including: global contact list, detailed site facilities and IT data, questionnaires, progress overview, and progress metrics.

SME on Quality Center, providing guidance to business as needed as well as customizing tool to meet out of the box business requirements.

Produce functional requirements for systems upgrades along with administering use cases during user acceptance testing and regression testing.

Involved in the creation and execution of UAT test cases for multiple projects.

Responsible for defining analysis strategies, developing analysis tools, and ensuring timely and accurate completion testing.

Provided support to the End to End integration/Regression Test Team.

EDUCATION

MBA/PGDM in Finance & HR

2008-2010

T.John College Bangalore University

BSc in Bio - Technology

2004 – 2008

Pragathi College of Science and management,

Bangalore university

Contact this candidate