SUMMARY:

• IT professional with a bachelor’s degree in computer science, offering more than 15 years of extensive experience in Software testing and quality assurance. Expertise in the fields of software process improvement and quality testing. Known for excellent analytical capabilities with the ability to develop and implement QA standard Processes and Procedures to achieve quality goals and objectives.
• A detail - oriented, proficient, and performance-driven software professional with over 15 years of experience in the IT industry with over 10 years in team and software quality management.
• Over 15 years of experience in information technology as a Software QA professional experienced in testing and test management.
• Skilled in Analyzing and defining the quality Goals of the organization and defining the test team’s mission consistent with those goals.
• Experienced in coordination, negotiation, and motivation of the resources in support of timeline and project deliverables ensuring customer satisfaction.
• Experience in defining the Test Approach, Test Strategy, Test Plan, Testing Timeline, Level of effort (LOE)
• Expertise in understanding the Business process and developing and maintaining test cases, analyzing bugs, and interacting with the development team and middleware teams in fixing bugs.
• Good understanding of quality assurance testing methodology relative to the Business Analysis, Application Design, and overall Software Development Lifecycle (SDLC) & (STLC).
• Worked under various testing methodologies like Agile-SCRUM/Kanban and Waterfall Model.
• Hands-on experience in testing data warehouse migration using Azure Data Factory (ADF), Azure Data Platform services like Azure Data Lake (ADLs), Data Factory (ADF), and Data Lake Analytics.
• Expertise in Defect management, Bug tracking, Bug Reports, and generating graphs using Test Management Tools such as ALM/Quality Center, MTM, JIRA
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
• Proficient in documenting and executing test plans and test cases/test scripts for manual and automated testing.
• Project status meetings, brainstorming sessions, identifying requirements, walkthroughs, and inspection reviews.
• Performed test plan preparation, test case designing, test case review, test case execution, and reporting.
• Hand-on experience in functional, integration, regression, system, security, GUI, backend, browser compatibility ad-hoc, and black box testing.
• Hands-on experience in Web app testing (Functionality, Usability, Compatibility, Security) using manual testing and automation tools such as SOAP UI.
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Experience in Dimensional Data Modelling using Star and Snowflake Schema.
• Experience in testing Full and Incremental loads through ETL tools in different environments.
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, and Data Loading.
• Good in RDBMS concepts and experience in testing Backend using TOAD/SQL developer with SQL.
• Experience in testing the Business Intelligence tools like OBIEE, EPM 11, SAP Business Objects, Micro Strategy, Tableau, etc.
• Proficient in preparing reports with analyzing the defects concerning metrics.
• Proficiency in testing progress reporting, Defect tracking, and maintaining using management tools like Quality Center, and JIRA.
• Proven track record of meeting and exceeding customer needs as an individual contributor and as a team member in meeting critical deadlines. Can work independently and collaboratively within a diverse team. Significant experience in coordinating testing activities with off-shore Teams.
• Built a dynamic relationship with the client, development, and other teams to ensure the highest quality deliverable possible and to deliver them on time.

TECHNICAL SKILLS:

Testing management and Automation Tools: Microsoft Project (Project Management), Clarity (Project Fund Allocation), SailPoint, Selenium, and Java-based automation using TestNG, Jenkins, Maven, Postman, SOAP UI, QTP (Test Automation), HP ALM/Rally (Test Management), Star Team 4.2 (Bug Reporting /Tracking /Configuration Management).

Configuration Management: Sub Version (SVN), Rally, JIRA

Reporting tools: OBIEE, Business Object, EPM 11, Hyperion, IBM CognosMethodologies: Waterfall, V-Model, Agile, Verification, and Validation

RDBMS: Oracle, Sybase, SQL Server, DB2, Informix, Teradata

Languages Known: SQL, Visual Basic, VB Script, JAVA, Shell, SQL, PL/SQL

Defect Management Tools: ALM, HP Quality Center, Rally, Test Director, JIRA, Clear Quest, Microsoft Test Manager (MTM), QMetry

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Sr. QA Analyst

Responsibilities:

• Participated in requirements, Design, and technical functional specification review meetings.
• Developed and maintained Positive, Negative, and Boundary condition Test Scenarios, Test cases, and Test data for Functional, Integration, and Security Testing.
• Working with a cross-functional team including business analyst, Product Owner, and Agile team to discuss the GAP during requirements, design, backlogs, and used cases analysis.
• Analyze the Technical design specification documents, business rules, and data validation specifications to identify deficiencies in test plans and procedures and enhance test overage accordingly.
• Participated in requirements and functional specification reviews and walk through to ensure that the testability requirements are met.
• Conduct QA entrance and exit criteria meetings with project stakeholders.
• Actively participated in smoke, functional, regression, integration, and ad-hoc testing during QA and System Integration phases.
• Facilitated defect review meetings and improved existing defect management process, driven team to work in a faster manner by reporting defects status.
• Continuously supporting testing activities for the enhancements and production support for the different applications by testing and validation of proposed changes and defects resolutions.
• Worked on Agile Methodology framework concerning the change in application requirements to achieve the target in stipulated time.
• Develop the Test Plan, Test Scenarios to perform Smoke, System, Integration, and End to End testing.
• Developed and maintained Traceability between requirements and test cases to ensure that testability is met.
• Working with an agile team in the SCRUM framework.
• Involvement in the analysis of Backlogs, Specification Requirement Documents (SRD), and Design documents to write test cases in different Sprints.
• Support UAT testing and created defect guidelines documents for users using QMetry.
• Conduct meetings and walk through with users and junior team members to discuss the defect management process in QMetry.
• Generate and distribute test progress and defect status reports to the Management team.
• Write and use SQL queries to set up and validate test data.
• Write and execute the Test cases for Web apps diagnostics, accessibility, and compliant validation based on government-defined processes and procedures using the tools.

