SUMMARY

• ETL/Functional/Automation QA Lead with 13+ years of experience in IT industry including 2+ years of ETL and BI testing and 2+ years of Automation testing.
• A talented, detail oriented software professional, interested in working in a team atmosphere to create innovative and simple solutions that helps to solve client’s most complex issues. Looking for a career that is both challenging and rewarding.
• Sound knowledge and understanding of Software Testing Life Cycle and Software Development Life Cycle
• Hands on experience in Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium WebDriver, JAVA, Junit, TestNG.
• Experience in creating Jenkins CI/CD pipelines and scheduling builds.
• Experience with Behavior Driven Testing (BDT) for Behavior Driven Development (BDD) with Cucumber JVM to implement Test Driven Development (TDD).
• Working experience as SDET.
• Hands on experience with build tools such as Maven, Gradle.
• Containerization using docker.
• Hands on experience with version management tools as GIT, Bit Bucket.
• Working experience with using scrum management tools as JIRA, Rally and Version1.
• Experience in testing the web services using SOAP UI, Postman and Rest Assured.
• Extensive experience in EDW/BI, Bigdata testing which includes DB2, Oracle, SQL Server, Hadoop. Proficient knowledge on ETL tools like Informatica/SSIS.
• Professional with experience in leading Testing efforts, including experience with all phases of testing: System/Functional, System Integration, User Acceptance, E2E and Performance Testing.
• Understanding of Star and Snowflake Schemas, Facts and Dimensions table and DW concepts.
• Experience overseeing the development of test plans, test scenarios, test cases, and execution of test cases and documentation of test results. Defining the testing strategy for large programs and ensuring requirements traceabilitythroughout the project lifecycle.
• Experience in BI reporting tool - Tableau, SSRS, OBIEE.
• Expertise in SDLC right fromrequirements planning to architecture, testing to deployment, and support, to help link client’s IT programs to organizational goals.
• Excellent working knowledge in Test Plan, Test Strategy, Test Estimates, Test Requirements and Test Case Design from the Business Requirement Document and Technical Design Document. Preparation and Execution of Business scenarios andTest Cases.
• Proficient in writing complex SQL scripts based on the business logic usingTOAD, Oracle SQL Developer, SQL Server.
• Perform Functional Testing, Integration Testing, Regression Testing and Implementation Test on Web based & Mainframe platforms (CICS, TSO, FileAid, SPUFI)
• Experience with SOA architecture that include Restful Web Service Testing.
• Worked on automation suite for each Retail application to cut down the manual hours
• Hands on experience in Test management & Defect management tools such as:HP ALM, Quality center 10.0
• Coordination with multiple project stakeholders which includes Design review meetings, Defect meetings, Test case/results reviews, Daily/Weekly status reporting.
• Experience in handling Onshore/Offshore team across a global model; which includes leading offshore testing team from client location in Canada and USA
• Experience in Insurance, Retail, Banking (Cards and Payments) and Airline domains with fortune 100 clients.
• Self-starter with Effective communication skills, Team player and excellent grasp of fundamentals combined with attention to detail and business process improvements with Quality and standards.
• Experience as a SCRUM Master and facilitated the Daily standup meetings, Grooming Sessions, Acceptance meetings and Retrospectivesessions for the SCRUM team.
• Superior analytical and problem solving skills; strong verbal and written communication skills
• Currently working as Test lead with responsibilities of Project execution, team handling and defect management.
• Certified Scrum Master from INTERNATIONAL SCRUM INSTITUTE.
• Demonstrated ability to work on Work Flow Diagrams, Entity Relationship Diagrams, and Data Flow Diagrams.
• Excellent team leading capabilities with excellent written, verbal communication and interpersonal skills
• Possesses excellent analytical, problem solving and learning skills as well as a keen interest in the emerging technologies Developed Strong Communication and interpersonal skills while working in diverse team environments
• Ability to work in a fast paced environment with tight deadlines and keeping quality as preference.
• Ability to work with various project stakeholders including BAs, developers, DBA, cross functional teams and project management team.
• Expertise in using MS Office (Word, PowerPoint, Excel, Project, and Visio), can create dashboards and reports and pivot tables using MS excel.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, SSIS, ODI

Defect Management: HP ALM, Quality Center 10.0, Bugzilla, JIRA

Operating System: MS-Windows, z/OS, UNIX

Technologies: EDW/BI Testing, Manual/Automation Testing, Bigdata testing

Database: DB2, Oracle, SQL Server,IMS, MongoDB

Tools: SQL server, TOAD for Oracle, Tableau, SSIS, SSRS, OBIEE, Oracle SQL Developer, MFT Mainframe Z/OS, SOAP UI, JIRA, Selenium, Autosys.

Testing Techniques: White Box, Black Box, E2E, Regression, Interface Testing, Automation testing

Data Transfer Tools: FileZilla, Putty, WinSCP, MFT

Languages: COBOL, JCL, JAVA, Gherkins, Junit, TestNG, Cucumber

Build tools: Maven, Gradle

DevOps tools: Docker, Splunk, SumoLogic, Jenkins

PROFESSIONAL EXPERIENCE

