SUMMARY

• Around 20 years of total experience in Information technology.
• Good functional knowledge about POS/retail, eCom, Ticketing, marketing and finance industries.
• 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.
• Experience in coordinator role for Onsite Offshore model.
• 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 SKILLS

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 Business Objects

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: TeraData 12.0, DB2 3.0, Oracle, SQL Server and MS Access

Testing Tool: QTP, Win Runner and Selenium

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

PROFESSIONAL EXPERIENCE

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.
• Coordinate Off Shore 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.
• Run and test automation deployments to the QA and CERT environments.
• Collaborate closely with solution architects to define and implement effective and efficient automation solutions to business challenges and opportunities.
• Implement the automation test scripts while integrating them with Application Lifecycle Management (Zephyr) which is a test management tool.
• Prepare automated test cases using customized automation tool developed for GISMO team. The automation functions need to be reusable and not cause any performance degradation. The automation requirements are derived from the product requirements, functional requirements and technical specification documentation.
• Play a vital role in incorporating a creative approach to using latest technologies to provide an extensible automation infrastructure.
• 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

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 and SSRS