John Zambo Email & Phone Number

Tampa, Fl, Us

Tampa, Fl, Us

Jacksonville, Florida, United States

Increase revenue by performing regular and ad hoc data analysis, forecasting, strategizing, communicating results, and implementing strategy changes using Excel, Microsoft SQL server, and PowerPoint.

Sun Prairie, Wisconsin, United States

While searching for a mutually beneficial opportunity for me and an employer, I have been improving my data analysis, financial analysis, risk management, and technical skills by taking courses in Microsoft Excel, Financial Mathematics, Probability, and Programming, passing a professional Financial Mathematics examination with a pass rate of less than 50% along the way.

Sun Prairie, Wi Usa

Increased productivity, efficiency, and revenue: o Conducted companywide forecasting and projections in Excel, delivering to executives and marketing o Designed, managed, and trained staff on Project Management systems and processes o Assigned and ensured on time completion of all tasks, maximizing billable capacity

Sun Prairie, Wisconsin

o Wrote code using Javascript, CSS, HTML, SQL, SuiteScript 1.0, and SuiteScript 2.0o Made Custom Lists, Records, Fields, Centers, and Dashboards, Saved Searches, Workflows, and Advanced PDFso Wrote User Event, Client, Scheduled, Map/Reduce, and RESTlet scriptso Performed NetSuite customization, solution design, and implementation

Fort Myers, Florida, United States

Cut costs and improved systems:o Saved $5000 per year by researching and finding a simpler Excel alternative to eMoney Financial Planning Softwareo Increased effectiveness of Excel cash flow management template by updating data and layoutConducted market and investment research and analysis and strategic portfolio management: o Analyzed investment options on performance, volatility, asset class, Morningstar rating, and expense ratio o Identified strategic markets to… Show more Cut costs and improved systems:o Saved $5000 per year by researching and finding a simpler Excel alternative to eMoney Financial Planning Softwareo Increased effectiveness of Excel cash flow management template by updating data and layoutConducted market and investment research and analysis and strategic portfolio management: o Analyzed investment options on performance, volatility, asset class, Morningstar rating, and expense ratio o Identified strategic markets to target for entryo Disseminated findings to controlling parties Show less

Fort Myers, Florida Area

Improved systems and processes and increased revenue:o Analyzed billing data, found, and corrected errors in AP and AR, increasing company revenue by 14% annuallyo Delivered reports in Excel to verify conclusions to both owner and clientso Built out, found and corrected flaws, implemented, and maintained Junxure Cloud CRM softwareo Presented and trained the owner and staff on newly designed business workflows and processes Managed all office operations:o Managed… Show more Improved systems and processes and increased revenue:o Analyzed billing data, found, and corrected errors in AP and AR, increasing company revenue by 14% annuallyo Delivered reports in Excel to verify conclusions to both owner and clientso Built out, found and corrected flaws, implemented, and maintained Junxure Cloud CRM softwareo Presented and trained the owner and staff on newly designed business workflows and processes Managed all office operations:o Managed financial operations, including Automated Clearing Houses (ACHs), AP and AR, billing, and depositso Handling all paperwork and incoming and outgoing office communicationso Monitoring status and completion of employee deliverables and informing owner of statuso Updating and tracking client and operational information and systems to maintain accuracy and effectiveness Show less

Ave Maria, Fl

Trained on, learned, and evaluated company operational processes and software using Junxure Cloud CRM, gaining a functional knowledge and finding ways for improvement.

Ave Maria, Fl

Taught students how to perform the different forecasting methods using STATA statistical software, including regression analysis, moving average, time series decomposition, and ARIMA.

Ave Maria Florida

Assisted visitors by telling them about the museum and giving personal tours for up to 80 visitors per 2-hour shift. Kept tally of number of visitors