Summary

Software Quality Analyst with 6 years of extensive experience in the Software Testing of Web-based, database and Client/Server applications. Actively participated in all the stages of software development and testing Life cycle. Highly proficient in manual testing and automated testing with exposure to managing the testing discipline including automated testing experience using tools such as QTP, Quality Center, Web services, Selenium and UAT testing etc

Highlight:

• Extensive experience in Information technology field in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP.
• Experience in Designing and creating Test Plans, Test Cases, and Test Scripts for Integration Testing, Functional Testing, and Performance Testing phases.
• Good exposure in developing and managing software QA programs.
• Proficient in writing and executing test cases with usage of various databases, tools for bug tracking and generating reports.
• Very good experience in Web services testing using SOAPUI.
• Solid understanding of process improvement like CMM, TQM and Six Sigma
• Project estimation and planning activities Functional and technical requirement review
• Verification and Validation of code root cause analysis and defect monitoring.
• Strong Proficiency in Black box, White box, Regression, Manual testing.
• Experience in generating reports using Informatica, Business Objects, OBIEE and Crystal etc.
• Experience in working both Agile and traditional Water fall Methodologies.
• Extensive ETL testing experience using Informatica Power Center/ Power Mart .
• Creating and defining software testing architecture, which includes the key technical decisions that constrains the overall design and implementation for a project
• Proficiency in interacting with SQL Server, DB2 databases using SQL.
• Excellent Oral and Written Communication, Presentation, Analytical skills.
• Detailed knowledge of the Software Development Life Cycle SDLC process for both waterfall and iterative, V-Model, RAD, QAI development methodologies.
• Proficient in writing detailed test cases, executing test cases, and analyzing windows based applications.
• Ability to work on multiple projects simultaneously for functional QC testing and related activities.
• Experience in ETL, Extract, Transform and Load of data using back end to validate results.

Technical Skills:

Professional Experience:

Confidential

DWH/ETL QA Analyst

Responsibilities:

• Working with subject matter experts to review business requirements then translate those into test cases.
• Leveraging best practices and methodologies to increase productivity, improve process efficiency, reduce production defect, strengthen end-user product.
• Design test plans, cases and scripts, and set execution criteria.
• Implement quality and continuous process improvement to reduce cycle time, cost, manage scope, schedule, quality, risks and increase customer satisfaction.
• Perform validation of data mapping and all transformation constraints and derivations, intermediate files and tables, and all output specifications in Informatica
• Perform System Integration SIT , Functional and Regression testing on applications.
• Involved in full QA life cycle: Unit Testing, Integration Testing, Regression, Smoke Testing and User Acceptance Testing UAT .
• Test MQ workflows.
• Perform Backend Testing, Database Integrity testing using SQL Queries.
• Perform end-to-end testing on the release version of the software application.
• Define procedures for change management process, requirement management, defect management process, and peer review process.
• Responsible for weekly status to show the Progress of the testing effort
• Develop and execute ETL test plans that ensure the quality of data transformations, data extraction, transformation and load programs ETL Data Mapping for a data warehouse, data models and ensure referential integrity.
• Perform data validation of all transformation constraints and derivations, intermediate files and tables, and all output specifications in Informatica.
• Performed Web services testing using SOAPUI.
• Follow an Iterative development testing for client's web application using Rational Unified Process RUP .
• Implement Mercury Interactive Quality Center for Business Process testing.
• Create test implementation methodology and work with developers, business team and other stakeholders to define the high level approach to testing.
• Execute and document test results.
• Conduct test readiness review with management.
• Establish templates for all test documents.
• Assist in the coordination, planning, and hosting of the User Acceptance Testing.
• Work with developers and the functional team to resolve problems.
• Perform manual testing for various test cases for module functionalities.

Environment/Tools: HTML, CSS, Intuit QuickBase, VISIO, SQL, Adobe Products, Informatica, Sun Solaris, Oracle 10G, SOAPUI, Quality Center, Windows XP/2000.Unix, Apex Explorer, Sales Force.com

Confidential

DWH/ETL QA Analyst

Responsibilities:

• Involved in all the phases of Software Development Life Cycle SDLC .
• Performed Business process analysis of the custom Web Applications.
• Involved in gathering User requirements and Requirements Analysis.
• Designed Database Diagrams using VISIO and data flow diagrams.
• Involved in Application Designing, Database Designing and User Interface Designing.
• Used Quick base to build customized database for internal use.
• Work with cross-functional teams to analyze data and identify ETL Logic for any system integration needs.
• Involved in writing test plan and test cases to approach document.
• Responsible for weekly status to show the Progress of the testing effort
• Develop and execute ETL test plans that ensure the quality of data transformations, data extraction, transformation and load programs ETL Data Mapping for a data warehouse, data models and ensure referential integrity.
• Perform data validation of all transformation constraints and derivations, intermediate files and tables, and all output specifications in Informatica.
• Follow an Iterative development testing for client's web application using Rational Unified Process RUP .
• Implement Mercury Interactive Quality Center for Business Process testing
• Create test implementation methodology and work with developers, business team and other stakeholders to define the high level approach to testing.
• Execute and document test results.

