We provide IT Staff Augmentation Services!

Sr.qa Analyst Resume

4.00/5 (Submit Your Rating)

John S Creek, GA

Summary:

  • 11+ years of Overall IT experience with 8+ years of extensive experience in Testing, Business Analysis, Coding, and Implementation of Mainframe, Siebel, Client\\Server and Web based applications.
  • Involved in implementing, defining, designing, testing, supporting and developing web based and client server environments.
  • Good experience in software system testing, Integration testing, UAT, PST, GUI Testing, Regression, Performance Testing, Functional Testing and Manual Testing.
  • Proficient in Manual Testing, Functional Testing and Automated Testing Tools.
  • Knowledge on quality standards like ISO, CMM Levels.
  • Involved in Project Management - Worked on Integrating and Data modeling core business processes CRM Siebel applications, E Commerce, Web Applications & DWH Applications.
  • Experience in Pharma, Financial, Insurance, Country Store Outlets, and Telecommunication applications as a QA/Business Analyst.
  • Proficient in System, Acceptance, Interface, Performance, Load, Integration, Regression, Black Box, White Box, UAT testing.
  • Strong knowledge in QA Methodology and Project Management.
  • Worked in various facets of SDLC, extensive knowledge of Capability Maturity Model (CMM), Rational Unified Process (RUP), Agile, SIX Sigma and IEEE Methodologies
  • Good Exposure on Siebel Analytics (OBIEE) concepts and ETL Informatica.
  • Exposure in Server rebooting/bouncing the Siebel servers and performing some of the Server Administration tasks.
  • Good Experience in Product Supporting Activities on all Siebel versions.
  • Tested Siebel Field Service, Siebel Pharma, Siebel Sales, Service, Siebel Call Center, Siebel Marketing, Siebel e-Customer, Siebel e-Communications, Account Management, Siebel Order Management, Product Administration, Forecasting, Quotes, Opportunity Management on various Siebel versions like Siebel 6.0, 7.0, 7.5, 7.8 & 8.0.
  • Good technical expertise in using SQL and have strong knowledge on PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, John's Creek, GA Jan'10 - Till Date

Confidential
Role: Sr.QA Analyst

Macy's Loyalty program was introduced to grow Macy's store sales and improve customer loyalty through a tender neutral rewards program. The loyalty program would initially reward customers based on their number of visits. The offers would entice customers to visit and purchase from our stores more frequently in order to earn rewards. A key focus of the program will be to reward Macy's customers' who shop with a Macy's Co-branded credit card or Macy's proprietary credit card more significantly than Macy's customers that use cash or other credit cards. The project has been declared one of the biggest successes in the recent history of the company. This project also set a precedent to all the other retailers by embracing cutting edge technology like Complex Event processing (TIBCO BE).

Roles & Responsibilities:

  • Involved in Requirement Analysis based on the BRD, RDD, TDD and also participated in Business and Technical Review meetings
  • Co-ordinated with Business teams and Development teams during Test Planning Phase to prepare the various test documents including Test Plan, Test Strategy and Test Cases.
  • Involved in executing the test cases and test scenarios for Smoke Testing, Functional and System Testing
  • Involved in validating the Web Services related to Customer, Account and Transaction Management using the SOAP UI 3.5
  • Involved in executing and validating SPOS (Smart Point of Sales) transactions like Purchase, Returns, Post void, Presales and Shipments.
  • Involved in Customer Enrollments and Customer Lookups and Customer Info and Account Maintenance using SPOS, MCOM and ICM
  • Involved in loading and validating the WSDLS in SOAP UI and preparing the Request XMLs
  • Involved in validating the Request and Response XML in SOAP UI Editor
  • Involved in validating the Business Processes developed in TIBCO Business Events and TIBCO Business Works
  • Involved in validating the JMS Queue Messages using GEMS tool
  • Involved in validating the Logs and Exceptions in TIBCO CLE (Common Logging & Exception)
  • Involved in triggering the JMS messages manually using TIBCO Designer 5.6
  • Involved in data extractions, file extractions and file transfers in UNIX environment using WINSCP
  • Involved in validating the Daily and Weekly Batch jobs like Presales to Rewards Conversions, Award Purge, Transaction Purge and Reward Markdowns.
  • Involved in writing SQL statements in Oracle ODS and DB2 for data validation
  • Extensively used Bug Tracker to raise defects, generate reports etc.
  • Conducted daily meetings with Project and Development teams to discuss testing and to prioritize defects and issues
  • Involved in preparing Test Execution Status reports and graphs using Excel

