We provide IT Staff Augmentation Services!

Db And Qa Analyst Resume

5.00/5 (Submit Your Rating)

Baltimore, MD

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, Baltimore, MD

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, Tampa, Florida

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, New Jersey

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.

Confidential

Project Management

Responsibilities:

  • Preparation of software project plan baseline, requirements, project cost, schedule, work breakdown and scheduling, resource management, work in progress, and work completed) of practical project Capita Selecta.
  • Detailed design and preparation of project (above) by using MS Project Management software.
  • Prepared and managed day to day activities, including the schedule of the project assigned.
  • Identified the different possible project risks and possible risk management solutions.
  • Took part in monitoring and Evaluation including Agile and Scrum.
  • Designed and coded of Library Book, keeping application software in Java and Eclipse environment.
  • Program development of Library Book, Keeping information system software.
  • AspectJ was used in the project to validate as a crosscutting concern due to various scenarios and reservation policies that had to be validated whenever booking was performed.
  • Object caching is another crosscutting concern that was implemented on a system seeking for performance optimization.

Environment: Java, JavaScript and Eclipse / Post: Project Lead

Confidential

QA Automation Lead

Responsibilities:

  • Involved in preparation of Request for Proposal /Invitation to Bid for Core Banking System of Confidential Limited, Nepal.
  • Direct involvement/dealing with the Vendor in queries related to user’s requirements, RFP and ITB.
  • Extensive experience with development and test methodologies, software CMM, including Agile and Test Driven Development.
  • Reviewed business requirements and preparation of technical specification of the business requirements.
  • Database Design, Development and Implementation (includes DDL, DML and DCL).
  • Created stored procedures and Trigger Plans using SQL and PL/SQL statements.
  • Developed test data and test hardness using MS SQL server 2005, Oracle 9i and Excel as back end and VBScript and JavaScript as front end Test.
  • Performed ETL processes using MS SSIS and Informatica, analysis SSAS and reporting SSRS.
  • Prepared various test plans of the project, test case and test scripts (VBScripts) maintained in Quality Center
  • Rational Unified Process (RUP) was followed throughout project and all artifacts are generated for each discipline.
  • Involved in Joint Application Design (JAD) session to gather requirements from all division and field offices.
  • Developed and design necessary test plan and test scripts for functional and performance testing using testing tools QTP, Selenium (IDE and RC), TestNG, Nunit, LondRunner and Jmeter.
  • Performed Manual and Automated testing (Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) using Test Tools including QTP, LoadRunner(VUsers, VUGen), QC, and Selenium (IDE and RC) and soapUI for the application under testing and worked in an Agile testing Environment.
  • Performed user’s requirement analysis and was involved in integrating of various modules.
  • Performed Manual and Automated Test Tools including QTP, LoadRunner, QC, and Selenium for the application under test.

Environment: ASP.NET, VB, C#.NET, IIS, Apache, MS SQL Server 2008, Oracle, SQL, PL/SQL, HTML, XML, MS Excel, ETL Informatica, QTP, QC, VBScript, JMeter, JUnit, Selenium IDE and RC, SOA, WinRunner, LoadRunner, Unix and Linux.

Confidential

Project Lead

Responsibilities:

  • Designed and developed user entry Screens to capture the customer orders.
  • Developed windows based applications to generate various reports using Crystal Reports.
  • Business components were incorporated in an application server (IIS).
  • Built, developed and managed a SQL Server relational database using data warehousing.
  • Created tables, indexes, views and Stored Procedures in MS SQL Server 2008.
  • Maintained project plan on a daily basis and submitted project report to management.
  • Developed project modules based on the given requirements.
  • Arranged meetings with project management team and modified according to the Project team.
  • Facilitated Integration of all the components and debugged for the final solution (Iterative process).
  • Involved in Software development and tested complete Software Development Life Cycle (SDLC) of the project.
  • Performed functional, and automation testing using QTP.
  • Created SSIS packages to automate Import and Export of data to and from SQL Server 2005 using SSIS tools.
  • Skilled in SQL 2005 Business Intelligence tools, Data Warehousing and ETL processes & strategies using SQL server Analysis and Integration Services.
  • Utilized extensive knowledge in tuning SQL, PL/SQL (DDL and DML) queries to improve the database performance and availability.
  • Worked as a part of a team and provided 7x24 supports when required.

Environment: ASP.NET, VB, C#.NET, IIS, Apache, PHP, MS SQL Server 2008, Oracle, SQL, PL/SQL, HTML, XML, Crystal Reports 8.5, QTP, WinRunner, JMeter, NUnit, .NET Framework.

Confidential

Project Lead

Responsibilities:

  • Web Server Configuration and site hosting in MS Windows Server 2003 environment.
  • Mail Server Configuration in Linux.
  • Databases (MySQL, MSSQL Server 2008 and Oracle 9i) installation, configuration and management.
  • Designed browser based Admin application for data maintenance.
  • Create users and provide users right in active directory in platform windows server 2003.
  • Intranet design and setup in ADBL, Head Office complex.

Environment: MS Windows Server 2003, MS Exchange Server 2003, Linux, IIS, Apache, PHP, MySQL, MS SQL Server 2008 and Oracle 9i.

We'd love your feedback!