SUMMARY:

• Overall 15+ years of professional experience in Banking, Finance, Insurance, Retail, HealthCare, Pharmaceuticals sales and IT Industry with specialization in Software Testing using Manual Techniques.
• 10+ years of experience in BI - ETL, Report Testing, Integration, Regression, UAT, Automation, DevOps - Continuous Testing, RESTful API Services Testing, ATDD, BDD Testing, Mobile Apps Testing and End to End testing (DWH/DB /DWH Migration and Functional Testing) and 3 years of Production Support and maintenance.
• Well acquainted with all phases of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile and V Model, specialization in Verification and Validation.
• Working knowledge in multiple areas of Software Testing life cycle including Test Project Management, Project Estimation, and Test Planning, Test Scripting, Test Execution, Bug Tracking, Review and Metrics collation.
• Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification (FRS), Design Documents, Use Case Specifications, and User Stories.
• Experience in User Acceptance Testing, GUI Testing, System & Functional Testing, Ad-hoc testing, Black Box Testing, White Box Testing.
• Experience in Defect management, defect analysis and defect reporting using various Defect Tracking Tools.
• Experience in DevOps Continuous Integration Testing and Mobile Testing.
• Experience in Data Warehouse projects specializing in ETL testing, Database testing and Reports testing.
• Good exposure in writing SQL Queries to perform data driven test validation. Exposure in working with front-end and back-end testing.
• Exposure working with .Net and Mainframe applications testing.
• Learnt and implemented Java Cucumber framework automation and with Selenium WebDriver.
• Knowledge on working with Hadoop Ecosystem stacks including HDFS, Sqoop, Pig and Hive.
• Exposure working with Tool configuration & Customization Testing for E-Commerce platform.
• Excellent Analytical, Problem Solving and Documentation skills including Team leadership coupled with aptitude to motivate team members towards goals, and Strong interpersonal, written & oral communication skills and capable to work on multiple project/product assignments.
• Lead teams of testers from team size 10 to 20 people, managed small to medium size projects, and have experience in interacting with offshore teams, onsite teams, client’s counterparts.
• Received several organizational level awards and recognitions.

TECHNICAL SKILLS:

Operating System: HP Unix, Windows 2000Professional/NT/XP, and MSDOS

BI/ETL Tools: Informatica, Ab-Initio, OBIEE, Cognos, SSRS, Netezza, MicroStrategy

Testing Tools: HP-Mercury Quality Center, JIRA, HP UFT, Cucumber - Gherkins, SOAP UI, Selenium

Version Control Tool: SharePoint, GitHub, TortiseGit

Database: ORACLE 8i/10g, SQL Server, Teradata, MongoDB

Testing Types: Black Box, Functional, Integration, System, Regression, User Interface, Database, DWH/ETL, Mobile and DevOps Continuous Integration Testing, Mobile Apps Testing

Programming Languages/Tools: Java, SQL, TOAD

Financial Planning Tool: JustEnough & T4G FP

Retail Suite: NetSuite

Agile Management Tool: VersionOne, JIRA

Analytics Tool: Actimize - Risk Case Manager (RCM)

Build Management Tool: Jenkins

PROFESSIONAL EXPERIENCE:

Confidential, Hoffman Estates, IL

Test Lead

Responsibilities:

• Involved in the requirements gathering session, analyze the functional requirements and estimate the technical efforts required.
• Interaction with the business users to understand their suggestions and doing technical feasibility study for the same.
• Developed highly Test Scenarios, implement validations and business requirement using best practices and methodologies.
• Worked on OBIEE tool, Teradata, Informatica, Oracle 11g, HP ALM
• Preparing Test Plans, Metrics and risks. Execute and monitor jobs to load data from source to target.
• Develop SQL Queries in Teradata, and Oracle DB to validate data from source to target.
• Interacting with Business Team for Integration Testing and User Acceptance Testing.
• Training and Mentoring of other team members.

Confidential, Cary, NC

Project Lead

Responsibilities:

• Regular Interaction with client and business users to understand the requirement and set up quality process translation in Software implementation.
• Involved in preparing Test Plan, Test Cases, execution of Test Cases and Timelines for the projects and conditioning test data.
• Learnt and implemented Java Cucumber framework automation for the report generation testing.
• Involved in writing features files using Gherkins to automate the report generation for Continuous Integration Regression Testing.
• Building the reports with parameters and running through Jenkins.
• Worked on RESTful API web services testing.
• Worked in Acceptance Test Driven Development testing.
• Defining the Scope of testing within the context of each Sprint release / delivery.
• Identifying Issues/defects and tracking them till the resolution, Root Cause Analysis and possible solutions for errors encountered and Preparing Status Report.
• Providing testing statistics and metrics to Client and to the project Management.
• Co-coordinating with offshore team and multiple vendor Development team.

