Akila Rajamani

adyyf1@r.postjobfree.com

913-***-****

Professional Summary:

12+ years of experience in Software Quality Assurance Testing, Defects Management and Release Management.

Extensively worked in Software Testing for complex distributed applications that includes Web Applications, Web Services and Mainframe Integration.

Strong experience in working with business users, technical team to gather and analyze Business Requirement, Functional, Technical Specifications and writing Test Strategy, Test Approach, Test Plan and Test cases.

Good understanding of SDLC and methodologies like Waterfall and Agile (KANBAN/SCRUM)

Strong working experience in Black box, White box, Mobile Testing, Functional, Regression, Automation, System, Backend, Integration and End to End testing.

Expertise in generating and customizing the matrix, reports and dashboards using KIBANA/TABLEAU.

Experience in Testing Database Applications of RDBMS in Oracle, SQL Server and DB2 using SQL Server Management Studio, SQL Developer, Win SQL and Squirrel.

Hands on experience in Back-end testing and data validation, writing SQL (DDL, DML and DCL) queries for back-end data validation testing.

Hands on experience in test, defect management and reporting tools such as ALM, Microsoft Test Manager (MTM), Team Foundation Server (TFS) and JIRA.

Experience in testing API’s, Web Services using POSTMAN, SOAP UI for WSDLs validation with different Assertions for validating responses.

Hands on experience with Automation Testing tools using Selenium and Eggplant.

Hands on experience in Data warehouse ETL testing using ETL tools (Oracle Data Integrator (ODI), Informatica Power center and Data Stage).

Hands on experience in BI report testing using OBIEE, Enterprise Performance Management (EPM 11).

Good understanding of OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated and analytics implementations.

Good verbal and written communications skills, with experience in creating design and test documentation.

Well-organized and highly efficient with experience working in a multi-tasking and dynamic environment.

Technical Summary

Testing Types

Black Box, Functional, Mobile Testing, Integration, System, Regression, User Acceptance, Database and End to End testing, Web service testing.

Automation Testing Tools

HP QTP, SOAP UI, Postman, Load Runner, Cucumber with Selenium, Eggplant.

Operating Systems

Microsoft Windows, UNIX, Linux. Main Frame

Test Management Tools

ALM/Quality Center, MTM, JIRA, Soap UI, Postman, Test Rail, TFS, Kibana, Sales Force

Databases/Tools

Oracle, SQL Server, Oracle SQL Developer, TOAD, Win SQL, Squirrel, Visual Studio

ETL/BI tools

ODI, DataStage, OBIEE, SAP BO, Tableau

Browsers

IE, Mozilla, Chrome, Firefox, Safari

Scripting Languages

VB Script, JAVA

Office Tools

MS Office, MS Project, Office 360

Professional Experience

YRC Freight. Overland Park, Kansas

Sr. SQA Analyst November 2016 to July 2023

YRC Freight is the leading transporter of industrial, commercial, and retail goods, specializing in solutions for businesses across North America through a full-service network, advanced information technologies, and proactive customer service. YRC Freight is the largest subsidiary of YRC Worldwide Inc., with corporate headquarters in Overland Park, Kan. Other YRC Worldwide subsidiaries include Reddaway, Holland and New Penn.

Responsibilities:

Reviewed and analyzed business and functional requirements as well as used cases in order to identification and creation of test scenarios and test cases.

Responsible for development of test plans, test cases, test scripts and the creation and execution of test scenarios for testing.

Responsible for creating traceability matrix and generating testing reports using KIBANA and Test Rail.

Good experience with Data Analytics using Tableau.

Worked with automation team members to provide priorities, test cases, and test scripts.

Reviewed and analyzed the Requirements documents, Data models, Data design flow, Data mapping documents and used test cases.

Responsible for understanding the project scope, plan, requirements, designs and the creation of the testing approach and test plan.

Participated in the initial phase of the project and provided the testing requirements, related testing documents and feed backs.

Explain and assign tasks to testing team members after participating in the requirement gathering.

Writing test cases and creating test data based on test scenarios and executed in the Test Rail.

Tested Dynamics CRM application modules like Dashboards, Reports, Account, Tasks, Leads & opportunities UI.

Worked on CRM projects using Sales Force like Case management, sales, reports, etc.

Writing and executing SQL queries to compare and validate data affected by scripts using SQL server Management Studio, SQUIRREL, WIN SQL, and other various tools.

Tested and validate different services and API’s using POSTMAN.

Developed and maintained traceability between requirements and test cases to ensure that testability is met.

Provided test scripts, test cases, test scenarios, screen prints and technical support to UAT.

Environment: Test Rail, Office 365, TFS, Sales Force, Microsoft Dynamics CRM, MS SQL Server Management Studio, Share Point, KAFKA, Postman, SOAP UI 4.5, HTML, XML, JSON, API Testing, and CITRIX.

CenturyLink Inc. Gardner, Kansas

Sr. Data Warehouse Tester June 2015 to August 2016

CenturyLink provides communications and data services for residential, business, governmental and wholesale customers in 37 states. Summary Data Reporting (SDR) project is to build the data Marts to report the summary data to the business users by different subject area.

