Emran Hussain

*

Handle Ad-Hoc Requests within the Investor Loan Administration department

*

Understand and interpret mortgage related data in a clear and concise manner

*

Process improvement through automation

*

Leveraging technology like Excel (including VBA), Python, SQL, Tableau, Project, Visio, Xceptor and Alteryx

*

Create clear and eye-catching Data Visualizations

*

Maintain key metrics and analytics

*

Statistical Analysis of Data sets

*

Data Mining and Data modelling

*

ETL activities. Mainly using SSIS, Tableau and Alteryx

*

Assure the integrity of data through automated extraction, manipulation, processing, analysis and reporting

*

Evaluate as-is process, identify gaps and develop solutions for process improvements.

*

Develop, test, implement and maintain reporting (regular and ad-hoc) that enables data driven decisions

*

Create Management Reports and Dashboards for relevant stakeholders and create presentations for all levels of management

*

Refresh daily trial/exception reports and resolve loan-level issues to ensure accurate default reporting. Engage with partners in Default lines of business to resolve process-level impediments to accurate reporting.

*

Review error reports provided after each monthly transmission and correct/resolve errors within prescribed timeframes.

*

Research and respond to investor requests for information or changes to reporting.

*

Research and respond to internal and external audit requests, where required.

*

Monitor key loan modification process milestones and requests for foreclosure holds, ensuring compliance with regulatory requirements (i.e., CFPB, HUD, etc.).

*

Monitor adherence to first legal deadlines on FHA loans, ensuring that manual extension requests are made by the line of business, where applicable.

*

Design and implement for various T-SQL ad-hoc requests and view.

*

Design and maintain various business reports and analyze requirements from analysts.

*

Using other technology like SSIS, SSRS and SSAS to organize, present and migrate data.

*

Using Python and PowerBI to analyze and organize various data sets.

*

In addition to the job duties as an Operations Associate, I have additional duties including mentoring new employees.

*

Using software like ANYDOC, SQL Server and Tableau to query and aggregate these data.

*

Providing documentation to inquiries and requests

*

Ensure compliance with PNC Bank's company procedures.

*

Reviewing claims and route to KFIs (Key from Image) and /or QuickApps

*

Preparing audit reports to thoroughly document audit findings

*

Assisting in finding non-indexed claims in OnBase

*

Assigning the right HIPAA codes to the correct amounts.

*

Consolidating of claims and helping workflow with various other work like reviewing transactions

*

Updating provider files with NPI, TIN and address

*

Keying in EOB and other health claims given to us by our clients, which is usually providers and hospitals. I ensure that I minimize errors and provide quality service by inputting data in accordance to company procedures and SLA.

*

Doing my job in compliance with HIPAA. I have had also to assign ICD Codes, revenue, procedure, and remark codes. This is done with OnBase software.

*

Balancing all the check amounts paid by the insurance companies. I have had to calculate all missing values and discrepancies in deductibles, errors in discounts, incorrect coinsurance, and various other issues.

ANZ Bank is one of the largest banks in Australia. Handling Customers, POS and Cash handling, some supervisory role, opening new accounts and cross selling the bank's products.

*

Collaborated with vendor managers and suppliers

*

Analyze purchase requisitions and reviewing for accuracy

*

Make recommendations regarding suppliers and products

*

Collaborating with engineers and ensuring a keeping a steady supply of optical fibers and other materials using FIFO method.

*

Managing inventory and all account receivables and payables. I had to prepare invoices, budgetary planning.

Worked at various departments, mostly customer service (including opening new accounts) and Credit and Foreign Trade. My internship report was the Analysis of the Credit Department.

2019 - 2021: The University of Texas at Dallas (Master's Degree) - CGPA: 3.33

2006 - 2010: BRAC University (Bachelor's Degree) - CGPA: 3.34

Bachelor's in Business Administration (Finance and Marketing) - Placed in 'Dean's List'.

1993 - 2003: SFX Green Herald International School (High School) - CGPA 3.7

O - Level (7 subjects including Mathematics and English)