Testing Sql Server
Resume:
Tanu Parihar
***************@*****.***
Albany NY
503-***-****(C)
Summary
> Around 7+ years of experience in Quality and Testing -Web
applications and client Server application.
> Around 2+ year of experience in web development using Microsoft
technologies like (C#/VB.Net, ASP.Net 3.0/2.0, ADO.Net and VSTS
2005)
> Extensively worked in Healthcare industry (HIPAA), Insurance,
Banking (Enterprise and Capitol market) domain.
> Very Good Business knowledge of HIPAA 5010/4010, X12, EDI, XML.
> Expert in HIPAA Transaction, 837P/I/D. 270/271, 276/277 Transaction.
> Knowledge of Medicare Transaction likes Claim (837I, P, D), Claim
Status (276/277), Eligibility(270/271)
> Worked in various stages of SDLC and Testing Life Cycle, Manual and
Automation Testing Methodologies
> Design, Execute and Manage Smoke, Unit, GUI, Integration,
Functional, Performance, System, Regression and User Acceptance
testing process.
> Box testing and White Box Testing
> Performed Integration testing, Smoke testing,Sanity testing,
system testing End to End testing, Regression Testing, Re-testing,
user acceptance testing(Alpha In-house environment, Beta testing
In- customer environment)
> Track and report on defects, and verify resolution of defects in
UAT
> Analyzing high level design requirements and designing Test Plan,
Test Cases and other Testing artifacts.
> Translate Business and end user requirements into Use Case.
> Experienced in Formulating and creation of Test Script using
Keyword driven framework.
> Designing Scripting Standards and GUI Checklist.
> Logging bugs using Defect tracking tools like Silk Central "Test
Manager", Mercury Quality Center, Involved in Review meetings,
Design Walkthrough, Coverage Analysis, Traceability Matrix and
generating Defect Analysis Status Report.
> PL/SQL, Oracle Query for creating a test data and executing
database testing.
> Creation of Business Requirement, Process Flow, Functional Rules
and Use Case Document.
> Building and deploying Java, ASP.Net application.
> Agile and waterfall model.
> Excellent Interpersonal, Written and Oral communication skills,
Fast Learner and Self Motivated.
Major Projects
CSC (Dept of Health, NY), Albany NY
March 2011 - Till
Date
QA Tester
I : eMedNY (Dept of Health NY)
Description: eMedNY System allows Medicaid providers to Submit HIPAA-
compliant Claims (Professional, Institutional, and Dental) 837,
Eligibility (270/271), Claim Inquiry(276/277), Prior
Authorization(278) transactions. The eMedNY is an incentive for paper
submitters to switch to an electric format. Providers can utilize
ePACES to view the status of claims submitted regardless of the
submission method. This means that providers can check on the status
of claims (and the associated payment amount) for claims submitted via
ePACES or any other method (electronic or paper). A great advantage of
ePACES is the speedy availability of claim status. For claims
submitted via ePACES (batch method). ePACES Provide Immediately Claim
Status for Professional providers (Physicians, Nurses, Nurse
practitioners and DME, etc.) claims can be submitted in "real-time".
Real time means that the status of the claim and any associated
payment amount will be available to the provider within seconds.
Responsibility:
> Responsible for developing System Test Plans and Test Cases based
on the user requirements and design documents.
> Extensively involved in Testing HIPAA based (837 I, 837 D, 837 P),
270/271 transaction of claims.
> Tested Medicare Claim Status Request Response (276/277)
Transaction.
> Exposure of Medicare Eligibility Request Response (270/271)
Transaction.
> Hands on Different X12 transaction and HIPAA Standards.
> Analyze and design system HIPAA Compliance with 5010/4010 and part
of HIPAA 5010 upgrade.
> Participated in the walkthroughs with the Business Analyst and
development team to understand the requirements and to formulate
test plans. Involved in System testing, Black Box testing and White
Box Testing
> Involved in data mining in mainframe system to research specific
provider and member data for creating test data setup. Altered the
provider tables and member tables in mainframe before the claim
adjudication to get required results.
> Performed results validation by comparing the adjudicated results
with the data in the mainframe. Created paper claims, XML
(Electronic) claims, and direct data entry claims for testing
purposes. Responsible for generating reports for batch processes in
mainframe.
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Involved in user acceptance testing with users along with providing
training to end-users.
> Prepare MOM (minutes of meeting) and Review Reports for Weekly
Status Call
> Participated in walkthrough with client and the development team,
attended Defect reporting meetings periodically.
> Invesitaged software bugs and interacted with developers to resolve
techincal issues.
> Work extensively on Manual Testing.
Environment: Java, ASP.Net, Mainframe,Cobol, DB2,Oracle, Sql Server,
X12, HIPAA, XQMF, PL/SQL, windows NT/2000/XP, Sharepoint Server 2007,
MS Power point presentation.
II: NCMMIS (Dept of Health, NC)
Description: NCTracks is a multi-payer system that will facilitate
provider enrollment and consolidate claims processing activities
for multiple DHHS health plans. Providers enrolled in DMA, DPH, and
ORHCC health plans will submit claims for covered health care services
to NCTracks. Providers who are contracted by Local Management Entities
(LME's) to perform state funded MH/DD/SAS services will continue to
submit their claims to the LME. NCTracks will coordinate processing
among the payers to ensure the proper assignment of the payer, benefit
plan, and pricing methodology for each service on a claim.
Responsibility:
> Extensively involved in web based application testing
> Responsible for developing system test plans and test cases based
on the user requirements and design documents.
> Participated in the walkthroughs with the Business Analyst and
development team to understand the requirements and to formulate
test plans. Involved in System testing, Black Box testing and White
Box Testing
> Wrote SQL queries to for Data Mining and Data manipulation.
> Formulate and Create Test Scenarios and Test Scripts in SilkCentral
"Test Manager".
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Involved in user acceptance testing with users along with providing
training to end-users.
> Prepare MOM (minutes of meeting) and Review Reports for Weekly
Status Call
> Participated in walkthrough with client and the development team,
attended Defect reporting meetings periodically.
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Work extensively on Manual Testing.
Environment: Java, JSF, Web Service, Oracle 10g, PL/SQL, windows
NT/2000/XP,Sharepoint Server 2007, MS Power point presentation.
III: MEIPASS (Dept of Health, NY)
Description: The Medicaid EHR Incentive Program (MEIPASS), eligible
hospitals and health care practitioners in New York who adopt,
implement, or upgrade certified EHR technology, and subsequently
become meaningful users of the EHR technology, can qualify for
financial incentives. CMS provides details on both the Medicare and
Medicaid EHR Incentive Programs so providers can determine whether
they are eligible for the programs and choose between the two
incentive programs. Once eligibility is determined and the desired
program is selected, eligible providers apply(pronounced "My Pass"),
is the system that will accept providers' registration and
attestation. Once eligibility is determined and the desired program is
selected, eligible providers applying to the New York Medicaid EHR
Incentive Program will need to register and attest with the State. The
Medicaid EHR Incentive Payment Administrative Support Service, also
known as "MEIPASS" (pronounced "My Pass"), is the system that will
accept providers' registration and attestation.
Responsibility:
> Responsible for developing system test plans and test cases based
on the user requirements and design documents.
> Participated in the walkthroughs with the Business Analyst and
development team to understand the requirements and to formulate
test plans. Involved in System testing, Black Box testing and White
Box Testing
> Regression testing for redesign the application
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Involved in user acceptance testing with users along with providing
training to end-users.
> Prepare MOM (minutes of meeting) and Review Reports for Weekly
Status Call
> Participated in walkthrough with client and the development team,
attended Defect reporting meetings periodically.
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Work extensively on Manual Testing.
Environment: Java, JSF, Web Service, Oracle 10g, PL/SQL, windows
NT/2000/XP, MS Power point presentation.
Client: Blue Cross Blue Shield of MI, Detroit MI
Feb 2010 - Feb
2011
QA Tester
Description: BCBS of MI offer an array of choices designed to meet
the diverse and ever-changing needs of Michigan employers as well as
individuals purchasing health care coverage. BCBS health plan choices
include HMO plans, broad network PPO plans and Supplementary health
coverage for Medicare recipients and traditional indemnity products.
Through BCBS family of subsidiaries, BCBS also offer prescription drug
coverage, dental plans, life insurance, long-term care, workers
compensation, Away From Home Care and many other products.
Responsibility:
> Responsible for developing system test plans and test cases based
on the user requirements and design documents.
> Extensively involved in Testing HIPAA based (837 I, 837 D, 837 P)
transaction of claims
> Tested Medicare Claim Status Request Response (276/277)
Transaction.
> Exposure of Medicare Eligibility Request Response (270/271)
Transaction.
> Participated in the walkthroughs with the Business Analyst and
development team to understand the requirements and to formulate
test plans. Involved in System testing, Black Box testing and White
Box Testing
> Involved in data mining in mainframe system to research specific
provider and member data for creating test data setup. Altered the
provider tables and member tables in mainframe before the claim
adjudication to get required results.
> Performed results validation by comparing the adjudicated results
with the data in the mainframe. Created paper claims, XML
(Electronic) claims, and direct data entry claims for testing
purposes. Responsible for generating reports for batch processes in
mainframe.
> Wrote SQL queries to for Data Mining and Data manipulation in MHS.
Used HP Quality Center for reporting and tracking defects.
> Formulate and Create Test Scenarios and Test Scripts in Quality
Center.
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Involved in user acceptance testing with users along with providing
training to end-users.
> Prepare MOM (minutes of meeting) and Review Reports for Weekly
Status Call
> Participated in walkthrough with client and the development team,
attended Defect reporting meetings periodically.
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Work extensively on Manual Testing.
Environment: Oracle 10g/9i, PL/SQL, Toad (PL/SQL tool), SQL
Navigator, MS Office Suite, Test Director, Load Runner, windows
NT/2000/XP, MS Power point presentation.
Client: Bank of North Carolina Raleigh, NC
Jan 2009 - Jan
2010
QA Tester
Description: Bank of North Carolina is one of the largest banking and
financial services organization. The application provided access to
online accounts for customers. One of the feature of the application
was it enable 24-hour access to the credit information; the
application as developed using Java, JavaScript and JSP on the server
side and Oracle as the database running on UNIX; Conducted end-to-end
testing on the entire system.
Responsibility:
> Responsible for developing system test plans and test cases based
on the user requirements and design documents.
> Create and formulate Test Cases/Scenarios based on Business
Requirement
> Formulate and Create Test Scenarios and Test Scripts in Quality
Center.
> Developed and executed test suites and operation scenarios to
detect, report and track defects using Test Director. Performed
Functionality and GUI Testing. Performed Security Testing using
Data Driven Testing methodology.
> Participated in the walkthroughs with the Business Analyst and
development team to understand the requirements and to formulate
test plans. Involved in System testing, Black Box testing and White
Box Testing
> Involved in set up of testing methodologies and also maintaining of
QA process model. Created and maintained test Environments for
efficient and faster testing.
> Performed Data Driven Testing to test application with different
sets of data from the test database
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Investigated software bugs and interacted with developers to
resolve technical issues.
> Involved in user acceptance testing with users along with providing
training to end-users.
> Prepare MOM (minutes of meeting) and Review Reports for Weekly
Status Call.
> Regression tests were done after the bugs fixed.
> Participated in walkthrough with client and the development team,
attended Defect reporting meetings periodically.
Environment: PeopleSoft, Java, JDBC, J2EE, MS Office Suite,
Oracle9i, SQL, P/L SQL Test Director, Load Runner, Oracle Web Server,
windows NT/2000/XP.
Client: Saber Co operation, Salem OR
Dec 2007 - Dec
2008
QA Tester
Description: The Hospital Management system involved the
computerization of hospital/clinic. It provided whole functionality
for the different departments. Its main module includes Patient
registration/Treatment, Billing, Inventory, HR management, Finance,
User Management etc. It is designed in three-tier environment, User
tier- User's screen, reports, Business Tier -COM components
encapsulating business rules and data tier-Interaction with data
source.
Responsibility:
> Create and formulate Test Cases/Scenarios based on Business
Requirement
> Formulate and Create Test Scenarios and Test Scripts in Quality
Center
> Prepare MOM and Review Reports for Weekly Status Call
> Work extensively on Script Creation using QALoad 5.6
> Perform Script execution and Analyze Results
> Communicating clear and accurate reports detailing on Performance
test results
> Create and Execute SOAP UI Scripts
> Executing UNIX commands
Environment: Java, JDBC, Servlets, J2EE, MS Office Suite, Oracle9i,
SQL, P/L SQL Test Director, Load Runner, Oracle Web Server, windows
NT/2000/XP.
Client: Institute ERP St. Mary School
Dec 2006 -
Nov 2007
Developer/QA Tester
Description: System take care's student's Academic Record their
Performance and Other activities of school like (sports, studies,
extra circular activity, and hostel transport. Medical Facility), Time
Table, Administration. It also takes care of HR, Payroll, Finance,
Time Table for Teachers and other employee's inside the institute.
Responsibility:
> Worked on the Analysis, Design and development of application.
> Developed presentation layer using various server-controls, HTML
controls and user controls.
> Developed some of the UI modules using HTML, JavaScript and CSS.
> Used ADO.NET for retrieving data from backend database SQL Server
2000. Used Data Adapters, Datasets and Command & Connection Objects
of ADO.NET to manipulate Data in the SQL Server Database
> Used SQL to store the data from the presentational layer into the
data base layer.
> Data grid used extensively to display various SQL Server elements.
Environment: VB.NET, Oracle, Rational Test Manager, Rational Clear
Quest, SQL Server 2005, VSS, UNIX.
Client: Majestic Software Limited, Noida, Inida
Nov 2004- Dec 2005
QA Tester
Description: Employee Record Management (ERM) is a Client/Server
Application which provides various benefits to the employees of the
organization such as Online Payroll, Tax Calculation, Intranet
timesheet, Pay link etc. As a Manual Tester, was involved in all the
modules in the application.
Responsibility:
> Analyzed system specifications and reviewed the Test Plans and Test
Strategies.
> Created several Test cases that cover the entire Functionality of
AUT (Application under Testing) using Test Director.
> Manually performed functional testing that included Security,
Systems Testing.
> Performed extensive black-box testing of the application.
> Used SQL queries to perform Data integrity testing.
> Performed end-to-end testing of application and also verified
compliance for software quality standards of the organization.
> Tracked Bugs and Reported them using Defect tracking and
Maintenance Tool Test Director.
> Environment: Test Director 6.0, Visual Basic 6.0, SQL.
Environment: Test Director 6.0, Visual Basic 6.0, SQL.
Client: Airtel Communication, Kota
Feb 2003 -
Sep 2003
Developer
Description: Airtel is one of the largest wireless voices and data
service providers. Online Inventory Management system was developed to
give access to the local users to manage their office inventory. User
needs to login in the web application to get access of online
inventory system. After Successful login user allows to view
inventory, enter new item and update existing inventory of their local
office.
Responsibilities
> Developed presentation layer using various server-controls, HTML
controls and user controls.
> Developed some of the UI modules using HTML, JavaScript and CSS.
> Used ADO.NET for retrieving data from backend database SQL Server
2000. Used Data Adapters, Datasets and Command & Connection Objects
of ADO.NET to manipulate Data in the SQL Server Database.
> Used Stored Procedures to store the data from the presentational
layer into the data base layer.
Environment: VB.NET, Oracle, Rational Test Manager, Rational Clear
Quest, VSS, UNIX.
Education :
. MBA in Information Technology
. 2 year Computer Course/Training in Microsoft technologies
in 2002
(Tanu Parihar)
Contact this candidate