Brad Hofman (Mba Finance) Email & Phone Number

Tel Aviv-Yafo, Il

Johannesburg Area, South Africa

Tech: Excel, VBA, Word, Power BI, Power PivotsOther: Salesforce CRM, Business Process optimization, ARISProject 1: Pricing ModelProblem:The sales cycle was excessively long, taking over 12 months due to the time needed to gather, clean, and model client data.Action:Developed a pricing model that allowed sales representatives to capture essential business data from clients in just 2 minutes. Initially built in Excel, the model was later integrated into Salesforce CRM.Result:- Reduced the sales cycle by 90%, from 12 months to under 3 weeks.- Enabled real-time demonstration of the fund's value and pricing.- Saved significant time and resources, increasing sales and generating more revenue.Project 2: Automated Client ReportsProblem:Monthly client reports took over 3 hours to create manually.Action:Developed an automated reporting system using Excel and VBA, generating comprehensive Word reports and interactive dashboards in just 3 minutes.Result:- Decreased report generation time by 98%.- Provided actionable insights to help clients reduce costs and address issues.- Saved time and money, contributing to increased revenue.Project 3: Interactive DashboardsProblem:Internal and external reporting required comprehensive data visualization.Action:Built interactive dashboards using Excel and Power BI for both internal and external reporting.Result:- Reduced time spent on data analysis and report generation.- Provided actionable insights for better decision-making.- Enhanced data transparency and accessibility, improving business strategies and client satisfaction.Salesforce AdministrationActed as the Salesforce CRM administratorSignificantly saved time and money for the company, while the actionable insights generated led to increased revenue. The interactive dashboards streamlined reporting processes and enabled data-driven decision-making across the organization.

Tel Aviv-Yafo, Tel Aviv, Israel

Tech : Excel, VBA, SQL, Tableau, Tableau Prep, Snowflake, MixPanel Other: Zendesk, Confluence, Business Process OptimizationData Pipeline: Unstructured DataProblem:The organization faced challenges in analyzing specific business requirements due to disparate data sources, including MixPanel, Zoom API, and MongoDB. The data was often unclean and fragmented, hindering detailed analysis and decision-making.Action:- Cleaned and created various data pipelines to integrate data from MixPanel, Zoom API, and MongoDB.- Developed complex SQL queries to unify and streamline the data, ensuring consistency and accuracy.- Leveraged Excel, Snowflake, and SQL to create and cleanse data sources within Tableau, facilitating a cohesive data environment.Result:- Improved data quality by 90%, leading to more reliable and accurate data analysis.- Enabled a unified view of the data, allowing for detailed and comprehensive analysis.- Enhanced the organization's ability to uncover actionable insights and make informed decisions.Data Management and Analysis Problem:The business lacked efficient tools for operational insights and faced time-consuming billing processes, hindering productivity and decision-making.Action:- Designed comprehensive dashboards and data sources to provide deep insights into business operations.- Developed billing automations using Excel and VBA to streamline the billing process.- Leveraged Tableau for creating visually appealing and informative dashboards.Result:- Reduced billing time from 2 weeks to just one hour, significantly improving efficiency.- Improved quality of data, leading to more accurate and reliable insights.- Enhanced operational insights resulted in tangible improvements across the business.- Achieved substantial time and cost reductions through operational enhancements.Transformed organizational data management, providing operational insights, while improving billing efficiency and data quality.

Tel Aviv Area, Israel

Developed the detailed business and financial plans for the company. The business plan was used to develop the funding and marketing strategies. the financial plans were used to raise funding for the company. The company undertook two rounds of funding and successfully raise using the business plan and financials plans

Israel

Business Plans:Provided valuable assistance to start-ups in creating, writing, and presenting comprehensive business and financial plans. These start-ups sought to secure funding and required detailed business plans, financial forecasts, and a clear understanding of their funding requirements. Ability to develop high-level business plans in under 2 hours. With a deep understanding of the business, conducted thorough market and competitor research, leading to the development of detailed go-to-market strategies. These well-crafted business plans were then effectively presented to potential funders, maximizing the chances of securing investment.Financial Modelling and Analysis:Created financial models encompassing income statements, cash flow statements, balance sheets, loan amortization, asset schedules, and valuations. These comprehensive models provide a clear and accurate representation of the financial requirements. Designed and created financial dashboards that highlight the critical points for decision-makers, allowing effective communication of key insights.Assisted clients in conveying their business value propositions through the creation of compelling pitch decks.Experienced within a diverse range of industries, including Internet of Things (IoT), cybersecurity, construction technology, fast-moving consumer goods, surfing products, wine, cannabis, financial services, cryptocurrency, and blockchain. This breadth of experience has equipped me with a deep understanding of industry-specific dynamics and challenges, enabling tailor business plans and financial models to the unique needs of each sector.

Tel Aviv, Israel

