Sign in

Management Sql Server

Langhorne, PA, 19047
August 10, 2012

Contact this candidate


Shruti Nadadur Ramakrishna



Over 7+ years of experience in analysis, design and development of client/server, web based and n-tier application along with extensive experience as a Quality Analyst with exposure to both manual and automated testing tools. Specialize in writing Test Plans, Test Strategy, Test Cases, Traceability Matrix and Status report documents. Good knowledge in Governance, Risk and Compliance management and casino games domain. Ability to resolve uncovered defects of an application in early stage of SDLC, which helps to improve the application’s quality and reduce development cost. Excel under pressure in deadline driven environment with superior interpersonal communication and technical documentation skills.

Professional Expertise

Experienced in manual testing with the focus on Functional Testing, End to End Testing, Stress Testing, Regression Testing, Smoke Testing, Load Testing, System Testing and Unit Testing, Adhoc Testing and Black Box Testing, Writing Test Cases, GUI Automation testing, System Testing, Integration Testing and User Acceptance Testing

Extensive experience in performing reviews like Test reviews and peer reviews for maintaining best coding standards.

Efficient in implementing QA Process, established standards, procedures, and methodologies and also have a solid expertise in HP Quality Center.

Experience in developing and maintaining QTP functional scripts for regression testing including dynamic parameterization using datasheets, database tables and external excel spreadsheets, virtual objects, checkpoints.

Good Understanding of Agile approaches like user stories, Programming, Test-Driven Development, Daily Stand-ups, Retrospectives, Pair Programming and Scrum meetings.

Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.

Prepared Test plans, Test cases reviews, test cases execution, and designing, executing, verifying and analyzing test programs, creating Defect Information reports, Defect status report, Weekly status reports, and Traceability matrix.

Experience in working on Governance Risk and Compliance (GRC) Management domain.

Experience in working on Casino games domain

Experience in working on projects developed using VB, ASP,.NET, Web services -SOAP, UDDI, WSDL, HTML, Oracle, MS SQL Server, VBScript, JavaScript and Flash.

Formulated and tested queries with SQL on an Object/Traditional Relational Database.

Exposure to all phases of Software Development Life Cycle (SDLC). Also worked in SDLC models like Waterfall and Agile.

Expertise in developing SQL and PL/SQL codes through various stored procedures, functions, triggers to implement the business logics of database in Oracle and SQL Server 2000/2008.

Completed PCSTEplus (Practioner’s Course on Software Test Engineering) Program from STAG Software.

Excellent analytical, communication and Interpersonal skills. Also have led small teams in implementation of projects. Good at mentoring newbies and have excellent leadership skills.

Good team player with the ability to manage and work independently in a time sensitive environment.

Technical Skills

Testing Tools Quick Test Professional 10.0, Rational Functional Tester, Load Runner

Business Intelligence Reporting Tools Twiki, Crystal reports

Operating system Windows 95/98/NT/2000/XP, Win7

Databases SQL Server Management Studio, PL/SQL

Web Technologies VB Script, HTML,

Version Control Tools SVN, CVS,VSS

Utility Tools MS Word, MS Excel, MS PowerPoint

Professional Experience

MetricStream :

Client: UBS Financial Services Inc, Washington, DC From Sep ’10- Jun ‘12

Senior QA Analyst

UBS draws on its 150-year heritage to serve private, institutional and corporate clients worldwide, as well as retail clients in Switzerland. They combine their wealth management, investment banking and asset management businesses with their Swiss operations to deliver superior financial solutions.

Audits module is designed for UBS to perform Audits management which help the firm in managing their supplier quality audits process. It also helps to maintain the relevant data to meet their organizations quality and compliance requirements. Typically, the audits are done based on a schedule prepared for the complete year. Audits can also be performed On-Demand or Adhoc basis. The audit schedule is prepared keeping in mind the criticality of the processes, systems and procedures established to achieve the required quality in the organization’s products and services. The maturity level of the quality system implementation governs the extent of monitoring, required in ensuring complete adherence to the established systems and procedures. Quality Audits are an integral part of

