Karuna Mishra

402-***-**** ac0j3q@r.postjobfree.com

SUMMARY

* ***** ** ** ********** in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, OLAP, Client/Server applications.

Solid Back End Testing experience by writing and executing SQL Queries.

Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.

Experience using backend query tools for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.

Extensive knowledge and experience in producing tables, reports, graphs and handling large databases to perform complex data manipulations.

Experience in testing and writing SQL statements.

Experience in Software Analysis, Quality Control, Documentation, Development and Manual QA Testing in Client/Server and Web based applications with Interactive Tools like QA Complete, Quality Center (Test Director), Test Link

Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 7.3 Series and Business Objects XIR3

Experienced in Backend Testing, BI Testing, and Data Quality Issues & Data Reconciliation process.

Extensively strong on databases including Oracle 11g/10g/9i/8i, Toad for Oracle 11.6, MS SQL Server

Extensively worked on analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.

Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.

Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

Excellent written and verbal communication skills including experience in proposal and presentation creation.

Experience in all phases of Software Development life cycle.

Excellent in testing web based applications.

EDUCATION: Master’s in Management Information System

TECHNICAL SKILLS:

Testing Tools : QA Complete, Quick Test Pro(QTP), HP Quality Center, HP ALM, Test Director, Test Link

Reporting Tools : Business Objects, Cognos, MicroStrategy, OBIEE,SAS, Hyperion

Languages/GUI tools : Java, SQL, HTML, Java Script, Visual Basic and Visual Café

RDBMS / Databases : SQL Server, Win SQL, Oracle, Teradata, DB2, MySQL, MS Access

Operating Systems : UNIX, Windows, MS-DOS, Linux

Configuration Tools : MS PowerPoint, Excel, VS, PVCS, Rational Clear Case, MS Visual Source safe

PROFESSIONAL EXPERIENCE:

Ameriprise Financials, Minneapolis, MN June ‘16– May’2017

QA Analyst

Ameriprise Financial is a diversified financial services firm, provides various financial services to institutional

investors and small to mid-sized businesses in the United States. It provides a variety of services and investment

products, including equity and fixed income investments, currency management, annuities, investment brokerage, sale-leaseback capital, insurance, retirement plans for growing business.

Responsibilities:

Participated in gathering Business Requirements and designed the project.

Involved in the design and development of the web application.

Participated in design reviews, involved in making recommendations where appropriate.

Participated in development and validation of entrance and exit criteria for each phase of testing of applications.

Prepared Test data at design phase for both positive and negative scenarios and tested the boundaries for database limitations.

Worked closely with clients and gave presentation on every operational release Tickets.

Written a Test Plan for an entirely new Project.

Responsible for writing test cases using standards defined by the project.

Performed backend testing using SQL queries and various other tests such as user acceptance,

integration, system and regression testing on the new build of the application.

Work with java developers to repair and enhance current base of PL/SQL packages to fix production

issues.

Used defect tracking and reporting, updating the bug status and discussed with

developers to resolve the bugs.

Environment: Oracle 7.0, SQL*Plus, SQL, Test Director, Rational Clear Quest, Windows, MS-OfficeTools, SQL, PL/SQL, Manual Testing, Test Director, Oracle

Crowley Maritime Corporation, FL Jul’15-Sep’15

Sr. BI Tester

Crowley Maritime Corporation provides transportation and logistics services in U.S. and international markets. It provides its services using a fleet of more than 300 vessels and its land based facilities and equipment includes terminals, warehouses, tank farms and specialized vehicles.

Responsibilities:

Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems

Participated in gathering Business Requirements and designed the project.

Tested Cubes and successfully met the production date despite of limited time.

Written Test Plan, Test Strategy, Test Script, Test Cases, reported bugs and tracked defects using QA Complete

Written several SQL queries for validating the front-end data with backend databases.

Defects were tracked and prioritized using QA Complete and analyzed the variation between expected result and actual result.

Written a Test Plan for an entirely new Project.

Tested the data warehouse with the help of data mapping document for various data feeds.

Participated in gathering Business Requirements and designed the project.

Work with ETL developers to repair and enhance current cubes to fix production issues.

Participated in development and validation of entrance and exit criteria for each phase of testing of applications.

Prepared Test data at design phase for both positive and negative scenarios and tested the boundaries for database limitations.

Tested several reports developed in Cognos 7.3 Series

Analyzed the Requirement Traceability Matrix, Daily Test Status reports, Weekly defects report, and Risk analysis by communicating with the Business Team.

