E-Commerce Sql Server

Shanmuga Priya Shanmugam

Email: *.*****.****@*****.***

McKinney, Texas, USA LinkedIn

Professional Summary

•8+ years of work experience in Manual testing and Quality Assurance of mobile and Web-based applications.

•Extensive experience in CRM, Banking, Loans, E-commerce, and Mortgage.

•Experience in testing Salesforce commerce cloud for E-commerce and Terafina operations on the Salesforce platform for banking origination and onboarding process.

•Excellent Hands-on experience in SQL Development

•Experienced in creating Stored Procedures and alter as per requirements

•Experienced in designing and monitoring the creation of DB visualization with MS SQL Server reporting services tool (SSRS reports)

•Experienced in database testing in large MS SQL server databases

•Experience in contributing to developing Automation frameworks built on Maven and Selenium WebDriver.

•Worked closely with product managers, developers, FRD writers, and testers for system requirements and functional document review and validations

•Extensive knowledge of standard business methodologies including SDLC, Agile/Scrum, Waterfall, and STLC.

•Experienced in developing test scripts in Selenium Web driver using core Java to automate web-based applications, testing and validating XPath Syntax, and worked in Eclipse. Hands-on

experience with all phases of the Software Testing Life Cycle (STLC) along with Defect life cycles and defect triages.

•Good exposure to the Azure DevOps methodologies

•Participating in all aspects of product testing, including test plan development, execution, and delivery of well-tested solutions within a short time to release

•Developed Test Scripts using Functional Requirement Documents. Test scenarios are created for Positive, Negative, Boundary cases, etc. Performed all types of testing on workflows and server software.

•Provides the highest level of customer service to customers, whether these are current or prospective clients of the Company, vendors, staff, business partners or visitors

•Knowledge of web development technologies including JavaScript, HTML, and XML.

•Well-acquainted with the OOPS and Java concepts -Encapsulation, Abstraction, Inheritance and Polymorphism.

•Strong oral and written communication skills, ability to adapt and learn new technologies and applications, and multi-task in a fast-paced environment.

Technical Skills

Testing Tools: Selenium WebDriver, Junit, TestNG

Operating System: Windows

Database: Excel, Oracle, SQL Server, Maria DB

Languages: JavaScript, HTML, XML, Cucumber, Java, J2EE, C, C++, J2ME, .Net, JSP Servlets

Defect tracking tool: JIRA

Framework: Spring MVC, Eclipse

DevOps: Azure DevOps

Cloud: AWS

Presentation tools: MS SSRS, PowerPoint, Lucid Chart

Professional Experience:

Half Price Books

Nov’22 – Present

QA Engineer (Salesforce UAT)

Responsibilities:

•Testing the SalesForce cloud platform for eCommerce.

•Working closely with both the eCommerce team and IT team

•Extensively working in SQL development, creating Stored Procedures etc.,

•Designing and monitoring the creation of DB visualization with MS SQL Server reporting services (SSRS reports)

•Periodical Database testing in large SQL server database environment

•Creating test scenarios and execution of Test cases and creation of defects for failed scenarios

•Perform writing of Test plans review user stories and write strong test cases.

•Experienced in the functional system, UAT, End to-End, and regression testing

•Working in the agile methodology using Jira and ADO

Nuvision Federal Credit Union

Sep’22 – Nov’22

QA Engineer (Salesforce UAT)

Responsibilities:

•Experienced in testing Terafina operations on Salesforce platform for banking origination and onboarding process.

•Experienced in CRM, Banking, Loans and Mortgage

•Experienced in agile methodology using Azure DevOps Boards/Sprints etc.

•Experienced in creating test scenarios and execution of Test cases and in creating defects for failed scenarios

•Experienced in writing Test plans and reviewing user stories andwritinge strong test cases.

•Experienced in functional, system, UAT, End to End and regression testing

•Worked closely with the Developers and Product managers for the system requirements

Calyx Software, Dallas – TX - 75219

July’21 – Aug’22

Mortgage Origination Software Product Tester

Calyx Software has multiple mortgage and loan origination software products like Point, Path, Zenly, Zip etc. where product testing required to be done on every version release on a periodical basis.

