Post Job Free

Resume

Sign in

Data Analyst

Location:
Minneapolis, MN
Posted:
April 02, 2020

Contact this candidate

Resume:

MANASI LINGE

952-***-**** adck0k@r.postjobfree.com https://www.linkedin.com/ManasiLinge

SOFTWARE QUALITY ASSURANCE

Creative and testing-savvy, software product and software Test Framework/Automation quality assurance professional with 10 years of progressive experience across a broad range of financial, banking functions and healthcare industry segments. Proven ability to combine vision, creativity and strong product acumen with well-developed testing management and leadership qualities to support the testing efforts, product launches, positioning companies and products for success. Areas of expertise include:

QC/QTP

Agile/Scrum

SDLC

835 File

STARS

Rally

MS Visio

SSRS

SSIS

COGNOS BI

HEDIS

Share Point

Healthcare Industry

Medicare and Retirement

Medicare Claims

CPT code

ORACLE/SQL/TOAD

E&I

C&S

STLC

Tableau

Community & State

SOA

PCOR

MACRA

Selenium

UFT

PROFESSIONAL EXPERIENCES

OptumInsight (Optum Advisory services) 2017-Present

Senior Healthcare QA Consultant

Project: STARS Quality reporting and Initiative Management:

1.UHC Medicare and Retirement :

i.Rate Maximization

ii.PCOR – Community and State, E&I, MnR

iii.MACRA

Project: UHC Digital, M&R Digital:

i.QA Assessment

Project: Episode-Based Payment System

Key Contributions:

As a QA lead reviewed the Detailed Business Requirement document.

Created Test plan and Test strategy.

Lead 5-6 team members in the whole QA Process.

Worked with UHG Administration team to get setup ALM Application Lifecycle Management tool for our team.

Created Development and quality assurance process documents.

Created technical documentation looking at the Store procedure and Scripts for the Payment Application.

Worked in Smart Base-Remote Desktop connection. Used UltraFinder to find the scripts and store procedure.

Being a QA consultant supported the pharmacy analytics on the Care Services Stars / Quality Reporting and Analytics team and tested thePart D STAR measures like Medication Adherence and tested the Clinical Programs like Institutional SNP, DSNP, HouseCalls etc.

Tested all aspects of pharmacy data related to Part D STAR measures

Performed unit testing, system integration testing, user acceptance testing, configuration testing, regression testing specifically in Agile and waterfall methodology.

Worked closely with cross functional team. Conducted daily scrum standup meetings.

Responsible for overall daily, weekly, monthly operations testing in production. Also responsible for enhancement testing for the new requirements right from the initial process of reviewing requirements with systems analyst and Business analyst, provided estimates for hours, resources for enhancement testing.

Written and reviewed SQL code in SQL Server Management Studio, Toad Tera-data tool

Worked in QA Assessment team, to provide support to team within UHC. Conducted several interview meetings with UHC digital team to understand the current testing process pain points. Involved in creating QA assessment documents. Created visualization flow chart using MS-Visio. Build frequently asked questionnaire for the in-house centralized share point tool.

Was responsible for data analysis tools such as: SQL, Tableau, MS SQL Server. Teradata etc.

Worked on reviewing PDF files generated. Used Beyond compare tool to compare the PDF files.

Worked in SVN-Subversion Repository Browser to track the version of code and to control version, to see what is changed, when and why.

Created visualized flow chart using Visio and PowerPoint.

Being a senior consultant was Involved in process improvement, workflow, benchmarking processes.

Verified QA Zip files and Reports for Quarterly updates.

Experience in Agile methodology. Worked with sprint planning team. Attended scrum meetings with cross functional team. Executed testing phases like integration testing, system testing in sprint like 2-3 weeks.

Actively participates in all sprint meetings Planning, Grooming, Daily Stand-ups, Sprint Review and Retrospectives

Define, gather, and analyze system requirements and technical specifications to create and execute test cases for large clinical IT initiatives

