Polling App

As mandated by SEBI all AMCs have to do the valuation of bonds on a daily basis. The process followed is the AMC receives a mail from either CRISIL or ICRA on a daily basis at 4.30 p.m. and this mail needs to be replied by the Fund Managers of AMCs after entering the necessary data in the attached Excel sheet on the same day, latest by 5.15 p.m. All this data needs to be stored and preserved for approximately 8 years.

This entire process was being done manually which was very cumbersome and time consuming. So to enhance the process and optimize the resources it was decided to automate this entire process and store the required data in a database by developing an application for the same.

Digital Transaction System

is a utility that handles all the transaction processing occurring in mutual fund companies .DTS works on daily basis and handles all the transaction related data. DTS ensures that every transaction is taken of care and logged into the system. It involves Email and Fax Transaction, Bank Statement Download and Credit Confirmation, Master/Mapping setups. It's a one-stop solution for whole Transaction processing.

Real Time Transaction Credit Confirmation

This utility helps AMCs to reconcile credit confirmations on real time basis from banks, this utility runs at a specific interval and checks for any new transactions received. As soon as the transaction is received the utility initiates the credit confirmation process.

Broker Grading System

This is a desktop application developed for all the departments who participate in Broker/Firm grading, and gives their votes to each and every Broker/Firms. Once all the votes are received from the Fund Managers, Research Analysts etc, the application, calculates the Rank of the firms based on votes received. All the Reports are generated by the system. Once the reports are verified, the system sends the reports to the Brokers/Firms for their ranking.

Upload/Download utilities Automation

There are two teams in AMCs one is Fund Manager and other is Dealer. FM assigns the deal to Dealers then Dealers perform the operations on assigned deals. This process is automated and streamline through an application name called Debt Requisition (Order Management) System. In this system different roles for users so FM, Dealers and compliance can use the system according to their daily operations.

Digital Business Card

A digital business card is an online means of sharing contact information. Like typical business cards, electronic business cards can be customized, designed, and shared with anyone. There are no space constraints with digital cards-you can add as much or as little information to your card as you'd like.

Employee Nomination Module

It allow employees to add and manage nominee details for various benefits like Health Insurance, gratuity, PF, and leave encashment. The module ensures compliance with legal requirements, enhances employee financial security, and streamlines benefit administration.

Additionally, the module can integrate with Organization HRMS Systems for fetching and updating employee details on daily basis in the application.

Medical Reimbursement and CHC Systems

One of the leading Mutual fund Investment companies in India. It is the seventh-largest Asset management company in India. The AMC was looking for an IT partner to implement their Medical Reimbursement and Comprehensive Health Check up system for their employees (Approximately 1400) using the latest technology with existing cloud Infrastructure. They were using a mix of manual and system driven technology to process these functions which was time-consuming and prone to errors. Cylsys Software created a robust and Easy to use system which made the entire process digital and thereby saving time and aiding the team to execute the entire process accurately and seamlessly. The new system made sure that Employees were able to register their Medical claims or requests for a Comprehensive Health check up with utmost ease. The new system also made a huge positive difference to the Medical Administrators at client AMC in executing processes like checking the claims, giving sanctions, releasing the sanctioned amount payments into Employee’s salary accounts in record turnaround time. It was a win-win situation for all the parties involved.

Tour Management System

This application streamlines the entire Travel and Ticket booking process for Employees of an Organization who travel for official tours. This system automates various tasks and processes and simplifies Tour planning, Tour approvals. scheduling and co-ordination resulting in better services delivered and improving overall productivity. Some of the modules in this Application are - Tour Requests from Employee's/ Tour approvals by the designated supervisor, Tour Advance processing/ Tour Rescheduling and Cancellation / Travel Desk Operations/ Tour Bill claims and processing by Accounts and much more

Additionally, the module can integrate with Organization HRMS Systems for fetching and updating employee details on daily basis in the application.

IT & Fixed Assets Management System

Every Organization has an IT Department which procures IT assets ( eg .Laptops. Desktops, I Pads etc) and assigns it to Employees at various locations/branches for use. These IT Assets are then tracked , audited annually, disposed of (after a particular time period), taking care of Warranties/AMC's of those IT Assets etc. This Application covers all these functionalities and more and ensuring that the life cycle of any IT Asset right from procurement/assignment/audit disposal is captured in the system and generates various Reports to help the IT Department to keep track of these IT assets.

Similarly. the Fixed assets module covers the Fixed assets ( Office furniture - Tables, chairs, sofas etc and Office Equipment - printers, projectors, fax machines) ( Equipment used commonly at various office locations /branches). This module take scare of the procurement/ assigning and annual audit of these Fixed assets

Mapping Automation Project

This Project revolves around the functionality of Mapping. In certain scenarios like Employee movement like Transfer, Appointment/ Resignation there is an impact on the Business relationships which those Employees are handling for that location /Branch. This Employee movement compels the smooth transfer of Business relationships or Mapping in the system from the Old employee to the new Employee at that location /Branch. This Application automates the entire Mapping process which was manual with its own share of manual interventions and rectification of errors , standardizes all the Masters and its maintenance and streamlines the entire process for all the stakeholders in the process.

Debt Requisition

There are two teams in AMCs one is Fund Manager and other is Dealer. FM assigns the deal to Dealers then Dealers perform the operations on assigned deals. This process is automated and streamline through an application name called Debt Requisition (Order Management) System. In this system different roles for users so FM, Dealers and compliance can use the system according to their daily operations.