Responsibilities:

•Involved in the FRD documentation review and validation for multiple project test cases

•Experienced in writing successful Test plans including the scope of testing, Test Strategy, execution schedule, and dependencies for Mortgage loan origination software like Point, Path, Zenly, etc.

•Experienced in creating test scenarios, execution of Test cases and creation of defects for failed scenarios

•Developed and executed automation test scripts using Selenium for faster deployment and delivery

•Experienced in the functional, system, UAT, End to End and regression testing of all the loan origination software products in Calyx

•Experience on agile methodology using fogbugz, Azure DevOps Boards/Sprints, etc.

•Worked closely with the Developers and Product managersonr the system requirements

Augusta Hitech, Plano TX – 75024 ( Direct Hire) Jan’21 – June’21

Prism – Health care Quality Analyst

Prism healthcare project was designed to have a single record representation for each individual patient. This record contains demographic and identifying information about that individual patient. It allows to link the patient with the medical partners for creating a better way to treat all the people who have been exposed to any infection or any health issues.

Responsibilities:

•Involved in writing Test cases and executing the test cases

•Retrieved data using SQL queries with mysql and involved in User Acceptance Testing (UAT) phase

•Involved in functional and regression testing

•Good experience in Software development life Cycle(SDLC),Software Testing Life Cycles(STLC),Bug Life Cycle(BLC)

•Experience on agile methodology

•Strong knowledge in SQL

Perscholas, Dallas Tx - 75201 Aug’19 – Dec ‘20

Web learning Platform Quality Engineer & Fellowship

Web learning platform will be letting the students around the world to learn any courses, at any time either through online or in person connect with teachers. The courses can be chosen based on student’s preference on teachers/location/timing or course reviews. Also, this tool will provide opportunities for the teachers to teach multiple number of courses for any number of students through online platform.

Responsibilities:

•Developed the web application using springMVC java framework with Hibernate validation

•Retrieved data using SQL queries with mysql and involved in User Acceptance Testing (UAT) phase

•Performed Junit testing for the method validations in the Data access objects

•Developed test scripts in Selenium web driver for automated testing of the developed web pages.

•Developed and implemented test cases based on the test scenarios during the project

Identity Systems, India (Chennai) Dec’08- Oct ‘10

Online Job Recruitment Services Java Web Developer & Tester

This project was to help Identity systems to go online and to connect the job seekers with potential recruiters of leading companies. This web solution allowed users to create the profiles for themselves and track their online registration status along with the hit ratio from the potential employers. This also has payment gateway by which the job seekers can pay for their premium services.

Key Responsibilities:

•Designed and implemented the online job recruitment services portal using Java & SQL database

•Covered database design concepts like data modeling, relational database model, database concepts etc.

•Created simple to complex queries including multi-table joins, Unions, Views, Correlated sub-queries etc.

•Performed routine updates, upgrades and overall maintenance of website.

•Ensured accuracy of website content by thoroughly editing and cross-checking.

Tata Consultancy Systems, India (Chennai) Dec ’07 - Nov ’08

UI Mobile Testing

Client Name: HUTCH, UK QA Analyst

The main aim of this project is to test the various UI components and to verify whether the functionality of these components on the display of mobile is according to its specification. Some of the major UI elements include form, textbox, text field, image, list, alert, etc. The scope of this project is to identify and develop test cases which check the functionality and the rendering the UI components on the display of the mobile simulators.

Key Responsibilities:

•Responsible for creation, design and execution of test strategies, including writing test plans, test cases and test scenarios.

•Follow up with developers for proper bug fixes and help enhance bug fixing

•Find bugs and report them with focus on technical and supporting details

•Performed compatibility testing with various mobile handsets to ensure that functionality working as expected.

•Executed test suites and perform other types of testing as described in the test plan

•Tested embedded application software on various mobile devices

•Participate in weekly test planning, project status meetings and reviews.

Educational Qualification

Master of Computer Applications

2007

Sarada College of Arts & Science, Tirunelveli

Bachelor of Science (Mathematics)

2004

Sarada College of Arts & Science, Tirunelveli

Contact this candidate