PROFESSIONAL SUMMARY:

• Certified Scrum Master with 6+ Years of extensive experience in IT Industry with 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) with 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 with varioussalesforce standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads, & Campaigns.
• Well Understanding in Workflows, Roles, Profiles, Report, Dashboard, VisualForce.
• Good understanding with 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 with 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 with excellent analytical presentation and interpersonal skills with 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 the varied needs of the 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 the Test Summary Report for all the major integrated releases.
• Sharing the 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 the 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 with the 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 the custom objects, Custom tabs, Validation rules, Page Layouts, Compact Layouts to suit the needs of the Application in the requirements.
• Worked on testing the users and assigning the roles, profiles for different users in the organization.
• Tested the Object and Field level security to hide the critical information on the profile users.
• Tested Workflow rules, defined related tasks, time triggered tasks, email alerts, field updates to the 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 the project.
• Do the Query Testing of Benefits before actual testing using Claims to ensure the benefits are coded as per the Coding guidelines.
• Creation of Test Beds with all the required Claims to cover all the benefits in the Plan and Test Execution.
• Raising Defects and track them to closure till all the Benefit coding issues are resolved and the Test Beds are signed off by the clients.
• Participating in daily status calls and provide Execution status and Defects status to all the stakeholders.
• Worked closely with development and testing teams to accomplish timely release objectives.
• Performing Root cause analysis for the defects and coming up with 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 with business analysts, business users, project teams to analyze business and functional requirements to create test plans, test scenarios, test cases to ensure the highest quality products are released to production.
• Acted as delegate representing QA and Support on various issues with vendors and worked with them for various solutions.
• Initiated the QA process in the project along with team lead and acted as QA point of contact to the 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 the project.
• Strong in writing complex SQL queries to profile and analyze the data in Oracle 10g.
• Developed SQL queries to check the database automatically and checking the data integrity in ETL Flow of data from source to stage and stage to target.
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications.
• Used Informatica PowerCenter to analyze the mappings involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter and test them with respect to the requirement specification.
• Used Informatica Workflow Manager, Workflow Monitor to run the ETL and monitor the ETL jobs along with reading the log files to find out the errors.
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.
• Worked closely with development and testing teams to accomplish timely release objectives.
• Review of Plans Benefits and coming up with the 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 the 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 the updated configuration guide.
• Involved in evidences review with clients using client’s Testing environment.
• Review of installation guide for the changes for each build.

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