Post Job Free

Resume

Sign in

Data Analyst Manager

Location:
Cincinnati, OH, 45242
Posted:
November 06, 2020

Contact this candidate

Resume:

Mili Sarmah

adhl2d@r.postjobfree.com

513-***-****

SUMMARY:

·Completed M.S. in Information Systems, American Sentinel University, Colorado, USA in the year 2014.

·Five years of experience in the Software Quality Assurance of Web Based and Client Server Applications and Data Manager for Population Council of India.

·Experience in Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC),

·Worked in Agile methodology.

·Extensive testing skills includes develop and execution of Test plan, Test Scenarios and Test Scripts, and participates in QA reviews and documenting QA activities

·Experience in Manual and Automation testing

·Experience in testing with cloud based environment – AWS .

·Experience in preparation of effective Test cases (Complex, End to End, Business flow, Scenarios based, Component based), test case execution, filing and tracking of defects

·Experience in testing web services/Rest APIs using Soap UI.

·Expertise in Defect tracking and Defect management tools; HP Quality Center, QTP

·Experience in testing across different device such as chrome book, IPads,Mac book, Mobile devices for compatibility testing .

·knowledge of programming languages – VB script, java script.

·Proven ability to support multiple projects under tight deadlines often with competing priorities and complexities and ability to work independently.

·Experience in GIS and remote sensing during research work done for M Phil dissertation.

·Experience in writing SQL Queries to query the database using SQL server management studio and PL/SQL Developer.

·Good presentation, communication, coordination, issue finding, solving and learning skills.

·Experience in leading in QA facility.

·Programming experience of disability testing tools like Jaws screen reader during MSIS.

·Experience in IIS, .net framework

TECHNICAL EXPERTISE:

Testing Tools

Soap UI, HP Quality Center, QTP.

Programming Tools

Vb script, JavaScript

Databases

Oracle, SQL Server,

GIS Tools

SPSS, Arc View, Arc GIS, EP12.

Tools

MS-Excel, MS-Word, MS-PowerPoint, Visio, Rally xml, HTML, Jira, TFS, SharePoint, GIT

EDUCATION:

·Completed M.S. in Information System, from American Sentinel University, Colorado, USA in the year 2014.

·Completed Masters of Philosophy in Geography from Jawaharlal Nehru University, India in the year 2003.

·Completed Masters in Geography from Jawaharlal Nehru University, India in the year 2001

·Completed Certification in GIS and Remote Sensing.

·Completed Certification in Quality Analysis

PROFESSIONAL EXPERIENCE:

Project: Formative Assessment for Teachers (FAST) Jun 2016 – Nov 2017

Client: Fast Bridge Learning

Role: Software Quality Assurance Specialist

FAST is a next-generation of evidence-based classroom assessments—created with and for teachers. FAST offer the only comprehensive assessment system with both Curriculum-Based Measures (CBM) and Computer-Adaptive Tests (CAT) to screen, diagnose, monitor and inform instruction faster—when you need actionable data—so you spend less time testing or guessing and more time teaching. It also offers screening, progress monitoring, and MTSS/RTL support, online scoring, and automated reporting. It is a cloud-based system which is easy to implement with online training and resources, automated rostering and SIS integration, nothing to install or maintain, and multi-platform and device support.

Responsibilities: -

1.Evaluate and test new or modified software programs and s/w development procedures used to verify that system functions according to user requirements use cases and conforms to business guidelines.

2.Review new or modified code changes, including documentation, diagram, and flowcharts, to determine if the system will perform according to user requests and conform to business guidelines.

3.Recommend design improvements, enhancements or corrections to programs.

4.Identify difference between business standards and user applications and suggests modification to conform to standards.

5.Analyze and understand requirements, devise a test strategy to adequately cover the requirement and use cases, develop high level test scenarios that implement the strategy, and elaborate scenarios into detailed test cases.

6.Collaborate with business and development teams to produce requirements that are well documented and clear.

7.Maintain subject matter expertise for the system under test and use that expertise to create, maintain and extend the test case library.

8.Database testing was done in cloud bases environment – AWS.

9.Participates in team process improvement to make sure everyone understands development lifecycle

10. Experience in leading a small group of interns in QA facility.

Project: FORCE: Sept 2015 – Jan 2016

Client: United Health Group

Role: Quality Assurance Analyst

This is a web-based application to create and manage Presale Health insurance plans. This project also included migrating the existing plan data in EXCEL to SQL server database. There is a rule engine which handles the federal, state and market mandates. The application has a user interface to create individual plans through it or creating multiple plans by copy pasting directly from an excel grid into the UI.

The complete process included Creating/Updating/Deleting plan, running plans through compliance Rules and exporting various reports for downstream consumers and systems.

Responsibilities :-

1.Involved in Requirement review meetings with Developers and with the Business to get more information

on each sprint release.

2.Analyze business requirements and develop test scenarios corresponding to all functional test cases/User Stories.

3.Interacted with the Business to clarify ambiguities and verify traceability of test conditions to Test Cases

