SUMMARY

• 6+ years of experience in the fields of Information Technology, Cable and Advertising, Financial, Aeronautical focusing on Quality Assurance and Testing.
• Expert in writing SQL queries and experienced in testing Functional, ETL and BI applications.
• Experience in Software Development Life Cycle (SDLC) using Waterfall Model, Rational Unified Process (RUP) with a good understanding of Agile Methodology.
• Data Analysis: Experience in Data Analysis involving Data Cleansing, Data Conversions, Data Transformation, Data Quality Analysis, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Excellent analytical skills in understanding business process and functionality requirements while translating them into system specifications
• Extensive experience in IT industry in testing client server and web based applications
• Creating Use cases and Activity diagrams using UML tools and Microsoft Visio.
• Familiar with Data flow diagrams, Work flow diagrams and Process flow diagrams.
• Worked with the development team to ensure testing issues were resolved.
• Performed backend data testing using PL/SQL scripts to check the data consistency, data integrity in the application and database as data was fetched from different database tables.
• Proficient in using any flavor of UNIX operating system by writing various UNIX commands.
• Extensive experience in performing data mart and data validation testing for data migration
• Perform bug tracking and Reporting using Quality Center.
• Experience in working with Analysts, Managers and Developers during the software development life cycle (SDLC).
• Extensive experience of Data Integration between various systems, sources, and databases. Experience in implementation of ETL methodology in Data Extraction, Transformation and Loading using Informatica.
• Proficient in Data warehousing and business intelligence concepts, design principles, and software architecture.
• Experience in Unit Testing, Integration testing, System Testing (Functionality and Regression), Performance testing and User Acceptance Testing.
• Strong experience in working with HP/ALM, Quality Center and QTP.
• Strong working knowledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Experienced in GAP Analysis, Cost Benefit Analysis, organizing, facilitating and coordinating JAD sessions, weekly meetings, conference calls and other regular project meetings.
• Valuable experience in coordinating with off shore resources and vendor selection.
• Involved in the development of Test Plans, Test Cases and maintaining the Traceability and Test Matrix.
• Detail oriented with strong multitasking and interpersonal skills and ability to resolve problems.
• Motivated, self - starter, with exceptional team building and leadership skills.

TECHNICAL SKILLS

• HP Test Director
• HP Quality Center
• Rational Clear Quest
• JIRA
• SQL
• PL/SQL
• SQL Developer
• DB Visualizer
• SQLDX
• Squirrel
• Oracle 11g/10g/9i
• Hadoop Hive
• SQL Server
• HP Vertica
• Informatica Business Objects
• Microstrategy
• Tableau

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Sr.QA Analyst

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from Hadoop Hive system to the target Market Data warehouse Oracle using complex SQL queries.
• Tested the entire compliance reports generated using Tableau BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Performed data validation on the flat files that were generated in UNIX and Hadoop environment using UNIX and Hadoop fs commands as necessary.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and co-ordinated with integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Participated in Sprint review meeting for Web based applications and involved in Sprint planning meetings.
• Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Defect logging, assignment and tracking through (MTM) Microsoft Test Manager.
• Worked on data migration in SQL server for one of the web based application where the historical data from CRM system was migrated to new system OMS database.
• Prepared test data to cover all the test scenarios.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
• Also used JIRA to update the project plan and daily progress including defects.

Environment: Informatica 9.1, SQL Server 2010, TFS, MTM, SQL developer for Oracle, HP Quality Center/ALM 10.0, XML, Hadoop Hive, Tableau BI tool, HP Vertica database, SQLDX for Hadoop hive, Squirrel client for Hadoop, DB visualizer for Vertica, JIRA

Confidential, West Chester, PA

ETL/BI.QA Analyst

Responsibilities:

• Prepare Test Strategy and detailed Test Plan for testing Global One - Client Server application and Enhance Custody - Web Based application emphasizing on the scope, approach and effort estimation
• Analyze the Business requirements to formulate design and, document Test Scenarios and Test Cases
• Construct and maintain Requirements Traceability Matrix
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Prepared PL/SQL scripts for executing backend queries and performing data analysis.
• Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Design and execute the test cases on the application as per company standards.
• Preventing occurrences of multiple runs by flagging processed dates.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations.
• Testing of multiple ECM Reports using SQL Queries on Toad
• Responsible for Database Migration from Oracle 9i to Oracle 10g
• Execute SQL queries to perform Backend testing to ensure data validation
• Performed extensive integration testing of the application to and from the UNIX and Mainframe systems
• Perform volume testing to monitor system s threshold for uploading and downloading transactions to and from the other downstream systems
• Conduct Regression testing on the system each time a new build comes through
• Overall responsibility for defect management - Defect logging, reporting, tracking, testing, closing etc using Rational Clear Quest
• Responsible for weekly status update meetings
• Mentor junior testers and provided one-on-one training on the application with emphasis on improvising the overall quality of software process
• Provide technical presentations and training workshops for end users

Environment: Toad, Informatica, SQL, PL/SQL, SQL Developer, MS-Office, Rational Clear Quest, HP Quality center, UNIX, Shell Scripting, Mainframe, Windows XP and Oracle

Confidential, New York

Test Engineer

Responsibilities:

• Prepare Test Strategy and detailed Test Plan for testing Global One - Client Server application and Enhance Custody - Web Based application emphasizing on the scope, approach and effort estimation
• Analyze the Business requirements to formulate design and, document Test Scenarios and Test Cases
• Construct and maintain Requirements Traceability Matrix
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Prepared PL/SQL scripts for executing backend queries and performing data analysis.
• Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Design and execute the test cases on the application as per company standards.
• Preventing occurrences of multiple runs by flagging processed dates.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations.
• Testing of multiple ECM Reports using SQL Queries on Toad
• Responsible for Database Migration from Oracle 9i to Oracle 10g
• Execute SQL queries to perform Backend testing to ensure data validation
• Performed extensive integration testing of the application to and from the UNIX and Mainframe systems
• Perform volume testing to monitor system s threshold for uploading and downloading transactions to and from the other downstream systems
• Conduct Regression testing on the system each time a new build comes through
• Overall responsibility for defect management - Defect logging, reporting, tracking, testing, closing etc using Rational Clear Quest
• Responsible for weekly status update meetings
• Mentor junior testers and provided one-on-one training on the application with emphasis on improvising the overall quality of software process
• Provide technical presentations and training workshops for end users

Environment: Toad, SQLServer, SQL Developer, MS-Office, Rational Clear Quest, UNIX, Shell scripting, Mainframe, Windows XP and Oracle