Environment: Win SQL for Oracle, SQL Server Management Studio, Toad for Oracle, Sql developer for Oracle, Windows, MS-Office Tools, SQL, PL/SQL, Manual Testing, Agile, Cognos, QA Complete

Magellan Health, Glen Allen, VA June’14– March’15

Sr.QA Tester

Magellan health offers an affordable care for individuals that have the greatest health care needs with a unique vision of better performance of health system. Better outcomes and brighter futures can be gained due to our complete person perspective.

Responsibilities:

Participated in gathering Business Requirements and designed the project.

Participated in testing web based Applications.

Participated in design reviews, involved in making recommendations where appropriate.

Participated in development and validation of entrance and exit criteria for each phase of testing of applications.

Tested entirely new application and successfully met the production date despite of time limit.

Responsible for developing test plans and test cases using standards defined by the project.

Performed backend testing using SQL queries and various other tests such as user acceptance, integration, system and regression testing on the new build of the application.

Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues.

Prepared Test data at design phase for both positive and negative scenarios and tested the boundaries for database limitations.

Used JIRA for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.

Worked closely with clients and gave presentation on every operational release Tickets.

Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems

Written a Test Plan for an entirely new Project.

Environment: Toad for Oracle 11.6, Sql developer, Windows, MS-Office Tools, SQL, PL/SQL, Manual Testing, Test Director, Agile, Test Link, Cognos

UHG, Eden Prairie, MN Sep ’11 – May’14

Sr. Data Warehouse QA Tester

UnitedHealth Group is focused on enhancing the performance of the health system while expanding access and quality, at an affordable price. We seek to empower people with the information, guidance and tools to make personal health choices. We work a little harder. We aim a little higher. We expect more from ourselves and each other. And at the end of the day, we’re doing a lot of good.

Responsibilities:

Tested the data warehouse with the help of data mapping document for various data feeds.

Tested multiple web applications.

Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems

Tuned Backend SQL queries to improve the system performance

Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.

Written Test Plan, Test Strategy, Test Script, Test Cases, reported bugs and tracked defects using Quality Center

Written complex SQL statements for data reconciliation including comparing record counts between source data, data loaded to the warehouse and rejected records.

Prepared Test data at design phase for both positive and negative scenarios and tested the boundaries for database limitations.

Performed all aspects of verification, validation including functional, structural, regression and system testing

Prepared Test Plan and Testing Strategy for the project.

Wrote SQL to perform database testing and to verify data integrity.

Tested different detail, summary reports and on demand reports developed by Report Studio.

Reported bugs and tracked defects using Quality Center

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Analyzed the Requirement Traceability Matrix, Daily Test Status reports, Weekly defects report, and Risk analysis by communicating with the Business Team.

Tested several reports developed in Business Objects XIR3

Tested several data migration application for security, data protection and data corruption

Written several SQL queries for validating the front-end data with backend databases.

Environment: BI Business Objects XIR3, SQL, Teradata 12.0, Teradata SQL Assistant 12.0, Quality Center 10.0, Oracle 11g, Report Studio, SQL Server 2008, TOAD, WinSQL

Mayo Clinic, Rochester, MN May ‘09– Sep’11

QA Tester

Mayo Clinic is the first and largest integrated, not-for-profit medical group practice in the world. Doctors from every medical specialty work together to care for patients, joined by common systems and a philosophy of the needs of the patient come first.

Responsibilities:

Involved in end to end application testing.

Developed business data feeds document for data mapping needs for BI purpose to migrate the data

Documented the validation rules, error handling and test strategy of the mapping.

Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.

Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Created temporary tables for validations after understanding the transformation logic.

Performed the tests in QA and contingency/backup environments

TOAD is used to perform manual test in regular basis. Oracle is used in this project to write Scripts and SQL queries for backend databases

Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.

Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

As QA Tester, performing responsibilities with both the functionality and back end testing.

Wrote complex SQL for Backend Testing of the data warehouse application.

Tested complex mappings using mapplets and reusable transformations.

Established and documented QA standards, procedures and QA methodologies.

Verify development of rule-set test scenarios, test cases, expected results and test scripts

Involved in extensive DATA validation using SQL queries and back-end testing

Worked on issues with migration from development to testing.

Environment: Business Objects, Quality Center, Oracle, SQL Server, SQL, Toad, XML, UNIX, Windows, TOAD, Teradata V2R4

Contact this candidate