SUMMARY

• Over 15+years of experience in SoftwareQuality Assurance on different platforms
• Expertise in testing Web based, Client Server, N - tier Applications
• Proficient in analyzing Business/System requirements and Use cases
• Experience in prioritizing requirements and resolving conflicts among gathered requirements
• Good knowledge on SDLC Methodologieslike Waterfall and Iterative methods
• Expertise in defining test methodology, creating test plans, preparing documentation and implementing test strategies during Software Development Life Cycle (SDLC). Knowledge and experience in every phase of Quality Assurance Life Cycle (QALC)
• Expertise in implementing established standards/procedures/QA methodologies; design, manage and maintain overall testing framework, test planning, test design, building/executing/automating tests; develop/execute detailed test cases and report test results
• Worked closely with Change Management, Data and Environment Teams
• Strong expertise and knowledge of Integration, System, Functional, Regression, Performance, Load, Stress, Smoke/Sanity, User Acceptance Testing
• Expertise in both Manual, Automated testing of Web-Based applications and Client-Server applications
• Proficient in using HP’sTest Management ToolQuality Center/ALM, JIRA, Confluence, Sharepoint for Test Planning, Requirements management, Defect tracking and Reporting
• Analyzing the Defects and interacting with the developer’s and team members in fixing the defects
• Extensive experience in Backend testing and ETL Testing using SAS DI, Informatica, Datastage, PySpark jobs and verify the data loaded to Oracle, SQL Server, HP Neoview, Greenplum,Teradata, Snowflake databases to check the data integrity
• Extensive experience testing BI reportsusing technologies like Tableau, SSRS, Micro Strategy, Business Objects
• Experience performingAPI testing using Swagger & Postman
• Expertise in writing SQL queries against the database to verify the data correctness and accuracy
• Developed Automated functional test scripts using QTP by creating check points, data table, break points and adding user defined functions
• Involved in creating test scripts for web-based applications for automation testing using Selenium IDE/Webdriver
• Involved in conducting cross browser and Cross Platform testing to check the compatibility of the content with different Browsers like IE, Netscape, Safari and Mozilla Firefox
• Involved in testing OracleRetail SCMSuite application Oracle Retail Merchandising system implementation replacing legacy IBM Mainframe application and data migration
• Expertise on working with MicrosoftOffice Suite (Word, Excel, Power Point)
• Successfully facilitated Test Plan, HLTC, Test Case and Defect review meetings
• Excellent problem-solving skills with strong technical background, quick learner and excellent team player with great interpersonal skills and ability to meet tight deadlines under high pressure

TECHNICAL SKILLS

Testing Tools: HP Quality Center/ALM, QTP, HP Performance Center, Load Runner, Selenium IDE/WebDriver, JIRA

Databases: Oracle, MS SQL Server, HP Neoview, Greenplum, Teradata, Pentaho DW, Snowflake

ETL Tools: MS SQLServer Integration Services (SSIS), Informatica Power Center, SAS DI, DataStage, Pentaho, TalendOpenstudio, PySpark

BI Reporting Tools: IBM Cognos, OBIEE, MS SQLServer Reporting Services (SSRS), Business Objects, MicroStrategy, Tableau

ERP/SCM Tools: Oracle Retail Merchandising System (ORMS)

Web/App Servers: IBM Web Sphere, IIS, Apache

Programming Languages: SQL, PL/SQL, C, C++, HTML, Postgresql

Microsoft Tools: MS excel, MS word, MS Visio, MS Project and MS PowerPoint Studio.

Database Tools: Toad, SQL Server Management Studio, DB Visualizer, SQL Developer, Teradata SQL Assistant, DBeaver

Operating System: Windows 2010/2007/2000/ XP, UNIX, LINUX

Scheduling Tools: Maestro, Autosys, CA Workload Automation (CAWA), Airflow

PROFESSIONAL EXPERIENCE

Confidential, Burbank, CA

Lead QA Engineer

