Sql Server Data

S A. S

Harrison, New Jersey (NJ) ***** C: 201-***-**** ******.**********@*****.***

High-performing professional with5+ year's experience specializing in SQL Server and Software Testing. Able to gather, model and utilize key data for diverse projects. Technologically savvy and capable to learn new programs quickly. Authorized to work in the USA for any employer.

SQL Server 2005/08

Manual Testing and QA

PL/SQL OCA Certified

Mantis DB bug tracker

UNIX Scripting

Putty, Filezilla, Vi, Notepad+

SQL Server Studio

QTP Automation testing

MS Word/Excel/PowerPoint

EMC Networker

Remedy ticketing tool

Analytical thinking

Proficient in writing complex SQL Queries in order to create Stored Procedures and use complex INNER and OUTER JOINS for Reports.

Experienced in creating different database objects such as Tables, Indexes, Cursors, and Triggers etc Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts

Experience in Tuning SQL Statements and Procedures for enhancing the performance of Databases. Designed data models, contributed to the overall design and implementation of the data warehouse Participated in all data warehouse planning and execution and Involved in the meetings with business users to design the business required document for the enhancements proposed Worked on various complex stored procedures on the backend to calculate budget data and provide actual and forecast information for all domains and Extensive experience in Korn shell scripting, sed and Vi editor Coordinated with production support and DBA team in refreshing the existing Database instances from the production servers and Provided the data as required for the front-end developers to restructure the existing presence of the UI Screen

Excellent knowledge of Software development life cycle (SDLC) and Software test life cycle (STLC) Participated in Requirement Analysis with the development team and the client Experience in creating and developing strategic Test plans, Test Cases, Test Scripts and generating Test Reports for Manual tests and Performed extensive Manual Testing on Web-based Applications Proficient in writing UNIX Shell scripts for automating project activities and well versed in Functional Testing, Integration Testing, System Testing, Regression Testing, GUI Testing and User Acceptance Testing (UAT) Actively interact with the development team in resolving Bugs identified from Testing, Extensive experience with editors like Vi, Editplus etc

Highly Motivated, Detail oriented, Versatile and able to work independently or as a part of a team In addition to excellent technical abilities possesses strong oral and written communications skills, analytical, interpersonal skills and problem-solving skills

O

S

P S

SQL Server Developer, 02/2014 to 04/2017

Skiva Technologies – Bengaluru, KA

Created new Database with objects such as tables, views, indexes, trigger and maintaining Referential Integrity Created and managed databases for clients as well as systems and reporting of finalized data Maintained the security, integrity, and availability of SQL server Performed data extraction and migration activities for populating test (or non-production) and customer databases Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications Tuned complex SQL queries, Created configuration files to execute the package in multiple environments Developed implemented and executed a quality assurance program and quality control standards for all ETL Performed regular data consistency, quality, and reliability checks and Participated in all data warehouse planning and execution Wrote Shell scripts to automate different project activities. Designed data models, contributed to the overall design and implementation of the data warehouse Implemented incremental loading as per the daily changes in a source database and applied event handlers, checkpoints and error logging on the failure of packages.

Developed Unix Shell Scripts to generate reports

Configured packages to operate them in testing and production environments and scheduled jobs to run Generated daily, weekly and monthly Ad-hoc reports in SQL Server Reporting Service (SSRS) on the products, Generated analytical reports of market research data and existing customer data using SSRS and reported to the Marketing Department

Developing special Shell Scripts to retrieve the data from different tables and also from the specific directories/Locations, format the data and to verify the data before loading into Tables Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reports to the end users and Making daily basis reports as per requirement using MS Reporting Services Created different user level groups and assigned the appropriate permission level to the database, This made sure that only the right person with enough authority would be able to see the Customer Information Communicated status with data warehouse and business intelligence teams and assisted in resolving data-related problems

Master working in OLTP & OLAP environments using SSIS, SSRS and SSAS cubes that include QA, Production, and development, implemented and maintained database schema and Entity relationship (ERD) diagrams from business requirements

Good knowledge of defining, developing and deploying Star Schema, Snowflake Schema and Dimensional Data modeling using SQL Server Analysis Services (SSAS) Used SQL Server Profiler to apply traces on the stored procedures and queries and rebuild them to improve the performance

Designed data models, contributed to the overall design and implementation of the data warehouse Lead QA Tester, 02/2014 to 04/2017

Skiva Technologies – Bengaluru, KA

Promoted to serve as lead QA tester, overseeing quality-assurance testing and teams for client software and systems development projects and Performed system, unit, performance, load, regression, stress, and data interface testing. Provided client developer teams with detailed reports on quality metrics, identified bugs flaws and recommended fixes and Created company's first comprehensive database of documented test defects and procedures to enable accurate replication and ensure compliance with standards

