Data Test Cases

SUMMARY:

Qualified professional with *+ years of extensive experience in the field of Business Analysis, including 2+ years of experience in Business intelligence Analysis working with the technical staff to implement management and staff's business requirements into the software application.

Team player and a self-starter with excellent communications skills, and interpersonal skills with exceptional ability to build productive relationships with colleagues, clients, and vendors across all functional and technical disciplines.

Experience in AGILE, RUP, WATERFALL methodologies and all phases of Software Development Life Cycle (SDLC).

Expertise in all phases of the software development life cycle (SDLC), with emphasis on business requirements, design, construction, documentation, risk assessments, project plans, testing, implementation.

Experience in creating project Scope document and discovery document to define the scope of the project.

Experience in gathering requirements from the various business users, other stakeholders and making Business Requirement Document, Functional Specifications Document, System Requirement Specification Document, and User Stories.

Extensive experience in developing Use Cases, Use Case Diagrams, Creating Screen Mockups, conducting GAP Analysis, RAT Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.

Good experience writing technical and business documentation including Business Decision Documents (BDD), Business Decision Statement (BDS), Business Caste Template (BCT), Project Charter, Functional Requirement Document (FRD) and Non Functional Requirements.

Experiences in performing Market Research and Customer Experience Insight (CEI) testing.

Proficient in SQL queries and worked on MS SQL server.

Experience in conducting Joint Application Development (JAD), project meetings, reviews, walkthroughs, and customer interviews.

Expertise in Client site coordinator that involves understanding business requirements, day to day client interaction, offshore knowledge transfer (KT) activities, onsite status call coordination, project deadline keeping and worked as a team with business partners and end data customers.

Extensive experience in Microsoft Business Intelligence Tools including Integration Services, Reporting Services and Analysis Services.

Explicit understanding of Healthcare Reform and ACA (Affordable Care Act).

Knowledge of Health Insurance Portability and Accountability Act (HIPAA) transaction, code set rules such as 837-Institutional, 837-Professional, 835-Claim Payment/Remittance Advise, 270/271-Eligibility Benefit Inquiry/Response, 276/277-Claim Status Inquiry/Response Transactions and testing in Client Server systems and Mainframe Applications, EDI 834, ICD9-ICD10.

Experience with health care Systems: Medicare Part A, B, C, D, Medicaid systems.

Experienced in creating and managing test plans and test scripts.

Expert in eliciting and gathering requirements, conducting meetings, JAR/JAD sessions and performing User Acceptance Testing with stakeholders and end users.

Involved in reviewing Test Procedures, creating Test plans, executing Test Cases, maintaining and executing detailed Test scripts for User Acceptance Testing (UAT).

Full life cycle experience in testing process (Requirements, Test Plan, Test Design, Test Cases preparation, Test Execution and Test Reports).

Experience working in Data Warehouse projects.

Good understanding of Data Dictionary and Data Modeling.

Experience in driving out data requirements for database applications.

Knowledgeable in data warehouse concepts used for reporting and analytics.

TECHNICAL SKILLS:

Programming Skills

HTML, SQL, C

Database

Oracle, MY SQL, SQL Server, DB2, MS Access

Reporting Tools

Crystal Reports 8.0, Business Objects, Hyperion

Operating Systems

Windows XP, 7, 8, Linux, Mac OS

BA Tools

MS Office, Visio, MS Project, Rational Rose, Rational Requisite Pro, MS Office FrontPage, SharePoint.

Performance Testing

Virtual User Generator, Load Runner, WAPT

Processes/Technologies

Rational Unified Process (RUP), Scrum, Agile, Waterfall

Automation Tools

Requisite Pro, Win runner, QTP, Test Director, Mercury Quality Center, HP ALM,

EDUCATION:

Bachelors of Technology from JNTU, Hyderabad, India

EXPERIENCE:

State of Florida, FDC, Tallahassee, FL Jan 2015 – Present

Senior Business Analyst

CMS (Commission Management System)

FCOR (Florida Commission on Offenders Review) want to Automate the Docket and Revocation Process. During the inmate interview all the documentation and the commissioner’s decision were noted down manually on paper. CMS helps the commissioners and the staff to do all the work automatically and saves a lot of paper work and thus increases the security.

Responsibilities:

Conducted individual and group (JAD) sessions with business stakeholders to gather the requirements and define the scope of the project.

Acted as a liaison between potential system users who have business problems and technology people who know how to create automated solutions.

Developed the use cases, project plans and managed project scope.

