Clara Serna
Ashville,NC
Summary
Dependable and detail oriented. Proficiency in various PC applications including Word, Excel, PowerPoint. Working knowledge in software applications/platforms such as SalesForce, Oracle - JD Edwards E1 and SAP Concur.
Overview
15
15
years of professional experience
Work History
Financial Analyst-GL/Accounting Department
PC CONNECTION
06.2017 - 11.2024
- Exported information from Oracle-JD Edwards software to prepare and design daily, monthly and quarterly key financial reports, validating report output for distribution to various user groups in the organization including senior management, sales teams, and other departments
- Performed ad hoc reporting and assisted with research and special projects for different groups
- (i.e., Invoiced sales by service type, cost of goods sold, gross profit and revenue by product and by region)
- Collaborated with month end close preparing and posting some journal entries and adjusting journal entries such as corporate prepaid expenses, accrued expenses and accrued revenues
- I also worked on account reconciliations, all, in an accurate and timely manner
- Collected sales and gross profit numbers from sales directors to prepare weekly Executive Dashboard presenting the sales budget numbers vs forecast vs actuals by month, quarter, and year divided in sales region and sales directors’ sections
- Also, showing outliners highlighting them using conditional formatting
- Posted in Salesforce and distributed by email the weekly Executive Dashboard to corporate management and sales team leadership for weekly meetings
- Prepared and distributed to the sales team and corporate executives a daily report showing the sales reps’ top performers by region and by directors
- Created spreadsheets using formulas and excel functions including x-lookup, pivot tables, slicers, sum-ifs, averageifs, conditional formatting, concat, dsums, power query, Macros, etc
- Performed SG&A month to month - horizontal variance analysis to identify accounting errors and jump increases above specific threshold for general ledger account’s total balances
- Also, re-classified journal entries to the correct cost center, general ledger account or with the correct subledger code or amount
- Worked closely with accounting to identify errors by running separate reports for several cost centers (i.e, marketing, IT report, sales) and verified with proper documentation that journal entries have been posted to the correct general ledger accounts
- Ran report to correct or update product categories on our product items list complying with auditors’ request regarding tax rules accuracy
Senior Credit Analyst-Credit Department
PC CONNECTION
10.2015 - 06.2017
- Prepared account reviews to be submitted for credit line adjustment
- Analyzed credit data and financial information of customers to determine credit lines up to $100K
- Prepared spread sheet to review credit worthiness of new and existing customers utilizing credit reports (i.e., Dun & Bradstreet, Credit Risk Monitor and Hoovers)
- Updated accounts on net terms, parent company information, review dates, fraud flags, payment type, AR representatives, and freight levels
- Prepared fraud report for the executive and sales team
- Updated spread sheet for credit reviews
Credit Analyst-Credit and Risk Department
WORLD FUEL SERVICES
09.2013 - 10.2015
- Contacted banks, trade and credit associations, salespeople, and others to obtain credit information
- Followed economic trends in firm's industry or branch of industry to predict probable success of new customer
- Evaluated results of investigations, prepared reports of findings suggesting credit limitations to management
- Maintained database of customer’s credit histories
- Prepared written analysis on current customers and prospective borrowers to measure financial strengths and weaknesses of borrowers and guarantors, collateral adequacy and general credit worthiness
- Reviewed credit worthiness of new and existing customers utilizing credit reports (i.e., Dun & Bradstreet, Credit Risk Monitor, Credit Safe, Experian, etc.), Reuters, corporate and individual tax return, and customer’s payment history to determine credit risk and to set the appropriate credit limit
- Used ratio analysis to help making a decision on credit lines of customers that provided financial statements
- Compared liquidity, profitability, and credit histories of establishments being evaluated with those of similar establishments in the same industries and geographic locations
Accounting Clerk – Accounting Department
CARICO INTERNATIONAL INC
08.2009 - 09.2013
- Assisting in preparing financial statements’ annual updates (Balance Sheet and Income Statement)
- Prepared and posted several journal entries assigned to the general ledger in Oracle
- Gathered and organized information in excel to prepare the annual U.S Income Tax Return for an S corporation
- Updated company’s annual depreciation schedule for fixed assets
- Used Oracle system to post money received from CODs, sales orders, receivable payments, wholesale payments and other type of income
- Collaborated with the SG&A schedule and revision
Education
Bachelor’s degree - finance
Florida Atlantic University
ABA Certificate - Commercial Lending
American Bankers Association
Skills
- Microsoft Excel
- Financial and operational reporting
- Financial management
- Financial statement analysis
Timeline
Financial Analyst-GL/Accounting Department
PC CONNECTION
06.2017 - 11.2024
Senior Credit Analyst-Credit Department
PC CONNECTION
10.2015 - 06.2017
Credit Analyst-Credit and Risk Department
WORLD FUEL SERVICES
09.2013 - 10.2015
Accounting Clerk – Accounting Department
CARICO INTERNATIONAL INC
08.2009 - 09.2013
Bachelor’s degree - finance
Florida Atlantic University
ABA Certificate - Commercial Lending
American Bankers Association
Similar Profiles
James LacailladeJames Lacaillade
Sr. Executive Account Manager at PC ConnectionSr. Executive Account Manager at PC Connection
Renee WagnerRenee Wagner
Marketing Project Manager at PC ConnectionMarketing Project Manager at PC Connection
Jarrod LemonJarrod Lemon
NOC Engineer at PC ConnectionNOC Engineer at PC Connection