SUMMARY:

• 8 years 8 months of IT experience in Software Testing of Web-Based, Data Warehousing/ETL and Client Server Applications..
• Highly motivated professional with excellent experience in Software testing and Quality Assurance.
• Excellent analytical skills for understanding the business requirements, business rules/processes and detailed design of the application.
• 2 year 2 months Selenium RC With Junit and Experience in implementing DataDriven and Keyword Driven Test Scripts.
• Good Experience in Web Platform Technologies in Web forms using Java,.Net, Webservices,XML and SOAP.
• Experience in coordinating and engaging teams for different phases.
• Extensive experience in design techniques, ETL processes, relational database theory, N-Tier development.
• Expert in conducting various testing types like Functional,Integration,Regression, UAT and End-to-end Testing
• Experience in Product Development, Retail Domain, Finance and Insurance and Brokerage Domain
• Expertise in Process management using Quality center to Document test cases and conduct triage meetings to resolve issues
• Experience in Technical writing Skills with hands on experience creating Businesses Requriements, functional Specifications, Mapping Documents-R Diagrams, Test Plan, Test Scripts and Status Reports.
• Expert in Defect Reporting and Tracking using Test Director/HP Quality Center,IBM Rational Clear Quest.
• Preparation of Test Plan, Test Cases, Test Strategies and Test Effort Estimation.
• Excellent skills in Database Testing. Experience in Testing Incoming Data values and out going data value with queries, stored procedures, functions and joins.
• Excellent Experience in Testing ETL Packages such as SSIS,SSRS . Validating Data in Destinations.
• Hands on Experience in Creating/ Testing Informatics Mappings.
• Proficiency in customization & implementation of Web Applications
• Strong Experience in Agile Methodologies, Scrum Methodologies.
• Experience in Wealth Management and Invest management.
• Experience in creating Data marts from different Data sources, and filtering data in it and customizing and trouble shooting performance counters in it
• Strong troubleshooting and organizational skills.

EDUCATION:

• Master of Computer Applications.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS)
Databases: MS-SQL Server 6.5/7.0/8.0/9.0/10.0, MS Access 97 & 2000
Reporting Tools: MS SQL Server Reporting Services, Integrating Services, Crystal Reports, Informatica, Analysis Services
Testing Tools : HP QualityCenter,SmartBear,Selenium RC Junit
Web Servers: IIS 5 and 6
Languages: MS SQL Server 2005(9.0)/2000(8.0)/7.0/6.5, T-SQL, VB.NET,C#, ASP.NET,TIBOC, BPF,AJAX,XML,PL/SQL, VB Script, JavaScript, Turbo C, C++, Java.
Tools: MS SourceSafe, Legacy mainframes, MS Office 97/2000/XP, MS FrontPage 98/2000, MS Outlook 97/2000
Operating System: Windows 2000 Advanced Server/Server 2003/Professional/ NT 4.0, Win XP Prof/Standard, Win 98.

PROFESSIONAL EXPERIENCE:

Confidential,Texas Nov11-Present.
QA Analyst & Engineer.

Siemens Corporation is a U.S. subsidiary of Siemens AG, a global powerhouse in electronics and electrical engineering, operating in the industry, energy, healthcare, and infrastructure and cities sectors. For more than 160 years, Siemens has built a reputation for leading-edge innovation and the quality of its products, services and solutions.

Responsibilities :

• Defined Testing Process and strictly following the process until testing is certified for the test phases.
• Participated in Full Life cycle for multiple Data project:analysis,design,documentation ,development and testing.
• Implemented Data Driven Test Script using Selenium RC Junit.for Smart Offer Project.
• Implemented Keyword Driven Test Scripts using Selenium Junit.
• Created Test Plan and Test Scenarios and Test cases according to Business rules and Functional Requirements.
• Worked with Business Analyst, developers and managers to resolve the Key issues in Project.
• Worked with BMC Quality Center to log the defects and analyze the tickets and assigning them to responsible team .
• Responsibilities included acceptance testing, functional testing, Integration testing, system testing and performance testing.
• Responsible for performing the Functional, Integration, Regression and UAT Testing.
• Fixed the issue in Data driven test scripts and delivered bug free test scripts.
• Conducted Cross Browser Testing to check the compatibility of the Application with different Browsers (IE, AOL, Netscape).
• Participated in Review meetings and provided update on various QC’s.
• Created Screen shots for using Selenium junit for all Applications in project
• Executed test cases manually and identified the mismatches and logged the defects using HP Quality Center.

