PROFESSIONAL SUMMARY:

• Around 7 years of extensive IT experience in various phases of IT projects such as testing, deployment and application support.
• Expertise in Manual and Automated testing. Worked on large number of projects and systems over the years and built a solid knowledge across the board in Smoke, Functional, Regression, Database, Load, Stress, Data validation, Security, Integration, Web based, GUI testing and UAT.
• Experienced in all phases of Systems Development Life Cycle SDLC implementing Waterfall, V-Model, and Agile, Iteration, Scrum methodologies.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using SQL and / or PL/SQL, T-SQL
• Experience in testing and writing SQL and PL/SQL statements.
• Worked on Web Services Testing using SOAP UI 4.0/3.0
• Experience in Quality Assurance using Java, Junit, Selenium WebDriver/ IDE
• Experienced in developing automation testing framework using selenium, WebDriver by following java
• Strong experience in testing tools like TestDirector7.6, Quality Center, Quick Test Pro.
• Good expertise in using TOAD, SQL Plus and SQL Advantage.
• Experienced in Automation testing using the WinRunner, Quick Test and Load Runner, Performance center.
• Experience with QA Methodology to ensure the Quality Assurance Control.
• Strong in Analyzing Business spec Requirements Develop comprehensive test Spec execute them.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading ETL
• Experience in Web and Object Oriented Technologies
• Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology.
• Has good knowledge of web technologies like Web Services, SOAP, XML, HTML,.NET, JavaScript, VB Script, C, C , and C .
• Expertise in Problem solving and Tracking Bug Reports using Bug tracking Tools.
• Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Application Data warehousing experience in Banking, Financial, Trading, Retail and Consumer.
• Reporting Tool : Business Objects 5.1 /6.1/XIR2, Cognos 7.3 Series, Crystal Reports
• DATABASE : Oracle 9i/10G, MS Access 2003, SQL Server 2000/2005, MYSQL 4, AS400 and Sybase
• ETL: Ab Initio, Informatica 7.1/8.1
• WEB SERVER : Tomcat, Apache, MS IIS 5.0/6.0, WebLogic 7.0
• METHODOLOGIES: Waterfall, AGILE
• LANGUAGES: Java, C, C , SQL, PL/SQL, HTML, DHTML, XML, Java Script
• LANGUAGE UTILITY : MS Office 2007, Eclipse, MS Visual Studio .Net
• BUG TRACKING TOOLS: Test Director 8.0, Quality Center 8.0,9.2/ 11

PROFESSONAL EXPERIENCE

Confidential

Sr. Lead QA Analyst and Off Shore coordinator

Responsibilities:

• Reviewed and analyzed the Business Requirement Documents and Technical requirement documents.
• Participated in writing High level Test plans, Unit test plans, Test Scenarios, and Test Cases.
• Expertize in Developing and Evaluating Business Requirements and expertise in Researching, Identifying and Resolving Problems.
• Conducted Test Plan walk through meetings with project team and ability to work independently within all environments.
• Took initiative to explore Alternative Approaches to Projects tasks and Communicated clearly about the technical topics and interacted effectively with representatives and various Business Units.
• Involved in Developing, Resolving Problems with maintain and executing Test Plans and Test Scripts for all BAU Releases to large Independent Integrated Releases.
• Responsible for UI, Functional, Web Services, cross browser, Automation, ETL, Reports Testing of Web, legacy applications.
• Testing has been done based on Change Requests and Defect Requests.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data in SQL Server Database.
• Developed Test Framework in Java and Selenium for UI Regression Test Automation.
• Implemented modular Framework for Selenium based scripts. Conducted Cross Browser testing in Google Chrome and Firefox using Selenium.
• Used Selenium WebDriver and Selenium Grid for testing application in different browsers.
• Used firebug tool for finding Xpath of the Web Elements.
• Used Eclipse as an IDE for developing Java/JUnit/Selenium code.
• Modified and Executed automated and manual test scripts for different modules using QTP.
• Involved in maintaining and uploading the QTP Scripts to Quality Center.
• Extensively used AS400 for data base testing.
• Agile Management and Software Development. Strong testing Quality Assurance experience within Agile environment .Good understanding of Agile software development lifecycle iterative and incremental
• Involded in all iterations with Business and Development team for Agile methodology testing.
• Extensively used TFS for creating stories.
• Involved in User Acceptance testing UAT exclusively in Agile environment.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Demonstrated good communications skills with all LOB partners and Technology partners both written and oral.
• Lead the projects and organize meetings with different LOB, Technology, TDM and Project Manager.
• Expertise in Analyzing Test Results for Validity and Correctness.
• Lead the team of 4 including onshore and offshore.
• Experienced in Developing and Evaluating Business Requirements and expertise in Researching, Identifying and Resolving Problems.
• Worked in understanding Interdependencies between components from small to medium and provided training and guidance to onsite and Offshore folks
• Extensively used Quality Centre for Defect Reporting and Defect Tracking.

Environment: AS400, SQL Server 2008, Selenium Webdriver/IDE, Java, ALM HP Quality Centre 9.2, 11, QTP, Windows XP, PL SQL, MS Office tools, Agile, Db Visualizer, Toad 3.0.1, TFS 2010.

Confidential

QA Analyst

Confidential stands out as an organization that drives innovation in the health insurance industry. Many BlueCross BlueShield BCBS plans use NASCO to process nearly 90 million claims annually, serving more than 7 million members.

Responsibilities:

