Saturday, 13 May 2017

Resume_Manual_4+Experience

Dingi

E-mail id:                                                                
Contact Number:

Objective
To work in an organization offering a continuous challenges and excellent growth prospects, where I could contribute significantly to the organization through conceptual and technical skills.

Professional Experience
               
                Working as Software Engineer for Project Monitoring Unit (Finance Department) Govt. of Karnataka under State Accounts Department from January 2011 to till date.
Total Experience: 4 years

Core Competencies

Ø  Excellent knowledge of Manual Testing concepts.
Ø  Good analytical skills to comprehend Business requirements.
Ø  Good understanding of Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC).    
Ø  Experience in Functional testing, Integration testing, System Testing, Regression testing, Smoke testing and User Acceptance testing.
Ø  Good Knowledge of testing process, test tools, creation and understanding of test artifacts like Test Case, Test Plan etc.,
Ø  Experience in developing, reviewing and executing Test Cases.
Ø  Experience in Bug tracking and reporting using defect management tools Bugzilla.
Ø  Exposure to test management tool HP Quality Centre.
Ø  Good knowledge of Test Case Design Techniques.
Ø  Software Methodologies -Agile and Waterfall.
Ø  Good knowledge in Quick Test Professional (QTP).
Ø  Very good knowledge in VBS with the concepts like Loops, Arrays, Functions, Excel Operations, File System Objects.
Ø  Having Experience in using the SQL Commands in cross Checking the Database.
Ø  Good Knowledge in DDL, DML, TCL. JOINs and Sub Queries.








Project 1: Panchatantra(Panchayath Online System for Grama Panchayaths of Karnataka)

Client
Gram Panchayats of State
Duration and team size
Sep 2011 – Till date
Environment
ASP.Net, SQL Server 2000, IIS web server.
Local Language Interface
 Unicode, Nudi, ISM.
Testing Tool
Manual Testing, QC
URL



Project Description :Panchatantra is a web-based application with 3-tier architecture. The Panchatantra system is a comprehensive system, meeting all the requirements of the Grama Panchayats (GP) in the State. It has been built with number of features for easier use by the GP staff. Panchatantra has been designed by incorporating the rules and regulations defined in Panchayath Raj Act. It guides the officers to carry out his/her GP activities as per the rules.

                In this system, users can submit the details of various properties, Beneficiaries, Works, and generate various forms as per requirement. They can also view various                 reports maintained by the department. This project has main modules like Master        information, Demands, Properties, Payments, Receipts, Wards, other information,                 section wise information modules, Panchayat Profile, Habitations module.

                This project is purely based on accrual double entry system for accounting operation      and performing bank reconciliation of each account, yearend process and generating balance sheet.
Roles and Responsibilities :
·         Understanding the Requirements thoroughly.
·         Writing Test Scenarios.
·         Writing Test Cases and Executing Test cases using Quality Center (QC).  
·         Performed Smoke ,Functional, Integration testing, System testing, GUI,
Usability & Regression testing, Acceptance testing.
·         Involved in review meetings and fixing the review comments.
·         Involved in team meetings in order to overcome the problems faced.
·         Involved in Weekly meetings regarding the status Update Understanding the Requirements thoroughly.
·         Cross checking the different data using SQL Queries.
·         Defect Tracking using Quality Center (QC).
·         Analysis and understanding the test case both regarding solution and automation perspective.
·         Imparted Training at client side on the operation of Application.





Project 2: e-FMS for MGNREGA.

Client
Rural Development and Panchayath Raj Department-Karnataka
Duration
April 2011-May 2012
Testing tool/type
Manual Testing, QC
Environment
ASP.Net, SQL Server 2008 R2, IIS web server.
URL

Project Description: e-FMS is “Electronic Funds Management System.” e-FMS software, an independent tool for facilitating online transfer of funds to the beneficiary accounts. In this case, the software is developed exclusively for the beneficiaries coming under the “Mahatma Gandhi Rural Employment Guarantee Act (MGNREGA).” The e-FMS software is intended to be vertically integrated with MGNREGS MIS and Partner Banking software. The e-FMS serves to online transfer of funds seamlessly and on real time basis to the beneficiary accounts those are validated and updated in MGNREGS MIS.
This application contains the modules like 1.Wage List 2.PDO login 3.President Login        4.Bank software 5.Acknowledgement to MIS.
Roles and Responsibilities :

