William Andrade
Verified Expert in Engineering
SAP BI Consultant and Developer
Lisbon, Portugal
Toptal member since December 19, 2023
William is a senior consultant with over 20 years of IT experience, including 15 with SAP. He has worked in various industries such as oil, telecommunications, aviation, pharmaceutical, and media, and with many technologies from infrastructure through development in various languages and platforms. William currently works with SAP solutions, specializing in BI architecture, and has demonstrated leadership, management, and innovation experience.
Portfolio
Experience
- SAP Business Warehouse (BW) - 20 years
- Data Warehouse Design - 20 years
- ABAP - 20 years
- JavaScript - 10 years
- SAP HANA SQLScript - 10 years
- SAP BW on HANA - 10 years
- SAP HANA - 8 years
- SAP Analytics Cloud (SAC) - 6 years
Availability
Preferred Environment
Windows, SAP
The most amazing...
...thing I've developed is a system for processing all types of insurance, which generates the invoice accordingly and serves all types of insurance companies.
Work Experience
Senior BI Consultant
Stratesys
- Engaged as a technical team lead for a greenfield SAP Analytics Cloud (SAC) financial planning project for the client, ITP Aero, an airplane turbine manufacturer. I organized the technical architecture and supported the team in the development tasks.
- Built six applications in the SAC designer for data input.
- Developed two classic models to support the business users and process.
- Created data actions for multiple calculations for profit and loss, cash flow, balance sheets, and income statements.
- Produced stories to analyze main KPIs, such as sales, cost, and margin.
- Supported financial planning and analysis processes like product costing, personnel planning, overheads, investments, and project planning.
- Helped build the translation strategy, user profiles, teams, and connections to SAP S/4HANA to gather data from SAP CDS views since this was a greenfield project.
Senior BI Consultant
Novartis
- Acted as a SAC application developer and SAP Business Warehouse (BW) consultant, developing dashboards for cost tracking.
- Tracked and fixed bugs using Jira as a reporting tool.
- Developed KPIs mainly through applications and stories using charts and tables to manage HR costs such as full-time equivalents, purchase or spend, and cost allocation tracking.
Experience
BW Sales Track and Integration with Salesforce
Education
Master's Degree in Business Intelligence
Universidade Federal do Rio de Janeiro - Rio de Janeiro, Brazil
Certifications
SAP Certified Application Associate – SAP Analytics Cloud
SAP
Project Management Professional (PMP)
Project Management Institute (PMI)
SAP BW Certification
SAP
Skills
Languages
JavaScript, ABAP
Platforms
Windows, SAP HANA
Storage
SAP HANA SQLScript
Other
SAP, BIA, Data Analysis, Data Warehouse Design, SAP Analytics Cloud (SAC), SAP Business Warehouse (BW), SAP BW on HANA, IT Project Management
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring