We provide IT Staff Augmentation Services!

Db And Qa Analyst Resume

SUMMARY

  • Over 14 years of IT experience in analytical, technical and testing capacities during complete Software Development Life Cycle and Software Testing Life Cycle. Team Lead in various positions.
  • Full life cycle development from interacting with customers, gathering requirements and analyzing needs, Program Analysis, Design, Development, Testing, Deployment and Post Production support.
  • Skilled in QTP, Quality Center, agile methodology, and SQL.
  • Experience in requirements collection, analysis, documentation, assessing testing processes, creating, implementing test plan, testing strategies and SQA strategies using Agile - testing methodology in UAT phase.
  • Quality Assurance, Software testing (manual and automate) and Quality Assurance Metrics and Reporting.
  • Solid experience developing, designing and report writing in test plans, test scripts (VBScript and JavaScript), testing and tracking and reporting in web and windows based application using automated testing and test management tools QTP, QC, LoadRunner, Software Testing using Visual Studio(STVS) 2010 and Selenium (IDE, RC, WebDriver and Grid), NUnit, JUnit, Ant, TestNG, DbUnit, Jmeter.
  • Experience in Unit and Integration coding and testing in Java using Eclipse IDE and VB and C# in .Net framework.
  • Software development experience using Visual Studio .net (VB and C#) and Java (J2EE).

TECHNICAL SKILLS

Operating System: Windows NT, Windows 95/98/2000/XP/Vista, Windows Server 2003/2008, Exchange Server 2003, Windows 95/98, Unix, and RedHat 5.

GUI: Visual Studio.NET, MS SharePoint Designer 2007, MOSS (MS Office SharePoint Server 2007), Visual Basic 6.0, Dream weaver.

RDBMS: MySQL(+phpMyAdmin), SQL Server 2005/2008 (including SSAS, SSRS, SSIS and Informatica), Oracle 11g in including OBIEE, Sybase, RapidSQL, MS Access and MS Excel.

S/W Language: C#, ASP.NET, VB.NET, ECM, Java 1.4, C, C++, Prolog, Heskal.

S/W Testing Tools: Quick Test Professional (QTP), Quality Center (QC), Team Tracker, Win Runner, Load Runner(Vusers,VUGen), Software Testing using Visual Studio(STVS) 2010 and Selenium (IDE, RC and Grid), NUnit, JUnit, Ant, TestNG, DbUnit and JMeter.

Internet/Intranet: ASP.NET, ADO.NET, PHP, HTML, DHTML, JavaScript, Java, Eclipse VBScript, XML, SOAP, SOA, AJAX, ADO, ASP, IIS6, IIS7.0, Jboss, Active Directory, Apache, COM/DCOM, and Joomla.

Others: MS Project Management Tool, Eclipse, TOAD, MS Office, LaTex, Adobe Photo Shop, Flash, Norton Ghost, Partition Magic.

Reporting: Crystal Reports, SSRS, VB Data Report, and Dashboard.

Data Mining Tools: QuDA, Weka, FCA (Formal Concept Analysis) and SPSS.

Scripts: VBScript, JavaScript, Window Script and TSL

PROFESSIONAL EXPERIENCE

Confidential

DB and QA Analyst

Responsibilities:

  • Prepared development environment and test bed for software testing and development.
  • Installation, configuration and upgrading of MS SQL and Oracle database server software and Interfaced with MSSQL and Oracle for technical support.
  • Designed and developed Test Plan, Test cases, Test scripts, Test Scenarios and automate using QC.
  • Worked closely with Developers and Engineering Teams in the review and modification of the product, its specifications using Agile-testing methodology and Developing, designing and analyzing SW-CMM.
  • Performed Manual and Automated (Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) Test Tools including QTP and QC for the application under test and working in Agile testing Environment.
  • Performance, Load, Stress, Memory Leak testing for different application software using LoadRunner and QTP.
  • Provided Efforts Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.
  • Performed Functional, Smoke, System Integration, Regression testing and Cross Browser Testing as per the specifications and automated regression scripts (VBScript) using QTP.
  • Developed re-usable VB functions and procedures for repeatable scenarios.
  • Test enhancement by inserting various checkpoints (database MS SQL and Oracle 11g, bitmap, XML and text) to ensure test script’s reliability and validity.
  • Performed Data-Driven automated tests, parameterized the values from spreadsheet onto QTP Scripts.
  • White box, Unit and Integration testing and develop user define re-usable functions in Java and C# using Eclipse IDE and .Net environments.
  • Silver-light and Ajax (Java) handling in software testing process.
  • Provided support to automation team in debugging and developing automated test scripts, Descriptive Programming and VB functions using QTP.
  • Design, Setup and management of CCNet Server, NUnit, Selenium IDE and WebDriver.
  • Developed MS SQL, PL/SQL and T-SQL Scripts for back end database testing.
  • Involved in ETL using SSIS.
  • Developed test scripts and test scenarios for performance and load test using Load Runner.
  • Maintained QC for Defect tracking and creating Test Matrix and involve in user Acceptance testing (UAT).

Environment: ASP, VB, C#.NET, STVS 2010, MS SQL Server 2008, Oracle 11g, including SSIS, and ETL Informatica, PL/SQL, Oracle 11g, XML, MS Excel, Win Runner, QTP, QC, and Load Runner.

Confidential

DB and QA Analyst

Responsibilities:

  • Prepare necessary development environment and test bed for software testing and development. It includes installation/management/administrative parts of Visual Studios (VB.NET, C#.NET, ASP.NET), SQL Server, SSIS, SSAS, Sybase database, Informatica and Windows Server 2008.
  • Installation, configuration and upgrading of MS SQL and Oracle database server software.
  • Interface with MS SQL and Oracle for technical supports.
  • Design and develop Test Plan, Test cases, Test scripts, Test Scenarios and automate using QC.
  • Work closely with Developers and Engineering Teams in the review and modification of the product, specifications using Agile-testing methodology, developing, and designing.
  • Perform Manual and Automated (Unit Testing, Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) Test Tools including, LoadRunner (VUsers, VUGen), QC, and Selenium (IDE and RC) and SoapUI for the application under test and work in Agile testing Environment.
  • Provided Efforts Estimate and coordinate the test schedule using Agile testing methodology in UAT phase.
  • Perform Functional, Smoke, System Integration, Regression testing and Cross Browser Testing as per the specifications and automated regression scripts using STVS 2010.
  • Develop re-usable C# and Java functions and procedures for repeatable scenarios and Ajax (Java) handling in software testing process.
  • Create and use check points to compare expected values to actual values of object properties, generated during test run.
  • Test enhancement by inserting various checkpoints (database MS SQL, XML and text) to ensure test script’s reliability and validity.
  • Compare and analyze, while validating the existing applications against the current environment.
  • Perform Data-Driven automated tests, parameterized the values from spreadsheet onto STVS 2011.
  • Extensive experience with development and test methodologies including Agile.
  • Provide support to automation team in debugging and developing automated test scripts.
  • Work closely with the developers to resolve the bug issues and unit testing issues.
  • Develop MS SQL, T-SQL Scripts for back end database testing.
  • Develop test scripts and test scenarios for performance and load test.
  • Maintain QC for Defect tracking and creating Test Matrix and involve in user Acceptance testing (UAT).

Environment: ASP.NET, VB, C#.NET, STVS 2010, IIS, Apache, MS SQL Server 2008 including SSAS, SSIS, SSRS and ETL Informatica, PL/SQL, T-SQL, RapidSQL, HTML, XML, MS Excel, Selenium IDE, Selenium RC, JMeter, JUnit, NUnit, TestNG, SOA, soapUI, Win Runner, QC, Load Runner, Windows environment.

Confidential

DB and QA Analyst

Responsibilities:

  • Prepared development environment and test bed for software testing and development. It includes installation/management/administrative parts of Visual Studio (VB.NET, C#.NET, ASP.NET), SQL Server, Oracle database, Informatica and Windows Server 2003.
  • Installation, configuration and upgrading of MS SQL and Oracle database server software.
  • Interfaced with MS SQL and Oracle for technical support.
  • Designed and developed Test Plan, Test cases, Test scripts, Test Scenarios and automate using QC.
  • Worked closely with Developers and Engineering Teams in the review and modification of the product, its specifications using Agile-testing methodology and Developing, designing and analyzing SW-CMM.
  • Performed Manual and Automated (Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) Test Tools including QTP, LoadRunner (VUsers, VUGen), QC, and Selenium (IDE and RC) and soapUI for the application under test and working in Agile testing Environment.
  • Provided Efforts Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.
  • Performed Functional, Smoke, System Integration, Regression testing and Cross Browser Testing as per the specifications and automated regression scripts (VBScript) using QTP.
  • Developed re-usable VB functions and procedures for repeatable scenarios.
  • Created and used check points to compare expected values to actual values of object properties, generated during test run.
  • Test enhancement by inserting various checkpoints (database MS SQL and Oracle 11g, bitmap, XML and text) to ensure test script’s reliability and validity.
  • Compared and analyzed, validating the existing applications against the current environment.
  • Performed Data-Driven automated tests, parameterized the values from spreadsheet onto QTP Scripts.
  • Extensive experience with development and test methodologies including Agile.
  • Provided support to automation team in debugging and developing automated test scripts, Descriptive Programming and VB functions using QTP.
  • Worked closely with the developers to resolve bug issues and unit testing (NUnit) issues.
  • Developed MS SQL and PL/SQL Scripts for back end database testing.
  • Involved in ETL using SSIS and Informatica, analysis activities SSAS and report/publication.
  • Developed test scripts and test scenarios for performance and load test using Load Runner.
  • Maintained QC for Defect tracking and creating Test Matrix and involve in user Acceptance testing (UAT).

Environment: ASP, VB, C#.NET, STVS 2010, IIS, Apache, PHP, MS SQL Server 2008 including SSAS, SSIS, and ETL Informatica, PL/SQL, Oracle 11g, HTML, XML, MS Excel, Selenium (IDE, RC) JMeter, JUnit, NUnit, SOA, soapUI, Win Runner, QTP, QC, Load Runner, Windows and Linux environment.

Confidential

Lead QA Automation

Responsibilities:

  • Performed B-testing including Regression, Integration, and System testing of the Application software under test. It includes Functional, Smoke, System Integration, Regression testing, Web Service testing and Cross Browser Testing as per the specifications using QTP, Selenium (IDE, and RC), Nunit, TestNG and soapUI.
  • Designed and developed Test Plan, Test cases, Test scripts, Test Scenarios and automated using QC.
  • Performed Manual and Automated testing (Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing)utilizing Test Tools including QTP, LoadRunner(VUsers, VUGen), QC, and Selenium (IDE and RC) and soapUI for the application under test and worked in Agile Environment.
  • Worked closely with the Developers and Engineering Teams in the review and modification of the product and its specifications using Agile-Scrum methodology.
  • Interfaced with MS SQL, Oracle for technical support.
  • Database Design, Development and Implementation (includes DDL, DML and DCL).
  • Created Store procedure and Trigger Plan in MS SQL Server.
  • Developed test data and test hardness using MS SQL, Oracle 11g and Excel as back end and VBScript and JavaScript as front end Test.
  • Involved in ETL using MS SSIS and Informatica, analysis SSAS and Reporting and publication by using SSRS and OBIEE.
  • Worked as a part of a team and provided 7x24 supports in database management.
  • Performed Load, Stress, Volume and performance testing of the application using HP Load Runner and JMeter.
  • Extensive experience with development and test including Agile and Test Driven Development.
  • Conducted Users’ Acceptance (UAT) and participated in defect review status meetings.

Environment: ASP.NET, VB, C#.NET, VBScript, JavaScript, IIS, Apache, PHP, MS SQL Server 2008 including SSAS, SSIS, SSRS and ETL, PL/SQL, Oracle 11g, HTML, XML, MS Excel, QTP, QC, JMeter, Selenium IDE and RC, SOA, soapUI, WinRunner, LoadRunner (Vusers,VUGen), Unix and Linux.

Hire Now