PROFESSIONAL SUMMARY:

• Extensive experience in ETL testing which includes Oracle, SQL Server, Teradata and Datastage, Salesforce, ESP.
• POC working knowledge of using Big data components HIVE and HADOOP.
• Excellent working knowledge in Test Plan, Test Strategy, Test Requirements and Test Case Design from the Business Requirement Document and Technical Design Document. Preparation and Execution of Business scenarios and Test Cases.
• Proficient in writing complex SQL Queries based on the business logic using SQL developer, Toad and Teradata Studio
• Performed Functional Testing, Regression Testing, integration and End - End testing
• Sound knowledge and hands on in Agile and Waterfall methodologies
• Proficient knowledge in triggering ETL Jobs using UNIX commands.
• Hands on experience in using WinScp to place the files between various locations.
• Experience on Autosys for job monitor and verify the logs
• Hands on experience in Defect management tools such as HP Quality center
• Experience in version controlling of developed code in Clearcase.
• Coordination with multiple project stakeholders which includes Design review meetings, Defect meetings, Test case/results reviews, Daily/Weekly status reporting
• Experience in handling Onshore/Offshore team across a global model which includes leading offshore testing team from client location in USA.
• Ownership in Automating data validation tools for improved ROI and increased productivity
• Experience in preparation of Test metrics and Test Artifacts
• Active member of Production release activities.
• Experience in BNFS with Capital Market domain with fortune 100 clients
• Self-starter with Effective communication skills, Team player and excellent grasp of fundamentals combined with attention to detail and business process improvements with Quality and standards

TECHNICAL SKILLS:

ETL Tools: ETL Tool, UFT

Automation Tools: Datastage, ESP, Data Loader, Salesforce Sandbox

Defect Management: HP Quality Center 12.0

Operating System: MS-Windows, Unix

Technologies: SQL, Java, Salesforce, HQL, Jasper, VB scripting.

Database: Oracle, SQL server, Hive,Workflow Tools

SQL Tools: Putty, WinSCP3, MS-Project, MS-Excel, MS-PowerPoint, MS-Word,Toad, SQL developer, Squirrel, Hive CLI

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Force starting jobs through Autosys using Unix and monitoring their status.
• Checking logs whenever job fails in Unix server.
• Analyzing root cause of the job failure and reporting the same to developers.
• Responsible for code promotion from lower environment to higher environment.
• Prepare Test Requirements document for the requirements planned for the release and conduct the Test case walkthrough with the technical team consisting of Solution Architects, Product Owner and Developers
• Preparation of test strategy and effort estimation
• Responsible for maintaining Test Artifacts in a shared location as well as in QC.
• Preparation of Test Cases and execution of them.
• Proficient with complex SQL commands to prepare the appropriate Test Data and condition them based on the business requirement.
• Responsible for End-to-End testing
• Responsible for Release activities such as QA signoffs, PO Signoffs and Test Plan Signoff for every release.
• Co-ordinate with off-shore testing team by delegating tasks to the team and track the progress on a daily basis
• Preparation of Daily and Weekly status reports and Monthly metrics.

Skills/Tools: HP Quality Center, ESP UI, Toad, Excel Macro, Squirrel, Hive

Environment: Windows, Unix

Confidential

Responsibilities:

• Prepare Test Requirements document for the requirements planned for the release and conduct the Test case walkthrough with the technical team consisting of Solution Architects, System Analyst and Developer
• Preparation of test cases based on requirements provided.
• Review of the Test Cases/ Test execution results
• Force starting jobs through Autosys using Unix and monitoring their status.
• Trigger and monitor ETL jobs and check for logs
• Proficient with SQL commands to prepare the appropriate Test Data and condition them based on the business requirement.
• Maintaining the Test artifacts for auditing.
• Validation of transformation logics from source against target.
• Responsible for End-to-End testing
• Preparation of Daily and Weekly status reports
• Defect tracking using QC and assigned it to responsible person.
• Placing files between different servers using winscp

Skills/Tools: HP Quality Center, Datastage, SQL Developer, ETL Tool, Excel Macro, winscp

Environment: Windows, Unix

Confidential

Responsibilities:

• Gathering and understanding requirements
• Preparation of test cases based on requirements provided.
• Breakdown the scenarios into tasks and manage these tasks and ensure on-time closure and timely delivery.
• Execution of QA activities as per Master Test Plan
• Preparation of test strategy and effort estimation
• Trigger and monitor ETL jobs and check for logs
• Accountable for the walk through of the test requirement to business at client site.
• Co-ordinate with other functional teams for End-to-End testing
• Conduct daily Defect tracking meeting listed in QC with other functional teams and project stake holders
• Circulate Daily and Weekly status reports
• Provide Sign-Off before each release Go-Live
• Represent the entire QA team from offshore for status meeting conducted by Senior Management
• Metrics collection and management

Skills/Tools: Salesforce sandbox, Datastage, Teradata, HP Quality Center 10,Data modeler, ETL Automation Tool

Environment: Windows,Salesforce

Confidential

Responsibilities:

• Gathering and understanding requirements from the onsite coordinator.
• Developing the code based on core java
• Experience working with ClearCase for Version controlling
• Preparing the SQL scripts, Test Cases and uploading the Test execution results in QC.
• Validated the data movement and transformations are done correctly
• Supported business team for writing the testcases in BUAT environment.
• Prepared status summary reports with details of executed, passed and failed test case
• Participated in regular project status meetings for daily status.
• Coordinating between onsite and offshore and attending Daily Status Calls as SPOC from offshore
• Analyzing root cause of the job failure and reporting the same to developers.
• Responsible for code promotion from lower environment to higher environment.
• Involved in manual, negative, positive, system, functionality, integration, regression, back end testing during the various phases of the application.

Skills/Tools: Core Java, Clear case, SQL, SQL developer

Environment: Windows, Unix

Confidential

Responsibilities:

• Prepare Test Requirements document for the requirements planned for the release and conduct the Test case walkthrough with the technical team consisting of Solution Architects, System Analyst and Developer
• Preparation of test cases based on requirements provided.
• Review of the Test Cases/ Test execution results
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Validating the direct logics of data
• Responsible for preparing data aginst the requirement document and hence uploading the same for extracting the report
• Reviewing the defects with offshore lead and sending them to development team for further process.
• Once defects are fixed, re-uploading the files into URL and extracting the output.
• Responsible for validating the exact data match between various files such as xml, excel and txt files received.
• Logging the identified defects into QC for further processing.
• Calculation of capital amount and aggregating the same calculations in the source file.
• Inserting dummy data into SQL tables for failing the report and incorrect validations are recorded

Skills/Tools: HP Quality Center, Excel Macro, Excel 2013,XML, Txt compare

Environment: Windows, Unix