G.Dhanasekar.

Mobile: +91-887*******

adg0cq@r.postjobfree.com

https://www.linkedin.com/in/dhanasekar-sekar-36973929/ PROFESSIONAL PROFILE:

10+ years of experience leading QA initiatives for complex software projects and high-performance solutions in various domains. Accomplished software quality assurance with a proven history of on-time, on-budget QA project deliveries. Highly skilled in determining the direction, scope & strategy of project initiatives, improving processes, building great teams and aligning technical effort with organizational goals.

Good experience in Resource allocation, Task Assignment, Team Building, Project Leadership, Release Management, Requirements & GAP Analysis, Process Design, Agile scrum methodology, Client Stakeholder Relations and Change Management.

Certification and Training has been completed the Azure-900 Microsoft Certified, ISTQB, CSTP GNIIT and Selenium.

Experience in understanding the customer and functional requirements and Expertise in End to End testing and project information and accurately establish project scope Functional Manual Testing.

Automation Testing: Selenium, JMeter, Cucumber / CI/CD, Maven, Jenkins, Web Service, API, SOAP UI, Postman, Talos and Jumbo Tool.

Mobile Testing: (Android / iOS )

Ecommerce Testing: B2B, B2C, C2C.

Database and ETL Testing :(MS SQL / Oracle / Redshift)

Reporting Tools Testing: Microstrategy, Tableau and IBM Cognos

Defect Track Tool: (HP ALM / JIRA / Version One)

ERP Domain: PeopleSoft HRMS / HCM / FSCM / Workday v24 / Base Benefits Compensation / North America / Canada Payroll / Global Payroll/ People fluent / HRIS / Sales force.

Travel and Expense Domain: Concur Travel Expense in Oracle Application.

Hospitality Domain: (CLC Lodging Application Hotel / Workflow / Intranet/ Lodging / Talon)

Financial Suite: Oracle Enterprises Business Suite Financial.

Banking Domain: Card Management and Retail Banking.

Insurance Domain: Knowledge in Guidewire- Claim Center / Policy Center / Billing Center and Absence Management 360 Solutions

Interactive Voice Response Testing: Siebel CRM / E-Toll Collection

Conceptual Knowledge in UNIX, VBScript, Excel Macros, Java / ColdFusion 11 / C, C++, VB, MS- Office, MS-Excel, MS-PowerPoint

Expertise in QA Test Management: defining Software Testing Life Cycle (STLC), Defect Management Life Cycle, Software Development Life Cycle (SDLC) methodologies. Creating QA Project Plans Test Schedules, Test Estimates, Test Requirements, Test Strategies, Test Scenarios, Test Cases, Test Scripts, Traceability Matrix, Release Management, Feasibility and Test Closure details and Knowledge Transition to stakeholders.

Coordination of testing activities between clients and the offshore testing team.

Providing technical and domain guidance to team members and Conducted Knowledge sharing sessions for new members. Knowledge of complete end-to-end project development and Migration Strategy. PROFESSIONAL EXPERIENCE:

Hexaware Technologies Ltd., Technical Architect / Test Manager / Software Quality Assurance – Aug 2010 - Present - Holding Valid H1- B Visa (USA) / T0714557 PRIOR EXPERIENCE:

Fourth Dimension Software Systems India (P) Ltd., Product Consultant / Implementation Dec 2006 – Aug 2010

EDUCATION:

Master of Computer Application, University of Madras, Chennai 2000 – 2003

Bachelor of Science (Mathematics), University of Madras, Chennai 1996 – 1999 CERTIFICATION & TRAINING:

Azure-900 Microsoft Certified Fundamentals, Microsoft Certified- H389-9494,2020

ISTQB, NIIT, Chennai, 2012

CSTP, STG, Chennai, 2004

GNIIT, NIIT, Chennai, 1996- 1999

APPERCIATION & AWARDS:

Ace and Star Award for the Outstanding Contribution in Digital Assurance Competency – Hexaware Technologies.

Completed Evolve Bronze Foundation Course (AWS / AZURE / Behavioral / Quality Techniques / Test Expertise / Java / Machine Learning, Agile, ITIL). PROJECT DETAILS:

THE HON Company. Jan 2020 to till date.

Role: Test Lead (Manual and Automation Testing).

