Data Analyst

MEGALA SHANMUGAM

QUALITY TESTER

Blue Heron Tr, Sterling, Virginia- 20165 ******.**@*****.*** 979-***-****

SYNOPSIS:

8+ years of IT experience with emphasis on Quality Assurance and data analysis in Finance &Mortgage, Banking, 508/WCAG complaints Federal projects, Health care, Event Management and Telecommunication domains.

Experience in SDLC BDD, Agile/Scrum, Waterfall and Kanban Software development models.

Experience in Test Plan, Test Cases Design and Execution in Manual & Automation Testing.

Worked on Automation testing tool- Selenium Web-driver with Cucumber, Page Object Model (POM)using Java.

Expertise in the Testing framework like TestNG and Continuous Integration tool like Maven- Eclipse IDE and GitHub.

Extensively worked in Integration, Functionality, Regression, Database, Compatibility, User-Acceptance, System Testing and End to end testing.

Experience in analyzing test results and submitting the bugs using Bug Tracking Tool Quality Centre, JAMA, JIRA-Zephyr & Team Foundation Server (TFS).

Ability to test back-end database applications by writing SQL statement.

Experience in SQL-Server, Couch base No SQL database, Perl and UNIX shell script.

EDUCATION:

Master of Science in Computer Engineering, University of Florida, Gainesville, FL (07/13)

(College tuition financed by “Achievement Award” University Scholarship Program).

Bachelor’s in Information technology (IT), Bharath University, Tamil-Nadu, India (06/09)

SKILLS:

Selenium WebDriver, JAVA, TESTNG, JUNIT, Robot Framework, Cucumber Gherkins, Page-Object Model.

Eclipse Maven, Jenkins, GitHub.

API Testing POSTMAN, SOAPUI.

HP Quality Centre, JIRA, qTest, Confluence, SharePoint, TFS, JAMA.

Oracle11g, No-SQL DB, SQL Server 2010/2007/2003, RDBMS, Rapid SQL, PL/SQL, MS SQL.

HTML, Webservices, VB Script, SQL, UNIX/LINUX, Perl.

WCAG/508 Compliant testing JAWS, WAVE and Dragon Software.

EXPERIENCE:

Automation QA Tester 10/2019 -Present

AllDirection Source Technologies

Project: Medflic provides a scheduling system on free subscription basis for medical personnel. The scheduling system can be accessed by subscribers both as an online service and via the deployed office calendar software or integrated with their website. The subscriber's schedules are available to the patients.

The end user-searchable database includes specialties, range of services, office locations, photographs, personnel educational background and user-submitted reviews. For each doctor the users can review the free slots in the schedule and make appointments for specific time slots

Responsibilities

Involved in analyzing business/system requirements and developed test cases, test scenarios and test data for manual and automation.

Involved in Requirements analysis and Validating Data elements of the applications

Understanding to create business requirement documents for development and QA teams

Automating web application using Java, Selenium WebDriver in TestNG and Page Object Model.

Used Eclipse IDE to develop and execute the test cases using Selenium WebDriver and Java.

Enhancing Test cases using Java Selenium TestNG Annotations.

Used Element locator (Id, CssSelector, Xpath, CSS, etc.) and Relative Xpath to locating dynamic web elements in web-based application testing.

Used Quality Centre for Test case management and maintain Requirement Trackability Matrix.

Participated in Daily standups, Sprint Backlog, Sprint Planning meetings as part of the Agile Methodology

Regularly followed up with Development Team to discuss discrepancies identified during testing

Participated and contribute in scheduled Sprint Review, Retrospective, and Planning meetings

Reported bugs, communicated notifications to the developers using defect tracking tool JIRA.

Worked effectively with Developers, Business team, Project Management to achieve processes improvements.

UAT Application Tester 02/2019 -07/2019

Project: Freddie Mac Loan Advisor is a web-based tool that analyses the appraisal reports sent to the Uniform Collateral Data Portal (UCDP) to analyze appraisal reports and give you a view of their valuation risk. It also LCA provides immediate view of collateral representation and warranty relief associated with the property value. The analysis and feedback returned also help accuracy and adherence to Freddie Mac underwriting guild lines and compliance standards.

Responsibilities

Reviewed System, Business Requirement documentation, identified test objectives, developed test scenarios, test Cases for the LCA web-based application.

Executed Functional, Regression and UAT test scenarios and documented all programming defects software bugs in JIRA and Quality Centre.

Participated and coordinated in Test Case Walkthroughs with the Testing and Management team.

Performed Requirement Analysis by gathering both functional and nonfunctional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM)

Enhanced the automation test scripts and performed Regression testing using Selenium WebDriver TestNG framework.

Conducted cross-browser testing using HP Quality Center to make sure the functionality works in each browser.

Executed test cases for support functions and interfaces in order to run the reports.

Reviewed the defects and conducted retesting on multiple browsers using HP Quality Center

Actively participated in the UAT transition, retested UAT defects and updated comments in JIRA on client feedbacks

Documented all issues/defects reported by subject matter expert testing team in a timely manner with accurate and detailed reproducibility steps along with frequency of and documentations.

Quality Tester 02/2017- 01/2018

MICROPACT, Herndon

Project: Entellitrak is a low-code application development platform for case and records management. It is continuously configurable and takes a Data-First™ approach, application development can be done from any starting point. It helps visualize system transformation, digitize and share information, and get to work connecting the dots.

Responsibilities

Developing test plans, Epics and guidelines based on Agile and Kanban methodology.

Developing test case document and execution suite in qTest document management tool from the user stories for WCAG/508 complaints.

Responsible for planning regression & Smoke test stories in every Sprint.

Performing 508 compliant verification testing manually and reviewing technical requirements of software

Performing both Front-end and backend testing for Entellitrak application.

Performed GUI functional and sanity testing manually for each new build of the application

Performing System integration testing (SIT), UAT, smoke testing, functional, regression testing for the Entellitrak internal tool.

Monitor nightly review of impediments and code with offshore Testers and Interns in Indonesia, China and India.

Used Maven Eclipse IDE for automation test script development.

Performed automation testing using Selenium WebDriver- TESTNG frameworks.

Responsible for thorough testing of browser and platform compatibility issues

Using JAWS, WAVE, WEB-Accessibility tool bar, and Dragon software for 508 compliance testing.

Test GUI and functionality on Android, iOS and Cross browser testing for the 508 complaints sessions

Using JENKINS for scheduling build automation using calendar scheduling and Cron expressions

Using JIRA for defect logging and tracking purposes.

Developing Cucumber-Gherkins test scripts for automation team.

Performing Security and Mobile testing for US federal agency projects.

Sr. QA Tester 07/15 – 02/17

Conduent, Maryland

Project1: Electronic Toll Collection System (EZPass) is an electronic toll collection system is that brings traveling convenience and allows customers to pass through, without stopping to pay toll or use tickets, at any E-Z Pass compatible toll facilities. It uses transponder-based technology to electronically record toll usage. This tag is attached to the customer’s vehicle and is read by an overhead antenna and the tolls are automatically debited from the customer’s pre-paid toll balance.

Quality Lead

Project 2: Easy Pay MetroCard is for customers who want to enjoy the benefits of MetroCard that never runs out of rides. The MetroCard is linked to the customers’ credit or debit card, and refills automatically as it is used.

Responsibilities:

Analyzing the functional requirement document and writing integration and functional test case document based on Waterfall model.

Worked on Siebel CRM, Web Based / GUI Testing and executed the test script manually and through automation tools.

Reviewed requirement document and involved in developing QA test plan document

Performing smoke testing, functional testing, and regression testing, system integration testing and end to end testing for new change orders/build in CRM application

Performed Credit card rebill processing using UNIX batch jobs for huge data on scheduled timeslot.

Performed performance and cross-browser testing for Siebel and web applications

