SUMMARY

• Around 7 years of professional experience in Software Industry, Expertise in all kinds of testing (Manual and Automation) with focus on Business Intelligence, ETL, Data warehouse, DataMart, Databases, Web services, Client - Server applications
• Extensive knowledge on all phases of Software Development Life Cycle (SDLC).Experience in Agile, Scrum and Waterfall models of SDLC.
• Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participate in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, & Defect Report.
• Worked with Business analysts to understand the business and involved in walkthroughs, and periodical meetings to come up with project plans.
• Extensive use of defect tracking tools like Quality Center and Test Director. Experience in functional testing tools such as Selenium testing
• Wrote complex SQL and PL/SQL queries to validate DataMart and Data warehouse Backend Testing
• In-depth knowledge of all QA Phases that include Manual, Functional, System, Integration, Regression Testing End-to-End testing
• Experienced in Integrating and coordinating testing activities into software development activities
• Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases on the basis of product release features, client’s requirements and related technical documents.
• Tested the reports generated by SSRS and verified and validated the reports using SQL.
• Experienced in creating Environment Variable, Automation Object Model (AOM), and Dictionary Object Model
• Worked with different RDBMS Oracle, SQL Server, Teradata, MySQL, IBM DB2 and their GUI utilities like SQL Loader, Oracle SQL developer, Teradata SQL Assistant, Win SQL to do transaction of data
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Experienced in programming Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using Oracle, SQL Server and DB2.
• Working knowledge on various types of data feeds like: XML, DB2, Oracle and Flat files.
• Excellent in writing SQL and PL/SQL queries and UNIX shell scripts to perform Backend testing
• Strong working experience in the Data Centric Testing, Data Analysis, Design and Development
• Supporting multiple projects, while maintaining strong quality and ability to meet deadlines
• Excellent analytical skills, documentation skills and presentation skills
• Self-starter and ability to present ideas in a concise, logical and well organized format

PROFESSIONAL EXPERIENCE

Confidential, Oldsmar, Florida

ETL/QA Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Designed and executed various Test scripts for Regression tests
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using SSIS ETL Tool and Internal ETL Tool.
• Involved in investigating the errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Prepared and Execution of test scripts using Selenium using TestNG
• Performed functional, compatibility testing on different browsers like Firefox, IE & Chrome
• Experience in working with Selenium Web Driver
• Experience in writing CSS Selectors, Xpath expressions to identify web elements.
• Written Complex SQL Queries. To do manual testing in my feature on the SDM tool for every release and check the configurations
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center defect tracking system.
• Involved in Mobile Testing and Web Soap based Webservices
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.
• Worked on issues with migration from development to testing.
• Tested the entire compliance reports generated using SSRS BI tool by validating the data in the report against the database according to the requirement specifications using SQL

Environment: Quality Center 12.1, UAT, ASP.Net, HL7, ETL,SQL Server, Business Intelligence Mainframe, MS Office, SOAP UI 3.x, Oracle, XML, WSDL, XSLT

Confidential, Duluth, GA

ETL /QA Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using SSIS ETL Tool/Informatica.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Validated the target table column definition with source column definition (including type and length)
• Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Extracted Data from Teradata using Informatica and SSIS ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Heavily involved in performance testing and worked with analyzing tables, gathering statistics, tuning of SQL queries used to fetch source data.
• Presented QA team work update/Status to Project/Program Manager in status meeting and also worked with business team to get approval on test plan/test cases.
• Developed Test Scripts and executed them manually to verify the expected results and published the same to wider audience upon successful completion along with QA signoff.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files
• Used HP Quality Center to state requirements, business components, test cases, test runs for every iterations, defects. Also link defects with requirements.
• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Documented and reported various bugs during Manual Testing.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Retesting the resolved defects/issues after the developers fix the defects
• Validated cube and query data from the reporting system back to the source system.
• Involved in preparing test data for UAT and participated in UAT signoff

Environment: Oracle 9i/10g,Teradata, SQL, UNIX, HP Quality Center, TOAD, SQL Navigator, Windows XP Professional, PL/SQL, SSH Pro, Smart FTP, MS Excel 2003, MS Word 2003, Remedy, PVCS Version Manager, Text Pad 5.0, SharePoint

Confidential, Orange County, CA

QA Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Designed and executed various Test scripts for Regression tests
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Involved in all three centers (Claims Center, Policy Center and Billing Center) Integration and their Replication data load in Guidewire tables.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power center.
• Involved in investigating the errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Experienced in Property & Casualty Billing.
• Used Quality Center to maintain Test Case and Reports Repository.
• Have programming skills in SQL and PL/SQL and experience in SQL Server and Oracle databases on UNIX and Windows platforms.
• Tested Micro strategy reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters
• Prepared and Execution of test scripts using Selenium using TestNG
• Performed functional, compatibility testing on different browsers like Firefox, IE & Chrome
• Experience in working with Selenium Web Driver
• Experience in writing CSS Selectors, Xpath expressions to identify web elements.
• Written Complex SQL Queries. To do manual testing in my feature on the SDM tool for every release and check the configurations.
• Worked in an agile technology.
• Involved in the maintenance of Claims Systems - Property & Casualty using PowerBuilder and SQL Server
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.
• Experience working on different ETL tools worked with tools like Informatica and Talend.

Environment: Informatica 9.6.1, Micro strategy, Oracle 11g/10g, Quality Center 11.0, QTP, XML, Agile, Win SQL, T-SQL, SQL, TOAD, SQL Assistant 6.0, PL/SQL, IBM DB2,UNIX, MS Visual Studio, MS Access, Flat Files.

Confidential, Madison, WI

QA Tester

Responsibilities:

• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Redesign, Customer Billing Output, Earthquake Transition, EDI Lien holders and Dwelling Fire Rate Change 2010.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services
• Worked in an agile technology with Scrum.
• Developed Test Scripts and executed them manually to verify the expected results.
• Executed the Test cases for Micro Strategy.
• Tested the XMLs feeds received from another source which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Involved in automated Regression Testing using Quick Test Professional (QTP).
• Created Data warehouse ETL test data for all ETL mapping rules to test the functionality.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing on UNIX and Windows platforms.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Tracked defects to closure by coordinating with the dev team.
• The reports that were created in Micro Strategy were testing by running the SQL statements
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Prioritized and reported defects using Quality Center to present documents and reports in weekly team meetings.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Managed and executed the test process, using Agile Methodology
• Worked with Data warehouse ETL group for understating mappings for dimensions and facts.
• Prepared test data to cover all the test scenarios.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

Environment: ETL Informatica 8.6, Micro strategy, SQL, PL/SQL, HP Quality Center 9.2, XML, MS Visual Studio, Agile, Oracle 10g, QTP, ALM, SOAP UI, JavaScript and TOAD for Oracle

Confidential, New York

QA Analyst/Validation Tester

Responsibilities:

• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Comparing/analyzing mainframe test data with the front end.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Running SQL queries on the mainframe servers to retrieve test data.
• Reviewed Functional and Integration requirements.
• Develop Functional and integration test cases and review Test Cases wrote by peers.
• Created Test Cases, and got reviewed those by peers
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Discuss issues/defects with the business and development teams.
• Testing/Verifying/logging defects.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Developed UNIX Shell scripts to automate repetitive database processes
• Performed application setup in test environment and enhancing the documentation.
• Worked with internal and external developers/quality assurance staff to understand and resolve issues.

Environment: AGILE, Window NT/XP, Vista, HTML, Java, DB2, Excel, QTP, Quality Center, SQL, SQL Assistant, XML, XPath, XQuery, and Web Services.