Drafted business rules needed to support user role assessment for the technology team.

Created AS-IS and TO-BE Business Process and user stories to define the application flow

Analyzed business requirements and segregated them into high level and low level Use Cases, activity diagrams/State Chart diagrams using MS Visio according to UML methodology

Analyzing the risks and issues in the project in order to avoid project delays.

Facilitating weekly meeting calls to discuss the action items, issues/open items, and next steps

Used iRise tool for developing the mockup screens for Docket Automation and Revocation.

Provided Milestone dates and timelines for each project by analyzing the effort including the resources.

Stand up calls every day with developers in order to track the project.

Used JIRA for Defect tracking, raised tickets and allocated them to the developers to solve the issues.

Proactively worked with clients to maintain a consistent service delivery while closely working with delivery team to ensure enhanced customer experience

Dedicated Presales consultant for functional sync up with the client taking care of every requirement and intake related to the account.

Acknowledgement Application for the PII

FDC(Florida Department of Corrections) wants to develop a application for the agreement paper they do for the security of the information. All the active employees of the FDC have access to sensitive data, so FDC need a application for the staff to sign a agreement that the information they have access to can only be used for work.

Defined the scope of the project and drafted the document with the business rules.

Had standup meetings with the developers and finished the projected with the period of 2 weeks.

Proactively participated in preparing the Use cases, Test plans and Test cases.

Managed requirements from inception to delivery with the scrum development.

Involved in the User Acceptance Test (UAT) and client walk through sessions.

Environment/Technology:

MS Office 2013, MS Visio, iRise, JIRA, .NET, Windows 7.

CSX, Jacksonville, FL Oct 2013- Dec 2014

Business Intelligence Analyst/QA Coordinator

MART (shipment management and resource tracking) System is a Web-based supply chain management system that offers a customized shipment platform that is delivered to customers, suppliers and carriers through a secure, Web-based application. The SMART System provides shipment validation, visibility and optimization and provides a tool for comprehensive data collection. We offer the services for different customers like intermodal, international and domestic for shipping their Freight or managing their Freight using our Value added services.

Responsibilities:

Gathered business requirements, Functional and Non-Functional by conducting JAD sessions from key stakeholders, customers, and subject matter experts to define the scope of the project.

Performed as and to-be scenarios on ad-hoc reporting by manipulate complex data on MS SQL server.

Create Scope document, Project Charter and Business Case Template (BCT).

Conducting and Facilitating Sprint Panning, Sprint Retrospective and Daily stand up meeting for each sprint cycle.

Creating User Stories and Dashboards in JIRA and Confluence.

Performed GAP Analysis (“As IS” – “TO BE”) to derive requirements for existing system enhancements.

Created High Level Business Scenarios and Detail Business Scenarios to verify the business process and system flow.

Created and owned the Use Cases and Use Case Diagram using MS Visio and kept them updated during the requirement stage and in development state.

Creating SQL Queries to analyses and test data.

Written various SQL queries and performed validations

Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.

Utilizing BO WEBI tool to answer business questions through reports and to create dashboards in business friendly language.

Working independently to produce project deliverables such as knowledgeable in data warehouse concepts used for reporting and analytics User Stories, Data Mappings, Mock-ups, and Wireframes etc.

Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, INFORMATICA and DAC and the required connectivity for integration with the data warehouse.

Uploading and sharing documentation via SharePoint.

Working as a QA (Quality Assurance) Coordinator.

Extensively involved in Business Functional Testing, Backend Testing, System Testing, Cross-Browser Testing and Regression Testing.

Creating Test Plan and Test Cases.

Creating and tacking defects using JIRA.

Uploading and updating test data using DB2 Upload tool.

Testing Transformation Rules.

Coordinating UAT testing.

Environment/Technology:

MS Office 2013, Win SQL 11.0, Business Object, Oracle 10G, BO Reporting WEBI tool, SharePoint 2010, JIRA, Confluence, DB2 Upload, DB2, OBIEE, Beyond Compare

Florida Blue (BCBS), Jacksonville, FL Nov 2011 – Sep 2013

Business Intelligence Business Analyst / QA Coordinator

As health insurance industry moves toward a retail-based, consumer driven marketplace Florida Blue decided to implement quantum change in the way insurance is marketed. Florida Blue’s focus is to transform business to allow us to successfully compete in the future. Florida Blue is adopting an end-to-end, sale to service, IT platform to help manage its individual under-65 and small group non-grandfathered business. As a part of Quantum Program, X09 - Data and Reporting team's objective is to determine and implement critical, minimum-necessary reporting solutions using Facets data, or a combination of Facets and Florida Blue legacy data.

