Business Analyst Resume Plano, Texas - Hire IT People

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

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

Confidential, Plano, Texas

Default Reporting Analyst

Responsibilities:

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.

Confidential, Richardson, Texas

Operations Analyst

Responsibilities:

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 Confidential 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

Confidential, Richardson, Texas

Operations Associate

Responsibilities:

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.

Confidential

Personal Banker

Responsibilities:

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.

Confidential

Intern

Responsibilities:

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.