Environment: SOAP UI 3.5, TIBCO Active Matrix BusinessWorks (BW) 5.7.2, TIBCO BusinessEvents 3.0.1, TIBCO Designer 5.6.0, TIBCO Enterprise Message Service 5.1.2, TIBCO Hawk 4.8.1, TIBCO Rendezvous 8.1.2, TIBCO Runtime Agent 5.6.1, TIBCO CLE 2007, XML, Oracle SQL Developer 2.1.0, Oracle 11g, , AS/400, UNIX, Web services, Windows XP, Bug tracker 3.0, WIN SCP 4.2.5, IBM DB2.

Confidential, Atlanta March\'09 - Present
Senior Siebel QA Tester

Confidential, Operates with Cable, Data (Internet) broadband, and Fixed Wire services and supports the same via the Legacy platform and has been lately building a solution using Siebel CRM. Cox has made a decision to implement a common eCommerce platform supporting both core and wireless services. There are two main organizations using the Siebel CRM application for Wireless and eCommerce.
Responsibilities:

  • Extensively worked on Siebel e-Communication 8.0.1 version for the Siebel eCommerce Order Processing functionality.
  • Analyzed business Requirement's, Functional Design, Technical Design and Release Notes Walkthroughs with business groups.
  • Good Experience in Agile methodology.
  • Created Test Plans, Test Cases and Test scenarios in Quality Center, Mapped the test cases to Requirements.
  • Experience in Automate the creation, execution and analysis of functional, regression, sanity and performance tests for Siebel and Ecommerce applications.
  • Involved in Quote Creation and Product Business rules on Order Management Module.
  • Validate the Order Processing application interfaces with ICOMS, CNS, AF, and Ingrain during various stages of the Order flow.
  • Validate the Siebel web services data from Account Creation and CPNI Account Information.
  • From the requirement and system requirement document to come up with a detailed Test Plan
  • Executed Test Cases manuallyto check GUI and Functional features of the application.
  • Defects were tracked and prioritized using Quality Center Tool.
  • Involved in UAT Test, Regression Test, Performance Test and System Test and supported to Production environments.
  • Reviewed and Modified Existing scripts and also developed new scripts for the new functionality.
  • Record and Play the Siebel navigations using QTP 10.0
  • Validation of Test Plans injecting SQL queries using database Oracle10g and TOAD.
  • Involved in Creation of Organizations, Positions, Responsibilities, Products, Product Classes, Product Attributes, Sites, and Franchise Groups etc.
  • Validated Product Screens, Cardinality and Constraint Rules

Environment: Windows XP, Siebel 8.0.1, Siebel 8.0.1 Tools, Siebel e-Communication Client, Java, Quality Center 9.2, Web Services, HTML, Oracle 10g, ICOMS Billing, Order Express, CNS, Ingrain, Unix, Load Runner, Visual Studio, QTP 10, Cute FTP,

Confidential, Atlanta Jan\'06 - Feb'09
Siebel QA Tester

Confidential, is the largest regional mobile phone company in America, and the fifth largest mobile phone company overall. With a market cap of $24.79 billion and around 13 million customers, the company focuses on small to medium-sized cities, and also has low-cost roaming agreements with the major national carriers.
Responsibilities:

  • Full Lifecycle Upgrade conversion from Siebel e-Communication 7.5.3 to Siebel7.8. Work included planning, analysis, design, development, implementation, testing and support of the conversion process in a UNIX/NT environment.
  • Analyzed business Requirement's, Functional Design, Technical Design and Release Notes Walkthroughs.
  • Created Test Plan, Test Cases and Test scenarios in Quality Center, Mapped the test cases to Requirements.
  • Experience in Automate the creation, execution and analysis of functional, regression and performance tests for services and SOA applications.
  • Validated the data in MQ Series Logs.
  • Set up the test environment with the libraries and configuration files required for SOAP Web services or custom security algorithms.
  • Recorded and tested the XML values with variable test data, or add dynamic data to the test.
  • From the requirement and system requirement document to come up with a detailed Test Plan
  • Executed Test Cases manuallyto check GUI and Functional features of the application.
  • Defects were tracked and prioritized using Remedy Tool.
  • Involved in UAT Test, Regression Test, Performance Test and System Test and supported to Production environments.
  • Performed all development migrations to other upper environments using version control PVCS Dimensions.
  • Reviewed and Modified Existing scripts and also developed new scripts for the new functionality.
  • Validation of Test Plans injecting SQL queries using database Oracle10g and TOAD.
  • Loaded & Verified phone images, bills, products and all market specific information into the Siebel database to enable testers execute the different test cases.
  • Tasks also included bouncing Siebel Servers when requested.

