Systems Analyst Resume
Napa, CA
SUMMARY:
- Highly Motivated IT professional with over five years of diversified experience in the areas of Software Quality Assurance and Testing.
- Strong knowledge of Software Development Life Cycle (SDLC) including Waterfall, Agile and Spiral Methodology.
- Strong knowledge and hands on experience on black box testing (functional testing) to test c/c++.
- Performed Manual Testing and Automation Testing of Client/Server, data warehouse and Web-Based n-tier applications using various testing tools like Automation testing tools such as Silk test, QTP, Win Runner and Load Runner
- Highly effective in communicating with Developers & end-users, and translating scientific information into everyday language
- Experience in preparing test approach documents, test plans, test conditions and test cases
- Experience working with Selenium IDE
- Manual Testing expertise includes creating Test Plans and executing Test Cases, Data Driven Testing, Back End Testing (on Oracle using SQL queries) and Data Integrity Checks on the Database
- Strong knowledge and experience with programming Languages like C++, JAVA, and Visual Basic.
- Standardize artifacts, templates and checklists as per the needs of the project.
- Extensive experience of working with Quality Center, Jira, Rational Clear quest
- Experience in establishing the Requirement tractability matrices, test case to requirement traceability and various status reports.
- Highly effective in communicating with Developers & end-users, and translating scientific information into everyday language.
- Ability to adapt to new and ever changing Technology.
- Have experience on various environments like UNIX and Windows platforms and UNIX Shell Scripting.
- Excellent multi-tasking and time management skills and developing resource plans.
- Motivated team player with excellent analytical and detail oriented skills.
TECHNICAL SKILLS:
Tools and defect tracking tools:Quality Center, Jira, Quick Test Professional (Q.T.P), Win Runner, Test Director, Load Runner, Rational clear quest
Modeling:
Use Case Modeling, Sequence diagram, Activity Diagram.
Methodologies:
SDLC, RUP, Waterfall, Agile.
Operating System:
MS-DOS, UNIX, Linux, Windows 98/XP/ME/NT
Web Technology:
J2EE, HTML, XML.
Languages:
SQL, C++, Java, HTML, VB
Databases:
MS SQL server, DB2, Oracle 8i/9i,Teradata, Oracle 10g, Oracle 11g
MS Office suite:
Word, Excel, PowerPoint, Project, Visio
PROFESSIONAL EXPERIENCE:
Confidential,Napa, CA
Duration: June 2011 to Present
Designation: Systems Analyst
Project Description: Confidential,is fiercely committed to its mission of advancing, protecting, and rewarding the practice of good medicine. It is the nation’s leading physician-owned medical malpractice insurance carrier and a financially strong company, with sound management, consistent leadership, and a history of uninterrupted growth.
Roles and Responsibilities:
- Extensive experience gathering and defining, businessrequirements (BRD) translating them into technical specifications and functional requirements(FRS) documents for the inbound and outbound EDI processes for HIPAA compliant files.
- Experience in interacting with Stakeholders, gathering business requirements and delivering business process outputs.
- Experience to work with vast array of information gathered during elicitation.
and able to respond in a timely manner to rapidly changing information. - Proficient in understanding the working knowledge of relational databases, client-server andweb-based concepts.
- Document business rules and maintaining rules repository develop test plans, test scripts and covering all Test scenarios and eliminating redundancies in performingQuality Assurance testing.
- Execute Test Plans to ensure that defects are detected prior to release.
- Analyzing data results and providing conceptual solutions to systems design work.
- Coordinating with the users and performing UAT testing.
- Extensive experience in tracking solution functionality and performance to ensure that it meets market needs through analysis and validation of functional requirements, visual design, test plans and test code development.
- Testing user interface and database testing by executing SQL queries.
- Involved in the regression testing and unit testing of the upgrade of Oracle Database from 10g to 11g
- Involved in testing the upgrade of MS office from 2007 to 2010.
- Experienced in using defect-tracking systems like Quality Center, Axosoft, Borland Star Team Cross-Platform.
- Experience in Running batch jobs using Tidal scheduler.
- Experienced in testing and analysis of applications developed using different technology suites like J2EE and.NET
- Extensive Knowledge of all phases of Software Development Life Cycle (SDLC) and SDLC standardssuch as Waterfall, RUP and Agile.
- Experience in analyzing changes and identifying areas of the application to be Regression tested.
- Good working knowledge of major Operating Systems and testing applications on WindowsNT/2000/XP/Server2003 and UNIX environments.
- Ability to manage work within tight deadlines and flexible to shift priorities quickly within a fast paced work environment.
- Enthusiastic, fast learner and motivated with a positive outlook and strong written, verbal and documentation skills.
- Ability to handle multiple tasks and work independently as well as in a team.
Environment: Windows 2000/NT/XP, Oracle 10g, Oracle 11g, C#.Net, SQL server, Star team, Toad for oracle 11.5.1.2, Tidal scheduler 3.0, VMware.
Organization: Confidential,Harrisburg PA
Duration: Jan 2009 June 2011.
Designation: QA Engineer
Project Description: Confidential,aproperty and casualty Insurance company. It deals with thePennsylvania Farmers and Thresher men’s Mutual Protective Association, under the name Pennsylvania Thresher men’s and Farmer\'s Mutual Casualty Company. Worked on the automated payment plan project and the system involve data processing both via online screens and batch processing. Also had to test c/c++ using black-box testing, used to test c-compiler we use a pro-C compiler, which means that we have embedded SQL statements, accessing an Oracle database. The results almost always are data updated or inserted in the database, and the input for the processes is also taken from the database .The online processing involves screens for data capture of the \'Insured\' by insurance agents, validation of the information for providing the quotations and preparing data for batch processing to post data to legacy systems. The batch processing involved updating legacy files, automatic renewal process, printing of face sheets and auditing.
Responsibilities:
- Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers using rational requisite pro
- Performed the software performance testing to test web applications.
- Was involved in black box testing (functional testing) for testing C- compiler (C++).
- Involved in all stages of testing the Auto & Home Insurance application.
- Performed Regression and Integration Testing and responsible for interacting with developers and especially when Customer enters his Quote such as Discounts, Models of Vehicles etc.
- Involved in testing data migration from traditional database to Legacy Systems.
- Extensively worked for Functional and SystemTesting.
- Performed Functional and Performance Testing on Property and Casualty Modules.
- Tested the applications in Assembly, and Production environments.
- Designed & Developed Test data using Version control tools Visual Source Safe.
- Tested the validity of the Quote Premiums and Purchase Premiums while comparing the entered Quotes and Purchases with all store data.
- Involved in testing the Property & Casualty application, which delivers the online Auto Insurance information related to the accidents.
- Testing also involved inspecting SOAP, XML requests/responses by looking at the logs.
- Closely interacted with the Test Analyst to resolve the critical problem
- As a test analyst responsible for updating the test scripts and executing these scripts
- Performed Back End testing by writing SQL queries to perform transaction testing.
- Made use of JIRA defect tracking tool to manage, report, document, and communicate the defects found in the application to the development team
- Conducted walkthroughs in an effort to identify and realize the processes and flows involved in the new system.
- Organized meetings with the developers, testers, and other team members.
- Worked with external vendors to incorporate their products into the application.
- Compiled UAT (User Acceptance Testing) for testing purposes.
- Created documentation for the release that included Implementation Plan, Support Plan, and Support Training.
Environment: QTP, Jira, Windows OS, MS-Office, MS Visio, UML, Oracle
Organization: Confidential,Bloomfield, CT.
Duration: May 2007-Dec 2008
Designation: QA Tester/Analyst
Description: Confidential,is one of the largest in healthcare insurance industries. Worked as QA analyst on a web-based application accessed by potential customers to buy Insurance products, get free rate quote and report accident via their website. Liberty mutual is an insurance company that helps people manages the risks of everyday life, recover from unexpected. Rate change analyzer is a client/server based for comparative rating group for viewing and adjusting information about insurance premium rates of various insurance products from different insurance companies.
Responsibilities:
- Tested the Membership, Eligibility and Claims processing applications using rational requisite pro
- Project followed SDLC/Agile.
- Adept at all four modules of Quality center namely requirements, Test Plan, Test execution and Defects tracking
- Converted requirements tree to test plan tree using convert-to-tests wizard and identified/created subjects.
- Creating automation framework using Selenium (Key word Driven Frame work).
- Involved in developing test plan, test cases and test scripts.
- Testing covered integration testing, system testing, positive testing, negative testing and regression testing.
- Developed and executed test cases, produced problem reports, suggestions, system test logs.
- Involved in writing test script using Rational Functional Tester for GUI & Functionality Testing.
- Testing involved standard, image, database, text, page, accessibility, XML checkpoints.
- Involved in carrying out load/stress/performance testing using JMeter.
- Involved in creating Virtual User Scripts, Defining User Behavior, Running LoadTest Scenario, Monitoring the Performance, and analyzing results.
- Involved in backend testing on Oracle Database using SQL Queries.
- Performed Grey Box Testing(Black + White)
- Used bug-tracking tool Quality Center extensively to store all testing results, metrics, implemented Test Plan Document, Defect Tracking and Reporting
- Verified test cases in Requirements Traceability Matrix(RTM) using Requisite Pro.
- Documented reports based onrequirements coverage analysis and communicated to developers.
- Participated in JAD sessions for resolving bug issues.
Environment: .NET, JUnit, Agile, JMeter, Java Script, Selenium, Flex, CVS, HTML, Oracle, Quality Center
Organization: Confidential,Boston, MA
Duration: FEB 2006 Apr 07
Designation: QA Analyst Description: Worked on multiple projects with a major responsibility for a project to build a central data warehouse of financial reference data which can be leveraged by various downstream applications. This was a financial data warehouse applications where in market data for financial instruments such as fixed income, FX, derivatives and equities was sourced from external vendors and through the ETL process the data was transformed based on the business rules and was distributed to the internal clients through user specific data marts. I was mainly responsible to validate and provide qualitative & timely data for FX and fixed income.
Responsibilities:
- Accomplished requirement analysis, functional &system specifications analysis and developing effective test conditions to build the test plans and test cases and contributed at all stages of projectlifecycle and SDLC
- Was involved in performing software performance testing on the database to test the accessibility of the data that is entered and retrieved.
- Responsible for requirement analysis and preparing QA test plans and test scenarios including the test data sets for each test condition
- Closely worked with SMEs for understanding the data requirements and the business processes regarding to fix income
- Performed data analysis using complex SQL & MS Excel functions
- Responsible to track, document and maintain the requirement- test case traceability to ensure effective test coverage
- Performed extensive SQL scripting for testing the ETL process for data Extraction, transformation and loading. Also validated and tested the central data warehouse and specific data marts
- Tested data loading, data integration, data validation&Regression testing
- Develop check points for verifying and validating data throughout ETL process
- Developed test datasets based on the business rules, constraints and wrote SQL scripts for testing those data
- Tested and validated the data from sources system (External vendor data) to target system (Staging table, central data repository and data-marts)
- Developed Win Runner test scripts for regression testing, defined the directory structure for easy maintenance of scripts and executed the scripts
- Formulated Test Plans based on the User Requirement Document for the Functional, Regression and System testing including the test scripts for Data warehouse applications using Test Director
- Developed and Maintained the Requirements- test case TraceabilityMatrix (RTTM) and defect matrix
- Performed defect tracking and classified the defects as Critical, High as well as medium and low severity level for the defects
- After successful development and UAT testing of the product, participated in production testing and also participated at Business Continuity /disaster recovery testing
- Effectively managed the issues and escalated the issues at right time thus implemented the issue management procedures.
Environment: Oracle, Informatica, Quick Test Professional, Test Director, TOAD, MS Excel, MS Word
Organization: Confidential,Bridgewater, NJ
Duration: May2005-Jan2006
Designation: QA Analyst
Description:Confidential, is a services firm specializing in retirement savings and providing other services like Property & Casualty insurance and Life insurance. Foresight is a leading international insurance organization of commercial and industrial insurance in the US.
The project was for claims management system with user enhancements, testing and enhancing the existing workflows and streamlining and refining their claims processes on the commercial Umbrella policies and guidelines to add coverage to General Liability, Hired and Non-owned Auto Liability, and Employers Liability, for a single premium.
Umbrella insurance provides broad insurance beyond traditional home and auto. It provides additional liability coverage above the limits of your homeowner\'s, auto, and boat insurance policies
Responsibilities:
- Responsible for analyzing the business process and documents, and developed Test Plans, Test cases and Test Scenarios.
- Coordinated with the project manager in various aspects of the project such as Planning test automation, creating and reviewing automated tests, maintaining automated tests.
- Experienced inBackend Testing using SQL Serverfor data integrity.
- Performed various tests includingFunctionality, Performance, Interface and Regression testing using Win Runner built in functions.
- Used Test Director to create the bugs and generatereport for the Triage meetings.
- Interacted with developers, team leads and team members to resolve issues.
- Assisted inUser Acceptance Testing (UAT).
- Actively participated in creatingTest Summary Report (TSR).
Environment: Win Runner, Test Director, C++, Java Script, and Oracle.
