SUMMARY

• 10+ years of experience having performed the roles of QA Analyst, Application Support Analyst, Programmer and Onsite Coordinator
• Good understanding of Software Test Methodology and Software Development Life Cycle
• Experienced in handling business critical applications
• Experienced with handling teams in Offshore/Onsite models
• Experienced in testing of GUI/Web based, Workstation based applications, Cognos Reports and ETL testing
• Proficient in Functional, System, Integration, Regression, Implementation, User Acceptance testing
• Strong skills in backend Database testing using SQL queries
• Performed Web Services testing using SoapUI and inhouse - built Web Service Launcher tool
• Experienced in analyzing Business/Functional requirements
• Involved in preparation of Test Strategy
• Experienced in creating Test Plans, designing Test Scenarios and Test Cases, and Test Execution
• Experienced in Defect Management
• Quick learner and ability to quickly adapt to new functions/areas/domain
• Results oriented with the ability to handle multiple projects and meet deadlines
• Ability to perform consistently within a team and as an individual contributor
• Good team player with strong communication, coordination, analytical and interpersonal skills

TECHNICAL SKILLS

Operating Systems: Windows 7.0

Languages: VB, ASP, HTML, Javascript, SQL

Database: DB2 on UNIX/LINUX/Mainframe

Test Management Tools: DOORS

Defect Tracking Tools: TRAC

Reporting Tools: Cognos 10.x

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

QA Test Analyst / Application Support Analyst / Cognos Developer

Responsibilities:

• Primary Test and Support Analyst for COT and CTS workstation apps and CTS Cognos reports
• Primary Test Analyst for CIMS and ORT web applications and corresponding Cognos reports
• Resolved problem calls and queries from business partners
• Analyzed issues and provided solutions. Coordination with infrastructure support areas, as needed, to resolve issues
• Interaction with business to understand the requirements and prepared high level approach/design document
• Coordinated with developer for COT and CTS application enhancements/defect fixes
• Provided database design changes, developed a database stored procedure, defined database triggers and database sequence objects for CTS enhancements
• Developed a new Cognos report for CTS enhancements and modifed existing ORT Cognos reports that includes drilldown reports, prompts, and report SQL queries
• Involved in creation of Test Strategy and Test Plan
• Designed Test Cases based on the requirements and worked with the team to verify the Test Cases
• Tracked the Requirements Traceability Matrix to ensure that all the requirements are covered by the test cases
• Created Test Data according to test scenarios
• Executed the Test Cases, managed the Defects, communicated Testing and Defect status to the project
• Followed up with the developers to discuss the defects identified during testing
• Performed backend database testing by running SQL queries
• Performed testing of COT web service
• Performed testing of ORT and CIMS web apps for browser upgrades
• Performed Regression testing of applications for infrastructure/browser updates and as needed
• Assisted in gathering Business Volume Metrics and coordinated with performance team for performance testing
• Coordinated User Acceptance testing with business
• Coordinated with Database/Cognos support areas to implement the database/reports changes in production
• Performed Implementation testing, Production implementation checkout and verification

Environment: .Net, DB2 on Linux/Mainframe, Cognos 10.x/8.x

Confidential

QA Test Analyst / Application Support Analyst / Onsite Coordinator / Cognos Developer

Responsibilities:

• Worked with the project business analyst to create the detailed requirements document
• Provided database design changes to handle ASR Fire salvage data
• Modifed Cognos reports to handle ASR Fire salvage data
• Provided application functional knowledge to the offshore team & resolved their queries
• Involved in development of Test Strategy, and created Test Plans
• Coordinated with offshore to create & execute Test Cases
• Reviewed the Test Cases developed by offshore and also got it reviewed by onsite project team
• Ensured that all the requirements are covered by the test cases
• Developed SQL queries to test the ETL process for migrating ORT data from SQL server to Mainframe database and performed ETL testing
• Performed System testing, web services testing for both ASR & ORT apps, testing of ASR Cognos reports
• Performed backend database testing by running SQL queries
• Logged defects, followed-up with development team to fix the defects and bring it to closure
• Provided testing status to the project on a regular basis
• Coordinated with business partners for User Acceptance testing
• Performed Implementation testing, Production implementation checkout and verification