Ability to write test plans, test cases, and execute tests within a distributed environment

Manage defects and help drive defect resolution

Assist business users in defining user acceptance testing

Develop in-depth system and application knowledge to provide higher test quality and coverage Experience working directly with business users

Experience in creating test data requests from upstream applications for SIT

Establish and maintain test cases and test data

Hands-on in creating/debugging/enhancing different automation frameworks

Create and maintain test cases in a test management tool such as ALM and CA agile central

Actively participate in walk - through, inspection, review and project meetings

Work with business users, business analysts, and developers to create and analyze various required project documents

Participate in production implementation verification and accountable for validating system quality

Plan, document, evaluate and track testing results to ensure system applications are free from defects

Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and / or functionality

Automated manual test packs resulting in significant cost and time savings

Heavily involved in sprint grooming, planning, retrospective meetings

Involved in code reviews, giving suggestions and areas of improvement to the team.

Defined and documented requirements for the automation process

Planned test activities for current and next sprints in parallel to development of new features

Attended user story walkthrough meetings and explained the requirements to the team

Done heavy backend ETL testing using tera data and sql server.

Trained junior testers on the automation and how to use it to reduce manual efforts

Good Knowledge in participating in bug triage meetings with developers to validate the severity of the bug.

Wells Fargo Home Mortgage 2015-2017

Systems QA Analyst-4

Project: SLoaD Application (TOG)

The testing duties of our team pertain to software used by the Default Services – Collections and Home Preservation business lines for multiple aspects of loan servicing. The goal of Default Services – Collections and Home Preservation is to work with customers to help them retain or liquidate homes to avoid foreclosure.

Key Contributions:

Working with Home Preservation, Settlement.

Responsible for reviewing Requirements from BRD provided by Business. The following methods were used. Walkthroughs, BRRD- Business Rules requirement documents, BRD -Business Requirements Document, FSD -Functional Design Documents, Test Plan. Ongoing meetings regarding Testing Status, Defect Calls, Project Status Calls.

Working as a SME- subject matter expert and worked Independently and was responsible for Integrated Functional Testing for the designated WA- Work Assignments for BRRD, BRD, FSD for test planning, data preparation including conditioning for FNMA and FHA loans. Created test cases, completed test execution through the Defect life cycle.

Created Ambiguity documents, test objectives, test scenarios, test scripts and execution for each release. The information that was gathered is documented using HP/ALM. Test cases are executed and defects are recorded as appropriate. Defect and fixes are applied as well as assigning priorities and working with the development team to bring them to closure

Executed test cases in HP/ALM Quality center for IFT testing, regression testing, Ad-hoc testing, and Extract testing.

Work with the automation team to field any questions they have as they are setting up the regression bed for test case execution

Mentored new team members as they came onboard.

Worked closely with Data analyst, Business Analyst, QA Leads and Manager.

Tested Windows 10 when it first rolled out for our team. Ensured that all the testing tools and applications were compatible with windows 10

UNITED HEALTH GROUP, MN (OptumHealth) 2011–2014

Software Quality Analyst and Data Tester

Project: eSync Health Portal

Key Contributions:

Reviewed System Requirement Specification and Use Cases. Generated and ran the scripts, analyzed the results using SQL. Responsible for Quality Center set up to manage the testing phase like Testing requirements, Planning Tests, Running Tests and Defect Tracking.

Being a data analyst, performed Mass Migration testing, Data Integrity testing. Responsible for Test Data Creation. Generated the flat files to load them in the database engine.

Responsible for Maintaining and managing the data for each work-stream in excel sheet.

Using standard layout and Macros. Generated the flat files so that the data can be uploaded to the FACETS.

Worked closely with internal partners like DA’s, QA Leads and Development Leads.

SCANTRON CORPORATION, MN 2010-2011

Software Quality Analyst

Project: 1) ScanStation 2) Regulation E

Key Contributions:

Responsible for testing the application using operating system (win7, Win XP, Win Vista) and Virtual Machine ware Workstation on Windows Host (Windows Vista Business) in different limited/restricted user mode, standard mode and admin mode. Worked on installation of the software application, installed operating system and also installed printer, configured the scanner to the machine.

Worked on Web based application where bank representative and bank clients have the option to opt in or opt out. Generated and tested the weekly and daily reports of each financial institution against the database.

Performed testing phase using team foundation server. Participated in Walkthroughs and Triage Defect report meetings periodically.

UNITED HEALTH GROUP, MN (OptumHealth Financials) 2009– 2010

Software Quality Analyst

Project: Strategic Payment Program (UAT)

Analyzed the user requirements and interacted with system architect, developers and business users.

Worked as a Lead for overall script creating and writing effort for a Strategic Payment Program. Handled 2-3 team members and also worked with cross-functional team members.

Reviewed Business Requirements Documents and the Technical Specifications Documents and developed test plans and manually executed test cases, test scenarios using the Quality Center/Test Director to test the functionality. Prepared test status reports during test execution process.

Performed regression testing, UAT Testing.

Generated and ran the scripts, analyzed the results. Logged the bugs in Defects tab in Quality center.

Responsible for creating test data/ script using excel sheets, xml files and executing test scripts and logging the defects.

Involved in Writing, Updating and maintaining the UAT validation criteria using excel sheet for various stages of Testing.

Validated Providers Explanation of Benefit’s (Electronic payment and Paper payment) using Enterprise Data storage System.

Involved in the process of migrating the test cases manual to manual (Test director to Quality Center 9.2).

Executed the script using TOAD and written SQL queries to pull out the reports from the database with UAT, STAGE, and SYSTEST environment.

Worked on Oracle Financials to pull out the data against UAT testing for Payment engine.

Executed the scripts using Ultra Editor tool.

Worked in operational Reporting Business intelligence tool. Pulled out the reports from ORBIT and Executed the reporting scripts for system run reports(TOPS,GFLX), delayed Resubmitted payment Reports and Pacific funding payment Reports.

Developed Manual Test Cases and tested the whole application and defects are isolated.

Pulled out the screenshots of TOPS claims using IBM Personal communications.

Participated in Walkthroughs and Triage Defect report meetings periodically.

UNITED HEALTH GROUP (Ingenix), MN 2009

Software Quality Analyst

Project: GES-TRICARE (Government Encounter System -Medical Claim Application)

Key Contributions:

Involved in Quality Center and QTP Administration and installation process. Developed Test Strategy for Automation testing tool QTP. Build and automate testing scripts using Quick Test Professional. Created Test Data (UI Test Data) for Test cases using Logical/Physical Data Model. Developed Regression Scenarios for Automation Testing.

Performed the complete testing phase and defect life cycle. Involved in Backend testing by using SQL queries

Analyzed the user Stories/requirements and interacted with system architect, developers and business users. Worked with cross-functional team and technical team. Participated in Walkthroughs and Defect report meetings periodically.

Wells Fargo, San Francisco, CA May’07 - Feb’08

QA Analyst

Credit Approval System (CAS) is to provide the client credit information to OASIS. Bear Stearns Tech group initiated the web enabling of the Collateral Monitoring system (OASIS). Since CAS and OASIS are tightly coupled, it has been decided that CAS would also be web enabled, so as to provide the credit users with a single credit application using the Single Sign On security interface.

Analyzed the requirements of the application and involved in creating the Functional Specification.

Involved in design and development of Test Plan and Test Cases using the SDLC procedures.

Set up the Automated Testing Environment for creating, and running automated tests using QTP.

Created Shared Object Repository using QTP.

Developed Automation Driver & Component Scripts, common and application common reusable library functions, Configuration files and Recovery Scenarios using VB Script.

Parameterized the scripts with Action parameters, Data table parameters, Environment variables and random numbers.

Generated the reusable library functions to import test data from & export the test results to external files like Excel sheets, notepads and XML files, generated the log files and screenshots.

