SUMMARY

• Around 10 years of experience in Software Testing and Management.
• Expertise in Test Management, Planning and Testing projects on different methodologies (Agile - Scrum, V Model, Waterfall).
• Expertise in Automation, Web and BI/ETL Testing.
• Experience in Project Estimates, Scoping and Resource Management.
• Experience in setting up Team on Onshore Offshore model and QA Process Identification, Implementation and Optimization.
• Experience in Test management and Automation tools like HP ALM, SOAPUI, QC, QTP, Selenium, Loadrunner and JIRA.
• Experience in creating QTP Automation framework and executing Automated test scripts.
• Proficient and diverse work experience in Manual, Automation, ETL, System (SIT), Exploratory, Acceptance (UAT), Regression, Integration, Interoperability, Functional and Usability Testing.
• Experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export.
• Experience in Data Modelling, Client Server (Pl/Sql) development, ETL Migration, Reporting and Production Support.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good Leadership qualities and People Management skills.
• Sound in Analytical Skills and Requirement Analysis.
• Excellent communication, interpersonal skills.
• Experience in Software Testing, Application Management, Development, Production Support, Enhancement and Maintenance.
• Experience in working with Business Users, Senior management and External Vendors.
• Experience in creating Support Documentation and providing Business Trainings.
• Experience in working with clients with different geographical orientation: US, Australia, India and Middle East.
• Experience on Financial Services, Banking, Lending and Leasing, Wealth Management, General Insurance, Higher Education and Travel domains.

TECHNICAL SKILLS

Tools: Erwin, Oracle Warehouse Builder, Informatica, Business Objects, Rapidminer, FM Model SSRS,SSAS, SSIS, Tableau, Powerbuilder, Toad, PL/SQL Developer, Hadoop, Hive, PigVSS, Microsoft Suite, Appworx, Remedy, Calibre, HP ALM, JIRA, HP Quality CentreUFT, SOAPUI, Eclipse, QTP, Software Planner, Test Director

Databases: Oracle 11g, MYSQL, Sybase, Hadoop,DB2, SQL Server, Teradata

Languages: PL/SQL, Unix Shell Scripting, Groovy, .NET,C++, Visual Basic, HTML

Domains: BFSI, Travel, Healthcare, Insurance and Higher Education

PROFESSIONAL EXPERIENCE

Confidential, NJ

QA Lead

Responsibilities:

• Setting up the QA process, Team and Test Artefacts in accordance with Scrum methodologies.
• Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Create detailed documentation (Design specification, Data mapping, Data flow and sequence diagrams) and verify data mapping.
• Creation of Test scenarios, Test cases, Test data identification & Test execution.
• Analyse Hadoop cluster and different Big Data analytic tools including Hive, Sqoop and Hbase database.
• Perform data validation in HIVE using HIVEql.
• Perform Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer.
• Participate in QA build deployment, code reviews and version controls in TFS.
• Create adhoc reports to users in Tableau by connecting various data sources.
• Build, publish customize interactive reports and dashboards using Tableau.
• Present dashboards and reports based on the customer needs.
• Develop process for Data Analysis and testing Data flow.
• Investigate data anomalies and perform Root Cause Analysis (RCA).
• Identify, analyze, and document problems with functionality, output files or table.
• Extract, manipulate and analyze large datasets of Mynewshub and present the findings in a simple and understandable format.

Confidential

Automation QA Consultant

Responsibilities:

• Quality Assurance, Test Team Management, Test Estimation, Resource Planning.
• Implement Scrum Principles in the projects and drive Daily Scrum Meetings.
• Facilitated Pre-Grooming Activities to help the Sprint start on time by resolving all the impediments before Sprint Start.
• Coached and mentored other agile team members and provides best practices and not so good practices.
• Conversion of business CTQ’s to IT requirements, Design, Testable Use Cases.
• Identifying the Automation scope and modules.
• Creating Automation Test strategy.
• Identifying and creating the Automation test cases using Keyword driven methodology.
• Leverage Quality Center to Test Modules using Unit Test Cases, Use Cases and Functional Test Cases.
• Install, configured SOAP UI to test web services using WSDL file given by Development team.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
• Verify XML extracts as per the standard schema provided.
• Verify XML for correct values, tags, data elements, sequence and order.
• Use XML spy to validate XML against the Standard XML schema.
• Verify the application if the correct values are displayed after a change made in XML and the functionality is working as per the business requirement.
• Executing the Automated test scripts and verifying the Logs in case of failures.
• Analyzing Selenium to replace QTP as the main Automation tool.
• Perform functional testing to identify various critical points in the application and automated it by using Selenium Webdriver.
• Create selenium based scripts using JUnit.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
• Prepared and executed of test scripts using JMeter and SOAP UI tool to perform Web Services testing.
• Performing Mobile App testing.
• Monitoring and managing the Testing environment.
• Identification and Implementation of Automation and Operational Testing Tools.
• Educating the users with the product and for its testing, Integration, Functional and User Acceptance testing.

