SUMMARY

• More than 8 Years of experience in design, development and testing in Oracle database applications, web based applications.
• Expertise in both Manual and Automated Tesing.
• Expertise in testing Distributed Web - Based Applications, Client-Server, Java applications, .NET applications.
• Expertise with Agile and WaterFall development methodologies.
• Experience in Preparing Test Strategy, Test Planning, Test Cases Design,, writing Test Scripts by decomposing Business Requirements and developing Test Scenarios to support quality deliverables.
• Expertise in Test Environment Setup, Test Data Setup, Test execution, Defect Management, and Test Metrics preparation.
• Highly Proficient in different types of testing like Functional and Regression Testing, System Testing, Integration Testing, User Acceptance Testing, Performance Testing, Smoke & Sanity Testing, Exploratory Testing.
• Strong data warehousing and business intelligence skills
• Extensively tested PL/SQL, HTML, XML, DHTML, Oracle, VB, VBScript, Java, JavaScript and dynamic Web pages.
• Strong experience in SQL, PL/SQL.
• Basic experience of UNIX.
• Experience with Business Intelligence tools like Hyperion/Brio and Interactive Reporting.
• Extensively used Mercury Quality Center. Good Experience in automated testing tools such as QTP, Test Director etc.
• Adept in Back end testing and performed Data integrity/verification testing using SQL queries
• Extensive experience with Functional, GUI, Database, Stress, Volume, Regression, Load and Performance Testing.
• Highly proficient in SQA methodologies for Waterfall, Agile.
• Excellent verbal, written and analytical skills. Self motivated with strong work ethics.
• Strong planning and problem solving skills.
• Experienced in working in a team or independently.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2000/XP/NT/98/95

Databases: Oracle, Teradata

DB Tools: TOAD, SQL Assistant, Teradata Manager

Programming Languages: SQL, PL/SQL, Java Script, VB Script

Reporting Tools: Brio, Hyperion Solutions (9.3), Interactive

Reporting 11,Microstrategy 8.12:

Version Management: PVCS and CVS

Test management Tools/: Rational Test Manager, HPQC/ALM

Testing, Defect Tracking: Load Runner 8.x/9.x, Win Runner, Quick Test Professional, Test Complete, Test Director, Rational Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Westminister Co

Analyst/Developer

Responsibilities:

• Creating and managing Users, Role, Permission set, Profiles, Sharing Rule, Validation Rule, Applications, Objects, Records Type, Page Layouts, Custom Fields & application, Data Type, Fields Accessibility, Apex Data Loader, Command line Data Loader, Sales force API, Data Migration.
• Lead automation
• Opportunity automation
• Sales and Forecasting
• Document Automation
• Email Automation
• System Integration
• Testing and validating the entire Applications including the Objects, Fieds, Fields Accessibility, Data, Records, Page Layouts, Custom Fields, Data Type, Users, Roles, Permission set, Profiles, Sharing Rule, Validation Rule etc.
• Manage salesforce deployments
• Test case preparation, execution

Confidential

Responsibilities:

• Creating and managing Users, Role, Permission set, Profiles, Sharing Rule, Validation Rule, Applications, Objects, Records Type, Page Layouts, Custom Fields & application, Data Type, Fields Accessibility, Apex Data Loader, Command line Data Loader, Sales force API, Data Migration.
• Loan Application integration
• Borrower, Asset, Employment, Governance, Declaration and other aspects of Mortgage process automation
• Integration with custom Loan Origination system
• Testing and validating the entire Applications including the Objects, Fieds, Fields Accessibility, Data, Records, Page Layouts, Custom Fields, Data Type, Users, Roles, Permission set, Profiles, Sharing Rule, Validation Rule etc.
• Manage salesforce deployments
• Test case preparation, execution

Confidential, OH

QA Analyst

Responsibilities:

• Involved in the Analysis of the Business requirements, test planning, test case development, and test execution
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stake holders can understand the business process.
• Worked as a QA analyst for testing Facets and Membership solution web application.
• Preparing test requirements, Test Plan approach document and Test Cases
• Prepared test data as per requirements specifications document
• Set up test environment and conducted execution as per approved test cases and procedures
• Performed extensive Manual Testing to verify the application is complete and stable
• Performed data validation and testing extensively by using SQL queries including multi-table joins, aggregate functions and sub-queries
• Generated scripts for Automated Testing using QuickTest Professional
• Enhanced test scripts by inserting GUI checkpoints and Synchronization points
• Performed parameterization and correlation on data values
• Tested the application for web functionality, and verified online modules for broken links and orphan links
• Executed, analyzed, and verified test results and worked with developers to resolve issues
• Coordinated with the programmers for finding the application flow.
• Tested that the application can enable you to receive, store and send HIPPA standard transactions and facilitates the administration of HIPPA privacy rights.
• Performed Regression Testing and updated test assets periodically
• Prepared Requirement Traceability Matrix (RTM) to establish trace ability between requirements and test cases and procedures
• Generated weekly QA reports using TestDirector