Responsibilities:

Analyzed Mainframe reports that are generated through current Florida Blue's Legacy Systems (NRBS-National Regular Business System and RTMS-Real Time Membership System.)

Evaluated RFP (Request For Proposal).

Created Product Backlog, Sprint Backlog and managed User stories.

Written technical documents like BRD (Business Requirement Document), HLR (High Level Requirements) and FDD (Functional Design Document)

Created Requirements Specifications, Use Case Diagrams, High Level and Detailed Process Flows, Robustness Diagrams and Domain Model as well as standardized a process that decreased requirements gathering and analysis time by 50%

Performed GAP analysis and created a Master Inventory of the business’ existing, critical-reporting processes that will be impacted by Quantum Program.

Responsible creating Test Plan, Test Cases and Test Cards based on use cases in business requirements to cover both functional and non-functional requirements.

Identified new business reporting requirements in response to new ACA (Affordable Care Act) regulations.

Used ClickView for Data analysis and reporting

Worked with project manager to define solution scope.

Conducted DBR (Detailed Business Requirements) and IDR (Initial Data Requirements) sessions to gather Requirements.

Elicited, analyzed, modeled, and documented Detailed Business Requirements (DBR) and Validated requirements with stakeholders and the project team by communicating and presenting requirements artifacts, models, and deliverables appropriate to stakeholder needs

Gathered and Documents all data requirements into Initial Data Requirements Document (IDR)

Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)

Used Facets Data Dictionary to assist in Data Mapping process.

Used Facets Data Models to better understand table structures and joins to assist business in creating new reports.

Expertise in data warehouse QA process and different levels of testing like Functional, Regression, and Integration testing with business scenarios.

Utilized Share Point document management system to share documents and track notes and action items.

Escalated issues, risks, and changes to Project Manager as they arise.

Wrote SQL statements to manipulate replicated Facets database tables and to query data.

Identified and addressed data issues affecting data integrity using MDM (Master Data Management) standards.

Reviewed Vendor and Florida Blue SIT (functional and requirements testing) test plan and test case coverage.

Create user acceptance test cases (UAT) and production verification test cases.

Created AD-hoc BO Reports.

Executed and manages UAT test cases through Silk Central and HP ALM.

Exported test cases written in MS Excel to HP ALM/QC using HP ALM Add-in to MS Excel.

Created Daily defect tracking reports and conducted bi-weekly KIOT meeting to walkthrough Open defects with Business and Project team.

Participated in Weekly meetings and walk through to discuss Defect Priorities

Provided direct feedback to the teams, and used quick and personal approaches to solve the problems.

Environment/Technology:

Silk Central, MS Office 2013, Win SQL, 11.0, Business Object, SAP, SAS ODS, Windows, MDM (Master Data Management),NRBS, Share Point, RTMS, Facets 5.0

KPMG/State of Hawaii (DHS) Nov2009-Oct 2011

Senior Business Analyst

HAWI is 23 year old legacy system that is used by Hawaii State to process applications and determine eligibility, and maintain eligibility for Medicaid, Medicare, SNAP and other Federal and state government insurance programs. HAWI became inflexible, difficult to maintain and needs lot of manual work. Also, it did not support CMS’IT guidelines and did not align with Medicaid Information Technology Architecture (MITA). Therefore, State decided to replace HAWI system with KOLEA system to implement a new eligibility system that aligns with the CMS vision to make health insurance coverage more accessible and to improve efficiency.

Responsibilities:

Wrote functional specification documents & developed non-functional documents.

Utilized Scrum model from agile methodology.

Structured and evaluated RFP (Request for Proposal).

Conducted JAR sessions to verify and validate the business requirements.

Conducted JAD sessions to allow Connector and DHS stakeholders to communicate with each other, resolve problems at early stage.

Evaluated and structured RFP (Request for Proposal).

Created and maintained Action Item and Policy Item Log.

Used HP ALM tool to manage requirements, create test scripts, and tie requirements to test scripts and identify and manage defects.

Identified and created all necessary business use cases from requirements, created UML diagrams including use cases diagrams, activity diagrams, sequence diagrams, and class diagrams using Microsoft Visio.

Design and develop Business Intelligence solutions using MSBI tools (SSRS, SSAS, SSIS)

Worked with DHS to gather requirements of their current case load management system and suggested new ideas that are helpful in the development of the new KOLEA system.

