SUMMARY:

• Over Eight years of experience in Software Development and Quality Assurance in Web - based, SOA/Web Services, Data warehouse and Client/Server applications
• Experience in writing Test Plans, defining Test Cases, developing and maintaining test scripts, creating test data, analyzing bugs, interacting with development team members in fixing errors
• Expertise in both manual and automated testing
• Strong experience in QA Methodologies (Waterfall and AGILE) and Structure Testing
• Expertise in testing Web Services using SOAP UI
• Proficient in all forms of testing including Functional, Integration, Performance and User Acceptance Testing
• Experienced in using automated tools like Selenium, Quick Test Pro, Win Runner, Quality Center, Version One, Informatics and Rational Suite
• Extensively used SQL queries for back end testing, Data Verification, Data Analysis and while data are being transferred between the front end and the back end database server
• Experience in testing of various relational database applications like DB2, Oracle, SQL Server
• Extensive Knowledge and experience in Managing Large Projects involving Onsite-Offshore Delivery Model
• Highly motivated, organized and detail-oriented individual with excellent communication and documentation skills

INDUSTRY EXPERIENCE:

Telecom(IP networking, OAM&P, Switching, troubleshooting, PSTN, layer 2/3 protocols overview/Transmission Technology, IP, POTS, PRISM, CVoip and Broadband-HSI), Banking/Financial, Retail, Insurance, Health Insurance

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro, WinRunner, Quality Center, Selenium, Rational Suite (Test Manager), Version One

Bug Reporting Tools: Clear Quest, TestDirector, PVCS, Quality Center

OS390, Windows 2000/98/NT, HP: UX, LINUX, MAC OS

Programming Languages: C/C++, VB, JAVA, SQL, Perl, JCL, COBOL

Databases: DB2, Oracle 12.1, SQL Server 7.0/2000, MS Access

Web Technologies: HTML, XML, JSP, Java, VB.net, ASP.net

Methodologies: RUP, XP, Waterfall, Spiral, AGILE

Scripts: VB Script, JavaScript, SQL Script

Packages: FrontPage, Adobe (PageMaker, Illustrator, Acrobat, PhotoShop), MS Publisher, MS Office

Others: TOAD, SQL Query Analyzer, AQT, XML Spy, SOAP Scope, SOAPUI, PUTTY, WIN SCP, Ultra Edit, Clear Case, Version One, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Data warehouse Analyst

Responsibilities:

• Participate in the project life cycle from analysis to production implementation, with emphasis on system test plans, execution, analysis and results
• Participate in walkthroughs of business requirements and design specifications for the projects
• Involved in writing the Test Plans, Detailed Test cases, Test Summary Reports based on Business Requirement Documents and Design Specifications and Data model diagrams
• Detailed understanding of design specifications documents, Load Documents, S to T mappings, Transformation rules documents and Data Models
• Involved in detail understanding of Star Schema and Snow Flaked architecture
• Involved in Extensive testing of Type I and Type II Dimension tables and Fact tables
• Conduct system testing from Landing Zone (LZ) to Data Warehouse to validate data for table loads, element level transformation rules as specified in design/load documentation and source target mappings
• Production support- Run Informatica jobs and Validate results after deployments
• Service Tickets- Involved from IT analysis, Code Fix, Testing, CAB(Pre-Prod), Prod
• Extensively used simple and complex custom SQL queries to test the data and the transformation rules and table load rules from Source to Target tables
• Extensive testing has been performed on Current, history tables and Fact tables
• Involved in various kinds of testing like System Testing, Regression Testing, Smoke Testing, and Post-Implementation Testing
• Coordinated with Offshore Teams during the Testing Process
• Test Cases and Test Execution and Defects are maintained in the Quality Center tool
• Trained other members of the Quality Assurance team on the application and processes
• Involved in Daily SCRUM meetings and AGILE/Scrum Methodology for the overall Project
• Involved in requirement meetings to understand the functional requirements and enhancements to the existing requirements and participated in bug review & Go/No Go meetings

Environment: Version One, Toad, Query Surge, Informatica, MS Excel, MS Word, Oracle DB, Windows, XMLSPY, XP/2000/NT, MS Visio, PL/SQL, AGILE/Scrum Methodology, Stored Procedures, SQL, IDM/ADM, TIBCO, Advanced Query Tool(AQT), IP Switch WS FTP 12

Confidential, MN

QA Lead

Responsibilities:

• Creates data and metric systems to track operational workflows; maintains records of results and feedback. Analyzes data and metrics, identifies problem areas, and provides actionable insight to management.
• Provides input to Engineering and vendors on defects and required enhancements.
• Contributes to design considerations for new products or architectural changes to existing products. Assists with or leads efforts to build new application infrastructure, coordinating efforts across teams.
• Analyses problems in design, configuration, data flow, and data state within a highly complex multi-product provisioning system.
• Expertise in Software Development Life Cycle and Software Testing Life Cycle which includes Requirement analysis, system integration and Team Building.
• Planning, coordinating and performing Integration Testing, Validation Testing, Functionality Testing and Regression Testing, Database testing, Performance testing, Soap UI testing, GUI testing, User Acceptance Testing including Back-end and Front-end testing.
• Developed and documented Testing Strategies for Manual and Automated testing.
• Extensively worked on backend testing and well versed with SQL, PL/SQL queries to run the data integrity test.
• Involved in data driven tests using SQL queries to extract data from different databases and their verification.
• Automation testing using tools like QTP for functional and regression testing of the application.
• Actively involved in design review calls at the time of requirement gathering, design and analysis.
• Assisted the Systems Engineer and Business Analysts with modeling the requirements.
• Worked close to business in the process of HD ticket validation and support.
• Analyze the application data needs and support the test team for all the system data needs.
• Worked with different interfacing teams to solve the system integrity issues there by identifying the gaps in the IT requirements.
• Activity worked in the CCB process of requirements that are de-scoped for future releases.
• Defined the test approach and thus ensured the successful implementation of the test cycle.
• Assigned to own, lead, & direct the entire project for a Rx Test Team HSI module.
• Communicated with Project manager in regards to the status, issues and Making sure of providing the detailed estimates (LOEs) on time.
• Coordinated the testing activities, review and signoff
• Supported the UAT, Inter system and E2E testing
• Before the release deployment verified the test exit criteria and provided the test summary to the clients.
• Responsibility as the single test point of contact:
• Owned the total testing for the application.
• Able to understand the functionality of the total application and developed the test cases for the application in order to perform the regression testing on the total application.
• Responsible to update the test status to test manager and application project manager on timely basis.
• Able to work with the development team, to get enough hold on the application.
• Provided the test summary to the clients and ensured the successful implementation of the application.