Confidential

Senior Engineer/SDET Batch/Automation

Responsibilities:

• As a part of this project helped team to create test plans and carried the defect triage meetings.
• Wrote complex SQL queries to validate the ODI ETL conversion rules for data converted from legacy Db2 DB to oracle DB.
• Worked on automation testing framework for the application using Jenkins and Unix shell scripts.
• Created Test Plans and Test Strategy which describes the features and functions to be tested.
• Supported solution designing activities and automated test scripts.
• Designed and implemented test scripts and managed test automation processes.
• Worked on Selenium Java based framework for automation.
• API/Webservice test automation using Rest Assured and Postman.
• Executed manual scripts and participated in UAT activities.
• Modified automated test scripts as per system functionality and functional requirements.
• Reviewed test results, issues and defects related to business units.
• Prepared and implemented test scripts for unit and regression tests.
• Participated in smoke testing, regression testing and user interface testing.
• Manage daily interactions with client executives and PSC (Project Steering Committee).
• Helped team on technical front to write SQLs to test the database part of the test effort.
• Review project documentation for all assigned projects to ensure that the project requirements are clearly defined.
• Analyze project requirements and develop Test Plans and documented test cases that ensure that all functionality is performing as intended.
• Report defects and escalate issues as needed.
• Meeting with management and project steering committee on testing health and any show stoppers.
• Generating reporting from ALM as per management needs.
• Trained and mentoredthe test team on software testing processes and SQL scripting practices.
• Set the standard test procedures to carry out the thorough testing of the new system.
• Developed Requirements Traceability Matrix (RTM) to make sure the TCs are lined up against the requirements.
• Conducted Daily standup meeting with test team on the issues/blockers/status on the work being done and planned.

Environment: Windows, UNIX, Mainframe, JAVA, SQL

Confidential

Lead QA Analyst ETL/BI/Automation

Responsibilities:

• As a part of this project helped team to create test plans and carried the defect triage meetings.
• Wrote complex SQL queries to validate the ODI ETL conversion rules for data converted from legacy Db2 DB to oracle DB.
• Validated the ODI batch jobs as per the requirements against data in the tables.
• Worked on automation testing framework for the application using Selenium.
• Created Test Plans and Test Strategy which describes the features and functions to be tested.
• Build cross platform testing with Selenium WebDriver and Cucumber JVM.
• Developed and implement Keyword Driven, Selenium Page Object Model framework with Selenium WebDriver using Object Oriented Programing Java and open source unit test framework TestNG
• Interface testing where ODI is used to send and receive data to and from external agencies.
• Supported solution designing activities and automated test scripts.
• Designed and implemented test scripts and managed Selenium test automation processes.
• Executed manual scripts and participated in UAT activities.
• Modified automated test scripts as per system functionality and functional requirements.
• Reviewed test results, issues and defects related to business units.
• Prepared and implemented test scripts for unit and regression tests.
• Participated in smoke testing, regression testing and user interface testing.
• Manage daily interactions with client executives and PSC (Project Steering Committee).
• Helped team on technical front to write SQLs to test the database part of the test effort.
• Review project documentation for all assigned projects to ensure that the project requirements are clearly defined
• Analyze project requirements and develop Test Plans and documented test cases that ensure that all functionality is performing as intended.
• Report defects and escalate issues as needed.
• Meeting with management and project steering committee on testing health and any show stoppers.
• Generating reporting from ALM as per management needs.
• Trained and mentoredthe test team on software testing processes and SQL scripting practices.
• Set the standard test procedures to carry out the thorough testing of the new system.
• Developed Requirements Traceability Matrix (RTM) to make sure the TCs are lined up against the requirements.
• Conducted Daily standup meeting with test team on the issues/blockers/status on the work being done and planned.

Environment: Windows, UNIX, Mainframe, JAVA, ODI

Confidential

Lead QA Analyst ETL/BI

Responsibilities:

• Leading the team through the project.
• Created the test strategy, test plan and test approach
• Performed system, functional, integration, compatibility, availability, regression testing.
• Performed negative testing to test the application for invalid data, verified and validated the error messages generated.
• Conducted the defect triage from testing team to discuss on the defects.
• Represented as a test lead from Client side (GDOL) and facilitate weekly Quality Assurance meetings with the project stake holders
• Provide weekly QA status report to the Project SteeringCommittee (PSC).
• Create Test report summary; metrics
• Provide QA Sign-off
• Perform quick smoke test post deployment.
• Connecting with various stakeholders for blockers
• Coordinating with DBA for database issues.
• Coordinating with team members on the issues they are facing.
• Co-ordinated the online, web-based, outside interface testing with numerous vendors that are GDOLs technology partner.
• Analyzed the failures on prod and dev box and tracked them to closure.
• Wrote UNIX scripts to automate the analysis of the failed jobs.
• Prioritized the high-risk areas and raised flags time to time to the Project Steering Committee on the issues.

Environment: Windows, UNIX, Mainframe Z/OS.

Confidential, Atlanta, GA

QA Lead/Scrum Master/Product SME

Responsibilities:

• Leading the project with 20 members and mentoring newly joined engineers to optimum level of efficiency.
• Implement quality software best practices to develop test strategy, test plan, test data, test case and test automation and actively participates in process improvements.
• Designed automation testing framework for the application using BDD, Keyword Driven and Data Driven Approaches.
• Implemented Continuous Integration using Jenkins and Maven.
• Used JIRA for Project and Bug tracking tools. Followed Scrum process to implement Agile Software development method.
• Implemented Parallel execution of scripts using SAUCE LABS.
• Created Test Plans and Test Strategy which describes the features and functions to be tested.
• Developed scripts using Selenium WebDriver and Selenium Grid for cross browser testing.
• Implement wide range of functional testing by various QA Automation Test Framework like Key Word Driven, Data Driven and Behavioral Driven Testing concept to ensure the code reusability and code maintainability, which reduces the script development time.
• Build cross platform testing with Selenium WebDriver and Cucumber JVM.
• Developed and implement Keyword Driven, Selenium Page Object Model framework with Selenium WebDriver using Object Oriented Programing Java and open source unit test framework TestNG Developed automation scripts/framework using Selenium WebDriver to automate the testing process.
• Worked as a SCRUM Masterand Product Owner, depending on project needs.
• Facilitated the Daily standup meetings, Grooming Sessions, Acceptance meetings and Retrospective sessions for the SCRUM team.
• Backlog maintenance and tracking all the tasks logged in JIRA to closure with every sprint.
• Making sure the various stakeholders are updated about the sprint deliverables and show stoppers.
• Working with team on closure of the blocking issues.
• Reviewing product backlog with Product Owners and other concerned parties.
• Mae sure that the Product Owner and delivery team are in sync and agreement for expectations and product and timelines.
• Writing the User Stories and presenting it to the SCRUM team.
• Performed Demos of the application to business owners during the acceptance meetings.
• Presented the ideas on how to make enhancements to the application to make it smooth for end users.
• Analyzed system specifications and user stories to design and develop test cases
• Creating Test estimations, Test strategies and Test Plans, writing and executing Test Cases.
• Web testing of KIAPT tool by providing the pricing, facings, linear width, attributes of each item and the traits details of each stores.
• Publishing the assortment plan from KIAPT for integration testing purpose and providing the assortment reports to Planogram team.
• Troubleshooting of the back end database for the bad data in the KIAPT tool.
• Creating the SQL queries and fetches the data from the DB2 using SQL developer.
• Running java batch jobs of daily, weekly and monthly for the testing purpose.
• Tested and Implemented the KIAPT tool using Agile testing methodology for monthly production release.
• Performed the Functional, end-to-end, regression, performance, UAT and production support testing.
• Performed intensive Black Box Testing and high level White Box Testing.
• Defect reporting, daily, weekly and monthly testing reports using Quality Center
• Perform System, Integration and Regression Testing and provide test data for User Acceptance Test.
• QA Lead for the members Confidential offshores and review their deliverables before sharing the results with the client.
• Participated in writing High-level Test plans, Test Scenarios, Test cases Analysis and Presentation of Results.
• Creating Traceability Matrix and executing test cases in Quality Centre and validating the results.
• Creating and publishing the daily, weekly and Monthly project and defect reports to higher management.
• Creating the management and financial reports for the project using MyCompass reporting tool.
• Created various Excel reporting utilities in cooperation with quality center including the graphical and bar reports.
• Performed feasibility study and automated the KIAPT tool with Selenium.

Environment: Windows, UNIX

Confidential, Baltimore, MD

Team Lead/Senior Developer

Responsibilities:

• Developing and maintaining the applications using COBOL, JCL, DB2, VSAM, CICS, SAS, File Master, CA7 Scheduler.
• Preparing detailed design document for the project. Providing sizing and estimate.
• Working on application enhancement. Working on production issues.
• VSAM file handling. Using DB2 database for data fetching and updating. Working on complete SDLC for projects.
• Onsite offshore co-ordination. Client interaction. Technical training to resources. Requirements gathering.
• Working on roll out activities.
• Used ENDEVOR as version management tool. Hand on expertise on CA7 Scheduler for scheduling of the jobs. Post implementation support.
• Worked on a very niche technology “Stratus mainframe” for migrating the system to IBM mainframes environment Z/os. Responsibilities included creating elements (CODES, JCL, PROCS, JOB DOCS, SORT CARDS etc.) from scratch to create the same functionality on mainframe.

Confidential, CA

Team Lead/Senior Developer

Responsibilities:

• Developed the COBOL source code for the new and existing applications.
• Fixing the code to resolve the production issues.
• Writing and running COBOL Batch jobs (JCL).
• Debugging the COBOL and CICS (Online Screen) codes for fixing the issues.
• Performed Unit Testing for COBOL Codes and for CICS Online Screens.
• Worked on hi-priority production issues which require quick turnaround time.
• Excellent logical and analytical skills.
• Hands on expertise in XPEDITOR for debugging the online CICS programs
• Wrote JCL’s from scratch for newly developed applications
• Hands on CA7 automatic scheduling of the mainframe jobs.
• Hands on expertise on Endeavor and Changeman.