Sri Sakthi Kumaran S.M.V

Project - NEM Reform (Integrated energy storage system) – AEMO

• Enhanced software quality by implementing effective test strategies and test plans.
• Well-versed in creating source qualifier query using SQL as per source to target mapping sheet
• Delivered high-quality releases under tight deadlines by prioritizing critical tasks and adjusting resources accordingly.
• Good at developing SQL queries and ETL scripts for querying data against different data bases for data verification process and Source to Target mappings.
• Good at validating source to target mapping rules for different types of source/targets i.e., data base/file/excel to data base/file/excel
• Working on Real time transactions from source to Target with XMLs/JSONs transformation based on technical specifications/Data design documents and Source to Target mappings
• Preparing daily status reports with details of executed, passed, and failed test cases and defect status.
• Attending and conducting in regular agile scrum meetings and QA status meetings Defect triage meetings.
• Leading and guiding team in their test execution without impacting my deliverables
• Throughout the project in various iterations/Sprints – conducting system testing, System Integration testing, User Acceptance testing and Regression testing.

Tools
JIRA, Microsoft SSMS, Practitest, Postman, Confluence

Project - BlueYonder- Demand Forecasting upgrade- Woolworths

• Forecasting Upgrade (BlueYonder- Demand) is an integrated End to End replenishment solution that will provide predictive visibility of the future inventory position and direct team to consistently address the most important drivers of availability.

Project - BlueYonder Fulfilment Upgrade -Woolworths(APR 2017- OCT -2018)

• BY Fulfilment is the main platform that Replenishment uses to calculate and generate orders for Stores and Distribution Centres (DCs)
• BY Fulfilment calculates orders based on inputs from TPRP, Replenishment Central and SAP and it does this by ordering as late and as little as possible without breaching Safety Stock or Article/Network Constraints

ROLES & RESPONSIBILITIES

• Managing team of ten by coordinating with client and onshore team members
• Streamlined communication between testers and developers through detailed defect reporting and tracking systems.
• Improved project delivery timelines by efficiently managing testing resources and schedules.
• Analyzed proposed technical solutions based on customer requirements.
• Collaborated with clients to define solution requirements.
• Identified and documented project changes with proactive budget oversight.
• Responsible for Creation of Test scripts for UAT users and supporting them with required data
• Analyzing the BY custom scripts and core supply chain functionalities with data integration
• Client interaction experience with exposure to the onsite offshore module
• Analyze the issue, fault fixing and communicating the solution to the Client
• Execution of Test cases for Functional and Regression Testing
• Development and Execution of regression scripts using PLSQL

Tools

• JIRA, TCS Mastercraft ALM, BY Demand, BY Fulfilment, SQL Developer, Putty, WinScp, Informatica, UC4, Qtest, Tosca

Project- Enterprise Information Management - Metcash Trading Limited

• Metcash is currently undertaking a business transformational journey to re-imagine itself by shifting focus from a supplier centric to be more customer-centric
• As part of this transformational journey, Business & IT teams in Metcash have jointly agreed to embark on an EIM Program to realize this business vision by addressing the existing Business & IT challenges on Information management and reporting.

ROLES & RESPONSIBILITIES

• Handled 3-member team for an entire release.
• Analyzed data to coordinate installation of new systems or modification of existing systems.
• Coordinated efficient large-scale software deployments.
• Preparing Manual Test Cases for the new Requirements/functionality, modified features.
• Execution of Test cases for Functional and Regression Testing.
• Preparing Test summary report, Defect analysis report.
• Responsible for successful and on time delivery of results.
• Involved in the business meetings to understand the requirements.
• Logging the issues found and tracking them using QC.
• Preparing Daily status reports, test summary report, Defect analysis report.
• Performed production deployment and the Business verification testing.

Tools

Hadoop, Impala, Hive Informatica

10.0 (BDE), Hue, SQL Server, Putty.

Project - Global Television Audience Measurement (GTAM) - AC Nielsen(2014-2016)

• The GTAM (Global Television Audience Measurement) Meter program aims to deploy fully functional television set meter, a low cost set and people meter, a scrolling text people meter.
• The scope of the GTAM initiative includes the development and test of all aforementioned meters to measure audiences watching TV content along with the necessary software for in-home installation and related changes to existing collection facilities and processing systems

Project - Local Media Hybrid - AC Nielsen (2012-204)

• Local Media Hybrid is an initiative by the Nielsen Company for upgrading the Nielsen Local Audience Ratings

Roles and Responsibilities

• Wrote and optimized test cases to maximize success of manual software testing with consistent, thorough approaches.
• Assessed software bugs and compiled findings along with suggested resolutions for development team members.
• Gathered data on integration issues and vulnerabilities and outlined improvement recommendations.
• Coordinated work with various teams to solve problems and improve efficiency for software testing and automation.
• Checked software beyond testing scripts for interconnected problems not covered by established specifications.
• Debugged code and located root causes of problems by reviewing configuration files and logs.
• Defined, created and controlled testing environments for successful software deliverables.

Tools

• SQL developer, JIRA, QC, Putty, DB Visualizer, Winscp, Fitnesse, Spotfire.