RESPONSIBILITIES:

• Define test strategy, test scenarios, and write test scripts that follow real world business scenarios using both manual and automation techniques
• Write complex SQL queries to perform data validation on Snowflake DB for the data loaded by both Talend Open studio and PySpark jobs which are integrated to the Airflow(DAG’s)
• Validate the KPI data used by business for the reporting needs
• Verify that the data is extracted and loaded correctly from the different internal payroll and accounting sources systems like CC payroll, hours+, HTG+, CAPS Payroll system etc.
• Identify and troubleshoot data inconsistencies and validate the referential integrity of the database tables
• Generate the ad-hoc reports by writing complex SQL queries and build scheduled reports using SSRS and Tableau
• Verify that the Tableau reports are fetching data from snowflake and the data in the report matches the data in the DB by writing SQL scripts as per the business requirement
• Perform API testing via the Postman and verify the front-end integration of the application
• Work closely with business stakeholders to understand the details of new requirements and any enhancement requests to create effective test suite for both automation and manualtesting
• Work closely with the automation engineers to implement automation framework for application automation
• Train and coordinate User Acceptance Testing (UAT) with the business stakeholders
• Work closely with other QA team members to refine testing practices and ensure effectivenessof the QA deliverables
• Work with development team members to proactively identify, communicate and resolve issues and risks that impede the execution and/or success of testing
• As a scrum master host, the daily scrum’s, technical/design sessions, grooming sessions, sprint planning and sprint retrospective sessions and also coordinate with dev-ops and other internal groups to resolve any requirement, process, environmental and infrastructure related issues
• As a scrum mastermanage the sprint/product backlog and create story tickets as needed to prioritize product features and capabilities to align with business needs
• Work closely with DEV & QA to make sure team follows the agile processes defined
• Participate in requirement gathering sessions with business stakeholders both internal and external teams
• As a release manager, manage the release process and coordinate the releases to UAT &production and update the weekly status reports for the leadership/executive management teams
• Document the release notes, release plans and work closely with dev team to create the deployment checklistfor a successful production deployment
• Perform postproduction deployment verification
• Coordinate, collaborate with offshore team to help them understand the business requirements to meet the project deliverables

ENVIRONMENT: Windows 10, Unix, Tableau, Talend Open Studio, Snowflake, My SQL, MS SQL Server, PostgreSQL Oracle,React, NodeJS, Elastic Search, Python, PySpark,SQL Server Reporting Services, RESTful Webservices, Postman, Selenium, Jira, Confluence, AWS, Airflow, Docker, Material UI, Azure DevOps

Confidential, Burbank, CA

QA Engineer

RESPONSIBILITIES:

• Involved in extensive Interface testing to generate files for the major clients to feed in to their SAP, Oracle systems for reporting
• Involved in extensive API testing via Swagger
• Involved in validation of the Business Objects Reports for both the data and the report parameters and filters to verify that the data is flowing in to the reports as expected
• Involved in refreshing the Test DB environments with the data from Prod database for testing any production patches
• Worked in Agile project environment for rapidly changing or highly emergent requirements and following parallel development and testing
• Involved in the design of Test Plan, Test Casesbased on the requirement specifications as per the JIRA stories to validate the data and features
• Created and executed the complex SQL queries using MS SQL Server Management studio to verify the data load after the successful job completion
• Involved in testing both Incremental load and Full load by running the Pentaho jobs and making sure that the DB tables are correctly performing theInserts, Updates, Deletesof the data as per the transformation logic
• Involved in testing various JIRA’s that were created as enhancements to the existing components and signing off to release the components to Production
• Extensively used JIRA and Confluence for both Test Management and Defect Tracking for Test Planning, Test Scripts creation and Defect’s creation
• Extensively interacted with the developers and users to resolve technical issues and tracked defects.
• PerformedRegression testingto test the impact of bug fixes
• Prepared Test Status Summary Reports with details of executed, passed and failed test cases
• Coordinatingwith both the onsite and offshore teams in meeting the project deliverables and project deadlines
• Involved in providing training to both UAT and CAT and providing necessary support for users to perform CAT testing