Environment: Quick Test Professional, Quality Center/ALM, Oracle, Java, XSL, XML, HTML, SoapUI, Windows 2000, MS Office, Project and VISIO.

Confidential, Englewood

Developer/Analyst (SME)

Responsibilities:

• Requirement analysis
• Report design and development using SQL, PL/SQL and Interactive Reporting Studio
• Unit testing, System testing and release
• Publish, Schedule and Run Reports using EPM Portal
• Gather requirements and design docs from Business Analyst and Design team for System and UAT
• Participate in preparing the Test Plan, Test strategy, Test cases and Test Scripts for Regression, Integration System and UAT
• Managing all phases of testing for assigned components ensuring test plans and test cases are completed and met business requirements.
• Responsible for manual testing of the application to match with application requirements and write user manuals for EPM Portal.
• Generated test execution reports and release status assessment report using Rational Clear Quest.
• Facilitated meetings between Stakeholders, DBAs, other Developer and with multi-functional team to identify and resolve issues, and integrate system enhancements.
• Worked closely with end-users to develop a detailed understanding of the opportunities for improvement and functionality, detect bugs and resolve them, provide feedback and improve the entire development process.
• Designed quality center test lab and test sets for easy tracking of overall test process for UAT
• Prepared and executed Test cases according to the specification using QTP
• Reviewing the documents to verify the functional coverage and types of testing like Acceptance, Smoke, Integration, Load, Stress, Regression etc.
• Setup the test environment for System and UAT
• Analyze and clarify business request and specifications.
• Perform Functional, Integration, System and Regression Testing to check the stability of the Application
• Participate in the project status review meeting
• Analyze Test Results and Reported Bugs using QC

Environment: Hyperion IR, EPM, HPQC, QTP, Rational Clear Quest, DOORS, SQL Server, Windows, IE, QTP, XML, Java J2EE, Oracle, SQL, PLSQL, MS VISIO, MS Project, and MS Office.

Confidential, Englewood, CO

Developer/Analyst

Responsibilities:

• Requirement analysis
• Report design and development
• Unit testing, System testing and release
• Coordinating with Testing and Business team
• Developed and Tested numerous month end reports for the Accounting (Programming Payments, Tax).
• Developed and Tested reports for the Sales tax team that will help them claim money for equipments that have been re deployed.
• Developed and Tested reports for the Marketing, Internal Audit and Corporate Management Program.
• Tune queries and develop generic queries so that they can re use when needed.
• Thorough knowledge of the various databases and the data and how they can be manipulated to produce meaningful reports for the business.
• Modeled the business rules into a functional star schema database design and data modeling.
• Extensively used SQL Query, Joining tables, SQL functions in Queries.
• Responsible for creating test scripts, setting up QA data for various scenarios, tracking the QA defects.
• Having interacted closely with the various business units, I understand their requirements and am able to suggest ways to develop reports that would be more useful to the business.
• Trouble shooting, analyzing reports that do not produce the expected results and finding solutions or work around for them.
• Widely used Database objects like Views, Indexes, Stored Procedures, synonyms, Triggers and Global Links for reducing the load on ETL tools.
• Prepared Test Scripts, Test Cases based on requirements and functional specifications
• Performed the System Test Cases and verified actual results to expected results
• Performed Backend testing by using SQL on Teradata database for validating & retrieving the data used for various testing scenarios.
• Performed data driven testing for necessary data required for applications.
• Prepared Regression Testing suite of automated QTP scripts to do the Regression Testing and Build Acceptance Testing.
• Performed field validation with the data in the DB2 Database to make sure whether the application is pulling the correct data or not.
• Load all the function libraries using Library functions in QTP utilities.
• Created and executed various SQL quires for data and table structure changes.
• Created the test data for system testing, regression and UAT using EXCEL.
• Performed System, GUI, Integration, Functional and Regression Testing.

Confidential, Englewood

QA Analyst

Responsibilities:

• Developing test cases by analyzing the requirement specifications for functionality and regression testing and execute them against new builds.
• Test Trouble Tickets, Change Requests and Enhancements.
• System, UAT, Regression and Performance test.
• Performing back end data validations using SQL Server to ensure the expected configurations exist in the standard list of configuration tables in our system called NEPTUNE.
• Validating the feasibility of a new Call Plan or new Market by creating new Accounts and Telephone Numbers and assigning usage by going through all the transaction processes ( Confidential Digital Voice processing) right from the Switch to the billing including Mediation, Pricing and Billing using End to End Testing method.
• Submitting and Managing bugs in defect tracking tool. (Test Director)
• Worked closely with Development and Product / Project Management for the timely resolution of defects and verify defect fixes.
• Used to attend requirement discussion, design discussion, status update meetings and the Lesson learned meetings for various projects.
• Creating Data for System testing and User Acceptance Testing.
• Helping Users to understand the implementation of new interfaces and enhancements

