SUMMARY:

• Around 6+years of experience in the areas of Software Testing, Quality Assurance and Database testing.
• Extensive experience with Software Quality Assurance Testing on GUI based Client - Server &Web Based applications, ETL, Web Services, Data Driven Applications, Data Warehousing projects using Manual and Automated testing procedures.
• Experienced in working various SDLC models (Agile-SCRUM, V-Model and Waterfall) and involved in all SDLC phases from Project Initiation to Post Deployment meetings.
• Diverse work experience on System testing, Regression Testing, GUI testing and Database testing using Black box testing methodologies.
• Strong experience in Defect Life Cycle in QA.
• Have extensive experience in implementation of Workflow Rules, Role based Page Layouts, Record Types, Approvals and Assignment Rules.
• Extensive experience in writing Test Plans, Test Scenarios, Test Cases, and analyzing Test Results.
• Extensive experienced in handling projects in the areas of Functional, Integration, Regression and Acceptance Testing in Agile and Waterfall models
• Good knowledge in Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.
• Worked on sales cloud and service cloud.
• Strong exposure to Security and sharing rules implementation at object, field, and record level for different users at different levels of organization and also Single Sign - On (SSO) setup.
• Good knowledge of Salesforce configuration, Data migration, System integration Testing and familiarity with Visualforce (Pages, Components, Controllers) MVC architecture.
• Hands on expertise in moving Apps from lower sandboxes to production environments and addressing issues related to functionality, integration, and deployment.
• Well versed in analyzing CRM business processes that include Campaign management, Lead Management, Role Hierarchy, Account Management, Case Ma

PROFESSIONAL EXPERIENCE:

Confidential

Quality Analyst/Sales Force Tester/QA

Responsibilities:

• Validated hundreds of reports and tested dashboard bases on roles and role hierarchies. Tested salesforce standard objects (Campaign, Accounts, Contacts, Opportunity) and custom objects, page layouts, fields validations and its access to the user based on defined profile. Validated workflow rules, approval processes, and validation rules.
• Tested lookup and master - detail relationships on the objects and created junction objects to establish connectivity among objects. Worked on Data migration from lower to higher environment and validation the data. Created Test scripts, Test cases, executed Test cases and logged the defects in QC environment. Performed GUI, Functional, Regression, Retesting, Usability, Acceptance, Smoke testing Good interacted with QA team, Developers, Project Managers and Clients to resolve issues. Involved in reviews for functional requirements and Test case scenario and Test case designing. Coordinated with onsite/offshore teams, conducted necessary KTs and provided full support whenever it was required.
• Tested in sandboxes and deployed Components and Data from one environment to another and Managed sandbox refreshes and release testing. Hands on expertise in moving Apps from lower sandboxes to production environments and addressing issues related to functionality, integration, and deployment. Created/Modified Visualforce pages and Apex Custom Controllers on Force.com IDE to customize the view and functionality of the page according to organizational needs. Run database queries in workbench for Test data into salesforce. Discovered missing data needed for reporting and worked closely with the client to get the correct fields and objects created to complete the project.

Environment: Salesforce, Informatica, PL/SQL, Flat Files, Csv file, Text file, UNIX, SQL, Oracle 11g, Reports, SFDC Sandbox

Confidential

Sales Force QA/ETL Tester

Responsibilities:

• Tested Sandbox environment customized the Salesforce application as per the client's requirement. Involved in Preparation of Test Procedures, Test Scenarios, Test Cases and Test Data. Tested the company's Salesforce CRM application. Involved in gathering customer requirements from business user teams spread over the Sales, Marketing and Service cloud. Involved in creating gap analysis document, clearly identifying the data, business process and workflows of the organization. Involved in finding the gaps of the requirements and acting as the Scrum master for all the Sprints. Preparing Test Strategy and Test
• Plan for all the applications. Analyzed Business requirements and solution specification documents to design Test Plans, Test cases. Defined requirements in Quality Center and mapped with the respective test cases for traceability. Designed the Test Strategy, Test Plan, Test cases, created RTM, Test Results documents. Verify that for rejected data proper error logs are generated with all details. Performed Test Plan/Test case review meetings during testing phase. Performed execution of test cases manually using Quality Center. Wrote SQL queries to compare source to target data. Performed data validation testing, wrote test cases based on business scenarios. Designed test data using MS Excel sheet for testing the application with positive and negative inputs. Conducted Configuration, System and Integration Testing and User Acceptance Testing. Performed sanity / smoke testing for each release. Maintained multiple versions of test sets and worked on regression testing. Involved in all phases of SDLC. Used QC for tracking, analyzing, and documenting.

ENVIRONMENT: Salesforce.com SFA & Force.com Platform, ALM, Oracle DB, Window XP, Unix, Oracle, JIRA, JSON, SOAP UI, Clear Quest, Java, J2EE, Informatica Power Center 9.1, Putty, WinSCP, IBM Tivoli Workload Scheduler.

Confidential

Quality Assurance Analyst

Responsibilities:

• Worked on detail design documents and Business Requirement Documents in Quality Center to understand testing needs and understand complete business process. Ensured content and structure of all testing documents/artifacts is documented and maintained. Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization. Keep track of new requirements/change in requirements of project. Tracked and prepared the report of all testing activities like testing results, test case coverage, required resources, defects discovered and their status, performance baseline etc
• Involved in customizing Transactions 837, 835, 276/277 in their following loops and segments in map/data translation. Prepared/updated the metrics dashboard at the end of a phase or at the completion of the project. Associated test cases with their requirement using coverage and used coverage analysis view in Mercury Quality Center to ensure all requirements are tested. Experienced in performing User Acceptance Testing (UAT) and keeping testing logs & cycles to add to software testing artifacts. Validated the output reports for the layout provided by the states. Worked with the enrollment team on the data consistency issues and made sure that all the columns on the output report have the correct values. Excellent presentation skills and good written and oral communication skills to work with Business users for UAT testing. Wrote SQL queries using TOAD and SQL Developer for the backend testing, extensively used inner and outer joins to verify data integrity in Oracle database.
• Communicated with business and development teams to resolve issues with test execution and ensured enhancements meet established quality and end user needs. Logged the defects in Quality Center maintaining right priority and managed the defects through it. Generated defect summary reports and test metrics to provide project status to upper management.

ENVIROMENT: HP Quality Center 10, Oracle 11g, PL/SQL Developer 2.1, Toad 9.7, Microsoft Project, MS Office Suite, Putty for UNIX, HTML, Outlook, and Lotus Notes.

Confidential

QA Analyst

Responsibilities:

• Wrote the SQL queries for landing table, staging tables and master's table validate the data results. Working in Agile environment attend daily stand up, sprint planning, backlog grooming refinement and retrospective meeting. Load the test cases in the ALM under test plan and execute the test cases in the test lab. Create task, update the task, and input actual work. Reviewed Informatica mappings and run the job in workflow manager and to check in the workflow monitor to validate. Extensively used Informatica power center for extraction, transformation and loading process Write the test cases and update as per the design documents and follow the mapping doc for the system Integration region.
• Identify the complete test scenario for report testing. Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e., backward navigation from target to source. Performed backend database testing by writing SQL scripts to verify data integrity. Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle Involved in all testing phases: Smoke Testing, Functional Testing, System Testing, Performance Testing, Regression Testing, Integration Testing, and Quality Assurance Testing Involved in validating the aggregate table based on the rollup process documented in the data mapping. Assisted in creating test data and test cases and execute function system tests as needed. Tested the application by writing SQL Queries and creating pivot views as to perform back - end testing.

Environment: Informatica, PL/SQL, Flat Files, Csv file, Text file, UNIX, WinSCP, ALM, Rally, Oracle 10g, 11g.