SUMMARY

• Over 6 years of total IT experience in a QA and ETL Testing.
• Very good at Network testing of switches, routers and Intelligent Network platforms
• Good experience in Test Management and client Coordination, mentoring new joiners and junior team members
• Good with Requirements gathering & Documentation, Data Analysis/Mappings and understanding Business Processes.
• Experience in use case diagrams, E - R Diagrams, Activity and state diagrams and documenting business requirements
• Good with performing gap analysis, co-ordination of meetings with clients and technical teams
• Design, develop, and execute test plans and test procedures supporting new software development.
• Write problem reports, provide test progress updates, and author test results summary reports and recommendations.
• Collaborate with software engineers to identify and resolve issues.
• Performed Unit, Integration and System Testing.
• Worked with Microsoft office tools including office 365, Team foundation Server, MS Visio, Outlook and One Drive.
• Worked with Financial Applications like Atlas Office, OLA, Activity Center
• Responsible for UAT project planning like creating testing scenario, test plans, and test scripts
• Deft in testing methodologies viz. BI - ETL Testing, Report Testing, Manual Testing and
• Proficiency in Test Processes and writing test plans, test cases, defect reporting, debugging and documentation
• Expert in Software Testing Methodologies, Agile process and Water models
• Good with discovering identifying troubled areas and suggest solutions.
• Good understanding of business intelligence concepts and concepts related to reporting tools such as SSRS
• Experience in writing complex SQL queries for data analysis and testing.
• Expertise in Impact Analysis for the requirements, identifying scope, estimating effort, designing test strategy for testing, project monitoring, co-ordination and follow-ups.
• Excellence in analysis of existing systems; risk and feasibility analysis for planned systems
• Good at performing RCA (Root Cause Analysis) for the post delivery/production issues by co-ordiniting between Clients & PSG (Production Support Group), Development teams.
• Setting up QA environment for QA testing.
• Good interaction with Business users supporting and training for UAT
• Handled Functional, Performance & Load Testing on Web Applications with QTP, Load Runner and Web Load
• Knowledge of Test Management Tools - Mercury Test Director 8.1, Mercury Quality Center 9.0 and Site Administration.
• Expertise in preparation of test data, analysis of test results, preparation of Traceability Matrix, Status reporting and preparing entry & exit criteria
• Strong trouble-shooting, multi-tasking, organizing and communication skills
• Excellence in Team work and capable of working independently.
• Excellent rapport with clients
• Good experience in Banking, insurance, pharmaceuticals domains
• Experience as a Team Analyst in team.
• Sound knowledge of QA process and Strategy giving attention to details.

TECHNICAL SKILLS

ETL Tools: Informatica9.x/ 8.6/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2, Teradata, MySQL

Languages: SQL, PL/SQL, XML

Tools: Toad, SQL Developer, Teradata SQL Assistant, SQL Plus,SSRS

Operating Systems: Windows 2003/2000, Linux

Testing Tools: HP Quality Center,ALM, Bugzilla, Rational Clear Quest,MS TFS, QTP, Selenium, MS SharePoint Server 2010, SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Confidential

QA/ETL Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering. Responsible for understanding the ETL data mapping document.
• Tested UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Prepared Test Plan for the project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Reported bugs and tracked defects using HP QC.
• Involved in extensive DATA validation by writing several complex SQL & PL/SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in data warehouse testing by checking ETL procedures. Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced and complex 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
• Tested several data migration application for security, data protection and data corruption during transfer
• Tested the ETL process for both before data validation and after data validation process.
• Tested with Front-end functionality for the entire application
• Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
• Tested the data load process using the Informatica ETL tool.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
• Worked with Data Conversion projects for testing data quality after migration.
• Used Teradata SQL Assistant for data retrieval and querying.
• Used MLOAD, FLOAD, and TPUMP & FAST EXPORT for initial and incremental loadings.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Validated documented user requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing. Validated business reporting requirements with internal and external customers.
• Used SQL for Querying the DB2 database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Validated the reports to make sure all the data is populated as per requirements.
• Tested several data validation graphs developed in Ab Initio environment.

Environment: ETL, Data Profiler, UNIX, Shell Scripting, Teradata 12.0, T-SQL, Teradata SQL Assistant, MLOAD, FLOAD, FEXPORT, TPUMP, SQL, PL/SQL, Quality Center, QTP, Oracle 10g, Cognos Series 8.0, Report Net, Impromptu, Report Studio, SQL Server 2005, Erwin 4.0, UNIX, Windows 2000, TOAD

Confidential

QA Analyst

Responsibilities:

• Tested the existing Reports with 100% accuracy
• Validated data in Target database according to business rules
• Executed very complex SQL queries to validate and verify data set per business rules. Working with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase.
• Identified bugs and defects, and reported them accurately using Microsoft Team Foundation Server 2013.
• Worked with UAT activities to ensure the applications and products and releases are according to the Quality Assurance standards.
• Handle the tasks of ensuring that the Pre-UAT activity is performed accurately and efficiently
• Responsible for UAT project planning like creating testing scenario, test plans, and test scripts
• Monitoring Informatica Workflows for ETL Process.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested the existing Reports with 100% accuracy
• Validated data in Target database according to business rules
• Executed very complex SQL queries to validate and verify data set per business rules. Working with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase.

Environment: Oracle 12c, Informatica 9.x, TOAD 8.0, UNIX, MS Office Suite 2013 including MS TFS, MS Visio, Office 365, Atlas Office, OLA2, Activity Center, SQL Server 2008, ALM, Quality Center, QTP, Cognos Series 8.0, Report Studio,, Erwin 4.0,, QTP, Selenium