SUMMARY:

• Over 6 years of experience in Quality Assurance Testing and application testing.
• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications.
• Good idea of data and testing with working knowledge of Finance, Banking and Healthcare domains.
• Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models.
• Analyzed business requirements, detailed scope and deliverables for testing.
• Good Understanding and Knowledge with Agile methodologies and waterfall environments.
• Strong experience in writing Test Plans, Test Conditions, Defining Test Cases, Developing and maintaining Test Scripts, analyzing the results of scripts, interaction with team members in fixing the errors.
• Experience in validating Web services using SOAP UI.
• Extensive working experience on Integration Testing, Functional Testing, GUI Testing, Performance Testing, Regression Testing, System Testing, Database Testing.
• Involved in stages of Test Analysis and User Acceptance Testing.
• Provided Efforts, Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.
• Strong experience in using Quality Center and Test Director for Requirement Management, Test Planning, Test Case development, Test Case execution and Defect Tracking.
• Experienced in Database Testing using SQL queries on RDBMS databases like SQL Server and Oracle.
• Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situation at all levels.

TECHNICAL SKILLS:

ETL TOOLS: Informatica 9.0/8.6, SSIS

Databases: Oracle 11g/10g/9i, MS SQL SERVER (2012/2008 R2)

Languages: SQL, PL/SQL

Tools: HP QC/ALM, TOAD, SQL Loader, Autosys, Control-M

PROFESSIONAL EXPERIENCE:

QA Analyst

Confidential, Charlotte, NC

Responsibilities:

• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client-Server applications.
• Verified GWM Channel Hub profile Client Channel Segment Code and re-calculated Master Profile Client Channel Segment Rollup Code.
• Verified EPI Alignment code reference table, Client Channel Segment Code reference table and Client Channel Segment Rollup Code reference table.
• Verified Client Segment Roll UP Codes for Combine. Implementedagile - ScrumMethodology for frequent changes to client requirements and following parallel development and testing.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Created various business scenarios for functional and regression testing.
• Used HP Quality Center to upload all test cases in Test plan and Test lab modules.
• Interacted with developers to resolve the bugs.
• Logged the defects in Quality Center.
• Used Control-M to test the batch interface jobs and their dependencies.
• Created test data based on the test scenarios and executed the test cases.
• Worked as Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Involved in Business analysis and requirements gathering.
• Develop 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.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Executed SQL queries using TOAD to query Oracle database. Prepared test strategy to validate Teradata reports against Oracle reports.
• Exported the Report data from Oracle and Teradata warehouse to Excel and validated using formulas.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle.
• Written complex SQL queries to validate the data.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Performing smoke test by running QTP scripts
• Wrote and executed complex SQL queries including JOINS to validate Back-end data.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Experience in creating UNIX scripts for file transfer and file manipulation.

Environment: Informatica 8.1, Oracle 9i/10g, Teradata, SQL, Quality Center, Control-M, QTP, Agile, XML, Clear Quest, Windows XP, MS SQL 2008, Unix

Sr. QA ANALYST/TESTER

Confidential

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Used HP Quality Center to upload all test cases in Test plan and Test lab modules.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications.
• Designed and executed the test cases on the application as per company standards and tracked the defects using HP Quality Center 10.
• Involved in Web Services Testing using SOAP UI.
• Automated the screen shots using an inbuilt recorder in the MS Dynamics AX 2009.
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Identified duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations.

Environment: Informatica 8.6, Crystal Reports 2011, SOAP UI, HP Quality Center/ALM, Teradata 12, TOAD, Oracle 10g, PL/SQL, J2EE, Confidential DB2, MS dynamics AX 2009, MS SharePoint 2007.

QA TEST analyst

Confidential

Responsibilities:

• Understanding the Business requirements, and STT (Source TO Target) Documents
• Review & Analysing the requirements and STTs
• Writing and reviewing Test Scripts and Test Cases.
• Executed all test cases and loaded the test results in Quality Center.
• Verified column mapping between source and target tables
• Testing the initial data load containing previous years records
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status.

Environment: Informatica 8.6, HP Quality Center, TOAD, Oracle 10g

ETL QA TESTER

Confidential, Bloomington, MN

Responsibilities:

• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Participated in meetings with Business Analyst and Design Review meetings with the Developers for better understanding of the modules
• Prepared test plan, strategies and estimations
• Written various UNIX SHELL SCRIPTS for file manipulation, data parsing, text processing, job scheduling and cleanup needs.
• Source to target requirements, etl map specifications and business requirements were referred to write precise test cases
• Conducted walkthroughs with business and development team to get the approval of the test cases.
• Performed smoke test to make sure all the test environment is set and executed the test cases in Quality Center.
• Used Quality Center to log the defect and follow the complete defect cycle
• Conducted status meetings with Development Team and QA Team to discuss and resolve the issues reported in Quality Center.
• Used Control-M to test the batch interface jobs and their dependencies.
• Involved in developing, debugging and executing Unix Shell scripts.
• Performed regression testing of the application once the defect is fixed.
• Performed negative testing on the different modules of the application
• Wrote and executed test scripts and test cases for different source to staging, staging to accredited and accredited to data warehouse data flows.
• Participated in Functional and Design Review meetings of conversion components
• Participated in meetings on peer review of test cases on conversion components mentioned above and secured sign off on them before conversion test execution.
• Tested the above components by running the Ab Initio ETL jobs in UNIX box, verified and validated the requirements as per Functional and Design specs.