Professional Summary

• Software Test Engineer with over 8 years of experience in Software Testing, IT support, Test Automation development and testing ETL, Data warehouse, Client/Server and web applications.
• Expertise lies in Functional testing, Manual Testing and Automated Testing, Back end Testing , Regression testing, User Acceptance testing UAT , System testing, Integration testing Ab Initio and Black Box Testing.
• Expertise in testing of new smart list in Great Plains for Periodic reporting
• Excellent knowledge of Agile Scrum development environment, multiple web browsers, and automated testing suites.
• Experience in job scheduling for Data ware House using Autosys
• Extensively used HP Quality Center QC and Mercury Test Director for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate-wide-ETL solution using IBM Datastage8.0,7.X /6.X Manager, Designer, Director, Administrator , Parallel Extender, Data Mining, OLTP, OLAP
• Experience in Testing knowledge of Great Plains and Microsoft CRM processes.
• Experience in Testing BI applications using OBIEE, SSRS.
• Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, functions using SQL Developer and Toad as development tools.
• Tested trading partner specifications and EDI mapping guidelines
• Proficient in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center QC 11,/ALM, Test Director, JIRA, Clear Quest
• Diversified experience in Manual and Automated testing extensively used automated Testing Tools such as Mercury Interactive Test suite in both Windows and UNIX environment Win Runner, QTP and Test Director .
• Worked with Cucumber, using Selenium web driver to test web application and mainframe applications.
• Behavior driven development approach to write automation test script to test web applications with Selenium-Cucumber
• Familiar with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions Triggers.
• Experienced in dealing with clients to gather requirements, understanding the Business Requirements, product demonstrations and providing product support.
• Experience in full Software Development Life Cycle SDLC designing, debugging, testing, Documentation, maintenance and enhancement .
• Having excellent problem solving and analytical skills and experience of test plans, strategy and Procedures throughout the life cycle of a project from specification reviews through to user Acceptance.
• Perform migration and testing of static data and transaction data from one core system to another.
• Writing and executing SQL queries to ensure data integrity to meet user requirements exposure in Database testing.
• Experience in testing automation scripts with Win Runner for all the components of application.
• Experience in data analysis and problem solving with large amounts of data
• Hands on experience with analysis of business, technical, and functional requirements and Tested the test plans, test cases and test strategies.
• Prepare data migration plans including migration risk, milestones, quality and business sign-off details.
• Experience in Load runner using various technologies like WEB, SOA.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center QC and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Proficient in automating the QA process using various automation tools QTP, Load Runner, Quality Center.
• Work across multiple functional projects to understand data usage and implications for data Migration.
• Experience with software test management tool HP Quality Center QC /ALM.
• Familiar with the use and working of Rational Requisite Pro for requirements management.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Experienced in web and client/server applications QA testing.
• Expertise in QA Testing in distributed Unix Environment and Oracle databases as back end, Performed end-to-end testing back-end testing.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL Tester

Environment: Informatica Power Center 9.1, Quality Center ,Windows NT, Microsoft Great Plains, Micro Strategy, Oracle11i/10g, SQL Server, Agile, PL/SQL, Toad, VSAM Files, XML, XSD, HP Quality center/ALM.

• Created temporary tables for validations after understanding the transformation logic.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Documented the validation rules, error handling and test strategy of the mapping.
• Worked with automated SQL Stored Procedure to daily populate Great Plains
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using Mapplets and reusable transformations.
• Conducted back to back meetings with developers and discussed about all open issues.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Extensively Used HP Quality Center QC /ALM as test management tool and Created and maintained the defects in HP Quality Center/ALM.
• Tested data sheets with Agile and Waterfall methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Established and documented ETL QA standards, procedures and QA methodologies.
• Conducted test case daily reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System ETL Mapping Document for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Confidential

Role: ETL Data stage Tester

Environment: IBM Web sphere Data Stage9.1 /8.5/ 8.0.1/8.0/7.5/7.1, HP Quality center9.2, QTP 9.2 Selenium, SQL server SSIS 2005 , SQL server SSRS 2005 , SSAS , Teradata V2R6, Windows 2000, T-SQL, SQL Plus, UNIX, Rational Clear Case, , DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, Win SQL, HP ALM.

• Tested the Online Services application to ensure that the requirements, artifact from each phase, and the final product--are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Monitor security batch processing jobs in multi-platform shop via Control-M Tidal Schedulers.
• Interacting with the Offshore Team members about the project status thru Conference calls and need to prepare a Teams of Memorandum for the same.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster Moment of data.
• Tested various work flows with AGILE methodology, keen interaction with BA's, Developers and infrastructure team
• Performed backend testing and reviewing DB tables for updates
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Performed the Unit and functional testing which validate the data is mapped correctly which Provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Tested the application for web functionality, and verified the online modules for broken links.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Tested policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Performed usability testing frequently to ensure continuous availability of online services to Personal clients.
• Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall Process flow and Source to Target Mappings.
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc , Dashboards etc.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Tested transformation functions and record formats for various input data files.
• Responsible for testing packages using SSIS ETL to verify data completeness, data Transformation, data quality, integration testing, UAT regression testing.
• Writing SQL Queries to retrieve data from data base.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Conducted weekly batch testing to incorporate changes in new builds.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Confidential

BI Tester

Environment: Informatica 8.1, Test Director 8.0, Win Runner 5.0, Load Runner , Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005. Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP

• Involved to create Business Risk Levels to determine Test Priorities.
• Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, Involved in both Manual and Automation Testing.
• Performed Regression testing using Test Director.
• Extensively used SQL Queries to verify and validate the Database Updates.
• Used Test Director a workflow automation tool for defect tracking and product automation.
• Created User Defined Functions and procedures in Test Director Library to re-use them in Different tests.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems Including Oracle and Teradata.
• Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Tested SQL 2000 Reporting services, Integration services and Analysis services
• Defining and performing the Test strategies and associated scripts for the verification and Validation of the application and ensuring that it meets all defined business requirements and Associated functionality.
• Tested the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down.
• Tested OLAP cubes and SSRS reports for various business needs.
• Worked with SSIS system variable, passing variables between packages.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Excel.
• Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.
• Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
• Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Confidential

ETL Quality Analyst

Environment: Test Director 8.0, SQL server 2005, SQL Server, DTS Packages, Remedy, Windows NT, UNIX, MS Excel, VSS Visual SourceSafe , Load Runner, Quality Center 8.2, QTP 8.2

• Tested different methodologies like Waterfall and AGILE, well versed with both Methodologies of SDLC.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
• Involved in unit testing and integration testing of the developed work Analyzed production support Issues.
• Gathered UI specifications and analyzed business process and established test strategies.
• Tested the values for test, Component parameters in Quality Center.
• Performed Backend Testing, Database validations, patient claims validations by writing complex SQL minus queries
• Installing, Configuring and maintaining of Load runner and QTP Tools.
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Responsible for developing PL/SQL Stored Procedures, Functions, Packages, triggers and other Database objects.
• Assigned users in TD administration, Created Test folders in Test Directors users in Project Customization.
• Logged issues in Test Director and tracked them to see whether the bug is fixed in the next Version.
• Communicated with Developers regarding technical issues.