DRAAOs Phase-II Training

Date Session Topic Faculty PPTs Study Materials
01-11-2021 I Introduction to Database, Types of Databases,  RDBMS Concepts Puneet kumar Sharma,Core Faculty, RTI, Jaipur    
01-11-2021 II Writing Basic SQL Statements,Restricting and Sorting Data (Where clause, Character Strings and Dates and Comparison Operators) Puneet kumar Sharma,Core Faculty, RTI, Jaipur    
01-11-2021 III Types of Procurement –(i)     Open/Limited/Direct Negotiation Tender; (ii)     Single Stage vs Two Stage, Single Packet vs Two Packet system. (iii)    Expression of Interest (EOI), Request for Qualification (RFQ) and Request for Proposal (RFP) Rakesh Vijayvergia, Core Faculty, RTI, Jaipur    
01-11-2021 IV Types of Procurement –(i)     Open/Limited/Direct Negotiation Tender; (ii)     Single Stage vs Two Stage, Single Packet vs Two Packet system. (iii)    Expression of Interest (EOI), Request for Qualification (RFQ) and Request for Proposal (RFP) Rakesh Vijayvergia, Core Faculty, RTI, Jaipur    
02-11-2021 I Selecting Data from Oracle Other Comparison Operators Using the (BETWEEN,IN,LIKE, IS NULL)Operator, Logical Operators, Using the (AND,OR,NOT) Operator Puneet kumar Sharma,Core Faculty, RTI, Jaipur    
02-11-2021 II Rules of Precedence, ORDER BY Clause, Sorting in Descending Order, Sorting by Column Alias, Sorting by Multiple Columns Puneet kumar Sharma,Core Faculty, RTI, Jaipur    
02-11-2021 III Terms and Conditions of Contract:
(i)      General Conditions of Contract (GCC) and Special Conditions of Contract (SCC); (ii) Significant clauses in contract- Performance Security, Term, Termination, Dispute Resolution, Force Majeure, Payment schedule, default, deliverables, etc.; New Procurement Processes- Hybrid Annuity, Swiss Challenge, Revenue Share models.
Rakesh Vijayvergia, Core Faculty, RTI, Jaipur    
02-11-2021 IV Terms and Conditions of Contract:
(i)      General Conditions of Contract (GCC) and Special Conditions of Contract (SCC); (ii) Significant clauses in contract- Performance Security, Term, Termination, Dispute Resolution, Force Majeure, Payment schedule, default, deliverables, etc.; New Procurement Processes- Hybrid Annuity, Swiss Challenge, Revenue Share models.
Rakesh Vijayvergia, Core Faculty, RTI, Jaipur    
03-11-2021 I Single Row Functions SQL Functions Two Types of SQL Functions Single Row Functions Character Functions Case Conversion Functions Character Manipulation Functions, Number Functions (ROUND, TRUNC MOD)  Puneet kumar Sharma,Core Faculty, RTI, Jaipur Single Row Function  
03-11-2021 II  Working with Dates Arithmetic with Dates Using Arithmetic Operators with Dates Date Functions Conversion Functions (TO_CHAR TO_NUMBER TO_DATE) Date Format, Special Functions (NVL DECODE)Nesting Functions Sh. Vinod Sencha, Core Faculty, RTI, Jaipur Working with Dates  
03-11-2021 III Project appraisal techniques; Financial analysis, Sensitivity analysis Dr. Hoshiyar Singh, Financial Advisor    
03-11-2021 IV Project appraisal techniques; Financial analysis, Sensitivity analysis Dr. Hoshiyar Singh, Financial Advisor    
05-11-2021 I Functioning of Overseas Audit Offices Sh. Ramavatar Sharma, AG    
05-11-2021 II Displaying Data from Multiple Tables EQUIJOIN, NONEQUIJOINOUTERJOIN SELFJOIN Aggregating Data Using Group Functions AVG SUM MIN MAX, COUNT GROUP BY and HAVING Clauses Sh. Vinod Sencha, Core Faculty, RTI, Jaipur

Join

Group Function

 
05-11-2021 III Subqueries  Sh. Vinod Sencha, Core Faculty, RTI, Jaipur Subqueries  
05-11-2021 IV Specific clauses in contract: Price variation, Penalty clauses, Blacklisting of a contractor/firms Rakesh Vijayvergia, Core Faculty, RTI, Jaipur    
06-11-2021 I Creating and Managing Tables CREATE TABLE ALTER TABLE DROP TABLE Sh. Vinod Sencha, Core Faculty, RTI, Jaipur DDL  
06-11-2021 II Manipulating Data INSERT UPDATE DELETE COMMIT ROLLBACK Sh. Vinod Sencha, Core Faculty, RTI, Jaipur DML  
06-11-2021 III E-Tendering / E-Procurement
(i)         Tendering, Forward and Reverse Auctions.
(ii)        Manual tendering vs Online tendering/auction
Yogender Bagda, SPFC, GoR    
06-11-2021 IV Weekly test      
08-11-2021 I An overview of PPP and Privatization, Requisites for the success of PPP Projects, Objectives of PPP- Contractual Relationship, Sharing of Responsibilities, Risk Transfer and Flexible Ownership; Role of Pvt. Sector Partner in PPP projects-Strengths & Weaknesses Chetan Prakash Mandawaria, Jt. Director    
08-11-2021 II Institutional arrangements for Appraisal and approval of PPP Project; A study on Organisational structure for Appraisal and Approval of PPP projects; Financial
Powers of PPP Appraisal Committee; Procedure for Formulation & Appraisal of PPP Projects; Appraisal by/ Approval of PPP Appraisal Committee
Chetan Prakash Mandawaria, Jt. Director    
08-11-2021 III Exercise on SQL Sh. Vinod Sencha, Core Faculty, RTI, Jaipur    
08-11-2021 IV Benefits to Public Sector, Private Sector and the public; Common misconceptions about PPP in Infrastructure Projects. Rakesh Vijayvergia, Core Facutly, RTI, Jaipur    
09-11-2021 I Role of SAI in the International Arena including within Associations of SAIs Mrs. Atoorva Sinha    
09-11-2021 II Overview of audit of public sector commercial undertakings  Mukesh Shrimal, AAO, O/o AG (Audit-II), Rajasthan, Jaipur    
09-11-2021 III Financial support to PPP projects in Infrastructure, Model Concession Agreements (MCA); Institutional Arrangements in State Governments Chetan Prakasha Mandawaria, Jt. Director    
09-11-2021 IV Financial support to PPP projects in Infrastructure, Model Concession Agreements (MCA); Institutional Arrangements in State Governments Chetan Prakasha Mandawaria, Jt. Director    
10-11-2021 I Mandate, Scope and Objectives of PPP Audit, Mandate for Audit of PPP Projects, International Auditing Stds. and Guidelines for the Audit of PPP Projects; Scope of PPP audit; Objectives; Types of Documents to be audited; When a Project should be subjected to Public audit.  P K Jain, Core Faculty, RTI, Jaipur    
10-11-2021 II Mandate, Scope and Objectives of PPP Audit, Mandate for Audit of PPP Projects, International Auditing Stds. and Guidelines for the Audit of PPP Projects; Scope of PPP audit; Objectives; Types of Documents to be audited; When a Project should be subjected to Public audit.  P K Jain, Core Faculty, RTI, Jaipur    
10-11-2021 III Basic Concepts of Commercial Accounting Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
10-11-2021 IV Basic Concepts of Commercial Accounting Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
11-11-2021 I Identifying and Sharing of Risks in PPP: Feasibility/Organisational Risk, Condition Precedent Risks, Financing Risks, Construction Risks, Operation and Maintenance Risk, Demand Risks, Revenue Risks, Risk from unforeseen developments, Termination Risks, Residual Value Risks P K Jain, Core Faculty, RTI, Jaipur    
11-11-2021 II Identifying and Sharing of Risks in PPP: Feasibility/Organisational Risk, Condition Precedent Risks, Financing Risks, Construction Risks, Operation and Maintenance Risk, Demand Risks, Revenue Risks, Risk from unforeseen developments, Termination Risks, Residual Value Risks P K Jain, Core Faculty, RTI, Jaipur    
11-11-2021 III Journal Entries Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
11-11-2021 IV Journal Entries Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
12-11-2021 I Auditing Process and Criteria for PPP Audit: Audit Methodology, Audit of Project Formulation and Approvals, Audit of Concession and Concession Period, Audit of Risk Allocation, Audit of Financing Risk, Audit of Viability Gap Funding, Audit of Tariff/Toll/User Charges, Audit of Total Project cost P K Jain, Core Faculty, RTI, Jaipur    
12-11-2021 II Auditing Process and Criteria for PPP Audit: Audit Methodology, Audit of Project Formulation and Approvals, Audit of Concession and Concession Period, Audit of Risk Allocation, Audit of Financing Risk, Audit of Viability Gap Funding, Audit of Tariff/Toll/User Charges, Audit of Total Project cost P K Jain, Core Faculty, RTI, Jaipur    
12-11-2021 III Main Books for Recording Financial Transactions Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
12-11-2021 IV Weekly test      
15-11-2021 I Public Financial Management(PFM) : An overview Dr. N K Gautam, INGAF    
15-11-2021 II PFMS: Registration of user ID, pre-check, sanctions uploading and passing of B Dr. N K Gautam, INGAF    
15-11-2021 III PFMS: Registration of user ID, pre-check, sanctions uploading and passing of B Dr. N K Gautam, INGAF    
15-11-2021 IV PFMS: DDO interface Dr. N K Gautam, INGAF    
16-11-2021 I PFMS : EIS Module ( For generation of salary Bills and other establishment Bills  and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO Dr. N K Gautam, INGAF    
16-11-2021 II PFMS : EIS Module ( For generation of salary Bills and other establishment Bills  and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO Dr. N K Gautam, INGAF    
16-11-2021 III PFMS : EIS Module ( For generation of salary Bills and other establishment Bills  and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO Dr. N K Gautam, INGAF    
16-11-2021 IV PFMS : EIS Module ( For generation of salary Bills and other establishment Bills  and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO Dr. N K Gautam, INGAF    
17-11-2021 I PFMS: GPF Module Dr. N K Gautam, INGAF    
17-11-2021 II PFMS: GPF Module Dr. N K Gautam, INGAF    
17-11-2021 III PFMS: Pension Module Dr. N K Gautam, INGAF    
17-11-2021 IV PFMS: Pension Module Dr. N K Gautam, INGAF    
18-11-2021 I PFMS: EAT Module Dr. N K Gautam, INGAF    
18-11-2021 II PFMS: EAT Module Dr. N K Gautam, INGAF    
18-11-2021 III PFMS: DBT Module Dr. N K Gautam, INGAF    
18-11-2021 IV PFMS: DBT Module Dr. N K Gautam, INGAF    
20-11-2021 I NTRP Module Dr. N K Gautam, INGAF    
20-11-2021 II TSA Module Dr. N K Gautam, INGAF    
20-11-2021 III Important Reports in PFMS Dr. N K Gautam, INGAF    
20-11-2021 IV Important Reports in PFMS Dr. N K Gautam, INGAF    
22-11-2021 I Posting of Transactions in Ledger Pradeep Mundra, SAO, O/o AG (Audit-II), Rajasthan, Jaipur Posting  
22-11-2021 II Posting of Transactions in Ledger Pradeep Mundra, SAO, O/o AG (Audit-II), Rajasthan, Jaipur    
22-11-2021 III Overview of IT Audit Madan Maloo, SAO, O/o AG (Audit-II), Rajasthan, Jaipur Information Security  
22-11-2021 IV Planning of IT Audit Madan Maloo, SAO, O/o AG (Audit-II), Rajasthan, Jaipur    
23-11-2021 I Preparation of Trial Balance Vinod Kumar Sharma, Core Faculty, RTI, Jaipur Trial Balance  
23-11-2021 II Preparation of Trial Balance Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
23-11-2021 III General IT Controls Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur    
23-11-2021 IV General IT Controls Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur    
24-11-2021 I Adjustment entries for preparation of final accounts Vinod Kumar Sharma, Core Faculty, RTI, Jaipur   Adjustment-Entries  
24-11-2021 II Adjustment entries for preparation of final accounts Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
24-11-2021 III IT Controls-Application Controls Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur    
24-11-2021 IV IT Controls-Application Controls Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur    
25-11-2021 I Preparation of Trading and Profit and Loss Account Deepak Khandelwal, CA Trading P&L  
25-11-2021 II Preparation of Trading and Profit and Loss Account Deepak Khandelwal, CA    
25-11-2021 III Audit of IT Security and End User Computing Controls Vinod Sencha, Core Faculty, RTI, Jaipur Audit of IT Security  
25-11-2021 IV Audit of IT Security and End User Computing Controls Vinod Sencha, Core Faculty, RTI, Jaipur EUCC  
26-11-2021 I Preparation of Balance sheet Deepak Khandelwal, CA Balance Sheet  
26-11-2021 II Preparation of Balance sheet Deepak Khandelwal, CA    
26-11-2021 III Audit of Development and Acquisition of IT Assets Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
26-11-2021 IV Audit of Development and Acquisition of IT Assets Vinod Kumar Sharma, Core Faculty, RTI, Jaipur    
27-11-2021 I Issue of Audit Certificate to Commercial Undertakings Mukesh Shrimal, AAO, O/o AG (Audit-II), Rajasthan, Jaipur

Audit Certificate

Issue in GST Audit

 
27-11-2021 II Material Management-Purchasing Concepts Faculty from Indian Institute of Material Management/Electricity Companies    
27-11-2021 III Material Management-Purchasing Concepts Faculty from Indian Institute of Material Management/Electricity Companies    
27-11-2021 IV Weekly test      
29-11-2021 I Material Management-Specifications and Standards Faculty from Indian Institute of Material Management/Electricity Companies    
29-11-2021 II Material Management-Specifications and Standards Faculty from Indian Institute of Material Management/Electricity Companies    
29-11-2021 III Material Management-Procurement Process Faculty from Indian Institute of Material Management/Electricity Companies    
29-11-2021 IV Material Management-Procurement Process Faculty from Indian Institute of Material Management/Electricity Companies    
30-11-2021 I Material Management-Logistics and Warehousing Faculty from Indian Institute of Material Management/Electricity Companies    
30-11-2021 II Material Management-Use of IT Tools Faculty from Indian Institute of Material Management/Electricity Companies    
30-11-2021 III Overall Evaluation test      
30-11-2021 IV Valediction by DG sir