Client: HON – USA.

Tool Used: Java, CSS, VB Script and Java PL/SQL Developer V9.0.5, Putty, WinSCP, CVS, HP ALM, Zeplin Tool, CI/CD, Maven, Magneto, Jenkins. Mobile Testing Stimulator, Selenium Webdriver Description:

A HISTORY OF GOOD BUSINESS, HON didn’t become the most recognized name in office furniture overnight. Since 1944 our products have helped doers like you achieve more workday victories. The bold idea successfully sold to the tough manager happens in our chairs. The click of our file cabinet drawer signals another project well done. Cleaning off the top of our table, just to get it dirty again. Whether the pressure is on, or the rest of the office is gone, we’re right there with you. To help you work smarter, more comfortably and on your terms.

SURROUND OURSELVES WITH SMART PEOPLE

OBSESS OVER LITTLE THINGS

ALWAYS AROUND TO DO THE RIGHT THING

Roles and Responsibilities:

Experienced with front end back end and integration testing of data

Knowledgeable about point of sale and POS retail systems

Created SQL queries and analyzed testing results.

Used defect tracking systems for defect processing and quality controls procedures.

Proven experience with manual test scripts and cases preparation

Verification and Validation HON Home / PLP /PDP testing in details each a very links, sublinks, image and complete the payment gateways and complete the place order were from warehouse HON storage.

Analyzed the user requirements, discussed with product team and developers to clearly understand the terms specified in the user story.

Creating functions and scripts to automate the test cases using Selenium and Appium to work with multiple platform (iOS, Web).

Preparation of Automation Test Suite for Functionality (for Mobile Apps/web) using Java

Implementing Page Objects, Data Driven, modular, hybrid automation frameworks using Selenium WebDriver, Cucumber, Appium and java

Involved in giving demo to the client for designed scripts

Using Git repository for pushing the automation code

Continue the B2B, B2C process flow from ecommerce flow to business and customers.

Strong functional and technical abilities and Highly analytical and results-driven

Develop technical presentations & proposals & perform customer presentations

Participate in business development activities and provide technical guidance for future solutions

Collaborated with all teams for data defect mitigation.

Reviewed and interpreted systems documentation and business requirements.

Worked both independently and as part of a QA project team depending on project requirements.

Independently managed time to meet all task deadlines.

Provided business end-user support and Automation testing process is in progress FleetCor Technologies - Corporate Lodging Consultants. Jan 2017 to Dec 2019. Role: Test Lead (Manual and Automation Testing).

Client: FleetCor – USA.

Tool Used :ColdFusion 11, Windows 7 / 10, Oracle 11g, PL/SQL Developer V9.0.5, Putty, Service Now, Version One Defect Tool, Test Stimulator, Pcloudy, Selenium Web Driver, TestNG, Parameterization, Maven, Core Java, Eclipse, JENKINS, Hybrid Frame Work. Description:

Web Application:

CLC is a leading negotiator of workforce lodging rates for businesses in North America. CLC purchases more than 13 million hotel rooms annually and leverages this volume into deeply discounted rates on business lodging for its clients.

Nationwide access to more than 17,000 hotels across the U.S. and Canada, including a customized list of hotel options. Enhanced data reporting that ensures compliance to your policies and protects your bottom line.Pre-negotiated, non-public low rates that save money without extra administrative time 24/7/365 support for your travelers on the road, 20-40% savings on lodging costs Mobile Application:

The client is a leading independent global provider of specialized Booking Reservation services including corporate lodging discount cards and other specialized payment services for businesses throughout the world. Scope of the project is to test mobile applications (CLC) part of client application. Roles and Responsibilities:

Participate in business enhancements discussions and manage the resulting operational Projects analyze the needs and requirements of the business for testing.

Review functional specification documents, test plan, test preparation, test case, test data, test execution, test result and test closure proactively, quality documents, and test plans for system Integrated testing.

Execute test case and raise the defects or log the defects if any, re-execute defects status in Test cases and close the defects as per the project and releases.

Automate the smoke, sanity and regression test cases using Selenium Web Driver tool with java technology which reduces the manual effort for testing in order to expedite the delivery.

Analyzed the user requirements, discussed with product team and developers to clearly understand the terms specified in the user story.

Creating functions and scripts to automate the test cases using Selenium and Appium to work with multiple platform (iOS, Web).

Preparation of Automation Test Suite for Functionality (for Mobile Apps/web) using Java

Implemented Page Objects, Data Driven, modular, hybrid automation frameworks using Selenium WebDriver, Cucumber, Appium and java

Involved in giving demo to the client for designed scripts

Using Git repository for pushing the automation code

Responsible for individual delivery as well as matrix management of activity carried out and Monitor, coordinate, report & validate project initiatives and manage individual projects. End to end. Attend regular project review calls / meetings and Monitor and escalate issues effectively, ensuring clear communication channels.

Creating QA project plans/QA project schedules, QA estimates, QA feasibility and risk Assessments, test strategies, test scenarios, test requirements, test cases, test scripts, traceability matrix, Peer create test plans and releases management.

Corporate Lodging Consultant / Emergency Lodging Application / Derby soft and Real Time Lodging Solution and Mobile Application.

Oracle Business Suite Application - Voucher Entry, Trial Post, Auto Trail Post, Invoice, Customer Receipts, Card Management process, Accounts Payable, Customer Contracts, Accounts Receivables, Billing, Project Costing and Distribution Process

Prepared Effort estimation and plan for the given requirements and Set processes for test plan reviews and ensure that test scenarios get reviewed by Product Management.

Ensuring all development tasks meet quality criteria through test planning, test execution, quality assurance and issue tracking.

Participates in all Scrum Ceremonies and ensures the team understands the requirements at their best and provides the proper efforts and estimates on their work items Global Data Warehouse (GDW) 2.0. Apr 2015 to Dec 2016. Role: Quality Analyst (Offshore and Onsite).

Client: American International Group-USA.

Tools Used: PeopleSoft HCM 9.0, Datastage 8.5, Cognos 10.2, Workday, ETL, BI, Data warehouse Description:

The objective of GDW 2.0 project is to build a Data Warehouse which can be used by HR senior management to perform trend analysis of employee’s data globally and generate analytical reports. The data from various source systems will be staged first and data from multiple sources will be conformed, transformed and then loaded into the Data Warehouse for analytical reporting purposes. Transactional reports will be generated from the Operational Data Store (ODS) and it will be separate from the MDW from where analytical reports will be generated. The ODS and MDW together form GDW 2.0. Role and Responsibilities:

Responsible for test planning and test case preparation for all modules

Involved in the preparation of test data.

Review of the Scripts and suggesting modification in the scripts.

Provide Test case walkthrough to the business and HRIT.

Executing the scripts and reporting the bugs through defect tracking tool HPQC

Built new Cognos reports developed will be tested based on the end user requirement and functionality.

Data stage jobs, sequencers and routines will be tested and validated against the requirement. Coordinate the Quality process on deliverable as per the organization and customer standards. PBI – Payer Mapping (Pharmacy Business Insights). Jan 2014 to Mar 2015. Role: ETL / Manual Testing (Offshore and Onsite).

Client: IMS – USA.

Tools Used: Oracle Database 11g, UNIX Shell Scripting, Cybermation (ESP Workstation), Redshift, Netezza, JIRA, ETL Data Stage Healthcare / MicroStrategy / Tableau / Control M. Description:

WebMD will provide a general site activity file. Client will provide Rx and Dx data for known patients within the past 12 months. The general site activity file will be used to project the results of the matched Experian- WebMD sample to the full WebMD universe.

The resulting data is loaded into an Oracle database as a set of reporting tables that are used by Micro strategy and Tableau to produce online reports.

Everyday Health projected is to design, build, host, and operate an enterprise solution that will enable Everyday Health to more effectively profile, size, monitor and evaluate online or offline customer engagements. Users will access reporting and analytics through a customized web-based reporting tool. The data platform is a stand-alone project for Everyday Health. Roles and Responsibilities:

Involved in analyzing the Business requirements and Design Documents.

Involved in test estimation, preparation and execution of test cases.

Count Validation between source and target tables.

Data content Validation between source and target tables, Concatenating columns, using joins with many tables.

Verifying logics as per business requirement, Experience working with huge volumes of data, analyzing record sets for Data Quality and Data Validation

Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.

In collaboration with other team members, analyzed raw data to ensure the data will meet the business need. Worked with the business owner to identify key data elements that will be monitored on an on- going basis to ensure a high level of data quality within the Warehouse.

Designing the SQL queries based on FDD, Involved in running the Cybermation jobs using ESP Workstation.

Assisted in writing the SQL queries to validate the Cybermation outputs against the data present in the database (Target Table).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Coordinated with the offshore development team to provide them with the necessary requirements with the stored procedures and packages and the necessary insight into the data.

Created and modified several UNIX shells Scripts according to the changing needs of the project and client requirements. Execute Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables. Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures Bug reporting and tracking using Quality Center (Version 11.0).

Preparation of Daily Execution Reports, Weekly project status, Quality Metrics and Test Monitoring Sheet details.

EAZYPASS PLAZA- Electronic Toll System. June 2013 to Dec 2013. Role: QA Lead (Onsite).

Client: XEROX – USA.

Tool Used: Siebel CRM and IVR, Oracle 9i, SQL Crystal Report UNIX and SQL, Manual Testing, JIRA.

Description:

ETC is an application which automates the Toll collection system. It allows Toll user to register to an Agent, so that he can pass through the Tollgates, without paying. It would be automatically deducted from his credit. It also keeps track of any Violations. ETC uses various technologies to automate the collection of tolls as a vehicle passes through an ETC lane, without requiring the driver to manually pay cash or deposit tokens are preloaded with information that makes them unique for each customer. Roles and Responsibilities:

Analyzing the functional flow of the new enhancement and check the impact on the existing system.

Create the Traceability Matrix with the timelines required with planned dates.

Create the test scenarios and test scripts as per the formats required.

Execute the test scripts and documented test log, if the any defect leakage prepared the functional defect log.

Playing a vital role in team as a Sr. Software Engineer in prioritizing the defects found by the team and also give the Severity and assigning to the development team as required and help the team always when required and guide the team to reach the deliverables on time. Analyze and test the new enhancements of various modules and complete the deliverables on time. Impart training to the new team members to help them cope up with the existing process and functionality. Reimplementation Project-Bank of Montreal, Harris, Nesbit Bank. May 2012 to May 2013. Role: Test Lead (Offshore / Onsite).

Client: Aon Hewitt- USA.

Tool Used: PeopleSoft HCM 7.X, 8.0 and 9.1, People Tools 8.48, Oracle 11g AQT HPQC 11.0, Manual Testing.

Description:

BMO Client in PeopleSoft and one of the major clients in HR Operations for is BMO (Bank of Montreal) BMO Financial Group, is one of the Big Five banks in Canada. Re-Implementation is applied on 3 instances of legacy systems (PS 7.X and PS 8.0) to PeopleSoft 9.1 where the project majorly includes Core HR, NA Payroll. Hence there are various streams like data Conversion, Interfaces, Customizations, Panama Extensions and Reports.

Roles and Responsibilities:

Ensuring the integration of PS HRMS database with the third-party tools.

Analyzing the functional flow of the new enhancement and check the impact on the existing system.

Deriving the requirements of the project from the Business Requirement Document.

Create the Traceability Matrix with the timelines required with planned dates.

Create the test scenarios and test scripts as per the formats required.

Playing a vital role in team as a Sr. functional tester in prioritizing the defects found by the team and also give the Severity and assigning to the development team as required and help the team always when required and guide the team to reach the deliverables on time.

Working on various streams like data conversion, customizations, interfaces and reports. Analyze and test the new enhancements of various HRMS modules on future state (PS 9.1). People Soft HRMS Implementation. Jan 2011 to Apr 2012. Role: QA Lead (Offshore).

Client: The Peter Kiewit – USA.

Tool Used: PeopleSoft HCM and HRMS 8.9, People Tools 8.48, Oracle 10g SQL.HPQC 11.0, Manual Testing.

Description:

Client is in the business of Construction, Mining and Engineering Powerhouse and has CMS WEB Application and customized PeopleSoft Payroll application to meet their business requirement. Fluctuating Work Week process was implemented to pay Staff Salary Non-Exempt employees’ overtime and salary employee halftime. Alternate Timecards process need to be able to submit both Staff and Craft hourly alternate timecard file for Company 215.

