SUMMARY

• 7+ years of total IT experience and very good noledge in QA of Software Applications and Testing.
• Solid experience in testing of data warehouse / data marts for business applications with Banking and Financial domains.
• Adept in writing/reviewing/executing Test scenarios, Functional/Integration/Regression/UAT Test cases, analysing bugs, interacting with team members in fixing errors.
• Strong analytical skills which halps quickly and efficiently translate business requirements into test scenarios and test cases.
• Extensive 5 years of QA experience in Data Warehousing technology in building and managing various data warehouse / data marts.
• Experience in using RDBMS systems such as MS SQL Server, Oracle, MySQL, Netezza, MS Access.
• Excellent noledge of DB objects: Tables, Views, Stored Procedures, Indexes, Constraints, Synonyms, Sequences.
• Very strong in writing complex SQL queries using JOINs, UNION, EXCEPT, Subqueries, Aggregation functions, Case statements, wildcards etc.
• Expertise in Database Programming language (Stored Procedures, Triggers, Packages, PL/SQL).
• Extensive testing and supporting experience in data extraction, transformation and load processes in a corporate - wide-ETL framework.
• Expertise in working with Unix which includes File management, Process management, Checking log files, Shell scripts.
• Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess excellent Presentation.
• Interpersonal skills with a strong desire to achieve specified goals.
• Excellent written and verbal communication skills including experience in creation and presentation various reports and demo documents.
• Good communication and interpersonal skills, ability to build relationships and effectively communicate to peers, senior management, and end users.

TECHNICAL SKILLS:

Testing tools: C, C++, OOP, Java, and Visual Basic JIRA, Quality Center, HP ALM, MS EXCEL

Methodologies: Waterfall, Agile

Languages: VBScript, Perl, UNIX Shell Scripting

Operating systems: RDBMS

Web Technologies: UNIX, Linux and Windows XP, Solaris MS SQL, Oracle, MS MS SQL Server, Oracle, MySQL, MS Access, MS Visio HTML/DHTML, ASP, .NET, XML, Java Script, VB Script, AS400, Mulesoft

PROFESSIONAL EXPERIENCE:

Confidential - N ew Y ork, NY

Sr QA Engineer

Responsibilities:

• Analysed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Configured QA Environment for testing by deploying builds, Autosys task scheduler jobs, DB refresh, DB Schema changes, DML changes etc.
• Tested the data and data integrity among various sources and targets.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Performed extensive testing in migrating data from OLTP to Enterprise Data warehouse.
• Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.
• Written various Autosys JIL Scripts to activate the UNIX scripts in production me.e. JIL scripts for the Box and Command jobs.
• Written complex SQL queries for validating the data stored in different database tables.
• Helped the team in analysing the data to be able to identify the data quality issues.
• As a Test Lead involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.
• Involved in Database testing by writing & executing SQL & T-SQL queries using SSMS to validate that data is being populated in corresponding tables and manually comparing the results with front-end values.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing of the flow and the logic for the Data warehouse project.
• Monitored the data move process through Data Extract to Flat file
• Involved in writing the test cases and Test plans based on BRDs and BA Visio diagrams.
• Used various UNIX commands to create/copy/rename files, to stop/start services and to check log files.
• Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing. Also, manually tested the application for each system build, for both negative and positive testing.
• Communicated with the client for weekly status reports.
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Tested the ETL process for both before and after data load/normalization processes.
• Generated tractability Matrices to ensure that all the requirements are covered by the test cases.
• Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: SSIS, SQL, PL/SQL, Autosys, Unix Shell Scripting, MS SQL Server 2014, HP Quality Center 12, MQ Series, Microsoft Visio

Confidential - N ew Y ork, NY

ETL QA Analyst

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Involved in implementation of the Test plans, Test cases and Test Scripts.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Performed Schema comparison between the repository and test environment databases to make sure that the testing environments are up to date for testing.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing based on Use cases developed.
• Tested and troubleshooted the test results to verify that all data were synchronized and matched to expected results of the test cases.
• Testing and bug fixing of an embedded logging application written in Python.
• Provided Autosys expertise for batch processes running in the QA environment within the Enterprise Business Intelligence group.
• Experience with Autosys job scheduler including JIL scripting, virtual machines and Converted existing scheduled processes from Legacy to Autosys.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor.
• Performed root cause analysis on data quality on the questions raised by the UAT users related to Business Objects reports.
• Extensively used SSMS for analysing the data generated by ETL process using complex SQL queries.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• Tested the ETL data mapping and other ETL Processes (Data Warehouse Testing).
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Reviewed the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Involved in preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Worked on HP ALM and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Plan.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.

Environment: Ab Initio, SQL, T-SQL, SQL Server 2010/2012, Unix Shell Scripting, XML, XML Spy 2008, XSLT, HP ALM, Autosys, Tomcat Web Services, Tibco Grid Services

Confidential - Chicago, IL

ETL QA Analyst

ETL/Data/SQL Tester

Responsibilities:

• Gathered user requirements from each Business Units for test.
• Interacted with the Business users to identify the process metrics and various keys, dimensions and measures.
• Designed and developed Test Plans and Test Cases and executed them.
• Involved in implementation of the Test plans, Test cases and Test scripts.
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Organized sessions in a batch, to run the sessions in a batch in sequential order or start them concurrently by the server.
• Initial testing was conducted manually, and later phase was executed using Mercury Tools
• Conducted the Functional, System, Regression, and Performance testing of the Web application using Mercury tools Quick Test Pro and LoadRunner.
• Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Designed process performance loading strategies. And also wrote the optimizing techniques to improve the process loading time within the streamline using Server Manager to load the data into the Target Database.
• Involved in writing Test cases and Test plans which are managed and controlled using HP Test Director. Also used HP Test Director to manage and track defects.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing and Performance Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Created and published Impromptu/Report Net reports.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Used Query Studio to test ad hoc reports.
• Involved in Unit Testing of all reports and packages.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Developed complex queries using different data providers in the same report.

Environment: Informatica Power Center 8, Oracle, SQL, PL/SQL, Netezza 4.6, UNIX Shell Scripting, XML, TOAD, HP Quality Center, Report Net, Framework Manager, Report Net 1.1