Native Floral Group is a national cut flower bouquet company, with five production facilities strategically located throughout the United States, and was the first to develop today's regional bouquet model. As a revenue analyst, I create company daily sales and inventory tracking reports with a simple dashboard to show sales by item UPC among other measures, improving projections on different item variations across several markets. As a fast growing company gaining increasing amounts of data at hand, I created a data warehouse in SSMS to store the information more securely and efficiently, then went on to develop an ETL package to automate data integration. In addition, I created a report to monitor and analyze the use of temp-labor at our manufacturing sites.

Analyzed investment returns running weekly and monthly performance reports in Excel. Reported cash values of client accounts, compiled presentations for managing directors.- Assisted with accepting and rejecting investment proposals summarizing content for managing directors.- Analyze and compare different asset allocations for various client portfolios and present results to managing directors.- Reduced daily cash and position reconciliation time by introducing VLOOKUP and Pivot Tables.- Analyzed fees billed by third party investment advisors to ensure proper billing and payment.

Monitored risk in cash and futures markets providing clients with strategies and input on how to hedge their production.- Improved the efficiency of management and traders by researching basis bids and international markets while communicating supply and demand analysis.- Upgraded customers to higher levels of service by conducting surveys regarding crop conditions and satisfaction with the company’s daily newsletter on futures pricing and expectations.- Improved information turnaround time for management and traders by analyzing and summarizing CFTC ‘Commitment of Traders’ reports.

Research and evaluate statistics and economics of real estate assets.- Brought about a new real estate acquisition by performing feasibility studies of property values according to neighborhood.- Unfurled new funding source after investigating methods of capitalization for new projects.- Increased on-line inquiries 50% by creating interactive website for company .

Shadowed management, marketing and production teams and presented changes in yields at weekly management meetings.- Introduced new tax deductions to the company by pioneering in-house program for provincial and national research .- Investigated and documented displays and treatment of inventory in thirty grocery stores creating a PowerPoint presentation which resulted in changes in delivery schedule.- Implemented internal audit of food safety requirements and corrected issues before distributor audit.

Managed company accounts and inventory- Keep track of current inventory and communicated with manufacturers regarding purchase orders and drop shippments.- Managed company retail websites and opened an Ebay store increasing sales and inventory turnover.- Scheduled appointments and helped open purchasing accounts with new companies as the business grew.