SUMMARY:

• Over 10 Years of Software testing experience working in agile environment and good understanding of software development life cycle (SDLC, STLC) and agile model.
• Experience with different types of testing techniques and strategies i.e. black box testing, functional, system, regression, integration testing.
• Extensive experience in ETL (Ab Initio), Informatica, Initiate and web testing (.Net technology, HTML, C++ and Drupal).
• Experience being part of Center of Excellence for Data Validation testing with HP.
• Expertise with back - end testing and data validation.
• Experience working in Onsite offshore model.
• Experience working on databases: SQL, Teradata, DB2 and Oracle.
• Experience in requirement gathering/ analysis and creating system requirement specifications documents (SRS).
• Experience in designing test plan, creating test cases, executing test sets, and development in ASP.NET.
• Microsoft certified application developer
• Experience working on .Net technology, HTML, C++ and Drupal.
• Tested web application in waterfall and agile development processes.
• Estimated testing efforts with business analysts and offshore QA Testers.
• Good in team interaction and team management.
• Strong interpersonal and excellent communication skills.

TECHNICAL SKILLS:

Languages: C++, C#, .NET, ASP.NET, JavaScript

User Interface: HTML, CSS

Technologies: Microsoft Technologies .NET 1.1/2.0, Drupal

Test Automation Tool: HP ALM, Web EME,SOAP UI, Apache JMeter

ETL Tool: Ab: Initio, Informatica

Bug Tracking Tools: Bugzilla, JIRA

Software: Visual Studio, Rational Rose, Microsoft Office, Eclipse

Environment: Windows (XP, Vista, Windows 7), Unix

Databases: SQL Server 2005, Oracle 10g,Teradata,DB2

FTP: WinSCP, PUTTY

Version Control: SVN

Web/ Application Server: Apache Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, Windsor Mill, MD

Sr. ETL Test Engineer

Responsibilities:

• Planning and execution of test integration activities across multiple platforms/application.
• Providing /mentoring technical guidance to team members.
• Creating and implementing process, procedures, tools and templates related to software quality assurance.
• Performing ETL execution using tools such as Informatica and system testing the functionality.
• Developing ETL logic using Informatica 9.6 /10 mapping and workflows and monitored jobs using Informatica monitor
• Created ETL processes using Expression, Aggregator, Lookup, and Joiner Transformations.
• Perform Performance tuning of ETL processes.
• Provide LOE estimations to meet project deadlines.
• Creating quality assurance strategy, test plans and test beds to address end to end systems integration needs.
• Test data preparation based on ETL mapping logic as per system requirement document.
• Executing ETL workflow to load data into MDM
• Debug Informatica mappings to do root cause analysis
• Developing and performance tuning of complex SQL scripts/Stored Procedures to verify and validate data from source to target in DB2 environment.
• Create complex shell scripts to validate data and automate test scenarios.
• Preparing Requirement Trace-ability Matrix (RTM).
• Working on HP Application life cycle management database to Customize ALM reports.
• Executing test cases based on system requirements and business requirements.
• Proposing solutions to address software quality assurance standards and best practices.
• Execute validation scenarios to verify the ETL transformations.
• Reporting and tracking defects using JIRA.
• Reviewing the defects, test case and test plan documents with the clients.
• Closely work with developer to prioritize the issues to resolve and test.
• Performing Data services testing using SOAP UI.
• Performing XML Schema validation against XSD, and data validation.
• Validate extract files using Mainframes.
• Developed SQL, VB, shell scripts to automate data validation using JMeter tool for Web Services and database.
• Parameterized SQL scripts using JMeter for data validation.
• Automate performance testing via JMeter for web services.
• Perform restful web services testing.
• Submit JCL jobs to perform reorg and run stats on Mainframes.
• Identifying gaps within MDM in all areas (development, testing, data Analytics etc.) and proposing to the client to implement the changes needed.
• Performing system testing, smoke testing, regression testing and performance testing for the given requirements.
• Worked in Agile methodology and participated in spring planning and backlog grooming sessions to provide story points and prioritize the tasks.
• Conducting Scrum meeting and updating status on JIRA Board.

Environment: Windows XP/ UNIX/LINUX JIRA, HP- Application life cycle management (ALM), Informatica 9.6/10, IBM Initiate, Apache JMeter, SOAP UI,IBM DB2 v4.1.1, tortoise SVN

Confidential - McLean, VA

ETL Tester

Responsibilities:

• Gathering requirements from clients.
• Provide LOE estimations to meet project deadlines.
• Create and Review test cases with Tech lead and clients.
• Developing and reviewing test scripts in DB2 including CLP scripting for multiple database validation.
• Mock test data based on ETL mapping logics as per system requirement document.
• Developing and performance tuning of complex SQL scripts/Stored Procedures to verify and validate data from source to target in DB2 environment.
• Automated data validation using SQL script via QTP.
• Executing data stage sequences to load data into MDM.
• Debug parallel jobs to do root cause analysis.
• Create complex shell scripts to validate data and automate test scenarios.
• Preparing Requirement Traceability Matrix (RTM).
• Create and execute test cases based on system requirements and business requirements.
• Perform manual testing on web-based application.
• Performing system testing, smoke testing, regression testing and performance testing for the given requirements.
• Execute validation scenarios to verify the ETL transformations.
• Reporting and tracking defects using QC tool.
• Maintaining test repository using Quality Center tool.
• Reviewing the defects, test case and test plan documents with the clients.
• Closely work with developer to prioritize the issues to resolve and test.
• Worked as QC Admin and developed SQL and VB scripts to fetch defect report, Test Case summary and Test result reports from HP ALM.

Environment: DB2, Windows XP/ UNIX, Doors, Quality Center 10.0, WINSCP

Confidential - Richmond. VA

Associate Data Warehouse Test Analyst

Responsibilities:

• Create and Review Business Assurance Strategy and test cases with Tech lead and clients.
• Managing onsite offshore delivery.
• Mock test data based on ETL mapping logics as per source to target mapping document
• Preparing the SQL scripts to verify and validating data from source to target in Teradata environment.
• Create Test plan with respect to the requirements
• Preparing Requirement traceability matrix (RTM)
• Create and execute test cases for staging, distribution and load ready jobs based on the requirements on QC.
• Testing Ab Initio graphs in UNIX environment.
• Performing system testing, smoke testing for the given requirements in Ab Initio.
• Execute validation scenarios to verify the ETL transformations.
• Reporting and tracking defects using QC tool
• Maintaining test repository using Quality Center tool.
• Providing training to offshore testing team
• Involved in sprint planning and backlog grooming sessions.

Environment: Teradata 13.0, Windows XP/ UNIX/ Linux and SSH Secure Shell, Ab Initio, Web EME, Quality Center 10.0

Confidential - Charlotte, NC

Software tester

Responsibilities:

• Performed system and integration testing for Model View Controller pattern.
• Test presentation layer (UI) developed using, Java Script & HTML
• Performing system testing and integration testing
• Performing QA checks biased on requirements
• Create Test plan based on requirements
• Create and execute test cases for JAVA based web application
• Defect tracking and reporting
• Creating requirement traceability matrix (RTM)

Environment: JAVA, SQL Server 2005, Eclipse, Java, Windows XP, SSRS, Eclipse, Quality Center 9.2

Confidential - Charlotte, NC

Developer/Tester

Responsibilities:

• Requirement gathering and analysis
• Develop websites in Drupal technology
• Analyzed the requirements and created test plan and test cases
• Create and execute test cases for web-based application
• Performing system testing and integration testing
• Performing QA checks biased on university standards by executing scripts
• Review test cases and scripts for consistency to ensure all aspects of the application
• Used Bugzilla for bug tracking

Environment: Drupal, SQL, Windows XP.

Confidential

Software tester/ developer

Responsibilities:

• Worked as Test lead and involved in requirement gathering
• Assisted project lead to create test plan.
• Assisted team in setting up the test environment
• Prepared Risk Assurance strategy document
• Designed test cases and use case scenarios for the testing phase
• Performed quality analysis based on various company standards and practices.
• Performed System testing on web-based application Developed in .NET
• Used various testing techniques to provide accurate results
• Performing data validation check in target tables (SQL)
• Perform regression and negative testing methodologies
• Created logical design and table structures in SQL Server
• Designed 3-tier architecture using ASP.Net, C#.Net
• Developed presentation layer using HTML and CSS
• Reporting and tracking defects using QC tool
• Maintaining test repository using Quality Center tool.

Environment: C#.Net, MS SQL, Windows XP Professional, SQL Server 2005, Quality Center 9.0

Confidential

Software Developer & Tester

Responsibilities:

• Requirement gathering and analysis.
• Setting up QA environment.
• QA checks based on requirements.
• Create Test plan based on requirements
• Create and execute test cases for .Net based web and windows-based application on QC
• Performing system testing and integration testing.
• Defect tracking and reporting using QC tool
• Closely worked with developers and business analyst for bug reviews
• Providing Production support in QA environment
• Performing data validation check in target tables (SQL)
• Providing technical support for bug fixing and maintenance in SMS module
• Enhancements Analysis of the specifications provided by the clients for SMS Module

Environment: C#, Database: SQL server 2005, Rational Rose, Quality Center 8.0, Windows XP.