Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 26

कार्यक्रम PROGRAM |  | तमड कै ररर्र प्रतिक्षण MID CAREER TRAINING |  | PROG CODE
 |  |  |  | IT 1059
तर्षर् समूह SUBJECT GROUP |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य OBJECTIVE |  | UPDATING     KNOWLEDGE     ABOUT     THE     LATEST     CONCEPTS/ DEVELOPMENTS AND FINE TUNING THE COMPETENCIES NECESSARY FOR SHOULDERING HIGHER RESPONSIBILITIES WITH THEIR CAREER PROGRESSION
लतक्षि समूह TARGET GROUP |  | SCALE  IV  &  SCLAE  V  EXECUTIVES  WHO  HAVE  COMPLETED  15-21 YEARS OF SERVICE IN THE BANK
अर्तध/DURATION |  | 3 WEEK
DAY | SESSION | CONTENTS
Day 1 | I | Overview of Indian Banking Scenario | Emerging Trends in domestic and global environment, regulatory      guidelines,      Statutory      provisions, prudential  and  supervisory  framework,  Prudential and supervisory framework
 | II |  | Landscape, Future opportunities, Client expectation, and     processes/new     business     models,     loan restructuring
 | III | Consumer Banking | Market  overview,  understanding  portfolio  /product mix  and  focus  for  business  growth  (HL/EL/PL  and subsidiary business etc.)
 | IV | Customer Orientation & Customer Service | Customer  centricity  and  Marketing-In  the  merging landscape,      Customer      aspirations,      customer experience gap, digital perspective relationship and digital marketing, Financial Advisory services, CPGRS and compliant management.
Day 2 | I | Priority Sector lending | PSL      Guidelines      Agri/MSME      financing      and restructuring, Role of NABARD, Climate Change and sustainable Banking
 | II | Alternate Delivery Channels | Digitization   in   Banking-ATM,   INB,   Kiosk,   Mobile Banking etc.
 | III & IV | International Banking | Treasury management
Day 3 | I & II | Credit Management and Monitoring | Credit decisions and Credit Monitoring, Securities and Guarantees,  Risk  Mitigation  Tools,  Monitoring  SMA Account,  Early  warning  Signals,  Red  Flag  accounts, Stress Asset Resolutions
 | III & IV | Stressed Asset Management | IBC-2016   case   laws/Judgement   of   NCLT/NCLAT, SARFAESI   Act,   RBI   Guidelines   on   stressed   Asset Management, Sale of Assets to ARCs
Day 4 | I & II | Regulatory Compliance Overview | Overview of key regulatory Compliance & regulatory Framework  in  India,  Compliance  Policy  Guidelines, developing compliance culture in the organization
 | III | Information Security Landscape | Basics    of    Information    Security-Introduction    to regulatory  &  legal  Framework  of  IS  Policy,  Cyber Security Act, IT Act-2008, E-Governance
 | IV | Cyber Crimes & Frauds | Cybercrimes,   combating   cyber   threats,   role   and importance   of   people   awareness   (customer   and employees) preventions and Fraud Risk Management
Day 5 | I | Emerging Technology | Importance  of  Big  data,  data  Analytics,  Artificial Intelligence, machine Learning,
 | II |  | Importance of Block Chain technology
 | III & IV | Customer Due Diligence and Overview of Risk Management | Risks    in    Banking    Business,    Risk    Management Framework,      Identification,      Evaluation      and mitigation,   Operational   Risk   Overview,   Internal factors, employee errors, processes/system failures, monitoring    and    control,    FATCA/FIU    reporting transactions,   closing   AML   reports   Filing   STRs, KYC/AML Compliance
Day 6 | I | Emotional Well-being | How  to  maintain  work-life  balance,  personal  and professional challenges, reduce stress and preventing burnout
 | II | Work-life Balance | Understanding the emotional wellbeing connect with a perspective of person’s physical, mental, emotional and social health factors
 | III | Know Yourself | Understanding  Yourself,  SWOT  Analysis  in  order  to perform to the best of one’s ability and Motivation
 | IV | Financial Planning Agile Leadership | Step-by-step  approach  to  meet  one’s  life  goals  by managing   your   money.   Wealth   Management   & Investment Advisory
Day 7 | I | Honing your Relationship Skills | Develop the ability to inspire, influence communicate and build bonds for better interpersonal relationship. Personal & professional relationships
 | II | [NAME] | Leadership  roles,  styles,  desired  behaviors,  traits, strategic orientation, innovation and critical thinking , Leading by example
 | III | Think like an Owner | Taking    Ownership    and    owning    responsibility- organizational goals and Team performance. Task and role clarity
 | IV | Achieving Goals | Goal  achievement-organizational  goals  &  personal Goals. Building roadmaps. End results