Confidential, San Ramon, CA

Project Lead

Responsibilities:

• Participate in Requirement Gathering meeting and provide inputs to business teams on testing approach and feasibility.
• Lead Test Estimation, test design, test execution with respect to testing standards, tools and platforms.
• Design and modify test plan, test strategy other test life cycle documents.
• Involved in writing SQL queries using TOAD/SQL developer to validate the data mapping.
• Create traceability matrix between requirements and test cases.
• Coordinate with other teams for issue resolution and clarification.
• Develop test summary report based on the defined template to close testing phase on the project.
• Participate in the release control process (when the application is transferred from the build team to the test team) to ensure that solutions meet business requirements.
• Work on innovative solutions and process improvements ideas.
• Onsite team management, customer coordination and interaction.
• Worked on Team Work plan and resource management.
• Provided value propositions in terms of existing capabilities and new technologies.
• Proactive identification of newer opportunities in & around the current engagements.

Confidential, Richmond, VA

QA Lead

Responsibilities:

• Working as Test Lead and onsite co-coordinator for two PODS in the project, involved in prioritizing multiple tasks between two PODS and ensuring task completion within the assigned sprint.
• Involved in preparing Test Strategy, Test Approach document for all releases.
• Involved in performing analysis for Business Requirements, functional and system requirements. Involved in designing detailed test cases for System and Integration testing phases.
• Managing end to end testing requirements and involved in performing System Testing, Integration Testing, User Acceptance Testing and Regression Testing for all the releases.
• Defining the Scope of testing within the context of each release / delivery.
• Involved in writing SQL queries using TOAD/SQL developer to validate the data mapping.
• Worked on RESTful API/SOAP web services testing.
• Worked in Acceptance Test Driven Development testing.
• Involved in writing shell script to automate standard Alert Ingestion of Redesigned Rules.
• Involved in setting up UAT environment and assist business users on the test execution by preparing test scenarios, identifying test data and performing test execution.
• Identifying Issues/defects and tracking them till the resolution, Root Cause Analysis and possible solutions for errors encountered and Preparing Status Report.
• Co-coordinating with offshore team and multiple vendor Development team.

Confidential, Framingham, MA

QA Lead

Responsibilities:

• Regular Interaction with client and business users to understand the requirement and set up quality process translation in Software implementation.
• Involved in review of all documentation (BRD, SRS) relating to the given Project.
• Involved in preparing Test Plan, Test Cases, execution of Test Cases and Timelines for the projects and conditioning test data.
• Involved in documentation and validation of issues and defects found during testing via HP ALM Quality Center.
• Written and executed SQL scripts to validate the requirements related to database validation.
• Involved in identifying and conducting Regression Testing scope by interacting with the project management teams.
• Worked on RESTful API/SOAP web services testing.
• Involved in working with Integration and identifying End to End testing scope by interacting with the project management teams.
• Anchoring & coordinating with the Project Management/ business team on the Daily status and deliverable Walk-throughs.
• Supporting users/business for UAT to ensure defect free deployment.
• Providing testing statistics and metrics to Client and to the project Management.

Confidential, Eden Prairie, MN

QA Lead

Responsibilities:

• Worked on Project estimation and project timelines.
• Worked as onsite coordinator and SPOC for all the projects.
• Involved in creating Test Plans and designed test cases as per the requirements related to BRD and design documents.
• Manage & Coordinate with a team of 5 persons at offshore and multiple vendor Development team.
• Involved in conducting walkthrough of test deliverables with Client and business users.
• Involved in regular interaction with Business Analysts and Design team and project Developers on the test execution.
• Involved in technical requirement analysis and participated in discussions with Developers on producing valid test scenarios and test cases.
• Written and executed SQL scripts to validate the requirements related to database validation.
• Involved in identifying and conducting Regression Testing scope by interacting with the project management teams.
• Responsible for executing the project using Agile Scrum methodologies.
• Used Issue Tracker to track and report system defects and bug fixes and coordinated with the development teams for closing defects.
• Monitored project activities and advised on issues to the team members to ensure and meet project deliverables in time which resulted in high customer satisfaction.
• Regular interactions with the project members were conducted to Motivate, inspire, and encourage them and to resolve project issues.
• Involved in reporting team discussions and have provided valid clarifications for the issues faced and also used to highlight the risks and concerns to the key stake holders.
• Involved in regular day to day work allocation process, effective tracking, managing test activities and monitoring the progress of the work.

