SUMMARY

• Seven years of experience, including 3 years as DBA in development and production environments.
• Ensure Oracle database systems operate efficiently and securely.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• Manage internal databases, from planning and testing stages through implementation and support.
• In - depth understanding of security and backup procedures to ensure database integrity.
• Background in developing backup and disaster recovery plans for nationwide offices.
• Superior communication, presentation, analytical and problem solving skill.
• Work well with all levels of business.
• Experience in system analysis and in Quality Assurance of Client/Server, and Web based applications.
• Excellent professional skills to prepare test plan and managing projects by meeting with business or technology owners to gather information to determine project parameters and specifications.
• Involved in Preparation of Test Plans and Test scripts.
• Well experienced in Test planning, documentation, defining and executing the test scripts.
• Proficient in QA processes, test strategies, and in performing Functional,
• GUI, Regression, Database, and Integration testing
• Strong experience in creating test scripts using Excel, Word and HP Quality Center
• Strong skills in ORACLE, SQL.
• Expertise in working with different browsers like IE, Firefox.
• Excellent rapport with Business Analysts, Developers and Testers in the projects and worked in close collaboration with team members to ensure quality of the application.
• Good Skills in Manual testing and Web testing.

TECHNICAL SKILLS

Operating Systems: Windows (XP/2000/NT/me/98/95)

RDBMS: Oracle, SQL Server, Unix/Linux.

Test Tools: Quality Center and ClearQuest, QTP.

Languages: C, SQL, PL/SQL, Oracle

Packages: MS Office, VSS and Sharepoint.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Experienced with database administration, database systems, data management and/or database development
• Worked independently design, build, administer, manage, and maintain Oracle databases with general direction and oversight
• Experienced in working with databases in a Linux-based environment (virtual environment preferred)
• Created new databases and users: set up backups, export, and other monitoring scripts
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery
• Identify, recommend, and implement all new database technologies and Oracle license management.
• Understanding of TCP/IP, LAN, WAN and other network aspects in a large enterprise
• Experience troubleshooting and resolving complex database related issues
• Proficient in a team environment and who can communicate and present effectively to the customer.
• Expertise in the use MS Word, Excel, PowerPoint
• Ability to prioritize and work with multiple assignments simultaneously
• Ability to interact effectively with all levels of management, customers, peers, and staff
• Strong organizational skills
• Superior attention to details
• Excellent analytical & problem solving skills and Positive and enthusiastic attitude
• Strong dedication to customer service
• Ability to learn quickly and adapt to ad-hoc changes in the environment
• Excellent oral and written communication skills
• Worked with multiple up/down stream systems with the entire project time line, and asking their availability at that time and also.
• To establish and maintain a timely manner test methodology and to resolve questions during the testing process.
• Worked on new Industry methodologies for improvising the testing process.
• As Test Lead involved in the project and team Budget/cost meetings.
• Worked with multiple up/down stream systems with the entire project time line, and asking their availability at that time and also.
• To establish and maintain a timely manner test methodology and to resolve questions during the testing process.
• Worked on new Industry methodologies for improvising the testing process
• As a TEST LEAD Supported SIT efforts for Web-Services application.
• Prepared data for all the manual test cases in QC for automation.
• Prepared all the ER files needed for the automating the test cases.
• Executed Test cases in QC and updated the status and attachments for each test case.
• Created XML files from Excel and validated the XML Response back to Excel
• Interacted with developers in case of any issues.
• Involved in the test case review meetings by the team members.
• Responsible for updating the status to the lead on a daily basis.
• Used DOORS to verify the requirements.
• Used ClearQuest to Open and View the defects.

Environment: Java, J2EE, DOORS, ClearQuest, GEMS, Agile, QTP, SQL server, HPQ and Oracle

Confidential, VA

Responsibilities:

• As a Sr.QA Analyst, participate in Sprint planning by providing LOE.
• Review Business, Design and Data Requirements
• Create and Review BAS with Lead, Business and QA manager and get sign off.
• Performed different types of testing like Extraction, Transformation and Loading
• Based on Transformation Logic, created Derivations
• Create scrub book when data is required and mock test data when source data not available.
• Create test cases using standard test case template.
• Review the test cases in Excel and export to Quality Center
• Participate in daily stand-ups to communicate to the delivery team and QA Manager about the issues, concerns / risks.
• Executed ETL jobs(Ab-Initio) on Unix and validate against the database
• Worked independently on multiple projects
• Working with delivery team to resolve defects and issues.
• Validating defects and updating BAS Results and generate test completion report.

Environment: Java, JBOSS, Ab-Initio, Oracle, Quality Center, Clear Quest and UNIX.

Confidential, VA

Responsibilities:

• As a Test Engineer, developed all the test cases based on the requirements document.
• Involved in the status meetings to discuss the issues and progress of the application on a weekly basis
• Used Clear Quest to open and validate the defects.
• Developed Requirements Traceability Matrix to validate that all requirements are covered.
• Created XML files to be used for Web-Services application and validated the response XML
• Used SQL Server for backend validation.
• Verified the log files for error messages when the application encounters any errors.
• Performed bug regression, release testing and supported end to end testing.
• Responsible to work with the developers to get the defects fixed.
• Tested the applications with different versions of web browsers and Operating system.
• Involved in the release meeting to see the status of the application after installed in the production.

Environment: Java, JBOSS, SQL Server, Visual Source Safe, Quality Center, Clear Quest and QTP