| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEProfessional Summary:Over 10 years of diverse experience in Information Technology with emphasis on SQL Testing, Quality Assurance and Business Analysis. Expertise in entire software development life cycle in analysis, design, development, enhancement, implementation, troubleshooting, performance tuning, coding, testing, production support using Oracle 11g/12i, SQL Server, PL/SQL, ETL, Data warehouse & Unix projects. I possess excellent communication, inter-personal and documentation skills. I quickly adapt to an existing work environment and like to work with teams and independently based on business needs.Expertise:Strong understanding of software development life cycle models and object-oriented systems design and architectureExtensive experience in developing Test Plans, Test Cases and Test Scripts in UAT environment on Java/JavaScript on multiple OS like Linux, UNIX, Windows, Android, Blackberry and iOSExperience in Functional & Regression testing utilizing manual and automated testing skills.Extensive knowledge of various phases of Software Development Life Cycle (SDLC) in different methodologies such as Waterfall and Agile SCRUM focusing on root cause analysis and software/middleware/firmware troubleshootingWorked on both Client/Server and Web based applications developed in BASIC#, Java, JavaScript, HTML and .NET technologies.Develop optimized QA scripts for regression testing with data sources. QC/ALM of integration communicating with databases and Business Manager.Performed Back End Testing for the UAT setup by writing various queries for the purpose of database integrity in Oracle and MS SQL Server.Expertise on DDL, DML and DQL of SQL commands and other stored procedures in SQL.Hands on in web service testing using tools like SOAPUI in UAT environmentStrong Experience in testing of CRM applications on SalesForce.com and PeopleSoft platform and AS/400 application screensExperience in the all modules of the Quality Center (QC)/ 11 ALM Edition for Microsoft Dynamics GP (Great Plains) testingGood understanding in Defect Life Cycle for tracking the defects with Severity & Priority.Created, updated and maintained the Test Matrix and RTM to ensure that the test plans written covered the Requirements.Extensive experience in Functional testing, Smoke testing, Integration testing, Environment Testing, System testing, UAT testing, End-to-End testing, Performance testing, Regression testing, Database Testing, GUI & UI testing, browser compatibility testing and smoke testing in Windows & Unix environmentsReport defects using Defect tracking tools like Quality Center / Test Director, Rally, JIRA and VersionOneExpertise in writing and understanding SQL Queries for data validation and back-end testing purposes.Skill Set:AUTOMATION TOOLS & DEFECT TRACKING TOOLSHP Testing Suite HP ALM, Quality Center/Test Director, QTP, SOAPUI. LoadUI, Selenium IDE & RC, Win Runner, TestMaker, TTP, BugZilla, JIRA, PushToTest, Rally, VersionOneWEB TECHNOLOGY / PROGRAMMING LANGUAGESMS Visio, Sharepoint, .NET Framework, C#, ASP.NET, HTML, UML, Java, JavaScript, J2EE, VB Script, XML, AS400 Mainframe, Silverlight, MS Visual Studio 2.0, Sales Force (SFDC)DATABASE TOOLSOracle 10g/11g/12i, Toad 8.6, MySQL, MS Excel, MS Access 2007, MS SQL Server 2016, IBM DB2Version Control/Source Code ManagementGIT, SubVersion, Microsoft Team Foundation Server (TFS), Eclipse, Jenkins, Autosys, Control-MOPERATING SYSTEMSMS-DOS, Windows XP, Windows 7,UNIX, Linux, Windows 2016 ServerProfessional Experience:Veristat, Dallas. TX Oct 2022 - February 2024QA testerResponsibilities:Reporting: Generate and provide detailed reports on testing activities, including test coverage, defect status, and overall software quality metrics.Validation and Verification: Validate software against user requirements and verify that it meets specified criteria before deployment.Automation: Develop and execute automated test scripts to streamline testing processes and improve efficiency.User Acceptance Testing (UAT): Coordinate and support UAT activities with stakeholders to ensure software meets end-user expectations.Continuous Integration/Continuous Deployment (CI/CD): Integrate testing processes into CI/CD pipelines to enable rapid and reliable software delivery.Performance Monitoring: Monitor and analyze software performance metrics to identify areas for optimization and improvement.Training and Support: Provide training and support to end-users on software features and functionality as needed.Audits and Inspections: Participate in audits and inspections to ensure adherence to quality standards and regulatory requirements.Root Cause Analysis: Conduct root cause analysis on critical defects and incidents to identify underlying issues and prevent recurrence.Security Testing: Perform security testing to identify vulnerabilities and ensure software systems are secure against potential threats.Cross-platform Testing: Test software across different platforms and environments to ensure compatibility and consistency.Customer Feedback Integration: Gather and integrate customer feedback into testing processes to continuously improve software quality and user experience.DXC/Gainwell Technologies (Remote) June 2020 Sep 2022QA TesterResponsibilities:Interacted with clients to determine User requirements and goals.Participated in analysis of Business and functional requirementsWrote SQL queries to test the application for data integrity and verified the contents of the data table.Developed Test Plan and overall Test Strategy for the Application.Developed Test cases, Test plans, and Test procedures using MS Word and MS ExcelDeveloped Test Cases and Test Scripts for System and UAT Testing.Performed Positive and Negative Testing for this application.Extensively used SQL queries to check storage and accuracy of data in database tablePerformed basic testing of security features using manual testingResponsible for creating Test Strategy for the Data WarehouseInvolved in creating the design and technical specifications for the ETL process of the project.Worked on trimming the SQL and optimizing the SQL by using various VLDB settings in the MSTR to avoid the cross join and removing multiple passes.Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extractedUsed Erwin to reverse engineer the existing database design in SQL Server 2016Developed Test Cases and Test Scripts for System and UAT Testing.Performed Positive and Negative Testing for application.Responsible for communicating Defect Status Reports to business in project meetings.Participated and organized weekly meetings and walkthroughs to improve the testing efforts.Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.Tested the reports using Power BI and Tableau functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2016Extensive user of Clear Quest for defect tracking, process automation, reporting and lifecycle traceability for better visibility and control of the SDLCStrong Windows operating-system background, with understanding of the key drivers and influences on performanceDeveloped SQL Stored Procedures and Queries for Back-end testing.United Healthcare Nov 2016 May 2020QA TesterResponsibilities:automated and manual test cases for the customer enrollment and billing modules.Actively involved in Functional, Regression, Smoke, environment, UAT and Integration Testing in Agile methodology focusing on root cause analysis and troubleshootingWorked in Agile development environment, analyzed the user stories (Requirements) and attended daily standup meetings and Sprints for the web and mobile applications for customer enrollment and billingInvolved in developing Test Plan, wrote Test cases, and executed theAttended sprint plan meetings every two to four weeks to review the user stories.Maintained Automated Scripts and troubleshoot their issues for each Site Release, Feature, and, Small Enhancement Project.Validating test cases against Excel Data sources, Access Data sources and SQL Server databases.Detected Defects, communicated to the developers using Bug Reporting Tool and Tracked the Defects using Quality Center 11 ALM.Performed web service testing using SOAPUI and XMLFormatter utilities and involved in importing new builds into SOAPUI projects.Developed RTM to validate the requirements with test cases in JAD environment for the SharePoint 2010 applicationsInteracted with off shore team to resolve defects and functional issues of the application using JIRA.Using Quick Test Pro (QTP UTF) conducted Regression Testing followed by the System Testing and Negative testing.Responsible for application code deployment using Jenkins.Used MS Project 2012 for task assignment, resource allocation (time and cost) as well as preparing Gantt Chart for tracking work progressWorked on SOAP and REST web services testing using SOAPUI and ensured XML request and responses are parsed correctly and performed XPATH validation changes for values using Regular expressions.Performed Grey box testing by validating UI and application code for web and tablet applications and verifying web services using SOAPUI, XML assertions and Groovy ScriptingWorking on test estimations and UAT team (team size 4) for work allocation, reporting and issue fixing using MS Project.Involved in parameterization of endpoints in SOAPUI and validation of Linux Shell ScriptsExtensively used Quality Center ALM Edition for test case development, test bed preparation and execution.Uploaded Business requirements, test scenarios, test cases and defects to Quality Center for multiple OS like Linux, Android, iOS and WindowsDeveloped and executed SQL joins to validate the results in Web Services and Front end with Database.Worked on SharePoint 2010 for folder/files management and user story management.Responsible for application code check-in using SVN version control for BASIC # application codeUsed JIRA for defect tracking and documented different error situations like HTTP 100, 200, 300 and 400 series.Performed backend testing using complex SQL joins to validate data in SQL ServerParticipated in RTM Test cases Walkthroughs and defect report meetings periodicallyTexas Capital Bank, Richardson TX May 2014 Oct 2016QA TesterResponsibilities:Tested app-exchange applications. Integrated Apex with External services by making callouts that used SOAP and WSDLUsed Apex Data types, Variables, Expressions, Assignment statements, Conditional statements, Loops, SOSL an SOQL queries, Locking statements, Transactional control and Exception statements to invoke Apex triggers and validate themTested Batch Apex to build an archiving solution that ran on a nightly basis, looking for records past a certain date and added them to the archive.Worked with Ajax toolkit to invoke Apex through anonymous blocks and Public web service methods.Worked with Anonymous Blocks that could be compiled and executed using System Log Console, Force.com IDE and Web Services API call.Supervised and created comprehensive test plans for end to end, System, Enterprise and Regression testing, creation and maintenance of test cases (manual / automated), and test data.Supervised the system test plan and test case walkthroughs with application partners and documentation compliance of QA activities.Supervised routine generation of defect metrics and communicated them to upper management on a timely basis.Worked on 2 Week Agile SCRUM sprints and responsible for creating QA Project plans and test plans (test strategy, testing scope and coverage, traceability matrix resource allocation, risk, etc) for sprint testing. Defined and utilized metrics and reports to communicate the testing status, product quality and readiness to management on daily stand-ups.Lead the team for conducting requirement analysis with the product owners and creating software requirement specifications (SRS) and process flow diagrams for delivering work to the technical teams. Also, working as a liaison between the business teams and the technical teams for defining acceptance criteria, clarifying requirements and setting up technical delivery expectationsUsed GIT, Eclipse and Jenkins for source code management and deploy the latest build on the Test Servers for testing activities.Participated in design and implementation a new test Automation Framework and the automation for the structured testing on Reporter Application as SaaS application using HP QTP and JavaResponsible for QA deliverables/documentation like Software Test Protocol, Test summary and Conclusions, Code lock memos, Trace matrices (Functional to Test case) using corporate/industry SOPs, and verification guidelines and procedures.Reviewed the Business Requirement Documents, Functional Specification documents, Technical Design Specifications to get a better understanding of the system on both technical and business perspectives. Assisted in the design/development of software requirements.Conducted Discussions and meetings with Architects/designers to understand the application and the overall functionality of the system.Provided Test Estimates for various test phases of the project for UAT TestingPerformed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database.Performed server side API testing for Zuora REST APIs web store integration with the application using SOAP UI.Performed regression testing of the applications to validate functionality, GUI elements and web service methods integration between applications.Analyzing and troubleshooting the issues reported by the team and logging them into the Rally defect tracking tool.Prepared weekly and daily status and Defect reports for managerial reference.AT&T, Dallas TX Aug 2013 - Apr 2014QA AnalystResponsibilities:Involved in the Analysis, Design, Coding and Testing of the application.Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.Created SQL*Loader control files for loading the data from flat files to staging area tables.Developed SQL scripts to create database objects like tables, views and sequences.Used SQL*Loader to load bulk data from various flat files.Developed SQL and PL/ SQL scripts for migration of data between databases.Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 6i.Developed complex triggers in reports before/after for validation of user input.Designed and developed user interfaces using Oracle Forms 10g.Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS_PROFILER, etc.Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.Performed server side API testing for REST APIs web store integration with the application using SOAP UI.Performed regression testing of the applications to validate functionality, GUI elements and web service methods integration between applications.Analyzing and troubleshooting the issues reported by the team and logging them into the Rally defect tracking tool.Prepared weekly and daily status and Defect reports for managerial reference.Education and Certification:Certified Scrum Master (CSM) - (Scrum Alliance)Advance Java with Strut, hibernate, spring, spring boot, framework from (NIIT)Software developer with Core Java and Advance Java from (Tops technology)Masters Degree in Commerce, Gujarat University, IndiaBachelors Degree In commerce, Gujarat University, IndiaDiploma Networking TechnologyDirectorate of Employment & Training: Web Designing with HTML, DHTML & JavaCertified Software Development (CSD): C, C++ Programming, Java, Advance Java, and Database DBMS, PL/SQL. |
