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
• Has good experience as a UAT Coordinator in leading the team, troubleshooting the issues, guiding the team members in error handling and problem fixing.
• Extensively worked on Informatica and Datastage.
• Strong Experience in using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Strong Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Experience in testing Cognos Applications and ETL processes, Provided extensive End-User Training and Support for Cognos report testing
• Good understanding and hands on experience on various prompts (Cascading Prompts), filters, conditional formatting, and conditional blocks according to the report specifications.
• Tested 100+ reports for various sectors i.e., Audits, Outstanding, Dealer Performance, Risk, Review
• Good understanding on Cognos models and data elements in COGNOS Frame Work manager
• Excellent knowledge in testing database objects like Stored Procedure, Views, packages, functions and Triggers using PL/SQL.
• Ability to prioritize multiple tasks.
• Self-motivated and able to work independently and as a member of a team
• Experienced in using automated tools like Quick Test Pro, Win Runner, Quality Center, Query Surge 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, Switching, troubleshooting, 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, Win Runner, Quality Center, ational Suite (Test Manager), Version One, Query Surge

Bug Reporting Tools: Clear Quest, Test Director, Quality Center

Windows 2000/98/NT, HP: UX, LINUX

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

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

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

Methodologies: RUP, XP, Waterfall, Spiral, AGILE

Scripts: VB Script, JavaScript, SQL Script, ICM Script

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

Others: SQL Query Analyzer, AQT, XML Spy, SOAP Scope, SOAPUI, PUTTY, WIN SCP, Ultra Edit, IBM Lotus Notes, CAD(Cisco Agent Desktop), Site Core

PROFESSIONAL EXPERIENCE:

Confidential, MN

QA Portfolio Lead

Responsibilities:

• Actively involves in design review calls at the time of requirement gathering, design and analysis on call flows, IVR prompts and Msg, CRM data collection requirements and reporting requirements
• Create 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
• Analyze the Confidential data needs and support the test team for all the system data needs.
• Data validations in source entities E-ODS, Call center wrapper to CSV files by writing complex SQL queries using data mapping docs
• Work with different interfacing teams to solve the system/data integrity issues there by identifying the gaps in the IT requirements.
• Analyze and validate customized Cognos BI reports linking various databases, to meet the user requirements
• Good understanding and hands on experience on various prompts (Cascading Prompts), filters, conditional formatting, and conditional blocks according to the report specifications.
• Validated various reports including List, Grouped List, Cross tab, Combinational Chart and Drill -Through Reports.
• Assigned to own, lead, & direct the entire project for Confidential call recording and call management team. Communicating with Project manager in regards to the status, issues and making sure of providing the detailed estimates on time.
• Demo the functionality to UAT and coordinates to support UAT testers during UAT phase
• Prepare test summary report and give sign off per Software Engineering Process
• Analyses problems in design, configuration, data flow, and data state within a highly complex multi-product provisioning system.
• Develop frameworks for automating the secure site website that involves the product info and One web authentication tests
• 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.
• On-shore/off-shore coordination to track the progress of the testing and defects

Environment: IBM Lotus Notes, Clear Quest, MS SQL server, SOAP UI, MS Visio, MS Excel, MS Word, Oracle DB, Windows, XMLSPY, XP/2000/NT, PL/SQL, AGILE/Scrum Methodology, Stored Procedures, CAD(Cisco Agent Desktop), Nice Recorder(Cyber Tech), Cognos, Sales Force, Site Core, QTP,MFT

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 Confidential 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 Confidential 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.
• The script was developed using data driven framework and implemented them successfully in the project. It saved a lot of regression effort in the project.

Environment: Oracle 10g, TOAD 9.7.2.5, Quality Center 10, Borland Caliber RM tool, Para soft SOA tool, Java script, Microsoft office suite, PLSQL, XML, Load runner, Web services.

Confidential

Technical support

Responsibilities:

• Analyze the user requirements from Caliber and interact with system architect, developers, business analyst and customer to identify gaps in the requirements to arrive at clear and correct requirements
• Perform estimation of effort for every release
• Responsible for timelines and quality of deliverables. Prepare the system test plan
• Risks and Issue Management
• Involved in project review meetings and weekly QA Managers meetings
• Review test cases and scenarios in ALM
• Map the test cases in Quality Center to the corresponding user requirements in Caliber for traceability and test coverage
• Perform sanity testing and environment health check for each build delivered
• Perform system, intersystem and regression testing
• Prepare test metrics and overall status tracking and monitoring
• Onshore offshore coordination
• Demo the functionality to UAT and coordinated to support UAT testers during UAT phase
• Prepare test summary report and give sign off per Software Engineering Process
• JUNIT entity is being used to develop the automation script.
• Developed a hybrid framework. At the end of the script the results will be updated in result sheet.

Environment: SQL Server 2005, Oracle 11g, TOAD, Quality Center 11 (ALM tool), Borland Caliber, Para soft SOA tool, Microsoft office suite, PLSQL, T SQL, XML, Java script, Load runner, Web services.

Confidential, Minneapolis, MN

Data warehouse Analyst

Responsibilities:

• Conducted several walkthrough meetings with business analysts and developers to analyze requirements.
• Detailed understanding of design specifications documents, Load Documents, S to T mappings, Transformation rules documents and Data Models
• Developed Test Plans and Test Cases based on the Functional specification (FSD),Business Requirements (BRD) documents, Design Specifications and Data model diagrams.
• Involved in creation and execution of UAT test artifacts, test documentation and reporting.
• Involved in developing a requirement traceability matrix to ensure that all business requirements are covered within the test cases in test environment.
• Participate in the project life cycle from analysis to production implementation, with emphasis on system test plans, execution, analysis and results
• 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
• Test Cases and Test Execution and Defects are maintained in the Quality Center tool
• 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: Toad, Informatica 9.5, AQT, SQl server management studio, Clear quest, TIBCO MFT file transfer, XMl, SOAP UI, Unix

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 Confidential .
• 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

Software Engineer

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.
• Extensive Knowledge and experience in Managing Large Projects involving Onsite-Offshore Delivery Model. Coordinated and efficiently worked with On-Shore/Off-shore teams
• 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
• 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 Detailed Test cases 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
• 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
• Test Cases and Test Execution and Defects are maintained in the Quality Center tool
• 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, People soft