any Quality Management System to verify compliance to the established systems and procedures in an organization.


Agile development - Participated in daily scrum meetings to report daily progress of Automation activities and Sprint planning for test planning activities.

Designed test cases for manual and automation testing, developed and maintained checklists for regression using QTP automation, functional and system testing.

Created and executed QTP test scripts suites for daily regression runs.

Participated in strategy and status meetings to report issues and also in Build release meetings and QA status meetings.Communicated with developers through all phases of testing to prioritize bug resolution.

Developed SQL-queries/procedures for database and backend testing using SQL Server Management Studio.

Used Bugzilla for repository, reporting and tracking bugs, and providing updates on resolved bugs.

Verified and analyzed errors and recommended modifications to the Developer.

Participated regularly in daily status meetings and reported to the QA Manager.

Effectively implemented different QA methodologies/policies, strategies and plans in all stages of SDLC.

Understanding the UBS business, Usecases and transer the knowledge to the team.

Involved in scheduling and executing test sets, collecting test result, and analyzing the data using Twiki.

Performed System, Functional, and Regression test and verified all the failure conditions enhancement.

Participated in Validation and Data driven testing with different sets of data.

Responsible for testing Reports and Auditing Reports. Wrote SQL queries to access the data from the database tables and crosscheck the results.

Developing defect tracking and analysis procedures.

Participated in design, walkthrough and review meetings.

Environment: Quick Test Professional 10, Windows/Web Applications, SVN, SQL Server Management Studio 2008, Team Foundation Server 2010, Agile-Scrum Methodologies, Java, PL/SQL, VB Script, Windows 7

MetricStream :

Client: Pfizer, NY Jun ’08 – Aug ’10

QA Analyst

We have a leading portfolio of products and medicines that support wellness and prevention, as well as treatment and cures for diseases across a broad range of therapeutic areas; and we have an industry-leading pipeline of promising new products that have the potential to challenge some of the most feared diseases of our time, like Alzheimer's disease and cancer.

Complaints Management module is designed to help FDA regulated companies to manage their complaints management process, to meet their organization’s quality and compliance requirements. The Complaints Management module will allow the FDA regulated customers to record the complaints in the system, conduct a preliminary investigation, complete investigation, and identify regulatory reporting requirements in line with US FDA MedWatch and EC reporting requirements. The Complaints Management module is integrated with the CAPA for initiating corrective actions for the complaints that were taken up for investigation and that need corrective action to prevent recurrence.


Interacted with multiple business users and technical teams across the organization.

Worked with Business/system clients building requirements. Coordination with team in making them practice agile.

Analyzed and Performed Gap Analysis based on requirements documents.

Identified root causes, analyzed and provided solutions to critical, medium and low issues in a reasonable timeframe.

Clearly understood the requirements and prioritized tasks and exceeded expectations by delivering ahead of time.

Created and executed test scripts, plans and raised defects ensuring quality of Web applications with an agile environment.

Responsible for creating test cases and test scripts based on requirements.

Maintained positive customer relationship by exceeding expectations.

Tested web application with passing values through SQL Queries.

Involved in the complete lifecycle of automation, including testing and deployment to improve the efficiencies and reduce the manual errors.

Handled release management meetings every day following the SDLC process to have a smooth release.

Actively learned new process and developed templates for documenting the process, metrics etc.

Involved in Regression testing, Functional testing, Integration, system, and UAT testing.

Responsible for preparing RTM (Requirement Traceability Matrix).


PL/SQL, JavaScript, QTP 9.5, Load Runner 9.5, Oracle 9i, Windows/Web Applications, Twiki, SVN, Agile-Scrum Methodologies

Award: Received a “Special Achievement Award” for working on the above project.

