Data Test Cases

TANUSHREE PATRA

SUMMARY

IT QA/Business Analyst with Automotive industry, Finance, and Health care domain experience.

Develop and maintain business requirements, technical/functional specifications, process workflows, use case diagrams/documents, and traceability matrix documentation.

Author test cases to review applications, design and implement basic SQL queries for QA testing and report/.data validation.

Developed report scripts to export data files and compare with Informatica files.

Participate in Joint Application Development (JAD) meetings with IT and project team members to conduct gap analysis tasks and develop use case and user story documentation.

Retrieved data from SAS into Essbase and prepared daily reports for review by authorized users.

TECHNICAL SKILLS

Business Intelligence

Application Development

Gathering Requirements

IBM Cognos

Informatica MS Excel

JIRA

MS Visio

Oracle

QA Testing Quality Assurance

SAP

SAS

SDLC

SQL

PROFESSIONAL EXPERIENCE

Blue Care Network

Business Analyst

August 2018 - Present

Created user stories to assist with the development of a new Web Based Application tool that enables the users to create requests for Care Advance and Facets.

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

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

Coordinate project initiatives with software developers, stakeholders, project managers and software testers.

Created test cases and executed the test cases to make sure that all requirements are meet.

Did UAT testing before the Sprint Demo.

Developed the product backlog along with Product Owners.

Participated in sprint planning, daily scrums, testing, retrospectives and sprint reviews.

Created Product Backlog, Sprint Backlog and managed User stories in Jira.

Created issues and bugs in Jira.

Created and Managed version control in Jira.

Developed the product backlog along with Product Owners.

Developed detailed Test Plan for system Testing based on SRD and BRD.

Developed SQL queries to extract data from the source tables.

Involved in writing and implementation of the various Test cases and Test scripts.

Created Test Cases as per the business requirement and executed them.

Developed Test Plans, Test Cases in Test Manager.

Evaluated and documented actual test results against expected result.

Conduct variety of tests, including but not limited to database testing, security testing, regression, GUI,

integration, UAT, non-functional, etc.;

Designed, setup, and modify test cases, test plans, test data, and test environments;

Interacted with developers, Business & Management Teams and End Users.

Involved in cross browsing testing of the application on various browsers to ensure it functions.

INFO SERVICES LLC, MI

Business Analyst

February 2016 - July2018

Provide detailed reviews and analysis of client business needs and recommend corrective actions design to improve service quality and value for their customers.

Perform data audits for clients, requirements/gap analysis, author summaries, and collaborate with internal. teams on content and scheduling of client deliverables.

Serve in a key role on various teams through all project phases to ensure business objectives are met and draft requirements for review and approval by senior leadership from both company and client sides.

Develop and maintain business requirements, technical/functional specifications, process workflows, use case diagrams/documents, and traceability matrix documentation.

Author test cases to review applications, design and implement basic SQL queries for QA testing and report/.data validation.

Participate in Joint Application Development (JAD) meetings with IT and project team members to conduct gap analysis tasks and develop use case and user story documentation.

ALLY FINANCIAL SERVICES, MI

Business Analyst

December 2014 - July 2015

Handled Monthly, Managerial, and Security closing and forecasting processes.

Designed Essbase applications with balance of Dense and Sparse Dimensions.

Developed comprehensive reports with Hyperion Financial Reports, Excel Add-in, and Smart View, created. Cubes leveraging a variety of storage options, and retrieved data to analyze cube outlines for data integrity.

Granted user access based on established needs and assigned them to specific groups for preservation of confidential data.

Author test cases to review applications, design and implement basic SQL queries for QA testing and report/.data validation.

Optimized outline structure, loading, and calculations through development of appropriate dense and sparse settings of dimensions, storage allocations, and dynamic calculations.

Created Rules files to migrate data from client's financial database Essbase cubes, and built linked and transparent partitions between source and target cubes.

MERCEDES BENZ FINANCIAL SERVICES, MI

Business Analyst

March 2012 - July 2014

Created new cubes and migrated existing ones from older Essbase server to an upgraded Windows environment with all historical data intact.

Ensured data integrity through all security and change management phases.

Leveraged a migration wizard program to port cubes from Essbase 7.1.3 to System9.

Developed report scripts to export data files and compare with Informatica files.

Installed, configured, and maintained Hyperion System 9 environment and Shared/Analytical Provider services platforms.

Fabricated SQL scripts, indexes, and complex queries to perform quality assurance and server environment testing.

Supported business users in the retrieval of critical data in Smart View format.

Created a variety of documents for installation of Smart View and to stop/restart Essbase services.

Maintained and monitored individual and group users in Shared services.

Developed web forms, business rules, and sequences for authorized users.

INTEGRETAS, MI

Business Analyst

January 2012 - March 2012

Retrieved data from SAS into Essbase and prepared daily reports for review by authorized users.

Copied and migrated exported data into various technical environments.

Added and provisioned users and groups into the LDAP directory.

Created and modified report scripts designed to extract and migrate data for cube balancing.

Prepared Maxl scripts to rename applications and subsequent provisioning of users.

Developed and modified .Property and .CFG files in Essbase and Provider services.

SENRYO TECHNOLOGIES, IL

Essbase Analyst

September 2011 - December 2011

Provided high-level support to resolve production issues, including eradication of bugs in Intranet applications and Essbase cubes.

Maintained cubes to display Essbase Status in easily identifiable views.

Performed database administrative activities including, but not limited to, user and group creation, setting of passwords, and establishment of filters.

Modified and redeployed applications in development, test, and production servers.

Authored and distributed user documentation.

EDUCATION

Bachelor of Science in Accounting and Commerce, Accounting and Commerce, Utkal University, Bhubaneshwar, India, 2003

Contact this candidate