SUMMARY

• 9+years of experience as Software Quality Assurance (QA) in different environments and platforms including Automation testing Data Warehousing, Manual testing, Client/Server and Web based applications.
• Experience in Data Warehouse applications testing using Informatica on multiple platforms.
• Experience in different domains like Banking, healthcare and Ecommerce
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Proficient in different Databases like Oracle, SQL Server.
• Good experience in Business Objects, Cognos, Micro strategy Reports testing
• Involved in all phases of the STLC, with timely delivery against aggressive deadlines
• Extensive experience in writing SQL Queries to validate the databases systems and for backend database testing.
• Experience on Working with Automation tools like Selenium
• Experience in testing tools like HP ALM/Quality Center and Jira.
• Experience in working with different sources like flat files, excel, XML database
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in corporate - wide-ETL solutions using Informatica and DataStage.
• Solid experience in manual testing, Black box testing techniques.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Performed Manual Testing on Client-Server and Web-based Applications.
• Experience in Webservice testing Using SOAP UI
• Extensive experience in drafting Test Flows, Test Plans, Test Strategies, Test Scenarios, TestScripts, Test Specifications, Test Summaries, Test Procedures
• Extensive experience in writing Test cases & Test Status Reports.
• End to End responsibility to close the defects and fixes.

TECHNICAL SKILLS

Databases: Oracle 11g/10g, SQL Server, Teradata 14

Programming: SQL, PL/SQL

Testing Tools: HP ALM 11.0, JIRA 7.5

ETL Tools: Informatica 10.2/10/9.5, DataStage 8.7/8.1, SSIS 2012

Operating System: Microsoft Windows, UNIX, LINUX

Reporting tools: Cognos, MicroStrategy 10.11

Automation tool: Selenium

PROFESSIONAL EXPERIENCE

Sr.test Engineer

Confidential

Responsibilities:

• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Working with different types of sources like Dat files,text files,Excel,oracle and Sql Servers
• Coordinating with multiple teams to garther source files and cordiante with devlopment team to run the required jobs
• Built Automation script for data validation
• Responsible for planning and directing Quality Assurance
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using HP ALM based on the Functional Specifications.
• Executed Test Cases using positive and negative data in HP ALM Test Lab and reported results and defects using HP ALM ‘s Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Involved in identifying the defects and developed Defect Tracking report using HP Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: HP ALM 11.0, Informatica Power Center 10.0,MS Excel, Oracle 11g, SQL, PL/SQL, SQL Server, SOAP UI, TOAD, UNIX, Windows, MicroStrategy 10.11,Selenium

Sr.test Engineer

Confidential

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Responsible for planning and directing Quality Assurance
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using HP ALM based on the Functional Specifications.
• Executed Test Cases using positive and negative data in HP ALM Test Lab and reported results and defects using HP ALM ‘s Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using HP Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: HP ALM 11.0, Informatica Power Center 10.0,MS Excel, Oracle 11g, SQL, PL/SQL, SQL Server, SOAP UI, TOAD, UNIX, Windows, MicroStrategy 10.11

Sr.test Engineer

Confidential

Responsibilities:

• Analyze the Business Requirements and closely work with the Business Team to get the clarifications addressed
• Run Defect Triaging and Review the Test Scenarios/ Test Cases with Business Review Business requirement for different Specialty center modules and provide Test estimation to project management
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Developed Test Cases for Deployment Verification, ETL Data Validation and Report testing, front end user interface testing.
• Created Test Scripts in SOAP UI and Restful for Testing Web Services
• Planning for Test Execution activities to accomplish tasks on daily/weekly basis
• Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
• Worked with end users to generate UAT scripts and to successful completion of UAT testing
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Performed browser compatibility testing, performed front end web application testing and verified and validated defects using SQL to retrieve data from database.
• Tested ETL mappings that transfer data from Oracle source systems to the Data Mart
• Working experience on daily status reporting & managed end to end testing

Environment: ETL Informatica 9.5, Oracle 11g, SQL, PL/SQL, MS Office Suite, HP ALM 11.0,Jira, Unix, Windows, Cognos

ETL Tester

Confidential

Responsibilities:

• Interacted with Business Analysts, Developers and support team to define the testing requirement documents along with the QA Manager and mentored the QA Team accordingly.
• Drafted the Test Plan document and presented to IT and Business group for Sign Off.
• Escalation for unresolved bugs to the concerned developers and module leaders.
• Used Unix Commands to access and trouble shoot Errors by accessing the Error Log files.
• Participated in Design Phase, together with members of the Product team, developers, and DBAs.
• Performed Smoke, System testing, system Integration Testing, User acceptance, Database & Regression testing.
• Prepared Test cases, procedures, Bug Tracking, Logging and reporting bugs using Quality center
• Expert with Test documentation, such as Test Cases, Bug Reports, Use Cases etc.
• Designed various test Cases with different test conditions.
• Prepared and executed scenarios for the Regression testing on new builds.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
• Develop test cases and executed in HP QC
• Involved in creating test plan to test the ETL system thoroughly.
• Extensively interacted with developers to analyze & resolve issues that were encountered while testing application.
• Executed Test Cases using positive and negative data in HP ALM Test Lab and reported results and defects using HP‘QCs Defects tool.

Environment: Data Stage 8, Oracle 11g, SQL, PL/SQL, MS Office Suite, HP QC 10, Unix, Windows, Cognos,TOAD,SQL developer