·         Analysis, understanding of Business Requirements and the System functionality.
·         Involved in updating test cases and reviewing the updated test cases.
·         Identifying the different Business scenarios and updating the status to the Business Analyst.
·         Involved in Regression testing, functional testing, Integration testing, system testing, smoke testing, Writing Test Cases and Executing Test cases using Quality Center (QC), Finding Defects. 
·         Reporting Defects manually (by taking Screen shots) and using bug reporting tool QC.
·         Performed Smoke testing, Functional testing, Integration testing, System testing, UI and Regression Testing, and Acceptance testing.
·         Imparted Training at Client Side on the operation of the Application.
·         Defect Tracking Using Quality Center (QC).
·         Using SQL queries for cross checking the Database.


Project 3:MGNREGA (Mahatma Gandhi National Rural employment      Guarantee Act 2005)

Client                                   
Rural Development and Panchayath Raj Department-Karnataka
Duration             
1year-Feb 2011– Feb 2012
Defect tracking tool
 Bugzilla
Environment
ASP.Net, SQL Server 2000, IIS web server.
Testing Tool
Manual Testing
URL

Local Language Interface
Unicode, Nudi, ISM.
Project Description : The MGNREGA has been notified in 200 most backward districts of the country. The objective of the Act is to provide employment to those who demand employment Within 15 days of their demand.

1. The Act provides 100 days of employment guarantee to a rural household.
2.Effective monitoring of the Program necessitates computer based monitoring.

This project contains many modules like creating job cards for rural households,               generating Nominal Muster Rolls, payment of wages to households, work details    module, work allocation module, material bill entry and payment modules, funds receiving and transfer module, fund transfer to implementing agencies module, generating financial reports, bank reconciliation module, automatic fund request     module and many more modules which purely financial business modules.

Roles and Responsibilities:

·         Analysis, understanding of Business Requirements and the System functionality.
·         Involved in Writing test scenarios and Test Cases and Executing Test cases.
·         Involved in updating test cases and reviewing the updated test cases.
·         Identifying the different Business scenarios and updating the status to the Business Analyst.
·         Tested application for Roll Based logins (DPC, PO/block, GP, Implementing agency. Social Audit Logins)
·         Performed Smoke Functional, Integration testing, System testing, GUI, Usability & Regression Testing, I18N testing, Acceptance Testing.
·         Cross checking the data to ensure that if data is being stored in database or not, by executing the SQL queries.
·         Raise the defects, report them in Bugzilla and track them to the Closure after successful verification.
·         Involved in review meetings for the developed scripts and fixing the review comments.
·         Interacting with the developers on a regular basis for application updates and enhancements.
·         Imparted Training at Client side on the Operation of the Application.



Education Qualification

M.Tech in Digital Communication and Networking from SJCIT, Chikkaballapura,   Year of Pass out 2008, Aggregate -70%

B.E in Computer Science and Engineering from Vemana Institute of Technology, Bangalore Year of Pass out 2004, Aggregate -62%

I hereby declare that above furnished details are true to the best of my knowledge.

                                                                                                                                               
Place: Bangalore                                                                                                                                                              
Date:                    


Resume_Manual_2.4_Experience

Ajay Y
Email : @gmail.com
Mob:

CAREER OBJECTIVE
     
   To utilize my skills and abilities in the organization to deliver high quality software to customer.

TECHNICAL EXPERIENCE

Manual testing:
Ø  Dynamic professional with  2.5years of experience in the area of Manual Testing.
Ø  Good knowledge in SDLC & STLC concepts.
Ø  Experience in Component Testing, Data flow testing, End-to-End testing and Regression Testing.
Ø  Writing and Executing Test Cases.
Ø  Active Participation in Test Case Review.
Ø  Hands of experience on QC Test Management Tool.
Ø  Good Knowledge of Test Case Design Techniques.
Ø  Coordinating with the Development team for bug fixing.
Ø  Tested the Application by carrying out Smoke Testing and Ad-hoc testing.
Ø  Knowledge on I18N Testing and  L10N Testing.
Ø  Involved in Compatibility Testing.