Developed functional and regression test case for EZ Pass new build.

Performed automation execution for the account creation process in EZ Pass web application using the Selenium automation tool-Data Driven Model.

Located dynamic Web Elements using id, CSS Selector and XPath in automation testscripts.

Developing SQL Queries to perform Database testing.

Maintain and present the test metrics of all the projects in the account and take part in QA audit.

Used JIRA, JAMA for defect tracking, test script maintenance.

Conducting weekly meetings and involving in the meetings with the development and build Team every week and as necessary.

Performed User Acceptance Testing (UAT) for Java application at the end of the test phases with the requirements collected from the user.

Involved in generating Master Test Plan, which had all complete information about the Test Strategy involved in verifying the functionality of the application.

Analyzed the requirement document and created test scripts and scenarios for the Easy pay application NY and NJ agencies.

Performed EMV (Terminal Emulator) device testing for both EasyPay and EZ Pass application using physical EMV and billing devices.

CVENT Mclean VA 07/14 – 07/15

Sr.QA Tester

Project: Simple Events-The goal of Simple Event's first external release is to provide a less complex tool for our existing event planners to manage events of smaller scale and complexity than they would normally manage within our system.

Responsibilities:

Writing test case based on Agile and Kanban Model and Automating API test cases using SOAPUI Tools

Performed analysis of business rules, business and system process flows, user administration to be used for the new merged platform

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Developed functional and regression test case for website and iOS/Android Mobile apps.

Created test case and worked intensively on system testing, end to end testing and UAT testing on the application before product deployment.

Used Selenium TestNG, Soap UI for automation and API testing.

Involved in providing the efficient locators strategy like XPath and CSS to run Selenium RC script in stable condition.

Used Firebug Tool, Chropath to identify the Object’s id, Name, XPath, link in the application

Performed Functional Testing in QA, Staging, Pre-production and Postproduction builds.

Performed various Section 508 accessibility Compliance test with JAWS, WAT. Logged, monitored and retested defects in QC for Section 508 failures with various compatible browsers.

Performing Mobile testing for Mac, Android devices and Cross browsing and Multi browsing testing manually for application verification.

Used JIRA, Confluence for managing critical issues and bug management.

Working Production support team and verify the issues based on severity

Involved in Back log discussion session and contributed to the improvement plans

Coordination with Team lead, project manager, BA, Developers on daily scrum meetings to deliver quality product and to ensure RTM is completed.

QA Tester 10/13 – 06/14

VIASAT, Maryland

Project: NMS-NBN Co is a satellite service to provide access to broadband services to people in homes, small businesses and indigenous communities in some of the most remote areas of Australia. The long term intention is to provide high-speed broadband coverage to eligible premises across mainland Australia and Tasmania as well as outback areas and Australia’s islands including Lord Howe Island, Norfolk Island, Macquarie Island, Cocos and Christmas Island.

Responsibilities:

Developing test plan, test strategy, test scripts and RTM for of the satellite networks, user interface systems for BDD approach.

Scheduling and scripting jobs using crontab in UNIX environment in satellite security management.

Performed installation of various user interfaces in satellite communication system

Performed batch processing using Cron tab to automate the data loading in database system.

Performing functional testing, regression testing, performance tests, and security testing to ensure proper user roles are being assigned to the corresponding groups in User Authentication module of the Network management system

Provide support in developing and maintaining ETL processes that extract data from multiple sources residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.

Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.

Used SPLUNK, Syslog for backend log verification.

Involved in release planning meeting before the release and prepared the documents for the team to follow the testing during production.

Performed UAT Testing on the web-based application and used JIRA-Zephyr for Bug maintenances.

Performed Smoke, Regression testing of applications after defects were fixed.

Data Quality Analyst – ETL 05/13 – 9/13

Freddie Mac McLean, VA

Project: Corporate Data Warehouse.

