Software Development Sql Server

A dedicated IT professional with a **+ years of experience in API,UI and DB testing. Excellent understanding of software development life cycle and test methodologies from project definition to post deployment. I bring a unique blend of skills to drive innovation and quality in IT projects.

Areas Of Expertise

Testing Tools

Postman, qTest, Splunk,swagger

Database

SQL Server, Oracle, MySQL, MS Access

Project Methodologies

Agile/Scrum, Waterfall, SDLC, STLC

Markup Languages

XPATH, HTML, JSON, XML

Workflow Tools

Excel, PowerPoint

Defect Management Tools

JIRA, Confluence

Other Tools

CI/CD, Notepad++, MS Office (Word, Excel, PowerPoint), MS Visual Studio

Operating System

Windows Variants, UNIX, Linux

Work Experience

SDET Tekvivid May 2023-Till date

●Sanity Testing of NPEs (Non-Production Environment) after each vulnerability fixes

●Support Collection Run in NPE environments

●Maintaining confluence page for module on regular basis

●Gather business requirements, study the application, and collect the required information from developers, and businesses.

●Executed REST-based web services for API testing using POSTMAN

●Prepare Master Project Plan, Master Test Plan, UAT Test Plans, and Test Logs, Test tracks, Test Strategy, Test Scenarios, and execution of Test Case

●In an Agile environment attended daily stand-up meetings and reviewed user stories.

●Documented the defects in the Quality Center and assigned them to the relevant developer.

●Executed SQL queries to verify the database for the relevant test cases.

●Validate Source and target data matches using SQL

●Plan, design, and execute UAT testing for software products

●Identify the bugs and raise JIRA tickets and involve developers to get the issue resolved

●Conducted API Testing using Postman & Functional Testing to validate complete flow, including logs & database entries

Technologies: Jira, Confluence, Postman,, SQL Server, Oracle, PCF, qTest, Splunk,Swagger

SDET T- MObile Feb 2021-May 2023

Performed UI Testing & Functional Testing

Performed testing of multiple APIs

Used Postman for REST/ RESTful API Testing and Automated REST calls & worked on JSON data

Performed end-to-end regression testing & database testing.

Performed database testing using SQL queries for backend validation in Oracle

Participate in Agile meetings such as Sprint planning, Backlog grooming, Daily Standups and Retrospectives.

Configured APIs and header in Bladerunner for teams to test API

Good hands on debugging API issues like service down, increasing instances, API errors

Validate the error logs in SPLUNK and raise a JIRA ticket and assign it to the respective developers

Use swagger to check the API request and their mandatory and non mandatory headers

Execute regression tests in the morning/evening based on deployment timings and then gather reports and reach out to leads in case of any queries or failures in test

Execute sanity tests once the code is deployed to any new environments to verify whether any new codes are breaking in new environments

Facilitate and monitor UAT execution, track and document testing progress, ensuring alignment with project timelines

Perform Functional,regression,E2E testing of APIs

Act as the main point of contact between the project team and business users during UAT

Identify risks and potential bottlenecks during the UAT phase and escalate as needed.

Provide regular updates on UAT progress, including test results, defect summaries, and resolution statuses.

Validate that all critical issues have been resolved before final sign-off.

Triage the defects and work closely with developers and Business analyst to get the issue resolve

Technologies: Postman, Oracle, Agile, Jira, Confluence, JavaScript,MS SQL,Swagger

Sr. Technical Implementation Engineer, McKesson Nov2008–April 2014

Support McKesson ((HEC and Tracking Board), EPW, HOM, HMR, and HED), API, Imprivata, and Intellidesk. Provided 24x7 application support for issues and requests.

Served as HEC, tracking board, EPW primary analyst, and point-of-contact to answer customer inquiries regarding software application issues.

Developed business requirements and processes in support of implementations. Supported computer security policies through maintenance of user IDs, access rights, and profile changes as required. Performed system error analysis and security monitoring for assigned systems. Developed and maintained security documents.

Served as technical liaison and resource and primary point of contact for users and staff.

Created user accounts and passwords ensuring users had appropriate access to perform their job.

Led project including system design, setup, configuration, and installation.

Strong understanding of informatics standards and application to workflow at various customer sites.

Consult daily with customers on their current needs for process and workflow improvement for better adaptation of client’s needs.

Utilize SQL to troubleshoot and research errors within McKesson applications.

Identify bugs by performing functional, usability, compatibility tests

Maintain timeline/milestones of implementation in timely manner.

Successfully manage client build process throughout implementation phases leading to successful activation experience.

Collaborate with customers to analyze current system(s) while working to determine implementation solutions to improve overall customer functionality

Provide training, testing, and support to super users as well as end users during the implementation cycle.

Maintain consistent and effective communication with clients and current team for optimal implementation experience.

Technologies: BMC Remedy system, SQL Server, UNIX,LINUX

Technical support analyst NTT Data Dec 2007- Oct 2008 -- Apr-2004

Configure device like routers, switches in to HPUX monitoring system in Linux

Escalate to incident teams incase of Network down issues

Install monthly patches via remote desktop

Documenting outage information including actions taken to resolve the outage

The Network Monitoring team monitors multiple server solutions which are a critical to the functionality of our users’ ability to perform their mission

Monitor physical and virtual server performance to achieve a defined Service Level Agreements or SLAs

Provide and test backup and disaster recovery processes and procedures

Prepare and maintain written drawings, documentation, and reports

Monitor network services: File Servers, Print services, Active Directory, and DNS

Work with vendors in the process of troubleshooting escalated incidents

Monitor email for incidents and customer requests

Create virtual servers, pools/pool members, nodes, monitors, etc.

Knowledge of Monitoring protocols i.e.: SNMP, Syslog, NetFlow, etc.

Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

Install setup and configured oracle enterprise manager cloud control 12c as a tool of administration, performance tuning, monitoring, alerts and also OEM grid control 11g/12c.

Troubleshooting errors using Cluster ware logs and patching 11g and 12c RAC environments involved in upgradation of databases from 11. 2. 0. 4 to 12c in QA and dev environments.

Implemented asm on rac and standalone databases and managing disks and disk groups.

Technologies: BMC Remedy system,HP Openview, SQL Server, UNIX,LINUX

Education & Training

Bachelor of Electrical and Electronics Engineering

Master of Power Electronics and Drives

API Testing Database Testing SQL UAT.

Contact this candidate