SUMMARY:

• Certified Big Data Hadoop professional with 10+years of IT experience; over 8years of diversified experience in Software Quality Assurance and Testing within Retail, Banking and HealthCare industry
• Proficient in Functionality Testing, Black and White Box Testing, System Integration testing, Regression Testing, User Acceptance Testing (UAT).Proficient in using all modules of HPQC and ALM.
• Very good experience working with different retail modules RMS, ReIM, ReSA, RDF, SAS, SIM.
• Extensive experience testing ETL codes where development environment involves Data stage, Informatica, Abinitio and Autosys.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Proficient in analysis of Business Requirements, developing comprehensive test Specs & executing them.
• Expert in designing and developing Test estimation, Test strategy, Test plans, Test scenarios and Test cases according to the given business specification.
• Hands on experience in defect managing process - Defect logging, Defect tracking and handling Defect Triage meetings
• Solid backend database testing experience by writing SQL and PL/SQL scripts to verify data integrity.
• Involved in Manual Testing of applications in UNIX and Windows Environments for both Server side and Data Warehousing Applications.
• Excellent skills in DB2, SQL Server and Oracle 9i/8i RDBMS. Oracle SQL developer.
• Involved in end-to-end system testing in distributed SOA enabled environment.
• Expertise in Problem solving and Tracking Bug Reports using various Bug tracking Tools.
• Hands on experience on testing and writing complex SQL, T-SQL, PL/SQL and Netezza SQL statements.
• Working knowledge of Web Services using SOA, SOAP UI, REST & Custom Based Approach.
• Worked on developing /testing software applications on the IBM Mainframes using COBOL, DB2, SQL, CICS, VSAM, JCL, TSO/ISPF, SPUFI, QMF, and XPEDITER in MVS environment.
• Performed backend testing using SQL Queries and UNIX SHELL SCRIPT.

SOFTWARE SKILLS:

Testing Tools: HPQC, HP ALM, JIRA, ServiceNow, Visual Test, Silk Application Stress Tool (WAS)

Languages/GUI tools: COBOL II & VS COBOL, JCL, SQL, EASYTRIEVE, XML, XSLT, VB, FOXPRO, CLIPPER.

ETL tools: Informatica 8.5/ 8.1/7.1/6.2/5.1 (Power Center/ Power Mart), Datastage

RDBMS / Databases: SQL Server, Sybase, Oracle and MS Access 97

Web Servers: MS-IIS 5.0, Apache 1.3.9, MS Commerce Server 2000

Application Servers: JRun 2.33, Web Logic 7.x, Web Sphere 6.x,

Operating Systems: MS-DOS, UNIX, Windows 95/98/ NT/2000, Win2K Advanced Server, Novell NetWare

Configuration Tools: CVS, PVCS, Rational Clear Case, MS Visual Source safe

EXPERIENCE:

Confidential

Sr. QA Analyst

Katy, TX

Environment: HPQC, HP ALM, JIRA, Service Now, SQL Developer, MS Access, Aginity, DB visualizer, AS400

• Validate roll-up logic for Class, Vendor, Style, Color from lowest Item Level between RMS and SAS.
• Validate key indicators for items like, core-assortment, Out of Stock dates, and Clearance Level logic in SAS.
• Perform testing to validate change in merchandise hierarchy through reclass events in RMS.
• Create reclass events in RMS and validate data flow in downstream system like RDF.
• Generate item forecast with reclassed data in RDF and validate forecasted data in SAS.
• Validate Sales History Build batch program to validate rolled up merchandise hierarchy level view of weekly sales at a store location for use by the Retail Allocation product.
• Validate key SAS measure like Sls Ttl, Total Transaction Count, EOP, Item Per Class, Item Per Store by validating data flow from Abi, ODS and RDF.

Intueor Consulting

Sr. QA Tester

Ridgeland, MS

Environment: HPQC, HP ALM, JIRA, Service Now, Eclipse Mars2, SQuirreL SQL MS Access, Aginity, DB visualizer, AS400

• Create tasks for development JIRA using screen ID located on multiple pages in web application.
• Bring changes from legacy system to new system using run commands in eclipse.
• Run class within eclipse to convert files into XHTML, CONTROLLER AND CONTROLLERBEAN.
• Run generated artifacts within eclipse.
• Do Maven install on new build to deploy changes in new system for testing purpose.
• Use SQuirreL, Eclipse to identify and test data for testing.
• Use Source Tree to commit merged changes from development team.
• Identify root cause for discrepancies between legacy and new systems.
• Create and track defects in JIRA and generate daily reports to review progress.

