One of the oldest and largest broking firms in the Indian Security Industry.
The current process of Portfolio Analytics, by gathering data and performing tasks like calculation and Analysis of different schemes available with each division, is carried out manually. Comparative analysis among different benchmarks was done manually in separate excel sheets. This process was very slow and consumed more effort and there was no in-depth analysis done.
Other limitations of the process were ?
The system provides performance and attribution analysis for mutual fund schemes along with tracking of their financial ratios and valuation parameters.
The system provides performance and attribution analysis for mutual fund schemes across the Kotak Group, along with tracking of their financial ratios and valuation parameters. The aim is to have a consolidated and universal view across the entire spectrum, and to track and attribute the performance characteristics. It also helps fund managers to track and present the performance of portfolios and impact of their investment decisions on fund's performance. They can compare their portfolio with a model benchmark portfolio and with compliance criteria.
Group Snapshot which shows the overview of portfolios of selected schemes, at group level, for the selected duration. It includes information like AUM, Returns, P/E, EV/EBIDTA, ROE, Beta, Sharp Ratio Medium Holding, the Average Holding, Time to Liquidate, No. of stock in the Scheme, Style, Break up like Large, Mid, Small cap, Cash etc.
Performance Tracking - Sector/Stock wise Performance tracking with the benchmark, with their allocation effect and return. Under weighted and over weighted sectors.
Peer Group Comparison with AUM return of 1 month to 1Year with their P/E ratio and P/B Ratio.
Liquidity report calculates and displays the stock wise liquidity i.e. how long it may take to liquidate the entire portfolio. And calculates the overall portfolio liquidation, which needs to be calculated for each stock and get the average number of days to liquidate the total portfolio.
Developed a separate reconciliation module with support for different file formats and configurable data format in order to achieve flexibility for future-modifications to the data formats.
In import file module, Harrier needed to import the data from different systems of research team, Bloomberg, offshore team and fund analyzer team, which required to be given special attention while designing the database. It was required that complete data from research team should be imported in Excel format in some hidden columns that required special emphasis while coding.
Since GUI is developed in .Net while business logic is in Java and XML is used for communication between tiers, the exception and error handling became more important and required to be given appropriate treatment. Passing the collection to the XML reader from the middle tier was particularly challenging.
Information in the Group snapshot report was calculated by consolidating individual values from other reports for individual schemes, particularly from 7-8 different reports that display single values for a portfolio.
Single controller Servlet serves multiple client requests by calling particular store procedure making the process complex and hence required special mapping in data base.
Core Java, Servlet, MS .NET, MS SQL server 2005, Sun One Application Server.
Develop a flexible payment solution as a mobile app that will allow to pay anyone with just a mobile number. The main objective to design this app was to provide hassle-free, fast and secure payment transaction for things we do on daily basis.
PayTonic lets you pay anyone with a mobile number. This helps you to make quick and secure payments to anybody from your phone address book. It uses mobile number as a unique identifier. Transactions can be made using only a mobile number, once registered with necessary bank details which will be saved in a secure PCI-DSS compliant vault. The app is also secured using a 4-digit PIN defined by the user. Separate registration for a merchant receiver is also defined in the app.
Only mobile number needed: Pay & receive money using just the mobile number.
Accept all electronic payments: Pay using net banking, credit card, debit card and mobile wallets.
Offline Payments: Unregistered users can also claim payments.
Direct Payment to Merchants: Merchants don’t need smartphone and can receive direct payments to bank account once registered with PayTonic.
Express checkout: Save your cards and bank accounts for easy transfers.
Secured: Since PayTonic is not a wallet, there is no money to be loaded into it. Hence your money is always safe in your bank.