SUMMARY

• Over 7 years of extensive experience in Software Quality Assurance and Testing with strong knowledge of Software development life cycle (SDLC) and Software Testing Life Cycle (STLC)
• Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios
• Hand on experience in Functional testing, Integration testing, System testing, Regression testing and End to End testing
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experience in financial application testing such as Insurance, Banking, Health and web applications integrated with various legacy systems
• Create test plan, test coverage requirements document, test cases and execute test cases manually for MDM.
• Extensive experience in all testing methods including Waterfall, Spiral, V model, Agile and Scrum
• Expertise in creating/developing Test cases, Test scenarios using standard and modular approach
• Experience in working as a single point of contact for all testing activities and as liaison between the different teams members and the manager
• Validate EDI Claim Process according to HIPPA compliance
• Well versed with Manual and Automated Testing methodologies and principles.
• Validated insurance claims, customers’ records, and policy renewals data moving from operational data store to Enterprise data warehouse.
• Validated the market surveys functionality, both the front end and back end for gathering information about customers’ choice and preferences of insurance products and ongoing market trends in the insurance industry.
• Validated customized insurance programs functionality to suit the customer needs.
• Experience in testing/validating the Source, Stage and Target (End - to-End) data systems
• Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified
• Familiar in working with Quality Center to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements.
• Expertise in Defect Tracking, Defect management and Bug Reporting using tools like Clear Quest, Test Director, Quality Center
• Experienced working with Customer Information Data Mart for business reporting thru MDM and Reference Data
• Experience in testing/validation of Actuate reports, Business standard and ad hock reports
• Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting
• Experience in creating & scheduling the jobs using Autosys
• Ability to work as independent and team member in challenging and cross platform environment
• Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, DB2, Teradata V2R6/V2R5, SQL Server 2005/2008

ETL Tools: InformaticaPower Center, Ab Initio, Data Stage, SSIS

Operating System: Windows, UNIX (Solaris)

Scripting: UNIX Shell Scripting, PL/SQL scripts

RDBMS Load Tools: SQL Developer, SQL * Plus (Oracle), T-SQL (SQL Server)

Reporting Tools: Business Objects, Cognos, Micro Strategy, SSRS, SSAS

Database Tools: TOAD, SQL Developer, Rapid SQL

Languages: SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE

Confidential, phoenix AZ

ETL QA Tester

Responsibilities:

• Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings,
• Involved in writing and reviewing the test scripts.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Identified the test data to execute the test cases.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Create and execute test scripts for MDM using QTP Automation tool.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Worked on Waterfall, RUP and Agile methodologies.
• Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Extensively worked on RPD and Dashboards.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks
• Did Data Centric Test Solutions for Data Warehouse, Data Integration, Data Quality Assessment and Data Privacy.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Participated in manual functional testing and automation using Autosys
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Solely responsible for manual and automated testing of MDM
• Validated Query Prompts as, Cascading Prompts, Calculations, Conditions & Filters
• Experienced using database query and integration tools such as TOAD, SQL plus etc.
• Experienced in data analysis using SQL, TQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported bugs and tracked defects using Quality Center.
• Developed the Test Scripts and Test Cases in Quality Center.
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Error handling and performance tuning in Teradata queries and utilities.
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Data reconciliation in various source systems and in Teradata.
• Written several complex SQL queries for validating Cognos Reports.
• Extensively used SQL to verify and validate the data loaded into Target
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Preparing and supporting the QA test environments

Environment: Informatica Power Center 9.1, Claims, agile, Cognos 10.2 series, Oracle 11g, HP ALM 11/quality center, SQL Server 2012, Oracle SQL Developer, Teradata, OBIEE 11g, XML, PL/SQL, SQL, WinSCP, Putty, TFS, UNIX, Toad, SharePoint, Windows Office

