SUMMARY:

• Over 6 years of experience as Quality Assurance Analyst dealing with all levels of testing including Black Box, Functional, Regression, Integration, Testing, User Acceptance Testing (UAT) and End to End Testing.
• Possess Extensive Experience in projects like CRM, Telecommunication, Medical, Insurance and Mortgage.
• Closely involved in Software Quality Assurance, Develop, Implement, and maintain test plans, test scripts and test methodologies.
• Have experience in ETL Testing using tools like INFORMATICA and SSIS 2016.
• Experience in writing SQL Queries for data validation, manipulation and verification in Oracle /SQL Server /Hue.
• Experience with complete Software Development Life Cycle (SDLC)
• Expertise in developing, implementation and maintaining Test Plan, Test Script and Test Methodologies Specialized in testing website for design, content, functionality and cross browser comparison on IE (6.0 - 8.0, Firefox and Safari)
• Experience in reports testing and reports validation in Micro Strategy, Cognos.
• Experience in developing Test Plan, Detailed Test Cases , writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Understanding of data warehouse concepts, Running the Shell scripts, Linux commands, notepad++
• Collaborate with business teams, system analysts and Development Team to understand business, Design, technical functional requirements and Technical Implementation.
• Experience converting the User Stories, Technical Implementation and Business Requirements to Test Plan- Scenarios and Test Cases.
• Conduct data analysis; identify issues and recommend and implement solutions.
• Knowledge of Big data, data validation in Hue, running the mappings in Informatica Big Data Manager.
• Experience in analyzing the data in Excel with Pivot tables and V-lookups

TECHNICAL SKILLS:

Operating Systems: CentOS, Windows,Mac,Linux

ETL Tools: Informatica 10.1, SSIS 2016

Browsers: MSIE, Firefox, Chrome, Safari, Opera

Databases /SQL: Oracle 11g, SQL Server 2016, Informatica 10.1

Web technologies: Knowledge of HTML, XML and CSS.

Software methodology: Waterfall, Agile.

Bug Tracking Tools: JIRA

Performance Tools: J-Meter

Testing Web service Tools: Ready API

Reporting Tools: Micro Strategy, Cognos, Business Objects, Birst

Testing Methodologies Used: Agile Methodology, Data Warehouse testing, GUI Functionality Testing, Integration testing, Regression testing Automation

Selenium web driver, Eclipse: Agile Methodology, Data Warehouse testing, GUI Functionality Testing, Integration testing, Transaction testing and Regression testing

PROFESSIONAL EXPERIENCE:

Confidential

ETL Tester

Responsibilities:

• Written SQL queries to validate reports against the database
• Used SQL query to validate backend data from stage to target database
• Written Test Cases for ETL to compare Source and Target database systems
• Identified issues and logged defects and re-tested them when fixes were completed by development
• Compared data through BDQ (Bridgewater data query). BDQ interacted with oracle database and MS SQL server to collect current state data and future state data.
• Attended daily scrum meetings and provided statues on testing activities, obstacles and accomplished goals
• Utilizes structured query language (SQL) to analyze and validate data during testing.
• To attend the business meetings to understand and prioritize business, functional, and technical requirements.
• To review user cases and other technical documents with team to ensure business requirements are adequately reflected in technical planning documents.
• Documented detailed test cases using equivalence class partitioning and incorporating both positive and negative scenarios.
• To analyze the business unit's activities and trends and compares analyses against service standards and best practices.
• Tested the individual endpoints such as soap, rest using Ready API.
• Used firebug to inspect DOM and capture JavaScript errors.
• Performing Load testing using J-meter.
• Logging bugs and defects in Jira.
• Attending Backlog grooming and sprint planning.
• Ran Informatica sessions and checked the session logs for debugging.
• Involved in regular project review meetings & Testing Status Meetings.

Environment: SQL Server 2016, Microsoft Visual Studio (BIDS),Microsoft Dynamic CRM, Oracle 11g, Informatica 10.1,Jira,Hue

Confidential

Software QA Analyst

Responsibilities:

• To consult with stakeholders to determine and prioritize business, functional, and technical requirements.
• Implemented Black box technique to test Membership Sales Process and its various purchase paths such as POS, APOS PT (After Point of Sale Personal Training) and APOS FAO (After point of sale Family Add on).
• Performed functional testing technique to test the club finder, product and pricing module of the Fit24 app.
• Used firebug to inspect DOM and capture JavaScript errors.
• Tested the trimmed down version of application on various smart phones and tablets.
• To ensure that all tests are conducted and documented to meet project timeline.
• Tested User Interface applications GMS, FIT24IC, FSS.
• Consistently worked and communicated issues with off-shore development team on a daily basis.
• Verified ETL process worked from beginning to end. By running the extract scripts (KSH) verified data migrated from different source systems to staging tables.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Verified the dimension and fact tables are populated correctly by running the load scripts and utilizing the staging tables.
• Verified the transformation logic (based on requirement) worked correctly from data mapping document using stage and target tables.

Environment: SQL Server 2016, Microsoft Visual Studio (BIDS, Oracle 11g, Informatica 10.1,Jira,Hue

Confidential

QA Software Test Engineer

Responsibilities:

• Tested ETL process across multiple client teams
• Utilized INFORMATICA Power Center designer to analyze mapping, sources, source transformations, expressions, sequencers, normalizes, filters and targets
• Verified data for ETL Packages using SQL Queries
• Utilized INFOMRATICA Data Warehouse for testing ETL process
• Validated workflows, sessions and WORKLET to check in and check out
• Analyzed functional and business requirements to develop test suites, test plans and test cases
• Created test plan and estimation to share with the business team
• Defined testing process for functional and usability testing
• Performed functional, regression and integration testing for web-based Dashboard application
• Coordinated with business and development team to resolve defects through defect triage meetings
• Develop standardized matrix reports

Environment: Oracle 11i, Toad, INFORMATICA, UNIX, Microsoft Office

Confidential

Quality Assurance Analyst

Responsibilities:

• Participated in creating Test Plan and test cases based on business requirement utilizing HP Quality Center 9.2
• Executed test cases, log/tracked defects utilizing HP Quality Center
• Performed back end testing utilizing APEX Edit SQL tool to validate data
• Involved in all phases of testing i.e. Functional, Regression, Integration, End to End and UAT testing, with the different environment i.e. QA, Staging, Pre-Production
• Attended weekly cross-functional defect report meetings and presented progress and updates

Environment:: HP Quality Center 9.2, Microsoft SQL Server 2008, Notepad ++, Microsoft Office