Sql Developer Resume Profile
Skills
Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.
Skill Manual Testing
|
Employment History
Confidential
Sr. CRM Tester
Responsibilities:
- Participated in the Requirement review meeting and Analyzed the Requirements
- Developed test plans for Sales, Marketing and Service.
- Created SQL queries to verify accuracy of data using Toad
- Developed Test Cases for all Sales, Marketing and Service in a agile frame work.
- Tested the customized Customer Relationships like Accounts and Contacts Entities with new attributes.
- Verified and Validated the Edited and New Accounts
- Created brand new contacts in existing Accounts to verify that customization and DB compatible with new data.
- Experienced in data analysis using SQL, TSQL, and PL/SQL
- Recorded test scripts in QTP QuickTestPro and later modified by adding logic, functions and also by adding various checkpoints, synchronization and parameterization of statements.
- Verified and Validated the new Opportunities, Quote Order for customized Accounts
- Provided management with metrics, reports, and schedules as necessary and participated in the design walkthroughs and Involved in managing testers responsible for performance and manual testing.
- Verified the Opportunity Relationship with Account and Contact.
- Created and Tested Contract/Case from Account to verify the cross functionality.
- Verified and validated the customized and configured sales functionality like Leads, Opportunities, Customer, Competitors and Campaigns.
- Develop automated suite of test cases utilizing Mercury Interactive's WinRunner for both global and domestic versions of Chase's Transaction Initiation application.
- Verified the Leads for sales opportunities and inquiries customization.
- Created mock test product data for competitors and verified the Views for the Sales.
- Verified and Validated the Configured Quick Campaigns with manual email and CRM
- Automatic email method.
- Used Quality Center for Test Cases, Running Scripts and logging Defects.
- Created Test Campaigns and tracked them to verify the data quality.
- Verified the Customized Marketing Functionality.
- Excellent development skills using Dot Net, C, C , VB Script
- Created mock campaigns and distributed to perform activity to produce and mail word document.
- Developed and implemented a process, using QMF Query Management Facilities that generated reports detailing female and minority vendors' activities to be used for governmental compliance.
- Created marketing list and verified the data against filter criteria and Locks.
- Verified the qualified and disqualified leads in the marketing.
- Tested the Calendar and Scheduling services activities for the service reps.
- Verified and Validated the On-demand and Automated Workflows
- Created ad-hoc queries like user defined queries to retrieve the desired causes customer records
- Created Queries for Related Entities to retrieve related entity attribute values.
- Verified the Custom Receipts and Validated the Printable data.
- Verified and Validated the SSRS reports and CRM Reports.
- Verified duplicate records in customized duplication detection entity.
- Tested the outlook integration Testing and integration with Great Plains.
- Used Active Directory for Windows Authentication issues and Performance issues.
- Used Active Directory for the domain, domain controllers, user, printers, saved queries and pc data.
- Performing Web Services Testing on Remote and Integrated desktops.
- Tested CRM outlook integration with windows exchange server.
- Used Query Analyzer to write and execute queries and SQL Server.
- Tested the CRM in N-Tier Architecture.
- Used Story card each functionality in Agile Methodology and followed unique story card id to develop test cases.
- Used Rational Clear Quest to report the defects using agile frame work.
Environment: Microsoft Dynamics CRM 3.0, C, C , 4.0 Web and GP 10, Rational Clear Quest, Web Services, .NET 2.0, Dexterity 10, VSS, SQL Server, Agile, Out Look, VB Script, SSRS, Share Point, Mainframes, File Aid, Oracle, PL/SQL.
Confidential
ERP/CRM Tester/Sr. QA Tester
Responsibilities:
- Analyzed and defined testable requirements created and implemented test plans.
- Developed Test Cases/Scripts based on Use Cases, SRS Documents.
- Hand-coded HTML, Java script and CSS.
- Performed through system and regression testing and reported the issues in Quality Center repository.
- Gathered requirements from the existing Tier users and analyzed the requirements.
- Involved in performing functional, Acceptance, system, and regression Testing.
- Developed the Test Data for different Companies like Local and State in order to test the different Transactions.
- Communicated with development team to ensure testing issues are resolved
- Performed Screen Navigation Test to ensure that the links are established as per the documentation provided.
- Prepared and executed different SQL Queries against the SQL Server and GP Database.
- Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
- Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
- Excellent development skills using Dot Net, C, C , TSL
- Analyzed the defects and make sure the defects are fixed in priority.
- Performed Web Services Testing for GP and .NET Environment
- Used Remedy for reporting the GP defects.
- Followed and Implemented the SDLC to improve the Testing Process and Efforts.
- Coordinated with the Business users, BA's and Testers in order to perform UAT Testing.
- Interacted with Business users and BA's regarding the Requirement Issues.
- Involved in Weekly Testing Status meetings with Testing Team
- Published the Test Results in VSS for tracking the existing defects and resolved defects.
Environment: Microsoft Dynamics Great Plains V10. Dynamics CRM 3.0, Dexterity 10.0, VSS, SQL Server, VB Script, .NET .NET 2.0 Frame Work, C, C , ReportNet, Share Point, Mainframes, TSO/ISPF, File Aid.
Confidential
Sr. CRM QA Tester
Responsibilities:
- Analyzed Business requirements, Functional Requirements documents to understand the Application.
- Involved in the analysis of requirements and modifications for existing test plans and test cases.
- Created and Executed a Number of Batch Tests Using Mercury Test Director.
- Implemented Agile Frame Work and QA Methodologies for Datatel Recruiter
- Developed Test Cases that provide a detailed list of conditions under which the system will be tested using Quick Test Professional.
- Authored Test Cases in Quality Center after the analysis of Requirements / Use-Cases.
- Tracked all bugs using Quality Center and reviewed the status of test execution by tracing defects to requirements.
- Deployed and managed the appropriate testing framework to meet the testing mandate.
- Experience with Quick Test Professional for automating functional and regression test cases in Standard Windows, Visual Basic and Web environment using VB Scripting.
- Involved in both manual and automated testing of the Recruiter web application.
- Created and executed Functional, Security, Usability test cases manually
- Developing automated Test Scripts using QTP for Regression Testing.
- Installation, Maintenance, Exchange management shell scripting, mailbox creation, Outlook 2010.
- Creating Application specific and generic functions to reduce redundant code.
- Designing the Performance Test scenarios with various user-mix to perform Performance testing of the application
- Creating test cases and manual testing for daily builds.
- Performed the compatibility testing on Recruiter Web with Microsoft Internet Explorer.
- Develop automated suite of test cases utilizing Mercury Interactive WinRunner for both global and domestic versions of Chase's Transaction Initiation application.
- Extensive knowledge of an intranet system developed in Visual Basic, Java Script, HTML using a Sybase database and over 8 CICS interfaces used to provide real-time quotes and on-line submission of applications to assist Agents in a quick turnaround of business processes.
- Reporting and Tracking the Defect Using Microsoft Team Project.
Environment: Microsoft Dynamics CRM 4.0, Microsoft SQL Server 2008, Selenium, Microsoft Visual Studio 2010, Microsoft Team Project.
Confidential
Senior QA Tester
Responsibilities:
- Involved in gathering requirements and analysis for applications.
- Developed Test Plans, Test Cases, Test Scripts for UAT test s
- Used Informatica as an ETL Tool for Developing the Data Warehouse.
- Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in Req Pro.
- Developed Tractability Matrix and Test Coverage reports.
- Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
- Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
- Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing.
- Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
- Used Shell scripts extensively for automation of file manipulation and data loading procedures.
- Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
- Execute batch processing and verify the jobs status and data in database tables
- Responsible for designing Framework and executing automation scripts using QTP.
- Tracked the defects using Clear Quest and Quality Center and generated defect summary reports
- Automated test cases with Mercury WinRunner Terminal Emulator Add-in
- Modified Configuration file according to space constraints
- Created checkpoints and synchronization points for functional testing using Quick Test Pro QTP .
- Wrote shell scripts to run PL/SQL programs and job scheduling.
- Prepared status summary reports with details of executed, passed and failed test cases.
- Developed and implemented a process, using QMF Query Management Facilities that generated reports detailing female and minority vendors' activities to be used for governmental compliance.
- Interacted with developers, Business Management Teams and End Users
- Participated in regular project status meetings related to testing
Environment: Facets 4.31, NASCO, FLEXX, UNIX, Shell Scripts, Mercury Quality Center, Rational Clear Case, Java, J2EE, Web sphere, Apache, IHS Server HTTP , Web Logic, TIBCO, MQ Series, Informatica, PowerBuilder, Share Point, Visual Basic, Citrix, MS-Windows, MS Project 2003,DB2, IBM Mainframes, CICS, Sybase, Oracle, SQL Plus, Access, SOAP, XML, XML Spy, SQL, .NET, QMF, TSO/ISPF, File Aid, CITT, Team Track, RMIS. Lotus Notes.