SUMMARY:

• Around 20 years of total experience in Information technology.
• Good functional knowledge about POS/retail, eCom, Ticketing, marketing and finance industries.
• Experience in coordinator role for Onsite Offshore model.
• Around 10 years of experience in .Net, ETL / Data warehouse / Report testing.
• Good at SQL and Stored Procedures.
• Good Understanding and working knowledge in SAFe (Scaled Agile Framework) .
• Expert in test plan, converting the project requirements to use cases, test cases data flow diagrams and scenarios.
• Strong believes in continuous quality process improvement and the documentation
• Good at Root cause analysis to research on missed defects by team.
• Conduct Knowledge Transfer sessions among the team members and make sure all team members has same level of functional and technical knowledge.
• Expert in develop Excel macro tools to minimize the manual interference or work.
• Preparing pre and post implementation check list.
• Working closely with UAT team during testing and UAT sign off process.
• Strong Testing experience in Web applications (.Net), ERP (PeopleSoft) and Client Server applications.
• Experience in Designing, Developing and Executing test cases.
• Committed to ensure compliance with standard QA practices, processes, continuous improvement and enterprise standards to make sure the defect free delivery.
• Experience in software product development life cycle, methodologies (Agile), strategies and Traceability Matrix.
• Assign and balance the work load to team members.
• Experience in defect tracking tools like Test Director, TFS, eRoom, Lotus Database and Rational Clear Quest to submit and track defects.
• Conducted the KT (Knowledge Transfer) Sessions.
• Proven ability to adapt quickly to new projects and assignments.
• Possess good analytical and interpersonal skills required for delivery of timely and robust projects.
• Experience in gathering business requirements from client and documentation.

TECHNICAL SUMMARY:

ERP: PeopleSoft and GISMO

Web Applications: .Net

ETL Tools: SSIS Packages, DataStage 7.5.1A EE and Server, Informatica 7.x

BI Tools: SSRS, Cognos 10.1.1, Crystal Report, Tableau and Power BI

Web Tools: REST, SOAP UI and Postman.

GUI: Visual Basic 6.0, VC++

Operating System: Windows NT, Linux and UNIX

ERP: People Tools 8.43, Peoplesoft Query & PeopleSoft HRMS (HCM) 8.8 and 8.9

Languages/Application: C, C++, VB Script, MS Excel (macros)

RDBMS: SQL Server, TeraData 12.0, DB2 3.0, Oracle and MS Access

Testing Tool: QTP, Win Runner and Selenium

Defect Tracking Tools: Quality Center, Test Director, TFS, Lotus Database, Rational ClearQuest and eRoom

PROJECT EXPERIENCE:

Confidential

Sr. QA Analyst (BI)

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Wrote SQL queries to validate the standard SSRS, Dashboards/Power BI Reports
• Co - ordinated Offshore team.
• Extensively tested several SSRS and PowerBI Reports for data quality, fonts, headers, footers, and cosmetics.
• Work with Developers during test summary and status calls to resolve defect.
• Provide reporting of tests and test results from regular builds to the Manager.
• Responsible for bug reproduction cases and scenario
• Extensively used SQL queries for data verification and backend testing
• Developed test scripts using SQL queries to validate data.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: SSIS, SSRS, PowerBI and Recurly.

Confidential, Grapevine, TX

Sr. QA Analyst

Responsibilities:

• Design and Maintain Automation Framework to validate the Product, Price and Hierarchy feed before uploading them to AWS S3 Bucket.
• Test applications that communicate and send data to the AWS Cloud components (AWS SQS queues, AWS SNS processing, AWS S3 buckets.
• Co-ordinated offshore team.
• Testing and monitoring batch jobs.
• Developed an automation tool to check the job log files in QA and notify the team by scheduled email .
• Review the user stories with User Stories before grooming session, noted down the questions and clarifications.
• Assign the User Stories to QA team members and closely monitor them until it moved to Done Status.
• Coordinate with downstream teams and make sure the ECP data is flowing smoothly.
• Pilot demo with team members before show the test results to Product Owners
• Schedule the Demo and work with Product Owners to move the User Stories from PO Acceptance to Done state.
• Test the SnapLogic applications that perform ETL, file movement, and other functions. SnapLogic is a new tool used for AWS Cloud integrations among other uses.
• Implement the automation test scripts while integrating them with Application Lifecycle Management (Zephyr) which is a test management tool.
• Work closely with POS, Warehouse, Middleware, EIM, Big Data and Business Intelligence teams for integration testing and any support they require.
• Perform SQL script and Stored Procedure design reviews to ensure design objectives are met and standards are followed.
• Lead discussions, and cross-training with the team members to sharpen their approach of creating automation Scripts to encompass all possible functional changes.
• Lend technical leadership to develop new automation tools/frameworks and implementation for initiatives within the Enterprise.
• Work closely with corresponding functional testers assigned to every modification after the first round of functional testing to understand the complexities and change to achieve generating scripts with quality and reusability.
• Create, schedule, and monitor the Tidal jobs. Tidal is a scheduling software that launches batch and ETL processes on a schedule.
• Analyze the batch process job logs and follow up with necessary actions if it fails.
• Designed and created an automation tool to search through batch job log files for Errors and email a report to the appropriate teams/users.
• Work closely with development/business teams to reproduce and analyze the bugs/issues in PRE and POST environments.
• Develop and produce project documentation, Test scenarios and Test cases to ensure consistent results across all projects.
• Recommend practical approach to complex product testing specifically to generate more robust scripts to handle regression testing.

Environment: / Tools: AWS, .Net, C#, SQL Server 2008, Pervasive, SOAP UI, REST, Postman, Snaplogic, and Tidal, Microsoft Test Manager.

Confidential, Grand Prairie, TX

QA Lead

Responsibilities:

• Designed and Created test plan and test scenarios for Ticketing Suite and Reporting.
• Deployment and Testing for Ticketing Suite and reports.
• Responsible to translate business requirements/ Functional or Technical specifications into quality assurance test cases
• Testing eCom web services.
• Review the test scenarios, test cases and Test Results.
• Review the Clarification raised by the team members.
• Developed test scripts using SQL queries to validate back end.
• Analyze and testing SSRS Reports.
• Responsible for documenting the process for future references.
• Review the QTP Scripts

Environment: .Net, C#, SQL Server 2008, SSIS and SSRS

Defect Tracking Tool: TFS and MTM.

Automation Tool: QTP 11

Confidential, Grapevine, TX

Sr. QA Analyst

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Middleware, Data warehouse and Report testing.
• Deployment and Testing for Middleware application.
• Attending Scrum meetings.
• Responsible to translate business requirements/ Functional or Technical specifications into quality assurance test cases
• Review of test scenarios, test cases and Middleware, Data warehouse and Report Test Results.
• Review of Clarification raised by the team members.
• Effectively used TFS as a bug tracking tool.
• Developed test scripts using SQL queries to validate Report data against Source and Data mart data.
• Analyzed and documented the test results for Cognos Reports.
• Enhanced and modified the scripts according to the test case scenarios.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Periodical meetings with Directors, Project Managers and Clients for implementing new approaches and techniques.
• Responsible for documenting the process for future references.

Environment: .Net, C#, SQL Server 2008, TFS, SSIS, Cognos.

Defect Tracking Tool: TFS and MTM.

Confidential, Irving, TX

Sr. Analyst QA (BI and Reports)

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and Report testing (Dash board and sub reports).
• Deployment and Testing for SSRS reports
• Responsible to translate business requirements/ Reports specifications into quality assurance test cases
• Review of test scenarios, test cases and Data warehouse / Report Test Results.
• Maintaining Traceability Matrix document.
• Review of Clarification raised by the team members.
• Effectively used Team Track as a bug tracking tool.
• Developed test scripts using SQL queries to validate Report data against Source and Data mart data.
• Analyzed and documented the test results for SSRS Reports.
• Enhanced and modified the scripts according to the test case scenarios.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Periodical meetings with Directors, Project Managers and Clients for implementing new approaches and techniques.
• Responsible for documenting the process for future references.

Environment: SSIS Packages, SSRS, Cognos Business Objects, SQL Server 2008, Visual Source.

Defect Tracking Tool: Test Director.

Confidential, Dallas, TX

Sr. Analyst (QA)

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse testing.
• Deployment and Testing for cognos and SSRS reports (Dash board and sub reports)
• Attending Scrum meetings.
• Designed and developed automation tool to test around 170 tables using Microsoft Excel Macros.
• Participated on Developing and testing for Audit and Sanity Automation tools to test Data ware house (SAMBI) project.
• Database validation testing after publishing to the QA/STG environment during each iteration
• In QA environment, the QA tester reviews all deliverables.
• Responsible to translate business requirements into quality assurance test cases
• Review of test scenarios, test cases and Functional Test Results.
• Maintaining Traceability Matrix document.
• Review of Clarification raised by the team members.
• Analyzed the functional requirements of the application and developed test strategy for the application.
• Effectively used TFS as a bug tracking tool.
• Developed test scripts using SQL queries to perform regression testing for different versions of application.
• Analyzed and documented the test results for each build of testing.
• Enhanced and modified the scripts according to the test case scenarios.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Periodical meetings with Directors, Project Managers and Clients for implementing new approaches and techniques.
• Responsible for documenting the process for future references.

Environment: .Net, C# and SSIS Packages, SSRS,Cognos, SQL Server 2005 and 2008, Control - M, TFS.

Defect Tracking Tool: TFS(Team Foundation Server).

Confidential, Plano TX

ETL Sr. Analyst (QA)

Environment: DataStage 7.5.1A EE, .Net, C#, PS Query, Oracle, MS Excel (macros) Windows NT, UNIX and Quality Center