Sql Server Quality
Resume:
Shivali Bais
Frisco, TX - *****
Email: ******@*******.***
Summary of Qualifications
• Lead QA Professional with over 13 years of experience in Information Technology industry with strong experience in establishing effective QA programs in small to large organizations
• Experienced in managing multiple projects simultaneously, providing accurate resource and time estimates, delivering projects on schedule, driving continuous process improvements, and defining and implementing development and quality practices, procedures, metrics and techniques.
• Solid experience in QA Testing methodologies, requirements gathering, generating Test Plans, Test Cases and Defect reporting.
• Expertise in problem solving and Defect tracking using Test Director and Quality Center.
• Experience in creating, executing and maintaining Test Plans, Test Scenarios, Test Cases and analyzed Traceability Matrix using Mercury Tools.
• Strong experience in writing test scripts and programming in WinRunner (TSL), QTP (VB Script).
• Expertise in testing web-based applications, client-server applications and ETL projects on Windows as well as UNIX operating systems.
• Good understanding of relational databases like Oracle, SQL Server, MS Access with proficiency in back-end testing using SQL.
• Experience in System Testing which includes GUI Testing, Regression Testing, Load Testing, Stress Testing, Functional Testing, Sanity Testing and User Acceptance Testing.
• Involved in all stages of Software Development Life Cycle (SDLC)
• Experience with Agile as well as waterfall methodology
• Very strong in Business Analysis and Implementing the user requirements as well as documentation.
Industry Experience
MedAssets (Broadlane Inc), Plano, Texas April 2007 - Present
Sourcing Support, Lead SQA
MedAssets helps healthcare providers find cash from existing operations and improve margins by providing comprehensive financial performance solutions which improve healthcare providers’ operating margins and cash flow, delivering the potential to increase a typical health systems’ net patient revenue by 1-3% and decrease supply expense by 3-10%. As a QA Lead of Sourcing Support Service Line, reporting to Director, QA, I am responsible for the quality of all software products and services for this service line. That is my top priority. But I’m also known for accepting challenges to tackle product problem areas and drive solutions to them.
Responsibilities:
• As a Member of the Change Board Committee, I was able to delay/stop many releases to Production environment which could have potentially ended up affecting other applications because of the Integration points.
• Defined standards and implemented IT quality assurance “best practices” and procedures in coordination across the teams (e.g. Use of “Releases” module in Quality Center to capture Agile Developments’ Sprint cycles)
• Worked with the Director of Development to improve the quality of the software going into QA. Established regular defect reviews, unit testing and handoff criteria.
• Conducted Scenario review meetings with Developers & Business Analysts on regular basis which helped them understand what kind of testing was being done and why.
• By Working closely with development teams, Project Managers, Business Analysts and Release Management teams to identify project time lines and resource requirements, I was successfully able to Direct and align testing resources, ensuring all deadlines were met while considering constraints on deadlines, and tech resources.
• Responsible for Recruiting and managing contractors for projects that had tight deadlines and not enough resources.
• Prepared test plans and involved in designing, documenting, reviewing, writing and executing test cases.
• Actively worked with other members of the QA team to constantly improve the process, tools, and effectiveness of the team. (e.g. gave a presentation about the role of QA in Agile Methodology)
• Coordinated frequent status check meetings with the team and provided the Weekly Status Reports to management.
• Because of my “Attention to Details” attitude I was asked to perform GAP Analysis for some projects where I had to compare applications and write down detail requirements for missing features which was then used by developers and QA.
• Successfully led the testing efforts in a cross functional team with offshore and domestic resources
• Held the role of QC Admin to add new users, change permissions for existing users, create new projects etc...
• Creatively found time and resources (within heavy software release workloads) to drive the automation of our tests using QTP. We were able to achieve 80% TestCase coverage for most of the applications via automation which saved us time during Regression testing.
• Developed Regression testing scripts using Web UI for Silverlight platform to determine which tool suites our needs.
• Validated test Results, logged defects and generated several defect reports using Quality Center which were sent to the whole team so they could understand the urgency of fixing the defects on time.
• Used HP Quality Center to document requirements, write Test cases, execute Test Lab and create defects.
• Currently working on efforts to move all the Quality Center Testcases & Defects to Rally as Rally is going to be our tool for Agile Development.
Technical Environment: SQL Server 2008/2005, Java, .Net 4.0, Silver Light 4.0, HP Quality Center 9.2, QTP 9.2/10.0/11.0, Web UI 4.0, Windows XP, Windows 7, IE 7/8, Mozilla Firefox 5, Rally
Blockbuster Inc, Dallas, Texas April 2006 – April 2007
ICV, Sr. QA Analyst
As a QA Tester I was responsible for the testing of an ICV and Total Access Applications for one of the largest retail company in the US in its kind.
ICV: This integrated customer view application consisted of two systems Loss Prevention and Target Marketing. LP lets the Blockbuster to prevent losses by identifying the fraud customers and TM lets the business create and pitch the customized campaigns to the customer.
Responsibilities:
• Involved in preparing Test Plan, Test Cases and Automation Test Scripts.
• Participated in meetings with BAs, DBAs, PM and QA for reviews on Business Requirements and Test Cases/Scripts.
• Developed automated scripts for UI and Back-End functionality using WinRunner (TSL).
• Developed Custom functions for use with Winrunner.
• Tested and Automated ETL functionality from Data Warehouse using Winrunner (TSL).
• Validated Data for up to 40 million records.
• Created Test Data for functional, Integration and UAT test scenarios.
• Created SQL files to load or reset database to cover all test scenarios.
• Used TOAD and Query Analyzer for querying Oracle Database
• Performed fail over scenarios for Apache, Weblogic and Database.
• Monitored the log files while executing the scripts.
• Used TestDirector as a Testing Repository, Defects Management, Test Execution and Test Coverage Tool.
• Created reports from TestDirector at different stages of testing using different filters
• Migrated most of the WinRunner scripts to QTP
• Participated in UAT with business owners.
Technical Environment: WinRunner 7.8, Test Director 8, Solaris, Java, XML, Oracle 9i, WebLogic, Apache, TOAD, MS Office Tools, Netscape, IE, Lotus Notes, QTP 9.0
Adea Solutions Inc, Irving, TX March 2004 - Feb 2006
Sr. QA Tester
Commission Tracking System (CTS) was built to capture employee’s general, salary, billing and time sheet information and generate various management reports. It allows recruiters, account managers and top management to keep track of the current consultants head count, new starters, projected finishers, commissions etc., The overall systems objective was to greatly reduce time and effort and to streamline the existing manual processes and automate them to perform the company’s IT staffing services efficiently.
Responsibilities:
• Automated existing Test cases using Mercury Interactive’s(now HP) WinRunner
• Prepared manual Test cases according to the Functional Specifications for new functionality
• Executed Test Cases to validate the functionality of transactions
• Conducted Functional and regression testing for Commission Tracking System
• Performed Sanity testing for all the builds
• Reported, Logged and Tracked defects using TestDirector
• Generated Reports like Consultant’s head count, new starters, and commissions from database using SQL queries.
• Maintained and Regularly updated Test Cases with every defect fix.
• Worked as BA as well as QA at times as this was in-house Application.
Technical Environment: Java, DHTML, JSP, JavaScript, TestDirector, WinRunner 7.0, TSL, SQL, Oracle 9
Nortel Networks, Richardson, TX May 1998 - May 2001
Member of Scientific Staff (aka QA Engineer).
The DMS-500 Local and Long Distance Switch is a DMS Super Node application that combines local services of the DMS-100 switch, and long distance services of the DMS-250 switch. In addition to the trunk connections supported by the DMS-250, the DMS-500 delivers all line types currently supported by the DMS-100 system for residential and business applications.
Responsibilities:
• Involved in writing Test cases For DMS-500’s features
• Review the design documents for requirements coverage and design detailed test cases based on class, object, state and activity diagrams. Develop test scenarios from system use-cases
• Performed Switch testing manually
• Created and implemented functionality tests manually
• Created Script files using Perl to atomize some testcases
• Designed and executed automated test scripts for Sanity testing
• Participated with the management team in Inspection and Walkthroughs
Technical Environment: UNIX, Perl
Employed as a contractor working for the DMS Software Integration and Release (SIR). This work was carried out on a UNIX platform using Netscape and VI editor, and involved interfacing with software design and test groups.
Responsibilities:
• Enhancement of all SIR automation tools using HTML and CGI
• Execution and troubleshooting all aspects of SIR Load build process
• driving the resolution of error conditions and deficiencies (obtaining customer and management approval when necessary)
• Provide feedback concerning completeness and accuracy of load
• Regularly meet with team leads, other team members and developers to evaluate the project progress
• Use SR system for defect tracking
Technical Environment: UNIX, TCL, HTML, CGI, Netscape
*Worked as a s/w Developer Prior to this
NexGen Information Systems, Bombay, INDIA. Mar 1996- Jul 1997
Development of Business Card product of AT&T targeted for a small business owners. My responsibility was to analyze Business Requirement Documents and prepare Detail Design Documents for base classes and GUI screens, prepare Object Interaction Diagrams, Code the Business Classes and Controllers, Code and design GUI screens.
Technical Environment: UNIX, C++, x-motif, select enterprise
Datasoft Application Software India Ltd, Bombay, INDIA. Dec 1994 - Feb 1996
TOTAL is a ‘Borland C++’ based Financial Accounting Package. My responsibility was to design and develop new module called ‘Designer Processor’. Also developed reports like ‘Trading Profit and Loss’ and ‘Summary report for General Ledger’.
Technical Environment: DOS, C++
Technical Skills
Testing Tools: HP Products (WinRunner 7.0/7.5/7.8, TestDirector 7.0/8.0, Quality Center 10.0, LoadRunner 6.5/7.8/8.0, QTP 9.0/9.2/10.0/11.0), Rally
Operating Systems: Windows Vista/NT/2000/XP/Window 7, UNIX, Sun Solaris.
Languages: C #, C++, C, Java, PL/SQL, VB, HTML
Scripting Languages: TSL, VB Scripts, Pearl
Databases: Oracle 8i/9i/10g, MS Access, SQL Server 2000/2005/2008
Internet Technologies: JavaScript, XML, HTML, ASP, JSP
Others: SQL Developer, PVCS, Visual Source Safe, J2EE technology, .Net Framework, TOAD, Query Analyzer, SQL Server Management Studio
Education
BS in Engineering (Electronics and Communication Engineering)
ITIL Certified
SWADA Certified
Lean Six Sigma Yellow Belt
PMP – Training in progress
Contact this candidate