Resume

Sign in

Data Analyst

Location:
Chandler, AZ
Posted:
February 22, 2020

Contact this candidate

Resume:

Rupali Das

QA/Business Data Analyst

adbxbt@r.postjobfree.com, 480-***-****

SUMMARY

I am working as Business Data Analyst. Produce accurate, consistent and timely visualizations by extracting information from multiple applications and systems.

Here I am applying basic knowledge of the principles of metadata, lineage, business definitions, compliance, and data security to project work.

I am using Tableau tool to procure data for daily report in business benefit.

Develop quantitative analysis, dashboards, and ad hoc reporting to demonstrate performance of key business initiatives and define areas for optimization

I have worked as an associate QA Data analyst/processor in the backend of an application, verifying the accuracy and validating the data as per the requirement.

Performed research and provided valuable inputs in data management process. Making comparisons, taking alternative actions, and storing data for future use.

Assisted in the development of market research analysis and provided accurate information, free from error.

Extensively used Excel Formulas, Pivot Tables and VLOOKUP functions for data evaluation.

Gathered Business Requirements, Functional Requirements, supported data gathering and analysis of data.

Worked as a UAT Test Co-Ordinator, wrote in-depth and high-level test script for UAT testing environment.

Have written UAT test scripts from FSD document.

Worked on Agile software development environment.

I worked as a QA Test Analyst and is responsible for applying the principles of Testing development life cycle (TDLC), (SDLC) and writing SQL queries.

Perform Functional, Regression and Re-testing. Analyzed System specifications and performed smoke, GUI, functional, Performance, Integration and Usability testing.

I have hands-on experience in Testing of external facing portals for the company, UI testing with a lot of functional backend testing.

Perform Functional Testing, Regression Testing, System Integration testing, User Acceptance Testing (UAT) and End to End Testing.

Used HP Quality Center extensively throughout the testing process to plan and maintain tests, maintain traceability of tests to the application functionality and again to requirements, defect tracking and management, etc.

Conducting functional: positive, negative, boundary, non-functional: compatibility, localization, integration, usability, GUI testing.

Verified results and produce test summaries and defect reports.

Perform browser and platform compatibility testing in IE, Firefox, Chrome on Windows 10/8/7/Vista/XP.

Intermediate knowledge on SQL queries using all joins. Understand stored procedure.

Expert in using Keynote’s DeviceAnywhere mobile testing (iOS and Android) platform to ensure their members have fast, easy access to their health records and account information, regardless of location or time.

I have excellent research and time management skills.

Experienced to work with Agile/Scrum methodology.

Knowledge on API Testing.

Knowledge on Selenium Framework.

I am highly organized with the ability to perform analytical design complementing my technical skills.

SKILLS

Applications: Microsoft Office, PL/SQL, MS Visual Studio, ETL, QC, UFT/QTP, WebServices-SOAP, Selenium, Web Driver, JUnit, TestNG

Languages: SQL, HTML, Java, JavaScript, VBScript, C#, Python

Platform: Windows

Database: Oracle, SQL Server

Markup/Tools: XAMPP, HTML, XML, CSS

BI Tools: SSMS, SSIS, SSRS, SAP Predictive Analytics

Design Software: Corel Draw, Adobe Photoshop, Adobe in Design, Adobe premiere, Macromedia Flash.

PROFESSIONAL EXPERIENCES

Ampcus Inc. Chantilly, VA -- May 2018 -- Present -- Business Data Analyst I

ReqRoute, Inc. Milpitas, CA -- Oct 2017 -- April 2018 -- Data Processor/Analyst

One Source US, Inc. Fremont, CA – April 2017 – Sept 2017 – System Tester

CloudSire LLC, Parker, CO – Oct 2016 – March 2017 – QA Analyst

Sogeti, US LLC, Scottsdale, AZ -- May 2015 – Aug 2016 -- QA Tester

Work Experience

Ampcus, Inc.

Role: Business Data Analyst (Verizon Wireless) May 2018 -- Present

The Business Applications and Data Support Analyst within Information Technology supports change and problem management, application and configuration management and production support of the suite of business applications and customer web sites ensuring that the systems and data are accurate and available in a 24x7-operating environment in Verizon Wireless.

Attend daily standup meeting and end of iteration meeting.

Attend review meetings with Business, Developers and end users to understand the requirements Review data to ensure accuracy and completeness of data.

Review audit trails on computer systems used to acquire and process data.

Work closely with internal teams to identify and recommend areas for data analytics.

Organized with the ability to work on multiple tasks concurrently.

Verify and maintain data integrity upon completion of audit.

Training individual submarket to follow the process of data analytics with the company regimen.

Use SQL queries to fetch data for everyday data analysis.

Use Tableau tool to create daily report for data integrity and accountability.

Environment: Tableau, HP ALM 12.53 Oracle 11i, Eclipse IDE and JIRA, Hue

ReqRoute, Inc.

Role: Data Analyst (Centene) Oct 2017-- April 2018

Project on data processing and data analysis for Insurance based company (Centene). Collecting and verifying the accuracy of the data provided and process based on requirements.

