Expert in Front end automation testing
Resume:
Rajesh Kannan Kumaresan
************.*********@*****.***
Summary:
Over 8+ years of experience in the DW ETL and BI testing with specialized in Automation through WebDriver JS and Jasmine testing framework using Protractor.
Expertise in Automation testing for both Angular and Non-Angular pages.
Certified Tester by International Software Testing Qualifications Board.
Proficient in Databases such as Oracle and Teradata and also completed External certifications in those technologies.
Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
Developed test scripts to automate process of testing in Protractor WebDriverJS.
Proficient in Manual & Automated Testing in both Data warehouse ETL and BI.
Performed ETL data validations with respect to Active Records, SCD Types date, DDL, DQA, Lookup tables, Mutual Exclusive relationship, Referential Integrity violation and Surrogate keys generation.
Good understanding of ETL testing principles and concepts.
Expertise in performing Functional Testing, Integration Testing, Backend Testing and Regression testing.
Good at VB Macros which aided in the automation across the projects worked upon.
Extensive experience with Agile/Scrum Methodologies.
Experience working in a variety of programming languages and environments including JavaScript and other Object Oriented languages.
2+ Years’ experience Interaction with Onsite Clients.
Knowledge in the ETL of data into a data ware house/date mart and Business Intelligence (BI) tools like MicroStrategy, Customized Reporting tools using Angular JS framework.
Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
Good Exposure on Requirements Analyzing and Streamlining and Management.
Well versed with Various Testing Stages/Levels/Phases, Testing Types, Testing Techniques and Quality Work Products.
Hands on experience in preparing Test plans, Test cases, Automated Tests and Test Data. And executing the same and expertise on Black box Testing
Good expertise in peer reviews (Test Design and Defect Reporting) and analyzing the results and reporting Suggestions and defects.
Awards / Certifications:
Secured University 3rd in U.G.
International Software Testing Qualifications Board (ISTQB)
Teradata 12 Certified Professional (TCP)
OCP Certified by Oracle as an Oracle PL/SQL Developer Certified Professional
OCA Certified by Oracle as an Oracle PL/SQL Developer Certified Associate.
Secured Silver Champion Award in HCL.
Completed Computer Hardware & Network Engineering course in ACCEL IT ACADEMY in First Class with Distinction.
Skills:
Testing Tools : WebDriver JS, Protractor
Bug Reporting Tools : Quality Center, Bugzilla
Databases : Oracle, Teradata
Operating Systems : Windows 7/8, DOS, UNIX
ETL Tools : Informatica
Scheduler : Crontab, SVN, Control-M, UC4
Education:
Master of Computer Applications
Bachelor of Computer Applications
Work Experience:
Client: eBay
Employer: Cognizant Technology Solutions
Sr.QA Analyst
Project: XRAE 01/2015 to Present
Description:
XRAE is the extensible Reporting Application Environment, a rather promising effort by the FP&A and MAP team (Finance Platform & Analytics and Marketplaces Analytics Program) in eBay that allows users to create sophisticated reports within an existing application environment. It has “N” number of reports / dashboards which are getting consumed by Top level Executives / Business people which serve as a source of truth for building strategies and attain a growth in the business. Users can generate a reporting interface in an application environment that already handles things like user permissions, SSO authentication, and connection to internal data sources, and so on; and it allows to create custom entities by which user can slice the data.
Responsibilities:
Attended standup calls on daily basis and had two week Sprints in Agile Methodology.
Written extensive programming in JavaScript for automating the functional and regression testing through Protractor which is an End-to-end testing framework for Angular JS application.
Implemented Jasmine as a testing framework with WebDriverJS in Protractor.
Recorded and Created Test Cases through Selenium IDE framework for Smoke testing.
Worked as BI Tester responsible for the requirements, reviewing of the mockup screens for Dashboards / Reports.
Prepared System Test Plan, Test Cases / Use cases for Data and Functional validation.
Created User Stories and logged defects in JIRA application.
Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
Written SQL queries for validating the data from source to target tables.
Created jobs in UC4 job scheduler for running the QA validation checkpoints at the ETL side.
Validated data across the dashboards for the common metrics and dimensions with intended data formats.
Validated Threshold check for the metrics in the dashboards both from High-Charts and Grids.
Validated default values, filters by changing values to the dimensions and number of elements present across the Dropdowns in the frontend.
Validated the intended actions on the pop-up / child windows.
Prepared Test Summary report at the end of each project and submitted to the Management.
Performed Functional, Black Box, System and, End to End, Regression testing.
Extensively used Smoke, Sanity and Integration Testing.
Environment/Tools: UNIX, Teradata SQL Assistant, UC4, Protractor.
Client: eBay
Employer: Cognizant Technology Solutions
Sr.QA Analyst
Project: Business Health 07/2013 to 12/2014
Description:
eBAY is one of the leading company which manages eBay.com, an online auction and shopping website in which people and businesses buy and sell a broad variety of goods and services worldwide. In addition to its auction-style selling, the website has since expanded to include "Buy It Now" standard shopping. QuickStrike is BI application which has several dashboards / reports used by various users / higher management people to make the right decisions on the business to increase the net revenue and profit. This has been developed in Microstrategy with Teradata as backend database. Followed scrum methodology which is an iterative and incremental agile software development framework for managing software projects and product.
Responsibilities:
Attended standup calls on daily basis.
Analyzing the BRD, Design documents during the sprint planning.
Automated data validation in MicroStrategy Reports using MSTR Office and through subscription in MSTR NarrowCast Server.
Prepared various use case scenarios on understanding the business requirements for the data validation of reports.
Worked on the testing of dashboard reports and drilled down subject areas reports.
Have come up with multiple scenarios for prompt values and tested indeed.
Validate the formulae, filters and the data results calculated for totals and sub totals for the data set.
Verify the report structure and the formatting is as per requirements.
Verify the data displayed in the reports match with the actual data in DW.
Data validation of Teradata tables, Output Files.
Performance testing of reports.
Building of regression test scripts/suite.
Reported defects while testing the product.
Retest the fixed defects.
Uploading Test Cases, Test Results and Defects into common server.
Environment/Tools: Windows, UNIX, Teradata SQL Assistant.
Client: NBAD (National Bank of Abu Dhabi)
Employer: Cognizant Technology Solutions
QA Analyst
Project: EDW QA/Testing 11/2012 to 06/2013
Description:
NBAD has started the project initiation activities for construction of an EDW with initial focus on Profitability, and the SAS Profitability Management solution. Teradata would leverage its FSLDM industry standard data model to design a robust and scalable Active Data warehouse customized for a typical Corporate/Consumer Banking and SAS would help architecting the Business Intelligence and Analytics platform to develop insights on the banks performance. The immediate focus for the IT team is limited to profitability related insights and NBAD has partnered with SAS to replicate the platform. The typical business intelligence tools leveraged are SAS Enterprise Business Intelligence Server, SAS Profitability Management Solution Mid-Tier Server and SAS Mid-Tier ABM Server.
Responsibilities:
Analyzing the BRD, Design documents for 12 source systems.
Involved in the development / QA meetings in the requirement gathering phase.
Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
Prepared Test Cases artifacts.
Involved in identifying general validations (other than mapping validations) and preparing Test cases.
Executing the Test Cases in SIT environment and capturing Test Logs.
Done automation using VB Macro for generating and executing all general validation test cases which has reduced the effort of the testing to a significant extend.
Automated areas are SCD types dates, DDL, DQA, Lookup tables, Mutual Exclusive, Referential Integrity and Surrogate key generation.
Test Cycles are carried out for Enterprise releases.
Implemented Bugzilla tool in the EDW project for effective defect tracking.
Retest the fixed defects.
Uploading Test Cases, Test Results and Defects into VSS server.
Assisted in the preparation of project weekly status report.
Environment/Tools: Windows, Bugzilla, Teradata SQL Assistant, ERWIN Modeler, VSS.
Client: JPMC (JP Morgan Chase)
Employer: Cognizant Technology Solutions
QA Analyst
Project: Info1 Development & Support 09/2010 to 10/2012
Description:
Info1 is a Shared Services Environment, Centralized Data Hub and cross-LOB Platform for Operational and Application Data Stores. Information one is the Operational Data Store for Retail Lending applications. Info1 loads data from 100+ systems on a daily and monthly basis into Oracle databases. It provides data for management reporting purposes and feeds to downstream and upstream systems. It provides technology and methodology that enables the cleansing and transforming of conflicting data from operational business systems into integrated information that enables the business to answer any business question. It is linked to many research/development tools, a variety of reports and interfaces may be developed.
Responsibilities:
Analyzed the BRD, Design documents and prepared Test Plan, Test Cases artifacts.
Executed Test Cases in UAT environment and captured Test Logs.
Done automation using PLSQL and UNIX scripting for reducing the effort of the testing to a significant extend.
Both functional and non-functional testing is done for the work request as a part of the SIT testing. Time taken by the job is recorded as a part of the testing but no performance testing is done.
Test Cycles are carried out for Enterprise releases.
Recorded defects in the Defect Tracking sheet and provided defect information to the Developers.
Retest the fixed defects.
Uploaded Test Cases, Results and Defects into HP Quality Center.
Prepared Weekly Status report which involves the tasks that worked upon and send it to the management.
Migrated code from one environment to another environment using SVN and scheduling the jobs in Control-M.
Handled calls with Client on a weekly basis.
Assisted in preparing monthly metrics report for the project.
Maintained QA Tracker and code migration sheets.
Environment/Tools: UNIX, TOAD, Putty, Control-M, SVN.
Client: BT (British Telecom)
Employer: HCL Technologies Ltd
QA Analyst
Project: e-DCA 09/2007 to 08/2010
Description:
eDCA is an electronic data capturing Application. eDCA application supports the creation and maintenance of VPN order details for KEYSTONE and MPLS services provided by BT. Infrastructure details required for provisioning the requested services are obtained by eDCA application by querying the PDMT database at regular intervals. The orders from eDCA are forwarded to CLASSIC application for provisioning. The issues faced by the user, while using the eDCA application are forwarded as bridge cases, to the eDCA, ASG team. The eDCA ASG team analyzes these bridge cases and resolves these cases.
Responsibilities:
Have been worked as a Database tester in the application maintenance project.
Understanding the requirement and deriving the test cases for to validate each requirements.
Performed peer review of the test cases and done with the validation.
Developed NULL validator tool to extract not null count values from each field of the tables/views.
Executed Test Cases and capturing the results.
Raised Defects and tracked till closure.
Work together with the developers in resolving issues in system.
Coordinated and conducted weekly project status meetings.
Environment/Tools: Windows 2003 Server, TOAD, Clarify CRM, UCPS, Web logic JMS.
Contact this candidate