Senior Quality Assurance Analyst Resume
Atlanta, GA
SUMMARY:
- Big Data Testing
- Strong in SQL
- Over 10 years of experience in the areas of Software Testing, Requirement Analysis and all phases of the Software Development Life Cycle (SDLC) process
- Relational Database Management System (RDBMS), in writing SQL queries
- Write reports using ECL Queries, SALT, Sublime
- Writing test plans, defining test cases, developing and maintaining test scripts and Documenting all phases of QA process
- Worked in Rally and Agile environment
- JIRA, QC ALM 11, UFT
- Telecom Billing Operation
TECHNICAL SKILLS:
OCP(Oracle Certified professional) 10g Unix SQL, PL/SQL
Oracle Enterprise Manager Oracle Report Developer 2000
ECL IDE, Advanced Thor Accurant System Analysis and Design
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Senior Quality Assurance Analyst
- Develop update and maintain test plan such as smoke, functional and regression test.
- Identify, research and document bugs, finding the root causes of bubs.
- Develop and maintain test data using SQL quarries.
- Meeting/Chat with Developer and/or Product owner regarding any issues specially Defects
- Processing data using SQL
Using: SQL*Plus, Unix, Excel, QTP, QC,XML
Confidential, Alpharetta, GA
Senior QA
- Testing Big Data using ECL
- Work on Public record and Insurance Data Verification
- Write report using ECL Queries, SALT, Sublime and SQL
- Write SQL queries
- Automate File validation process using ECL Queries.
- Analyze Data From Landing Zone to Production Environment
- Track/Create Bugs using JIRA
- Work with HPCC Big Data key build data verification including FCRA and Non FCRA data and Boolean Data in Public sector and Insurance
- Check log files to and other related report to make sure of data quality
- Application Lifecycle Management/Quality Center 11 and HP Unifies Functional Testing
- Verify 100% data from Landing Zone to Client end to make sure of 100% accuracy
- Worked well within ridged timelines to accomplish data progression.
Using: ECL IDE, Orbit, Orbiti, Dops, iDops, Jira, ALM QC, HP United Functional Testing (UFT), ADV Report, Thor, Ecl Watch, Accurint
Confidential
Senior QA
- Write user stories(Test Plan) from Comps and/or Business analysis report
- Write Test Cases and execute
- Write validation test Document
- Write SQL queries.
- Run Regression, system, Sub - System Test, Sanity Test, UAT
- Raise Defects, keep track/Status of defects
- Attend daily status calls to discuss about progress, and/or plan for the day
- Discuss about work flow with PO, Manager, Developer
- Check point calls to discuss with client current status of testing
- Meeting/Chat with Developer and/or Product owner regarding any issues specially Defects
- This is fully Manual Testing
Using: Rally, SQL, PIWIK, Agile
Confidential, Alpharetta, GA
Senior QA
- Work with HPCC Big Data key build data verification including FCRA and Non FCRA data
- Utilize Enterprise Control Language (ECL)
- Write SQL Queries
- Application Lifecycle Management/Quality Center 11
- Quick Test Professional v11
- Verify 100% data from Landing Zone to Client end to make sure of 100% accuracy
- Make sure data verified 100% and released in time
- Worked well within ridged timelines to accomplish data progression.
Using: QTP, QC ECL 4.0, Orbiti, Production Thor, Dev Thor, iDops, mySql Soap UI, XML etc
Confidential
Senior QA
- Test mobile devices through network elements
- Create new subscribers on HLR
- Write SQL queries to get data
- Provision from Switch Control to other Network device
- Mobile subscriber provisioning with HLR and HSS
- Check subscriber detail through Switch Control and Database
- Create file for CCR DB team
- Create file for Mediation team and send it to Mediation team
- Process files and sent the file to Enabler team
- User provisioning using HLR
- Burn usage and create file for Mediation and check notifications
- Write Test Plans and Test Cases using XL and transfer it to QC
- Rise defects in QC and Follow up about defects
- Run Queries to edit/update data using SQL*Plus
- Work on CALEA (Commission on Accreditation for Law Enforcement Agencies)
- Provision SIM on different RANs
- Perform Data Throttling Test on different Network
Using: SQL*Plus, Unix, Excel, .Net, Telegence, Different RAN, QTP, QC,HLR. HSS
Confidential
Senior QA (Billing)
- Check data to confirm no records are missing.
- Take data backup.
- Write SQL queries to pull customer data
- Perform negative test
- Ensure data was flowing the right way
- Write test plans per business requirements and test cases and execute
- Raise defects
- Ratifications and rating administration
- Traffic Analysis and Call Matching for resolution of any dispute issue
- Cross check payments in billing system
- Provisioning and cross checking new carrier for both incoming, outgoing
Using: Oracle 10g, CBoss, Toad,.Net, SQL*Plus, PL/SQL, Quality Center, Excel
Confidential
Senior QA
- Design and develop Test Plan, Test Cases using XL
- Test the application for both positive and negative scenarios
- Interact with developers and business analysts to assess functional requirements
- Log, track, and verify defects, documenting all phases of QA process using HP Quality Center
- Perform Functional, Regression, Data driven testing using Quick Test Pro
- Applications to provide technical assistance in identifying, evaluating, and resolving basic test problems
- Perform Manual testing for the Functionality, GUI of the Web applications
- Work with Business to establish and maintain a consistent test methodology
- Design and develop SQL queries to perform back-end testing
- Work with cross functional team, and participate formal/ informal meetings
Using: UNIX, Oracle 10g,.Net, Quality Center, Quick Test Pro (QTP), SQL*Plus,PL/SQL, MS Excel, WinRunner, Rational Clear Quest
Confidential, Atlanta, GA
Senior QA
- Create, execute and maintain Test Scripts for Integration, Functional and Regression test cases
- Monitor the system to validate that the data performing well
- Track defects and create customized reports on defects using Quality Center & Clear Quest
- Design and develop SQL queries to perform back-end testing
- Design and develop Test Plan, Test Cases
Using: UNIX, Oracle, Quality Center, Quick Test Pro (QTP), Toad, MS Excel, Clear Quest