System Analyst Resume
Professional Summary
- Excellent understanding of Software Development Life Cycle (SDLC) and Test Methodologies from project definition to post-deployment documentation.
- Expertise in developingstrategic Test Plans and Test Cases using requirements and design documents while specifying Objectives, Scope, Roles and Responsibilities.
- Proficient with multi-vendor testing tools like Win Runner, Test Director, Quick Test Pro and Rational Clear Quest.
- Strong aptitude in implementing different QA processes and Standards.
- Extensively used Bug Tracking tools like Mercury Test Director and Rational Clear Quest.
- Good understanding of Relational Database Management Systems.
- Exposure to different operating systems like windows 95/98/00, NT, XP and Unix.
- Knowledge of SQL queries and procedures.
- Proficient in C, VC++, SQL, VBScript.
- Excellent communication, analytical, programming and logical skills.
- Self-starter and a team player with good aptitude for learning new technologies.
- Ability to interact with individuals from various internal and external groups – Users, Business Analysts, Developers, Technical Support, Testing team and Project Management.
- Strong analytical, time-management, organizational and presentation skills.
- Excellent team player with an ability to interact with external system counterparts, end users, providers, managers and technical personnel
- Proficient in automation testing using QTP tool.
- Skilled in testing client-server applications.
- Experience in software design and development in technologies like C, C++, Unix Shell Scripting, FORTRAN , Java, J2EE, Perl, Oracle and MYSQL.
- Expertise in C, C++. Shell/Perl,
- Working experience of multiple operating systems like Windows, different flavors of UNIX
- Hands on experience in developing LINUX/UNIX applications.
- Working experience of SQL, PL/SQL and MYSQL.
- Working experience of automation process using PERL.
- Utilized Microsoft Project effectively for project management and tracking.
- Experiencedin white box testing using Junits and cppTest frameworks in oracle/web-server and client-server domains.
Education
Bachelor of Science in Electrical Engineering,
Undergraduate courses in Software Engineering,
Certification
QA Diploma from Institute Of Technical Education {ITE-Bloomington, MN}
TECHNICAL SKILLS
Operating Systems
Windows XP, UNIX,LINUX(Red Hat) Solaris
Languages
VBScript, JCL, C, C++, JAVA, Shell scripting, Perl
DBMS
DB2, ORACLE, MS SQL Server, MS Access
Tools and Utilities
Quality Center 9.0, QTP 8.2, IBM-Anchor, Green screen, Microsoft Project, MS Office, Acrobat reader, Rational Clear Quest 7.0, Toad for Oracle, Excel, Visio, PowerPoint, La Tex, Business Objects Web Intelligence, Siebel.
Applications worked on
Health care Claims, Disability Insurance, Commercial Insurance, Banking, Financial Services, Logistics
Types of projects worked on
Manual testing, Automation testing, SDLC, Maintenance, Production Supporting, Development
Academic Projects
Project: Confidential, June2009 – May2010
: QA Analyst
Description
The purpose of this project was to test the enhancement and the functionality of the Web Applications and Client-Server Applications, which are used by customers and the internal users. The web applications dealt with online registration, browsing, selecting, ordering and bill processing. The customer profile will be maintained with customer account, service accounts and billing accounts for order processing and billing of the products. The integration among the modules of application to process customer management, order processing and billing were done interactively using Client-Server GUI application and web application.
Responsibilities
- Reviewed and analyzed the Business, Functional Requirements documents and streamlined the Testing Activities.
- Actively participated in requirement gathering and Test Plan review meetings.
- Examined the application for testing, data validation and workflow of customers.
- Involved in developing Test Plans, Test Cases in Microsoft Word and Microsoft Excel.
- Imported the Test Cases from Excel to Test Director via the import facility.
- Executed manual test cases using Mercury Test Director 8.0 and reviewed test cases developed by other testers.
- Analyzed the results, tracked the defects and generated reports using Test Director.
- Created Traceability matrix between Requirements and Test Cases using Test Director.
- Corresponded among Team Members.
- Was involved in the regression testing after each modification and enhancements.
- Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.
- Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
- Designed test plans and defined cases for functional, integration system, and user acceptance testing.
- Attended weekly defect report meetings and presented progress updates.
- Involved in Integration testing for release of updated Jigsaw Apps Exchange.
- Ensure that all the test cases are updated in the Quality Center along with Master test plan.
- Involved as part of automation team using QTP, developed test scripts.
- Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.
- Involved in Release support - Release to QA, involved in environment setup, testing the release process.
- Involved in Performance testing QA using Load runner 8.0.
- Involved in Backend Database testing in Oracle using SQL.
- Defects were tracked, reviewed, analyzed and compared using Quality Center.
Environment: Test Director 8.0, Rational Clear Quest 2003, Java, SQL Server 2000,
Load Runner7.8, HTML, IE6.0, Windows XP, MS Office.
Client: Confidential, Feb2008 - April2009
Project: Online booking system
: System Analyst, Developer
Project Description:
The website handles secure booking for air ticket and railway ticket. To implement these functionalities we have used core Java, J2EE, Java beans, Java Scripting and JDBC. Besides this on the client side I have created user-friendly GUI interface and Web pages using HTML and ASP, used Java Script for client side validations.
Responsibilities:
- Researche & Analyses project documentation and participated in project reviews.
- Design and Development of the system using Java, J2EE, JavaScript, JDBC.
- Developed, documented, verified & maintained Test Plans and associated Test cases to meet the business requirements
- Performed white box testing of the modules using the Junit framework.
- Validated the mapping and integrity of data populated in the database.
- Performed manual and Automated testing and maintain documentation on different types of Testing viz.Positive, Negative, Regression, Integration, System, User-acceptance, Performance, and Black Box.
Environment : JAVA, Junit, Oracle, VB, MS-ACCESS, Test Director.
Project: Storage Controller System Jan2007 – Jan2008
: QA Tester
Description
This was a high end storage sub-system designed to be a high availability, high reliability and a high performance machine. This system was designed for storing critical customer data in large volumes with extremely low access times.
Responsibilities
- Extensively interacted with team members to test according to the requirements.
- Developed Test Plans and Test Cases based on the Business Requirements and Design Documents.
- Performed installation and configuration of software required for testing.
- Developed and executed SQL Queries to perform backend database testing.
- Used Verification points and conducted data driven tests to verify the contents.
- Identified test cases to be automated and marked them by adding “automation” field in Test Director.
- Identified Automated scripts for regression testing using Win Runner.
- Executed 7 Rounds of Testing including System, UAT, functional, regression, data migration and Smoke and played a major role in Pre and Post production testing.
- Involved in submission of bugs through Defect Reports and frequently participated in Defect Report review meetings.
- Isolated and simplified problems discovered during testing so that they can be fixed easily.
- Responsible for status updates showing progress of testing.
- Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.
- Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
- Designed test plans and defined cases for functional, integration system, and user acceptance testing.
- Attended weekly defect report meetings and presented progress updates.
- Analyze business and system requirements, mange development of specifications to create and execute detailed test plans, and verify bug fixes.
- Oversee 4 on- and off-site QA analysts.
- Configure test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
- Supervise development of SQL-queries/procedures for database and backend testing.
- Manage script creation for regression and stress testing using LoadRunner and QuickTestPro.
- Use Clear Quest for repository, reporting and tracking bugs, and providing updates on resolved bugs.
Environment: Unix, Windows NT, Quick Test Professional 6.5/8.0, Test Director 8.0, Rational Clear
Case.
Professional Experience
Confidential,India
: Quality Control Engineer Jan2006- Nov2007
Description
A leader in the Indian market for manufacturing External rotor motors, used in the assembly of such products as electronic panels. International clientele included Siemens, Otis, Carrier and numerous domestic companies in India.
Responsibilities
- Developed, documented, verified & maintained Test Plans and associated Test cases to meet the business requirements as designated by the QA Manager and approved by the business user.
- Created Test Scripts in Excel for Premium calculation.
- Performed manual and Automated testing and maintain documentation on different types of Testing viz., Positive, Negative, Regression, Integration, System, User-acceptance, Performance, and Black Box.
- Used Test Director 8.2 on the local environment and on the network created common depository.
- Automated tests of the web interface using QTP.
- Ensured performance of various sub systems and tested their interfacing.
- Validated the mapping and integrity of data populated in an Oracle database.
- Logged in Issues in PVCS tracker (an online tracking System) arising during testing.
- Evaluated the progress and took initiatives to meet the QA testing targets
- Inspected motor parts against the engineering prints.
- Documented various test performed on the motors.
- Generated department reports regarding the performance of the motors.
- Communicated with the purchasing subdivision and exterior vendors to source the motor parts and assemblies.
- Oversaw the production stages and assembly line quality control.
- Played key role in the creation of a proficient and efficient system for ensuring the quality of product.
- Helped other departments to create compliance information packages.
- Managed all quality assurance in Gepo Foods\' factory and reported directly to the Factory Manager.
- Managed a team of 6 people; assigning them tasks, and motivating them to meet deadlines.
- Demonstrated the quality assurance procedures to customers on factory visits.
- Performed Quality Audits at the factory.
- Created computer applications with the help of a programmer to monitor the factory environment.
- Analyzed the quality assurance system and made recommendations for improvements. These were incorporated into the current quality assurance system.
- Examined equipment in the factory to check that it met the company standards.
- Investigated new equipment installed in the factory to make sure that it would comply with quality assurance procedures.
Environment: QTP8.2, Load Runner, Test Director8.2, Oracle, PL/SQL, Java, and UNIX
Project: Portfolio Analysis and Reporting (Banking) Jan2004 – Dec2005
: QA Analyst
Project Description:
PA&R (Portfolio Analysis and Reporting) is a project for IB (Investment Banking) division of JPMorgan Chase. PA&R as a whole involves functions such as Managing and limiting the firm’s credit exposures, analyzing the existing portfolio of credit and hedging risks. Thereby, it supports lines of business such as Global Credit Risk Management (GCRM) and Credit Risk Policy (CRP). It comprises of applications dealing with contradictory, but still complementary technologies such as Mainframes and Client-Server. All the applications under PA&R, deal with Data Sourcing, Data Analysis, Data Warehousing and Reporting.
Responsibilities:
- Developed the multiple testing scenarios based on the Business requirement’s use cases and user interface
- System testing to ensure accurate end to end functionality
- Test execution of Integration testing, end-to end testing, System Testing, Functional testing
- Prepared TestScenarios for automation and developed automation test scripts using QTP
- Used SQL Queries for data validation and writing SQL Statements using QTP as an interface.
- Generated test scenarios, test cases and test data. Executed tests, created defects reports using Test director
Environment : Test Director 8.0, Lotus Notes, MQC 9.0,.Net, SQL server, Windows XP Professional, OS 390, Java, JCL, DB2, Excel, MS Visio, PowerPoint, QTP 9.0
Confidential, CO Feb2003 – Nov2
: Tax Specialist
Description:
A leading national income tax and financial products service provider.
Responsibilities
- Prepared Income tax returns and amended returns for individuals.
- Provided advice to clients on related tax implications and tax planning.
- Responded to IRS notices.
- Provided advice to clients regarding financial products of H&R Block.
- Developed the multiple testing scenarios based on the Business requirement’s use cases and user interface
- System testing to ensure accurate end to end functionality
- Test execution of Integration testing, end-to end testing, System Testing, Functional testing
- Prepared TestScenarios for automation and developed automation test scripts using QTP
- Used SQL Queries for data validation and writing SQL Statements using QTP as an interface.
- Generated test scenarios, test cases and test data. Executed tests, created defects reports using Test director
Environment : Test Director 8.0, Lotus Notes, MQC 9.0,.Net, SQL server, Windows XP Professional, OS 390, Java, JCL, DB2, Excel, MS Visio, PowerPoint, QTP 9.0