Uploaded File
add photo
Suprita
suprita_jain31@yahoo.com
904-608-1184
Jacksonville, FL 32099
QA/BA Analyst
10 years experience W2
0
Recommendations
Average rating
152
Profile views
Summary

  • Over 6 years of diversified experience in Information Technology.
  • Over 4 Years of experience as a QA/BA Analyst in Client\Server, Web Applications using Manual testing Techniques and Automated testing tools with emphasis on Functional, System Integration, Regression and User Acceptance Testing.
  • 2 years of experience with SSRS, SQL, SQL server 2008/2012.
  • Involved in preparing detailed Business Requirements document in accordance to SDLC deliverables.
  • Conducted business requirement meetings with business unit teams to determine project goals and elicit requirements
  • Involved in requirements gathering and JAR/JAD Sessions and worked closely with business. Experienced with medical claim processing, payment system and General Ledger accounts.
  • Well versed with the 837 and 835 HIPAA transactions.
  • Excellent Experience and Strong knowledge of all the phases of SDLC (Software Development Life Cycle) such as Water Fall Model, V-Model, Agile Methodology.
  • Expertise in Test Case Design and Test Execution.
  • Expertise in Defect Management and Reporting using the test management tool HP ALM 14.2.
  • Proficient in project management tools like JIRA, HP ALM, TFS and MS Project.
  • Experience in writing SQL queries (SQL Server and Oracle) for basic database operations.
  • Experience in generating ad hoc and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
  • Extensive experience in developing Complex SQL queries with multiple complex joins, Group By, Having and Views etc.
  • Experienced in developing ETL using SSIS processes to implement complex business rules of data transformations.
  • Developed SSIS packages with various tasks like - File System, E-mail, Execute Package, Data Flow task, Execute SQL task.
  • Sourced data from various types of relational databases, flat files, excel files.
  • Experience in creating various types of reports like drill down, Parameterized, Cascading, Conditional Table, Matrix, Chart and Sub Reports using SQL Server Reporting Services (SSRS).
  • I'm motivated by working on challenging problems and tasks, interested in being an active member of a dynamic and resourceful team. I work well under pressure and tight schedules.
  • I'm detail oriented, accurate, efficient and able to work as a team player or independently.

Experience
Business Systems Analyst/ Quality Assurance Analyst
Banking/Financial
Nov 2016 - present
Jacksonville, FL

QA/BA, Test Case Preparation, HP ALM, Systems Analysis, Agile Methodology

Test Case Preparation System Analysis Agile Methodology Quality Assurance HP ALM BSA
Remove Skill
QA/BA Analyst
Healthcare
Jun 2014 - Jul 2016

Roles and Responsibilities:

  • Responsible for developing Test plans based on Functional specifications and Technical specifications.
  • Responsible for writing Test cases for Functional Testing, Regression Testing, System Testing, Integration Testing, and End-to-End testing.
  • Involved in preparing detailed Business Requirements document in accordance to SDLC deliverables.
  • Conducted business requirement meetings with business unit teams to determine project goals and elicit requirements
  • Researched and prepared user stories.
  • Conducted review sessions with developer to finalize the technical and system design.
  • Experience in preparing Requirements Traceability Matrix (RTM)
  • Worked on medical claim processing and payment system.
  • Validated the 837 and 835 HIPAA mandatory format.
  • Validate the General Ledger accounts for medical payments.
  • Involved in Positive testing, Negative testing manually.
  • Involved in testing of Web application, performed GUI, Functionality, Regression and Security Testing.
  • Developed and executed SQL Queries to perform database testing.
  • Responsible for maintaining test cases and test scripts for the application.
  • Used HP ALM for bug Tracking and for maintaining the test documents

Environment: HP ALM 14.2, SQL, PL/SQL, Java, JSP, J2EE, Oracle 9i, Windows 2003, UNIX, TOAD