Roles and Responsibilities:

Ensuring the integration of PS HRMS Involved in Requirement Analysis, Estimations for QA testing, preparing Test plans.

Reviewed documentation for correctness and clarity Impart training to the new team members to help them scope up with the existing process and functionality.

Interacted with development, teams when necessary and Involved in Daily and weekly calls with clients in onsite to interact and resolve the issues. Involved in understanding the complete user flow of the application.

Responsibilities include determine test scenarios and conditions based on requirements.

Designed test cases based on the functional specifications and prepare test data and performed Functional Performing Sanity, Integration, Usability, System Regression testing, Beta Testing and Regression Testing.

Prepare Requirement Traceability Matrix, Test cases and executing the test cases in HP Quality center.

Ensuring the employee’s list based on the cost center wise to verify the personal details like – Gender, Default Cost Center, Personal Details, Personal checking account to support direct deposit of reimbursement and Personal credit card.

People Soft Financial Upgrade. Sep 2010 to Dec 2010. Role: QA Tester (Offshore).

Client: Northern Trust - USA.

Tools Used: PeopleSoft FSCM and HRMS 8.9SQL.Manual Testing, HP ALM 9.0. Description:

This project is initiated to implement a central systems platform that supports integrated streamlined processes globally for customer’s entire core accounting functions. It is responsible for replacing the General Ledger and other core financial applications including Consolidation in ERP. Roles and Responsibilities:

Understanding the client requirements by studying functional document and Involved in the preparation of test data.

Account Receivable involved in customization of additional billing functionality like down payment, billing plans, configuration for the dunning, incoming payments, incoming payments like residuals, partial payments, payment differences like underpayment/overpayment, reason codes and cash application.

Responsible for all Accounts Payable processes. Ensured input and timely payment of all vendor invoices. Program Administrator for in house Accounts Payable Imaging System.

Assisted in Month End Closing and Year end close. Rectified escalated accounts payable issues from employees and vendors. Processed Month End closing and reports.

Procurement Services manages, administers and coordinates supplier purchases and agreements relating to goods, services and Review of the scripts and suggesting modification in the scripts and executing the test scripts and reporting the bugs through defect tracking tool. Fourth Dimension Software Systems India (P) Ltd – Champagne (Hospitality) Dev 2006 to Aug 2010. Role: Product Consultant / Implementation Manager. Client: India / Singapore / Srilanka / Andaman.

Tools Used: JAVA 2.0.Eclipse 3.2, Report Writer, SQL. Description:

Champagne integrates all the arms of the hospitality enterprise into a single. Seamless and comprehensive software systems that allow your staff do what they do best. FRONT OFFICE / POINT OF SALES / BANQUETS / STORES PURCHASE MANAGEMENT / PERSONNEL MANAGEMENT / HOUSEKEEPING / FOOD COSTING, LIQUOR COSTING / TELEPHONE MANAGEMENT / TALLY INTERFACE / VISITOR MANAGEMENT / GATE PASS SECURITY / TIME MANAGEMENT SOLUTION / ACCOUNT RECEVIALBES / SHORT MESSAGE SERVICE (SMS) / MAINTAINCE / ASSET INTERFACE SOLUTION. Role and Responsibilities:

Responsibilities include determine test scenarios and conditions based on requirements

Interacted with developers and subject matter experts (SME) to understand the Functionality of the CRM and in-house distribution tracking application.

Prepared the test cases / Performed System testing and regression testing by executing the test cases / Identified software defects and interfaced with developers to resolve them and provided full support to the development team / Conducted Regression testing based on the bugs submitted during the earlier builds / Reviewed documentation for correctness and clarity/ Interacted with development, teams when necessary.

Preparation of test data / Performed Functional and Regression Testing / Developed and Executed Test Cases /Submission of bug reports / Wrote Test Cases service line items, work order, customer accounts billing /System / Configured product price plans for testing through GUI.

Updated the Test Cases based on any implementation changes / Preparing the defect report / Involved in Peer Reviews / Designed Test Cases based on the functional specifications.

Involved in understanding the complete user flow of the application / Finding bugs by executing test cases and assigning bugs to the concerned developer and Integration, Usability, System Regression Testing and UAT Testing.

Contact this candidate