AGILE
Ø  Worked in Agile Scrum Module.
Ø  Actively involved in Sprint Planning Meeting.
Ø  Participated in Daily Standup Meeting.
Ø  Involved in Sprint and Release Retrospect Meeting.


Test Management Tool

Ø  Expertise in writing test cases and execution of test cases in Quality Center.
Ø  Proficient in logging and tracking of defects using Quality Center.
Ø  Prepared Requirement traceability matrix using Quality Center.

PROFESSIONAL EXPERIENCE

Ø  Currently working as Software Test Engineer with Techaries Soft Pvt Ltd, Bangalore from Oct-2012 to till date.
EDUCATIONAL BACKGROUND

Bachelor of Engineering (Electronics and Communication Engg) from Government Engineering College.


PROJECT DETAILS

PROJECT #1
Project Name
Golden Eagle

Clients
Fusion Optix Inc, US

Technology
Apache, MySql, PHP, Linux

Test Management Tool 
Quality Center 10.0

Role
Software Test Engineer


Project Description:
Golden Eagle is a custom made solution for our client to assist its various business verticals like organization wide sales, marketing, customer support, and inventory functions. Golden Eagle have features like search option by module name, find and view by tasks name, user lookups by respective field created, export, clone etc. and by offering a common sharing platform through its single database. Golden Eagle contain several modules like promotion, guide, account, capability etc and each of them internally offers a huge set of options to handle, monitor, control, and update regular business data into the integrated system and track them for centralized process. Golden Eagle is built to integrate, strengthen, and expand my client’s business.

Roles and Responsibilities:
Ø  Study and Understanding the Business requirement.
Ø  Participated at Requirement review meeting.
Ø  Involved in writing Test Scenarios.
Ø  Participated in Scenarios walkthrough meeting.
Ø  Experience in writing the Test cases as per the Functional requirements.
Ø  Responsible for Reviewing Test cases.
Ø  Involved in Test Case Execution.
Ø  Executed Smoke, Functional, Integration, System Testing.
Ø  I have done Regression and Adhoc testing.
Ø  Proficient in logging and tracking of defects.
Ø  I was involved in Retrospective meeting.

PROJECT #2
Project Name
P2S Paradise

Clients
DMC Visions Inc. Canada

Technology
Apache, MySql, PHP, Linux

Test Management Tool 
Quality Center 10.0

Role
 Associate Test Engineer





Project Description:
            P2S Paradise is a web based application built for specific needs of the clients business.P2S Paradise can be used by all the resources of each and every department in an organization this is one of the centralized software which integrates all the departments of an organization.
            P2S Paradise provides end to end business integration solution to our clients that enable them to offer an un interrupted continuous Business Vertical integration to assist the business users to maintain, monitor and control everyday business activities. P2S Paradise also empowers our client to maintain an Unbreakable information transfer channel with their customers thereby providing a positive thrust to their businesses. This application is very user friendly for the end users and provides various advanced search options to find and track their business continuously.

Roles and Responsibilities:
Ø  Participated in regular project status meetings related to testing.
Ø  Performed Functional Testing, Integration Testing, System Testing and Regression Testing.
Ø  Executed Smoke Testing and Ad-hoc Testing.
Ø  I have done Compatibility Testing.
Ø  Defect tracking and reporting.
Ø  Participated at Bug Triage meeting.
Ø  I was involved in Sprint and Release Retrospective meeting.

KEY STRENGTHS

Ø  Well-organized and strong work ethics.
Ø  Ability to blend into a team, and excel in individual capacity
Ø  Ability to adapt to new environment.
Ø  Enthusiastic when facing new challenges.


PERSONAL DETAILS

Name                           :
Father Name               : 
Permanent Address     :  
                                  


PASSPORT  DETAILS

Passport No                 :
Date of Issue- Expiry :

Place of Issue              :          

Thursday, 11 May 2017

alternative records

  1. To fetch ALTERNATE records from a table. (EVEN NUMBERED)
    select * from emp where rowid in (select decode(mod(rownum,2),0,rowid, null) from emp);
  2. To select ALTERNATE records from a table. (ODD NUMBERED)
    select * from emp where rowid in (select decode(mod(rownum,2),0,null ,rowid) from emp);