Rafael Feldhaus Email & Phone Number

Ottawa, On, Ca

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

- Develop and maintain comprehensive reporting and analysis for different lines of business, leveraging data to provide insights and support decision-making.- Optimize Power BI reports using external tools, achieving 50%+ size reduction, 60% faster updates, and reduced cloud costs for data consumption and processing- Streamline complex SQL queries to fetch only relevant data for reports, minimizing data volume processed in Power BI.- Manage the full data lifecycle, collaborating with business users to identify and articulate requirements, designing and building viable solutions, and testing and deploying solutions across multiple environments, ensuring smooth and efficient operations.- Design and build compelling dashboards that provide actionable insights and facilitate cross-functional collaboration across the lines of business.- Enhance core team analytics by developing and curating reports, dashboards, and datasets, enabling stakeholders to make informed decisions based on accurate and up-to-date information.- Use advanced analytics techniques to generate actionable insights and forecasts on business performance data, identifying trends, patterns, and opportunities for improvement.- Identify and select the most appropriate data sources to meet user needs, ensuring the relevance, accuracy, and completeness of the information provided.- Perform data profiling and mining activities to uncover patterns and insights that inform business decisions, applying statistical analysis techniques and communicating findings clearly to stakeholders.- Analyze query and report output, interpreting results and providing insightful reports that explain key findings to clients, enabling them to make informed decisions based on the data.

Ottawa, Ontario, Canada

Designed and developed dashboards in Power BI, providing data visibility to stakeholders in business development, sales, and operations areas, resulting in actionable insights and improved decision-making.Maintained and optimized Power BI workspaces, including setting up data refresh schedules, managing permissions, and performing other administrative tasks, resulting in smooth and efficient operations.Collaborated with partners such as Microsoft to develop various reports using internal and external data and multiple sources, delivering valuable business insights, identifying trends, and supporting business development activities.Engineered an ETL process using Power Query, enabling daily inventory performance data collection, and enabling the delivery of product performance reports 50% earlier, improving the efficiency and effectiveness of customer deliverables.Identified opportunities for process improvements, particularly in data entry activities, to enhance data quality and accuracy, enabling better decision-making, and more reliable insights.Ensured the security, availability, data integrity, and accuracy across various data sources, proactively monitoring and resolving issues, and safeguarding the integrity of the data provided to users.Developed an automated process using Power Automate to streamline operations, eliminating repetitive tasks and consolidating daily email orders into a centralized data source, enhancing efficiency and enabling the generation of insightful Power BI reports.Led the company's CRM selection process, gathering and analyzing requirements, and conducting a thorough comparison of competing solutions to ensure the adoption of the most suitable platform.Took charge of CRM implementation, overseeing the seamless import of transaction data and client portfolios, while also crafting a robust sales pipeline. Established clear, actionable milestones for each stage of deals, ensuring a structured and efficient sales process.

Brazil

- Contributed to the Sales Operations area to review and improve the sales process pipeline and sales reports.- Participated in the quarterly and annual company’s strategy meetings, presenting the accurate forecast for the next period and contributing with market insights - Worked close to the HR team to implement a new scorecard for the variable remuneration to the sales team- Defined, tracked and reported sales performance metrics and trends using Business Intelligence tools- Coordinated the new distribution contract agreement implementation, according to the company’s compliance policies, tracking and reporting the acceptance by the dealers.- Supported on the project management to adopt an EDI system between the dealer’s network and the company to provide real-time data to the product inventory system through OLAP cubes- Managed key accounts supporting customers with reports on their Return on Investment (ROI) and markup data- Raised direct and channel sales by 50% leading a team of 7 technical sales representatives, awarded with the best regional performance in 2016

Brazil

- Developed business and sales plans for key clients to plan, execute, control and track all their commercial actions through OLAP Cubes- Contributed to the development and implementation of a commercial scorecard, to determine the benefits in terms of pricing and payment conditions based on each distributor’s performance. - Excelled managing the largest retailer in Brazil (Dental Cremer, a Henry Schein company) that was an opportunity to use analytics to achieve excellent results and change this case in a benchmark in the company.- Established a routine to support the scaling-up phase of Henry Schein Brazilian branch, with a weekly meeting between the client’s purchasing team and the operation and supply chain company’s representants to identify issues and opportunities in the short and mid-term- Sold dental consumable products and equipment for the distribution network and e-commerce acting partners in the territory

Curitiba, Paraná, Brazil

- Created an Order Submission System in Microsoft Excel so that the sales team could send their orders by e-mail - Managed the territory in terms of performance and in maintaining effective relationships across a base of pet retailers and veterinary clinics- Filled market demand of the companies' products by maintaining inventory levels and attaining distribution targets for the brands' portfolio- Delivered presentation and training to ensure the retail sales team had knowledge and qualification to expand the market share from companies' product

Bachelor'S, Business Administration

Final Paper: Analysis of the commercial management model of companies specialized in pet retail in the city of Curitiba / PR

Postgraduate Degree, Commercial Management And Sales

Final Paper: The impact of Technologic, Economic, Social and Culture Changes on Brazilian Retail Management

Professional Certificate, React.Js

Front end development: HTML, CSS, JavaScript, React.JS