4.Worked closely with the developers and engineering teams in review and modification of the product and its specifications using Agile-testing methodology.

5.Developed Test Scripts and prepare Traceability matrix and prioritize test cases for each sprint release.

6.Participated in daily Scrum and meetings and participates in Sprint planning and Sprint review meetings

7.Created test cases and test scenarios.

8.Responsible for reviewing Release Notes for each build and perform Smoke test, retest defects fixes and perform Regression test and update defect list.

9.Performed functionality, regression, compatibility, and Web application testing, and ad hoc testing for Force.

10.Coordinated between the business users and the development team during the user acceptance testing

11.Performed End-to-End testing of the Force Insurance application and to ensure application is working as designed

12.Perform Back end testing and writing SQL queries to validate the data in back end data base tables

13.Involved in Data migration testing

14.Involved in Rules (Mandates) Testing.

15.Ability to participate proactively on a project team to provide high quality results and communicate complex technical information to various levels of Project team members and Project coordinator

16.Performed peer reviews for the Test cases by the team

Project: HIOS Catalog:

Client: United Health Group

Role: Quality Assurance Analyst

.

HIOS Catalog: This project deals with the affordable care act (ACA) and helps in managing the HIOS (Health Insurance Oversight System) ID’s for unique combination of plan. Only Small Business and Individual plans which are ON or OFF the exchange are assigned a HIOS ID. This system caters to the need of many downstream consumers within the company and also used for reporting to the Government. There is a web service built which provides unique HIOS ID for a set of defined parameters. Also, this system sends lot of batch feeds which is time sensitive. These are a very critical application and have lot of financial implication.

Responsibilities: -

1.Involved in Requirement review meetings with Developers and with the Business to get more information on each sprint release.

2.Analyze business requirements and develop test scenarios corresponding to all functional test cases

3.Interacted with the Business to clarify ambiguities and verify traceability of test conditions to Test Cases

4.Worked closely with the developers and engineering teams in review and modification of the product and its specifications using Agile-testing methodology.

5.Developed Test Scripts and prepare Traceability matrix and prioritize test cases for each sprint release.

6.Participated in daily Scrum and meetings and participates in Sprint planning and Sprint review meetings

7.Created test cases and test scenarios.

8.Responsible for reviewing Release Notes for each build and perform Smoke test, retest defects fixes and perform Regression test and update defect list.

9.Performed functionality, regression, compatibility, and Web application testing, and ad hoc testing for HIOS.

10.Participated in end-to-end testing in different environments using Soap UI for testing the Web Applications and reports

11.Coordinated between the business users and the development team during the user acceptance testing

12.Performed End-to-End testing of the HIOS application and to ensure application is working as designed

13.Perform Back end testing and writing SQL queries to validate the data in back end data base tables

14.Ability to participate proactively on a project team to provide high quality results and communicate complex technical information to various levels of Project team members and Project coordinator

15.Performed peer reviews for the Test cases by the team

Project: Invoice Management System Oct 2007 - Aug 2009

Client: Indsoft inc

Role: QA analyst

The Invoice management project is a web based application which gets invoices from different vendors to the system. The system processes those external files and sends data to the database. Some send it as csv file and some as excel spread sheet. The system has excellent search facilities to load the invoices to the web based screen. Users can validate the invoices make corrections and save them to the database again. The UI was built in asp .net and the back end is SQL Server 2008.

Responsibilities: -

1.Understood the business logic, user requirements and test-objectives to develop use case scenarios.

2.Created Traceability between Requirements and Test Cases.

3.Reviewed test conditions for QA and made recommendations.

4.Provided functional testing of the system to assure that changes were correct.

5.Documented defects in defect tracker on issues found while system testing and documented Error Codes generated by different Systems during Testing.

6.Facilitated project meetings including scheduling, recording and distributing minutes, and following up on action items.

7.Experienced interacting with business users and executives to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Project Charter and Project approach documents.

8.Participated in Integration, System, GUI, User Acceptance Testing.

9.Maintained Test Logs and Reports in MS-excel.

10.Test data coming from web services as input to the system. Vendor information and some business rules for validations were tested

Project: HIV Prevention Strategies in Western India Apr 2004- Oct 2004

Client: Population Council of India, Govt. of India.

Role: Data Manager / Analyst

I worked as a Data Analyst for the project. My role was to analyze data produced from HIV positive patients. Interviewers conduct interviews with different people with HIV virus. This data is fed into the system called EP12. Reports were generated and sent to population council of India. An inbuilt questionnaire in presented to the patients and they either talk or fill that information. The interview provides the documents

Responsibilities: -

1.Analyze the date fed data to the system using EP12.

2.Analysis of data and generating reports.

3.Statistical tool SPSS is used extensively to quickly view data, formulate hypotheses for additional testing, and carry out procedures to clarify relationships between variables, create clusters, identify trends and make predictions.

4.Have to send a weekly report to the population Council of India, Delhi with data from around 50 patients from different hospitals in Pune, India

5.The tool uses excellent feature to generate reports as per gender, age, problems, locations, habits.



Contact this candidate