Environment: Windows 2000, Siebel analytics 7.8, Siebel 7.8.2.5 Tools, Siebel e-Communication, Java, Web sphere, Web Services, HTML, Oracle 10g, Oracle9I,Unix, Shell scripts, Perl scripts, Dimensions, Remedy, Load Runner, Visual Studio, QTP, Cute FTP, Quality Center and PL/SQL Developer.

Confidential, NewJersey Oct\'04 - Dec\'05
Siebel QA Lead Analyst
Confidential, has internal applications running across different platforms and technologies supporting the business users. Fujitsu is particularly regarded as a solutions provider to the different Products, finance and telecommunications industries as well as government agencies. It also offers a variety of unique and innovative software products.

Responsibilities:

  • Involved in gathering Business Requirements and developed specific test scenarios to test client.
  • Tested & verified Service, Forecasting, Quotes and Order Management Module.
  • Logged bugs in Test Director that are found during the process of testing and running defect reports for status meetings.
  • Executed test cases manually to check GUI and Functional features of the application.
  • Developed scripts manually for different modules and worked with Win Runner in developing automation scripts.
  • Involved in project meetings and discussions for setting targets and goals to be achieved in the QA process.
  • Involved in Black Box Testing (Functionality, GUI Testing, System Integration Testing (SIT), Compatibility Testing, Accessibility Testing) for Manage Actions, Monitor Database and Action Monitor Modules.
  • Analyzed the business requirement document and the system requirement document to come up with a detailed Test Plan.
  • Defects were tracked and prioritized using Test Director and analyzed the variation between expected and actual results.
  • Analyzed defects status using Test Director and interacted with developers to fix defects/bugs of the application.
  • Involved in running PL/SQL and SQL queries to validate Data.
  • Involved in doing performance testing using Win Runner covering three main functional areas billing client and assure the system is behaving faster.
  • Experience in handling large business teams & conducting requirement gathering the sessions.
  • Rich Experience in Siebel Test Plan Creation, test scenario & Test Case Creation.
  • Executed test scripts using Mercury Quality Center.
  • Experience on Siebel Test Execution Management using Defect Management Tool.

Environment: Windows 2000, Siebel 7.5.3 Tools, Siebel Client, Thin Client, Oracle9i.Unix, EIM, Quality Center, QTP, Win Runner, CVS and Test Director

Confidential, USA Oct\'03 - Oct'04
Siebel Tester

Confidential, has country store outlets in all over USA. Gateway manufactures computer related products. This Project represents a committed order amount request that will be handled by Siebel. By using this framework any application can generate the appropriate message to request a Siebel committed order amount. The Siebel adapter is independent of the requesting application, and does not need to be modified if a new application requires Siebel committed order amount. .
Responsibilities:

  • Study of Master Test Plan, Knowledge Acquisition and Capturing Test Requirements.
  • Analysis of all Technical Transformation Rules, Business Translation Rules for both functional and business requirements from the Mapping Specifications and Functional Design specifications.
  • Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
  • Primarily involved in testing activities like Functional Verification, Regression, User Acceptance testing for new builds.
  • Create and configure the load test plan using Mercury.
  • Verifying data on message text and rvspy tool for JD Edwards.
  • Worked on Configuration Management tools like PVCS repository tool.
  • Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
  • Worked on Configuration Management tools like PVCS repository tool.
  • Testing Siebel eSales, Call Center, Service, and Sales Order data on Siebel thin client in different environments such as UAT and Pre-Production environments
  • Preparing test cases and analyzing the results of the test cases.