Environment: Windows Server 2003, Java, Junit, Selenium RC, BMC Quality Center, Jmeter, XMLSPY,

Confidential,New Jersey April10- Nov11
QA Analyst & Engineer

Bank of America Corporation (Bank of America) is a bank holding company, and a financial holding company. Bank of America is a financial institution, serving individual consumers, small and middle market businesses, corporations and governments with a range of banking, investing, asset management and other financial and risk management products and services. Through its banking subsidiaries (the Banks) and various non-banking subsidiaries throughout the United States and in selected international markets, it provides a range of banking and non-banking financial services and products through six business segments: Deposits, Global Card Services, Home Loans & Insurance, Global Commercial Banking, Global Banking & Markets (GBAM) and Global Wealth & Investment Management (GWIM), with the remaining operations recorded in All Other. In April 2011, the Company merged its corporate and investment banking divisions.

Responsibilities:

• Defined Testing Process and strictly following the process until testing is certified for the test phases.
• Participated in Full Life cycle for multiple Data project:analysis,design,documentation ,development and testing
• Created Test Plans, Test Scenarios, Test cases, Test Scripts, Traceability matrices according to Business and Functional Requirements.
• Work with business analyst, developers and manager to develop test plans, produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign –off for a high volume of data and regular release schedule for successful project delivery.
• Responsibilities included acceptance testing, functional testing, Integration testing, system testing and performance testing.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Participated in QA meeting for providing update status on Various QC’s .
• Tested the IF Service of TIBCO for OAO Applications and Assigned and solved the issues as per Business Requirement
• Implemented Data driven Test scripts using Selenium RC Junit for OAO Project.
• Implemented Hybrid driven test scripts using Selenium Junit for Alerts projects.
• Responsible for the Analysis of software applications and computer systems, Focus of the effort is on batch process modules, UI screens, and Reports
• Mentor testers and answer technical questions related to SQL and test strategy.
• Using Clear Quest, Quality Center to log the defects, analyze them and assign to the responsible team and update with the proper data to reproduce the defects.
• Analyzing Test Results, Recording Defects encountered while Test execution and Tracking them to their closure.
• Wrote test case scripts; executed and documented detailed results and summary reports.
• Executed systems and data quality testing to ensure all development deliverables are production ready.

Environment : Windows Server 2003, Quality Center, Java,Junit ,C#,TFS,ASP.NET,TIBCO,BPF,SQL Server 2008, Clear Quest,Selenium RC.

Confidential,Vermont June 09 – Mar 10
QA Analyst & Engineer

The flagship of the enterprise, National Life Insurance Company, was established in Montpelier, Vermont in 1848 and is licensed in all 50 states and the District of Columbia. From its very beginnings, National Life has been one of the innovators of life insurance in America, having introduced a number of improvements that are now regular features of policies sold by a number of insurers. Over the years, the company has made available a variety of new types of coverage and provided progressive improvements in underwriting and service practices.

Responsibilities:

• Complete Responsibility in manual testing, Automation testing of the compliance and discretionary projects in both Auto and property lines of business.
• Prepared Test Plan Which covers the Test Estimation for Future Release.
• Performed manual testing of Active X components for windows flavor( Windows XP/2000/NT).
• Created Mappings for the Requirements in Test Lab from iteration to Iteration
• Participated in Business meeting for gathering requirements for multiple projects.
• Executed test cases manually and identified the mismatches and logged the defects using HP Quality Center.
• Execute and sign off on test scripts. Work closely with Ops Manager to update Release Grids.
• Wrote test case scripts; executed and documented detailed results and summary reports.
• Preparation of Test Procedures, Executing Test Cases both manual and automated test cases using HP Quality Center.
• Executed SQL Queries for Database end-to-end testing
• Supported production deployments over the weekends.
• Tested the IF Service of TIBCO for OAO Applications and Assigned and solved the issues as per Business Requirement
• Configure test environment for the specific test cases, Create test data and execute manual tests, document results..
• Implemented Data Driven Test Scripts for Whole Project.using selenium RC Junit.
• Responsible for performing the Functional, Integration, Regression and UAT Testing .
• Worked on Web services to combine component based development and internet standards and protocols that include HTTP,XML, SOAP and Web services Description language.
• Perform Integration test by running ETL jobs, validating data loads, troubleshooting job execution errors and executing test scripts
• Work with development, QA, and Automation engineers to research, design, and develop complex test automation units.
• Using Clear Quest, Quality Center to log the defects, analyze them and assign to the responsible team and update with the proper data to reproduce the defects.
• Participate in production release validation to ensure successful deployments of products without any performance issues.
• Prepared Test Summary report and conditional acceptance memo if required.

Environment: Windows Server 2003, Quality Centre, Java, Junit, SQL Server 2008, SOAP,XML, TIBCO, BPF Services,Selenium RC, Web Services, Clear Quest.

Confidential, (Mclean, VA) Fe09- June 09
QA Analyst

Freddie Mac works with mortgage lenders to help people get lower housing costs and better access to home financing. Freddie Mac is one of the financial institution involved in mortgage business for single family and multi family business. All loans & Securities Transaction Accounting & Reporting, duties during this project are finding defects in various modules.

Responsibilities:

• Create test script and test cases by working with business analysts and developers to review business requirements, functional specifications and technical solution design.
• Analyzed Use Cases and developed Test Plan, Test Scripts and Test Cases and executed them.
• Executed the test scripts on different releases as well as in different modes and validated the actual results against the expected results using HPQC.
• PerformingSmoke, Integration, ValidationandCompatibility testingof the application manually.
• AutomatedTest casesand developed tests for Regression Testing using Mercury Imperative’sQuick Test Pro.
• Involved in the conversion of Manual regression test cases to Automation Test Cases
• Maintained automation scripts, object repositories, functional libraries inSelenium Junit RC
• GeneratedBug (Defect) Reportsand track the status of each defect.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality
• Performed Data Validation of the data flow by performing end to end testing.
• UsedQuality Centerfordefect tracking and reporting(logged defects, changeRequests, recorded defect details, assigned severity and reported defect status).
• Involving in Risk Analysis, Root cause analysis, Walkthroughs and Release support
• Developed and executed SQL queries to verify the proper insertion, deletion and updates into the data Warehouse supporting tables and cubes usingTOAD.
• Worked closely with the development team and the State user in an Agile environment to quickly identify issues
• Interaction with developers for resolving the critical bugs and functionality modifications.

Environment :Selenium RC Junit.,Quality Center 9.2,SOAP UI,Webservices, Java, JavaScripts, HTML, VBScripting, Oracle10g/11g,WindowsXP.

Confidential,,NY Jan 08 – Dec 08
QA Analyst/Engineer

Always(In Style)® International, Inc. is a personal style training, customer profiling, and data warehousing company that provides customized fashion, beauty, style, and etiquette analysis and advice to both individuals and organizations. Founded in 1982 by Doris Poser, with the publication of her first book, Always In Style, the Always(In Style)® profiling software, books, products and training programs have been rolled out in 25 countries. Always(In Style)®’s corporate assets, including but not limited to it\'s proprietary Personal Profiling™ software, reflects over $8 million in investment and 25 years of operational experience.

Responsibilities:

• Production Infrastructure DBA Support-Responsible for administration of almost a 40 instances out of which 10 are Production Instances 12 are Development Instances and 18 are Testing Instances and comprising of 200 databases with size up to 300GB
• Perform quality assurance analysis and testing on an Enterprise-level web application for the Life style Products
• Responsible for application analysis, test strategy development, test case creation, test script development, test execution, defect tracking and reporting.
• Involved in Business Requirement with various Retail experts.
• Responsible for the Analysis of software applications and computer systems, Focus of the effort is on batch process modules, UI screens, and Reports.
• Create automated test scripts for Retail Applications using QTP for automation of the manual scripts
• Perform Backend database testing to validate the data using complex SQL queries,
• Perform Integration test by running ETL jobs, validating data loads, troubleshooting job execution errors and executing test scripts.
• Worked on Web services to combine component based development and internet standards and protocols that include HTTP,XML, SOAP and Web services Description language.
• Conducted Cross Browser Testing to check the compatibility of the Application with different Browsers (IE, AOL, Netscape).
• Conducted Review meetings for Tickets raised for Retail Applications and closed the tickets.
• Perform Regression test for every module of Software development
• Use chart graphs to test positive & negative scenarios based on the test cases
• Work with development, QA, and Automation engineers to research, design, and develop complex test automation units.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Participate in all stages of testing, such as Unit, Integration, Regression System and UAT testing, in both manual and automation environment.
• Absorb and understand system design, data model, and functional components of large software system
• Mentor testers and answer technical questions related to SQL and test strategy

Environment: Windows server 2003, Quality Center, SQL Server 2008, Visual Studio 2005, SOAP,XML, ASP.NET,C#, Web Services. Clear Quest.

Confidential,Edison, New Jersey April 2006 to Oct 2007
Database Administrator/Developer
Systemic Enterprise Connector (SEC)

SEC PLM is a online project life cycle management system with powerful Enterprise Application Integration processing needs in engineering and manufacturing enterprise Confronted by various functions/departments having operations at a tactical level to Strategic policy level.

Configuration control features in all the systems facilitate decision-making persons or Groups of people across the product development or project hierarchy for evaluating and approving or disapproving pieces of data/ information in transactions.

SECPLM is highly scalable and integrated internet/intranet environment with robust Systems that interplays addressing large data, information and time bound functions. More specific to product development enterprise.

Responsibilities:

• Installed, Upgraded, and configured SQL Server 2000 and replication servers on Sun Solaris and Windows NT.
• Reviewing business requirement documents to get a better understanding of the system on both functional and business perspectives
• Tested SSIS Package design by writing SQL scripts to validate data extraction/loading from different sources including flat files, RDBMS tables
• Develop parameter driven ETL process to map source systems to target data warehouse with SSIS Package complete source system profiling.
• Defect management, Bug Reporting through the Bug Tracking tool for business Application software and & Design package.
• Involved in documenting Test Plan, Test Cases and Test Procedure using Business requirements document and Functional requirements document of the system.
• Tested the Reports generated for accuracy of the data reported, using SQL queries.
• Performed Regression testing, smoke testing of the deployments in various environments (QA, Development, Staging, and Production.)
• Review and analysis of business requirements to define the test scenarios, scope and approach.
• Mentor testers and answer technical questions related to SQL and test strategy
• Wrote test case scripts; executed and documented detailed results and summary reports.
• Executed systems and data quality testing to ensure all development deliverables are production ready.
• Identify the test environments and prepare the Test Environments booking and maintenance Plan. Coordinated the testing with different teams.
• Prepare Detailed Test Schedule and Test Resource allocation W.R.T Test Estimation provided.
• Conducted Cross Browser Testing to check the compatibility of the Application with different Browsers (IE, AOL, Netscape)
• Configure test environment for specific test cases, create test data, and execute manual tests, document results, assigning the defects to development team and update defect tracking systems.
• Participated in regular project status meetings related to testing

Environment: Windows Server 2000, SQL Server 2005,T-SQL,Quality Center,TestDirector,QTP.