IUT is an Integrated Unit Trust module for State Street Bank & Trust Company (UK). Responsible for co-ordinating teams, developing and maintaining windows forms and web pages, creating stored procedures/functions, performing unit testing, fixing defects, reviewing code, and carrying out urgent changes on servers. Also involved in code migration to Git.

Developed an application for financial package, designed financial reports, created Chart of Account (CoA) master, Ledgers, Groups, Currency, Exchange rate, and Company master. Responsible for requirement analysis, development, support, unit testing, and status reporting.

IUT is a Integrated Unit Trust module. The UK Unit Trust industry is unlike any other security market in UK.There is no centralized market for the purchase or sale of unit trusts and no centralized settlement system. So Unit Trust create our own source of Unit Trust information as lack of reliable vendor feeds causes us to be unaware of when income events take place. The system will also perform a reconciliation function of UT holdings held within State Street against that of the Unit Trust Managers.

Trust this would suffice your purpose understanding of financial consolidation process, development of application for financial package, functional understanding of consolidation to develop logics, designing of financial reports like BS,PL, Cash flow etc.It creates Chart of Account (CoA) master as per country. (In India financial report format is SCHEDULE VI), Ledgers, Groups, Currency,Exchange rate,Company master. It takes the balance sheet data from excel and dump into SQL. Then mapping ledgers with groups. And then generate report in static.
Database creation, creation of Triggers and Stored procedures.

1KEY product contains one module 1KEYHPC View. 1KEY product basically is BI tool. It creates reports on the basis of query. There are different types of report View, Cube, Chart, KPI, Dashboard, etc.
In 1KEY View module can create GridView, BandedGridView and CardView types of report. Created report can be export and email in PDF, TXT, XLS, XLSX, CSV, HTML format.

1KEY product maintains its ULS (User Logged System) database. Means which user, what activity and when, this all information maintain in ULS database. 1KEY Trigger Management application creates triggers for INSERT, UPDATE and DELETE commands dynamically for selected tables.

Internal web application developed to download trial full version of VIEW CUBE modules from the BI 1KEY application using the AVANGATE payment gateway for payment services. Responsible for development, support, and unit testing.

Developed GridView, BandedGridView, and CardView types of reports in 1KEY View module of the 1KEY product. Created reports exportable and email-able in various formats. Responsible for development, support, and unit testing.

Developed triggers for INSERT, UPDATE, and DELETE commands dynamically for selected tables in the ULS database of 1KEY product. Responsible for development, support, and unit testing.