Environment/Tools: HTML, CSS, Intuit QuickBase, VISIO, SQL, Adobe Products, MicroStrategy, Intelligent Server, MicroStrategy Desktop, MicroStrategy Web, Oracle PL/SQL, TOAD, Windows 2008 Server, Quality Center.

Confidential

DWH/ETL QA Analyst

Responsibilities:

• Responsible to gather and analyze the required documentation, system design and developed the test plan that includes test cases for the specified performance requirements.
• Involved in all the phases of Software Development Life Cycle SDLC .
• Performed Business process analysis of the custom Web Applications.
• Involved in gathering User requirements and Requirements Analysis.
• Designed Database Diagrams using VISIO and data flow diagrams.
• Involved in Application Designing, Database Designing and User Interface Designing.
• Used Quickbase to build customized database for internal use.
• Work with cross-functional teams to analyze data and identify ETL Logic for any system integration needs.
• Involved in writing test plan and test cases to approach document.
• Present all the test reports and bugs in Quality Center.
• validating the analysis reports, Web service validation using soap-xml
• Performed testing on WSDL file converts into XML file using SOAPUI.
• Created Reports using Complex Filters, Compound Metrics and Prompts.
• Used Advanced Prompts, Non Aggregatable Metrics, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
• Used Customer, Product, Geographic and Time dimensions and generated complex reports.
• Tuned reports performance as per the requirement.
• Submitted testing reports for Bug-reporting and Bug-tracking using the test management tool
• Test Director, Quality center and Test central
• Customized reports, Documents and deployed them to MicroStrategy web.
• Responsible to writing Migration database test plans from Legacy system to New system
• Created Tested Flat Files for Import/Export testing using Informatica ETL tool.
• Coordinated with development team for bug fixes and discrepancies.
• Performed Regression testing against each new build.
• Involved in the testing of Enhancements and Run the Informatica Interfaces to check the data in different validations.
• Involved in the testing of Front end application once data spools into the Staging.
• Involved in the testing of data from Data ware house to Apex Explorer Backend of Sales Force.com
• Developed and maintained SQL Scripts using TOAD to test whether Data Integrity and Referential Integrity were being met
• Involved in writing of defects Identified in Testing and clearly communicate with development via defect tracking database Quality Center .

Environment/Tools: SOAPUI, Informatica, Sun Solaris, Oracle 10G, Quality Center, Windows XP/2000 and Unix

Confidential

Role: Software Tester Developer

Responsibilities

• Involved in the design stages of the Application and participated in the meetings with the client, Business Analyst and the development team.
• Involved in designing based on the System requirements from the Business Analyst.
• Extensively tested Graphical User Interface Components.
• Involved in all the phases of software development life cycle SDLC .
• Involved in Application Designing, Database Designing and User Interface Designing.
• Involved in project meetings to review project status, report possible red flags and their respective solutions.
• Used VISIO and data flow diagrams to design Database Diagrams.
• Extraction of test data from tables and loading of data into SQL tables.
• Responsible for Data mapping testing by writing complex SQL Queries.
• Performed testing on WSDL file converts into XML file using SOAPUI.
• Extensively performed Manual Testing in all modules of the Application.
• Integrated Quality Center with QTP and maintained test cases and test Scripts.
• Developed User Controls for front end UI pages in PHP and performed Business Analysis on each functionality.
• Incorporated Role based authentication in application using Username/Password and Database.
• Back end Programming using SQL and PL / SQL and UNIX shell scripting
• Normalized the tables and created the database tables.
• Retrieved the data from the database using SQL queries.
• Designed Well Formed User interface using XHTML, JavaScript, HTML
• Experience in all levels of Testing such as Positive testing, Negative testing, Smoke testing, Integration Testing, Functional Testing, System Testing, Regression testing, Black box testing and browser testing, User Acceptance Testing
• Used the Style Sheet Classes CSS to maintain Look and Feel of the web pages.
• Used Quick Base to build customized database so that the users can have secure
• Web access.
• Involved in the analysis and modeling of the business processes and system.
• Developed Project Plans and provided inputs to the Senior Management.

Environment/Tools: SOAPUI, HTML, CSS, Intuit Quick Base, JavaScript, SQL, PHP,Adobe Products, Quality Center.

Confidential

Role: Software Tester

Responsibilities

• Interacting with developers on daily basis to discuss the Requirement Specifications provided by the Analysts and any discrepancies in integrating the specifications with the application.
• Reviewing design document to analyze flow of the applications which involved in the sub division of the modules and the complete analysis of each module
• Analyzed business specifications and developed test plans and test cases for 12 modules.
• Involved in execution of test case of the ADMINISTRATION module for the system as well as a SECURED LOGIN module for the application.
• Identified software defects, wrote easy-to-follow bug reports, logged them into bug tracking database, monitored their progress and verified their resolution using Test Director
• Performed System, Integration, Black Box GUI testing
• Responsible for weekly status reports showing the progress of manual automation testing efforts and defects to be resolved
• Followed Agile Methodologies for creating scripts
• Interacted with developers and end users to resolve technical issues for testing efforts
• Tested database functionality using SQL.

Environment/Tools: Test Director, Visual Basic, Windows XP, MS Office HTML SQL.