Accelerated average QA testing turn-around time, allowing a company to accept more testing projects without W H

increasing staff

Designed and implemented automated testing tools and programs addressing areas including database impacts, software scenarios, regression testing, negative testing, error/bug retests, and usability Documented software defects using bug tracking system reported defects involving program functionality, output, online screen and content to software developers

Acted as liaison between development and business teams provided visibility and clarity into business requirements to the development teams, and provided design and architecture insights to the business teams Coordinated QA, UAT sessions and executed UAT scenarios with end users for final approval and user sign-off As a Mobile Tester and QA Engineer, performed manual and automated testing for the Skiva router setup web application across multiple browsers ((IE, Firefox, Safari, and Chrome) and Skiva router setup application on mobile devices (Android, iOS)

Created and executed manual functional, regression, system, integration and exploratory tests Analyzed Functional Requirements and Business Specification as part of Static Testing on earliest stages of SDLC Responsible for creation, design, and execution of test strategies, including writing test plans, test cases, and test scenarios and Involved in writing Requirement Tractability Matrix (RTM) detailed Test Plan Performed test automation using HP Quality Center, Identified, analyze, and document defects using Mantis defect tracking systems and Participate in weekly test planning, project status meetings, and reviews Developed and implemented QA Methodologies for the department, This included but is not limited to development of test case standards, requirements traceability matrix, and testing metrics Worked closely with project manager and Project team to learn about the project functionalities and provided testing timelines

Tested the application under different networks and Internet speeds including on 3G and Wi-Fi and Involved in a testing application on different mobile Platforms such as iOS and Android devices Attended Demos and met with Client for User Acceptance and providing QA Signoff on the testing A Tested Web app, Native app using SeeTest for automated the mobile testing and run the scripts on multiple devices with VBScript using QTP, and also performs manual testing according to the requirements Delivered thorough QA testing reports that determined product quality and release Senior Executive, 07/2011 to 07/2012

Vodafone India Service Pvt Ltd – Pune, MH

Manage, administer and maintain IT Backup infrastructure. Troubleshoot system issues monitored scheduled jobs and monitoring SQL server databases

Created and Maintained Users roles groups and granting the privileges to users and Groups and maintaining security up to date

Running daily health check scripts Writing Shell scripts using awk and sed for pattern matching and log file analysis and Managed provisioning, performance, availability, and capacity for Backup environment Provided technical expertise to other departments in Vodafone and monitor alert logs Improve current processes implement best practices and technical standards Responsible for installing, configuring and troubleshooting any issues for the Backup infrastructure Design, manage and support a mixed environment of Backup systems(EMC Networker) Perform troubleshooting, incident, and error handling for systems Assist in the identification, development, and maintenance of policies and procedures that are relevant to the proper operational functions of the Backup infrastructure Configuration and capacity management of Backup infrastructure Wrote Shell scripts to test the modified Stored Procedures which will make use of awk, sed etc

Quality assurance of new and existing Backup systems. Lifecycle management of all Backup infrastructures Evaluation of tools and applications to monitor backup infrastructure and Running analytical troubleshooting techniques on the systems that malfunctioned

Being a “technical consultant” for junior and new beginner Backup Admin as well as the others in the group Maintain operational readiness ensuring complete recovery in the event of a disaster. Attend daily routine tests regularly

Operational support of all IT Backup infrastructures on 7*24 bases to provide continuous IT services availability and issue resolution

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools

Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring and Replication

Expert experience in implementing operational automation and Documenting and Reporting the bugs found to the team and tracking it with Remedy ticketing tool

Work on priority 3 and priority 4 Incidents and update incident in remedy tool, Restore backup as per client request Graduate Trainee, 06/2010 to 06/2011

GAP Technologies – Pune, MH

Gathered data and built financial models around key metrics Involved in programming module screens like Employee, Work Assignment etc Monitoring SQL Server activity through a profiler

Query tuning and optimization through T-SQL

Design and implementation of database maintenance plan Performance optimization and normalization of the database Designed database schema validation tool using stored procedures Migrated data from Access, a Textfile to SQL server through DTSJob, Scheduling, batch, alert and E-mail notification setting

Created Database objects including Tables, Triggers, and Views Set database access privileges for different users and user groups Bachelor of Engineering: Computer Engineer, 2010

SKN Sinhgad Institute Of Technology & Science - Lonavala, MH, India Oracle Certified Associate PL/SQL developer

Diploma Program in Software Testing

Brain bench certifications in SQL, UNIX, and Software testing E

C

Contact this candidate