Confidential

Sr. QA Analyst

Katy, TX

Environment: HPQC, HP ALM, JIRA, Service Now, SQL Developer, MS Access, Aginity, DB visualizer, AS400

• Develop test plan, test cases, and test scenarios to validate the software applications by using various systems including HPQC, HP ALM and JIRA.
• Work closely with business users to identifying test scenarios.
• Generate daily reports using ALM to present daily testing progress or report road blocks to project team.
• Closely work with developers and business analyst to work on defects and identify root cause.
• Frontend/Backend testing for different ETL interfaces -RMS to SAS, RDF to SAS, ABI/ODS to SAS, RMS to PIM.
• Identify and create test data for various ETL interfaces.
• Validated complex business rules as per mapping documents.
• Validate data flow from Legacy system(IP)to staging tables before loading to the Production environment (RMS) during data migration process.
• Perform root cause analysis and generated report about defects being introduced during development.
• Validate SAS application through backend for interfaces like Sales, Inventory, On Order, On Order Cancel, Comparable Stores and Location.
• Validate JDA Space Data from ODS to POGs Sub-Cluster Staging tables.
• Develop and test business processes (UAT and Systems Integration testing) and supported end users in execution of test scripts.
• Perform Manual Testing, Smoke Testing, Functional Testing, End-to-End Testing, Integration Testing, Regression Testing, and Back End Testing.
• Extensively tested ETL data by writing SQL Queries from multiple source system like RMS, ABI and ODS into different target systems like RDF and SAS.
• Actively involved in data migration and testing Reports generated by Micro Strategy using SQL.
• Write SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Create variance reports for key indicators like Sales, Cost and Units by tracking data through backend in RMS, ODS, ABI, RDF and SAS.
• Responsible for testing patches provided by Oracle as well as enhancements/fixes provided by Academy development team.
• Coordinate with UC4 team to make sure necessary batch process ran before validation in Test Environments.
• Validate PO’s generated from RMS received in WMS system and. Also, validated data populated in Sales Audit tables through POS system
• Validate forecast settings like Default Forecast Method, Spreading Profile, Forecast Cycle Days for entire domain in Forecast Admin workbook.
• Monitor system behavior by modifying forecasting parameters like Approval Method Override, Forecast Method Override, Source Level Override at more granular level like product/location in Forecast Maint. Workbook.
• Used Forecast Approval Workbook to adjust, analyze and approve forecast.
• Make changes to forecast in Adjusted Forecast Measure and manually approve forecast in Forecast Approval Workbook.
• Validate Cloning process for new item/location from model after item/location through Product/Location Cloning Administration workbook.
• Test if the history is being pulled correctly for cloned item and location is per Clone Adjustment Ratio set in Product/Location Cloning Administration workbook.
• Validate source level forecast by aggregating data to higher level like Item/Store/Week, Class/Area/Week, Item/Chain/Week.
• Tested logic for alerts like, Alert High Forecast, Alert Low Forecast, Alert Approve by Alert triggered in Alert Manager workbook is as per parameters set by users in Alert Maintenance workbook.
• Write logic and create template to validate key measures like Retail, Cost and Units interfacing to SAS Application from RDF.
• Write complex logic using SQL for SAS Hierarchy that being feed to RDF through ABI.
• Test the logic for OOS, Anomaly Events, Promo Events in Sales Preprocessing workbook.
• Write SQL queries to validate OOS logic in Netezza ODS environment.
• Perform backend validation for weekly sales data that being pulled from ABI into RDF.
• Manually execute forecast generation process using Run Batch Wizard.
• Tested forecastable items coming in from RMS are flagged correctly in RDF.
• Validate Enhancements by Academy development team and patches for fixes provided by Oracle on different RPAS versions.
• Work closely with end-users to understand new features being implemented and provide testing needs and inputs throughout development cycle.
• Developed and maintain robust regression test suits in HP ALM for each release.
• Troubleshoot questions and provide solution during UAT testing.
• Work and coordinate with cross-functional team for issues arising during QA and UAT cycle.

