Name – Manjula Dollegowda Ramegowda

Email - adg0om@r.postjobfree.com

PHONE NUMBER - 908-***-****

Professional Profile:

Quality Analyst with 10.5 years of experience in Software systems analysis, development and Quality assurance especially in client/server and web-based applications for Various Clients.

Data science skills – Python, Pandas, NumPy, Data Visualization, Data cleaning, MS SQL, Concepts of AI

Manipulating, cleansing & processing data using Excel, Access and SQL.

Responsible for loading, extracting and validation of client data. Liaising with end-users and 3rd party suppliers.

Analyzing raw data, drawing conclusions & developing recommendations Writing SQL scripts to manipulate data for data loads and extracts.

Developing data analytical databases from complex financial source data. Performing daily system checks.

Data entry, data auditing, creating data reports & monitoring all data for accuracy.

Designing, developing and implementing new functionality.

Experience in Finance, Retail and Insurance Industries as a QA Analyst/QA Tester.

Strong ability to understand Business and user Requirement.

Strong Testing Experience in Functional Testing, Performance Testing, Integration Testing, Regression Testing, GUI Testing, Database Testing and Compatibility Testing as well as cross browser testing.

Experienced in Writing and developing Test plans, Test cases, Test case design, Test Reports for the specific business requirements and documentation of both Manual and automated tests.

Excellent programming knowledge in SQL, PL/SQL,, VBScript, HTML, & UNIX

Experience in various levels of testing: System testing, Integration testing, Regression testing and Business Acceptance (BAT).

Good experience in performing User Acceptance Testing (UAT)

Responsible for Identifying Users who will participate in testing, developed and coordinate the development of test scripts, test cases and test data. Gathering test result and provide testing feedback to the project manager.

Extensive understanding of SDLC and STLC Life cycles

Experience in testing XML files and validating the data loaded to staging tables for Service Oriented Architecture (SOA).

Experienced enough with MS Project and MS Office.

Extensively worked on database testing (Oracle, SQL Server, Sybase) and validating the application against the database

Strong technical Knowledge of UNIX Utilities, shell Script to automate process.

Sound Knowledge in RDBMS i.e. Oracle, SQL Server, DB2, and Backend Testing using PL/SQL Scripting.

Good experience in defect tracking and reporting using Test Director/Quality Center.

Experience in using Clear Quest for tracking and reporting defects.

Extensive Experience with mercury Interactive (HP) Tools (Quick Test Pro) using Black Box Testing.sucess

Involved in Back End testing (Data Validation Testing) by writing SQL queries.

Executing, Maintaining Test Scripts and Updating as and when the business rules change.

I have completed my Data Science course and willing to work on this field.

Technical Skills:

Operating Systems: MS DOS, Windows NT/2000/ME/XP/Vista, Unix, OS/400

Programming Languages: SQL, PL/SQL, HTML, DTML, XML, VBScript, Javascript, Python

Office Software: MSOffice (Word2010, Excel 2010, PowerPoint 2010)

Database Technologies: MS Access, MS SQL Server 2012, Oracle, DB2

Testing Tools: Test Director 8.0, Quick Test Pro 11.0 (QTP) Rational Clear Quest, and Bugzilla, Toad for Oracle

Version Control Software: IBM Rational Clear Case, MS Visual Source Safe 6.0

Data visualization software - Tableau Software

Education Details: BE in Electrical and Electronics Engineering – 1995- SJCE, Mysore.

Professional Experience:

Project: Major USA Telecom Provider Firm Sep 2007 – June 2009

Client : Sprint

Role : Team Lead

Integrated Retail Management System

Project Description: Integrated Retail Management System is a point of sale application. This application is used mainly in Sprint stores and in affiliate stores. It is a business-critical application. The application is used by over 8000 users and in over 800 stores. Retail Management System is used to sell Sprint phones and is also used for customer maintenance activities like password change, billing language change, plan change (related to mobile phones), change of mobile number. It is also used to maintain Inventory of mobile phones and their accessories. It maintains an exhaustive list of stores, their location and the users of the application in these locations. Sprint merged with Nextel. The Nextel retail stores also started using the Integrated Retail Management System (iRMS) application. This application will support both the Sprint customers and Nextel customers

