SUMMARY:

• 8+ Years of experience in IT industry as Quality Assurance Analyst and Tester
• Thorough knowledge of SDLC and QA/Test methodologies
• Advanced skills in manual testing and proficiency with backend automation test strategy
• Proficiency with use of all modules in HP QC or ALM (Application Lifecycle Management)
• Exceptional Transactional SQL (SQL Server, Teradata and Oracle.) knowledge
• Skilled in building complex SQL statements involving all join variants to enable them to make robust comparisons of source to target data loaded by the ETL
• Querying against source and target database objects
• Proficient with use of SQL inserts/Updates/Deletes to create “fabricated” and “negative” test data sets.
• Excellent written and verbal communication skills
• Good understanding of Snowflake and star schema for DW modeling.
• Used CA Erwin tool to view / verify the data models while creating test case
• Extremely good in validating XML data files using XML Spy.
• Good Knowledge of Web service Testing application SoapUI.
• Good understanding of XML DTD and XSL.
• Worked on Informatica DVO tool for Regression Testing.
• Analyzed mapping documents and Identified documents/data required for system and functional testing efforts for all test scenarios.
• Managed and executed the test process, using Agile Methodology
• Exceptional documentation skills created most part of the test ware documents including Test Strategies, Test Plan, Test Cases, and Bug reports.
• Enhanced test scripts by analyzing and improving the total time for testing through synchronization and parallelization of independent test scripts.
• Good communication, effectively resolved conflicting scenarios with clients daily stand up calls to communicate test / data related issues.
• Validated XML files against DTD and XSD.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 10.0/ALM Rational Requisite Pro, Rational Test Manager, Rational Clear Quest, XML Spy

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin

Databases: Oracle 11g/10g/ 9i/8i, SQL Server 2005/ 2008, TeraData, MS Access 2000, TOAD, DB2

ETL: Informatica Power Center 8.X,9.1, Data Stage

Programming: SQL, XML

Operating Systems: Windows, Linux and Unix

BI Tools: Cognos 8.4, Crystal reports, OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, Raleign, NC

ETL MANUAL QA

Responsibilities:

• Involved in Tested ETL process that loaded data into the Datamarts from source level to staging and from staging to the target.
• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Logged defects using HP Quality Center 10, linked defects with requirements and generated Defect Reports in QC.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer tools for Querying source Database.
• Performed Report Testing using Crystal Reports by writing SQL queries to validate the data on the report and compare with the backend data.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
• Retesting the resolved defects/issues after the developers fix the defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Informatica 9.0, Oracle 11g/, PL/SQL, TOAD 8.0, SQL, Quality Center 10.0, Crystal Reports 12.0

Senior QA Software Test Engineer

Responsibilities:

• Designed and developed QA Test Plan/Test Cases using Testing methodology with all possible Use Case to cover all testable function in Positive & Negative Testing.
• Provided Test metrics on the results of system testing activities; coordinated and collaborated with others in analyzing collected requirements to ensure system development and implementation plans meet customer needs and expectations.
• Helped drive automation innovation (participated in testing tool analysis and/or reviews, assisted and/or trained other manual testers in automation, implemented recommendation to improve test automation).
• Developed SQL Script (Developed complicated SQL Script in Toad) to validate data, automated UNIX based process.
• Set up Test Environment including refresh database from production, maintained test environment with upcoming release.
• Involved in key learning process after each release to implement process in future as a part of QA Process Management.
• Interacted with team to resolve daily issues in installation, code delivery, documentation, and defects.
• Involved in testing of multiple applications with QA, SIT and UAT testing by documenting, reviewing, resolving defects, follow up with interface sign-off.
• Supported Change Control by reviewing impact of all modules planned all release schedules, back out plan.
• Supported production support team in production Trouble Ticket to analyze root cause of problems and resolved with team.
• Involved in production support testing assisted team in staging testing, support in change control request.
• Involved in different major and minor release testing by updating test plan with testing methodology, reviewed test results and analyzed defects and resolved with team.
• Experience with testing Quality Center and Toad for defect tracking and database use.
• Ability to multi-task effectively, Excellent verbal and written communication skills and attention to fine details.

Environment: Informatica 8.6, Oracle 10g, HP Quality Center 10, Teradata 12.0, Cognos 8.4 BI Series, UNIX

Database Tester

Responsibilities:

• Monitored the Database for duplicate records.
• Merged the duplicate records and ensure that the information is associated with company records.
• Standardized company names, addresses, and ensure that necessary data fields are populated.
• Reviewed the database proactively to identify inconsistencies in the data, conduct research using internal and external sources to determine information is accurate.
• Resolved the data issues by following up with the end user.
• Coordinated activities and workflow with other Data Stewards in the firm to ensure data changes are done effectively and efficiently
• Reviewed the database to identify and recommend adjustments and enhancements, including external systems and types of data that could add value to the system.
• Extracted the data from database and provide data analysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to report data in the format requested
• Used VBA for excel to automate the data entry forms to help standardize data.
• Assist CRM Analyst with Email Marketing Campaigns, including Client Publications, Newsletters, and announcements.
• Assisted other Data Stewards with Data Change Management (DCM) Inbox in resolving various tickets created by the User Change Request in Inter Action Database.
• Developed and Created Logical and Physical Database Architecture using ERWIN.
• Designed STAR Schemas for the detailed Data Marts and plan Data Marts involving Shared Dimensions.
• Conducted Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Wrote T-SQL Scripts to manipulate data for data loads and extracts.
• Used SSIS to extract, transform, and load data from transaction systems.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Implemented Slow Changing Dimensions (SCD) type 2 to maintain historical data.
• Utilized several Transformations like Lookup, Aggregate, Conditional Split, and Derived Column for implementing the Transformation Logic in the Packages.
• Created Stored Procedures, Tables, Functions, and Triggers in SQL Server 2008.
• Analyzed the large datasets to draw key marketing insights from the dataset results.
• Assisted BI Developers to fetch reports using SSRS.
• Assisted with end user training.

