SUMMARY:

• Excellent 6+ years IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Data Warehouses using ETL & Business Intelligence solutions, UNIX, OLAP for Financial /Banking and Technology Industries.
• Expertise in implementation of automation framework using selenium, proficient in test automation using UFT and selenium tools
• Strong experience in java programing, seleniumweb driver, Junit and testing.
• Well versed with handling elements in selenium web driver.
• Defects were created, tracked, reviewed, analyzed, stored test data and compared using Quality Center.
• Performed Database testing
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Experience in Mobile Apps testing for mobile devices.
• Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in Data Analysis, Understanding in Dimensional Data Modelling, Data Extraction, Transformation & Loading (ETL), Cubes and End User Reports.
• Good Understanding on Star Schema Modelling, Snow - Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modelling.
• Exposure to multiple ETL tools including Data stage, Informatica, Ab Initio and SSIS.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Experienced in functional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing. .
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects XI, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards.
• Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Advanced user in using Test management tools like HP Quality Center/Test Director, JIRA.
• Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2008/2005/2000/7.0/6.5, IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• A good team player with excellent written and verbal communication skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9,8.5.1 (Designer, Workflow Manager, Workflow Monitor,) Abinitio GDE

OLAP Tools: IBM Cognos v9, SAP Business Objects 2010/2008/XIR2, MicroStrategy 8.0

Data Modelling: Erwin, Microsoft Visio, Rational Rose (UML), ER Studio

Operating Systems: Windows NT/2000/2003/XP, UNIX, Solaris and MSDOS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, DB2, MS Access, Teradata V2R5.

Testing Tools: Quality Center, Test Director, JIRA, HP Quality Center 9.0/9.2/10.0/ ALM, Doors, TFS, selenium, cucumber

Mobile Testing: Android, IOS

Languages: XML, SQL, PL/SQL, C,C++, VB, Java, HTML

PROFESSIONAL EXPERIENCE:

Confidential, CT

QA Engineer

Responsibilities:

• Designed test cases using selenium webdriver and testing.
• Involved in regression testing using selenium.
• Involment in automation environment setup using Eclipse, Java, Selenium webdriver Java.
• Defects were created, tracked, reviewed, analyzed, stored test data and compared using Quality Center.
• Performed Database testing.
• Worked on Chase QuickPay feature for mobile phones.
• Experience working in mobile testing platforms like Android and iOS
• Created Business Process Testing BPT test scripts using ALM
• Experience working with JIRA and Agile Methodologies
• Used log files and reported errors through various commands into defect tracking tool.
• Documented errors and implemented their resolutions.
• Tested Cognos Reports according to the business requirements.
• Wrote test plans for positive and negative scenarios for functional, GUI and security testing
• Involved in validating java interfaces for business applications.
• Responsible for creating test cases for End to End Testing.
• Batch Test Cases are Created to verify the data to be in sync in both database and online screen(CICS)
• Validated XML schema to validate data.
• Online Test cases are created to test the whole functionality of the online (CICS) screens.
• Executed all Conversion, Batch and Online Test cases to match with the expected results.
• Tested Database integrity testing by executing SQL statements on Oracle database.
• Participated in daily reviews and kick-off meeting.

Tool: used: Selenium and Su-tracker

Testing Approach: Manual and Automated

Environment: JAVA.,HTML, SQL, Cognos, ORACLE

Confidential, San Francisco, CA

System Quality Analyst

Responsibilities:

• Execution of selenium test caes and reporting defects.
• Involved in automation infrastructure development using selenium
• Involed in regression testing using selenium .
• Performed more complex analysis of business requirements and system specifications.
• Involved in Batch cycle testing for front end web application.
• Involved in writing complex SQL on Oracle 11g.
• Worked in Agile methodology and actively involved in multiple projects at a same time.
• Created test plans and scripts for own projects.
• Worked as a Lead on a project.
• Performed moderately complex to complex test data conditioning, regression testing, Ad-hoc testing and testing validation.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down reports.
• Provided specific guidance on defects to developers.
• Experience on ALM for creating test cases and QC for logging defects.
• Gave direction to less experienced Analyst.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports
• Logged, tracked and verified resolution of software and Specified defects.
• Demonstrated all phase of the system QA Process.
• Involved on configuration testing, UI testing experienced on SOAP UI, UNIX, and running shell scripts.
• Have great knowledge on UNIX commands and sql quires.
• Involved in End to End testing and supported UAT.
• Generated defect reports by various environments like UAT, SIT, and QA and shared with the stakeholders on a daily basis.

Testing Approach: Manual and automation

Tools: Used: Selenium Web driver with Testing Framework

Testing Approach: Manual and Automation

Technology: Java, Cognos, Oracle

Confidential, Dallas, TX

QA Tester

Responsibilities:

• Tested the application on different operating systems for the compatibility of the mapped network drive.
• Involved in writing test cases and test scripts for functional testing.
• Test cases are mapped to the corresponding business requirements.
• Undertaken extensive development of Automation Test Scripts using Quick Test Pro.
• Planned and executed the test cases and reported the bugs in Quality Center.
• Developed SQL queries to check the data integrity and data flow in accordance to the business standards.
• Maintained test matrix for latest test results information.
• Worked with developers and system engineers to nail down the technical problems and to discuss the defect reports.

Environment: QTP 8.2, Load Runner 8.0, Quality Center 8.2, Java, Web Logic, JavaScript, EJB, Oracle & Win NT/2000/XP.

Confidential, VA

QA Analyst /Tester

Responsibilities:

• Prepared test cases for Navigational testing, Functionality testing under load and GUI testing using Quality Center.
• Performed manual testing of the application and identified defects.
• Automated the test cases for Regression testing using QTP.
• Manual testing to perform bottlenecks.
• Parameterized the test scripts to generate and test different reasons for inquiry.
• Involved in database testing of the application to check for insert and update operations.
• Handled unexpected errors using inbuilt exception handling.
• Performed regression testing to check for defects in previous tested modules.
• Used Monitors to identify load and performance bottlenecks.
• Correlated the unique data generated from the server such as Session ID.
• Analyzed transaction graphs, web resource graphs and network graphs to pinpoint the bottleneck.
• Involved in Database Testing using SQL Queries.
• Participated in meetings and walkthroughs.

Environment: Quality Center, QTP, Oracle, Unix, Windows, Websphere