Contribution: As a Team member and Test Lead, I am responsible for test case preparation, execution and regular accurate status report generation for our IBM US customer Sprint-Nextel.

Role/Responsible for:

Leading and managing the System and End-to-End testing team.

Involved in Effort estimation, Test case preparation, Test data request, Defect tracking and Test case execution tracking using Quality Center tool.

Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.

Involved with Test Strategy and Test Plan in agreement with the project stakeholders.

Managed testing effort for UAT test teams for project before production (go-live).

Created test strategies to detail testing activities from requirements gathering thru defect management thru UAT to production.

Created XML Input files for SOA Testing and worked extensively with SOAP UI to validate web services

Involved in Review Test scenarios, Test scripts prepared by the team and ensure business sign-off.

Involved with both static (reviews, walkthroughs, inspections& peer review) and dynamic testing and maintain all documents in Confluence.

Involved in testing like -UAT, KPI Testing, E2E Testing, Functional, Integration, Content testing, Cross Browser with different- different e.g. Chrome, Mozilla, IE), Regression and System Testing (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing, Maintenance testing.

Created and Verified Web services API requests, SOAP Protocols.

Experience in Testing Validation Rules, Work Flows and Approval Processes for new Tasks, field updates, and Email generation according to application requirements.

Voluntarily involved in giving training for new joiners in our team.

Key projects handled so far include UBP 3.0 (System Testing and Triaging the problem tickets) UBP4.0 (End-to-End testing)

Awarded “The Best of IBM Bravo Award” for playing the pivotal role and leadership demonstrated in nurturing the RMS -Enterprise Testing Team for client Sprint-Nextel.

Project: DFS – PCS Consolidated layer July 2006 – Aug 2007

Client : Sprint

Role : Team Member

Project Description: DFS –– PCS Consolidated layer is supporting the Billing System for one of the Major Telecom Providers (SPRINT-NEXTEL) in U.S.A. The Consolidated Layer (CL) is being developed to provide a consolidated source of enterprise billing and usage information. This approach provides a staging area to consolidate billing information from multiple systems. The consolidated information from the Billing Systems is extracted from the Consolidated Layer and fed to downstream data-marts. Downstream applications perform various analysis and generate reports from these data-marts.

As a tester following are my responsibilities in this project.

By reading and understanding the SR documents we got some idea about the nature of Test cases to be designed like Loading, Extraction and also it helps us to know the business requirements.

Preparing the Detailed Test Cases and reviewing the same with the development and analysis team. Leading and managing the System and End-to-End testing team.

Preparing the Test data for the business scenarios & validating the Detailed Test Cases by executing the scripts.

Involving in Test Environment setup for System testing and Regression testing.

Documenting the Test result & and defect tracking with Development team till the particular defect got resolved.

Performing the End-to-End testing and do the Manual verification for all basic file Characteristics.

Performed Sanity testing, GUI and Functional testing, Post Production validation as per task packets.

Back end testing of the application using SQL queries for the Content Testing.

Performed data accuracy, data validation, and data integrity testing by querying the database using SQL Queries to check the data table on the Server.

Utilized process-based test management system Quality Center for organizing test requirement's documents, test plans and test lab.

Figuring out various error handling strategies to be adopted during cross system data migration.

Sprint PCS Sep 2004 – Jun 2006

Responsibilities:

Developed Test Plans, and Test cases based on requirements, and technical and design specifications

Ran UNIX shell scripts to count the records for EDW source to staging tables.

Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.

Developed Test data requirements and data dependencies, and conditions for all test cases.

Performed Functional, Integration, and Regression testing

Identified Test scenarios for Automation for critical functionality.

Worked with business team to test the reports developed in OLAP

Developed Automation test scripts, and run the scripts as part of regression testing.

Quality Center used for Test Cases development and test execution status tracking.

Testing the data present in fact tables and dimensions tables.

Performed Data Validation, Data Conversion and Data Reconciliation Testing.

Performed HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.

Defects found tracked and managed in Quality Center and disposition in defect scrub meetings.

Represented in Project and Defects scrub meetings, and provide status on assigned tasks.

Testing status reported to QA Manager and project manager.

Involved in production data validations for each change in all releases

Involved in SQL queries to pull out data from database.

Project : Resource Management Tool (RMT) Jan 2003 - Feb 2004

Client : CTG (Computer Task Group)

Role : Team Member

Brief description of the project:

To Migrate the Resource Management Tool written in VB application to web enabled using .Net technologies

The existing Resource Management Tool is used to:

Allocate resources

De-Allocate resources

Re-allocate resources

Resource availability

Resource forecast

Customer billing

Creates New Projects

Import the plan-view hours’ weekly

Generate Management Reports

Role/Responsible for:

Participated in writing Test Plan and Test cases, software documentation from business, technical and functional requirement.

Created and documented the Test Scenarios for each functional area mentioned in Test Plans to develop the test scripts.

Developed test data depends on the Test Scenarios as per the functionality of the application.

Performed Integration, System, GUI and Functional testing as per task packets.

Back end testing of the application using SQL queries for the Content Testing.

Documenting the Test result & and defect tracking with Development team till the particular defect got resolved.

Performing the End-to-End testing and do the Manual verification for all basic file Characteristics.

Project: b2b-helpdesk.com Dec 2000 - Aug 2001

Client : Activeservers.com

Role : Team Member

Brief description of the project:

This is a generic product developed for Web Sites Administration. This product can be used by and site which need an Administration module to answer queries about the site or the service they provide. This product can be purchased and can be used independently or they can sign up and pay a yearly fee and provide a link on their site.

Role/Responsible for:

Developed and conducted a wide range of tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.

Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.

Performed the Backend Integration Testing to ensure data consistency on front-end by writing and executing SQL statement

Being part of the test team, responsibilities involved writing complex queries using SQL and PL/SQL to generate data based on the complex derivations for each attribute.

Validating the data passed to downstream systems.

Involved in functional, integration, End-to-End, interface, performance, system, black box testing.

Involved in Database Validations, Writing Test scripts (Including the related SQL Statements by joining various tables) depending on Requirements for both Positive and Negative Scenarios.

Project : Taj Technologies Pvt. LTD Dec 1999 - Oct 2000

Client : Taj Group

Role : Team Member

Brief description of the project:

The entire project has been broken down into five modules.

Q-Bid Logon Process: Logon. Create new userID, logon validation, displaying rules and Maintenance

Q-Bid Auctionator: Current auctions, New Auctions, Forthcoming Auctions, Listing Auctions, My Bids, Feature auctions

Customer Services: Edit profile, LogOff Application, Rules page, Application Help/demo

Automated process: Start an auction; close an auction, update/display, and bid-Winners

Backend Services: Auction Maintenance, Program code maintenance, Denomination Maintenance, Product catalog maintenance, Product category maintenance, and Bid Maintenance, Winner Notification

Role/Responsible for

Software Engineer

Involved in the Coding the Project for BI Performance q-bid auction development, Taj Technologies Pvt. LTD

Involved in Coding & testing of the programs.

Responsible for design screens, functionality, coding and database designing

Involved in Coding & testing of the programs.

Involved in Integration & Acceptance testing.

Project : Share Accounting System and Banking Sep 1998 - Nov 1999

Client : Pentafour

Role : Team Member

Brief description of the project:

Share Accounting System

Developed the software package for maintaining records of shareholders of an organization. The organization plans to issue 10Million shares @$10 per share. The project is designed to automate the share accounting system.

Banking

Developed the software package that maintains the records of Account holders in “Master File”. This includes Saving Account, Current Account, Fixed Deposit Account and Loan Account. Transactions of these accounts are maintained in “Transaction File”.

Role/Responsible for:

Participated in Requirements Analysis, Design Development. Prepared the Prototypes for the Screens LLD and UTP.

Responsible for design screens, functionality, coding and database design

Involved in Coding & testing of the programs.

Involved in Integration & Acceptance testing.

Contact this candidate