SUMMARY

• Around 8 years of good functional knowledge and extensive testing experience in Software analysis, Software Quality Assurance Testing for Banking, Health Insurance and Telecom Domain.
• Extensive experience in Manual Testing and Specialized in writing Test cases and Testing Life Cycle and creation of Test data .
• Good experience inQAmethodologies like Software Development Life Cycle (SDLC), Agile and Waterfall from project definition to post - deployment and experienced in complete Software Testing Lifecycle.
• Hands on experience on ETL tools in ETL process development, testing and in maintaining ETL codes.
• Extensive experience in Functional Testing, Database Testing, System Testing, Regression Testing, Smoke Testing, Compatibility Testing and GUI Testing.
• Strong experience in entire life cycle of Data warehouse/Data mart using Informatica Power Center (Designer, Repository manager, Workflow manager and workflow monitor)
• Experience in maintenance and enhancement of existing data extraction, cleansing, transformation, and loading processes to improve efficiency
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations and business rules
• Experience in managing the whole testing process using Mercury QTP (Quick Test Pro).
• Very good experience in doing Manual Testing by using defect management tools like HP Quality Centre/ALM and Jira.
• Extensive experience in UAT (User Acceptance Testing), UAT Test Plans and UAT defect reporting.
• Very good exposure on Bug Life Cycle and STLC.
• Expertise in Agile/Scrum Implementation Management.
• Good functional knowledge and extensive testing experience in Web services.
• Extensive experience on MS Office (Word, Excel, PowerPoint, Outlook, Access).
• Performed Back End testing, reading data models, writing SQL queries in Oracle, MS SQL Server.
• Experience in testing Enterprise Data Warehouses using Informatica Power Center DVO, DataStage, Ab Initio and SSIS ETL tools
• Ability to meet deadlines, handle pressure and co-ordinate multiple tasks in a work / project environment.
• Resourceful team player and capable of delivering tasks within stringent timelines and work in a team and Independent.
• Experience in reporting bugs using Microsoft Word and Adobe pdf and tracking bug with Excel.
• Self-starter,energetic,highly motivated team playerwith excellentproblem-solving skills. Capable toquickly learnnew technology and adapt to a new environment.
• Possess Multi-tasking skills, ability to lead end-to-end QA efforts, result oriented; thrive in a fast-paced, deadline-based environment.

TECHNICAL SKILLS

Operating Systems: Windows XP/Vista/2007, UNIX.

Languages: Java, C, C++, VBScript, SQL

DBMS: Oracle, My SQL

Configuration management tools: SVN, CVS, Clear Case

Testing Tools: HP Quick Test Professional

Bug Reporting: HP QC/ALM, Jira

Web Technologies: HTML, XML, Java, ASP.Net

Tools: MS Word, MS Excel, PowerPoint, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Dorchester, MA

ETL/Quality Analyst

Responsibilities:

• Analyzed business and technical requirements, developing strategic Test Plans, Test Cases and responsible for monitoring proper execution of all the Test Cases.
• Planning for Test execution activities to accomplish tasks on daily/weekly basis
• Co-ordination of Test Design/ Test Execution efforts across teams and with business.
• Tested the application utilizing the Agile Methodology.
• Involved in writing test cases to test the workflow of claim processing, payment processing and billing application.
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Involved in UAT (User Acceptance Testing), UAT Test Plans and UAT defect reporting.
• Performed various scenarios by Manual Testing, executed different Test cases manually and Monitored the System Performance
• Involved in and responsible for Functional, Regression and Integration testing of the application.
• Used Jira for Test case Management and for Defect tracking.
• Validating all theBatch jobsthat are scheduled and executed.
• Worked on multiple separate commercial and retail sources. Testing the staging layer followed by integration testing in DataMart with an additional snapshot testing for reports.
• Escalated testing issues, interacted with business users/analysts, developers, external teams to resolve the defects/issues.
• Tested all the ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes. Tested the reports developed using Business Objects.
• Took part in testing all the ETL process that loads the data into CRDM
• Understand the mapping documents and write and execute SQL test scripts and record actual result.
• Data validation based on database integration jobs with SQL Server.
• Data validation in report and dashboards.
• Participated in test case review, defects review meetings and requirements walkthroughs.
• Interacted with developers, Business analyst to resolve technical issues.
• Participated in defect review meetings and walkthroughs meetings.
• Presented Test Metrics to management for tracking status of the project and deciding Go/No-Go for each scheduled release of the application
• Took full ownership of end-user quality, usability and appeal to deliver high quality software on tight schedules

