Mortgage

Mortgage

Our consultants worked on a client’s project which helped the client to design process/application to provide a single source of trusted loss sharing data by building loss sharing database/process and manage the loss sharing data as ongoing operations.

Our Exerience: Consolidated various work stream to handlecalculation; Accrued Interest calculation; Trouble Debt Restructuring (TDR) Process; Stopped Interest Report; MF Credit Accounting data upload; Consolidation of inputs to Loss Allowance Model; MBS Disclosure Process ; Disclosures for Impaired loans etc. MF REO-Loss Allowance work stream was responsible for deriving multifamily allowance estimate, restatement for charge off accounts, and providing accounting standards for impairments for all trouble debt restructured loans.

Identifying the most homogenous, standardized set of multifamily transactions that are well suited for hedge accounting.Application supported client’s effort for implementing FAS 133 fair value hedge accounting by identifying the multifamily loans eligible for hedge accounting.

Identifying data issues in source systems that could have caused incorrect Fair Value In financial reports Identified data/logic issues in the application that could have resulted in overbooking FAS 114 reserve amount in a given quarter

Designed application may help to trim down the need of manual Ad-hoc analysis being performed by various MF divisions and hence help better utilize time and resources of the company

Streamlining SOX process flows, change management processes and successfully developed applications which can save time during close process for financial reporting

Consultants: .Net Developer, Java Developers, Business Analysts, Project Managers, QA Tester

Technologies: ASP 2.0, VBScript, JavaScript, HTML, VB.NET, Visual Studio.Net 2003, XML Web Service, T-SQL, SQL Server 2000, Visual Interdev 6.0, MS-Office and Windows 2000, Oracle; Sybase, MS Access 98/2000/2003/2007, TOAD for Oracle 9.5, Oracle SQL Developer, Oracle Business Intelligence Suite, Micro Strategy, Enterprise Edition (OBIEE) 10g, Tableau, SAS, Quality Center, Test Director, Rational Clear Quest (2003.06.13.402.000), Bugzilla, MS Project, MS Visio, MS PowerPoint, Rational Req. Pro. (8.23.0072.1), RM Sync 2.6.1, Quick Test Pro (QTP), WinRunner , IBM Maximo, BMC Remedy AR System 7.1, SOX-XL; MS Share point, RUP, Waterfall, Agile, Scrum

Consultants:
.Net Developer, Data Analyst, Business Analyst, QA Tester

Technologies:
ASP 2.0, VBScript, JavaScript, HTML, VB.NET, Visual Studio.Net 2003, XML Web Service, T-SQL, SQL Server 2000, Visual Interdev 6.0, MS-Office and Windows 2000