SUMMARY

• 15+ years of overall test management experience wif 13+ years of strong experience in Data analysis, Design, Testing and Implementation of End to End Data warehousing and Business Intelligence solutions using ETL Tools and 12+ years of experience in Web - Testing/UI testing as well as application and product testing wif 3+ years of Selenium Automation experience.
• Possess excellent analytical skills wif ability to conduct advanced business requirement quantitative analysis and translate results into streamlined business recommendations for the purpose of formulation of use cases/ functional requirements and further business need gathering.
• Strong problem-solving and technical aptitude using SQL /MS Excel, PowerPoint and Splunk for data analysis.
• Possess strong interpersonal skills, communication and presentation skills wif the ability to interact wif people at all level. Sound leadership skills wif experience in managing multiple projects/teams. Has actively played the roles of Business Analyst / Scrum Master and Product owner.
• Possess rich client interfacing skills and has experience working in Onshore and Offshore Team Models
• Adept in HCM, Media and market research, Payroll management, Retail, E-Commerce, Telecom, Banking and Financial Domain.
• Experienced in working on Waterfall Model, Agile Methodology as well as Scrum Methodology Projects
• Demonstrated leadership experience on high-profile projects involving cross-functional collaboration and presentations to senior-level management.
• Hands on expertise in Data-warehousing concepts and Big data / Hadoop tools. Involved in End to End Testing of ETL processes wherein the organizations were using Informatica, Data stage, Kafka, Oracle/Oracle Golden gate, Hive, Spark, Netezza and Teradata
• Proficient in writing Test Strategies, Test Plans, Test Estimates, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports relevant to various testing phases in SDLC / STLC
• Possess rich experience in testing including Backend, Frontend, Regression, Functional, System, Interface, Usability(UI), Compatibility, Sanity, Smoke, Black box, Integration, Verification and Validation of End-to-end and User Acceptance Testing(UAT).
• Proficient in Mercury s Test Director/Quality Center (QC), HP ALM for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking. Expertise in usage of Rally/Jira for defect management.
• Very strong skills in writing complex SQL Queries and Procedures for testing Business applications
• Working noledge of Automation based testing tools like Informatica Data Validation Option (DVO), UFT, Selenium and Katalon. Adept in Java / Python and Selenium programming. Assisted in Automation of highly transactional HCM web application using Selenium WebDriver, JUnit, TestNG and Cucumber.
• Experience in API testing, XML, Web Services, SOAP, REST and Mobile testing using ARC, Katalon.
• Ability to work independently or in a team environment as well as a rapid pace environment.

PROFESSIONAL EXPERIENCE

Confidential

Principal QA

Responsibilities:

• Active End-to end principal QA for ADP SBS/RUN-EVO team via manual / automation using Selenium Web driver JS scripts for Digital Onboarding and transformation projects.
• Develop test scripts to handle changes in the objects and web elements of the application using Selenium WebDriver and JavaScript.
• Assist in Development and review of the existing automation framework and support Automated Testing through development phase to troubleshoot issues found in end to end testing infrastructure.
• Monitor the SPLUNK infrastructure for system health, availability, optimization and troubleshooting to follow industry best practices.
• Provide expertise in Monitoring, Event Management and IT Analytics areas using Salesforce and Google Analytics tools such as Omnibug, Google tag manager assistant.
• Follow scrum process in Agile methodology for all user stories and work closely wif developers to test using RALLY and Confluence.
• Verification and Validation of Data and collections in both SQL databases such as SSMS (SQL Server Management System) and NoSQL databases such as Mongo DB.
• Analyze business requirements, system requirements and data mapping requirement specifications closely interacting wif developers and QA team.
• Coordinate testing wif developers, review business requirements and has the ability to translate the requirements into detailed and complex test cases covering various test scenarios through to test closure.
• Build test Strategy outlining the scope, objectives, timeline and focus of software testing effort for functional, regression as well as user acceptance.
• Perform Defect testing and exploratory testing/Ad-hoc testing after each build to extensively cover regression phase.
• Perform API functional testing using Postman / Advanced rest client.
• Perform cross browser and compatibility testing on desktop across all browsers as well as mobile devices every week for every new build.
• Key Quality Analyst responsible for testing real-time streaming (SPARK) transactions using Kafka (message streaming) and SQL via SQL developer/TOAD wif assisted validation using Hadoop-Hive.
• E2E (End-to-end) tester involving multiple applications and web interfaces and ultimately verifying and validating results in Data warehouse (DWH) from application UI.
• Develop, execute and manage all activities from requirement analysis to UAT testing support for the existing data warehouse in a highly Agile environment following Scrum methodology
• Served as SME for specific domains (HR/Payroll and Time) for RUN, Vantage, WFN and EV5 applications and was responsible for APP/BI Validation as well.
• Co-ordinate and conduct Scrum meetings wif team and clients to track progress and report status. Taken up the role of scrum master and was also responsible for creating user stories as PO.
• Additionally took ownership and responsibility for the creation, execution and maintenance of UFT automation scripts using SQL. Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, Junit, TestNG and selenium Grid.
• Performed critical roles for the new initiatives to Test Enterprise data warehouse End to end testing using ETL tools - Informatica, SQL and PL-SQL.
• Continuously interacted wif cross functional team like Business Analysts, Developers to understand requirements and enabled preparation of Requirements Report and Functional Specification Document and thereby formulated Test scope and Test Strategy for multiple projects.
• Owned tasks associated wif Regression Testing, Functional Testing, Load/Volume Testing, Database testing & Application Testing of the Application by test cases (both manual and automation)