Environment: MS Office, VBA Excel, Access, SSRS SQL Server 2008, Oracle, Erwin 3.5, Windows 2000, TOAD 7.

ETL Tester

Responsibilities:

• Involved in analyzing the existing system process.
• Designed and created Documentation for the proposed system by creating Technical documentation, mapping documents, Functional Documents.
• Enhanced the Legacy Technical Specifications to meet the Enhanced System specs.
• Designed and maintained logical and physical enterprise data warehouse schemas.
• Worked on Star schema loaded data using Fact Tables (Rebate Utilization, AMP Utilization Table, to the staging tables (I calculate).
• As testing all data issues used SQL scripts to get issues resolved.
• Created naming conventions and system standards for lookup (Connected and unconnected) transformation and target tables.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Worked on issues with migration from development to testing.
• Prepared test data to validate ETL rules wherever necessary.
• Extensively used ETL and Informatica to load data from flat files (Price Group, Balancing File, etc.) MS Access and MS SQL Server 2005.
• Used Informatica Workflow Monitor to monitor workflows and review session log.
• Designed, developed and deployed new Data Marts along with modifying existing support additional business requirements
• Worked on Source Analyzer, Power Center designer, Workflow manager, Mapping Designer.
• Loaded data from source tables (Contract Pharmacy, Pharmacy Name, Pharmacies (vw), Provider XRef (vw)) to the target table named Pharmacy Name.
• Performed Regression Testing as and when the Bugs got fixed and check whether the application is free from builds.
• Wrote test plans to in corporate the testing needs of the data warehouse using Test Director.
• Wrote test cases for the data extracts to make sure the vendors are sending the correct data files.
• Maintained Source definitions, Transformation rules and Target definitions.
• Improved Performance for complex jobs by using Transformations Source Qualifier, Aggregator.
• Involved in developing and maintaining Modeling standards, Operation procedures and new development areas.
• Implemented Scheduled jobs in UNIX Environment and EDW scheduler.
• Worked on testing with Complex Mappings by importing Procedures/functions to build business rules to load data.
• As a testing process created Database scripts, Procedures, Database Constraints.
• Designed developed and tested processes for validating and conditioning data and maintained test documents (UAT), System Testing and integration Testing.
• Tuned was implemented as a part of the ETL testing with use of hints, parallel hints.
• Translated business-reporting (OLTP REPORTS) requirements into Data Warehouse Architectural design.
• Performed Performance tuning and solved data quality issues raised in loading the data form Source to Target.

Environment: Informatica Power center 8.1/8.6.0,Oracle 10g, SQL, PL/SQL, MS SQL Server 2005, MY SQL, MS Access 2003, UNIX, TOAD

Data Warehouse Tester

Responsibilities:

• Developed and documented data Mappings/Transformations and Informatica sessions as per the business requirement
• Involved in the development of Informatica Mappings and also tuned them for better performance
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed
• Initiated and developed new techniques to improve the testing process and improve the performance of the test scripts
• Executed Workflows in the Test Environment in order to load the data from the source systems to the WH
• Wrote test scripts to test the Policy Dimensions and Facts for counting the records in the source and WH tables Type 1 and Type 2 changes in the WH tables.
• Developed and executed Counts Type 1 and Type 2 test scripts to test Coverage Reserve and At Fault Dimensions under Claims
• Developed test cases and scripts for GUI testing functionality testing interface testing and regression testing.
• Exported Manual Test Cases from MS Excel template directly to Mercury Test Director and executed all the Test Cases in Test Director with Pass/Fail/Blocked status
• Wrote T-SQL test scripts for validating the data in the target database
• Analyzed and developed the Accounting Date scripts which were used by the Unit Coverage Fact in the Warehouse
• Worked closely with the Business Analysts Systems Analysts Developers and DBAs to solve the issues identified during the testing process in a timely manner
• Updated the status of the testing to the QA team and accomplished tasked for the assigned work to the Project Management team regularly
• Performed Regression testing of the fixed issues in the new build until no new issues are identified
• Managed Change Management and Version control of the scripts bugs and documents during the testing phase of the project
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log
• Submitted Final Test Report and required documentation for the project within the assigned time frame

Environment: Crystal Mercury Test Director, Informatica Power Center 7.1, HTML, DB2, SQL Server 2000, UNIX, Windows XP/NT/2000,SQLEnterpriseManager, Query Analyzer Control Center, Microsoft Office Suite, Microsoft Outlook