Anran Cui

Sr. Data Analyst

US Bank

Aug 2023 - Current (1 year 10 months)

● Power BI Reporting: Created Power BI reports for US Bank's Dealer Services business, supporting risk control, audit, and operational teams. ● MS SQL Studio Expertise: Developed efficient stored procedures in MS SQL Studio for data extraction and transformation to enhance data retrieval for Power BI reporting. ● Automation with VBA and Excel: Automated report generation processes using VBA and Excel, improving workflow efficiency for responding to requests from risk control, audit, and operation teams. ● Collaborative Cross-Functional Support: Collaborated with cross-functional teams to understand and address reporting requirements, ensuring Power BI reports met the dynamic needs of the Dealer Services business.

7

Data Analyst, Wholesale Fuels

7Eleven

Apr 2022 - Aug 2023 (1 year 5 months)

● Database Development: Transitioned 5 years’ financial and operational reports from Access/Excel to Power BI, optimizing a cloud-based dashboard with a live connection to SQL Server, customizing features/filters, and enhancing the user experience for 100+ end-users. ● RPA: Utilized Power Automation to automate data collection and updates, streamlining workflows and enhancing data-sharing capabilities while reducing manual efforts. ● Data Visualization: Visualized gross profit, volume, EBITDA, R&M, inventory adjustment in a sales manager, States, Acquisition Segment, Brand dimensions by bar charts, waterfall, map to create a dashboard in Power BI ● Financial Analysis: Leveraged Excel, SQL, and Power BI to conduct detailed income statemen

Data Analyst, logistics

Pilot Company

Jul 2021 - Apr 2022 (10 months)

•Maintained Tableau and Excel pivot report on a daily base, performed updated as necessary to ensure accuracy. •Examined reports and database on a regular base to location and date and reported errors to superiors and proposed solutions. •Collaborated with the business intelligence team and business development team weekly to improve the logistic procedure. •Supported various finance departments in reaching their goals through analysis, such as creating urgent report as needs. •Prepare and design reports to senior management, as well as any regulatory reporting requirements related to transportation and logistics activities about crude and water.

R

Property Accountant

Rise Residential

Aug 2020 - Jul 2021 (1 year)

•Prepared monthly bank reconciliations for more than 20 bank accounts for 10 properties. •Recorded weekly/monthly adjustment and hard/soft cost accrual entries by using a self-built excel spreadsheet. •Reviewed monthly financial statement analysis according to GAAP and fixed errors before closing. Assisted in the annual audit and assisted tax return preparation. •Assisted the controller in large data processing, such as liability, budgeting, insurance information, etc. •Coded invoices, expense reports, check requests, etc., with correct codes conforming to standard procedures, ensuring proper entry into the financial ERP system: Sage, ResMan, Acumatica, ComputerEase.

T

Sales Data Analyst Intern

Tao Motor

May 2020 - Aug 2020 (4 months)

• Using and adjusted self-designed Excel SQL query application to manage monthly base sales, inventory and financial dataset, up to 20,000 queues. • Assisted controller in internal control to supervise sales associates, and processed online orders for major dealers and submitted invoices by using Fishbowl daily. • Updated and maintained the CRM system to prove accurate inventory quality for vendors, dealers and subsidiaries. • Used Excel's VLOOKUP and Pivot table to organize quarterly transportation expenses and reported for controller. • Coordinated and communicated with dealers and various internal departments via email, telephone and live chat, and reported issues to the controller for decision making daily.

Data Analyst Intern-IT/Internal Audit

University of North Texas

Mar 2020 - Apr 2020 (2 months)

• Perform risk assessments, including operational, financial, compliance, and IT, etc. • Assist in developing audit objectives • Develop audit programs • Perform detailed transactional testing of accounts, records and controls. • Assist in gathering, summarizing and analyzing data and other information • Assist in the preparation of working papers which record and summarize data on the assigned audit project in accordance with professional standards • Assist in the development of appropriate findings and recommendations to strengthen internal controls, correct deficiencies, improve activity performance as needed to most effectively and efficiently achieve the stated objectives • As necessary, assist audit staff execute audit work • Communic

Graduate Assistant

University of North Texas

Jan 2020 - Mar 2020 (3 months)

• Provided front line virtual and in-person advising for special programs with UNT partner organizations. • Advised prospective students about UNT and application and admissions process. • Provided program support for short-term programs and other international initiatives. • Entered information into databases. Compiled data and/or calculate simple statistics to prepare special or recurring reports for supervisor.

Accounts Payable Analyst

Walmart

Jan 2019 - Dec 2019 (1 year)

• Effectively reconciled vendor statements matching line items, researching and correcting discrepancies for warehouse, Sam’s club and Amigo Supermarkets with a SQL based system. • Investigated and reviewed all invoice for appropriate documentation prior to authorization payment • Ensured files and documentation are thoroughly and accurately in accordance with company policy.

I

Income Tax Assistance

IRS Volunteer Income Tax Assistant VITA Program

Dec 2018 - Apr 2019 (5 months)

• Completed two-day training on tax law and preparation guidelines • Met with individuals to analyze tax documents • Utilized Link and Learn software to perform file taxes for low-income, local, individuals and families

N

Accounting Intern

NEW ASIA MARKET

Aug 2018 - Dec 2018 (5 months)

• Use QuickBooks to record cash and account payable invoices and maintain accurate accounting records. • Assist with accounts payable and receivable, and perform daily bank reconciliation. • Answer phone calls from vendors and customer daily. • Receive payment by cash, check, credit cards, vouchers. Issue receipts, refunds, credits to customers.

Cashier Clerk

Compass Group

Feb 2018 - May 2018 (4 months)

• Receive payment by cash, check, credit cards, vouchers, or automatic debits. Issue receipts, refunds, credits to customers. • Assist supervisors and auditors daily to minimize revenue and expenditure errors. • Count money in cash drawers at the beginning and the end of shifts to ensure that amounts are correct. • Count and maintain inventory daily for specific area and report inventory information to supervisor.

I

Treasurer

International ClubUNCC

May 2016 - May 2017 (1 year 1 month)

• Prepare financial statements used to forecast the budget and financially plan for annual event by using Microsoft Excel. • Collect expenditures and generate income statements. • Creating attractive PowerPoint slides and present it in front of more than 500 people. • Provide direction and information for future events and membership during weekly management meetings. • Manage a budget of approximately $3,000 and advised organization on how to spend responsibly. • Maintain and update information on our Facebook page and 1600 people's public group

About

Detail

Contact Anran regarding:

Timeline

Résumé

Languages:

Anran's behavioral traits
Anran's likely patterns of behavior, thought, values, and emotion. Based on the HEXACO model, OCP instrument, and Torre’s own research.