Post Job Free

Resume

Sign in

Management Data Analyst

Location:
Secunderabad, Telangana, India
Posted:
January 17, 2016

Contact this candidate

Resume:

Shailender Singh

B COM, M.COM

Email : acs48g@r.postjobfree.com Contact No: +91-784*******

To succeed in an environment of growth and excellence with having job satisfaction and self development that helps me to achieve personal as well as organizational goals.

Profile Summary

A self-motivated business management professional and M.COM by qualification with 3+ years of work experience in financial firm, Mortgage & service sector. Working at Managerial level as Senior Servicing Data Analyst with Berkadia Commercial Mortgage and expertise in Accounting, Data Analysis, Research, MIS Reporting, Quality check, Receivable, Investors relationship, Bank Accounts, Account Payable, Business Process improvement.

NOTABLE ACHIEVEMENT:

1) Got “Platinum Award for STAR PERORMER“at Berkadia Commercial Mortgage for 3rd Quarter, 2014.

2) Promoted as Servicing Data Analyst from Associate Analyst in 7 months after joining at Berkadia Commercial Mortgage based on my performance.

CORE COMPETENCIES:

Data Analysis

Accounting

Account Payable Vendors

Bank Account

MIS Reporting

Professional & Academic Qualification

Master degree in commerce(M.COM), 2015

Bhavans Degree (Osmania University), Andhra Pradesh, India. College

Bachelor degree in commerce(B.COM), 2012

Bhavans Degree (Osmania University), Andhra Pradesh, India. College

Intermediate (10+2), 2009

Loyola Academy, State Board of Hyderabad., India.

Professional Experience

Currently:

Organisation: Berkadia Commercial Mortgage, INDIA since 10th July, 2012 till now.

(Holding Company of Berkshire Hathaway, Inc.)

Designation: Senior Servicing Data Analyst

Key Responsibility Areas

To validate various kinds of data which are sent as an upload by various departments like Taxes, Loan Admin, Reserve, CMBS, Loan Boarding, Finance dept...etc.

Adjust account receivable every months and submit E-form and advise CRM Department.

Act as the primary contact for high risk changes to the system, reducing Company exposure to internal fraud.

To review and research the various loan agreements document for various loans like CMBS loans, Freddie Mac loans, Dealer loans, Agency loans and do internal audit for quality check and provide information like Index rate, debt ratio, and Late Charge amount...etc. and provide information to CRM and Investor reporting.

Research and Analysis on financial statements, Balance sheet, and provide the quality check report output to the respective US counterparts.

Preparing the business query reports by using report studio.

Prepare monthly loan list, Dash Board, audit sheet monthly and quarterly for A60 VS B66 loans.

To adjusted receivable for various loan type i.e. Interest, P&I, Arm loan and audit sheet.

Handle Suspense Research process which involves extraction of Report and research, consolidation of the report with the findings and mailing it to the respective US counterparts.

Project Risk Management: Analyze Risk related to the project & taking appropriate Risk mitigation measures.

Accounts Receivable Management: Ensuring timely receipts of receivables.

Work on LoanView account and InvestorView account which includes providing access to external party to loan information and query related to portfolio.

Work on Delinquency Report, DVR Report. To identify and modify components of Loan based on different circumstances.

To resolve the queries of Borrower for the Loans borrowed and also resolve the queries of Investors portfolio.

Assist CRM (Client Relation Manager) in resolving accrual issues resulting from unscheduled changes to loans such as modifications, curtailments, or advances.

Review loans for accuracy, backup, and applicable approvals. Process miscellaneous requests received by the department mailbox. This includes the setup of Investors, Bank Accounts, and Payable.

SDC Validations: The purpose of this process is to ensure all bulk data changes Processed via upload with the application IBM (Mapping tools) are successfully fed into System. It is final quality check through the Cognos and creates a final reports and data sent by various departments.

E-form/Invoice Processing (Accounts payable Management): Managing the receipts and voucher of both Internal and external parties and vendors.

Follow up a process of invoice both Internal and external

Archiving of Invoice data according to its categories.

Able to work with different environments handling multiple clients and contacts for each invoice.

Able to find and spot the invoices which don’t have PO or the documents which doesn’t contain PO.

Processing e-form and Invoice for Corporate management.

Keep track on slow approvals.

Approval / Research and Rectify errors on Charge Code and other type GL Code errors.

Additional responsibilities such as filing contracts, handling client requests, able to handle databases related to vendors of the company.

Working on various ADM cost centre and advice to various corporate VP and CRM disburse the funds.

Accounting and MIS Reporting: Handle & supervise whole accounting system.

Provide daily, monthly and annual MIS reports to the management i.e. Payable and receivable ageing analysis, Project wise profitability report, Profit and loss account and customised reports as required by management through Cognos reports.

Industry Visit Details:

Project Title: Cost Control & Quality check Management

Company: Bambino agro industries Ltd

Project Duration: October 1st 2011 to October 31st 2011(1 Month)

Location: Bibinagar, Andhra Pradesh, India

Project Brief: During my Visit at Bambino agro industries Ltd a unit of idea, I have learnt a lot on various facets of Financial Management and Accounting processes including Cost Control & Quality Check measures.

Exposure in Technical Skills & Analytics:

Tested 270 test scripts of new IBM Mapping tools application supports and provided output to make it functionally in the process.

Conversant with MS-Word, Power point, MS-Excel, and Windows operating system.

Well conversed with MS Windows 98, 2000, XP and Internet Applications.

McCracken IBM

Cognos IBM

QUERY Studio

Management and Planning exposure:

Attended Seminar on Commercial Real Estate SYMPOSIUM on 4th & 5th at Trident Hyderabad. (A.P)

Attended Seminar organised by Andhra Pradesh Economic Association on Economic Growth and Inclusiveness.

Attended Seminar on Globalization & its effects of as a part of career.

Accomplishments/ Achievements:

Participated in Debate competition, science fair/exhibition, school drama.

Received Best Cricket Player Award in Inter School Competition for the year 2007.

Team Member of the College Football Team.

Leadership and Extracurricular Activities/Hobbies:

Member for NSS camp during my graduations.

Organized festival events in the year 2012 in my college.

Pupil Leader in Intermediate Loyola Junior College Alwal.

Cooking Watching T.V. photography and Travelling.

NCC/Physical Training undergone:

Undergone NCC training and passed ‘A, B, C’ certificate examination held under the authority of Min. of Defence, Govt. of India.

Attended Mini Training Camp (Arms) from 06-07-2012 to 18-07-2012 and also Annual Camps organized by 3 Andhra Battalion, NCC Hyderabad.

Was part of a NGO named Divya Disha – Safe Childhood Campaign for 3 month.

Attended ARMY attachment Camp with 6th Bihar army camp at Hyderabad.

Personal Profile

Address : Room No – 306 B-Block, Phase III, Janapriya Arcadia, Mahadevpur, Kowkoor, Post Bollarum Secunderabad, Andhra Pradesh ZIP code - 500010, INDIA.

Languages Known : English

Marital Status : Single

Passport : L2777875

Notice Period : 2 Months



Contact this candidate