Day 8 | I | Thinking Differently | Train your brain to think differently to be unique and ahead, Rationality and maturity in thinking & decision making. Change Management, other’s perspective
 | II | Leadership Concepts | Adaptability  in  the  age  of  disruption.  Growth  and Survival
 | III & IV | Team Building, Negotiation Skills and Conflict Management | Team Dynamics, Fostering cohesive Teams to enhance productivity, role clarity, Conflict Management, driving teams to meet targets
Day 9 | I | Effective Communicatio n | Influencing     Stakeholders,     communication     skills, importance of clarity, completeness and timeliness
 | II | Decision Making | Decision making styles. Effect analysis. Desirability and acceptability. Tools and Techniques
 | III | Time Management | Time and Change management concepts. Prioritization.
 | IV | Delegation | Effective Delegation, Disciplines of execution, principle of delegation, feedback, Follow-up and Monitoring
Day 10 | I | [NAME] | Organization    vision,    mission,    values    and    goal- incorporating  in  personal  behavior  as  an  employee. [NAME], responsibilities. Organizational ethos
 | II | Business ethics and Integrity | Ethics and integrity for sustainable business, addressing the ethical challenges. Customer as business partner
 | III & IV | Experience Sharing | [NAME] and takeaway from the PROGRAM
Day 11 | I | Preventive Vigilance Concept | Preventive  vigilance-A  conceptual  Framework  film  on preventive Vigilance by the CVC
 | II |  | Various tools of preventive vigilance
 | III |  | Case Study on preventive vigilance
 | IV | Audit | An overview of Audit mechanism-Tools and Techniques to     detect     irregularities,     Control     framework, International   Audit   standards    and   evolving   best practices
Day 12 | I | Preventive Vigilance | Topics   for   Group   Discussion   (Preventive   Vigilance Measures/Ethics/Conflict of  Interest/technology as an enabler
 | II | e-Governance | Topics   for   Group   Discussion   (Innovation/            e- Governance/   reducing   discretion/   Best   Practices/ Transparency/ Complaint Redressal mechanism)
 | III & IV | Preventive Vigilance | Groups  to  make  a  presentation  to  discuss  preventive vigilance strategy
Day 13 | I | RSETI and Skilling | Overview, roles, functions, structure and working style of RSETI Training Institutes/Financial Linkage, Role of RSETI/DDUGKY  in  Rural  Transformation  and  Nation Building
 | II | Ice Breaking | Meeting    with    Lead    District    Manager,    District Development Manager (NABARD), representatives from the Dist. Administration. Aptitude/attitude and Altitude for Rural development
 | III & IV | Familiarization with Village Economic Survey | Familiarisation with village and visits to Bank Branch, Animal  Husbandry,  [NAME],  Post  Offices,  Markets, Other  Govt.  Organizations.  [NAME]  by participants
Day 14 | I | Visit to farms and interaction with progressive farmers | Visits  to  farms  for  discussion  on  agri  practices  and interaction with progressive farmers; Seasonal cropping pattern,  [NAME]   sources,  Credit   facilities,   Marketing Facilities,  Training  and  Extension  Service,  Experience sharing conquering hurdles, Future Plans, Introduction to Watershed PROGRAM, Solar Energy, Biogas and any other  innovative  technology  in  implementation  in  the village
 | II | Interaction with [NAME] | Interaction   with   [NAME]   Panchayat   Office   Holders, Panchayat Development Plan, Role of Good Governance in  Rural  Development/  Gram  Panchayat  Development Plan and attending [NAME]
 | III | Interaction with Health Centre and Anganwadi | Interaction at Primary Health Centre, Anganwadi Centre and  Visit  to  School  in  [NAME]  –  Enrolment,  Facilities, Services
 | IV | Delegation | Effective    Delegation.    Disciplines    of    executions, Principles of Delegation, Feedback  and follow  up and monitoring
Day 15 | I | Interaction with Self Help Groups / Mahila Mandals | Interaction  with  SHGs/Joint  Liability  Group  members, Observation of SHG meeting
 | II | Specific Interaction with villagers | Learning  on  different  Govt.  projects  like  Jan  Dhan, [NAME],     DBT,     Digitization     etc.     and     their implementation in the village
 | III & IV | Presentation and Debriefing | Presentation of learning from the visits and debriefing with the SDM/DS/BDO to be arranged by RSETI through Dist. Administration