Confidential

Assistant Consultant

Responsibilities:

• Test manager on high profile, cross-functional project to create new Booster Samples focused on top 20 large markets for ethnic minority population in order to improve the utility/clarity of Nielsen ratings for analysis on the minority audiences,
• Worked wif data and analytics team to update specific requirements, design the model and translation of business needs/requirements using extensive SQL scripts, present to senior management teams on proposed design and results of oversampled data, implement test structure, monitor and optimize results.
• Served as SME on previous and newly implemented functional data model.
• Uncovered important existing/hidden issues and proactively recommended solutions to optimize results based on functionality.
• Project Test Lead cum Data analyst of the most important cross-functional project of the organization dat was involved in stratifying samples based on demographical data. Played the role of SME and was involved in End-to- End Analysis, design, implementation and testing of introducing the stratification to existing basic and alternate samples.
• Quantified impact of prioritization of stratified layers on the business, identifying $30M+ opportunity for improvement
• Testing involved extensive Validation of multiple slowly changing dimensions such as type 2 as well as type 6 hybrid dimension tables and various FACT tables.
• Senior Test Lead involved in high Finance & Risk reporting providing key solutions for Anti-money Laundering and Fraud management. Required to perform Ongoing Customer Due Diligence to identify, mitigate and manage the risk of money laundering, terrorist financing and other suspicious activity faced by the Group in the provision of designated services using a risk based approach.
• Address inconsistencies in data definitions to improve accuracy of reporting.
• Reconcile the Finance & Risk management data set wif the senior management.
• Implement a governance process to ensure adherence to data management standards.
• Enable agile analysis and reporting by implementing a self-service reporting capability.
• Support agile business driven change to measures and metrics, reports and business views of data.
• Address a number of PWC and Internal audit control weaknesses. ET&A team is involved in testing of business functionalities and data integrity of loads into Group Data Warehouse

Confidential

Asst Systems Engineer

Responsibilities:

• Release Manager of project dat involved functional and regression testing of LSP (Loyalty Solutions Platform) system developed internally for customer representatives who service customers for their requests online and telephonic requests.
• Preparing Requirements Report by analysing the Functional Specification Document for a project and finalising the testing scope and Logical Date Plan for testing activities. Creating Test Plan, Test Cases & Test Scripts for various projects. Regression Testing, Functional Testing, Load/Volume Testing, Database testing & Application Testing of the Application by test cases (both manual and automation)
• Training new team members on application and domain noledge
• Received appreciation for project contribution towards David Jones Strategic Alliance.
• Module lead of project dat included functional regression and compatibility testing of NORDSTROM Shop site application through manual testing. Responsibilities included Web-testing, regression testing, database testing (using SQL queries and PL/SQL) onsite coordination, test environment setup, defect reporting and tracking.
• Was also assigned the duty of training new resources dat stepped into the concerned module and preparation of in-house documents for future references.
• Module lead, leading the MyGofer website testing team of 6 resources towards UI-testing, functional testing, defect reporting and tracking, and relevant interaction wif the development team.
• dis project included functional and regression testing of AOL Total Care application through manual testing. Module Lead handling responsibilities included leading a module of 3 resources, Product testing, Application testing, regression testing, Installation testing, Cross-browser testing, compatibility testing, Sanity testing, onsite client coordination, test environment setup, defect reporting and tracking.
• Responsibilities included requirement analysis, test plan preparation, test case preparation, test case execution, test script preparation, test case automation using XRunner, regression testing, onsite client coordination, defect reporting and tracking using the Test Director.

TECHNICAL SKILLS

Testing tools: Test Director, Mercury Quality Center(HP QC), HP Application Lifecycle Management 11.x

Automation tools: UFT ; Selenium; Informatica DVO; Katalon

Database Packages: Oracle 11g(SQL/PL/SQL); Oracle 12c(SQL/PL/SQL)

Defect tracking tools: Jira, Rally

SQL tool: Toad for Oracle, SQL developer

Data-warehousing/ETL tools: Teradata; Netezza; Informatica 9.x;

Streaming tools: Kafka messaging

Hadoop and Big data tools: Impala/Hive/Pig on Hue browser.

Other Packages and tools: MS Office, SharePoint, Advanced Rest Client (ARC) / Postman, Putty, WinSCP, Python, Eclipse, Salesforce

Data Analytics reporting and monitoring tools: Splunk, Salesforce, Omnibug, Google assistant Tag manager

Deployment and Version control(CI) tools: Jenkins, GIT, TortoiseSVN, Bitbucket

Operating systems: DOS, Unix, Windows 9x/NT/2000/Me/XP/Vista/7 Enterprise