Environment: Java/J2EE, Cognos 8.x, DB2 on Linux/Mainframe

Confidential

QA Test Analyst / Onsite Coordinator

Responsibilities:

• Participated in Requirements gathering sessions
• Assisted Test Coordinator in development of Test Strategy document
• Created Test Plans and Test Scenarios for the applications and Cognos reports
• Coordinated with offshore to complete the Test Cases for each of the test scenarios
• Ensured that all the requirements are covered by the test cases
• Worked with onsite team to review the test cases
• Coordinated test case execution with offshore & managed defects
• Provided testing status to the project on a regular basis
• Performed Integration / System testing of all the applications including external interfaces, batch jobs, Cognos reports
• Performed backend database testing by running SQL queries
• Coordinated with performance team to complete performance testing
• Coordinated with business partners for User Acceptance testing
• Performed Implementation testing, Production implementation checkout and verification

Environment: Java/J2EE, Cognos 8.x, DB2 on Linux/Mainframe

Confidential

QA Test Analyst / Application Support Analyst / Onsite Coordinator / Developer

Responsibilities:

• Supported the applications for continuous availability and monitored the application related jobs
• Resolved problem calls, queries, adhoc report requests from business partners
• Analyzed issues and provided solutions. Coordinated with infrastructure support areas to resolve issues
• Maintenance of web apps and ASR Cognos reports including defect fixes, enhancements, testing and implementation
• Understanding the client requirements and preparation of Design specifications
• Provided database design changes, modified database triggers and stored procedures for ASR changes
• Developed Test Plans and designed Test Cases
• Coordinated with offshore for design, development, test case creation and testing of defect fixes and enhancements
• Resolved offshore queries and issues and provided technical guidance as needed
• Performed System & Regression testing of web apps, Database testing, ETL testing, debugged and fixed defects
• Provided Business Volume Metrics and test data for performance testing
• Coordinated with performance team to complete performance testing
• Worked with business partners to complete User Acceptance testing
• Performed Implementation testing, implementing the changes to production and production verification

Environment: Visual Basic, ASP, HTML, Cognos 7.x reports, DB2 on UNIX

Confidential

QA Test Analyst / Onsite Coordinator / Cognos Developer

Responsibilities:

• Studied and analyzed existing application
• Interacted with business partner to clarify queries regarding the existing functionality
• Assisted Test Coordinator in development of Test Strategy document and Test Plans
• Coordinated with offshore for development and testing activities and reviewed offshore deliverables
• Developed ASR Cognos reports that included creating powerprompts
• Developed Test Cases to test the ETL process for data movement between archive and reporting database
• Performed Integration / System testing of the web application, batch jobs and Cognos reports
• Performed backend database testing by running SQL queries
• Performed ETL testing to validate data movement
• Assisted performance team during performance testing
• Assisted business partner in completing User Acceptance testing
• Performed production implementation verification and provided post-implementation support

Environment: Visual Basic, ASP, HTML, Javascript, Cognos 6.x, DB2 on UNIX

Confidential

Testing Coordinator / Test Designer

Responsibilities:

• Analyzed technical and functional specifications
• Coordinated with Onsite Coordinator in understanding the specifications and clarifying queries
• Developed Test Plan and created Test Schedule
• Coordinated with test analysts to develop Test Cases
• Ensured that all the requirements are covered by the test cases
• Reviewed Test cases, Coordinated Test Case execution and managed the defects
• Tracked and reported testing status, escalated High/Critical defects as needed, prepared Test Summary report

Environment: Visual Basic, ASP, HTML, DB2 on UNIX