Environment: Fiserv CORE DNA, DNA UX, QMetry, Smartsheet, MS SharePoint, SQL Server 2012, Enterprise Performance Management (EPM) 11, SQL Developer, JIRA, Webservices, SOAP UI, API Testing, Oracle DB.

Confidential, Kansas City, MO

Sr. Data Test Engineer/Test LEAD

Responsibilities:

• Reviewed and analyzed the Requirements documents, Design documents, Data design/flow, and Data mapping documents and used test cases.
• Develop, review, and recommend a test policy and test strategy for the organization.
• Plan the test activities by considering the context and understanding the test objectives and risks. This may include selecting test approaches, estimating test time, effort, and cost, acquiring resources, defining test levels and test cycles, and planning defect management.
• Participated in Pre-migration preparation and defined the testing approach after data migration.
• Prepared and executed test cases to validate the initial data migration migrated through Azure Data Box.
• Developed the test cases to compare and validate the existing data after lift and shift to the cloud.
• Validated the Schema, Data types, data access security and compliance, data quality, and integrity.
• Validated ETL processing that populates Azure Synapse both into the data warehouse and from the data warehouse to data marts.
• Developed regression scripts for each test repeatable and enabling a consistent approach to evaluating results.
• Worked on Agile Methodology framework concerning the change in application requirements to achieve the target in stipulated time.
• Developed and maintained System, Integration, Security, and UAT Test plans.
• Developed and maintained Traceability between requirements and test cases to ensure that testability is met.
• Tested ETL components including Tables/View structure, Data conversion, Data Mapping between source to staging, Staging to EDW, and EDW to Data Mart.
• Validated Data Consistency, Data Completeness, Data Correctness, Data Accuracy, and duplicate data into Data Warehouse and DataMart.
• Validated the installation and configuration of Initiate MDM Engine, Web Sphere, Initiate MDM Workbench, and Initiate Inspector in the Test environment.
• Developed and executed the test cases to validate the Transformation rules, Records counts, Logical and Physical deletes, exceptions, and errors for different stages of ETL.
• Developed and executed test cases for data validation in Staging, EDW, DataMart, and Reports.
• Validated the access to the System - Security, navigation to a particular screen, dashboard, page, and report
• Validate access to the right data, screens, dashboards, pages, and reports, response time to access the application, particular dashboard, page, and report, capability and ease of using prompts to select data on a report with specific attributes, use of drill down and navigation on Reports for OBIEE.
• Prepare KPIs, and periodic reports and communicate to the management including current testing and defect status, Risk status with mitigation chart, Test coverage chart, Defect trends, Milestone, Project health indicators (red, yellow, green), Predictive metrics, and Go/No go recommendations.
• Documented software defects in the defect tracking system Quality Center and keep defects up to date.
• Wrote and executed SQL queries using SQL developer, TOAD, and Microsoft SQL Server.
• Conducted QA entrance and exit criteria meetings with project stakeholders.
• Prepared test progress and defect report and communicate to the management.
• Facilitated defect review meetings and improved existing defect management process, driven team to work in a faster manner by reporting defects status.

Environment: Azure Data Factory (ADF), Azure Data Platform services like Azure Data Lake (ADLs), Data Factory (ADF), Data Lake Analytics, ALM 11.5, DataStage, GIS, ArcFM, ODI, SQL Server 2012, OBIEE, EPM 11, SQL Developer, Web Client, JIRA, SQL Server, Webservices, SOAP UI 4.5, HTML, XML, API Testing, .Net, JAVA, J2EE, SharePoint, Confluence, Oracle, DB2, Informix, SVN.

Confidential, Greensboro, NC

Sr. QA Analyst

Responsibilities:

