SUMMARY:

• Having experience of 9+ years in ETL / DWH Testing, Database testing and Manual Testing.
• Worked on different roles as Sr. Test Analyst, Test lead for the ETL/Dataware Housing projects
• Expert in designing SQL queries for the ETL/DWH Projects and BI Reports
• Good knowledge of PL/SQL concepts, UNIX Shell scripting, DWH, Data Migration and Python
• Expertise in validating the Business Intelligence Dashboards/Reports,QlikView Reports, BO Universe.
• Basic knowledge of Big Data Hadoop eco system, Wrote SQL for tables validation in Hue.
• Good Testing Skills and expertise in preparing Test Strategy, Test Plan, Test scenarios, Test Case, Requirement Traceability Matrix, Efforts Estimation
• Worked on domains - Investment Banking, Banking/Finance, Health care and Telecom .
• Good knowledge on SDLC/STLC life cycle. Worked on Waterfall and Agile methodologies.
• Worked on all testing phases - Functional testing, System Integration testing, End to End Testing, Regression testing and Supporting UAT testing for the Business users.
• Experience in working for onsite-offshore model .Worked on multiple projects simultaneously.
• Adaptable for new Technologies, Quick to learn new tools & domains

TECHNICAL SKILLS:

Programming: SQL, PL/SQL, UNIX Shell Scripting, Python

Database : Oracle 10g, Teradata v13, SQL Server2012 and Big Data Impala

ETL Tools : Informatica 7.1,2, Talend

Reporting tools : Business Objects XI, QlikView

Utility Tools: Toad, PL/SQL Developer, SOAP, Putty, Autosys,Activebatch

Test Management Tools : HP Quality Center 12, JIRA, QTP UFT,Squash

Configuration Management Tools : VSS, CVS, SVN

Others: Intellimatch Reconciliation, Geneva

PROFESSIONAL EXPERIENCE:

Confidential

Senior Test Engineer

Responsibilities:

• Validating the new Dimension and Fact tables created and updated as part of the creation of ongoing Data warehousing creation
• Going through the mapping document and writing the source query for Dimensions & Facts
• Talend tool is used for Development of ETL to pull the data to Dimension & facts
• Validating the Business Objects created on top of DWH
• Validating the Business Objects Universe created for Ad Hoc Reports by writing SQL
• Validating the Files loaded on daily basis in Hadoop and the tables validation in Hue tables
• Working in Agile methodology, through Sprints. Attending the scrum meetings daily for status reporting and highlighting any issues
• Verifying the Incremental data validation(Type1) for dimensions by creating data in Source systems (Geneva, Security Master) and validating them in Dimension tables
• QA Tasks were created in JIRA and logging defects to Dev team in JIRA and track it till closure.
• Test Cases are created and executed in Squash tool.
• Providing the Test Summary Report for each sprint completion

Tools: & Technology: SQL Server 2012, Hue (Hadoop User Interface), ActiveBatch, Squash, Talend

Confidential

Senior Test Engineer

Responsibilities:

• Understanding the requirements and designing the test scenarios
• Test Scenarios walkthrough with the Business Analyst and Development teams and get Sign off on the Test Coverage
• Explain the functionalities to offshore team and assigning the tasks to the team to create the test cases
• Involved in planning the test efforts for all test cycles and highlighting the risks early in the test cycle.
• Involved in Test Execution and running the daily defect triage with BA and development team
• Test Scenarios preparation for the Integration testing with the systems involved -Netting Library, Netting Engine, IRIS, and Framesoft
• Flat files testing between the source and target systems
• Analyze the Automation requirements and Co-ordinate with Automation team and make sure the automation is done for the regression suite. Executing the QTP Scripts for Regression.
• Coordinating with Performance testing team and helping them on the functionalities of the application, coverage of the test scenarios and test data preparation
• Understanding the Technical Architecture between each system and preparing the test scenarios and executing end-to-end testing for the downstream testing xml files submitting to the Netting Engine and verifying the output xml generated. Batch testing of the xml input files

Tools: & Technology: Oracle 10g, Toad, UFT, SOAP, HP Quality Center 12, Control M

Confidential

Senior Test Engineer

Responsibilities:

• Understanding the requirements by going through FSD and Mapping Document and designing the test scenarios
• Test Scenarios walkthrough with the Business Analyst and Development teams and get Sign off on the Test Coverage
• Create the SQL Test scripts for the tables as per the mapping document
• Involved in Test Execution and coordinate with developers and offshore testing team
• Verifying the data in Staging tables and then Core tables as per the logic provided in mapping document
• Conducting the Functional Testing of the Data migrated to the Target system
• Reviewing the code written by offshore team and guide them in SQL scripts as per mapping logic.
• Logging the defects for the issues observed and conducting the defect triage with Development teams, BA
• Test Data creation in source system and verifying the delta load to the target system
• Supporting the UAT testing until the UAT sign off provided
• Run the Automation scripts for planned tests and verifying the results

Tools: & Technology: Oracle 10g, Toad, PL/SQL developer, Informatica, UFT, HP Quality Center 12

Confidential

Test Lead

Responsibilities:

• Understanding the requirements of the project, preparing the test plan, High level scenarios and get it reviewed from the business users
• Involved in the Test Strategy, Test Efforts Estimation for the Dashboard design and Execution
• Go through the Design specification and ETL mapping documents to understand the transformation logic for the Teradata objects and prepare the SQL scripts on Source and Target tables
• Create the test cases, Test Data, RTM and SQL scripts to validate QlikView Dashboards GUI and the data.
• Validating the ETL for the Teradata backend objects by executing the queries at Source and Target tables.
• Extensively used and developed SQL scripts, complex SQL queries in backend testing of Databases.
• Validating the Dashboards GUI and the data as per the customer requirements
• Assigning the tasks to the team members, track the status, Review the work in case of issues
• Log the defects in QC, Review the defects raised by QA team and tracking till closure
• Sending the daily status Report on the Execution status to the testing team and highlight the deviations
• Participate in regular project status meetings and QA status meetings highlight the risks
• Checks for schedule adherence to all milestones and assists the Test Manager in preparing final test report.

Tools: & Technology: Teradata 13, Oracle 10g, QlikView Reports, HP Quality Center 10

Confidential

Senior Test Engineer

Responsibilities:

• Business requirements understanding, Test case preparation, Test case execution, Test case review and Defect Tracking
• Executing the Intellimatch ETL jobs to load the data from the feed files to the DB and to front end application
• Run the ETL jobs and ensure no runtime errors in the ETL jobs to load the input files to the database
• GUI testing on Intellimatch to ensure the data is correctly loaded.
• Functional testing on the application such as reconciling the data by making adjustments to the breaks in cash, trade and positions
• Testing the Outbound reports based on reconciliation data which is required for regulatory purpose
• Support to the UAT team during UAT Testing
• Regression testing to ensure there is no change in functionality of the existing recs

Tools: & Technology: Intellimatch 9, Unix, Autosys, SQL Server 2005, HP Quality Center 10

Confidential

Senior Test Engineer

Responsibilities:

• Business requirement understanding, Test case preparation, Writing SQL scripts, Test case execution, Test case review, Defect Tracking
• Gained knowledge working on different asset classes like Futures, Options, Strategies that FnO supports from various vendor feeds like Reuters, Bloomberg, DML, GMI.
• Involved in Downstream testing support for Internal Systems like Confidential Classic, Confidential equities and EDS for sourcing the Cash Equities data for which FnO is the distribution hub. EDS intern sources Cash Equities data from Confidential Classic and Confidential Equities.
• Writing the SQL queries to verify the ETL for the mastering of the data and validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Extensive SQL querying on Source, Staging and Target tables to validate Data Completeness.
• Ensured Error logs and audit tables are generated and populated properly
• Performed testing for adoption projects related to Direct market link for new feed files like DML SFE- Sydney futures exchange, Tokyo stock exchange (Tdex)
• Maintaining of UAT environment and made sure downstream clients get the up to date data for their UAT testing before client signoff.
• Extensive testing ETL experience using Informatica 7.4 (Repository, Designer, Workflow Manager and Workflow Monitor)
• Worked on Informatica to promote the code between environments, Scheduling, running manually and monitoring the jobs
• Tracking and reporting the issues to project team and management during test cycles

Tools: & Technology: Informatcia 7.1.2, Unix, Autosys, Oracle 10g, HP Quality Center10, JIRA, Toad 9

Confidential

Test Engineer

Responsibilities:

• Understanding the Requirements and Designing the test scenarios for Debtor/creditor reports. Interacting with client in case of queries and during test case review
• Preparation and execution of the test cases and raising defects, defect tracking, Regression testing on the defects fixed
• Preparation of test data as per the system test and input the files through mainframe to be processed by the system
• Validating data at GUI, Database and Report level.

Tools: & Technology: Toad, SQL, HP Quality Center, and JIRA