Responsibilities:

Reviewed business and functional requirements as well as data model, mapping and ETL design specifications in order to identification and create test scenarios and test cases.

Responsible for development of test plans, creation and execution of test scenarios and test cases for testing.

Worked closely with project team members on issue resolution and process optimization.

Worked closely with Developers, Business Analysts, and Business Users.

Reviewed and analyzed the Requirements documents, Design documents, Data design/flow, Data mapping documents and used test cases.

Responsible for understanding the project scope, project plan, requirements, design and creating the testing approach and plan.

Participated in requirements, code review and data model/data mapping review meetings.

Kept a thorough communication from start to the end of the project.

Writing test cases, creating test data based on test scenarios in MTM 2015.

Tested Dynamics CRM application modules like Dashboards, Reports, Account, Tasks, Leads & opportunities UI and data.

Writing and executing SQL queries to compare and validate the historical table data affected by scripts.

Tested and validated the different APIs developed in JSON and SOAP using SOAPUI tools.

Testing control-m jobs and shell scripts.

Responsible for creating traceability matrix.

Providing Technical support to UAT.

Creating reports using MTM and facilitating defect review meetings.

Environment: TFS 2015, MTM 2015, Microsoft Dynamics CRM, MS SQL Server Management Studio, MS office 2013, Share Point, Subversion, SOAP UI 4.5, HTML, XML, JSON, API, JAVA.

SPRINT Corp. Overland Park, Kansas

QA Analyst/Data Warehouse Tester March2013 to May 2015

Telecommunications holding company provides wireless services and is a major global Internet carrier. It is the fourth largest wireless network operator in the United States and serves 59.5 million customers. The company also offers wireless voice, messaging, and broadband services through its various subsidiaries under the Boost Mobile, Virgin Mobile, and Assurance Wireless brands, and wholesale access to its wireless networks to mobile virtual network operators.

Responsibilities:

Reviewed Business Requirement documents (BRD) and Functional Specifications Documents (FSD) to prepare Test Cases and identify test scenarios.

Involved in the creation of test plan, test cases, test procedure required for manual testing and initiating automated testing.

Wrote and executed test cases for data validation testing to Check for data integrity and errors while performing edit, delete, modify the forms on web pages

Analyze Data Models, Data mapping, Design, Conversion and ETL design documents.

Create, maintain and track of Requirement Traceability Matrix.

Used Quality Center creating and executing Test Cases and printing status report for the team meetings.

Tested database integrity, referential integrity and constraints during the database migration testing process.

Extensively involved with ETL test data creation for all the ETL mapping rules.

Executed SQL statements to test the integration between application and database.

Proficiently worked with OBIEE to test Physical Model, Business Model and presentation layer and established relationships.

Tested different types of Customized Reports (Drilldown, Aggregation) created by OBIEE to meet client requirements.

Validated the reports layouts in OBIEE based on Report Layout Document.

Creation and execution of test cases on Oracle Reports and OBIEE

Worked as an ALM/QC Admin and customized the tool based on requirements from users.

Facilitate defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.

Developed different Reports and Dashboard to communicate the testing progress and defect reports in TFS.

Tracking and testing connections of customers using SOAP UI for API and HTTP protocols.

Defects were tracked and prioritized using ALM and analyzed the variation between the expected result and the actual result.

Participated in various meetings and discussed Enhancement and Modification Request issues.

Environment: Oracle 11i, Microsoft Team Foundation Server (TFS) 2012, Microsoft Test Manager 2012, JIRA 7.0, TOAD, SQL Server 2010, ASP, VB scripts, Window NT, .Net, Web Services, XML, XML Schema, DB2, Unix, Confluence, SharePoint.

One Whistle Inc. Cupertino, California

QA Engineer January 2011 to February 2013

WHISTLE revolutionizes the way our world works by seamlessly connecting and merging consumers and producers. Users can post any services they need and can list services they themselves can provide. Thus, no matter if you are at home, work, transit, or the local pub, you will receive a Whistle when there is a producer or customer nearby. Services can range anywhere from retail, social, or personal.

Responsibilities:

Performed System testing, regression testing, End-to-End testing, Ad-Hoc testing, Integration testing and User Acceptance Testing.

Involved in writing test plans, finding and documenting bugs and errors.

Working with requirement team and development team to validate the business rules across the application components.

Maintained detailed test logs and report test results using Test Rail.

Participated in the test plan and test cases review meetings.

Worked closely with business experts and developers in order to perform my duties.

Responsible for Backend testing by executing SQL statements.

Interacted with developers for the status of the bugs and re-tested the fixed Bugs.

Analyzed the defects and categorized them based on severity.

Responsible for entering bugs into an automated bug management system and performing regression tests after the bugs are fixed.

Testing Web services using SOAP UI.

Problem reporting and tracking with HP ALM tools.

Close interaction with members of the development team.

Tested documents for Cross Browser Compatibility.

Environment: Oracle, Windows XP, Java, MS Office, SOAP UI, Quality Center, Agile Methodologies.

Education

Bachelor’s degree in economics Bharathidasan University, Tamil Nadu, India

Contact this candidate