SUMMARY

• IT professional with 5+ years of experience as a Software Quality Analyst with experience in Healthcare, Banking and Retail domain.
• 5+ years’ experience in JIRA and other related tools.
• Experience in understanding the business & technology of the client system AND providing them with quality deliverables.
• Extensive experience in analyzing system requirements and technical specifications to create and execute test plan and test cases.
• Experience in SDLC, Agile and Waterfall methodologies.
• Worked with other members of the team and stakeholders in an effort to improve the processes, methods, effectiveness and efficiency.
• Expertise in QA project scoping, estimation, tracking and reporting skills.
• Experience in creating guidelines for executing manual regression and automated tests.
• Worked closely with SME’s to make sure that test cases and test strategy covered every aspect to catch defects at initial stages of testing.
• Experience in validating source data coming from various database using SQL queries.
• Documented and reported defects and linked them with requirements using Quality Centre.
• Participated in walkthrough and defect reports meeting periodically.
• Supported development teams during application release from development to QA and to UAT environments.
• Experienced in Data Validation and Backend testing of databases to check the integrity of data. Used extensively SQL Queries to retrieve data from database.
• Used Quality Center for Test Management, Defect Management and save/manage the automation scripts created using QTP.
• Strong knowledge of Software Development Life Cycle (SDLC) as well as Testing Methodologies and the Role ofQA/ EDI Specialist
• Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes. Good understanding of Object Oriented Programming languages.
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Ab initio using SQL Server, Oracle, Hadoop, DB2 and UNIX. Ability to evaluate ETL/BI specifications and processes.
• Work closely with the Documentation team to insure the content is meaningful and correct.
• Experience in RDBMS, Microsoft SQL Server, Hadoop, Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
• Experienced in Black Box, White Box, Integration, Regression, Sanity, Functional, Front End and Back End Testing.
• Designed and implemented fully automated Hadoop Integration testing system.
• Responsible for Analysis and Defect Tracking using HP Quality Center/ALM, Test Director, JIRA, IBM Clear Quest.
• Business Intelligence tools like Micro strategy and Cognos.
• Sound knowledge and exposure in working with the various relational databases like Oracle, SQL Server etc.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Extensive experience in testing applications on UNIX environment.
• Excellent communication and writing skills.

TECHNICAL SKILLS

Platforms: Windows, UNIX, LINUX, MAC

Programming Languages: SQL, XML, VB SCRIPT

Automation Tool: QTP, Load Runner, SoapUI

Database Systems: Oracle, MySQL, Microsoft Access, SQL Server

Mobile Application Tool: IPhone Configuration Utility, Perfecto Mobil, Android Studio

Defect Management Tool: HP Quality Center/ALM, Bugzilla, Clear Quest, Rally, JIRA

Other Tools: Toad, SSIS, Teradata SQL Assistant, MS Office Suite, VMWare, XML Notepad, Crystal Report, Putty

PROFESSIONAL EXPERIENCE

Confidential, Evansville, Indiana

Mobile QA Test Engineer

Responsibilities:

• Understood system specifications and business requirements for its mobile project to prepare test strategy and test plan.
• Designed efficient manual test cases (both positive and negative) based on the analysis of Business Requirement documents
• Software Requirement Specification, Functional Requirement Specifications, Technical Design documents and Use cases.
• Interacted with Specification requirements team and developers regularly.
• Responsible for participating in project discovery meetings with all stake holders and providing initial high level estimates.
• Software Development Lifecycle (SDLC) And Software Testing Lifecycle (STLC) test practices such as test script writing and execution.
• Defect management and Agile testing methods.
• Partnered with cross - functional leads responsible for UAT (User Acceptance Testing) - providing them with test schedules, test data, direction and detailed Test Scripts in accordance with the Enterprise Release Schedule.
• Created comprehensive & feature-based Test Plans to test web-based of .mobile applications as well as performing compatibility suites on numerous mobile devices.
• Performed various types of testing on Mobile client applications across iPhone, Android, Blackberry and Mobile Web, and also web API's.
• Used See Test to automate Manual Mobile Testing Process.
• Performed Functional, Regression and Sanity Testing in each Sprint cycle for various e-commerce web-based transactions and business processes.
• Actively participated and represented QA Team in walk-through, inspection, review and user Group meetings, and led meetings within QA Team for creating various Test Artifacts.
• Mentored and supported QA offshore team in defining Test Procedures, application knowledge and Quick Test Professional (QTP) implementation.
• Used Quick Test Professional (QTP) to create and develop automated tests for continuous Regression Testing and various modules of Quality Center (QC) - Test Plan, Test Lab, Defects and Requirements.
• Attended weekly Project Status Meeting with Development team and QA Manager and worked.
• Closely with QA Manager to define Test Scope, Gap Analysis, Risk, Dependency and Constraints.
• Participated in design review meetings and provided revised final estimates for the project.
• Responsible for performing the Regression tests for every new builds, interim builds, candidate builds and modifications in production, development and QA environments.
• Analyzed the business logic of trading and banking operations and designed test cases.
• Worked on different trading module stocks, Options and Mutual funds.
• Responsible for creating, maintaining test plans and outlines for assigned functionality.
• Tested Confidential ’s banking modules for brokerage and bank accounts.
• Analyzed end to end functionality by testing the application manually.
• Involved in user authentication testing for both Android and Apple devices.
• Tested the application for navigation to different pages, buttons and other features on the page.
• Tested Confidential ’s application in iPad, iPhone, version 3 and 4.
• Tested different modules of application in Android.
• Used Quality Center 10 to design the scripts, perform baseline testing, execute the scripts and organize all the scripts systematically and generate reports.
• Updating scripts in HP Quality Center 10 and excel sheets.
• Interacted with business analyst to discuss better UI features that can be provided through the application to the clients
• Wrote & enhanced Test Cases and Test Scripts to meet new functional requirements as per the new business requirements on Individual modules & business process.
• Created simple to complex SQL queries to validate Oracle tables and for correct test data retrieval.
• Supported Sprint activities by determining the number of test cases needed to verify the software being developed off the Sprint Backlog.
• Formulated methods to perform Positive testing and Negative testing against requirements.

Environment: QTP, HP QC, Android Studio, Perfecto Mobile, XML, IPhone Configuration Utility

Confidential, Indianapolis, Indiana

Senior Quality Analyst

Responsibilities:

• Analyzed BRD, FRD and coordinated with business analysts to write test strategy and test plan.
• Performed ambiguity review on BRD and FRD.
• Attended walkthrough meetings with the Compliance Operations Team, Business Analysts and Development team to get a clear understanding of the laws, regulation and corporate standards that were to follow.
• Prepared Test Cases using Test Plan and involved in Test Cases execution.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them were missed.
• Validated the data fed from the various systems using queries.
• Performed data driven testing manually.
• Validated batch transaction using AutoSys in Unix Script.
• Tested every aspect of the AML monitoring system for any possible defects using negative and positive test scenarios.
• Logged defects using HP ALM, linked defects with requirements and generated Defect Reports in ALM.
• Retested the resolved defects after developer’s amendment.
• Worked in Agile methodology. Attended Daily standup meetings.
• Developed Test Plan and Test cases based on the user stories (Functional requirements).
• Executed manual test cases and identified the test cases to be automated.
• Detected Defects, Communicated to the developers using Bug Reporting Tool and Tracking the Defects using JIRA.
• Prepared Test Cases for GUI application.
• Involved in testing the backend Database retrieved the data from the tables using SQL.
• Validated Web Services request, WSDL and response xml using SOAPUI tool.
• Worked closely with development team to resolve defects and testability issues throughout the software development life cycle.
• Communicated with the developers through all phases of testing to prioritize bug resolution and oversaw their execution and tracking.
• Worked with other members of the QA and Development teams in an effort to improve the process, methods, effectiveness and efficiency.
• Escalated risks, gaps in UAT scope that lead to incorrect interpretation of UAT result to UAT Coordinator.
• Trained on AML (Anti-Money Laundering) concepts as it pertains to the different types of financial transactions that involve Latin American institutions.
• Reviewed and studied BRDs and FRDs for AML related financial transactions.
• Validated data mapping documents by country and transaction type using relevant BRD, FRD and any other available reference sources.
• Attended daily status/defects review meetings.

Environment: ORACLE’s AML Tool, JIRA, SOAP UI, Oracle, Teradata, AutoSys, HP ALM, My SQL.

Confidential, St. Louis

ETL/BI Tester

Responsibilities:

• Understanding the business & technology of the client system for providing them with quality deliverables.
• Developed test strategy and test plan using the Requirement documents.
• Worked closely with the team to make sure that test cases and test strategy cover every aspect to catch defects at initial stages of testing.
• Logged defects using JIRA.
• Started with validating the requirements from the users and testing the documents for the specifications.
• Tested the Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.
• Tested metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.
• Created and reviewed test case and test plan based on the data mapping documents for ETL front and based on BRD for reporting end.
• Identified and implemented process improvement efforts within the EDI structure including system interface, policy and procedure changes.
• Wrote complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Worked on837, 835, 276and277 InstitutionalandProfessional, EDI Gateway.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Assisted EDI team with thetesting of maps for HIPAA transactions 835and837.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Customized the QTP Test as per the Test Case by using the VB-Script.
• Tested reports with various object prompts to validate data of various Ad hoc reports.
• Involved in Testing of reports and worked with development team to optimize the Intelligence Server for better performance.
• Involved in testing complex Time Dimension and worked closely with data analyst team to help identify data related issues and analysis.
• Tested multiple projects pointing to staging, testing and production data warehouse.
• Tested various Report services and Dashboard documents on sales sent monthly to vendors.
• Performed data validation for Teradata Mload script and OLE Load for loading data into Teradata from various sources.
• Supported development teams during application releases from development to QA and to UAT environments.
• GUI testing of the mobile website for compatibility with IPad.
• Performed Smoke testing for each build of the application.
• Data validation testing - performed SQL validation to verify the data extracts and record counts in the database tables by writing SQL queries.
• Communicated with data warehouse team (business analysts, data modelers and developers) regarding status, issues and risks on a timely basis. Identify, mitigate and drive project issues and risks to resolution.
• Created training materials to align with enhancements and releases.

Environment: Micro strategy BI, DataStage (ETL), Teradata, QTP, JIRA, Internet Explorer, IPad

Confidential, Deerfield, Illinois

Quality Analyst

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
• Involved in testing the full functionality of POS (Point Of Sale system) from end to end.
• Close interaction with designers and software developers to understand application functionality and navigational flow.
• Daily Update Meetings with QA Manager to discuss the status of Projects.
• Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required conducting the effort.
• Actively involved in preparing business and technical documentation for applications in design, which would serve the development team.
• Developed user requirements for the POS application.
• Performed Smoke, Sanity, Regression, Integration, and Functional tests.
• Analyzed the user stories in the product backlog for each sprint and added the requirements to HP ALM. Mapped the dependency of the requirements.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in testing the full functionality of POS (Point Of Sale system) from end to end.
• Close interaction with designers and software developers to understand application functionality and navigational flow.
• Daily Update Meetings with QA Manager to discuss the status of Projects.
• Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required conducting the effort.
• Actively involved in preparing business and technical documentation for applications in design, which would serve the development team. Developed user requirements for the POS application.
• Performed Smoke, Sanity, Regression, Integration, and Functional tests.
• Performed tasks on IBM 4690 controller application to implement the modifications presented in the requirement.
• Tested the cashier activities, POS ability to read cards, store server, and back office integration.
• Tested on various VeriFone VPP Pin pads such as MX 0860 and MX 0915 pin pads with Omnico software (N2N4).
• Performed payment transactions authorization using Base 24.
• Involved in Test Data Preparation and Optimization.
• Used NCR's logix to create Copient Offers and used Copient web tool to load those offers.
• Used Zint barcode generator to create various types of barcodes for testing purposes.
• Performed POS (point of Sale) testing using image scanners, barcode scanners, POS registers and scale.
• Worked on Toshiba ACE POS application (IBM 4690) for performing commands to modify the terminal features and controller application features.
• Created Test Sets in Quality Center and executed for each build.
• Wrote test cases and tested POS back end application.
• Followed Agile (Scrum) project management procedures.
• Involved in preparing Traceability Matrix for the functional requirements of the system.
• Reduced inventory by monitoring staff, facilitating Associate training on Point of Sale (POS) replenishment system, and introducing improved inventory movement controls.
• Prioritized and reported defects using Quality Center and generated documents and reports for further analysis.
• Executed Test cases in different phases of testing like Smoke, Functional, Integration, GUI and System testing.
• Involved in meetings with Automation team for Development of Automation Scripts in QTP.
• Logged defects using Quality Center.
• Involved in testing XML scripts for Sales Summary.
• Worked in backend Testing using Mainframes commands for verifying logs and validating transaction details.
• Verified whether the front-end sales were correctly stored in the back end database by using SQL queries.
• Attended Status update meeting, review meeting and technical discussions.

Environment: HP ALM, IBM 4690, Logix, Web tool, Share-point, Web Services, SQL, HTML, XM