Qa Tester/analyst Resume
Irving, TX
Summary:
- Over 7 years of total IT experience in Business Analysis and QA Testing.
- 7 years of IT experience in Business Analysis, White and Grey Box Testing in the role of Test Analyst and also experienced in analysis related to Business Intelligence projects.
- Handled, monitored and guided Black and Grey Box Testing for OSS Systems Provisioning, Wire line Automations, Oracle Apps R12 CRM, Kenan FX, CITRIX, Order management, Mediation for Postpaid and Prepaid systems, Document Management System, POS (Point of Sale) and e-commerce for Prepaid and Postpaid systems.
- Very good at Network testing of switches, routers and Intelligent Network platforms
- Experience with Web application testing on Java based applications and SharePoint Server 2010
- Experience in Data Validation and ETL testing tool SSIS
- Experience working on SSAS for cube validation, Pivot tables
- Good experience in Test Management and client Coordination, mentoring new joiners and junior team members
- Good with Requirements gathering & Documentation, Data Analysis/Mappings andunderstanding Business Processes.
- Experience in use case diagrams, E-R Diagrams, Activity and state diagrams and documenting business requirements
- Good with performing gap analysis, co-ordination of meetings with clients and technical teams
- Proficiency in Test Processes and writing test plans, test cases, defect reporting, debugging and documentation
- Expert in Software Testing Methodologies, Agile process and Water models
- Good with discovering identifying troubled areas and suggest solutions.
- Good understanding of business intelligence concepts and concepts related to reporting tools such as SSRS, WebFOCUS and Tableau.
- Experience in writing complex SQL queries for data analysis and testing.
- Expertise in Impact Analysis for the requirements, identifying scope, estimating effort, designing test strategy for testing, project monitoring, co-ordination and follow-ups.
- Excellence in analysis of existing systems; risk and feasibility analysis for planned systems
- Good at performing RCA (Root Cause Analysis) for the post delivery/production issues by co-ordinating between Clients & PSG (Production Support Group), Development teams.
- Setting up QA environment for QA testing.
- Good interaction with Business users supporting and training for UAT
- Handled Functional, Performance & Load Testing on Web Applications with QTP, Load Runner and Web Load
- Knowledge of Test Management Tools - Mercury Test Director 8.1, Mercury Quality Center 9.0 and Site Administration.
- Expertise in preparation of test data, analysis of test results, preparation of Traceability Matrix, Status reporting and preparing entry & exit criteria
- Strong trouble-shooting, multi-tasking, organizing and communication skills
- Excellence in Team work and capable of working independently.
- Excellent rapport with clients
- Good experience in Telecom Domain, experience working for CMMI Level 5 organization
- Experience as a Team Analyst in the core team of 40 associates
- Experience as a Test Lead for some of the major client projects.
- Sound knowledge of QA process and Strategy giving attention to details.
- Internship projects in ASP.NET with C# and SQL Server.
Education:
- Bachelor of Technology (BS) in Computer Science and Engineering
Technical Skills:
Business Areas: Functional Knowledge of Telecom, Retail, Sales & Marketing.
Software/Tools: Mercury Interactive-Test Director, Selenium IDE, Toad - Oracle application, SQL developer,
SQL Server Management Studio, Microsoft Office Suite, Change Request Tool, Visual Studio,
SSAS, SSIS, MS SharePoint Server 2010
Reporting Tools: SSRS, WebFOCUS, Tableau
Languages: SQL, JavaScript, HTML, ASP.NET, Ruby
Operating Systems: Windows XP, 7
Databases: ORACLE 2000, Oracle 8i/9i/10g/11g, SQL Server
Professional Experience:
Confidential, Irving, TX April 2012 - Current
Role: QA Tester/Analyst
Confidential, a Sales and marketing company which provides people, technology, and analytics to support the sales and marketing of world-class brands. Their clients are fortune 500 companies with high expectations and forward-thinking philosophies.
Project Description: The Business Intelligence team at Mosaic works to bring about the customers with Analytics of their sales and solutions based on client requirements.
Team Size: 11 Associates (1 Team Manager + 7 Functional Team members + 3 Tester/Analysts)
Responsibilities:
- Prepare test plans, cases and set up testing environment, acceptance testing, regression testing for Quality assurance
- Bug finding, defect logging, Estimating efforts and tracking timelines for the project
- Perform Data Analysis and mapping, Datamanagement/dataintegration and co-ordination with Dev team
- Cube validation, Excel for data validation, pivot tables
- SQL queries and back end testing, SSRS report testing, deployment into UAT and Production
- User issues tracking, debugging and task assignment and follow-up
- Worked on SharePoint Insights and create links in site for client access to reports
- Conductinterviewswithsubjectmatterexperts, Understanding business
- Scenario identification and Executesystemacceptance testingbeforemovingtoproduction
- Monitor, Co-ordinate, Follow-up project tasks with team members
- Monitorsystemsandrespondtotechnicalissues, RespondtoRFQ/RFP/RFIs
- Serveasthetechnicalfirstpointofcontactforclient
Environment: Microsoft Business Intelligence Suite 2008 (SSRS, SSAS, SSIS), Microsoft Word, Microsoft Excel, SQL Developer, SQL Server 2008, SQL Server Management Studio, Visual Studio 2008, Team Foundation Server, MS Project 2010, Microsoft SharePoint Server 2010
Confidential,Atlanta, GA April 2010 April 2012
Role: QA Analyst/Project Management
Confidential, is dedicated to providing solutions to business problems, leveraging business intelligence, performance management and predictive analysis to determine behaviour combined with intuitive and easy to use visualizations.
Product Description: Confidential, is a Business Intelligence solution for Law Enforcement and Crime Control by using Predictive analysis that follows the concept of “Prevention is better than Cure”. Through Predictive Analysis the department is able to predict a certain happening at a certain place and incorporate forces to prevent any wrong doing. The solution also gives out Hands On information to the Officers at easy disposal and at the same time in a very secure environment.
Team Size: 9 Associates (2 Technical leads + 5 Functional Team members + 2 QA Analyst)
Responsibilities:
- Analyst and Project Management for the Law Enforcement Insight Analytics Project
- Gathering requirements, Scopeanddefineprojects, Define/documentrequirements, Develop/maintainprojectdocumentation, Build/Definereports, Establishtechnicalspecifications
- Prepare test plans, cases and set up testing environment, acceptance testing, regression testing for Quality assurance
- Bug finding, defect logging, Estimating efforts and tracking timelines for the project
- Facilitating client meeting, Training workshops and co-ordination with Dev team
- Perform Data Analysis and mapping, Datamanagement/dataintegration
- Conductinterviewswithsubjectmatterexperts, Understanding business, Contributetoproposals, Developcontentideas, solutions and enhancements
- Develop Business Process, WriteSQLqueries
- Scenario identification and Executesystemacceptance testingbeforemovingtoproduction
- Establish/maintainprojectcommunications
- Maprequirementstosoftwareproductfeatures
- Propose and implement strategies for project implementation
- Monitor, Co-ordinate, Follow-up project tasks with team members
- Developing reports in Report painter to query the tables and fetch data in various output formats like Excel, HTML etc.
- Usage of Active reports technology to quickly analyze data, export data and to draw simple charts out of it.
- Developing HTML user interfaces in HTML composer with drop downs and other UI components to run reports.
- Scheduled report caster jobs to distribute reports in the email as per respective schedules
- Monitorsystemsandrespondtotechnicalissues, BusinessProcessImprovement, RespondtoRFQ/RFP/RFIs
- Serveasthetechnicalfirstpointofcontactforclient
Environment: WebFOCUS 7.7.03, SSRS, Microsoft Word, Microsoft Excel, SQL Developer, Oracle 11g, SQL Server 2008, SQL Server Management Studio, ASP.NET, C#, Visual Studio 2008, MS Project 2010, Mercury/HP Quality Center
Confidential, Hyderabad, India May 2006 Apr 2010
Role: Test Analyst/Lead Analyst
Confidential, is the outsourcing partner for IT solutions of TTSL. A separate System Integration Testing team was initiated at TTSL to cater to the quality of the Business Critical Applications, Architecture enhancement projects, Change requests and Major releases. The Operations Support Systems has suite of systems to cater to the end-to-end business of TTSL.
Project Description: Confidential, is part of Tata Group that has over 90 companies. The group has a formidable presence across the telecom value chain. Incorporated in 1996, Tata Teleservices was the first to launch CDMA mobile services in India. TTSL was a CDMA telecom company initially, that has pan India presence which on collaboration with Japan\'s mobile company DOCOMO has launched its GSM services also in the Year 2009.
Team Size: 40 Associates (4 Module leads + 31 Functional Team members + 5 Test Analysts)
Responsibilities
- Test Analysis, Effort Estimations, Project Planning, Resource Management & IQMS activities
- Writing Test scenarios & cases, test plan for major functionalities
- All kinds of Functional and Non-functional testing (Security testing, Installation validation testing, release testing, usability testing), Browser compatibility testing
- Functional, Performance & Load Testing with QTP , Load Runner and Web Load
- Migration Testing for new/upgraded applications
- Involved in User Acceptance Testing (UAT) for functional releases with training and support
- Asset building for the team with Training Plans, Functionality Documents
- Task Assignment, Project Monitoring, Co-ordination, Review and follow-up activities with co-team members
- Discussions/Meetings with the client and other stakeholders to meet deadlines
- Prepare resource utilization report, execution report, defect report, weekly status report.
- Working with development team in problem analysis and resolution
Major Contributions:
- Successful deployment of Telcordia Intelligent Network
- Successful deployment of GSM services through TATA DOCOMO which is a big success in Indian Telecom Market now.
- Test Lead, Analysis, Planning, management of execution of GSM for Virgin Mobile.
- Primary point of contact for Prepaid systems for Analysis, Planning, Execution of GSM and CDMA, Network Testing on IN platforms of Telcordia and Alcatel and other systems like TIPPS (Prepaid customer management system), AIS (Prepaid Starter pack generation and maintenance system), EVD (Electronic Voucher Database).
- Primary point of contact for Wire line Automation in TTSL for Alcatel, Ericsson, Lucent & New generation switches
- Key role in the Test execution of Provisioning system POS (Point Of Sale)
Environment:
Mercury QC 9.0, TEAPOT (Internal Test Management tool), Load Runner, Web Load, Oracle 10g, Web applications, TOAD, Test Director, Putty, SQL Developer, IPMS, Oracle Apps R12 CRM, Metasolv, TIBCO, BPM Windows PC, Microsoft Office, Windows Vista Servers with Linux
Confidential, Hyderabad, India May 2005 Mar 2006
Project:
Intelligent Communication Messenger
Responsibility:
- .NET Application development for healthcare professionals
- GUI, User Interface Designing and implementing application wokflow under Microsoft .NET framework using C#
- Communication set up between applications and database with ADO.NET
- Unit Testing and Bug Fixing
Environment:
ASP.NET with C#, SQL Server, Windows PC, Windows XP