Qa /data Analyst /lead Resume
Park Ridge, NJ
SUMMARY
- Over 8+years of experience in Information Technology with emphasis on Software Testing/Quality Assurance/Business Analyst/Tools Administration.
- Experience in leading the teams of QA engineers, Analysts, Business Analysts, Testing and Development teams to setup QA environment and to perform successful testing.
- Experience in testing Standalone, Client Server, Mainframe and Web based applications using Automation tools and Manual testing techniques with White Box and Unit testing experience using unit testing tools.
- Administration and Configuration experience in setting up and configuration of Test Management and Change Request tracking tools like HP Quality Center, Rational Clear Quest and QTP.
- Experience in setting and configuring QA Environments for different business domains such as Healthcare, Finance, Banking, HR, Ecommerce, Travel, Retail and Advertising.
- Extensively involved in various phases of Software Development Life Cycle (SDLC) with experience in managing testing lifecycle process using Waterfall, Agile, MSF, V - Model, RUP and RAD Models.
- Experience in creating Test Plans and designing test cases covering all test conditions and eliminating redundancies.
- Experience in configuring QA Process in Test Director/Quality Center/Rational Test Manager/Rational Administrator with Project/Site administration knowledge for test requirements writing, requirements tracking, defect tracking, Test results, Defect status reporting and batch testing with customized VB scripting and work flow scripts.
- Good knowledge of writing SQL queries in Oracle, SQL-Server, Teradata, MS-Access, DB2 and Firebird database systems and experience conducting backend database testing using Toad, Sql Assist, Studio Express and Sql developer.
- Experience in conducting different types of testing including White Box Testing, Black Box Testing, GUI Testing, Data Driven Testing, Back End Testing, Integration, Regression, Sanity, Functional and System testing, Load Testing, Stress Testing, Performance Testing.
- Extensive Knowledge in testing applications using HIPAA Standards, ICD 9 and ICD 10 DX codes.
- Experience in applications testing and WSDL Testing through XML using SOAPUI Tool.
- Excellent working knowledge of major Operating Systems and tested applications on Windows 7/98/NT/2000/XP, Linux, UNIX and mainframe environments.
- Ability to handle multiple tasks and work independently as well as in a team.
- Excellent team leading capabilities with excellent written, verbal communication and interpersonal skills.
TECHNICAL SKILLS
Testing tools: HP QTP, Quality Center, Test Director, Mercury QTP 10, Win Runner, VSTS, Rational.
Bug Reporting Tools: Test Director, HP Quality Center, PVCS, Jira, Clear Case, Clear Quest, and Rational Pro
Testing Types: User Acceptance Testing (UAT),Batch Testing, Performance Testing, GUI Testing, Functional Testing, System Integration Testing, Regression Testing, Keyword driven Testing and White Box testing, Black Box texting.
Testing Languages: VBScript, QTP, TSL & SQA Basic
Applications: MS Office, MS Access, Photoshop, MS Visio, Excalibur
Application/Web Servers: Web Logic 10, Web sphere, Soap UI, SOA test, Service test, Apache 2.0, Message Broker, Tomcat
Languages: J2EE, JSP,.Net,TFS,Servlets,C,C++,COBOL, SQL, PL/SQL, Shell Scripting, HTML, Slash commands, XML, PHP, JavaScript, VB Script, &Visual Basic 6.0.
RDBMS: Oracle 10g/9i/8i/7.3, MS SQL Server, MYSQL, PL/SQL, MS Access,, Teradata, Sybase, DB2
Operating Systems: Windows 95/98/2000/7/XP/NT, UNIX, LINUX, AS-400Mainframe
Tools: Visio, Tibco, MS Project, MS-Word, MS Excel, MS-PowerPoint, Toad.
Miscellaneous: ECmap,Webbbs,837,835,270/271,276/277
PROFESSIONAL EXPERIENCE
Confidential, Park Ridge, NJ
QA /Data Analyst /Lead
Responsibilities:
- Interact with internal team to identify core business, business flow and identify major & minor functionalities
- Participated in peer review meetings for creation of Test Scenarios and Test Cases.
- Create standard testing life cycle flow diagram and presented to Test Team.
- Developed and maintained traceability matrix between requirements, Test Cases and defects to cover functionality testing using Quality Center.
- Responsible for performing Post Deployment validation at the time of release / implementation.
- Hot fix testing for urgent production issues.
- Carried out enhancement of test cases and test scripts for functionalities added as per the new business requirements.
- Extensively used UNIX to validate process oriented testing like variable length data file validation.
- Performed Sanity testing for each new build of the application
- Involved in Regression testing of the builds and patches in staging and production environment.
- Coordinated meetings with the Development teams to ensure appropriate handling of the bugs and their timely resolution.
- Participated in bug review meetings on behalf of the QA team and providing signoff for the builds in Qual and Production.
- Mapped the custom objects to the standard objects where necessary, inserted GUI, Bitmap and Text checkpoints where needed, to compare the current behavior of the application being tested to its behavior in the earlier version using Quick Test Pro (QTP).
- Recorded regression test scripts using QTP for web based application and checked the functionality of the application.
- Developed automated Test scripts in QTP using VB Script for regression testing.
- Worked on Agile Environment with daily scrum meetings, stand up meetings, burn-down charts presentations and reviews.
- Wrote SQL for Data Validation on different Database down the Development, QUAL, Staging and Production environment using teradata DB.
- Involved in Database testing and database comparison by executing SQL queries and stored procedures to validate that data is being populated in an appropriate tables and manually comparing the results with front-end values.
- Worked on End to End scenarios while integrating from legacy systems.
Environment: Jira, IBM Mainframes, Quality Center, DB2, Web sphere Message broker, MS Office, Linux, UNIX, Windows 7, Tivoli, Teradata, Lotus Notes, QTP, Outlook, Winscp, Putty, Text pad, Sql Assist, Java, JDBC, Java Script, HTML, SOAP UI, XML, Apache Tomcat.
Confidential, Park Ridge, NJ
QA Analyst /Lead
Responsibilities:
- Involved in analyzing system design specifications and accordingly develop Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing for different Projects.
- Standard software testing life cycle (STLC) to perform different types of testing like System, Unit, Integration, Smoke, GUI, Sanity, Functional, Batch Processing, Browser Compatibility, End to End, Database, Regression and Retesting.
- Involved in testing Admin - Access Control Portal (Different roles and Groups) and Employee CDP Portal and Loyalty ware Portal on the CRM Dashboard Application for HRAC, Dollar and Thrifty Profiles.
- Involved in testing PC EXCALIBUR Integration by making a reservation on the DASHBOARD by passing Various Slash commands via Web sphere MQ Message to Excalibur Sever for all Profile brands.
- Involved in Verification and Validation of the Ecommerce ( Confidential .com) end user application after adding or updating or enrolling a customer from CRM MDR Repository.
- Worked with Mainframe (Integrated) Application to ensure various data flows synched properly from the Front End UI DASHBOARD Online J2EE Application, Service Layer and Batch Processing parallel to the Final Back End Downstream Destination System Mainframe System and TERADATA REPOSITORY.
- Involved in creation of handcrafted Software Test Beds, replication of problems and generation of bug report using Bug reporting tool Jira.
- Worked in Agile Scrum project implementation performing test coordination and task management.
- Involved in coordinating testing effort, responsible for test deliverables, status reporting to management, issue escalations.
- Involving in testing and validating different web services operations built in SOA Architecture using SOAP UI tool.
- Optimized QTP Scripts for regression testing of the application with various data sources and data types.
- Parameterized the fixed values in checkpoint statements, created data tables for the parameters and wrote functions for the parameters to read new data from the table upon each iteration - Performed Data-driven testing using QTP.
- Performed Negative Testing and Position testing to test various input file formats using XML and web services to test the SOA (Service oriented architecture) integration.
- Involved in staging and testing the application in single mode testing and parallel mode testing.
- Involved in testing and validating different charge cards (Credit cards) like Visa - MC, AMX, Confidential credit Card etc using different batch jobs.
- Involved in testing Performance of the different batch jobs by processing the larger files with different throttles and transactions and calculates the TPS.
- Used Winscp or Linux commands to transfer files (FTP) from remote Linux to windows local and vice versa for different CMDR and DTG Batch jobs.
- Involved in creating test files from the test data and ran the test files against the different data mover / copier / extract / create and data update Batch jobs for both CMDR and DTG applications.
- Trained and Mentored Quality Assurance Analysts by providing directions for assigned testing tasks.
- Proactively came up with innovative methods to improve software quality, test coverage and regression.
- Reviewed the Team work and periodically reported to QA manager regarding work status.
- Tested source to target data mappings using SQL commands in Teradata.
- Worked on multi platform environments like Windows, UNIX with clear understanding of file system, environment variables and file transfer protocol (FTP).
- Expertise in writing SQA plans, Systems Test plans, Traceability Matrix, defining test scenarios and test cases based on business and functional requirements .Documented all phases of QA Process using Quality Center.
- Involved in creating handcrafted test data files in the form of flat files and text files using excel, text pad and Win pad based on the Requirements File Layout and executing the files by converting the txt files to binary executable Files.
- Performed complex functional, data validation on staging of data for Complex Events of the system API on the Log file and Data base Testing with Teradata database.
- Involved in executing the Linux scripts in Putty and then after executing the scripts verify the output reports, error logs, System level logs to verify the results.
Environment: Jira, IBM Mainframes, Quality Center, DB2, Web sphere Message broker, MS Office, Linux, UNIX, Windows 7, Tivoli, Teradata, Winscp, Putty, QTP, Lotus Notes, Outlook, Text pad, Sql Assist, Java, JDBC, Java Script, HTML, SOAP UI, XML, Apache Tomcat.
Confidential, Burlington, NC
QA Analyst
Responsibilities:
- Worked Closely with BA team, SME’s and Development team to pull data requirements and related documentation.
- Analyzed the PRD and SRS documents, Use Cases provided by analysts and designed test cases.
- Involved in identify/modify all LCBS functions and functionality that will require modification to accommodate the future ICD 10 version of diagnosis codes
- Developed Test Plans, Test Scenarios, Test Strategy, RTM Document and test data according to the specifications.
- Involved in System testing, Batch testing, Regression, Re-testing and User Acceptance Testing manually.
- Involved in testing different online billable and unbillable modules of the Mainframes application.
- Validating data for UAT testing via QMF.
- Tested different online screens of the web based application.
- Performed GUI, Integration, Data Validation and Regression testing.
- Using Quality center created and maintained the test plans and test cases based on project inputs and made use of the folder structure of the test plan as a guide to all testing work, managing all aspects of testing.
- Actively participated in enhancements meetings focused at making the application more reliable
- Involved in validating and gathering the data from the daily batch reports from the mainframe TSO application.
- Involved in executing UAT batch test plans by requesting related jobs to run and validating the output for 4010 and 5010 Payers.
- Once the testing on each of the test plans are completed sent test results to business users for review and approval.
- Involved in testing different paper claims by using PDF web services.
- Set up test environment and create test data for both positive and negative test cases.
- Perform Regression testing after retesting the defects to make sure the fixes do not have any negative impact on the application.
- Monitor the test results and capture the screen shots and include in the test results.
- Logged tickets in IDM an internal bug tracking tool.
Environment: Quality Center, IBM Mainframes CICS, DB2, TSO, MS Visio, MS Access, QMF, My Style, Turn Style, MS Office, IDM, Oracle, UNIX, Windows, TOAD,Java,J2ee,Java Script, Web Services.
Confidential, Columbus, OH
QA Analyst
Responsibilities:
- Analyzed user requirements, functional specs and Use Case documents to create the Test Plan.
- Performed Black Box Manual Testing using Agile (Scrum) methodology.
- Performed Functional, System Integration, Regression, Re-testing, Compatibility User Acceptance Testing (UAT or End to End testing) Cross Browser and GUI testing manually.
- Wrote user defined functions in VB in expert view of QTP and stored them in central libraries as part of Regression automation.
- Test automation with QTP to quickly run regression tests to verify bug fixes.
- Worked on object spy, Shared object repository, Checkpoints, Output values, different types of recording modes and synchronization in QTP
- Used Quality Center to store all testing results, metrics, implemented test plan document.
- Developed Test cases and uploaded to Quality Center under Requirements for RTM.
- Defects are tracked and reported using Quality Center.
- Analyzed the functionality and wrote test cases for both functional and regression testing and editing the automated script by inserting logical commands to handle complicated test scenarios.
- Used SQL Server and developed SQL Queries to perform back end database testing.
- Reported tracked defects with reference to severity and types.
- Worked on Bulk Provider Customers live transactions on back end testing.
- Used SQL Navigator to perform Back end testing.
- Worked with off shore & on site team members assigned daily work and got updates on daily basis.
- Reported directly to project manager on weekly basis and provided updates on going weekly team meetings.
Environment: Quality Center, QTP, MS Project, MS Suite Pro, SQL Navigator, SQL Server, UNIX, Windows, TOAD, IBM Lotus Notes.
Confidential, Iowa, IA
QA Analyst
Responsibilities:
- Involved in writing the positive and negative test cases and executed manually.
- Analyze client Requirement and Specification & based on that create test files
- Attended the meetings to fix the bugs and to know the functionality and flow the application
- Performed Functional testing manually as per the test case and evaluated the test results
- Involved in CAT (Customer acceptance testing) Testing of the whole application.
- Files are exchanged via the sFTp site.
- Performed Data Validation of the data flow from the front-end to the back-end
- QTP is used to write, maintain and execute automated test scripts.
- Toad is used to view the data in the databases.
- Executed SQL queries to verify the data in the Oracle database.
- HPQC is used to write, store and maintain testing requirements, execute test cases, maintain defects( IR’s)
- Retrieved data from Oracle environment using SQL statements
- Prepared Test Summary Reports for every release using the Quality Center tool
- Identified Software problems, wrote easy-to-follow bug reports, logged them into bug tracking database, monitored their progress and verified their fix.
- Involved in different types of testing like system testing, functional testing, load testing, database testing, UAT testing, retesting, regression testing.
- Review and Analyze error logs document and implement a solution.
- Involved in the system testing on the entire scoring system for proper data generation and conversion and debugging end to end flows.
- Involved in production related issues and provided full documentation to the entire scoring system.
Environment: VB Script, C, C++, Ultra EDIT, Quality Center 9.2, sFTP, Oracle 10g, Windows XP, UNIX, LINUX, File Zilla, Putty, Toad 9.7.2
Confidential, Columbus, OH
QC Analyst
Responsibilities:
- Running production files & compare the results maps for transactions 837, 835, 270/271, 276/277 using X12 standards
- Involved in writing the positive and negative test cases and executed manually.
- Attended the meetings to fix the bugs and to know the functionality and flow the application
- Performed Functionality testing manually as per the test case and evaluated the test results
- Involved in defect tracking, defect reporting, analyzing results and documenting using the Test Director
- Involved in UAT Testing of the whole application.
- Testing both inbound & outbound and XML files & prepare analysis document with various results.
- Analyze client Requirement and Specification & based on that create test files.
- Running the files in Test & Production environment & compare the results.
- Involving the EDI environment including operations support, trading partner setups, and installations as well as handling any issues or concerns from trading partners.
- Other maps written were maps to translate customer data to custom reports for users to read, maps to translate customer flat file data to other custom flat file formats.
- Analyze inbound X12 HIPAA files and execute Trading partner testing and integration.
- Design database structures for custom processes.
- Experience withHIPAAAct Rules and regulations &HIPAA transactions
- Worked on various EDI X12 transaction sets 837 (I P), 270/271,276/277,835 etc.
- Review and Analyze error logs document and implement a solution.
- Involved system testing on all EDI transactions for both inbound and outbound translations for proper data generation and conversion and debugging end to end flows.
- Testing & documenting Any2Any maps proprietary for different file types.
- Involved on production related issues and provided full documentation to all EDI maps.
Environment: ECMap, Ultra EDIT, Test Director, Beyond Compare, FTP, XML, XSD, XSL, ANSI X12, Oracle 9i, Windows 2000, Microsoft Visual SourceSafe 6.0, UNIX
Confidential
QA/Test Engineer
Responsibilities:
- Creates and maintains the QC Plan & Test Strategy document.
- Leading the team and handling daily meetings.
- Involved in project planning, coordination and implementation of QA methodology.
- Involved in writing and implementation of the Test plans and various test cases.
- Participate in various meetings and discussed Enhancement and Modification Request issues.
- Interact with business analyst, system staff and developers.
- Involved in preparation for Test Plan for System Testing.
- Reviewing test cases prepared by the team for regression testing.
- Creating test cases against the new RFP (Request for Proposal).
- Preparing Test Plan, Test Strategy & Scope.
- Designing, Review and Execution of Test Scenarios and Test Cases.
- Logging Issues in JIRA
- Functional & System testing of the application.
- Preparing Testing status Reports and Testing Results.
- Examining the severity and priority of the Defects and Test Results Reporting.
- Performing Functional, System, Integration, Upgrade, Portability and Regression Testing under Mozilla, IE6, IE7
- Performed back-end testing using SQL queries to make sure that data entered has been uploaded correctly into Oracle Database.
- Involved in administration (installation, configuration, debugging, support and engineering) of MQ Series in multiple environments (Windows, UNIX, etc.).
Environment: C#, ASP.NET, JAVASCRIPT, AJAX, CRM (Sales Force), SQL Server 2000.