SQL Test Case Preparation Test Planning Regression Testing Business Requirements Oracle SDLC PL/SQL Quality Assurance HP ALM HIPAA Functional Testing Integration Testing System Testing EDI Security Testing TOAD 837 Java
Remove Skill
SSRS Report Developer & Data Analyst
Information Technology
Feb 2011 - Jan 2013

Roles and Responsible

  • Partner with business stakeholder to gather, refine and document business information requirements and reporting specifications.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
  • Developed various operational Drill-through and Drill-down reports using SSRS
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
  • Used cascaded parameters to generate a report from two different Data Sets.
  • Developed and Optimized Stored Procedures, Views, and User-Defined Functions.
  • Support the daily business operations with data analysis and data inquiries as needed.
  • Partner with Business Intelligence and Data Warehouse teams to ensure information delivery is consistent and accurate across the organization.

Environment: SQL Server 2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, Windows 7/XP, XML, MS Excel, MS visual Studio

SQL XML Visual Studio Data Analysis Stored Procedure Data Warehousing SQL Server SSRS T-SQL Business Intelligence Statistical Analysis Microsoft Excel Windows
Remove Skill
QA Tester
Information Technology
Feb 2009 - Jan 2011

Roles and Responsible

  • Prepared and executed Test Cases according to the BRD, Technical Specification, Functional Design and Use Case documents, identifying applications functionality, test requirements and coverage.
  • Conducted Manual Testing on basic functionalities of the application
  • Prepared PL/SQL scripts to verify the database updates, inserts and deletes of the records
  • Recorded Test Cases, and generated QTP Scripts for automation of the testing process
  • Manipulated Test Script for Customized objects in the Application for verification of subsequent builds in the application
  • Worked in all phases testing like Integration, System, Front end Testing, Functionality and Regression Testing of the application.
  • Performed Functional and automated Regression Tests using QTP
  • Compiled Test Scripts and Generated Reports for identified errors in the application
  • Tested the application for specific Performance and End User Testing on its compatibility on various web browsers like Netscape navigator and Internet Explorer
  • Gathered the Test Input Data, which includes Pre-condition, Test Results and Test Regression Data
  • Provided data to the business analysts during UAT

Environment: QTP, Oracle, SQL/PLSQL, SQL Server, C, C++, Java, JSP, Servlets, JavaScript, Web Sphere5.0, IE, HTML, XML, Windows2000/XP.

SQL Automated Testing Test Case Preparation Regression Testing Manual Testing Quality Assurance HP QTP UAT
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Information Technology Management MBA
not provided
Record has not been verified.
Computer Application DCA
not provided
Record has not been verified.
Skills
SQL
2016
5
Quality Assurance
2021
4
Regression Testing
2016
4
Test Case Preparation
2021
4
837
2016
2
Business Requirements
2016
2
EDI
2016
2
Functional Testing
2016
2
HIPAA
2016
2
HP ALM
2021
2
Integration Testing
2016
2
Java
2016
2
Microsoft Excel
2013
2
Oracle
2016
2
PL/SQL
2016
2
SDLC
2016
2
Security Testing
2016
2
System Testing
2016
2
Test Planning
2016
2
TOAD
2016
2
UAT
2011
2
Windows
2013
2
Automated Testing
2011
1
Business Intelligence
2013
1
Data Analysis
2013
1
Data Warehousing
2013
1
HP QTP
2011
1
Manual Testing
2011
1
SQL Server
2013
1
SSRS
2013
1
Statistical Analysis
2013
1
Stored Procedure
2013
1
T-SQL
2013
1
Visual Studio
2013
1
XML
2013
1
Agile Methodology
2021
1
Analysis
0
1
BSA
2021
1
Business Analysis
0
1
JIRA
0
1
Requirements Gathering
0
1
SSIS
0
1
SSMS
0
1
System Analysis
2021
1
Systems Integration
0
1
Testing Tools
0
1