Environment: Windows 2007, UNIX, Jira, SQL Server, VBScript, Java, Outlook

Confidential, MD

ETL/QA Tester

Responsibilities:

• Created Test plans, Test Designs and responsible for implementation of Test cases as Manual and automated test scripts
• Tested ETL jobs as per business rules using ETL design document
• Involved in Test plan, Test case preparation and assigning defects through TFS (Team Foundation Server
• Analyzed the Functional Design documentation and User Requirements.
• Involve in Functional testing, regression testing, user acceptance testing, and accessibility testing and End-to-End testing.
• Worked on EDI (Electronic data interchange) transactions: 270, 271, 834, 820, 835, and 837 to identify key data set elements for designated record set.
• Written several complex SQL queries for validating Cognos Reports.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
• Tested the claims processing with EDI transactions (270, 271, 835, 837) in HIPPA and HL7 Environment.
• Testing. Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Data Report testing in Business Objects.
• Prepared and executed Test Cases with different Test Sets for different objectives based on the Business/Functional requirements
• Performed Test Planning, functional testing and bug tracking
• Generated QTP Scripts for regression testing
• Multiple & Reusable Actions were Created and Executed in the Script
• Scripts were parameterized using the Data Table parameters, Environment Variables and Random Number Parameters
• Checked application for Cross Browser Compatibility.
• Performed manual testing of the product including functional tests, data driven tests, regression tests, and integration test
• Developed Integration Test Plans and Test Schedules to assist in the execution of functional, System Testing, Regression Testing, Integration Testing and User Acceptance testing.
• Scheduled Test Procedure Design Reviews in accordance with the procedures and regulations.
• Reported the defect identified during execution and doing a complete defect tracking using Quality Center.
• Conducted User Acceptance Testing (UAT) for projects, implementations, system fixes and enhancements, etc.
• Performed functional testing and usability testing according to the application complexity and test requirements.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement.
• SQL queries used to validate source data versus data in the data warehouse including identification of duplicate records.
• Wrote SQL queries on various data tables for Data validation and Backend Testing.
• Used Agile methodologies
• Participated in daily scrum meetings to report daily progress of Testing activities and Sprint planning for test planning activities
• Compliant with the HIPPA standards for privacy and security
• Good understanding of HIPPA privacy regulation

Environment: Microsoft Office Suite, Jira, QTP, Windows XP, Java, Oracle SQL, MS Excel, PowerPoint, MS Word,SSIS.

Confidential, Atlanta, GA

Quality Assurance Analyst

Responsibilities:

• Analyzed system user stories and the Mockups, and developed detailed Test case for System Testing.
• Conducted meetings and Standup Meetings with Product owners, Scrum, Developers and Business Analysts to gather information about business process.
• Maintained Traceability Matrix to ensure all conditions are covered in the Test Cases.
• Wrote test cases for GUI and Functionality testing.
• Worked on SQL queries and SQL Server, MySQL
• Wrote SQL queries that simulate business processes.
• Testing included functional testing, load and performance test, ad-hoc test, user acceptance test, sanity and BVT execution, browser and operating system compatibility testing
• Reported the bugs in Problem Tracker and traced them until they are fixed.
• Provided training to the users and helped them to perform UAT (User Acceptance Testing).
• Attended Empower training session by SME (Subject Matter Expert).
• Coordinate, mentoring of various tools and process flow of the application.
• Created test plans with client’s participation.
• Scope analysis, functional and technical Walk through Base line High speed testing.
• Also involved in content management/ Change control and Version Management. Performed regular updates to various static web pages.
• HP Quality Center is used for reporting the results and organized all the test cases.
• Maintained Central GUI Map for the entire application.
• Database stored procedure executions; Indexes and views with load were analyzed. Tuned SQL server by changing Parallelism, update statistics, hints settings.
• Results log files were analyzed for various HTTP errors, Server errors etc. Event viewer was also used for analysis.

Environment: Java, JSP, XML, Oracle, Windows 2000, SQL Developer, HP Quality Center, UNIX.