ENVIRONMENT: .Net, Business Objects, Windows 2010, MS SQL Server 2014, Jira, Microsoft Office Suite 2010, Service Winmerge, Confluence, JSON, Swagger, AWS, Pentaho DW, Jenkins, Unix, Mingle, GitHub, Rabbit MQ, Microservices

Confidential, San Francisco, CA

ETL/BI QA Lead

RESPONSIBILITIES:

• Involved in extensive ETL Testing, System Testing, Shakeout Testing, BI Reports Testing and UAT Testing
• Involved in executing the Datastage jobs thru UNIX (shell scripts) command line and verifying the success/failure of the jobs executed
• Involved in understanding and analyzing job failures by looking in to the Teradata BTEQ script logs
• Involved in validation of the Microstrategy Reports for both the data and also the report prompts and filters to verify that the data is flowing in to the reports as expected
• Involved in refreshing the Test DB environments with the data from Prod like database for both Facts and Dimensions
• Worked in Agile project environment for rapidly changing or highly emergent requirements and following parallel development and testing
• Analyzed the transformation logic in the Source to Targetmapping document and validated the DDL, Counts, Not Nulls, Duplicates, Referential Integrity on both Fact and Dimension tables
• Involved in the design of Test Plan, Test Casesbased on the requirement specifications as per the JIRA stories to validate the data
• Involved in creating the QA Stories corresponding to the Dev stories and documented the test results in JIRA stories
• Involved in job schedule execution using the job scheduler CAWA
• Created and executed the complex SQL queries using Teradata SQL Assistant to verify the data load after the successful job completion
• Involved in validation of the XML job output files
• Involved in testing both Incremental load and Full load by running the jobs and making sure that the DB tables are correctly performing theInserts, Updates, Deletesof the data as per the transformation logic
• Involved in testing various JIRA’s that were created as enhancements to the existing components/jobs and signing off to release the components/jobs to Production
• Involved in verifying the updated the job schedules as and when new jobs were added and dependencies in CA Workload Automation scheduling tool
• Extensively used JIRA and Confluence for both Test Management and Defect Tracking for Test Planning, Test Scripts creation and Defect’s creation
• Extensively interacted with the developers and users to resolve technical issues and tracked defects.
• PerformedRegression testingto test the impact of bug fixes
• Prepared Test Status Summary Reports with details of executed, passed and failed test cases
• Coordinatingwith both the onsite and offshore teams in meeting the project deliverables and project deadlines
• Involved in UAT testing, UAT training and providing necessary support for users to perform UATMicrostrategy Reports validation

ENVIRONMENT: Teradata, Teradata SQL Assistant, Datastage 8.5, Unix, Windows 2008, Altissan Jira, Serena Dimensions, MicroStrategy 10.1, Microsoft Office Suite 2010, Service Now, SVN, WinScp, Altissan Confluence, CA Workload Automation (CAWA)

Confidential, Burbank, CA

ETL Test Lead

RESPONSIBILITIES:

• Involved in extensive ETL Testing, Integration Testing, Functional Testing, Component Testing, Conversion Testing, Negative Testing, Assembly Testing
• Involved in executing the ETL SAS and Informatica jobs thru UNIX (shell scripts) command line and verifying the success/failure of the jobs executed and also performed thorough analysis in case of job failure by verifying the logs of both Informatica and UNIX jobs
• Involved in understanding theETL workflowsandETL mappingsand also monitoring the jobs in QA Environment
• Involved in testing the Informatica Mappingsand worked with staging area to validate the data by writing SQL queries and also validated the source system data from the source files with the staging using SQL queries
• Coordinated in setting up Test Environments and Test Plan needs with team members
• Involved in jobs execution of ETL Informatica workflows in both WINDOWS and LINUX environment thru UNIX command lines
• Involved in testing the SAS jobs and verifying the outputs created by jobs
• Analyzed the transformation logic in the Source to Targetmapping document and validated the DDL, Counts, Not Nulls, Duplicates, Referential Integrity on both Fact and Dimension tables
• Analyzed the source data systems and validated source files based on the source file workbook specifications in both Database and also the source files in UNIX
• Involved in the design of Test Plan, Test Cases, and Test Executionbased on the Source to Target mapping specifications to validate the platform data
• Created and executed the complex SQL queries using DB Visualizer for both HP Neoview and Greenplum database to verify the data load after the successful job completion
• Created and executed SQL queries on SAS DATASETS created by the SAS DI Jobs
• Involved in testing both Incremental load and Full load by running the jobs and making sure that the DB tables are correctly performing theInserts, Updates, Deletesof the data as per the transformation logic
• Created Maestro schedules and updated the schedules as and when new jobs were added, and dependencies were updated in the Maestro scheduling tool
• Extensively used of HP QualityCenter/ALMand JIRA as Test Management & Defect Tracking Tools for Test Planning, Test Scripts creation and Defect’s creation
• Extensively interacted with the developers and users to resolve technical issues and tracked defects.
• Worked in Agile environment for rapidly changing or highly emergent requirements and following parallel development and testing
• Prepared Test Status Summary Reports with details of executed, passed and failed test cases

ENVIRONMENT: HP Neoview, Greenplum, DB Visualizer 9.1, Unix, Linux, Windows 2008, HP Quality Center 10.0/ALM 12.0, Jira, Informatica PowerCenter 9.6, Maestro, SAS DI 9.4, SAS Enterprise Guide 4.3, Microsoft Visio, Microsoft Office Suite 2010, HP Service Manager, Service Now, SVN, WinScp, Sharepoint

Confidential, Katy, TX

QA Lead Tester

RESPONSIBILITIES:

• Involved in both Functional Testing, System Integration Testing, End-to-End Testing, ETL Testing, BI Testing Security Testing, UAT Testing and Smoke Testing involving both Client/Server applications and Web-based applications
• Analyzed the business requirements and worked closely with the BA’s to get clear understanding on the requirement documentation like the BPD’s, BSR’s, SDD’s and FSD’s and develop the High-LevelTest scenarios, Test cases and design Test Plan to ensure applications are tested as per the business specifications
• Involved in testing the handheld RF Scanner(emulator) used for scanning the barcodes on the items before the items are added to the inventory
• Involved in automating the test scripts using Selenium IDE/ WebDriver and enhanced scripts where needed to meet the business requirements
• Involved in inspecting HTMLobject properties/locator’s (ID, Name, Link etc) using the Firebug Add-on on Mozilla Firefox
• Created automation test scripts in Java using Eclipse IDE and executed the test scripts using Junit annotation
• Developed test scripts for Data driven testing using parameterization in Selenium by using Excel sheet for test data
• Involved in extensive Datastage ETL testing by running batch jobs and verifying the source and target database tables by writing SQL queries for any data discrepancies
• Verified the XML messages generated for the transactions which are real time in the DB2 database
• Verified whether the data has been populated in the appropriate databasetables by running the SQL queries based on the mapping document provided by the Developers after a successful ETL job
• Verified the Error Logs produced when there is an ETL Batch Job failure and worked closely with the ETL (ESB and RIB) developers on the issue resolution
• Involved in extensive Interface Testing of various applications to make sure that all the interfaces are able to subscribe and publish the data from the upstream and send it to the downstream by running the SQL queries
• Extensive experience writing SQL queries and verifying the data accuracy on the real-time transactions against the Oracle and DB2 databases
• Conducted Defect Triages and Defect Review meetings involving the Developer’s and DBA’s in order to resolve the defect

