SUMMARY

• Over 6+ years of experience in Information Technology with specialization in Software Testing.
• Expert in manual and automated testing for Client / Server, Web - based applications.
• Strong in analyzing Business requirements, specifications and development of Test Plans, Test Cases and executing them.
• Experience in Integration Testing, System Testing, Functional Testing, Regression Testing, Smoke Testing, Database Testing, GUI Testing, Build verification testing, User Acceptance Testing and End-End Testing.
• Worked on Data Stage Enterprise Integration Suite Data Stage Version 11.3.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Excellent working knowledge on Desktop Windows UI Application.
• Good knowledge of Dimensional Data Modeling, Star Schema, Snowflake schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Worked on SQL/PLSQL queries for extraction of data
• Created and executed SQL queries for validating transformation rules used in source to target mappings.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Experience in testing database applications of RDBMS in DB2, Oracle, and SQL Server.
• Knowledge of handling the Verification and Validation of data.
• Experience in defect tracking and change management using quality center, JIRA,HPALM
• Good knowledge and experience in SDLC, STLC and bug life cycle.
• Proficient in documentation using MS tools (Word, Excel & Access)
• Excellent knowledge of Agile & Scrum development environment, multiple web browsers.
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Extensively used Micro Strategy for report generation.
• Used Quality Center to track and report system defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Having excellent analytical skills with good communication and self-organizing skills.
• Ability to interact with developers and product analysts regarding testing status
• Assertive, Self-starter, diligent and a committed team player.

TECHNICAL SKILLS

• Quality center, Rational Clear Quest, JIRA,HP ALM
• 11.0,12.01,12.50
• QTP, Win Runner
• IBM Info Sphere Information Server Data Stage 11.3
• SQL, PL/SQL, VBA, Visual Basic, C#, ASP.NET,ADO.NET
• Apache Tomcat, JBoss, IBM Web sphere
• Win 98/NT/2000/XP, Linux, windows 7
• MS Access 2000, DB2,MS SQL server, Oracle 8i/9i/10G/11G
• Waterfall, Agile
• JSP
• XML, HTML
• IE 5.0, 6.0, 7.0, Netscape 4.7, 4.8, Fire fox, Safari Chrome

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

QA Analyst

Responsibilities:

• Tested POS application with different settings and configurations on the POS controllers.
• Done customer transactions such as the entry of items, tender, discounts etc
• Done sale transactions with credit card/debit card/gift card.
• Validated tender details on SIGUI Layaway registers.
• Return and exchange of an item with different tenders (cash, credit etc), with and without receipt.
• Involved in testing the desktop application.
• Tested various transaction declined scenarios (Invalid Card/PIN/Expired Card etc.)
• Responsible for creating business requirements-to-test case traceability matrix
• Developed and Maintained Test Cases and Test Plans for manual testing for assigned modules.
• Wrote UNIX scripts to transfer item files from one store to another, to check the log files.
• Used transaction viewer 2.0 to see complete payment history for a specific card.
• Add and delete items for the same layaway order on current transactions.
• Used HP ALM 12.50 for repository, requirements, traceability matrix, reporting and tracking defects and providing updates on resolved bugs.
• Performed Regression Tests to assure that new problem have not been introduced as a result of fixes.
• Working closely with software development, design and testing teams to determine best approach for each project or product releases.
• Participated in weekly meetings to resolve technical issues.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
• Formulate methods to perform Positive and Negative testing against requirements.
• Managed and conducted System testing, Integration testing, Functional testing and Regression testing.

Environment: HP ALM 12.01/12.50 , TV++, DB2, putty, Windows 8, Microsoft Excel 2016, UNIX, Tran viewer 2.0, POS Registers and controllers, EPAY simulator.

Confidential, Detroit MI

ETL Tester

Responsibilities:

• Analyzed the Software Requirements and Design documents and developed detailed Test Plans and Test Scenarios for the FACETS system
• Involved in data conversion validation testing and compared the legacy data to the converted data in the new Oracle environment.
• Responsible for creating business requirements-to-test case traceability matrix
• Responsible for providing test estimations and daily project updates
• Responsible for end-to-end testing FACETS system including system integration testing, regression testing and database testing.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables .
• Created and executed SQL queries to perform source to target testing on oracle database.
• Performed various tests like Duplicate check, primary key check, Reconciliation check, data integrity check, initial and incremental load check, data comparison check.
• Automated and scheduled the data stage jobs using UNIX Shell Scripting.
• Followed Agile/Scrum Methodology
• Participate in review meetings and provide updates to Test Plans, Test cases and Test Scenarios based on review comments.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Worked with Data Warehousing developers who extensively used Data stage, to design mapping to move data from source to target database using Stages to do the functionality.
• Developed and Maintained Test Cases and Test Plans for manual testing for assigned modules.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Performed Regression Tests to assure that new problem have not been introduced as a result of fixes.
• Extensively used Control - M to schedule the jobs and run the scheduled jobs at specific time.
• Working closely with software development, design and testing teams to determine best approach for each project or product releases.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
• Analyzed application data using the SQL to identify the ETL processes
• Maintain, backup and restore the data stage ETL repositories for the QA team.
• Performed Verification, Validation, and Transformations on the Input data (Text files) before loading into target database.
• Responsible for validation of Target data in Data warehouse which are Transformed and Loaded using data stage designer.
• Execute batch processing and verify the jobs status and data in database tables
• Executed and managed test cases and reported bugs in HPALM.

Environment: Oracle, J2EE, MQ Series, IBM Web sphere data stage 11.3,HPALM,, .net, +,TFS, VB Script, EDI, Web Methods, Control-M job Scheduler, Techexcel, AIX 5.3,Oracle, SQL Server, SQL Query Analyzer, MS Excel and Windows XP.

Confidential, NY

QA Analyst

Responsibilities:

• Participated in User Story review meetings by BA's and provided inputs/feedbacks
• Analyzed User stories before development begins and provided suggestions.
• Understood PBI'S (Product Backlog Items) for any particular Sprint
• Developed Test Plan's, Test Strategy, Test Cases and Test Scripts using liberty templates
• Followed Agile/Scrum Methodology.
• Worked closely with Automation and Manual Testing teams to understand test data needs
• Tested GuidewirePolicy Center Application functionality by Manual and Automation.
• Worked closely with the test data set up team to get the test data required for Manual Teting needs.
• Developed Test plan which defines a Test Strategy for the Application.
• Documented, implemented, monitored, enforced all processes for testing as per standards defined by the organization.
• Defined and established various processes such as defect tracking, review closure, document approvals.
• Performed Functional, Regression, UAT and Integration testing on different browsers.
• Performed Functional, Negative, GUI Testing, Positive, Integration, Regression, End to End and User Acceptance Testing
• Involved in creating the Traceability matrix based on Functional requirement in each module.
• Regularly followed up with the development team to discuss the defects identified during Testing.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using JIRA
• Prepared weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using JIRA.
• Maintained bug lists for critical issues using JIRA.

Environment: JIRA, IE 9.0, FireFox 17.0, DB2, HTML, Java, SQL Server,Windows XP, Paradox, UNIX, Hermes, Mainframe, Informatica, Excel, Word, Rally and NexJ Suite

Confidential

QA analyst

Responsibilities:

• Documented test requirements and test cases.
• Written user-defined functions and generated Test Matrix.
• Developed SQL queries to test the data after executing transactions like deposit processing and check processing in batches.
• Prepared and modified test data in User interface and verified and validated the same in the backend tables.
• Used Quick Test Professional (QTP) for regression testing and running the automation suite
• Parameterized the tests to check the application with multiple sets of data (Data Driven Testing) using QTP
• Worked on manually validating the data in database.
• Worked with requirements to write the test plan and test cases.
• Manually executed the test cases and reported the results to development.
• Worked closely with teams of clients, developers, and testers throughout the entire development
• Tracked and prepared reports for testing activities like testing results, test case coverage,
• Identified defects and their status.
• Involved in documentation for automated scripts.
• Worked with running the Smoke Test to verify the environment is stable.

Environment: J2EE, MQ Series, QTP, IBM Web sphere Data stage 8.5, Spring, HTML, JavaScript, AIX DB2, SQL Server, JIRA, AIX Unix and Windows XP / 2000, XML, Oracle 11g/10g, JUnit, Excel, SQL, Windows NT, UNIX, Sun Solaris, Putty