Professional Summary:
A dynamic IT professional with 6+ years of rich experience in the arenas of Software Quality Assurance. Experienced in analyzing Business Requirements and Specifications. Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle, Teradata and ETL. Well domain knowledge in Auto insurance, Health insurance, Telecom, Retail and Financial. Extensive experience in reviewing and analyzing Business Requirements and writing detailed Test Plans, Test Cases, and Test Scripts Experience includes the testing of Client/Server, ETL, SOA and WEB applications using Manual and automated testing tools like Quality center, Rational Suit, Load Runner and Quick Test Professional. Experience on Test management tools like TMS, Quality Center and Test Director. Expertise in implementing RUP (Rational Unified Processes), Agile and SCRUM Methodology by analyzing requirement specifications and responsible for developing Test Objective, strategies, Scope, Test procedures and Test Matrices. Extensive experience in conducting different kinds of tests such as Integration, Regression, Functional, System Testing, Black Box, UAT and Sanity Testing. Experience in working with scenarios related to Banking, and finance Web portal applications Experience in leading the testing effort for Mainframe, COBOL, java, J2EE, .NET applications. Sound knowledge and exposure in working with the various relational databases like Oracle, SQL Server etc. Expert in testing of cross browser Applications (Internet Explorer, Fire Fox, Safari, Opera, Avant, Maximo, Google chrome) with different protocols like HTTP, HTTPS and FTP. Proficient in adhering to SEI – CMM level quality procedures. Results oriented, with an ability to work with aggressive timelines and deliverables and to see any assignment to successful completion within the established project schedule. Extensive expertise in Business Intelligence and Enterprise Application Integration. Expertise in Back end database testing with database Oracle, DB2, and SQL Server. Proficient in executing SQL queries and strong in security backend testing. Excellent Scripting Knowledge of Mercury’s “TSL” for Win Runner, and VB Script for QTP. Excellent working knowledge of designing and implementation of QA test strategy and Test plans manually and automated test solutions for client/server, ETL, SOA Process, ERP and Web applications. Knowledge in testing SOA Architecture, Web Services, UDDI, Network protocols (VOIP, TCP/IP) and IVR system testing. Well in testing of the web services using the SOAPUI and PARASOFT SOA testing tool. Worked with the build/release management teams to validate the system setup and configurations at pre-deployment stage. Experience on Object Oriented Programming (OOP) like C#.NET, Java, using Eclipse and Visual studio with Back end as Oracle and SQL Server. Good verbal and written communication skills. EDUCATION:
Bachelor of Technology Technical Skills:
Testing Tools
QTP, Win Runner, and Load Runner
Defect Tracking Tools
Quality Center, Test Director Rational Clear Quest, JIRA and Bugzilla, Run Test Run
Project Methodologies
Rational Unified Process, OOD, UML, SDLC, Waterfall, Agile
Languages
C, C++, JAVA, J2EE, JSP
ERP
Siebel 8.0
Health Care Tools
FACETS
Data Base
Oracle9i/10g, SQL Server, DB2
Scripting Language
VB Script, JAVA Script, HTML, DHTML, UML and XML
Operating Systems
Windows 2000, 2003, XP, Home, Vista and UNIX
Protocols
TCP/IP, HTTP and HTPS
Application Servers
Web Services, Web Logic and Web Sphere
Version Manager
Visual SourceSafe, PCVS and Clear Case
Browsers
Internet Explorer, Nets Cape Navigator, Mozilla Fire Fox, VMware
Others
MS Office, MS Excel, Visio and Adobe
Professional Experience:
Confidential,Minneapolis OCT 10 – Till Date
Role: Sr. QA Analyst (ETL)
Project Name: RX Transport: RX Transport (DR. Transport) is the graphical interface (GUI) for ticketing for national repair. Primary users are the call center operations technicians in Century Link national repair centers.
Project Name: CRIS Billing System Test: The abbreviation of CRIS stands for Customer Record Information Systems. CRIS billing is the application that rates and edits the customer call records and produces the invoices for the customers based on the services rendered
Key Responsibilities:
Analyzed and reviewed business requirement documents (BRD’s) and system requirement specification documents and functional design documents. Involved in performing day to day testing of product updates and releases Responsible for creating or setting up any test data that is required for every release by coordinating with 10 different backend systems. Responsible for the ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Control - M, UNIX Shell Scripting Automation of the job flow and scheduling the jobs in Control-M Comparing the DB2 input files with ETL output files using the Comparex Unix script designed for the project specific activities Actively participated in writing Test Plan and Test cases Participated in peer reviews of all the documents and Test Cases Tracking software defects and routing them to the right person/team found in the applications while testing. Main contact between Development team, Business Analyst Team and our offshore resource Well versed in covering all the test scenarios because of the strong Domain Knowledge Conducted database testing using SQL queries Used Quality Center for organizing test requirement documents, test plans, test scripts, and defects Interacted with Developers and Business Analyst regarding requirements, test scenarios and defects Used Mercury Load Runner Controller for simulating multiple Vusers for performing load test Analyzed various graphs generated by Load Runner Analyzer including database monitors, network monitor graphs, user graphs, error graphs, transaction graphs and web server resource graphs Trained resources at offshore on daily call from onsite to equip them with knowledge of application Working on several different projects simultaneously Coordinated with Team Lead/PM/Business Analysts for QA Sign off for Test Cases/Test Plan. Participated in review meetings and daily status meetings during the testing process Extensively involved in manual functional testing. Created use case scenarios and documented work flow and business process Delivering project Technical Demos to clients and participating in business calls During the Beta Cycle worked with the END Users (in the PHEONIX, DES MOSINES, SALT LAKE CITY call centers) on daily basis for any issues faced by them and train them on the application. Participated in the User Acceptance Testing with the clients for every release Environment: Caliber (Requirements Management Tool), Quality Center 10, Knowledge Q, Bus tester, SOAP, Load Runner 9.52, SSH/PUTTY, Drools (For generating the flows), Tibco Bus Services, J-Meter, Toad, Oracle 10G, Informatica, Control M, MicroStrategy, Unix Shell Scripting, DB2 database.
Confidential,Richfield, MN JAN ‘10-SEP ‘10
Role: Sr. Test Analyst
Best Buy for business is an internal body of best buy which deals with government and private insurance partners like state farm, HSBC settlements .Prices for the skus, from the fulfillment partners will be loaded every day into the database. The system handles Data load, in store shipping issues and maintains data to be used for running Daily Reports which is very critical for the decision making and strategy planning by the top level management.
Key Responsibilities:
Analyzed and reviewed BRD, SRS, FRS, TRS documents to design quality test cases. Involved in generating Requirements Traceability Matrix (RTM) for functional requirements. Participated in peer reviews of all the documents and Test Cases. Involved in executing test cases manually and reported defects using Quality Center. Effectively interacted with business analyst and technical team in providing clear solutions to requirements. Designed test cases using Test Plan in Quality Center and mapped with requirements. Involved in execution of test cases using Test Lab in Quality Center and linked the detected defect with requirements and test cases. Generated test scripts using Quick Test Professional to check the functionality of the system. Used Quality Center to save the generated test scripts. Linked detected defects during automation to requirements and test scripts using Quality Center. Actively participated in status meetings to report issues. Generated scripts using Load Runner to measure the performance of the system. Performed web testing using Quick Test Professional to check the compatibility, reliability, and scalability of the application in different browsers. Involved in system and User Acceptance Testing. Documented test procedure documents and test results using Quality Center. Performed gap analysis by comparing actual result with expected result. Conducted database validation using SQL queries. Closely interacted with clients, developers, and system engineers to identify application defects, reviews, and follow ups. Environment: Quality Center 9.0, Quick Test Professional 8.0, Load Runner 9.50, oracle 9i, JUNIT, ASP.NET, Perl, HTML, C++, IIS, VB.Net, JavaScript, IE, web sphere, web services, UNIX, LINUX, and Windows2000.
Confidential,Florida SEP ‘08-DEC ‘09
Role: ETL QA Analyst
Project: Automated Financial Systems (AFS) is a major Commercial Loan Systems in Citibank. It is an online processing system but handles batch processing when necessary. Level III allows the design and delivery of new loan products to maximize the profit potential and processes and reports on both currentand future obligations.On each obligation,earnings methods are provided for both interest and fees. Multiple accruals of interest and fees can alsobe done on various balances.The system calculates and reports on all non-refundable fees that are amortized over the life of the obligation. Various methodsPayments, waivers and Reversals are provided. Being a Test Lead involved AFS Module Deliverables.
Key Responsibilities:
Involved in requirement analysis and documentation of functional specs. Identified Test Scenarios for required system and functional testing. Provided support in the preparation of Test Plan specifying an overview of testing approach, testing strategy, and scope. Developed Test Cases as per to the Requirement Specifications. Responsible for testing all new and existing ETL data warehouse components. Experienced at testing ETL\'s and flat file data transfers without relying on a GUI layer Worked with the components of Data Warehousing like components model, ETL tools. Tested Abinitio graphs for File to Table and Table to file conversions required for EBCIDIC format and XML files. Maintained the Requirement Traceability Matrix using Mercury Quality Center. Executed test cases and test scripts manually and using automation tools. Performed Functional, Regression and Integration testing. Responsible for designing and managing UAT test scenarios. Used QTP and RAID automation tools for Functional, Regression and Data Driven testing. Used SQL tools such as SQL Query Analyzer for creating SQL queries to verify the integrity of the data. Performed extensive back-end testing and database auditing using SQL Server. Used Quality Center as a release management tool. Provided production support for the releases. Used Mercury Quality Center and JIRA to house all test documentation, report/track all issues and defects. Provided clear concise feedback to development team on recurring errors both on an individual and team basis. Environment: QTP, Load Runner, Quality Center, Cognos8BI, SQLServer2005, .Net, COBOL, JCL, CICS, DB2, Rumba, QC8.2, VSS, Windows Vista/XP and Informatica Power Center 7.1.2.
Confidential,NJ AUG ‘07-SEP ‘08
Role: QA Analyst
Project: Mercedes-Benz had maintained a reputation for its quality and durability since 1958.The audacity to reject compromise, the instinct to protect what matters, the commitment to honor a legacy, the vision to consider every detail. The project aimed to develop an application for updating the time sheets of employees’ connected online through internal network and VPN worldwide, check overall robustness and performance of the server by conducting the performance testing of the application.
Key Responsibilities:
Analyzed and reviewed business requirement documents (BRD’s) and system requirement specification documents and functional design documents. Actively participated in writing Test Plan and Test cases. Documented the application from business, functional, and technical requirements. Created and documented the Test Designs for each functional area mentioned in Test Plans. Involved in smoke testing, functional testing and automation. Involved in performance testing and functional decomposition of web-based (SOA) and legacy systems architecture. Enhanced and modified test scripts according to the test case scenarios. Worked extensively on Virtual User generator and Controller. Parameterized the scripts for multiple users and enhanced them according to the test cases. Performed Correlation to scripts for multiple users and enhanced them according to the Workflow. Performed functional testing by generating scripts for application using Quick Test Professional. Effectively interacted with business analyst and developers to identify the defects in application. Conducted database testing using SQL queries. Used Quality Center for organizing test requirement documents, test plans, test scripts, and defects. Environment: UNIX, Quality Center 9.2, Quick Test Professional, VB.net, VB Script, TOAD, Ms Office.
Confidential,IL JUN ‘06-JUL ‘07
Role: QA Tester
Allstate insurance has an agency web portal from the agency web portal we apply for the new proposal. Once submitting to the Allstate insurance, we need to verify the proposal is properly mapped to Allstate insurance is e-commerce web Application and once it is there on Allstate insurance web portal we need to verify all the data is mapped to the respective fields in the web application and need to verify the premium amount for that policy.
Key Responsibilities:
Reviewed and Analyzed the System Requirement Specs and understand the control flow of the whole system. Follow the Agile methodology due to the continuous change of requirements. Performed Ad-hoc/Exploratory testing prior to automate the testing on the application. Developed re-useable code to share functionality with different tests, thereby providing easy to maintain. Excellent working knowledge of designing & implementation of all QA test strategy plans manually and automated test solutions for client/server and Web applications with Quick Test Pro. Administration and Automation framework implantation in QTP Excellent Descriptive Programming Knowledge in VB Script for QTP writing the functions from scratch. Develop all required test plans for each release of the software product. Performed Business Processes Testing (BPT) for typical Functionality. Review and approve test cases written by other QC staff members prior to execution Ensure thorough and documented traceability from test cases to design / requirements Write, present/distribute and maintain testing documentation; including release notes, release forms and other necessary testing reports Execute test plans against new software development, including functional testing, regression for the continuous change of price and discounts for different states and performance testing activities. Involved in database testing in writing the queries in SQL server in SQL Enterprise Manger. Developed and executed SQL queries to verify the data Integrity. Interacted with Database Developers during testing, isolated at different levels of Database Testing. Coordinate all quality control defect management and root cause analysis activities. Work with Professional Services to identify defects in products in the pre-production or production environment and posted in the team foundation server(TFS) When identifying defects, make recommendations to prevent future similar defects. Analyze defects looking for and documenting patterns to identify commonality. Assist Sr. Quality Control Test Manager in measuring the effectiveness of the testing effort by tracking trends in defects, requirements, test cases and recommending changes to continuously improve the quality control / testing process Perform the functional testing of web services using soap scope. Build and maintain the Quality Control environment(s) of installed on various desktop computers. Configure, maintain and control all test tools; including Quality Center, Quick Test Professional. Function as the lead tester / mentor for Automation and other assigned testing projects. Create the test environment for the all the flavors of windows and Mac operating system Provide expert analysis and acquisition of testing tools for the Quality Control team. Effectively communicate test considerations, defects, process initiatives, and general status of projects to the Quality Control staff, functional management and executive management. Perform Load and Stress Test By creating V users using Load Runner Used Quality center to log defects and generate defect reports and graphs. Perform the UAT and Implementation testing of the application. Actively participated in enhancement meetings focused at making the application more reliable. Monitored Quality Center to close the bugs/cases as and when developers fixed the bugs. Environment: Quality Center 9.0, QTP 8.2,TFS, Load Runner 9.0, JIRA, .Net Framework 1.1 ASP.NET,C#.NET, AJAX, XML, ,PHP,HTML,CSS, SQL Server 2005, SSIS, SSRS, SSAS MS Excel, UNIX, Windows XP, MAC OS and MS office.
Privacy Policy