• Defined Test Strategy, Test Plan, and manage resources for software development projects.
• Ensured appropriate test coverage of business and application functionality through test cases.
• Established business process and test considerations knowledge throughout the development and testing process.
• Facilitated enhancements and change management and accommodates into Test plan and schedule.
• Reviewed/audited existing test plans and test cases; suggest improvements where applicable.
• Assisted the Product Owner and Business Analyst with developing acceptance criteria.
• Provide leadership to non-technical functional testers on a day-to-day basis by empowering the test team and teaching them how to design and implement testing tasks necessary to meet the project deliverables.
• Managed and maintain the defects in Quality Center and provide updates to the team daily.
• Created weekly metrics/reports to capture test progress for projects and releases.
• Handled testing efforts for multiple projects/releases concurrently.
• Provided effort estimates, cost resource estimation, and planning for all the feature releases.
• Created guidance for data load processes, QA processes, and data movement processes.
• Tested various financial reports using the OBIEE such as General ledger reports (Balance sheet, Cash flow, Budget Vs Actual, Asset Uses, Financial structure, GL Balance, etc.
• Developed and customized Excel reports and graphs using Quality Center Dashboard for reporting.
• Worked with JIRA and Quality Center tools admins to customize the tools to support the reporting requirements.
• Modifying and migrating test data from the caliper to DB2 and FPH for testing.
• Updated and validated the control -M job properties to simulate production scenarios.
• Wrote and executed SQL queries to compare and validate the historical table data affected by scripts.
• Used ICEDEQ tool to compare table data.
• Guided the development of the test cases to validate the ETL process, business rules, Data transformation rules, Report layouts, and data.
• Tested various financial reports using the OBIEE such as General ledger reports (Balance sheet, Cash flow, Budget Vs Actual, Asset Uses, Financial structure, GL Balance, Trial balance, etc.
• Developed and customized Excel reports and graphs using Quality Center Dashboard for reporting.
• Worked with JIRA and Quality Center tools admins to customize the tools to support the reporting requirements.

Environment: ALM 12.1, JIRA 6.3.7, OBIEE 10.1.3, EPM 11, DataStage, TOAD, Microsoft SQL Server 2013, SQL Server Management Studio, MS office 2013, Share Point, Subversion, SQL Server, Webservices, SOAP UI 4.5, HTML, XML, API Testing, .Net, JAVA, J2EE, SharePoint, Confluence, Oracle.

Confidential, Pittsburgh, PA

QA Lead/Test Coordinator

Responsibilities:

• Involved in the entire software Testing Life Cycle of the projects from Initiation to Implementation.
• Create test plans and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Tested various ETL Informatica transformation rules based on log files, data movement, and with the help of SQL.
• Maintained the test logs, test reports, test issues, and defect tracking using the Quality center.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
• Created and executed SQL queries to perform Data Integrity testing on an Oracle Database Performed Functional, Negative, Smoke & Regression tests as per design specs.
• Tested several complex reports generated by Business Objects including Dashboard, Summary Reports, Master Detailed, Drill Down, and Score Cards
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Tested Full load & Incremental load by entering the sample test data to a couple of entities and making sure Inserts & Updates of loading the data are done correctly.
• Written several complex SQL queries for validating Business Objects Reports.
• Tested Data stage Hashed files for extracting and writing data - an intermediate file in a job.
• Proficient in performance analysis, monitoring, and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints, and SQL Trace both in Teradata as well as Oracle.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Tracked bugs using Quality Center and generated the defect reports for review by the client and the management teams.
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: ETL Informatica, BI Business Objects, SQL, QTP, Quality center, Teradata, Teradata SQL Assistant, UNIX, SQL SERVER, Clear Quest, Oracle, PL/SQL, TOAD, Java, DB2, and UNIX.

Confidential, Richmond, VA

Test Engineer

Responsibilities:

• Worked as a test lead and managed a team of 10 testers including on-shore and Off-shore. Participate in project meetings to identify the goals and tasks of the testing team. Assign the task to the team members, and track the progress on team labels and individuals.
• Created test strategy and test plan for different phases of testing such as functional, interface, conversion, parallel, and interface testing.
• Created Manual and Automation Framework guidelines, Testing Flow, and Defect management guidelines.
• Provided Quality Center to the technical team, Functional Team, and user’s team.
• Successfully developed and executed conversion test scenarios to convert data from source tables (legacy) to target tables (Oracle).
• Successfully developed and managed the process/guidelines to successfully test the data conversion from source tables (legacy) to target tables (Oracle) and interface between third-party vendor's system and oracle system.
• Documented the business process and procedures with Tour and captured the application data entry steps with UPK.

Confidential, Wayne, PA

Quality Assurance Lead

Responsibilities:

• Wrote and modified functional documents for converting data from Legacy to Staging table and Staging table to install base according to business rules and validation using Oracle AIM Methodology.
• Wrote and Executed SQL queries using TOAD to retrieve the data from data tables to perform data validations and verifications.
• Logged ITR for any requests and issues (related to access permission, production, and business rules).
• Interacted and discussed with customers and the sales team to clarify and fix issues in production for different quotes.

Confidential

Sr. QA Engineer

Responsibilities:

• Analyzed system requirements and was involved in developing test plans, test cases, and test schedules based on high-level and detailed designs.
• Involved in Business rules and use case documents review of different modules of the application.
• Involved in preparation of test data using Excel Sheet for End-to-End Scenario-based testing.
• Reported overall status to all stakeholders (Internal & External).
• Formulated Master Test plans, Test cases, and Test scripts.
• Created test logs and test results Summary reports and send them to developers.
• Cooperated with and provide technical support to project team members and co-workers.
• Developed and maintained proficiency in technical and analytical tools as defined by company standards.
• Provided project status reports to users and data processing management.
• Developed accurate documentation that complies with company standards.