Confidential

QA Lead

Responsibilities:

• Overall responsibilities for the Software Testing team deliverables and it' successful completion.
• Test Team Management, and Test Estimation.
• Automation Test Strategy Creation and Reviews.
• Assess Project risks at regular intervals during the course of project.
• Maintaining the QTP test scripts and customizing it as per the new business changes.
• Regular Test Status Reporting, Peer Reviews, weekly Defect Triages.
• Implemented a backup process for the automation framework reducing test script and data loss to zero.
• Enhanced automation framework effectiveness by using HP Quality Center 10.0 to schedule test execution through a remote test environment, sharing test status reports, and improving test data management.
• Connected remotely to UNIX servers using PUTTY and FTP files across different test environments by using Hummingbird and Command prompt.
• Ran the batch jobs using client component Ascential Datastage Director for validates jobs, schedules jobs, runs jobs and monitors jobs.
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules.
• Defect Management in JIRA.
• Coordination between multi vendors and different teams.
• Worked with subject matter experts to extract domain knowledge, business rules and decision processes.
• Engage Business users for UAT strategy reviews and approvals.
• Educating the users with the product and for its Integration and Functional testing.
• Identification and Implementation of Automation and Operational Testing Tools.
• Work with the business units to establish KPIs and methodology, and then create the appropriate reports and analysis.

Confidential

BI QA Lead/ Specialist, Business Analyst

Responsibilities:

• Manage and Lead all testing activities in an integrated Scrum team, working parallel with other Scrum teams.
• QA Process Identification, Implementation and Adherence for Business Intelligence track.
• Review product backlog, Track progress in Kanban and provide test effort estimates during Sprint planning sessions.
• Data warehouse-Cognos Report testing, Certification, and Integration testing.
• Report Load testing.
• Requirement and Impact Analysis.
• Test Metric Reporting.
• Creation of requirement documents for Cognos Report and ETL specific technical enhancements.
• Creation and maintenance of Test Suites and Test Scripts for Reports, Cubes, Databases, Software and Applications in Quality Centre, Software Planner.
• Integrated QTP with Quality Centre and scheduled running of QTP scripts in batch mode from the Quality Centre.
• Execution of Test Cases using SQL scripts.
• Work with Testing COE as SME for Datawarehouse testing.
• Create user helpdesk documentation for finished product; help with end-user training and knowledge sharing.

Confidential

QA Manager

Responsibilities:

• Quality Assurance, Test Team Management, Test Estimation, Resource Planning.
• Monitoring and Tracking the Test cycle, Organizing Test kick-off and Test team meetings.
• Review of Project plans and all project artefacts as defined in PMP.
• Preparation of QA strategy and Test Plan.
• Preparation of Automation and Performance Test Strategy.
• Reporting weekly testing activities to IT Project and Business managers.
• Risk identification and documentation (FMEA).
• Defect Management, Co-coordinating and monitoring Peer Reviews & Testing.
• Testing module setup in Enterprise Architecture tool, Verification of Use Case models.
• Requirement gathering, Creating and Maintaining Test Cases in Quality Centre.
• Meet with the business users and understand requirements, goals, document as-is and to-be functionality and business flow

Confidential

Automation Test Lead

Responsibilities:

• Lead a team of 16 QAs working on different products.
• Preparation of Automation QA strategies and Test Planning.
• Creation and Maintenance of QTP Automation Framework and maintenance of Load runner scripts.
• Creating Automation Scripts (VBScript) in the sprints.
• Creating the standard library for functions and sub-procedures.
• Using Global/Local - Test/Action Parameters and Data-Sheets to create data-driven testing.
• Implement Verification & Validation activities for a project as per the project plan.
• Regular Test Status Reporting and Defect Triage with BA and project heads.
• Creation of Test Cases in Quality Centre and hands on Client Server and Database Testing.
• Organizing, Co-coordinating and monitoring Peer Reviews & Testing.
• Test Environment Management.

Confidential

QA Lead, Onsite Test Coordinator, Business Analyst

Responsibilities:

• Setup of Onshore - Offshore model for Testing team.
• Organizing the testing workflow in par with implementation of Lean, Six Sigma and Agile methodologies.
• Reporting weekly activities to Test Coordinator, Delivery Assurance Manager & Project Leader.
• Testing artefact management in Quality Centre, Estimations, Reporting and Test Planning.
• Team management, Offshore resource planning for different assignments.
• Driving the defect meetings.
• Monitored and managed the testing environment.
• Test summary preparation, Support trouble shooting in the application.
• Mentoring and induction of new team members.
• Quality Controller/ Reviewer.
• Database, Functional and Automation Testing.
• SQL Scripting for automated test scripts and test data creation, Automation scripting in QTP.
• Detailed analysis of the requirements, documentation, test cases preparation, coding and testing.
• Production Support: Bug fixing with SLA of 2 hours and providing assistance to resolve the aborts in daily chains executing in production