Joyce L. Email & Phone Number

Los Angeles, California, Us

Perform ETL, Extract-Transform-Load processes, based on the junior data analyst entries from various sourcesResearch data automation tools to perform effective ETL to ensure data integrity in Big DataMaintain and analyze KPIs to assist in providing recommendations to management for continued business operationsBuild data visualizations based on Big Data collected post Data Cleansing and Data MiningCreate data process flows to determine where Big Data sources are and where data is locatedAnalyze property management data sets using Microsoft Excel Data Modeling and Power Query to gain insights that can be used to assist in critical decision makingMaintain up to date business documentation processes for reporting and analysisCapital expenditure budgeting to ensure restaurant is constructed within investment capsMaintain KPIs such as cash flow projections, labor summary reports, occupancy percentages, capitalization rates, expense ratios and loan percentage utilizationsCreate dashboard visualizations based on the KPIs that are being maintainedResearch and integrate property management CRM tools for company usage to analyze company client dataAdvise management on the state of business operations, financial commitments and obligations, and projected cash flow issuesPrepare and present periodic reports such as profit and loss statements and balance sheets to assist management in the decision-making processReview Google Analytics data visualizations to advise on company actionsCreate Google Tags on Google Tag Manager per property and commercial tenant for data integrity

Liaison between residents, managers, and owners on an as needed basis; i.e maintenance, disputes, conflict resolution, and general lease enforcementMaintain contact and coordinate with contractors, vendors, insurance carriers, leasing agencies, law enforcement and various agencies on an as needed basisMeet with prospective tenants to show properties, explain rental terms, provide general information, and review the application processTrack advertising and website traffic using Google Analytics to determine efficiency of advertising campaignsManage and oversee general maintenance and required improvements for commercial and residential properties

Assist in managing the loan amortization scheduling and mortgage financing for over 50 commercial and residential propertiesAdvise management on the state of business operations, financial commitments and obligations, and projected cash flow issuesPrepare and present periodic reports such as profit and loss statements and balance sheets to assist management in the decision-making processAudit financial records to ensure accuracy and provide support for litigation

Collect data using Marketing Research information based on taxes, property values, square footage, and traffic volume to develop dashboard and KPIs on Power BIAttend Power BI and Tableau (Business Intelligence Tools) training for growth in new developing Junior Data Analyst role for companyCreate and present Power BI and Tableau (Business Intelligence Tools) sample data dashboards using current company data to demonstrate the prime differences to upper management to decide which platform to utilizeAnalyze property management Big Data sets using Microsoft Excel Data Modeling and Power Query to gain insights that can be used to assist in critical decision makingCreate dashboard visualizations based on the KPIs that are being maintainedResearch and integrate property management CRM tools for company usage to analyze company client dataAdvise management on the state of business operations, financial commitments and obligations, and projected cash flow issuesPrepare and present periodic reports such as profit and loss statements and balance sheets to assist management in the decision-making processReview Google Analytics data visualizations to advise on company actions

Assist in managing the loan amortization scheduling and mortgage financing for over 20 commercial propertiesClassify and record financial data using PropertyWare, Buildium, Yardi Genesis, and Quickbooks for accounts payable and accounts receivables purposesOversee the financial operations of over 50 commercial residential properties in California and ChicagoMaintain regulatory good standing for business entitiesManage and oversee general maintenance and required improvements

Prepare, analyze, and maintain financial data for 100+ businesses to generate monthly, quarterly, and annual reports for account analysis and reporting purposesReporting Sales Taxes for 50+ companies in California, Nevada, Washington, Texas, and IllinoisOversee the startup and maintenance of good standing for corporations and limited liability companiesCompute taxes owed and prepared tax returns for individuals and businesses, ensuring compliance with tax requirements and paymentsUtilize advanced Microsoft Excel tools such as Pivot tables, macros, Power Pivot, and Power Queries, to create reports to ensure data accuracy and data relational databases

Manage the report and filing of payroll records for 100+ companies in California, New York, Texas, and ChicagoReconcile and processed payroll records for Quarterly and Annual tax filings in a timely mannerCorrespond with Federal and State agencies as needed to ensure smooth business operations and provide support with regards to reporting issuesCalculate payroll wages, tax deductions, benefits and commissions based on company payroll schedulesUtilize advanced Microsoft Excel and DAX formulas to calculate payroll

Perform preliminary analytical review and substantive analytical procedures to find any irregularities in financial dataReconcile financial transactions by verifying invoices from vendors and completing the posting processProcess invoices and billings to schedule timely payments in QuickBooksCreate table of accounts and assign transactions to proper accounts for documentation and record keeping

Bachelor Of Business Administration (Bba), Finance & Minor In Real Estate

Education record