Developed the scripts with descriptive programming in QTP.

Implemented Excel Objects and XML Objects to interact with the test data in Excel sheets and XML files without importing into QTP.

Implemented Data base check points and XML check points in QTP.

Generated the script for Automation Object Model to automate QTP.

Logged the bugs in Defects tab in Quality center.

Generated and ran the scripts, analyzed the results with Load Runner.

Responsible for creating test data using excel sheets, xml files and executing test scripts and logging the defects.

Developed Manual Test Cases and tested the whole application and defects are isolated.

Prepared test status reports during test execution process.

Performed Functional Testing, Integration Testing, Regression Testing, Performance Testing, User Acceptance Testing, GUI Testing and System Testing.

Extensively used SQL to verify the integrity and consistency of the data in the database

Used Hogan - data translate Translates back-end data into easily understood, manageable information for your front-end system

Interacted with Developers as needed to isolate the main cause of defects.

Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing.

Responsible for Quality Center set up to manage the testing process like Testing requirements, Planning Tests, Running Tests and Defect Tracking.

Environment: Manual Testing, Version one, Quality Centre, QTP, Subversion, Java, J2EE, Struts, Java Beans, Web Sphere, Bugzilla, Hogan, TOAD, BPT, Oracle 9i, UNIX and Windows XP. Waterfall and agile.

APOLLO HOSPTIAL, BANGLORE, INIDA 2004 - 2005

QA Engineer

Key Contributions:

Review and analyze Requirements and Design documents. Performed Functional, Transaction, Integration, End to End, Positive testing, Black Box testing, White Box testing and Regression testing. Developed and executed Automated Test Scripts for Functionality, GUI, Stress and Load Tests. Win Runner was used for automation of regression.

Created test plans and test cases for Manual and Automated Testing. Developed Test scenarios and Test cases using Test Director. Conducted System and Regression Testing using Win Runner and identified application errors. Developed Data Driven Tests using test data from flat files and analyzed the results using Win Runner.

Involved in Backend testing by using SQL queries. Tested Links and identified broken links using appropriate functions in Win Runner. Tested the application under Load and Stress using Load Runner.

ICICI BANK, MUMBAI, INDIA 2001 - 2004

Test Engineer

Key Contributions:

Analyze ILOG BRMS products requirements. Involved in writing Test Plans, Test Cases and Test Scripts, setup testing environment. Design and execute test cases, track and analyze issues, report test result and perform bug-fixing verification. Worked with ILOG Product Development and QA Team.

Worked with batch jobs and validated the reports. Coordinate and executed test work between ILOG product QA team and SDC Team. Participated in System, Regression and Acceptance Testing. Wrote SQL queries, PL/SQL procedures to ensure database integrity

Worked with all levels of management and resolved the issues found. Communicate and work with people of all technical levels in a team environment. Maintain excellent performance and exceed Client's expectations consistently throughout project.

Education and Technical Proficiencies

Bachelor of Science (BSC) in Chemistry

University of Pune, MH, INDIA

Technical Skills

Microsoft Tools (MS-Visio, MSPS (MS-Project server), SharePoint, MS- office Outlook MS Excel, MS Word, MS PowerPoint, Adobe Acrobat Reader, Velocedi.)

Other Tools (Ultra Edit, PLSQL Developer, SQL plus, Putty (SSH, Telnet and Rlogin Client), ORBIT, Toad and knowledge of ETL tool Informatics, ab initio.)

Databases (Oracle 9i/8i/8/7x, MS SQL Server, MYSQL Server, SYBASE, DB2, MS Access, UDB, AJAX)

Tools (Quality Center, QTP, Win Runner, Load Runner and Selenium, Rally, Test Director)

Web Technologies (JavaScript, CSS, HTML, DHTML, SOAP, XML, ASP and JSP, Agile/Scrum)

Languages (C, C++, Java, J2ee, VBScript, UNIX Shell Scripting, TSL, SQL and PL/SQL)



Contact this candidate