Professional Summary:

• Over 6 Years of professional experience in Information technology covering Quality Assurance, and Data Analysis in ETL, Business Intelligence, Client Server environments and Web Based applications.
• Strong testing background that included reviewing system requirements, Preparing test plans, test strategies, test scenarios, writing and executing Test cases.
• Strong Knowledge of the Software Development Life Cycle SDLC and methodologies Agile, Waterfall , and ensure Quality Assurance Control.
• Experience analyzing the requirements and Proficient in establishing QA Procedures, Standard Methods, and Business Requirement Document BRD .
• Experience in developing Test Plans and Test Cases using the requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Validated the Initial and Incremental loads for ETL applications build using Informatica, Ab initio, Data Stage, SSIS.
• Experience in QA Analysis for BI Reports testing using reporting tools such as OBIEE, Cognos, Business Objects, Micro Strategy, and SSRS.
• Strong work experience Black box and White box Testing.
• Experience in Functionality Testing, Regression Testing, System Testing, Integration Testing, Unit Testing and User Acceptance Testing.
• Working experience with Relational Databases like Oracle, SQL Server, DB2, Teradata and MS-Access.
• Experience with Data Analysis, Data Validation, Data Frequency Analysis, Data Scrubbing, Data Cleansing, Data Profiling, Data Migration Testing.
• Experience conducting review meetings and peer reviews for test plans and test cases.
• Experience in testing the ETL, PL/SQL batch jobs scheduled in Autosys.
• Experience working in UAT and post production support of various applications.
• Experience in Back-end testing using SQL queries on the various databases.
• Expertise in using test management tools such as ALM, Quality Center, TFS, Rally and JIRA.
• Strong experience in Defect Tracking and Defect Reporting.
• Documenting Test Documents using MS Office Tools- Word, Excel, and Power Point.
• Excellent Trouble shooting, Problem solving and Technical skills.
• Good Analytical skills, Presentation skills, good communication skills, effective time Management and ability to work in a team or independently.
• Expertise in all the phases of quality project life cycle from requirements gathering and analysis, requirements, high level and detail level test planning and execution.

Technical Skills

• QA Methodologies: Iterative, Agile, Waterfall
• QA Tools: ALM, Quality Center, Microsoft TFS, Rally, Jira, Clear Quest
• ETL Tools: Informatica Power Center, Data Stage, Ab Initio, SSIS
• BI/Reporting Tools: Cognos, Micro Strategy, Business Objects, SSRS, SSAS, OBIEE
• Query Tools: TOAD, Rapid SQL, SQL Developer
• Operating Systems: Microsoft Windows Family, OS/2 UNIX Sun Solaris, HP-UX
• Databases: Oracle 11/g/10g/9i/8i, SQL Server 2008/2005, DB2, Teradata: V2R6/V2R5
• Languages: SQL, PL/SQL, UNIX Shell Scripts, VB Script
• Version Control Tools: Clear Case, DOORS, Requisite Pro, Microsoft SharePoint
• Scheduling Tools: Autosys

Professional Exp rience:

confidential

Role: QA Analyst

Responsibilities:

• Developing Master Test Plans and Strategy Documents for testing the third party implementation of Order Motion to keep track of Orders in a centralized management
• Analyzed the Order Motion OMX system to understand the process and other integrated components inside the System
• Worked closely with Business Analyst and Subject Matter Experts to understand the core business rules
• Prepared Core Business Test Scenario CBTS test cases to effectively test the priority p1,p2 and p3 business test scenarios
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Analyzed the Technical Design Documents and created the test cases according to the design
• Analyzed the existing Informatica mappings that are in production and tested the code against the new mappings
• Performed monitoring of the ETL jobs Extraction, Transformation and Loading by using Informatica power center Work Flow monitor 8.1
• Responsible for creating test data in OMX UI by placing different orders for different promotions and kits
• Responsible to run the data load jobs in QA and Integration environment to maintain the daily full and incremental loads
• Tested the Business Reports using Cognos cubes and Cognos Reports studio
• Designed the test cases for critical Business Reports such as daily, weekly, monthly and yearly reports
• Tested the Oracle financial transactions in the OBIEEE suite
• Used Test Rail to state requirements, test plan, test cases, update test run status for each iteration
• Used JIRA as a bug tracking tool to log and monitor the defects
• Involved in recording change requests on the Change Requests.
• Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing.
• Validated that application meets requirements and functioning as per the technical and functional specifications.
• Worked as a test coordinator in UAT testing

Environment: Informatica 8.6.1, MS Access, Oracle 10g, SQL Server 2008, SQL, PL/SQL, Oracle Business Suite, Cognos reports studio, Cognos PowerPlay transformer, Cognos PowerCubes, Sharepoint 2010,Windows 2007, Test Rail, JIRA, SQL, , TOAD, Flat Files