Confidential

Responsibilities:

• Performed requirements and design inspection with Business user group and implementation groups.
• Created Master Test plan and release test plan, Test environment/data setup specs for Migration testing.
• Reported status to higher management during various phases of the Testing life cycle.
• Derived testing requirements from the functional, system and design specification.
• Responsible for creation of integration test plan, data mapping documents etc.
• Provided integration status updates and follow-ups with external vendors as well as internal stakeholders.
• Interacted with user groups, Business Analysts, vendors to understand detailed technical/business process flows, managed testing assets in Test Manager and Quality Center
• Created Requirements matrix, Use case in order to analyze and test critical areas of application, organized several brain storming sessions with Business Analyst and Clients in this process.
• Created Integration and System Test plans with SDLC standards, which adequately exercise functioning of the system and its various components are appropriately created and executed.
• Tested positive and negative testing for the rules associated with committing application
• Developed complete Test cases and scenarios including data required to adequately and thoroughly Test complex solutions on multiple operating platforms and appropriately consider, conceive, and apply technical Testing across multiple operation environments.
• Used Test manager and DOORs to maintain use case vs. test case requirements traceability matrix.
• Performed Black box, Functional Testing, GUI Testing, web Testing using Win Runner and Quick Test Pro. Performed end-to-end system Testing.
• Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases.
• Managed defects through Clear Quest defect tracking. Assigned defect priority, follow up and retest defects over builds
• Created Risk Assessment document based on defect matrix to assess the risks associated in production environment.
• Created, maintained, and updated Testing documentation and deliverables with CMM standards.
• Worked closely with the Developers, Users, Business Analysts, and Users during all Testing phases. Obtain through understanding of functional business concepts and specific knowledge of the business/ technical processes. Suggested process improvements.
• Created technical document with all performance details based on requirements presented to project management and performance maintenance team.
• Created test coverage analysis Reports using Test Director for UAT

Confidential

Responsibilities:

• Involved in assisting the QA Lead and participated in planning and organizing the test schedules and test cases.
• Designed and executed Test Plans and Test Cases based on business requirements using the Citizens Standards. Executed Test Scripts and different Test scenarios.
• Developed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements.
• Involved in functionality testing, Integration testing, Smoke testing, Black Box testing, Usability testing and Regression.
• Prepared Test Cases document.
• Prepared the Requirement Traceability Matrix that maps the functional/business requirement to the test cases.
• Responsible for Functional (Progression) Testing for the release.
• Performed Regression testing on various modules.
• Responsible for conducting different level of reviews of Test Suite and get sign-offs.
• Performed Backend Testing using complicated SQL Queries and to test the application for business rules in huge volume of data.
• Co-ordinate with the Business Analyst to understand and implement the testing as per the business requirements.
• Supported in preparing Mock Data for Test Bed. Helped to identify the data required.
• Tested CSG and AMDOCS account interfaces by sending test transactions through SoapUI to the Interface and validated the results.
• Performed Product Acceptance Testing.
• Assisting the team with issues and support for testing.
• Involved in doing System testing of applications along with team members
• Verified and validated fixed bugs.
• Tested the application manually and reported and tracked the defects through the Test Director.

Environment: All the user interfaces developed in Java//J2EE/XML framework with SQL Server as back end and Web logic as the Application server. SoapUI for Web service functional testing.

Confidential, Aurora, CO

QA Analyst

Responsibilities:

• Test case preparation and Test design.
• Requirement mapping against test cases using Rational tools.
• Execute test cases by manual and automated process.
• Preparation and Execution of Test Cases
• Involved in Functionality testing, Integration testing, Smoke testing, Black Box testing, Usability testing and Regression.
• Performing User Acceptance testing
• Involved in doing System testing of applications along with team members
• Verified and validated fixed defects
• Test reporting and Bug Tracking.

Environment: All the user interfaces are developed in Java//J2EE framework with SQL Server as backend and JBoss as the Application server.

Confidential

QA Analyst

Responsibilities:

• Write test documentation including test suites, test cases, checklists, etc.
• Persistent in localizing software defects and make them reproducible.
• Involved in assisting the QA Lead and participated in planning and organizing the test schedules.
• Designed and executed Test Plans and Test Cases based on business requirements.
• Executed Test Scripts and different Test scenarios.
• Test Scenarios, for manual with some automation testing.
• Use Quality Center Application to track defects.

Environment: ASP, Microsoft Interdev, VB Script for the front end development and Oracle as the backend Database server.

Confidential

QA Analyst

Responsibilities:

• Write and execute SQL queries for data validation.
• System test case preparation and testing.
• Set up and staged test data for all testing purposes and validated the results to conform functionality to requirements.
• Performed Positive and Negative Testing to ensure appropriate user authentication.
• Developed and Maintained Test Matrix to reflect the test progress