Confidential, Richardson, TX

QA Lead

Responsibilities:

• Worked on project forecasting, estimation, project timelines in coordination with project SME, Client and QA Manager.
• Worked as onsite coordinator and SPOC for EDW projects.
• Involved in creating Test Plan, test cases for multiple releases.
• Involved in conducting walkthrough of test deliverables with Client and project SMES.
• Involved in regular interaction with business Analysts and Design team and project developers.
• Attended regular walkthrough sessions conducted by Business teams.
• Involved in technical requirement analysis and participated in discussions with Developers on producing valid test scenarios and test cases.
• Written and executed SQL scripts to validate the requirements related to database validation.
• Used Quality Center to track and report system defects and bug fixes. Involved in creating modification requests for the bugs which helped developers to track and resolve the problems.
• Effectively coordinated with the development teams for closing a defect.
• Monitored project activities and advised on issues to the team members to ensure and meet project deliverables in time which resulted in high customer satisfaction.
• Regular interactions with the project members were conducted to Motivate, inspire, and encourage them and to resolve project issues.
• Involved in reporting Team discussions and have provided valid clarifications for the issues faced ad also used to highlight the risks and concerns to the key stake holders.
• Involved in regular day to day work allocation process, effective tracking, managing test activities and monitoring the progress of the work.

Confidential

QA Lead

Responsibilities:

• Developed test plan and Test Scripts covering business requirements and conducted reviews with the QA Manager.
• Involved in highlighting the risks and providing status reports to the key stake holders
• Involved in work allocation process, effective tracking, controlling the test activities and monitoring the progress of the work.
• Involved in writing SQL queries using TOAD/SQL developer to validate the data mapping.
• Executed test scripts to validate the reports generated through Oracle BI Reports.
• Executed test scripts to check the data flow from Source tables to Staging Tables and Staging to Data Warehouse tables.
• Involved in Report import check, Layout check, Graph check and Data Check Involved in Report business rules and functionality check.
• Involved in defects logging, tracking it until closure by validating once the defect is fixed, Root Cause analysis via HP Quality Centre.
• Extensively involved in Test Data Preparation.
• The Daily Status Reports are sent to the stakeholders showcasing the summary, status and issues.
• Involved in Manual Testing, Integration Testing, System Testing, Regression Testing, and Functional Testing.

Employer: Symphony Marketing Solutions

Confidential

Senior Consultant

Responsibilities:

• Involved in analyzing business model and customer requirements
• Involved in walkthrough of Test Plans, functional Specifications with project stakeholders.
• Involved in ETL Testing.
• Involved in Preparing and executing test cases.
• Involved in writing and executing SQL queries.
• Involved in documentation & validation of problems & defects found during testing.
• Follow up with the developers and ensure the Bugs/errors have been fixed with in the turn-around time.
• Involved in status call, discussing defects found with Offshore and Onsite Team.
• Submit testing statistics and metrics to Client and to the Management.

Confidential

Area Sales Manager

Responsibilities:

• Worked as database admin and involved in creating, maintaining database as per business requirements.
• Involved in providing production support and Maintenance of databases on production server.
• Involved in preparing, creating database and loading business data into the databases received from different sources.
• Generating business reports from the database for product sold as per the field research and market research analysis provided by the business teams.
• Involved in validating the data present in the database against the business requirements.
• Involved in maintaining and generating prescription trend from the database for a given product from the specific area and geography.
• Involved and maintained customer information based on the Retail chemist prescription audit trend.
• Involved in updating and maintaining Product database by gathering research information on the product using various sources.
• Involved in generating product availability tracker from the database which provides business team to identify and request stocks based on the market demand.

Confidential

Professional Sales Representative

Responsibilities:

• Involved in Market Research for identifying product sale trend for each type of product.
• Involved in generating reports for product sold in the market using field research and existing documentations.
• Involved in Planning and implementation of Sales Improvement Plans.
• Develop strategy to improve the sales of the product after sufficient research.
• Involved in providing calculation by conducting research on availability of the products to ensure sufficient stocking of products available across the geography.
• Involved in gathering Retail chemist prescription audit on the sales.
• Involved in conducting sales walkthrough to the management on the sales trend.