ENVIRONMENT: HP Quality Center 10.0, Oracle 11i/11g, Windows XP, Microsoft Office Suite, Microsoft Visio, Java, J2EE, Junit, XML, HTML, SAS, Oracle Retail Merchandising System (ORMS), IBM Mainframes AS400, Netezza, DataStage, Oracle SQL Developer, DB2, Warehouse Management System(WMS), Store Inventory Management System,Retail Sales Audit, PeopleSoft stock Ledger/AP/ GL, Retail Invoice Match, Eclipse 2013, Selenium IDE/Webdriver 2.3, Firebug

Confidential, San Ramon, CA

QA Test Lead

RESPONSIBILITIES:

• Involved in Regression Testing, End-to-End testing, Functional testing of Client-Server, Web Based and IBM Mainframe AS400 applications
• Developed the High-LevelTest scenarios, defined the Test cases and designed effective Test Plans to ensure applications are tested as per the business specifications
• Involved in loading the Detailed Test Cases, Business requirements in HP Quality Center
• Developed the Traceability Matrix as per functional specifications
• Involved in testing the network services/alarms/features like Multicast, MultiGigE, 802.3ah, 802.1ag, SNMP, Traps, SCP, DWDM Rings, MPLS Pings, LACP Traps etc involving various Network Elements like NTE, EMUX, ADTRAN, IPAG1/IPAG2, VPLSPE devices
• Involved in extensive Business Objects Reports Testing (Web Intelligence/Infoview) to verify if the data and the corresponding attributes are populated correctly in the reports and are accurate
• Involved in writing SQL queries against the Database to verify if the Business Object reports are displaying the correct data using the UI tool TOAD
• Involved in testing AOTS Remedy (BMC Remedy user) client tool which is used to create service assurance tickets when a trouble is reported in the network (Auto Tickets) and customer reported tickets (Manual Tickets).
• Performed Load testing using Performance Center
• Designed test sequences to test loads between highest performance and peak level usage
• The average CPU usage response time hits/sec are analyzed for each scenario
• Gathered the results from each test run and conducted in depth analysis on the transaction response times and performance of each server
• Generated detailed reports that include graphs and tables for various performance object counters and application transaction times
• Involved in Backend testing of the database by writing SQL queries to test the integrity of the application
• Worked and coordinatedwith both the onsite and offshore teams in meeting the project deliverables and project deadlines

ENVIRONMENT: HP Quality Center 10.0/9.2, Oracle 10g, TOAD, Windows XP, Microsoft Office Suite, HP Performance Center, SAP, Java, J2EE, XML, HTML, Business Object 6.0, IBM Mainframes AS400, DB2, BMC Remedy User, Altova XML Spy

Confidential, Baltimore, MD

QA Analyst

RESPONSIBILITIES:

• Involved in Functional Testing, Regression Testing, Backend Testing, End-to-End testing and System testing of various ETL jobs designed using Informatica PowerCenter
• Created and executed functional and regression test Scripts using QTP
• Created Test plan, Test Cases, Test Scripts for all the modules in Quality Center
• Performed Backend testing of the data base by writing SQL queries to test the integrity of the application
• Assisted in training the UAT users upon implementation of the developed system to familiarize them of its functions and operations
• Worked closely with the Architects, Business Analysts, Developers and DBA team forknowledge sharingandto resolve issues
• Coordinated with the client and ensured their additional requirements and modifications were updated and implemented in the application
• Created and maintained Regression Test Scripts for overall business process and executing them in QA Environment as well as Production Environment
• Tested application security features, including session expiry, passwords and compatibility across multiple browser types
• Involved in conducting cross browser and Cross Platform testing to check the compatibility of the content with different Browsers like IE, Netscape, Safari and Mozilla Firefox.
• Communicating with management, customers, and other stakeholders for updates and to resolve issues

ENVIRONMENT: Informatica PowerCenter, C#, VB.NET, ASP.NET, IIS, HTML, DHTML, XML, UML, Windows XP, Oracle10g, SQL Server 2005/2008, QTP, Quality Center 9.0/9.2, MS Office.