Created Business Requirement Documents (BRD’s), Functional Documents (FD’s) and System Requirements Specification (SRS’s) documents.

Collected, documented & managed business requirements and managed all change requests.

Conducted workflow, process diagram, data analysis and FIT/GAP analysis to derive requirements for existing systems enhancements.

Utilized Share Point document management system to share documents and to interact with client.

Getting business requirements from the Business Analyst as to what reports to build and what end users expected us to produce.

Involved in making the Medicare patient profiles being compliant with the HIPAA (834 transactions) regulations as well as ICD 9 – ICD 10.

Analyzed processes in medical coding and transition from ICD 9 – ICD 10.

Developed work flow diagrams.

Worked on Document Management, Service Definition, Workflow Management, Contact Management, Neutrals Management, Activity Management and Communications Management modules.

Helped testing team documenting system requirements & testing system development.

Co-worked with QA in writing test plan and data flow diagrams based on Use Cases using MS Visio & prepared expectation management metrics & change management plan.

Prioritized Production issues. The effort enhanced the application and decreased time for the business depending on the issue.

Researched Hawaii Medicaid fee for service claims using Hawaii Prepaid Medicaid Management Information System (HPMMIS).

Designed the ETL processes using Informatica tool to load data from Oracle, DB2 into the target Oracle Data warehouse.

Extensively used Data warehouse ETL tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.

Developed Data warehouse ETL test cases using data dictionary/mapping documents to validate data integrity, data transformation covering mapping, transformations and business rules.

Experience in testing HIPAA EDI Transactions

Involved in fine tuning SQL overrides for performance Enhancements.

Set up definitions and processes for test phases including Product test, system test following quality procedures.

Performed manual testing on the KOLEA system to raise errors.

Documented the errors and escalated them.

Managed security and privacy environments of healthcare data that was governed by HIPAA and other government mandates.

Coordinated with DHS to develop UAT cases.

Conducted UAT (User Acceptance Testing) to make sure that all user requirements are catered by the application & involved in preparing a user manual for the application.

Prepared weekly & monthly status reports, documented process flows, policies & procedures & developed training materials.

Providing UAT Test Case's, Test Results and Defects Report to the Business Users for Production Approval.

Conducted training sessions with eligibility workers and case workers.

Environment/Technology:

Windows, Oracle, Siebel, Identity and Access Management (IAM), JAVA/ J2EE, MDM (Master Data Management), identity access management (IAM), HPMMIS, Federal/State Hub interfaces, BI Publisher, Microsoft Office, Microsoft Visio, Share Point,HP ALM, Bug Zilla, Load-runner.

Quinnox Inc. Pune, India May 2008 - Sep 2009

Process Improvement Expert or “Senior Consultant”, HSBC Account

Responsibilities:

Redesigned and streamlined software development processes using six-sigma methodologies in the role of the Defect Prevention Champion for HSBC’s Global WHIRL Development team. The process improvements resulted in reduction of defect counts by 30% with zero impact on project delivery.

Mapped and recommended best practices for biannually recurring Compliance and Maintenance projects. The recommended process changes were accepted as standards for future C&M projects at HSBC and received high-level client appreciations for the initiative.

Presented internal financial models to investment groups. Compiled packages of documentation to fulfill due diligence and business process requirements of funding firms.

Senior Techno-Functional Expert or “Consultant”, HSBC Account

Responsibilities:

Consulted with HSBC as a functional and technical expert in the FAS and CMS modules of Vision PLUS.

Use Case modeling, translating Business Requirements into Functional and Technical Solutions, developing critical fixes for high priority defects, managing development and testing activities for new card products and features by coordinating and tracking work progress for globally located teams.

Designed, developed and implemented a replacement budgeting system for the IT department. This replaced an Excel-based budgeting system with a Hyperion Planning application.

Led the Hyperion team to complete the 2006 "Reporting Strategy" project on-time.

Designed and implemented a Performance Management System for technical support processes which enabled users to deposit, withdraw investments and manage individual portfolios in easier way.

Worked with SME’s of different groups to gain detailed knowledge of Investments and Capital Market and also to understand the cross impacts of the system

Worked with QA team in requirement testing, integrations testing and UAT.

Achievements:

Won HSBC’s 2008 Q4 TEAM Award for successfully designing and developing techno-functional solutions that enhanced the processing of HSBC’s credit and debit cards.

Received appreciations for mentoring and training junior associates in technical, functional and soft-skills.

REFERENCES:

Available upon request

Contact this candidate