ACCOMPLISHMENTS:

Involved in preparing QA sizing document and QA Sign Off document based on the Test Plan approved by the Project Manager, QA lead and developers.

Involved in reporting the performance issues in UAT.

Verify and manipulate data to produce meaningful information using excel.

Reported defects using QC and interacted with developers to resolve any defects/issues.

Created basic SQL queries for backend testing.

To validate and ensure the supplied data is correct and relevant.

Performed Sanity testing in Production environment after application is deployed. This is to confirm that application is deployed correctly and working as expected.

Sorting and arranging items in some sequence and/or in different sets.

Summarizing data to reduce detailed information from its main points.

Aggregating the multiple pieces of data.

Analyze the data by collection, organization, interpretation and presentation of data.

Create report to list detail or summary data or computed information.

Classifies and separates data into various categories.

Environment: HICS applications. HP ALM 12.53 Oracle 11i, Eclipse IDE and JIRA, QC.

CloudSire LLC, Parker, CO Oct 2016 – Sept 2017

Created functional automation scripts using open source tools selenium (Selenium IDE and Web Driver).

Experience in testing the application using TestNG, Data Driven Framework in Selenium Web Driver.

Developed and Modify the Test Automation Scripts in Selenium environment and logging all errors during execution in Test results Log file and logging in defect management tool.

Generating and executing Test Script by creating a test suite of automated regression testing using selenium tool.

Responsible to verify Web Services API request, response data validations using SOAP UI.

Used Java scripts to create test automation for the notification system.

Created automation scripts using QTP for different scenarios, used Smart Identification feature of QTP to identify unique properties of objects, created user defined functions, reusable actions, and managed shared object repositories.

Used QTP checkpoints for checking web pages, images, texts, tables and various UI elements.

Collected test data from the data team and tested for different kinds of scenarios (Positive & Negative) for the different fields of UI module.

Involved in preparing QA sizing document and QA Sign Off document based on the Test Plan approved by the Project Manager, QA lead and developers.

Involved in reporting the performance issues in UAT.

Reported defects using QC and interacted with developers to resolve any defects/issues.

Created basic SQL queries for backend testing.

Responsible for centralizing the testing approaches in various projects.

Performed cross browser testing and cross platform testing.

Prepared status summary reports with details of executed, passed and failed Test Cases also involved in weekly status and task review meeting.

Involved in interaction with third party vendors for selection of the testing tool.

Environment: Selenium, UFT/QTP, Java, JavaScript, VBScript, Oracle 11i, Eclipse IDE and JIRA, QC.

Sogeti US LLC, Scottsdale, AZ May 2015 – Aug 2016

Project on testing services and data Analysis. Verifying the quality of software and identifying complex data combinations used to test manually and automation software defects and to manage work products created by a remote/offshore team.

Role: Role - Manual Functional Testing, Web Services Testing and Automation Testing.

Attended Iteration planning meeting and finalize the user stories and estimation for the 2 weeks' sprint/iteration.

Involved in preparing high level scenarios based on Agile Methodologies for each Scrum.

Gathering Business Requirements, Functional Requirements and Technical Design Documents.

Performed Functional, Integration, Regression, End to End and User Acceptance Testing.

Involved in creating the Traceability matrix based on Functional requirement in each module.

Develop Scripts using Selenium Web driver with Java and TestNG framework.

Developed and maintained Data Driven framework using Selenium Web driver, Java and TestNG.

Created reusable and application specific functions using java.

As a part of Automation framework developed a customized excel test results report by using JXL and POI API functions.

Preparing Regression Test Matrix and providing details to Management.

Analyze User story, develop and deliver Automation Script in the same agile iteration.

Involved in Peer Reviews to check the correctness of the test Scripts and Test cases.

Attend daily standup meeting and end of iteration meeting.

Attended review meetings with Business, Developers and end users to understand the requirements.

Created and maintained Regression and Sanity Test Suite using Selenium Web driver using Java.

Execute Selenium Scripts, analyze results and report failures to dev team.

Have very good experience in testing web services using SOAP UI.

Import web service operations using WSDL URL and validate in SOAP UI.

Performed Sanity testing in Production environment after application is deployed. This is to confirm that application is deployed correctly and working as expected.

Developed and executed complex SQL Queries to perform database testing.

Written and executed SQLs.

Involved in Back End testing, written SQL queries to retrieve and validate the data.

Identified, logged and tracked defects in SqUIDS throughout the Defect Life Cycle.

Expert in using Keynote’s DeviceAnywhere mobile testing (iOS and Android) platform to ensure their members have fast, easy access to their health records and account information, regardless of location or time.

Run regression and smoke test suites on a new version of the application.

Gave Demos to Product Owners and delivered User stories from that Sprint.

Design Automation framework using keyword driven and data driven framework.

Creation of automation test suits for functional testing.

Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings.

Environment: Selenium, UFT/QTP, Java, SOAP UI, VBScript, Eclipse IDE, QC.

EDUCATION

University of Denver, MS in Information Technology (2015)



Contact this candidate