• Over 8 years of excellent IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Data Warehouses using ETL Business Intelligence solutions.
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in Data Analysis, Understanding in Dimensional Data Modelling, Data Extraction, Transformation Loading ETL , Cubes and End User Reports.
• Good Understanding on Star Schema Modelling, Snow-Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modeling.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Experienced in functional, integration, regression, compatibility, security, back end, acceptance testing UAT , smoke testing, sanity testing and GUI Testing.
• Advanced user in using Test management tools like HP Quality Center/Test Director, JIRA.
• Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2008/2005/2000/7.0/6.5, IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• A good team player with excellent written and verbal communication skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. .

Confidential

Data Quality Analyst / ETL QA analyst

• Analyze and resolve complex issues related to data provider, membership, claims, etc.
• Models.
• Manage data quality documentation. Define and maintain data standards, definitions, and
• Measure data quality. Activities include: Design, collect, analyze, and report on data quality assurance / production performance metrics.
• teams and development or improvement task forces. Assist other groups in database setup, design of edit checks, test plans, DQ policy decisions, etc. to ensure data quality objectives are met.
• Provide quality assurance oversight of data flows and stores. Revie quality of data entry, loads, transformations, extractions, merges, or other production jobs. This may also include the
• Provide data quality advisory services to the organization. Activities include: Participate in cross-functional root cause analysis as well as collecting user requirements.
• Involves interacting with business users to resolve data quality problems using techniques such as establishment and monitoring of service level agreements, communication protocols with data suppliers, and data quality assurance policies.
• Identify, assess, document, and communicate potential quality issues in the way data is managed.
• Developed Test Strategy, Test plans, and Test scenarios using MS Word and MS Excel.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for many scenarios and applications.
• Perform data extracts to identify data discrepancies.
• Environment: Oracle, Toad, MS Excel, HP Quality Center 10, XML.

Confidential

Sr. QA Analyst/ETL /Business Intelligence

Responsibilities:

• Involved in Regression, Functional, Integration, Smoke, Ad Hoc, End to End System Testing and User Acceptance Testing.
• Participated in analysis of Business and functional requirements.
• Interacted with Business users to determine User requirements and goals.
• Created reports that included a general overview, open bugs, ne bugs and enhancement requests.
• Entered ne bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Developed Test Strategy, Test plans, and Test scenarios using MS Word and MS Excel.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for many scenarios and applications.
• Performed basic testing of security features using manual testing.
• Responsible for creating Test Strategy for the Data Warehouse.
• Testing the source and target databases for conformance to specifications.
• Conditional testing of constraints based on the business rules.
• Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
• Conducted revie sessions on test case and regression test scripts in Quality Center.
• Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
• Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Tested several UNIX Korn Shell scripts for ETL data loading
• Verified Informatica sessions, worklets and workflows in QA repository.
• Verified the property and loan order information like data in the pricing models against source and target databases by using SQL Queries.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Used SQL for Querying the Oracle database.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested whether the reports developed in Cognos are as per company standards.
• Tested different detail, summary reports and on demand reports using Report Studio.
• Analyze software problems, provide clear and concise defect reports and follo defect tracking practices based on internal QA standards and processes.
• Reported bugs and tracked defects using Quality Center 10.

Environment: Oracle 11g, SQL Server, Informatica Power Center 9/8.5.1 workflo manager, workflo monitor , Cognos 8.0 Series, XML, Test Cases, Unix, Test Matrix, , TOAD, ALM / HP Quality Center 10.

Confidential

Sr. QA Analyst/ETL/ DWH Tester

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production Participated in revie meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, revie with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC 9.2.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Bug reporting and Bug tracking using HP Quality Center.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Worked in Agile methodology during application development and participated in daily scrum meetings.
• Developed user defined functions, created objects where required and used descriptive programing to automate.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and Executed SQL statements in Toad to retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix, and participated in daily/weekly QA meetings.
• Used Quality Center for logging the defects.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Informatica Power Center 8.6 Repository Manger, Designer, Server Manager , Oracle 10g,MS SQL, HP Quality Center 10.0/9.2, TOAD, BO, MS Excel, MS Project.

Confidential

QA Analyst/ETL Test Analyst

Responsibilities:

• Analyzed the Business requirements and developed 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.
• Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flo and the logic for the Data warehouse project.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested whether the reports developed in Business Objects and Crystal Report are as per company standards.
• Tested Ad-hoc reports, drill down and drill through reports using SSRS.
• Tested different detail, summary reports and on demand reports.
• Involved in pre and post session migration planning for optimizing data load performance.

Environment: Informatica Power Center 7.2, MS SQL 2000, Oracle 9i, SQL, PL/SQL, SQL Navigator, Erwin 4.1, Windows XP and 2000,Business Objects, Crystal Reports, Mercury Quality Center.

Confidential

QA Analyst

Responsibilities:

• Analyzed business rules to generate consolidated fact/summary data
• Written Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL to perform Backend Testing on databases.
• Involved in supporting the deployment of data marts and reports.
• Performed manual testing prior to automate testing on the application.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.

Environment: ASP.Net, Oracle 9i, PL/SQL, TOAD, XML, Test Director, HTML, Windows NT/2000.

Education: MCA Master of Computer Applications from Madras University.