SUMMARY

• Certified Scrum Master wif 6+ Years of extensive experience in IT Industry wif emphasis on Quality Assurance & Software Testing and ETL/ Data warehouse, (Manual/ETL) and backend testing.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) wif good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Good experience of Quality Assurance methodologies like Waterfall and Agile (Scrum).
• Experience in automated testing tool Selenium.
• Extensive experience in Salesforce CRM Cloud integration testing.
• Expertise in working wif varioussalesforce standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads, & Campaigns.
• Well Understanding in Workflows, Roles, Profiles, Report, Dashboard, VisualForce.
• Good understanding wif Apex Language, Apex Trigger, Apex Class & Apex Web Service, Visual Force (Page, Component & Controllers).
• Experience in HP ALM for Test Management; Jira, TFS for defect management, defect tracking and bug reporting tools.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Ability to work in Multi - Platform Environments like Windows, UNIX and Linux.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Experienced in Functional, Regression, Integration, End to End, User Acceptance Testing, System, Cross Browser Testing and Database Testing.
• Knowledge and experience in Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Data Warehouse.
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact wif database.
• Experience in testing SOAP and REST web services using soapUI tool.
• Experience in using UNIX commands and knowledge of writing Unix Shell Scripting.
• Versatile team player wif excellent analytical presentation and interpersonal skills wif an aptitude to learn new technologies.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to teh varied needs of teh stakeholders involved.
• Participating proactively in daily standup meetings, story grooming sessions, team retrospectives, suggesting and implementing improvements.
• Preparation of Application Test Strategy, Test Plans, Test Scripts, Requirements Traceability Matrix (RTMs), Cycle Plans, Test Evidence walkthroughs.
• Writing Test Scenarios and Test Data preparation for Functional, Integration, End to End and Regression testing.
• Preparing teh Test Summary Report for all teh major integrated releases.
• Sharing teh Test execution status and defects status on timely basis to Clients and leads and preparation of weekly Status reports.
• Ability to mentor new resources and help to get into current pace in teh project.
• Strong analytic skills self-driven, keen to learn and adopt new technologies and process.

TECHNICAL SKILLS

Operating Systems: Windows XP, Window 2000, MS-Dos, OS/400, UNIX, Putty

Testing Tools: HP Quality Center/ALM, QTP, JIRA, TFS

BI and ETL Tools: Informatica 9.6.1,9.1,9, 8.1, SSIS 2008, Cognos 10.2.2.

Web Services testing tool: SoapUI

Scripting Languages: SQL, Shell Scripting

Others: MS Project, Visio, MS Office, MS Excel

Databases: Oracle 9i/10g / 11g, DB2 8.0, MS SQL Server 2012/2005, Teradata 13

Application Environment: C#, .NET Framework, .NET Web Services. Java

PROFESSIONAL EXPERIENCE

Confidential, OH

Salesforce Test Analyst

Responsibilities:

• Review of Plans Benefits and coming up wif teh high-level scenarios.
• Working on New Client implementations and MOBs.
• Contribution to preparation of Test Strategy and Test Plans.
• Validated entities like Leads, Opportunities, Accounts, Campaigns, Forecasts, Contracts and Orders.
• Conducted Smoke testing, Sanity Testing, Functional testing, Regression testing, Integration testing and Data validation testing.
• Worked in Agile Environment
• Involved in testing teh custom objects, Custom tabs, Validation rules, Page Layouts, Compact Layouts to suit teh needs of teh Application in teh requirements.
• Worked on testing teh users and assigning teh roles, profiles for different users in teh organization.
• Tested teh Object and Field level security to hide teh critical information on teh profile users.
• Tested Workflow rules, defined related tasks, time triggered tasks, email alerts, field updates to teh business logic.
• Involved in SIT, Regression and UAT Testing for New enhancements as well as ongoing changes (Change Requests).
• Used HP ALM for writing Test Cases, Defect tracking and Status reporting.
• Rigorously performed Regression testing for every modification/enhancement of teh project.
• Do teh Query Testing of Benefits before actual testing using Claims to ensure teh benefits are coded as per teh Coding guidelines.
• Creation of Test Beds wif all teh required Claims to cover all teh benefits in teh Plan and Test Execution.
• Raising Defects and track them to closure till all teh Benefit coding issues are resolved and teh Test Beds are signed off by teh clients.
• Participating in daily status calls and provide Execution status and Defects status to all teh stakeholders.
• Worked closely wif development and testing teams to accomplish timely release objectives.
• Performing Root cause analysis for teh defects and coming up wif lessons learnt.
• Preparation of understanding documents for testing each Client benefits and Standard Coding Procedures.

Environment: .Net, SQL Server, Rx Claim System, HP ALM, Jira

Confidential

Test Analyst

Responsibilities:

• Worked closely wif business analysts, business users, project teams to analyze business and functional requirements to create test plans, test scenarios, test cases to ensure teh highest quality products are released to production.
• Acted as delegate representing QA and Support on various issues wif vendors and worked wif them for various solutions.
• Initiated teh QA process in teh project along wif team lead and acted as QA point of contact to teh team.
• Attended scrum ceremonies like daily stand up meetings, code review meetings, process review meetings and defect review meetings.
• Conducted Smoke testing, Sanity Testing, Functional testing, Regression testing, Integration testing and Data validation testing.
• Used Quality Center (QC) ALM for writing Test Cases, Defect tracking and Status reporting.
• Rigorously performed Regression testing for every modification/enhancement of teh project.
• Strong in writing complex SQL queries to profile and analyze teh data in Oracle 10g.
• Developed SQL queries to check teh database automatically and checking teh data integrity in ETL Flow of data from source to stage and stage to target.
• Tested ETL’s to ensure that teh source and teh target are mapped as per teh Requirements/specifications.
• Used Informatica PowerCenter to analyze teh mappings involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter and test them wif respect to teh requirement specification.
• Used Informatica Workflow Manager, Workflow Monitor to run teh ETL and monitor teh ETL jobs along wif reading teh log files to find out teh errors.
• Initiated Defects review meetings wif Developers and communicated wif them for whole defect life cycle until teh logged defect is closed and verified.
• Worked closely wif development and testing teams to accomplish timely release objectives.
• Review of Plans Benefits and coming up wif teh high level scenarios.
• Working on New Client implementations and MOBs.
• Contribution to preparation of Test Strategy and Test Plans
• Conducted Smoke testing, Sanity Testing, Functional testing, Regression testing, Integration testing and Data validation testing.

Environment: HP ALM, Informatica Power Center 9.1.1, Informatica Power Designer, Informatica Workflow Manager, Informatica Workflow Monitor, Oracle 10g, SQL Developer for Oracle, UNIX, PUTTY, and Microsoft Office tools.

Confidential

Test Analyst

Responsibilities:

• Study and analyze teh customer requirements.
• Review of FD from Product Management Group.
• Preparing Test Scripts and review of Test Scripts.
• Test Scripts Execution, Status Reporting on a daily basis.
• Preparation of Defect Logs, Test scheduling, bug-fix verification in new releases.
• Involved in testing of Hot fixes, Patches and regular Test Builds.
• Verification of new configuration changes in teh updated configuration guide.
• Involved in evidences review wif clients using client’s Testing environment.
• Review of installation guide for teh changes for each build.

Environment: VB, .Net, SQL Server, Microsoft Office, iAssist, Quality Center.