Confidential

Sr. QA Tester

Eden Prairie, Minnesota

Environment: COBOL, ODMS, CDB, CICS, TSO, ISPF, SQL, REXX, VSAM, Z/OS, Expeditor, File Aid and CA-7., Soap Sonar, Soap UI, HP QTP, HP ALM, Oracle 9i, Perl and UNIX Shell Scripting, TOAD 7.0, SAS/SQL, UDB DB2, Rational Clear Case, Java, XML, XSD, SQL, PL/SQL, Rally

• Created Test Cases, Test Case Inventory, traceability matrix based on mapping document and requirements
• Lead offshore team of testers and maintain task and estimation in Agile Development Software like Rally.
• Identify task for testing teams for each two-week Sprint and define user stories in Rally.
• Work in fast paced environment and generate reports, provide updates during daily Scrum.
• Work on Data Reconciliation for multiple feeds using Infogix tool.
• Performed Functional Testing and Back-end Testing manually using the database comparable results.
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Performed complex data validation using SQL queries.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Involved with business users to perform UAT and executed test cases to verify requirements, look and feel of the applications.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Enhanced the QT Pro Scripts in expert mode in order to implement efficient test scenarios.
• Used HP ALM for bug reporting.
• Tracked and reported the bugs with HP ALM.
• Worked in keyword view as well as expert view of Quick Test Pro.
• Responsible for developing manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
• Tested CICS mappings manually and checking the validation of the Mapplets.
• Tested JCL coding to check Adhoc jobs running or not.
• Experience in working independently and multi task without negative impact to timelines or quality.
• Strong Knowledge on the phases of Software Development Life Cycle (SDLC) Methodology.
• Generate business reports for SIT testing using dashboard analysis view for PM
• White box testing of JCL Code and Cobol 2 modules for processing credit card transactions
• Review the test cases written based on the Change Request document.
• Conduct testing based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Performed defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Tested data migration to ensure that integrity of data was not compromised.
• Conducted defect triage meetings.
• Rigorously worked on testing customer matrix from front end to backend.
• Modified and maintained CMS for testing content in web application.
• Demo progress of actual working product at the end of each sprint to the client.

Confidential

QA Tester

Jersey City, New Jersey

Environment: MVS, COBOL II, DB2, JCL, VSAM, BMC, JIRA, ABEND-AID, DATACOM, EXPEDITOR, TSO/SDSF, DBVISUALIZER, Mercury Quality Center 8.2 (Test Director), SoapSonar, Soap UI, DB2, Quick Test Pro 8.2, IBM DB2, Autosys, Oracle 10g, Rational Clear Case, Mercury ITG Governance, HTML, MS SQL 2008/2005 SSRS, SSAS,.NET, ASP.NET, VB.NET, C++, Oracle Warehouse Builder, Discoverer, Data Profiler

• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing
• Developed business process models in RUP to document existing and future business processes for the data warehousing.
• Involved in both Manual Testing and Automation Test scripts based on Use cases developed.
• Tested messaging and SOA web services using XML, Web services were tested using system-to-system and UI to system tests.
• Tested SOA end-to-end, Service by service and Interface by Interface.
• Involved with risk categories for SOA including Testability, Functionality, Interoperability, Performance, Security and Compliance.
• Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the business requirements.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Preparation of test data and execution of report JCL, restore jobs that create test datasets from the production, production data snapshots which are consumed by the run JCL, preparation of test data using File-Aid.
• Preparing exhibit documents after converting code of On-line/Batch program from VSAM files to DB2.
• Involved in implementation of the Test plans, Test cases and Test scripts
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement. Involved in the development of Informatica Mappings and also tuned them for better performance
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• An extensively used Complex SQL statement for retrieving data using TOAD and it is used in TSL scripts.
• Extensively worked on Mercury Test Center and ran various scenarios and scheduled them.
• Configured Quick Test Professional with Quality center.
• Collected user requirements from various stake-holders for the data warehouse.
• Very strong SQL skills and experience with OLAP. Expertise in data-driven testing, drill down applications, writing test cases and test scripts
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Used SQL for Querying the DB2 database in UNIX environment
• Developed automated scripts for functional testing and Data driven testing of the application using QTP
• Automated detailed test cases by using Quick Test Pro.
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
• Transformation of XML documents using XSLT.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.