• Analyzed functional requirement and conducted Walkthrough.
• Understanding requirements and technical specifications.
• Preparing and reviewing Test cases and Procedures to ensure coverage of and conformance of business requirement.
• Worked closely with business team to make sure all the changes made to requirements documents are implemented in the test plan and test cases
• Worked on BAT Benefit analyzer tool to remediate ICD9 codes to ICD10 and verify the Mapping for recommended tables before remediating.
• Worked parallel on creating claims, processing claims with both ICD9 and ICD10 codes.
• Mapping of ICD-10 codes to procedure and diagnostic codes.
• Identify scope systems that will be modified by the ICD-10 project to accommodate ICD-10 code and /or downstream impacts from ICD-10 codes.
• Extensively Worked in HBEK HRBK to make necessary changes to Benefit Constructs for testing BAT Benefit Analyzer tool application recommendation phase.
• Worked in visualizing and documenting the artifacts such as Class diagrams, Use Cases diagrams, using MS-Visio.
• Worked on NASCO NPS to test the Test Claims in HIQK HEHK.
• Performed extensive Load and Performance testing utilizing mercury load runner..
• Utilized Quality Center for test plan, test execution, requirement gathering and defect reporting.
• Involved in performing UAT with stake holders and business owners.
• Involved in writing Data Mapping Documents for the system and involved in documenting the ETL process and writing SQL Queries for the retrieval of the data.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting data.
• Involved in Status Tracking, Risk Identification and Defect Prevention activities as part of the Project
• Preparing and reviewing Test Cases and procedures and to ensure coverage of and conformance of business requirement.
• Generating Automation Regression Test Script, maintenance and enhancement of scripts as per the application change request for every new release.
• Wrote Technical documentation and performed black box testing.
• Identified defects and escalated defects using Quality centre.
• Lead the team of 6 including onshore and offshore.

Environment: NASCO, NPS,QC, MS VISIO, SharePoint, RUP, UML, XML, HTML, Microsoft SQL Server 2005, Manual And Automated Testing,Loadrunner , Sybase, ASP.NET 2.0.

Confidential

ETL/ QA Analyst

Project Scope: BB T, one of the leading global banking companies, has some 20 million-customer accounts and does business in more than 10 states, providing services to consumers, corporations, governments and institutions. The project was to transform the data coming from various sources through multiple stages before being loaded into the data warehouse and maintenance.

Responsibilities:

• Extensively used SQL in backend and front-end functions, procedures to implement business rules and security
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL
• Written Complicated SQL queries in Teradata for Update Dimension Tables, Export Data from Target tables etc.
• Involved with ETL test data creation for all the ETL mapping rules.
• Data Migration testing of both the number of migrated records and data quality
• Experience in ETL Data Warehousing, database testing using Ab Initio for ETL process.
• Created test plans and performed unit testing for the Ab Initio graphs
• Created Manual Test Suites for various modules.
• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources. Researched various production issues.
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Reported bugs and tracked defects using Quality Center 8.0 Test Director
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed testing extensively for integration and unit testing of standalone and distributed GUI-based applications.
• Involving in Functional testing, End to End testing and Regression Testing
• Involved in Web Services Testing using SOAP UI.
• Installed, configured SOAP UI to test web services using WSDL file given by Development team.
• Performed initial testing by designing Manual test cases and later on scripted test cases using QTP
• Created and Executed Automation Test Scripts for Functional and Regression Testing for Option Validation and the Authorizations using QTP
• Inserted Checkpoints to validate Objects, Pages, Text, and Table using QTP.
• Writing and executing software system test plans and test cases. These scripts were developed after reviewing the business requirements documents and technical specifications documents.
• Created test cases and for integration testing based on requirements
• Developed Weekly and Final Test Status reports with all the Test Metrics Such as Total Test Executed, Total Test Analyzed, Total Passed and Total Failed.
• Performed report generation defect tracking activities by using QC.
• Created and executed SQL queries to fetch data from database server to validate and compare expected results with those actually obtained.
• Conducted SIT and UAT status calls and review meetings.

Environment: Ab Initio, GDE 1.14, Co>Op 2.14 , EME, Data Profiler,Teradata, Oracle 9i/10g, XML, Flat Files, SQL, Stored Procedures, SQL, QTP, MS Excel, UNIX, Windows, Quality Center and Test Director 8.0 SOAP UI 3.0, Web Services

Confidential

QA Analyst

Worked as Web Tester on BSNL's web-based application accessed by potential customers. Every new customer has to register on the website using a User id and Password. A secure site processed the log in information. Detailed information about their billing, services, new features, company information, due dates, minutes used, and payment information was provided to each customer. The front end of the application was developed in ASP, HTML and JavaScript

Responsibilities:

• Performed Unit, Integration, functional, Load, performance, Regression testing.
• Involved in preparing Business test cases, test design, test Cases, and Strategies.
• Perform Functional, Regression, System, and Integration in batch mode across features.
• Performed End-to-End testing manually and was associated with User Acceptance Testing.
• Performed Black box testing for the Web based application
• Review the test cases and bug reports.
• Implemented and executed automated Test Scripts for Regression Testing using QTP.
• Created and executed SQL queries to fetch data from database server to validate and compare expected results with those actually obtained.

Environment: J2EE, JSP, PL/SQL, Oracle 8.x, Mysql 4.2.0, Linux RHEL 3.1, Python and QTP, Web Servers: Apache 1.3.3 and Tomcat 1.5.