Defense Acquisition University, Fort Belvoir, VA Mar ’07 – May ’08

Business Analyst and Tester

The Defense Acquisition University is the one institution that touches nearly every member of the Defense Acquisition Workforce throughout all career stages. The university provides a full range of basic, intermediate, and advanced certification training, assignment-specific training, applied research, and continuous learning opportunities. The university also fosters professional development through mission assistance, rapid-deployment training on emerging acquisition initiatives, online knowledge-sharing tools, and continuous learning modules.

Mission Assistance System, a project estimation Web Application for the Defense Acquisition University (DAU) where support agreement (contracts) are estimated and created in order to support Mission Assistance Efforts in which a product or service to other agencies is provided.


Understanding and capturing the business requirements, creating Functional specification documents and transferring the Knowledge to the team.

Test Plan, Test Strategy documents

Providing estimates and the work for modules being handled.

Creating and generate daily reports in QC to manage the work for team (Summary reports for Test case creation and Execution)

Participating in daily defect review meetings to discuss and assign defects

Reviewing testing artifacts and getting approvals from client/SME.

Involving in offshore meetings, Build release meetings and QA status meetings.

Prepare Status Reports in QC every week with QA status to help in monitoring the amount of work done for current week and plan for next week.

Involving in Project management meetings (PMO) and escalate issues with reasons for showstoppers.

Environment: VSS, Visual Studio.Net 2008, .NET Framework 2.0/3.5, ASP.NET, C#, SQL Server 2005, JavaScript, XML, Web Forms, Obout Tools, Crystal Reports 11.

Openbet-NDS, Bangalore, India Aug’05 – Feb ’07


OpenBet (formerly Orbis Technology) is the leading provider of software for interactive gaming and betting solutions. It is all about catering to the needs of the customer while maintaining the back-end operations viz., Admin to maintain and control the customer details and accounts. The front end is

developed using flash. There are different types of casino games viz., Card games like Blackjack, Poker, HiLo games etc, Slot games like 1 line slot, 2 line slot 20 line slot and 30 line slots.


Involved in the Functional, GUI, regression and retesting of Fixed Odd Games logic, Flash Animations, bets and winnings for games both in demo and real play.

Analyzed Project plan, Requirements, and Design Documents for Integration Layer interfaces.

Created, reviewed and executed test scripts of variety of games like Slot, Card, Roulette, Scratch cards, third party games, etc.

Testing of admin tool which administers the user profiles, cookies, and sessions forcing results on the flash games.

Participated in strategy and status meetings to report issues and also in Build release meetings and QA status meetings.Communicated with developers through all phases of testing to prioritize bug resolution.

Effectively implemented different QA methodologies/policies, strategies and plans in all stages of SDLC.

Understanding the casino games, Usecases and transer the functional logic to the team.

Involved in scheduling and executing test sets, collecting test result, and analyzing the data using Phpbugtracker.

Performed System, Functional, and Regression test and verified all the failure conditions enhancement.

Participated in Validation and Data driven testing with different sets of data.

Responsible for testing Reports and Auditing Reports.

Developing defect tracking and analysis procedures

Involved in creating Traceability matrix, High Level Plan, Mid Level Plan and Low Level Plan in the iterative process of the Agile methodology.

Involved in Continuous Integration Testing, End to End testing and UAT.

Involved in the Performance testing activities at the final stage of the program

Involved in preparing Run comparison reports and analyzing various Performance Runs.

Involved in the Test data preparation for functional and performance testing.

Provided support for UAT testing as required for the application or any other assigned application.

Worked with Data Designers & Developers to assure project standards and criteria are met.

Environment: Flash, JavaScript, XML, Web Form, Informatica DB2, Windows and MAC OS, Random Number Generator Server, Fixed odd games (FOG) Server, TOMCAT Server.


B.E. in Electronics & Communication Engineering at Visvesvaraya Technological University, Karnataka, India

Contact this candidate