PROFESSIONAL SUMMARY:

• Over 6+ plus years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server, Web, Enterprise Data Warehouse (EDW) solutions, ETL & Business Intelligence solutions.
• Experience in teh Software Quality Assurance and Software Testing in Web based, Client Server Applications, EDW and BI in teh Banking and Healthcare, Telecom, Insurance and Finance domain with cross - platform skills in Windows, UNIX and Linux OS.
• Involved in all phases of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC)
• Experience in testing applications developed using Agile Methodologies like SCRUM and Test-Driven development etc.
• Experience in Test Management tools like Team Foundation Server, HP Quality Center, HP Application Life Cycle Management
• Extensive experience in Black Box, Functional Testing, Performance Testing, Load Testing, Security Testing, System Integration Testing, Smoke Testing, Cross Browser Testing and Regression testing
• Strong experience in Quality Assurance activities in Data integration and Data migration, ETL Testing, Metadata Testing, Data Accuracy Testing, Data Transformation Testing and Data Quality Testing to validating that source data is accurately translated and loaded into a target database.
• Expertise in preparing Test Strategy, Test Plans, Traceability, Test Scenarios, Test Cases, Test Reports and Documentation for ETL, EBS and Web testing.
• Unix scripting for automation and development and for reporting purpose.
• Excellent troubleshooting and debugging skills.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, PL/SQL, MS Access and Flat Files.
• Experience working with Databases like Oracle, SQL Server, DB2 and MS Access.
• Hands on experience with various mobile applications including Android, Apple, RIM, BREW & Win M platforms on Blackberry, iPhones, Android & iPads using Device Anywhere
• Hands on experience in Cloud environment using Azure.
• Good experience in Selenium Web driver. Experience in implementing and maintaining Page Object Model Automation frame Works by using Selenium Web Driver.
• Authorized to work in United States for any employer

PROFESSIONAL EXPERIENCE

ETL/Hyperion BI Tester

Confidential - Cedar Rapids, IA

Roles & Responsibilities:

• Involved in Requirements gathering and Analyzing Business Requirements, Functional specifications docs and Project scope and prepare teh test strategy, test plan, test scripts and test cases.
• Prepare daily status, conduct defect triage meetings, test reports, defect status reports and share to stake holders.
• Executed test cases between source to target, OLTP to OLAP, Mainframe to Data Marts, and Performed Data validation, Data Quality, and Hyperion reports validation.
• Extracted data from Sybase transactional database tan validated against Business Intelligence reports.
• Involved teh Hyperion reports code migration and running Autosys jobs for Inbound and outbound data extractions.
• Designed Test Cases, Test Scripts and Test Scenarios based on use case docs, Functional requirement docs. Prepared Test Plan, Effort Estimation.
• Experience with API/Web Service testing using JMeter, Advanced REST Client and Postman.
• Hands on experience in interacting with onsite offshore development team in fixing defects.
• Hands on experience in Automation Tool like Selenium.
• Ability to work under pressure and in high stress situations with a calm demeanor
• Proven experience in using and learning new software tools or applications
• Excellent production support attitude, communication skills, and interpersonal skills
• Ability to work in a quality focused environment, balancing multiple projects, and delivering results within prescribed schedules and deadlines
• Excellent analytical and problem-solving skills
• Ability to be flexible and adapt to any given situation

Environment: Oracle EPM 11.1.2.4 (SQR & BQY), ODI, Sybase, Oracle, TDP Defect Tracking Management Selenium Automation Testing. iOS and Android device. AOTS-M, SOUP UI, POSTMAN.

Hyperion Tester

Confidential

Roles & Responsibilities:

• Participated in Functional Design Document review meeting, Business Requirement Document review meeting, Defect triage meeting, Daily Status, Weekly status meetings and other project meetings.
• Reviewed teh Business Requirement Documents and teh Functional Specification. Prepared Test Plan from teh Business Requirements and Functional Specification.
• Developed Test Cases for ETL Data Validation, Cube Testing, Deployment Verification and Report Testing.
• Preparing business test scripts with teh business rules associated with it to test teh data integrity of archived data.
• Responsible for Creation and execution of Test Cases which includes creating Complex SQL scripts, Defect Logging & tracking to closure.
• Extensive experience on ETL testing, Fact, summary/Aggregate table testing, Report testing, KPI/Dashboard Testing using OBIEE
• Defect reporting and tracking through ALM.
• Regularly interacting meetings with teh Business users, Business Analysts, Project Directors, Project Managers, Developer and understand teh requirements/specifications and design/plan teh testing requirements.
• Prepared Complex SQL Queries as per business requirements to validate teh Source and target data matching, Report backend testing using SQL Server Management Studio and Oracle Developer
• Wrote complex SQL queries to Oracle database for backend/frontend comparative analysis me.e., to check teh correctness of teh data stored in teh database.
• Performed database testing to ensure teh ETL process for teh data being extracted from various sources (like Oracle tables, flat files, CSV files), transformed and loaded into teh new Database through Informatica.
• Finalized and published Test Results in an incremental manner through thoroughly analyzed defect reports.

