With deep experience in Oracle applications, Avşa Consulting provides solutions to meet the financial software needs of its customers.
forms 6i -> Forms 9i -> Forms 10g ->Forms 11g -> Forms 12C -> Apex
We refresh Oracle Forms versions and migrate to Oracle Forms 12C or Oracle Apex.
Technology Used in the Software It is a software that uses WPF screens as an interface in accordance with the SOA architecture, communicates with the WCF service from the client to the Application Server and works with XML messaging format.
Software Package Specifications
Multivendor ATM software, EMV kernel, Recycle ATM software, Multilanguage ATM software, Fraud module integration
Achievements
Advanced ATM interface, User-friendly interface, Customer-specific personal menu, High-resolution visualization and advanced user experience that can use advanced visual elements instead of the classic ATM screen, Multi language support, Self-managing terminal application, Monitoring the CPU and RAM consumption of the ATM and taking action when necessary, Monitoring the amount of ATM remaining Disk and generating alerts when necessary, Recognizing which situations (XFS or user interface) that may occur on the ATM and taking action, Applications running on the ATM can control each other, Speed and Performance Increase (Using the power of the banking extension and terminal instead of a separate system), High performance and continuity, Compressing all incoming data to the server, thus reducing the network load
Elimination of integration layers with the banking application, transactions completed without coming to the center with flows managed on the ATM
Utilization of the latest software technologies and infrastructures, Average 30% increase in transaction speed, Operational Ease, Multilanguage e-journal.
With the Multi vendor operator panel, a single operator panel was prepared for all vendors, thus increasing the operational efficiency of branch users.
New approaches in campaign management infrastructure and orientation towards sales-oriented campaign management
Transaction actions can be set via the screen
Automating and shortening deployment operations
Fault management through monitoring application
Effective monitoring with web-based monitoring
Fast solution of problems with effective logging in the client
Products Included in the Software Package
Fault Management, Monitoring/SLA, ATM Definition and report screens, Operator Panel, Receipt Management, E-journal management, ATM Menu Development Application, RKL,EMV management, ATM switch, Reversal Application, HSM applications, Certification Support, Image Preparation (Security Settings), Dissemination application, ATM campaign management, ATM fraud, Fault Management
This software program, which has been developed for the registration and follow-up of accounting transactions, registration and follow-up of sales / marketing activities and reporting of all activities of small / medium-sized enterprises operating in all business lines in the real sector, aims to eliminate the weaknesses of the existing software programs used by enterprises of this size.
The existing software programs used by these enterprises, commonly known as SMEs, are programs that can only produce reports in accordance with the Tax Procedure Law (TPL) and have weak reporting features. The software program we are developing is designed to produce records and reports not only in accordance with the Tax Procedure Law, but also in accordance with International Accounting Standards (I.A.S./I.A.S.) and International Financial Reporting Standards (I.F.R.S./I.F.R.S.), and is designed to measure, monitor and report foreign currency exchange rate risk, interest rate risk, liquidity risk, credit risk and operational risk. Within this framework, businesses using this software are expected to be able to measure their inventories, inventory costs, trade receivables, trade payables, loans, etc. In this framework, it will be possible for enterprises using this software to instantly measure the interest risk that may arise from balance sheet items such as inventories, inventory costs, trade receivables, trade payables, loans, etc., the exchange rate risk that may arise from balance sheet items denominated in foreign currencies, the credit risk that may arise from all kinds of forward sales made without cash collection (against checks/notes or open account debt), the liquidity risk that may arise from all transactions, and the operational risk that may occur according to certain criteria, and to monitor the profit/loss that may arise from these risks instantly in the income statements.
In addition, it will also be possible for businesses to instantly monitor the market values of their balance sheets converted into cash, with the necessary interest, exchange rate and other adjustments. In other words, the records, financial statements and reports of enterprises are created with bank precision
Common Software Features and Technical Infrastructure of Programs
Purpose of Education and Process of Use:
These training programs aim to provide participants at all levels working in banks with the experience of managing risks that may arise in the real market environment and the habits of managing assets and liabilities (balance sheet) in a virtual environment and to create personal risk profiles of the participants.
In the training programs to be held under conditions very close to the real environment, there will first be a theoretical part and the participants will be provided with theoretical information on asset liability management in terms of profitability and risk management; to serve this purpose, a book with a CD will be delivered to the participants one week before the training as a training resource. In addition, a handbook introducing the computer program to be used during the simulation training will be sent along with the source book.
The simulation training, which aims to practically test the theoretical knowledge of the participants who have the chance to prepare for the training a few days in advance, will start immediately after the theoretical training and the participants will participate in two-hour trading sessions. Each participant will start from an equal starting point (i.e. as the owner of a bank established with the same capital) and at the end of each session, the balance sheet and income statement results of the daily transactions with the participants will be analyzed. After this review, which is expected to last approximately one hour, another session will begin and this practice will continue for the remainder of the training.
In the last half-day part of the training, the performance of all participants will be measured and each participant will be given a report card showing their performance by measuring success according to various criteria. After the training, the report card showing the performance of the participants according to various criteria, an evaluation letter expressing the views of the trainer on the personal risk profiles of the participants will be sent to the General Directorate of the relevant bank and brief recommendations will be made about the participants.
Technical Information Infrastructure :
The technical information infrastructure of the simulation programs has been prepared very close to real life and in accordance with the conditions in Turkey. In the program, which was obtained by reproducing the real recording environments where banks perform their daily transactions, it is aimed to perform all transactions of banks as in real information processing systems. There are two main training programs:
Active Passive Management with Simulation,
Users can enter transactions from the Interactive Simulation Screens (intermediate and high-level versions are also used)
They can also make entries from the Manual Entry Screens (elementary versions are also used), print the receipts of the transactions made and see the summary and detailed balance sheet, income statement and maturity follow-up reports after the end of the day. After the end of the trading day, the program automatically performs all rediscount transactions and records and all foreign currency valuation transactions. In other words, interest accruals are made for all loan accounts, securities accounts, deposit accounts, interbank placement accounts, etc. on which interest is defined; valuation of foreign currency denominated accounts is made and the profit or loss of foreign currency positions carried is calculated and transferred to the relevant accounts every day. Thus, users can immediately see the results of their daily transactions in the rediscounted and revalued balance sheet and income statement.
Software Infrastructure:
All of the programs are written on Oracle v19c database, using Developer v11g, which is also an Oracle software development product, in a graphical environment and fully parametric. The parametric structure of the program, in addition to the flexibility and robustness of the Oracle database, ensures that any new request can be realized easily, without the need for changes that require a long time and effort, and with a minimum number of specialized personnel. The changes requested by the participants can be implemented in a very short time (often within a few seconds during training) and only require changing parameter values. Therefore, the maintenance, understanding and correction difficulties of 'hard coded' software and the lengthy testing process are eliminated thanks to the parametric structure of the program.
Simulated Active / Passive Management Training Versions:
As mentioned in the introduction, there are three main versions of the simulation program;
Elementary Simulation Program, which is prepared for management candidates and/or bank employees with limited experience and aims to provide basic accounting, basic balance sheet and income statement information,
The Branch Management Simulation Program, which is prepared for managers who are in the process of transitioning from mid-level management to senior management to manage the balance sheet, and
Senior Management Simulation Program designed to reinforce senior executives' existing balance sheet management experience and improve their pricing and risk management habits.
a. Elementary Simulation Program:
Elementer Simülasyon Programının The target audience of this training program is the prospective managers (M.T.) who have not yet started their jobs and the clerks, assistant specialists and specialists who are already working but have limited banking knowledge. This training program, which was developed to increase the efficiency, shorten the duration and save a significant amount of money, especially for the prospective managers who undergo long and expensive training programs, aims to replace the General Accounting, Credit Process and Financial Analysis, Calculation of Cost of Resources, Financial Mathematics, Fund Management and Treasury Trainings and ultimately the comprehensive Asset and Liability Management Trainings. It is aimed to replace these classical trainings, which last approximately 30 working days and become increasingly inefficient due to the fact that they are verbal towards the end, with this 10-day training, which will be extremely efficient because it is interactive. In this training, trainees will have the following advantages:
In this training, which is recommended instead of classical Bank Accounting Trainings, trainees will be able to observe the receipts of all manual and interactive transactions and the results of these records in the balance sheet and income statement.
In addition to the information provided in the classical Credit Process and Financial Analysis Trainings, trainees will sell commercial, corporate and retail loans, analyze the financial statements of customers and fail some loans.
The imaginary calculations made in the classical Cost of Resources Trainings will be replaced by resource cost calculations to be made on realistic balance sheets and they will be able to see the results of the pricing created by incorrect calculations in the balance sheet and income statement.
In Classical Financial Mathematics Trainings, all calculations made on hand calculators are made automatically by the system on the basis of each transaction. Simple, compound interest calculations, individual loan payments, mathematical explanations of net present value and future value calculations, verification with hand calculators, etc. All transactions will be performed during the entire training and there will be no need for additional time for this training.
In addition to the information on all the instruments introduced in conventional Treasury and Fund Management Trainings, trainees will be able to buy and sell these instruments, buy and sell government securities at auction and second-hand, make repos and reverse repos, buy and sell interbank placements, make FX/TL, TL/FX and FX/FX spot transactions and FX/TL, TL/FX and FX/FX forward transactions, and buy and repay syndicated loans.
They will examine the records of all these fund management and treasury transactions, see the results of these records in balance sheets and income statements, and experience interest, maturity and liquidity risk.
In summary, the 10-day training will have become a highly productive General Banking and Asset and Liability Management Training in the atmosphere of competition provided by the balance sheet responsibility carried in concrete and the competitive environment created.
b. Branch Management Simulation Program:
It is a simulated training program designed to prepare mid-level managers and managers without balance sheet management experience to manage balance sheets, to provide more complex balance sheet management experience to managers who already manage balance sheets, and to recognize and improve Head Office pricing through the Branches Current Accounts.
Those who participate in this training as Branch Managers will increase their experience in managing branch balance sheets, while those who participate as General Managers will increase their experience in both managing the balance sheets of their banks and directing the balance sheets of their affiliated branches. In order to bring the simulation program closer to real life and to enable the users to really improve their skills, a computer environment is set up with an average of 5 banks, three branches of each bank, the CBRT and all parties in interactive communication with each other. In this environment where 5 General Managers, 15 Branches and the CBRT are present, on the one hand, the General Managers of the banks are involved in borrowing and lending money from each other, buying and selling securities or repo transactions, Treasury Bills auctions, open market operations, foreign exchange trading transactions conducted by the CBRT, and on the other hand, they manage and price their branches' competitions to accept deposits among deposit customers and to extend corporate and retail loans among credit customers, which are presented to them by the simulation program. Branch Managers, on the other hand, while assuming the risk and responsibility of carrying the balance sheet, also aim to realize the targets assigned to them by their General Directorates.
An information screen accessible to all bank head offices shows the list of banks willing to borrow and lend money and their rates, banks willing to buy and sell securities and their rates, and CBRT transactions and their rates. An information screen accessible by branches shows the list of deposit customers, corporate and retail loan customers and interest rates for their region.
In addition, market information and news are continuously transmitted to all users. In summary, it is aimed to enable bank managers at all levels to see the results of the work they have to do in real life by doing it in a non-real environment.
c. Senior Management Simulation:
This program, which can be attended by large Branch Managers, Unit and Group Managers and Assistant General Managers who have balance sheet management experience, can be carried out with or without multiple branches.
This program can be offered with participants belonging to a single bank or, if desired, with participants belonging to other banks. Pre-prepared, established bank balance sheets (with or without branches) are handed over to the participants and the participant(s) are expected to develop and manage strategies for the future by analyzing the risks, bankruptcies and other problems in the balance sheets and income statements of their banks. The General Manager and, if any, the Branch Managers reporting to him/her are expected to develop a vision and manage risk by analyzing growth, downsizing, interest rate, maturity, liquidity, FX position opening/closing, changing customer risk profile. The operating principles of this program are exactly the same as the previous version, the difference lies in the complexity of the balance sheets to be managed and the harsher and more disruptive artificial conditions to be created by the CBR.