Data Analyst/ Lending Analyst Resume
Charlotte, NC
PROFILE:
Recent graduate with a degree in Business Mathematics and several years of work experience. A motivated young professional seeking an analyst opportunity. Communicative and personable, will learn and adapt quickly, follow direction, and serve customers with poise and professionalism. Eligible for 2020 SOA Exam - Financial Mathematics. Multi-lingual in French, Lingala, and English.
AREAS OF EXPERTISE:
Analytics/Mathematics/Statistics
AWS, DevOps, GitHub, Jenkins
Data mining & cleaning
Project Management
Intermediate R, SAS, BI
SQL Database & Querying
MS - Excel, Word, Suite, Access
Support, Troubleshoot, Investigate
Documentation & Reporting
Concept Implementation
Financial Accounting
Macros, Pivot table, VLOOKUP
EXPERIENCE HIGHLIGHTS:
Data Analyst/ Lending Analyst
Confidential, Charlotte, NC
Responsibilities:
- Collect and prepare all necessary documentation for the loan package
- Compiled regular dashboard with help Excel macros
- Complete loan contracts and ensure clients are kept informed of the rules and requirements
- Submit files to the designated Underwriter through Salesforce
- Work with clients to establish their needs and recommend suitable types of loans
- Develop new and modify existing SAS/SQL code the Data Warehouse to meet the department objectives
- Analyze and interpret data to identify trends, patterns and opportunities for program and clients
- Wrote Cron Jobs and SQL procedures to integrate data from cross-functional APIs
- Performed analysis of archived data including data cleanup and data validation with SQL/SAS
- Created and maintained complex financial models for each company division
- Reviewed Customer Relationship Management database system with the aim of improving efficiency and introducing new algorithms focused on developing customers from generated leads
Account Receivable analyst
Confidential, Charlotte, NC
Responsibilities:
- Processed client invoices, applying price reductions and rebates
- Maintain records of company promotions, sales, price changes, and other factors affecting customer billing
- Identify and resolve errors with customer accounts
- Monitor customer payments received and current account status
- Provided income and expenditure forecasts as well as market growth and capitalization data for management
- Assisted HR in creating and conducting staff performance statistical tests
- Did the quarterly reconciliation of data from the organization’s divisions for input into the organization’s enterprise system software
Independent Tutor
Confidential, Charlotte, NC
Responsibilities:
- Assisted students with tutoring including homework and test preparation.
- Provided support for 50-member Actuarial Club
- Shared expertise in French, SQL, SAS, Mathematics, Economics, Finance, Statistics, and Calculus
- Tutored 12 freshman students resulting in improved grades
Supervisor
Confidential, Charlotte, NC
Responsibilities:
- Liaise with the Manager on a daily basis regarding current tasks, and assist in the planning of future tasks
- Ensure all assigned duties are carried out, and that resources are efficiently utilized
- Act as a communication conduit between Clients and staff
- Maintain and control use of stock, equipment & consumables
- Timeously request purchase of consumables, equipment and materials
- Assist the Manager to maintain the asset register
- Monitor and report absenteeism to the Manager
IT Data Analyst
Confidential, Charlotte, NC
Responsibilities:
- Extracting structured and unstructured data and create dashboards
- Manage and merge large amounts of data sources together
- Computer programming with SQL
- Automate different reports using SQL, VBA, SAS and Access
- Continuously exhibit core values of integrity, communication and teamwork.
- Present and communicate the data insights/findings to team to solve complex data problem
