Jonathan Martel Email & Phone Number

Providence, Ri, Us

Consultant solving all challenges with data extraction and cleansing, modelling, analysis, macro building, dashboard design and overall issues regarding data and analytics.

Brussels, Brussels, Be

* Owned all of US Reporting for all areas of the business, including ad-hoc and standard reports.* Managed a team of analysts, training them in advanced Excel, company systems and advanced modeling techniques. * Worked with IT to design and build out a centralized data warehouse that utilized SQL queries and Tableau to automatically report to every level of US Operations.* Owner of Budget and Forecast builds – worked with the Executive and Operations teams to build, manage and report on the budget from a top-down and bottom-up perspective.* Built scripts using Python and utilizing APIs to automate and streamline data extraction and cleansing.* Company expert in all reporting systems: NetChef Crunchtime and BizIQ, Great Plains, Adaptive, Toast Analytics, MonkeyMedia, and Tableau.

Elmsford, New York, Us

* Managed a team of four analysts who supported the reporting needs of the Sales, Marketing and R&D departments.* Developed the bottom-up company-wide annual budget process, in addition to regular forecast updates and revisions to plan.* Produced weekly Cash Flow forecasts and Business Line revenue variance reports to the Business Unit Directors, the CFO and the CEO.* Managed the financial relationships and obligations with over 20 external sales representatives and 15 major licensors.* Developed standard and ad-hoc analysis for Business Unit Directors to help them manage costs and improve revenue growth and new opportunities.

Sterling, Va, Us

* Owned all financial analytics for 3 of the top 5 clients in the company, which totaled over $100 million in top-line revenue.* Recouped, through investigative analysis, nearly $1 million in revenue from a top client, and provided follow-up analysis and reporting to assist with collection. * Owned, created and maintained reports that forecast revenues and expenses, set pricing, identified outliers, and ran ad-hoc analysis in support of the client services teams.* Built dynamic custom dashboard-style reports for internal and external clients that helped explain trends and identify existing and future business opportunities.* Used custom software (Toad, SQL Query Analyzer, Cognos TM1, Microstrategy, Avaya CMS, Oracle Discoverer) to generate reports and data sets needed to perform the above functions.

* Owned reporting and analysis for both internal and external sales teams, covering over 25 sales agents; ran regular and ad-hoc reporting for both teams.* Managed the transition of sales data from a manual in-house collection process to a hosted lead management tool, increasing new sales and retention by over 200%.* Produced ad-hoc analysis that resulted in cost reductions and revenue generation totaling over $250,000 for the company.* Stepped up to manage the sales team for three months while the department transitioned to new management.

* Provided strategic analysis to senior management to help meet revenue goals and identify KPIs.* Compiled and analyzed data for 12 major international brands on a weekly, monthly, quarterly and yearly basis.* Utilized Yahoo Overture, Google Analytics and AdWords, Omniture, ClickSquared, and numerous internal proprietary reporting tools to create timely and relevant reports and analysis.

* Compiled data and ran in-depth analysis of email delivery results across 400+ individual mailing brands.* Used pivot tables to analyze delivery performance across eight ISPs to assist in maximizing click-through revenue.* Communicated within the company to resolve any technical issues from sub-standard delivery results.* Worked with the New York office to improve data analysis and helped resolve any communication issues.

New York, Ny, Us

* Executed all email marketing campaigns for the Marketing, Advertising, Sales and Customer Service departments.* Coordinated email testing to maximize response and to help increase retention and acquisition goals.* Owned all aspects of email reporting and data analysis; provided campaign results to all company departments.* Owned ISP relations; responsible for improving delivery rates, CAN-SPAM compliance, and best practices.

* Determined business requirements for projects and managed relationships with internal departments to execute.* Managed client relationships by providing feedback and analysis of program performance.* Analyzed performance results and delivered recommendations to clients.