confidential

Role: ETL / BI QA Analyst / Data Analyst

• Conducted and attended story review meetings with Business team to gather requirements and prepare test cases.
• Prepared Test Plans, Test Strategies, and Test Scenarios for ETL and Reports testing.
• Created Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Performed Smoke Testing, GUI Testing, Functional Testing, Backend Testing, System Integration Testing, Sanity Testing, and User Acceptance Testing UAT .
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed complex data validation using SQL queries.
• Written several complex SQL queries for data verification and data quality checks.
• Used Informatica workflow manager to run the workflows and workflow monitor to check the status of workflows.
• Developed test plan with testing scenarios from the end user perspective for User Acceptance Testing UAT .
• Worked on data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Preparation of System Test Results after Test case execution.
• Tested the ETL Informatica mappings and other ETL Processes DW Testing .
• Validated SSIS, SSRS packages according to data mapping specifications.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Validated various transformations in control flow and data flow of SSIS packages.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL workflows/Mappings and monitoring error logs.
• Involved in validating the data moving from source to target using Informatica data validation option.
• Have tested reconcile and incremental ETL loads for the project.
• Validated the web services using Soap UI.
• Involved in day to day SCRUM in an agile environment meetings both on site and off shore teams providing the day to day updates on the testing schedules.
• Tested data migration to ensure that integrity of data was not compromised.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Used Rational Clear Quest as defect tracking tool.
• Before the Load is accepted to test, have performed smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes Inserts.
• Done data validation for the Cognos reports.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Tested analytical reports using Analysis Studio.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Informatica Power Center 9.1, Informatica Data Validation Option DVO , Clear Case, Clear Quest, Cognos 10, SQL, PL/SQL, UNIX, Putty, TFS, Flat files, XML, XSD, XSLT, Quality Center, Web Services, Soap UI, Agile, SQL Server 2008, SSIS, SSRS, SSAS, DB2, Rapid SQL

confidential

Role: ETL / BI QA Analyst / Data Analyst

• Developed and documented Standard Testing Procedures for manual testing.
• Played a key role in developing overall quality processes, metrics collection and change management.
• Created manual Test Cases and Test Suite based of functionality in Quality Center.
• Developed and executed test cases and test suites for Functionality and Regression testing.
• Created End to End test Scenarios in the checkout process such as Creating the account, Check out as guest.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Wrote PL/SQL scripts to verify the database updates, inserts and deletes of the records.
• Validated the ETL logs in DataStage director.
• Extensively used Quality Center to track defects and managed them.
• Executed test procedures and documented test results.
• Used DataStage Director to run/monitor the ETL jobs and tested the functionality according to data mapping requirements
• Reported software anomalies in accordance with the internal procedures.
• Provided testing the GUI consistency against different browsers running on windows against various screen resolutions.
• Validated Cognos reports according to report and functional specification documents.
• Tested broken links, navigation, forms, printing and usability.
• Worked on data validation by accessing SQL tables by executing complex Queries.
• Analyzed complains and suggestions coming from customers and reproduced them for developers.
• Tracked defects using Quality Center Attended Bug-Review meetings

Environment: DataStage 8, Oracle 10g, SQL, PL/SQL, Quality Center, TOAD, Cognos 8, DB2, Rapid SQL, JAVA, XML, Windows XP, SQL Server, MS Access, MS-Word, Ms-Excel, Mainframes, UNIX, Putty, JIRA, Clear Case, Clear Quest

confidential

Role: ETL QA Analyst / Reports Tester

• Worked as an ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Responsible for testing the reports according to client's requirement using Business Objects.
• Validated the joins and data using the business objects universe.
• Validated PeopleSoft information getting consolidated into reporting database to allow combined reports to be generated.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Prepared technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to validate business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Tested SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Involved in testing Ab Initio graphs based on data mapping requirements.
• Written complex joins to validate large database volumes.
• Collected performance statistics of each query, function, procedure and worked with business users for acceptable performance criteria.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Used UNIX to run the graphs related to Ab initio.
• Extensively tested several Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts and validated them.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Responsible in testing Initial and daily loads of ETL Ab Initio graphs.
• Validated complex Ab initio graphs using SCD type II involving transformations such as Expression, joiner, aggregator, lookup, update strategy, and filter.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Validated cube and query data from the reporting system back to the source system.

Environment: Ab Initio GDE 1.14, Co>Op 2.14 , SQL Loader, Business Objects XIR2, PL/SQL, SQL, PL/SQL, T-SQL, XML, XSLT, XML Spy 2008, Rally, Oracle 10g, SQL Server 2008, PeopleSoft, MS Visio, Windows 7/ XP, TOAD, UNIX, Putty, Clear Case, Clear Quest, SharePoint, Quality Center