SUMMARY

• 7+ years of valuable experience in Information Technology working for diverse domains such as Banking and Financial Services
• Expertise in Testing of Data Warehousing/Business Intelligence applications and experience in working wif EDWs (Teradata, Oracle, DB2, Sybase, SQL Server). Extensive experience in testing Reports like dashboards, drill up and drill down, adhoc as well as scheduled. Good exposure wif writing SQL scripts, complex SQL queries, Testing of Source to target mappings, Testing of BI Reports.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled teh Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Performed Unit, Integration and System Testing.
• Experience in Guidewire Policy Center, Billing Center and Claims Center.
• Proficient in testing projects from inception, requirement specification, planning, designing, configuration management & documentation and post production support.
• Rich onsite exposure of coordinating end to end testing processes, executing projects, interacting wif Onsite Testing for removing gap between client expectations & testing capabilities and assisting onsite work in planning & risk mitigation in critical situations.
• Hands on Experience on testing web services (SOAP, REST) using SOAP UI Tools.
• Experience working closely wif business analysts and business unitsto halp wifUAT testinganddefect management.
• Working Knowledge on all Phases of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and testing methodologies such as V - Model, Agile and Waterfall Model
• Deft in testing methodologies viz. BI - ETL Testing, Report Testing, Manual Testing and Automation testing (QTP), and Database Testing; and completing highly complex test optimization.
• In-depth knowledge of various tools such as ETL Tools: Informatica and Datastage Director; Reporting Tools: Microstrategy, SAP BO, OBIEE; Automation Tools (QTP), Quality Centre (QC) and Basic UNIX commands.
• Team Player wif excellent communication, planning, analytical and organizational skills
• Good analytical and problem solving skills.
• Team player wif excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS

ETL Tools: Ab Initio, (GDE 1.15, Co>Op 2.15), EME, Data Profiler, Informatica9.x/ 8.6/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS, Data Stage

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2, Teradata, Sybase 12.5, MySQL, Netezza

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI r3/r2/6.x/5.x, SSRS, SSAS, Crystal Reports, OBIEE

Languages: SQL, PL/SQL, XML

Tools: Toad, SQL* Loader, WinSQL, SQL Developer, Teradata SQL Assistant, SQL Plus*

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: HP Quality Center, Bugzilla, Rational Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Erie, PA

Sr. QA/ETL Tester

Responsibilities:

• Involved in implementing insurance claims applications using Guidewire Claim Center Product.
• Performed Data Validation Testing, Functionality Testing, Defect retesting and Regression Testing.
• Involved in testing teh XML files and checked whether data is parsed and loaded to staging tables.
• Was responsible for back-end system replacement of teh policy processing &billingsystems, changing from a proprietary back-end system to "Guidewire" a pre-built solution.
• Worked on Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework forGuidewire.
• Create and execute test cases manually; involve in executing automated test cases to verify Guidewire Claimcenter and Billingcenter applications.
• Automate existing manual test cases wif Selenium in collaboration wif QA team members.
• Performed backend testing using SQL queries to validate data.
• Wrote complex SQL queries in TOAD to perform Backend testing.
• Evaluate, plan, design, develop, and maintain test scripts using a framework for new applications, products, and/or enhancements to existing applications throughout their development/product lifecycles.
• Create and execute test scripts, cases, and scenarios dat will determine optimal system performance according to specifications.
• Coordinated wif team leads to determine needs and how best to implement JIRA wifin department.
• Write SQL queries, analyze teh data, and perform data migration processes.
• Conducted manual ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into teh Multi-dimensional data warehouse.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh ETL Mapping.
• Tested teh ETL mappings and other ETL Processes (Data Warehouse Testing).
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Tableau reports.
• Worked on teh Enhancement of Cognos reports
• Involved in preparing teh Test Scenarios for ETL Testing
• Creating Test Cases after analyzing teh BRD’s.
• Involved in requirement gathering and performed ETL process.
• Tested teh ETLInformaticsmappings and other ETL Processes.
• Involved in testing and validating data cleansing, data mapping, and data profiling, performed under ETL process using Informatica.
• Responsible for manual testing of both web and stand-alone applications (Agile/Scrum development) - majority testing: System Testing, Functional Testing, and Integration Testing.
• Worked wif Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group.
• Managed Jira users and created workflows, issues types, fields in production.
• Used SQL to validate teh new system staging data wif existing production data.
• Developed reusable SQL scripts dat can be used for regression testing.
• Used Selenium WebDriver API to automate tests on cross browser and cross platform environment.
• Created new/modified test scenarios, test cases, Test Metrics and test approach strategies for this project.
• Manually tested teh whole application before automation of teh tests. Helping development team in defining teh scope for Unit testing.
• Wrote Test Cases in HP ALM dat would test various Test scenarios.
• Wrote Test plan and Test cases for teh Integration testing and system testing.
• Designed and implemented SQL queries for QA testing.

Confidential, Walnut Creek.CA.

QA Tester

Responsibilities:

• Coordinated activities of testing resources to ensure testing effort on schedule and wifin budget
• Coordinated wif Release Manger on scheduling builds to test and staging
• Ensured Offshore QA team has teh expertise on application knowledge before starting of testing phase
• Provided estimates and ensured Vendor teams provided builds in a timely manner
• Member of Change Control Board to approve changes and enhancements
• Created Test Plan based on teh scope and schedule of teh project
• Defined teh Entry/Exit Criteria for teh project and ensure these criteria are met
• Ensured timely delivery of deliverables and adherence to deadlines.
• Coordinated wif Business and User Acceptance Team during test case creation and execution for UAT
• Reviewed and Analyzed Business Requirement Documents, Functional Specification wif System Analysts and Developers.
• Attended Use Case Review and Design Review Meetings and provided feedback.
• Performed Requirement Decomposition to identify High Level Test Scenarios from Specification.
• Assigned and reviewed test cases created by teh testing team in ALM
• Createdand Maintained Traceability Matrix to ensure test coverage of all requirements
• Authorized, Scheduled teh migration of code from development to different test environments. Also in charge of code movement wifin teh 2 test environments. This included new releases and patches.
• Triaged and Tracked Defects in ALM and sent daily Defect Report to Project Team
• Organized Defect Review Board meeting wif Project Team for daily updates on defects during execution
• Coordinated wif development team to ensure timely delivery of builds for new functionality and defect fixes.
• Coordinated wif multiple teams to ensure exclusive access during teh various phases of testing.
• Timely escalation of issue’s related to different teams to ensure an early resolution.
• Created a Regression Test Suite which can be progressively updated for new release of teh application.
• Updated teh Test Scripts for Regression build based on theenhancements to teh application
• Created and Updated Test Execution Matrix and Defect Matrix.
• Responsible for writing teh Test Cases and Test Scenarios based on teh Business Requirement Document (BRD) and technical Specifications and loaded in HP ALM.
• Ran teh SQL queries for checking teh data stored in teh database.

Confidential, MA

Datawarehouse QA

Responsibilities:

• Manually execute teh test cases to perform application functional testing of PolicycenterandBillingcenter.
• Worked on Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework forGuidewire.
• Wrote Test plan and Test cases for teh Integration testing and system testing.
• Involved in discussions wif teh Team on Quality Analysis, Manual Testing,Automated Test Toolsand Defect Tracking Tools.
• Involved wif ETL team to implemented ETL process to load and extract data using Informatica.
• Involved in ETL process testing using Informatica ETL tool. Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy center and Payment manager in Guidewire application based on teh business requirements using LISA.
• Performed manual front-end testing to check all functionalities of different modules.
• Created and maintained SQL scripts/queries for Data Migration, conversion, mapping, validation and data verification at teh backend testing on teh oracle database.
• Source to target requirements, ETL map specifications and business requirements were referred to write precise test cases
• Coordinating wif source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Conducted and automated teh ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into teh Multi-dimensional data warehouse.
• Verified teh ETL transformation logic by creating test SQL's and running them against teh source and target entities
• Created dashboards, reports and inquiries for all JIRA related administrations.
• Performed Manual and Automation Selenium testing of web based application.
• Performed database testing for checking Data Validation and Data Integrity using SQL queries.
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy center and Payment manager in Guidewire application based on teh business requirements using LISA.
• Involved in writing Test Plans and Test Scripts for Manual and Automation Testing.
• Implemented Load testing using Soap UI and Load UI tools.
• Analyzed teh responses of teh web service using SOAP UI and validating teh data in backend
• Involved in teh setup of Continuous integration by mapping teh script wif Jenkins to run in predefined time
• Created new/modified test scenarios, test cases, Test Metrics and test approach strategies for this project.
• Wrote Test Cases in HP Quality center dat would test various Test scenarios.
• Utilized JIRA to manage defect tracking, bug fixes, test scripts, and report defect.
• Prepared user manual and performed user acceptance testing.
• Wrote SQL Queries to retrieve and validate teh data.
• Developed Test Plans, Test cases, Test Scripts, Test strategy, Test Scenario, Test Reports.
• Did Integration Testing, Soap GUI testing, Smoke and Sanity Testing, and Acceptance testing in teh new builds for Basic Functionality Checking.
• Write SQL queries to automate data integrity and to verify teh UI data against teh real data.
• Designed and implemented SQL queries for QA testing.
• Prepared user manual and performed user acceptance testing.

Confidential, Dayton, OH

QA / ETL Tester

Responsibilities:

• Responsible for reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Prepared Test Cases for teh mappings developed through teh ETL tool SSIS and executed those Test Cases.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh SSIS Packages.
• Used JIRA to create and maintain Test Requirements.
• Check for teh assigned stories in JIRA and complete prior to deadline and mark it done after completion.
• Updated JIRA stories on teh confluence page and followed Scrum Agile.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh business systems.
• Performed Manual Testing to test teh usability of teh application.
• Performed extensive work wif ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Conducted GUI testing to test teh appearance and properties.
• Analysis teh testing activities as per teh planned forecast for teh given projects.
• Analysis teh Weekly QA Metrics Reports for to correct teh reporting errors.
• Getting updates and working wif project team members for issues captured through metrics reporting.
• Documented and reported bugs using JIRA.
• Actively participated in Status reporting meetings and interacted wif Developers to discuss teh technical issues.
• Analyzed teh requirement coverage and traceability to ensure teh testing coverage
• Performed Smoke Testing, Sanity Testing.
• Performed back-end testing using SQL queries to validate data and perform Data integrity testing.
• Documented and reported bugs using JIRA.
• Executed teh ETL jobs sessions and workflows.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Performed data reporting & visualization in Tableau.
• Assisted in production Support whenever needed.
• Involved in creating test cases for regression testing and assist test lead during teh testing activities.
• Was involved in Back End testing using SQL Queries on Oracle Database.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing
• Reviewed extensive SQL Queries wif complex multi-table joins and nested queries.
• Wrote extensive SQL queries for data validation, analysis and manipulation, and maintaining teh integrity of teh database.
• Responsible for executing SQL Queries for checking duplication in records.