As a freelance consultant for a company specializing in intellectual property services, I played a crucial role in automating various departments' official forms. This involved utilizing Word VBA programming, seamlessly linked to the information systems database. The objective was to automate the creation of official forms required for filing patents and trademarks.Through my efforts, the company achieved significant improvements in both quality and efficiency. Specifically, the automation process led to a remarkable 90% enhancement in the generation of forms, reducing time-consuming manual tasks and ensuring accuracy. This transformative initiative streamlined operations and allowed the company to focus more effectively on its core intellectual property services.

Israel

Validation and Qualification Analyst:In my role as a Validation and Qualification Analyst, I conducted a thorough analysis of standard operating procedures required for the successful implementation of SAP Enterprise Software. This involved reviewing, communicating, and documenting ITIL processes to ensure the effective support of the IT infrastructure and mitigate business risks. By employing the GAMP 5 methodology, I created, maintained, and reviewed various validation/qualification deliverables, ensuring that all systems were compliant with government regulations. Additionally, I provided ongoing support and valuable project insights to the management team. To optimize efficiency, I developed an Excel Application that accelerated the review process and provided effective controls.HRIS Business Analyst:As an HRIS Business Analyst, I played a pivotal role in the implementation of SuccessFactors and ServiceNow. In the SuccessFactors implementation, I collected and comprehended all relevant requirements, documenting functional requirements and mapping end-to-end business processes. Furthermore, I actively participated in the design and implementation of the ServiceNow HR service desk module. To ensure smooth operations, I defined specific data requirements, extracted and cleaned data, and prepared it for analysis, specifically for monitoring 100 different mobility scenarios. Additionally, I designed and implemented an Excel model that facilitated complex data migration scenarios, ensuring seamless transition and data integrity.

Johannesburg Area, South Africa

During my tenure as a consultant at Bytes Technology Group (Pty) Ltd, a subsidiary of Altech Group Ltd., a leading hi-tech firm in South Africa with an impressive turnover of over R400 million (GBP 21 million), my primary focus was on implementing the Microsoft Dynamics AX Management Reporter Product.As the primary point of contact for reviews related to the implemented computerized systems, I took charge of addressing queries and providing essential support to ensure smooth operations. Moreover, I played a crucial role in training senior management on how to effectively utilize the financial Management Reporting tool, equipping them with the necessary skills to make informed decisions.My responsibilities encompassed analyzing both business and product requirements, collaborating closely with stakeholders to develop a comprehensive project timeline. This involved creating vital project documentation, such as the Project Charter, Functional Requirement Documentation (FRD), Design Documentation, and detailed business process maps.In order to optimize business operations, I designed and communicated streamlined processes to ensure seamless integration and maximum utilization of the implemented system. Leveraging my expertise in Excel and VBA programming, I developed customized tools that provided ongoing support and valuable insights to the management team, enabling them to make data-driven decisions.Through my contributions, I played a critical role in successfully implementing the Microsoft Dynamics AX Management Reporter Product, enabling the organization to enhance its financial reporting capabilities and drive operational efficiency.

Israel, Tel Aviv

Project managed , created, communicated and documented processes for the implementation of Pyramid Analytics Business Intelligence toolMapped company business process using Visio created and documented user manuals Developed Excel reporting and patent applications using Visual Basics for Excel, Word and OutlookAutomated standard business processesCreated financial analytics and reporting together with financial statementsDesigned automation model to automate official patent forms, Information Disclosure Statements(IDS) , Foreign Filing cost estimates, Renewal Cost Estimates, Validation and other tasks. The efforts led improved quality of the forms, and reduced time to generate forms by 90%. This improved the productivity of the departments.

Johannesburg Area, South Africa

Consulted to international oil and gas companies and provided strategic, business and operational planning services. Created an integrated senior management project dashboard.Developed planning and budgeting applications for complex multimillion dollar projects being built in international locations.My efforts led to improved efficiencies and created effective reports that were used to make more informed strategic and business decisions. Saved time and improved the departments effectiveness

Lekki, Lagos State, Nigeria

Johannesburg Area, South Africa

Senior manager of a company manufacturing parts for industrial pumps.Implemented financial and manufacturing systems using Enterprise Resource Planning (ERP) software. Designed and improved the business processes, operational guidelines and financial controls for the company. Generate business intelligence reports to manage the financials and operations of the company. Operational guidelines led to an increase in efficiencies, reduction in waste and work in progress and reduction in real operating cost. Increased turnover and reduced operational costs creating increased profits. Improved the quality of goods manufactured to a 95% pass rate.

Undertook annual reviews of a portfolio of clients with turnover in excess of $5 million, to assess the financial, operational and credit risks, providing solutions to lending requirements, while minimizing the banks risk of default.

Master Of Business Administration - Mba, Finance And Strategy

*Distinction in Statistics *Undertook International Exchange at HEC Paris *Dissertation: "Economic Value Add in the Banking Sector"

Mba, Strategy

Exchange Student: Studied at HEC Paris (MBA) focusing mainly on Strategy Courses and International Negotiations.

Course In Data Analytics, Data Analytics

Course in Data Analytics focusing on: SQL Python Programming using Numpy, Pandas, Matplotlib, Beautiful Soup R programming Basic.

Bachelor Of Commerce (Honours), Business Economics

Distinction in Strategic Management