SUMMARY:

• Over 6 years of Experience in the IT industry with emphasis on Software Quality Assurance and Data validation, ETL validation, Business Intelligence and Testing using SQL Server, Oracle Databases.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Physical, Logical design, Resource Planning, Code Development and Testing Life Cycle (TLC) and QA methodologies and STLC.
• Experience and understanding of RDBMS and Data warehousing data models.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in analyzing requirements - Business requirements, Functional requirements and Technical specifications and created test strategies.
• Expertise in Writing Test Plans, Test cases, Test Scenarios. Creating and Managing Defect Cycle, Responsibility Assignment Matrix, traceabilityMatrix.
• Strong skills in performing Functional testing, GUI testing, System testing, Integration testing, End-to-end testing, Regression testing, Data-driven testing, Smoke testing, Sanity testing, User Acceptance testing, Cross-browser testing and Backend testing.
• Designed and executed manual and automated test cases through QC by integrating QTP.
• Expertise in Backend Testing and in executing SQL commands and writing complex SQL queries and worked on pl/sql coding and also worked on Unix platform, expertise in writing Unix coding.
• Hands on experience in using tools such as Microsoft Office pack, HP Quality Center (QC), TOAD, SQL* Loader, and SQL*plus, Site Minder V6.x, change management tool such as Bridge Clarify, Fogbugz TFS.
• Knowledge of Selenium IDE and Selenium WebDriver tool for automation.
• Specialized in Web based and Data Management Projects. Also extensive experience in Manufacturing, Financial applications as an ETL Tester.
• Helped the Development team with coding assistance when necessary.
• Good experience in various Industry verticals like Heath Care, Finance, Medicaid and telecommunication with appropriate oracle implementations.
• Experienced in working with Insurance, Financial Services and CRM System domains.
• Ensured timely deployment of production deliverable and providing post production support and maintenance.
• Strong Team building and mentoring skills and excellent team lead capability and strong Logical and Analytical Reasoning, excellent Management, Excellent communication with good listening, Presentation and Intrapersonal.
• Motivated to take independent responsibility as well as to contribute to be a productive team member.

TECHNICAL SKILLS:

Testing Tool: Mercury Quality Center 9.2, Visual Studio Team System, Team Foundation Server (TFS), Fogbugz

Databases: Oracle 9i, 10g, 11g, SQL Server 2005, MS Access

Operating system: Microsoft Windows 2000, 2003, 2007, XP, Solaris 10, Unix, Perl

Languages: SQL, PL/SQL, Shell Scripts, C++, asp.net, Java, J2EE.

Internet Tech: HTML, DHTML, Java Script, and Xml

Oracle Tools: TOAD 12.0, SQL Developer 3.0, SQL*Plus, SQL*Loader

ETL tool: Informatica, SQL Server Integration Services(SSIS)

Miscellaneous: Putty, Bridge Clarify, SOAP UI, Microsoft Office pack, MS Visio 07

PROFESSIONAL EXPERIENCE:

Confidential

Senior Quality Analyst

Responsibilities:

• Analyze, design and build testing procedures that deliver the client’s goals and provide our clients with maximum value.
• Analyzed the Functional Requirements and Design Specifications documents to ensure that the system met all of the technical and business requirements of the applications.
• Manually generate and implement templates for Test plan, Test Cases, and Test Scripts and performed Manual Testing on the entire application.
• Worked closely with software developers, business analysts, Sys admin, and other project management personnel involved in Software Development Life Cycle (SDLC).
• Performed back end testing by verifying the data in the Database.
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Extensive use of XML’s, XSD’s & XSLT’s for communicating data between interfaces.
• Expertise in column mapping between source and target and data in target database by ETL process.
• Participated in requirements and design specification reviews and technical documentation reviews as essential to performed assigned duties.
• Arranging meetings, conference calls and ensuring timely delivery of development iterations by using Agile Scrum Methodologies.
• Executed manual and automated tests, documented results, communicated issues, and verified issues resolved.
• Expertise in Functional, Regression and End to end testing for Various Modules.
• Performing Change Management, Risk Management while project work is progressing.
• Executing and coordinating Unit Testing, Integration and User Acceptance Testing.
• Creating Traceability Matrix, Test plan, Test cases and Maintaining issue logs.
• Prioritized defects to be fixed using an understanding of the business requirements and the needs of the customer, Logging defects in scripts and reporting to the developer
• Maintaining proper communication and follow up to speed up the process.
• Generated data when needed to fit particulartestingsituationsthrough excel and SQL.
• Actively involved in initiating meetings to clear the changes in requirements and make sure test cases are changed accordingly.
• Providing User training on the new system. Preparing process notes for future reference.
• Monitoring the system and providing post-production support when necessary.