Environment: Windows XP, Siebel Tools 7.5.2, Siebel Client, Oracle9i, Java, HTML, PVCS, Tibco, RVspy, Morpheus Tool, Message Test, UAT, PST (Gateway) Environments.

Confidential, Paris Dec\'02- Sept\'03
Siebel Tester
Confidential, Siebel was selected to perform customer relationship management activities within IBM Corporation. The MDS (Migration, Deployment & Support) operations scope focused on testing and support of legacy data migration and data interfaces to Siebel. The testing automation support focused on automation of test scripts created by the test teams to assist in Installation verification Test. The tools support focused on change analysis to assess impact of moving new releases in to production.
Responsibilities:

  • EIM Data Mapping for Accounts, Contacts, Positions, List of Values and Products.
  • Data extractions from legacy or source systems are developed and tested.
  • Testing the Siebel application.
  • Logging the defects through CMVC and Tracking those defects by TTT (Test Tracking Tool) till closure. Also followed up with development team to verify defect fixes and update defect status.
  • Provided support in moving the project to the Production Environment.
  • Reviewed Server/system logs and reports to identify application processing errors and possible improvements.
  • Analyzing, developing and testing the data for the EMEA and Asia Pacific Project.
  • Analyzing packages and running test reports.
  • Troubleshooting log files.

Environment: Siebel 7.5, Siebel 6.3, EIM, Siebel Tools, Siebel Client, Thin Client, LCIA, PCIA, Java, C, C++, Aix, Korn shell scripts, DB2 and Unix.

Confidential, UK Oct\'01- Nov\'02
Siebel Configurator
Confidential, has implemented the Siebel Field Service to profitably manage all aspects of their field service operations. Using Siebel Field Service they are managing field service activities, preventative maintenance, break/fix service events, service inventory, warranties, quotes and orders, shipping and receiving etc., it automatically assigns the most appropriate field service engineer to a service request based on product expertise, availability, geography, or other criteria.
Responsibilities:

  • Involved in the Customization of Siebel to meet the customer requirement and performed business analysis for enterprise CRM Application.
  • Defined Organizational hierarchy and created Responsibilities and Positions for different SR's.
  • Configured Components to support Workflow Manager, assigning data with Assignment Manager, defining assignment rules and running the assignment manager
  • Involved in configuring user interface objects applets, views, screens etc.,
  • Involved in developing actuate reports.
  • Involved in writing workflow policies for sending e-mail.
  • Worked on workflow manager and written work flow policies, conditions etc.
  • Developed single grouping and multi grouping reports.
  • Monitoring the Siebel application for its stability and track Siebel services and server components to ensure that application up and running during the business hours.

Environment: Siebel Version 6, Siebel Tools, Siebel Client, Workflow, Oracle, Actuate Reports, Microsoft Excel

Confidential, Hyderabad, India Aug'99 - Sep'01
Senior Software Engineer

This project was developed for banking transactions in Enterprise Java Bean gives consistency to the Database. User must logon by entering the valid username and password. This can be used to open a new account whenever necessarily. There are the options to choose the account Type like single account or joint account etc. User can also deposit the amount by just clicking the deposit button, whenever the customer wants to deposit their amount. In another Module, the user can withdraw the amount and they can close the account.
Responsibilities:

  • Designed the Customer Views, Standard Views, and Login Information for the Users. Whenever the Customer come to bank to make fixed deposit, So that just the user can enter the details of the customer, name of the Customer, Account number and amount to be deposit and the duration etc.

Environment: Java, EJB, XML, Servlets, JDBC and Oracle 8, Microsoft Excel Win 98

Confidential, Hyderabad, India Aug'98 - Jul'99
Software Engineer
This Tool is mainly developed to keep track of the Project Status of various Projects, Quality Management records, Software Configuration Management Records. It can generate different QC forms (Quality Control) and Change Management Forms. This tool can be used to see the Old Project Status reports, QC forms and change management of various projects. Change Management includes Change request details, Change Approval and Change Implementation details.
Responsibilities:

  • Designing, Coding, creation of Forms and Reports, Modifying the QC forms and change management of various projects and Check the status of Project Reports.

Environment: Java1.3, HTML, JDBC, JavaScript, Oracle and Windows NT.

EDUCATION:

M.B.A (International Business)

We'd love your feedback!