Sr.qa Analyst Resume
Summary:
- 13+ years of Overall IT experience with 10+ 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/SOA based and client server environments.
- Good experience in software System testing, Integration testing, White Box Testing, UAT, PST, GUI Testing, Regression, Smoke Testing, System Acceptance testing, Interface Testing, Adhoc Testing, DB Testing, Functional Testing and Manual Testing.
- Proficient in SOAP Web Service Testing & Automating Web Services using HP Service Test Tool.
- Involved in Project Management – Worked on Integrating and Data modeling core business processes CRM Siebel applications, E Commerce, and Web Applications & DWH Applications.
- Worked on XML, XSDs, WSDLs, Java Messaging Services, TCP/IP Protocol, Tibco interface testing, and Web services Testing on Service Oriented Architecture(SOA) tool and SOAP (Simple Access Object Protocol)Tool
- Experience in various domains like Smart Grid Retail Energy, Banking, Financial, E-Commerce, B2C&B2B Portal, Telecommunication, Country Store Outlets and Pharma.
- Strong knowledge in SDLC Concepts, STLC Concepts, QA Methodology and Project Management Concepts.
- Good Exposure on Point of Sale concepts and billing domain expertize.
- Worked as Onsite & Offshore coordination for various clients.
- Good Exposure Windows, UNIX, Linux environments and also able to execute the Shell & Perl on command line interface.
- Good exposure creating the test data before executing the test on various application domains.
- Good expertize in back end validation using Oracle SQL & Teradata using various client tools.(TOAD,SQL Developer, SQL Assistant for Java and Windows)
- Good expertize to create test reports for various projects using HP Quality Center ALM 11 Version.
PROFESSIONAL EXPERIENCE:
Confidential, Oklahoma City, OK Aug\'11 – Till Date
Sr.QA Analyst
SmartGrid IT at Confidential program involves system-wide deployment of a fully integrated advanced metering system, distribution of in-home devices to almost 6,000 customers, and installation of advanced distribution automation systems. SmartGrid IT allows smart meter customers to view their electricity consumption data at any time through a personalized Web site (study participants are testing other visual displays), and also allow Confidential to manage, measure, and verify targeted demand reductions during peak periods. New systems capture meter information for billing and implement new customer pricing programs and service offerings. The project deploys a more dynamic distribution management system, automated switching, and integrated voltage and reactive power control (IVVC) that reduces line losses, reduces operational costs, and improves service reliability.
Responsibilities:
- Design, development and execution of test plans, test cases, and test strategies.
- Single handedly completed various projects for the smart Grid IT Implementation.
- Good expertize working on multiple projects at a time with tight schedules.
- Fast learner and Team player on any new technologies and also eager to work on any applications.
- Good expertize using Quality Centre for various projects, Create Test Plans, execute Test Cases, Requirement traceability matrix, generated various test reports.
- Expertize to work in fast paced Agile development model.
- Experience in functional, integration, performance, data quality and regression testing.
- Identify project risks and recommend actions to minimize risk
- Experience with large horizontally scalable distributed component architectures including distributed databases and large Web/SOA application architectures
- Good expertize in Java Messaging Service ((Hermes JMS, GEMS), XMLs ,WSDLs, XSD Schemas, JBOSS and Web Services(SOAP UI Tool and HP Service Test) and Java based applications.
- Mentor and train 1-2 other engineers, lead larger projects, prioritize test activities and find creative solutions to blocking issues and problems
- Good Expertize in Tibco products like Tibco Designer, BW, EMS, CLE (Exceptions, Log, Configuration) & Enterprise Service Bus components.
- Good Expertize in automating the web service test cases using SOAP UI Tool 4.5 Version and HP Service Test 11.2 Version.
- Good Experience in File Load process, batch load process and load the test data.
- Read the Meter and Register Interval data from Silver Spring Network UIQ system
- Good experience on Searching the events, devices, Reports, Networks, Schedules and exports
- Experience working on windows NT and Unix/Linux systems
- Tested Daylight Saving Time (DST) for Fall & Spring Meter Interval Data.
- Tested Topic Messages and Queue Messages using Hermes JMS Tool & Gems Tool.
- Tested and extracted meter interval data(15 minute Interval) Meter Interval status from MDMS to Info Factory(Teradata Extract) by running the ETL Job Scheduler from the web interface
- Documented and track defects in JIRA & QC, as well as produce detailed reports using defect tracking tools
- Expertize in troubleshooting and identify the issues while doing the test execution.
- Good Expertize in backend validation using SQL Developer, Toad and Teradata db.
Environment: Soap UI Tool 4.5 & 3.5, HP Service Test 11.20(Automation Tool), Silver Spring Networks(SSN)UIQ AAM4.4.7.2, Tibco Designer 5.7.1.2, Tibco EMS 6.1, WSDL, XMLS, XSDs, Schemas, Hermes JMS Tool V1.14, BMC Remedy 7.6, HTTP Protocol, SMTP Protocol, ,HP ALM Quality Center 11, Sprinter 11, Linux, TIP version to 2.2.0.1 FP7, Omnibus version to 7.3.1 FP4, Cute Ftp, Jira 4.5 Defect Tracking Tool, MDMS EI Server 8.9.21, GEMS 3.3, AIX OS, Oracle SQL Developer 2.1.0, Teradata 13.20, Microsoft SharePoint
Confidential, Cleveland, OH April\'11 – July’11
Test Lead
Extreme Makeover - KNB Sales Tool project encompasses planning, designing, developing, testing and implementing an easy to use, brand new CRM Sales Tool for Confidential. The benefiting user community includes the Sales Professionals, Managers, the Support Staff and Data Administrators from a variety of Lines of Businesses and Product Groups.
Responsibilities:
- Analyzed business Requirement’s, Technical Design and Release Notes Walkthroughs with business groups.
- Created Test Strategy, Test Plans, Test Cases and Test scenarios in Quality Center, and mapped the test cases to Requirements.
- Experience in leading the team from onsite and Offshore Role model.
- Assigning the day to day work priorities to offshore team
- Defects were tracked and prioritized using HP Quality Center Tool.
- Tested this application using different Line of Business users
- 800 users were involved in this application
- Involved in UAT Test, Regression Test, Functional and System Integration, Data Integration, batch testing in Test & UAT environments.
- Reviewed and Modified Existing scripts and also developed new scripts for the new functionality.
- Proactively solve problems and suggest process improvements
- Mentor junior engineers to build their skills and contribution levels
- Good Expertize in Corporate Banking Domain Applications including analytics dashboards, reports, profitability matrix, revenue by product etc.
- Write test status reports and escalate issues as appropriate
- Reviewed the test case which was written by offshore team.
- Expertise in Test Data preparation for this project.
- Querying the results using Oracle Pl/SQL.
- Validation of Test Plans injecting SQL queries using database Oracle10g and TOAD.
- Involved in testing the Organizations, Positions, Responsibilities, Products, Company Hierarchy, Dashboards, Reports, Aggregate rules, Admin users & Support users etc.
Environment: Siebel 8, OBIEE Reports, CRISP, CIX Integration, Oracle SQL Developer 2.1.0, Oracle 11g, DAD, BoB Transfer Tool, CUCU Tool, Cognos Reports, AS/400, UNIX, Web services, Windows XP, HP Quality Center 10, WIN SCP 4.2.5, CONFIDENTIAL DB2.
Confidential Jan\'10 – Jan’11
Role: Sr.QA Analyst
Confidential’s Loyalty program was introduced to grow Confidential’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. 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 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 Business Events 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, CONFIDENTIAL DB2.
Confidential, Atlanta March\'09 – Dec’09
Ecommerce Tester
Confidential Content Store Application that will give Confidential wireless customers a richer experience while downloading content/application for their wireless devices through the Confidential.com website. Confidential will be partnering with various Content Vendors for making available content along with other media assets. The Content Store Application will allow the user to browse, preview and purchase content/application. The purchase transaction will be sent to QUALCOMM’s Brew Zone. Brew Zone will send the purchase request for authorization to BMC which validates user details against Confidential Oracle BRM through Active Mediation.
Responsibilities:
- Analyzed business Requirement’s, Functional Design, Technical Design and Release Notes Walkthroughs with business groups.
- Lead projects and provide technical supervision to other QUALITY ENGINEERING staff
- 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.
- Generate and download reports, approve, publish, edit, reject content and maintaining other administrator profiles.
- Download content from the Confidential Web Content Store like ringtones & Graphics, games, applications, what’s hot and news sports & Weather etc.
- From the requirement and system requirement document to come up with a detailed Test Plan
- Verified data content after ran the batch jobs for Daily, Monthly, Weekly and Monthly.
- 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.
- Tested this application using different logins like Guest/Anonymous Customer, Existing/Authenticated Customers etc.
- Tested Request XML Data and Response XML data which was sitting in the Logs.
- Verified the XML content when the batch jobs ran in UNIX environments.
- 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.
- Involved in Integration testing using XML validations which the data is coming from external application using middleware components.
- Good Experience on POS system using BRM.
- Account data has been loaded using UNIX batch jobs.
- Querying the results using Oracle Pl/SQL.
- 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.
Environment: Windows XP, Java, CRM, MCS, IDM, SMSC, Qualcomm, WCM, Brewzone, Quality Center 9.2, Web Services, HTML, Tibco interfaces, XML, Oracle 10g, ICOMS Billing, Order Express, CNS, Ingrain, Unix, Visual Studio, QTP 10, Cute FTP
Confidential, Atlanta Jan\'06 – Feb’09
Senior 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.
- Involved in Web services testing using SOAP applications.
- Set up the test environment with the libraries and configuration files required for SOAP Web services or custom security algorithms.
- Good Exposure on WSDL Concepts
- Experience in testing B2B&B2C portal applications in single sign on authentications.
- 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.
- Ran the shell and Perl jobs in UNIX machines and loaded Customer information in to Siebel and mainframe applications.
- Involved Payments using the Point of Sale (POS) system methodology.
Environment: Windows 2000, Java, Web sphere, Vitria, Unity, Siebel 7.8.2.5, Siebel e-Communication, VII Billing,B2B & B2C Portal applications, Cellware Billing, XML, SOAP Web Services, HTML, Oracle 10g, Oracle9I,Unix, Shell scripts, Perl scripts, Dimensions, Remedy, Visual Studio, QTP, Cute FTP, Quality Center and PL/SQL Developer.
Confidential, New Jersey Oct\'04 - Dec\'05
Sr. QA Analyst
Confidential has internal applications running across different platforms and technologies supporting the business users. Confidential 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.
- 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.
- 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, Java, J2ee, Oracle9i.Unix, Quality Center, QTP, Win Runner, CVS and Test Director
Confidential, USA Oct\'03 – Oct’04
QA Lead
Confidential has country store outlets in all over USA. Confidential 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, and 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 (Confidential) Environments.
CONFIDENTIAL, Dec\'02- Sept\'03
QA Tester
CONFIDENTIAL Siebel was selected to perform customer relationship management activities within CONFIDENTIAL Corporation. The MDS (Migration, Deployment & Support) operations scope focused on testing and support of legacy data migration and data interfaces to Siebel.
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, Lotus Notes, Korn shell scripts, DB2 and Unix.
EDUCATION:
- M.B.A (International Business)