FreightGuard International

Tech: Excel, VBA, Word, Power BI, Power Pivots
Other: Salesforce CRM, Business Process optimization, ARIS
Project 1: Pricing Model

Problem:
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 Reports

Problem:
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 Dashboards

Problem:
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 Administration
Acted as the Salesforce CRM administrator

Significantly 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.

Senior Data Specialist

Fractional CFO

Business Modelling Expert

Uniper Care 

Tech : Excel, VBA, SQL, Tableau, Tableau Prep, Snowflake, MixPanel 
Other: Zendesk, Confluence, Business Process Optimization
Data Pipeline: Unstructured Data
Problem:
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.

Senior Data Analyst

Wise Smoker

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

Interim - Chief Financial Officer

Brad Hofman

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.

Freelance Business and Data Consultant

Reinhold Cohn Group

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.

Data Analyst and Automation Consultant

Teva Pharmaceuticals

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.

Business Analyst

Bytes Technology Group

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.

Business Consultant - Financial Reporting Project

Ehrlich and Fenster Patent Attorneys

Project managed , created, communicated and documented processes for the implementation of Pyramid Analytics Business Intelligence tool
Mapped company business process using Visio created and documented user manuals 
Developed Excel reporting and patent applications using Visual Basics for Excel, Word and Outlook
Automated standard business processes
Created financial analytics and reporting together with financial statements

Designed 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.

Special Projects - Efficiency and Automation

Sasol Synfuels International (Pty) Ltd.

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

Senior Planning and Efficiency Consultant

Experienced Data Professional | Driving Insights and Efficiency through Data Analytics

My passion lies in helping companies harness their data to uncover valuable insights and drive efficiencies, resulting in time savings, cost reduction, and enhanced productivity.

I am a seasoned data professional with over 10 years’ experience in developing data driven solutions for companies. By harnessing the power of data, I have developed models that provide actionable insights and drive continuous improvements within organizations.

I possess advanced technical skills in Excel development, including expertise in VBA programming. Additionally, I have a solid grasp of SQL, Python, and diverse data visualization techniques, enabling me to effectively analyze and derive insights from data.
I am deeply passionate about empowering companies to unleash the untapped potential of their data. I am constantly seeking new avenues for collaboration, aiming to create transformative solutions that drive business growth. If you are interested in exploring how we can leverage data to propel your business forward, I invite you to connect with me.

Brad Hofman
Mobile: +972-58-462-9301
Email: hofman.brad@gmail.com

Taplio

Brad Hofman (MBA Finance)'s Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Brad Hofman (MBA Finance)'s Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Brad Hofman (MBA Finance)'s Linkedin Analytics