Environment: TFS, MS Dynamics 2009, Windows 8, ASP.NET, XML, MS SQL Server 2008,Citrix, VSS, SQL, Salad Bar, ETL, Citrix

Confidential, NC

Senior Quality Analyst

Responsibilities:

• Gathered, Understood and analyzed, requirements for project by attending User Group Meetings and created SRS (System Requirements Specifications) Document
• Expertise in using Sql Developer client tools for Querying ORACLE Databases for data analysis and also expertise in documentation and identification of test requirements.
• Good Exposure to Data Warehousing concepts validating OLTP and OLAP databases and meeting business needs.
• Expertise in writing and executing Complex SQL Queries and pl/sql code using TOAD and Sql developer.
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Extensive use of XML’s, XSD’s & XSLT’s for communicating data between interfaces.
• Expertise in column mapping between source and target and data in target database by ETL process.
• Designed and executed manual and automated test cases through QC by integrating QTP.
• Expertise in Database DDL, DML, DCL Statements for different purpose.
• Having Extensive knowledge on Verification and Validation process in project design.
• SQL Report Validation and identifying GAPS in Reports and in Database.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Manually generate and implement templates for Test plan, Test Cases, and Test Scripts and performed Manual Testing on the entire application.
• Validated reports and SQL Stored Procedures and functions in the project.
• Involved in testing all the reports that were generated comparing in Source and Target systems as per the requirement documents.
• Expertise in Functional, Regression and End to end testing for Various Modules.
• Tested the format of the reports according to the specifications provided and compared the data in the reports with the backend datamart through SQL.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Expertise in coordinating and taking regular follow up with development team to assure testing procedures are in pace.
• Monitoring current performance of the application and ensuring timely closure of the issues if any observed in production.

Environment: HP QC, oracle 10g, java, ETL, TOAD 12, SQL Developer, SQL *Loader, putty, Bridge Clarify, Windows 7.

Confidential, CA

Responsibilities:

• Analyze, design and build testing procedures that deliver the client’s goals and provide our clients with maximum value.
• Analyzed the Functional Requirements and Design Specifications documents to ensure that the system met all of the technical and business requirements of the applications.
• Manually generate and implement templates for Test plan, Test Cases, and Test Scripts and performed Manual Testing on the entire application.
• Worked closely with software developers, business analysts, Sys admin, and other project management personnel involved in Software Development Life Cycle (SDLC).
• Performed back end testing by verifying the data in the Oracle Database.
• Participated in requirements and design specification reviews and technical documentation reviews as essential to performed assigned duties.
• Arranging meetings, conference calls and ensuring timely delivery of development iterations by using Agile Scrum Methodologies.
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Extensive use of XML’s, XSD’s & XSLT’s for communicating data between interfaces.
• Expertise in column mapping between source and target and data in target database by ETL process.
• Executed manual and automated tests, documented results, communicated issues, and verified issues resolved.
• Expertise in Database DDL, DML, DCL Statements for different purpose.
• Performing Change Management, Risk Management while project work is progressing.
• Executing and coordinating Unit Testing, Integration and User Acceptance Testing.
• Creating Traceability Matrix, Test plan, Test cases and Maintaining issue logs.
• Prioritized defects to be fixed using an understanding of the business requirements and the needs of the customer, Logging defects in scripts and reporting to the developer
• Maintaining proper communication and follow up to speed up the process.
• Generated data when needed to fit particulartestingsituationsthrough excel and SQL.
• Actively involved in initiating meetings to clear the changes in requirements and make sure test cases are changed accordingly.
• Providing User training on the new system. Preparing process notes for future reference.
• Monitoring the system and providing post-production support when necessary

Environment: HP QC, Oracle 10g, unix scripting, java, ETL, TOAD 12, SQL Developer, SQL *Loader, putty, Bridge Clarify, Windows 7.

Confidential, Philadelphia, PA

Responsibilities:

• Gathered, Understood and analyzed, requirements for project by attending User Group Meetings and created SRS (System Requirements Specifications) Document
• Expertise in using Sql Developer client tools for Querying ORACLE Databases for data analysis and also expertise in documentation and identification of test requirements.
• Good Exposure to Data Warehousing concepts validating OLTP and OLAP databases and meeting business needs.
• Expertise in writing and executing Complex SQL Queries and pl/sql code using TOAD and Sql developer.
• Having Extensive knowledge on Verification and Validation process in project design.
• SQL Report Validation and identifying GAPS in Reports and in Database.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Extensive use of XML’s, XSD’s & XSLT’s for communicating data between interfaces.
• Expertise in column mapping between source and target and data in target database by ETL process.
• Expertise in Database DDL, DML, DCL Statements for different purpose.
• Expertise in Functional, Regression and End to end testing for Various Modules.
• Manually generate and implement templates for Test plan, Test Cases, and Test Scripts and performed Manual Testing on the entire application.
• Validated reports and SQL Stored Procedures and functions in the project.
• Involved in testing all the reports that were generated comparing in Source and Target systems as per the requirement documents.
• Tested the format of the reports according to the specifications provided and compared the data in the reports with the backend datamart through SQL.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Expertise in coordinating and taking regular follow up with development team to assure testing procedures are in pace.
• Monitoring current performance of the application and ensuring timely closure of the issues if any observed in production.

Environment: HP QC, Oracle 10g, Unix scripting, java, ETL, TOAD 12, SQL Developer, SQL *Loader, putty, Bridge Clarify, Windows 7.

Confidential

Quality Analyst

Responsibilities:

• Gathered, Understood and analyzed, requirements for project by attending User Group Meetings and created SRS (System Requirements Specifications) Document
• Expertise in using Sql Developer client tools for Querying ORACLE Databases for data analysis and also expertise in documentation and identification of test requirements.
• Good Exposure to Data Warehousing concepts validating OLTP and OLAP databases and meeting business needs.
• Expertise in writing and executing Complex SQL Queries and pl/sql code using TOAD and Sql developer.
• Expertise in Database DDL, DML, DCL Statements for different purpose.
• Having Extensive knowledge on Verification and Validation process in project design.
• SQL Report Validation and identifying GAPS in Reports and in Database.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Manually generate and implement templates for Test plan, Test Cases, and Test Scripts and performed Manual Testing on the entire application.
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Extensive use of XML’s, XSD’s & XSLT’s for communicating data between interfaces.
• Expertise in column mapping between source and target and data in target database by ETL process.
• Validated reports and SQL Stored Procedures and functions in the project.
• Involved in testing all the reports that were generated comparing in Source and Target systems as per the requirement documents.
• Tested the format of the reports according to the specifications provided and compared the data in the reports with the backend datamart through SQL.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Expertise in coordinating and taking regular follow up with development team to assure testing procedures are in pace.
• Creating reports on daily, weekly and monthly basis for strategic and tactical decision making process.
• Monitoring current performance of the application and ensuring timely closure of the issues if any observed in production.

Environment: HP QC, Oracle 10g, Unix scripting, ETL, java, TOAD 12, SQL Developer, SQL *Loader, putty, Bridge Clarify, Windows 7.

Confidential

Quality Analyst

Responsibilities:

• Gathered, Understood and analyzed, requirements for project by attending User Group Meetings and created SRS (System Requirements Specifications) Document
• Expertise in using Sql Developer client tools for Querying ORACLE Databases for data analysis and also expertise in documentation and identification of test requirements.
• Good Exposure to Data Warehousing concepts validating OLTP and OLAP databases and meeting business needs.
• Expertise in writing and executing Complex SQL Queries and pl/sql code using TOAD and Sql developer.
• Having Extensive knowledge on Verification and Validation process in project design.
• SQL Report Validation and identifying GAPS in Reports and in Database.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Manually generate and implement templates for Test plan, Test Cases, and Test Scripts and performed Manual Testing on the entire application.
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Extensive use of XML’s, XSD’s & XSLT’s for communicating data between interfaces.
• Expertise in column mapping between source and target and data in target database by ETL process.
• Validated reports and SQL Stored Procedures and functions in the project.
• Involved in testing all the reports that were generated comparing in Source and Target systems as per the requirement documents.
• Tested the format of the reports according to the specifications provided and compared the data in the reports with the backend datamart through SQL.
• Validated data connections from application tier to data layer, identified mismatch and reported to developers logging the defects identified.
• Monitoring current performance of the application and ensuring timely closure of the issues if any observed in production.

Environment: Siebel CRM, Oracle 10g,ETL, Unix scripting, Putty, HP QC, Bridge Clarify, SOAP UI, Site Minder V6.x, Microsoft Office pack, TOAD, SQL developer.