Redemption Automation

fully automate the entire process of creating upload files (using CAMS file as input), uploading those files on banks website and reconciliation of payment status between CAMS file, Bank Reverse Feed and Bank Statement.

CIOS

In order to maintain the log of inward and outward mails, parcels, search records, generate MIS reports. This module also helps to print labels and export the existing data. The distributed process of mail management becomes centralized.

Financial DB

This application is used to manage storage and retrieval of analyst company data created in-house. Company Financials and ratings retrieval very cumbersome and time-consuming.

Key Employee Compensation scheme

As you must be aware , SEBI has issued a circular on April 28th 20121 on Alignment of interest of Key Employees of Asset Management Companies (AMCs) with the Unit holders of the Mutual Fund Schemes, in terms of which a part of compensation of the Key Employees of the AMCs shall be paid in the form of units of the scheme(s), in proportion of AUM of mutual funds schemes for which they have role/oversight. According to SEBI mandate, 20 % of the Key Employees salary has to be paid in form of units of the scheme, in proportion of AUM of mutual funds schemes for which they have role/oversight.

Our Application computes the percentage, that will be paid in form of units of the scheme. The application will calculate the amount that has to be invested in each scheme. And accordingly the HR team will distribute the salary in different Schemes.

SRRMS

Fund managers need to peruse relevant research reports and prior meeting notes while preparing to attend company meetings. Department of Security Research has a large number of research reports created over the years. The Research Team prepares reports on a particular company after interacting with the company officials, perusing the published information of the company and other news related to the company. These reports need to be perused while preparing to attend company meetings. Through this Web application, we have provided a one-stop solution to all the RA and FM for daily Reporting. Following are some key features:

• Report Uploading module
Sector Wise, Company Wise Search Options.
• Dashboards for HOD, to view and approve the Pending Reports.
• Pending Invest Arguments , Initiating Notes
• Reminders for Uploading the IA notes etc

Indicative Net Asset Value Automation

• • NSE Data & Analytics Limited provides the 3 different types of data, i.e. Real Time Data, Snapshot Data and End of Day Data. The Real Time Data is a packet broadcast available in TCP/IP packet format, whereas the Snapshot Data and End of day data are available in the form of files. Certain products based on the Real Time Data are also made available through files.
• • Daily at 5 am from SFTP INAV Files folder, receives 5 PCF scheme files.3 NSE PCF files to IN folder of NSE SFTP and 2 BSE PCF files to S&P SFTP. From S&P SFTP, in every 10 seconds 2 INAV files through an API and then stores INAV data into Database for 2 BSE files. If files are not present into SFTP folder, email gets triggered to respective persons.
• • From OUT folder of NSE SFTP, INAV data files comes. Utility reads the INAV data files and saves into POSTGRES database for 3 NSE files. If there is no INAV data file from OUT folder then email gets triggered to respective persons.
• • Utility reads data from database and based on that creates 3 files for NSE, BSE and MF. It sends and stores the 3 files into a Temporary folder.
• • Utility pick up the files from Temporary folder and reads all 3 files. If no file found then email gets triggered to respective persons. If files found then sends files to specific destination folder. NSE file goes to IN folder of NSE FTP folder (Real Time). BSE file goes to BSE FTP folder. MF file goes to MF FTP folder (Real Time NAV).

RM Profitability

Regional Managers plays a very important Role in Fund Houses. Every quarter or half yearly, the Commission n of RM is calculated based on the Profitability This Web application collects all the Reports and data for RMs , and generates the required Profitability Reports There are 8 different types of file formats, that are uploaded into the application. The data is uploaded in form of Excel , these excels contains 7-10 lakh records /excel.

Red Analysis

Fund Houses has to Reconcile the data and Investments received on Daily basis. Once the Reconciliation is done , the Data is stored into the Master DB and many Age wise Reports are prepared. This Web Application ,enables the user to bulk upload the Redemption and Sales files and prepares the Age wise Reports. The whole process of data Reconciliation verification from KARVY , Tag Updating and Report Generation is performed by this application.

Vendor Payment Module

This is Web application for Managing all the Payments and Invoices pertaining to Vendors . This applications helps in Generating the Invoices, GST Calculation. Generating Monthly Reports, Quarterly Reports etc. It maintains and stores the Vouchers and Invoices paid to the Vendors. Reporting module have filter options for , user can customize search the Reports based on following parameters Department / branch from where the bill is raised, Bill Date, Bill, Amount, Party Name, Taxable If taxable, Tax Category Net Bill Amount

Application PDF form Development for Schemes

Scheme forms are critical asea Investors fill these forms to invest in various schemes. The Forms have to be easy to read and filled by the Investor Cylsys has created such form design and made it editable so that investor can fill the details. These forms are available on client's website. These forms with client data via PDF forms are stored on the central server for reporting, compliance and audit purposes.

Index Value Download Automation

In Fund Houses Index Values are monitored and stored on daily basis. All the BSE , NSE , Bloomberg, IIFL indices and their NAV values are extracted from the website and stored into the DB using through Automation. An automated utility is executed at schedules time interval to check the data from BSE /NSE websites and once the data is available on the Source site, this utility picks up the Values and uploads it into the Database. This saves a lot of time and effort of Business user at the peak hour