ETL QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Written SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Extensively involved in testing theETLprocess of data sources, SAP, PeopleSoft, Oracle, flat files into the target SQL server, Oracle database as per the data models.
• Experienced using database query and integration tools such as SSIS, TOAD, SQL plus etc.
• Involved in testing SSIS Packages, and in Data Migration.
• Worked in an Agile technology with Scrum
• Involved in testing the Cognos reports by writing complex SQL queries
• Extensively used Informatica power center for extraction, transformation and loading process
• Tested SSIS packages according to business requirements and data mapping requirement documents.
• Obtained detailed understanding of data sources, Flat files & Complex Data Schemas in order to write the best test scripts.
• Supporting presales activity for Data centric warehouse testing projects.
• Create automated test scripts for MDM using Win Runner.
• Responsible in testing Initial and daily loads of ETL jobs.
• Reported bugs and tracked defects using Quality Center (Test Director)
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Tested & developed the mapping for extracting, cleansing, transforming, integrating & loading data using Autosys.
• Perform full manual regression testing of MDM
• 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.
• Developed TSL (Test Script Language) for automated Testing using Win Runner. Worked with business team to test the reports developed in Cognos
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Experienced in data analysis using SQL, TSQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported bugs and tracked defects using Clear Quest.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Extensively used SQL to verify and validate the data loaded into Target.
• Done data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the SSRS reports.
• As a part of Data centric testing, loaded to Data warehouse is correct as per the defined business rules.
• Managed and executed the test process, using Agile Methodology
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Documented and reported various bugs during Manual Testing.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Performed the tests in both the SIT, QA and contingency/backup environments
• Used SQL for Querying the database for data validation, data verification and data conditioning.
• Writing the test scripts, test cases & test plan for multiple ETL Feeds.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, Backend Testing, End to End testing and Regression Testing
• Involved in Preparing and supporting the QA test environments
• Load new or modified data into back-end database.
• Defect Triage with Development team.
• Involved in peer review of test cases.

Environment: Quality Assurance, Agile, SQL Server 2008, claims, Cognos 8.0 Series, Oracle 11g, XML, XSLT, XSLD, Flat Files, MS Excel, SQL, T-SQL, PL/SQL, SSIS, SSRS, SSAS, informatica 8.6.1/8.1, Toad, Clear Quest, Windows, UNIX, Clear Case, HP Quality Center 10

Confidential, Nashville, TN

ETL QA Tester / Reports Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Validating the data passed to downstream systems.
• Used data stage director to run the jobs and check the log files.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Involved in validating SSIS and SSRS packages according to data mapping specifications.
• Involved in validating SSAS cubes according to functional specifications.
• Validated SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Create and execute test cases for MDM
• Performed manual testing on different modules of the application.
• Reported software mismatches (from the test planning), to the development team using Quality Center
• Involved in Testing SSIS Packages, and also involved in Data Migration.
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Exclusively used Analysis Studio and Report Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed,Drill down
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Validated Multi-Dimensional cubes using Power Play transformer
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Validated Query Prompts, Cascading Prompts, Calculations, Conditions & Filters
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection
• Analyzed Business Requirements and Developed the Test Scripts and Test Cases
• Used Quality Center for Bug Reports and Defect Tracking.
• Performed Risk Analysis based on Defect Severity and Priority.
• Tested User Interface inconsistency and application functionality.
• Worked on issues with migration from development to testing.
• Tested application in various browsers.

Environment: DB2, Oracle 10g, XML, Cognos7 Series, claims, informatica power center 7.2, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SQL Server 2008/2005, SSIS, SSRS, Toad, Clear Quest, .Net, C#, Quality Center, Windows, UNIX

Confidential, Woonsocket, Rhode Island

ETL QA Analyst

Responsibilities:

• Validated SQL and stored procedures for the data warehousing application projects.
• Documented business requirements by facilitating sessions between business and technical team
• Involved in systems design and implementation of standardized business processes
• Extensively used Joins in order to get records from different tables
• Validated Triggers that are implemented to enforce Integrity constraints, Cursors for data extraction and to carry out updates of new fields, and exceptions for run-time error handling.
• Validated Informatica workflows and mappings against the requirements.
• Involved in maintaining and first level troubleshooting of the database.
• Validated micro strategy reports according to the functional requirements.
• Analyzed and wrote logics, tests for software solutions involving database extraction
• Designed and implemented a new information database for supporting interfaces
• Coordinated with other technical teams to ensure compatibility with other modules and applications
• Consulted with users and stakeholders to ensure that requirements are met
• Familiarized with software development lifecycle and configuration management

Environment: Informatica, Oracle 8i, SQL Server 2000, Micro Strategy, SQL, PL/SQL, Windows XP, JAVA Script, Win XP, MS Office Suite