SUMMARY:

• Over 7 years of IT experience in Quality Assurance and Software Testing of various business applications in Client Server, Data Warehousing solutions.
• Expertise in writing Test Plans, Test Procedures, Test cases, Test scripts, Defect status reports and Test Summary report.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center and ALM.
• Expert in writing complex SQL queries for back - end and Reports data validations.
• Adept on database query tools such as TOAD, SQL Navigator and SQL Plus and SQL Developer.
• Experienced in Functional testing, Regression testing, Smoke testing, Reports testing and data testing.
• Extensive work in ETL testing using SQL, UNIX, Pl/SQL.
• Tested both the i Confidential emental and history load for DW projects with both positive and negative data to reconcile the data.
• Knowledge on the phases of Agile methodology and traditional Waterfall methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

QA Methodologies: Agile - Scrum and Waterfall

QA Tools: HP - Quality Center/ALM

Databases: Oracle 11g, 10gMicrosoft MS Access, SQL Server 2005/2008, Teradata

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL Plus

ETL Tools: Informatica Power Center 9/8.x, SSIS

Programming Languages: SQL, XML

Operating Systems: Windows and Unix

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI.

QA Analyst

Responsibilities:

• Created Test Plan and developed a test suite for testing purpose.
• Extensively used T-SQL to verify and validate the data loaded to the MS SQL Server
• Extensively worked on documenting understanding document and testing metadata based on creating fact and dimension table implementation in Star Schema.
• Generated test data to support testing initiative.
• Tested pre-session, post-session routines and batch execution routines using Unix scripts.
• Tested stored procedures & views in MS SQL Server.
• Utilized HP ALM for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Worked with Data analyst for clarifications on for data loading for both dimensions and facts.
• Prepared extensive set of validation test cases to verify the data
• Strong ability in developing advanced 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
• Involved in Functional testing, End to End testing and Regression Testing
• Preparing and supporting the QA and UAT test environments

Environment: Informatica Power Center 9, HP ALM, XML, XSD, XML Spy, SQL, PL/SQL, Oracle 11g/10g, UNIX, Windows

Confidential, Marietta, GA

DW tester

Responsibilities:

• Extensively tested the extracting, transforming and loading databases from sources to target in Oracle,DB2 and Flat files.
• Collaborated with EDW team to understand the mapping document and the extract, transform, rules and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Tested various types of keys and slowly changing dimensions in star and snowflake schema.
• Tested Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
• Tested the extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Sort, Column generators, Funnel and Oracle Enterprise.
• Tested Batches (DS job controls) and Sequences to control set of jobs.
• Extensively tested Change Data Capture for DB2 and Oracle files and employed change capture stage in parallel jobs.
• Tested Pre and Post session commands on Source and Target database using Shell scripting.
• Collaborated the defects in HP Quality Center.
• Tested Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Collaborated with BI and BO teams to kick off the data tests for reports affected by a change to the corporate data model.
• Collaborated with BO teams in revalidating and escalating data defects in dashboards and scorecards for Analysis and Tracking of key business metrics and goals.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and documenting both immediate and long-term issues.

Environment: Data stage 8.1, HP QC 10, Flat Files, Oracle 10g, BO, UNIX, Windows

Confidential, Durham, NC

Data Validation Engineer

Responsibilities:

• Communicate with the Data Services Team (Business Analysts, Data Architects, Developers and SVT) to review and analyze the business requirements. Actively participated in Requirements and Functional Specification Reviews (FRS)
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Apply knowledge of data analytics and business intelligence models to interpret technical solutions being implemented and design test cases that address functional and regulatory requirements.
• Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements
• Assisted in creating the Test Strategies (TS) and methods and Test Plans (TP)
• Assisted the lead and the SVT manager in creating the MRVPs (Major/Minor Release Validation Pack) documents and participated in sign-off meetings
• Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing
• Actively involved in the go/no-go and deferred defect meetings
• Conducted end-to-end data validation of data flow between source, staging, ODS(Operational Data Store), and DM (Data Mart) layer
• Analyzed the EDW mapping documents, Dimension tables and fact tables
• Wrote SQL queries to do the column level verification of the Dimension and Fact tables
• Involved in testing the data warehouse for both the initial load and the i Confidential emental loads of the target
• Tested various ETL transformation rules based on log files, data movement and with help of SQL
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Prepared Test Cases based on business requirements and business rules Performed Positive and Negative Testing Manually. Created SQL statements to validate the data tables.
• Communicate with the team - status, issues and risks on a timely basis to mitigate and drive project issues to resolution. Assisted the team in executing the ETL workflows to its completion and monitor the results. Actively involved in the Defect Triage meeting between the Development team and the SVT (System Validation and Testing)
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
• Involved in the Informatica 9.1 up-gradation testing to make sure that the existing, updated and new workflows are working as expected when migrated to Informatica 9.1 from Informatica 8.6. Created and documented the test plan for the same.

Environment: Quality Center 9.0, Informatica 8.6, Oracle 9i, TOAD, SQL Developer, UNIX, Windows XP, Internet Explorer, SQL, TOP Team, JIRA, Analytix, OBIEE, SPOTFIRE, ETL

Confidential, Florida

ETL Tester

Responsibilities:

• Participated in the requirement gathering of the various work streams by meeting with the Business user, base lining the details and documentation.
• Reviewed business requirements and technical specifications.
• Interacted with Business Analysts to understand the functionality of the Application under test.
• Created and maintained test documentation and test plan. Involved in manual testing, writing test cases and test plan.
• Created and developed test cases to test the web application called e-shopping based on HTML, CSS, XML and JavaScript.
• Utilized advanced MS Excel and database design to create test cases in mapping process.
• Provided specifications and instructions for Operations team to build QA and stage environments.
• Extensive experience in writing test plan for using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Good experience in Integration Testing to verify the required functionality of mapping (Session) in the environment specific to testing team.
• Identified test cases to ensure that correct numbers of rows (validated records) are transferred to the target from the source.
• Monitored the Informatica workflows using Power Centre monitor. Checked session logs in case of aborted/failed sessions.
• Performed analysis based on the source systems and existing OLTP database systems.
• Identified and logged the defects in Quality Center. Participated in the Defect Review Meetings.
• Maintained and executed automated Test scripts using QTP 10 as per the requirement
• Researched and troubleshoot customer data during all phases of ETL, starting with load and processing issues involving extracts, file formats, character sets and form Confidential ing issues and other data gaps.
• Deployed new builds and maintained the QA Environment.
• Created test cases to test Web Application.
• Performed manual, functional testing, secure testing and regression testing.
• Reviewed the docs from the Dev team and reported the bugs in Team Track and BugZilla.
• Tested individual components in Windows and LINUX/UNIX environments and the integration of the backend JAVA Services with the front end.
• Organized bug review and task review to assign/ re-assign the tasks and their priorities meetings.

Environment: SQL Server 2005, MS Excel, Business Objects 3 XI R2, UNIX, JAVA, Apache, MySql, JIRA 3.13, Toad, Informatica 7.1, QC 9.0, HTML,CSS