The CDW is a corporate data repository that makes accessible historical and current business relevant data as of the prior business day. Its purpose is to centralize corporate data from disparate data sources residing within Freddie Mac's transaction processing and end-user systems into one relational database for decision support, management reporting, ad-hoc and trend analysis, modelling and data mining purposes.

Responsibilities:

Involved in gathering requirements and analysis for applications.

Developed test Plans, test Cases, test Scripts for UAT tests

Responsible for analyzing and translating business requirements for the development of business rules for business units, identifying and documenting business rules and creating detailed Use Cases

Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.

Based on the ETL specification, loaded the data source to database and performed post –protection testing to ensure the data load in target.

Involved and tested original Mortgage Amount data from Loan IQ (Mortgage Amount, Mortgage Terms), tested the data elements that should follow the calculation logic in the legacy Purchase application and stored procedures

Writing SQL queries, generating reports to ensure data integrity and validating business rules

Created Test Cases in Quality Centre and RTM and mapped Test Cases to Requirements.

Managed and conducted System Testing, Functional testing, UAT and Regression testing.

Loaded data to different databases using SQL scripts, maintained repository for data loading scripts.

Developed SQL scripts and used UNIX for backend testing and Autosys job in putty.

Used shell scripts extensively for automation of file manipulation and data loading procedure.

Execute batch processing and verify the jobs status and data in database tables

Interacted with developers, Business & Management Teams and End Users.

Participated in regular project status meetings related to testing.

Jr. Quality Tester 04/13 – 06/13

Conduent (formerly known as Xerox Corporation), Maryland

Project: Electronic Toll Collection System is an electronic toll collection system is that brings traveling convenience and allows customers to pass through, without stopping to pay toll or use tickets, at any E-Z Pass compatible toll facilities. It uses transponder-based technology to electronically record toll usage. This tag is attached to the customer’s vehicle, and is read by an overhead antenna and the tolls are automatically debited from the customer’s pre-paid toll balance.

Roles and Responsibility:

Understanding the SDLC as well as testing methodologies and objectives.

Analyzing the functional flow of the new enhancement and Business Requirements to check the impact on the existing system

Creating and updating the Traceability Matrix with the timelines required with planned dates.

Creating the Test Scenarios and Test Scripts as per the formats required.

Performing Smoke testing, Unit testing, Functional testing, Regression testing on the new builds by executing the test scripts manually.

Performing regression testing on EZPASS Web application and reaching deliverables on time.

Executing the change orders and logs the functional defects in the JIRA Application.

Maintaining logs in QC, SharePoint for future references.

Participated on performance testing for EZPASS web application.

Making recommendations to improve performance, minimize risk, and improve the customer experience

Data Analyst/Tester - Data Warehousing Domain 04/09 – 8/11

Cognizant Technology Solutions, India

Project: 3M/ Toyota- the largest ManLog clients for Cognizant. It is a world leader in manufacturing and is a Fortune 500 company based in the USA. Cognizant Technology Solutions provides application development & maintenance services to 3M from its offshore development center.

Responsibilities:

Analyzed the System specifications and Business Requirements for full understanding of the Business and involved in Database Development process using ETL Tool- Informatica.

Tested complex ETL mappings, mapplets and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

Prepared Test Data for executing positive and negative scenarios.

Designed and developed Test Plans and Test Scripts for the Functional, System, and Regression testing.

Involved in Manual Testing of the application using QC and established baseline Scripts.

Used QC for managing test execution and Defect Tracking of all issues.

Involved in Database testing using SQL Queries, executed database queries in Teradata to check and compare the values in the database.

Scheduled Meetings, attended Walkthroughs interacting with developers, QA lead, and Project Managers.

Specified, designed, developed, and implemented contact cleansing and consolidation solution using the Trillium tool suite, Oracle, and UNIX to support Toyota Customer Relationship Management needs.

Worked along with the Database development team in Informatica ETL Tool

Designed and developed business name and address cleansing and matching process for 2.2 million business name and address contacts including de-duplication and interactive matching using Trillium batch software suite

Contact this candidate