Environment: Oracle 9i, Oracle 10g, Quality Center, Microsoft Office suite, PLSQL, TOAD

Confidential, Minneapolis, MN

Sr. QA Analyst

Responsibilities:

• Conducted several walkthrough meetings with business analysts and developers to analyze requirements.
• Developed Test Plans and Test Cases based on the Functional specification (FSD) and Business Requirements (BRD) documents.
• Involved in the creation and execution of test cases using Quality Centre
• Used Quality Center and clear quest for defect life cycle
• Tested different Web Services by using Soap UI tool.
• Tested various web service applications, Check cashing transactions, Check deposits, Check holds, Global remittance and International funds transfers..
• Validated the soap xml requests and responses by using the schema mapping documents.
• Validated the client sent transactions by using various tools like WIN SCP and PUTTY.
• Performed testing of different environments by running the automated test cases using QTP.
• Coordinated and efficiently worked with Off-Shore team
• Lead an offshore Team of testers to execute Test Scripts
• Extensive Knowledge and experience in Managing Large Projects involving Onsite-Offshore Delivery Model
• Involved in test data preparation for Positive/negative scenarios.
• Performed functional testing, backend testing, black box testing, Integration testing, regression testing and User Acceptance testing
• Developed various Test scripts to make System testing easier
• Developed a detailed report of the results for future releases as per client’s request
• Participated in Regression Testing after each build

Environment: XML, XML SPY, JSP Test Tool, Putty, WIN SCP, SOAP UI, QTP, Hogan (Main Frames system), CICS, COBOL, QC, UNIX and Visual Basic

Confidential, Minneapolis, MN

Sr. QA Analyst

Responsibilities:

• Involved in creation of High Level System Test Plans, Test Strategies, Test Approach by reviewing Business Requirement Document (BRD’S), Technical/Design Specification Documents and participated in the business requirement and Design Walkthrough sessions
• Involved in Software Development life-cycle and Test Life Cycle of the project from requirements gathering to transition using Agile/Scrum Methodology
• Managed requirements and Developed Test Cases, Test Execution and Defect Remediation using Quality Center
• Maintained Traceability Matrix using Quality Center
• Documented Test cases corresponding to business rules and other operating conditions in Quality Center
• Created or Stimulated Mocked Up/Test Data to perform end to end testing
• Tested the backend database by creating complex and simple SQL queries
• Involved in testing the System Integrity and Data Integrity of the application.
• Responsible for GUI Testing, System Testing, Exploratory, Regression Testing and Acceptance Testing
• Reported the bugs, Email notifications to the developers using Quality Center
• Interacted with Developers, BA’s and other team members within planning project for insights of the programs and in understanding the user’s needs for the testing standpoint
• Investigate software defects and interacted with developers to resolve technical issues.

Environment: Mercury Interactive Tools (Quality Center 9.0), AGILE/SCRUM, SQL, Oracle, AQT (Advanced Query tool), Java, Swing, Java script, HTML, XML, RIB, Windows XP and UNIX

Confidential, Minneapolis, MN

Data warehouse Tester

Responsibilities:

• Participate in the project life cycle from analysis to production implementation, with emphasis on system test plans, execution, analysis and results
• Participate in walkthroughs of business requirements and design specifications for the projects
• Involved in writing the Test Plans, Detailed Test cases, Test Summary Reports based on Business Requirement Documents and Design Specifications and Data model diagrams
• Detailed understanding of design specifications documents, Load Documents, S to T mappings, Transformation rules documents and Data Models
• Involved in detail understanding of Star Schema and Snow Flaked architecture
• Involved in Extensive testing of Type I and Type II Dimension tables and Fact tables
• Conduct system testing from Landing Zone (LZ) to Data Warehouse to validate data for table loads, element level transformation rules as specified in design/load documentation and source target mappings
• Extensively used simple and complex custom SQL queries to test the data and the transformation rules and table load rules from Source to Target tables
• Extensive testing has been performed on Current, history tables and Fact tables
• Involved in various kinds of testing like System Testing, Regression Testing, Smoke Testing, and Post-Implementation Testing
• Coordinated with Offshore Teams during the Testing Process
• Test Cases and Test Execution and Defects are maintained in the Quality Center tool
• Trained other members of the Quality Assurance team on the application and processes
• Involved in Daily SCRUM meetings and AGILE/Scrum Methodology for the overall Project
• Involved in requirement meetings to understand the functional requirements and enhancements to the existing requirements and participated in bug review & Go/No Go meetings

Environment: Mercury Quality Center, SQL Server Management Studio, SSIS, SSRS, SQL Server, SAS Reports, MS Excel, MS Word, Oracle DB, Windows XP/2000/NT, MS Visio, PL/SQL, AGILE/Scrum Methodology, Stored Procedures, SQL, Peoplesoft