SUMMARY:

Sr QA Analyst with strong testing and analytical skills having over 9 years of IT experience out of which over 3 years of development experience in the areas of mainframe and Java. Excellent experience in Quality Assurance and Application Software Testing (Manual and Automation) using Selenium, QTP and Quality center in client server distributed and n - tier web environments.

PERFORMANCE SKILLS:

• Knowledge and experience in Software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Developed and Designed test plans based on the business rules using Test Director
• Extensive experience in Bug tracking tools Test Director
• Extensive use of testing tools Quality center, Selenium
• Performed Manual and Automation testing using Test director
• Executed test cases and test procedures manually to test application functionality against user requirements performed various testing methods like Black Box, White Box, Module, Integration, Stress, Volume, System Performance and Regression
• Expertise on ETL Designing Databases, Data Warehousing (Data Marts), Dimensional Modeling, Designing of Star Schema
• Skills in Backend testing using SQL Queries on Oracle tables
• Modified queries to improved SQL query performance.
• Created, altered tables, views in the test server for testing result
• Formulated test plans for back-end Tests
• Tested data integrity of databases using Test Cases
• Strong analytical and technical skills
• Excellent communication and presentation skills with experience in the development, implementation and integration strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills

TECHNICAL SKILLS:

Methodology: Waterfall, Agile

Testing Tools: Quality center, Selenium, Rational Tools -Clear Case, Clear Quest

Languages: C, HTML, SQL, Perl Scripting, JAVA, COBOL and C#

Databases: Oracle, SQL Server 2005/2008, MS-Access, DB2

Data warehousing: Informatica, SAP BW

Reporting Tools: Business Objects

Cloud computing: Salesforce CRM

Operating Systems: Windows 2000/2003/XP/Vista, UNIX

Tools: TOAD, SQL Navigator, SQL Assistant

Scheduling: Control M

PROFESSIONAL EXPERIENCE:

Confidential

Test lead

Environment: Autosys, Control-M Work Load automation (WLA), CTLM Self-service and UNIX

Responsibilities:

• Involved in planning with application teams and testing the jobs in CTLM WLA which were migrated in different Waves
• Developed an in-depth knowledge of Control M and Self-service
• Helped application teams to understand the CTLM functionalities
• Provided post production implementation support for all Waves of migration
• Performed issue management in prioritizing the issues and assigning them
• Worked with Management and Senior Management to provide regular metrics on work levels for Leadership.

Confidential

Test lead

Environment: Salesforce, SOAP UI, Trac-Defect management and Testlink-test cases repository

Responsibilities:

• Worked as Systems Analyst and responsible for gaining an in-depth understanding of the CRM Salesforce business processes and managing the overall test planning and execution efforts for Customer Management tower
• Reviewed all business and technical requirements
• Developed an in-depth knowledge of Customer Management capability
• Defined and authored test cases for Customer Profile, Customer P, Customer Inquiry and Event triggers capabilities
• Prepared and provided test data requirement to the State Farm Test Data Team for System test requirements
• Provided base data for the daily test metrics/status report
• Worked with the offshore team to transition knowledge and assist with day to day activities

Confidential

ETL Test lead

Environment: Informatica, MS Access/SQL and SAS MOM

Responsibilities:

• Worked closely with business partners to understand the requirements for data migration
• Involved in designing the test cases for migrating the assets from taking source from various legacy systems to SAS MOM tool
• Involved in data cleansing and load them into Access database for executing the tests
• Worked with Informatica developers to close any requirements gap
• Loaded the marketing assets into Development, System and performance environments for system, UAT and performance testing

Confidential

Test Architect

Environment: Web Services (SOAP over HTTP), ESB, Curam, ODI

Responsibilities:

• Prepared a detailed technical design document for the interface
• Reviewed functional and detailed designs for the interfacing applications to understand the business needs for each interface
• Prepared high level test conditions for the interface
• Walkthrough the test conditions with state business to get the approval
• Prepared the test scripts based on the conditions
• Worked with testing members for peer review
• Reviewed the scripts with business to get final sign-off

Confidential

Sr QA Analyst

Environment: XML, J2EE, Selenium, Windows2000/2003/XP/Vista, UNIX, TOAD, SOAP and web service

Responsibilities:

• Review Business requirements with business and prepare a test Plans for all the features/functionalities specific to each iteration
• Involved writing Test cases
• Involved in manual and automated test scripts.
• Involved in Analysis, document, verify and manage defects, enhancements, and new features in the system change request.
• Pro - actively report critical issues and risks to management.
• Involved in creating reports and metrics
• Involved in complete regression testing for all the previous iterations
• Worked closely with the developers and Analysts in finding out a solution for any test defects
• Perform SQL for data verification
• Involved in testing code in all Environments like Smoke, functional and Regression

Quality analyst/lead

Confidential, IL

Environment: J2EE, Cobol, JCL, SPUFI, Expeditor, CICS, IDMS, TOAD, SQL, J2EE, XML, JSP, Junit Test Director, Windows XP, UNIX, Visual Source Safe, Bugzilla, informatica, Cognos, QTP and Quality center

Responsibilities:

• Evaluate d the requirements for testing and design, develop test plans and cases based on the business/software requirements
• Participate d in design review
• Document ed the mapping of test cases to requirements in Quality test center
• Create d regression test plan/cases
• Cleanse d and load ed the data using informatica
• Execute d smoke, functional and regression test cases
• Created SQL queries to create adhoc reports for the user needs
• Document ed the defects in QTC and create defect metrics for review
• Develop ed QTP scripts and execute them for regression and functional tests
• Modif ied the QTP scripts for additional test coverage
• Experienced in planning, estimating and scheduling of tasks using MS Project
• Creat ed reports using SQL queries thru SPUFI in mainframe environment
• Assign ed work to team members, tracking and reviewing the work products
• Coordinate d to migrate code to test and development environments
• Follow ed the change management processes to deploy code to production environment
• Consolidating the status reports on weekly basis
• Mentoring and coordination team for the successful test deliverables on time