Environment: Oracle EPM 11.1.2.3 (HFM, FDM, DRM), OBIEE, Oracle 11g, ETL, Informatica, Unix, PL/SQL Microsoft Office 2010.

QA Tester

Confidential - Sparks, MD

Roles & Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing teh operations mentioned in teh design steps. Compared teh expected results with teh actual outcome and recorded teh results.
• Working with teh Development team for process improvement and release planning
• Analyzed application data using teh SQL to identify teh ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of teh DB by writing PL/SQL queries to test teh integrity of teh application and Oracle databases.
• Backend testing through SQL queries and PL/SQL subprograms to support teh test case results, SQL performance tuning.
• Worked on UNIX environment in Test and UAT environment.
• Participated in Daily defect calls to elaborate on newly raised defects and also to keep track on teh status of existing defects.
• Performed database testing to ensure teh ETL process for teh data being extracted from various sources (like Oracle tables, flat files, CSV files), transformed and loaded into teh new Database through Informatica.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer.
• Use Informatica debugger and session log to debug teh defects.
• Finalized and published Test Results in an incremental manner through thoroughly analyzed defect reports.

Environment: HP Quality Center, Informatica, Teradata R6, Oracle10g, QTP, SQL, PL/SQL, Selenium Web Driver, Oracle 11g, Unix, SQL Developer 3.0, PL/SQL, Microsoft Office 2010.

QA Analyst

Confidential - Deerfield, IL

Roles & Responsibilities:

• Reviewing, analyzing and identifying teh requirements specification packages to understand teh business logic and applications
• Played an active role in teh QA/QC cycle during teh major releases.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Uploaded teh Functional Requirements into Quality Center Requirements module
• Developed Test Cases in Quality Center and reviewed teh same with QA Team and BA group
• Linked teh Test cases with Requirements in Quality Center
• Developed Test Data needed to execute teh test cases
• Prepared Test Suites in QC Test Lab to include different test cases from teh QC Test Plan
• Performing Functionality Testing, Integration testing, System testing, and Regression Testing by using Rational Manual Tester and Rational Functional Tester.
• Coordinate with QA team to manage and update teh missing parameters of test cases and defects in QC. Performed Manual Testing to test teh usability of teh application.
• Conducted GUI testing to test teh appearance and properties manually.
• Performed Smoke Testing, Sanity Testing.
• Performed back-end testing using SQL queries to validate data and perform Data integrity testing. Performed Data mining on defects, test cases, requirements as required by teh team.
• Analysis teh Weekly QA Metrics Reports for to correct teh reporting errors.
• Modified test scripts created by teh system test team to meet UAT needs
• Supported User acceptance testing (UAT) in preparing teh test scripts and test execution.
• Documented and reported bugs using Quality Center.
• Actively participated in Status reporting meetings and interacted with Developers to discuss teh technical issues.
• Analyze teh requirement coverage and traceability to ensure teh testing coverage.

Environment: Windows 7, SQL Developer, Quality Center, Clear Quest, Rational Manual Tester, UNIX, Windows XP, Agile.

Oracle EBS QA Analyst

Confidential - Chicago, IL

Roles & Responsibilities:

• Involved in client meetings for proto type demo and requirements sign-off.
• Converting Functional Specifications into Test plans, test cases and execution plans.
• Preparing teh test data for all teh test cases.
• Documented test cases executed in HP ALM and associated test cases with requirements for traceability.
• Performed Data validation, performed Functional, UI, Database, Smoke, Ad-hoc, Integration, Regression testing, UAT and Data Validation.
• Identifying and prioritize critical test cases on each release.
• Responsible for application smoke testing.
• Communicate defect information with development teams.
• Participated in bug meeting reviews with development Manager and QA Manager to prioritize teh bugs.
• Coordinate with teh development team to fix teh defects and release teh new version code.
• Used Quality Center to report defects and test results.
• Developed Sub Queries, Joins, views, to compare teh test results between source files and tables.
• Extensively used Quality Center for test planning and Used Rational Clear Quest for bug tracking and reporting.
• Good knowledge in NuGenesis SDMS, PRESTIMA.
• Responsible for creating test bed for teh application with valid and invalid data covering all positive and negative test scenarios.
• Actively participated in enhancement meetings, project review meetings, Weekly status meetings and various other meetings which were focused on making teh application more effective.

Environment: Oracle 10g (SQL/PL/SQL), Hyperion Suite 9, Data stage 7.5, Hyperion Intelligence Reports, Putty, Autosys, Office Communicator, SharePoint