Power BI
Horea Gavris
Business Analyst
Cluj Napoca
Summary
Business Intelligence Developer with over 8 years of experience in designing, developing, and testing advanced dashboards and reports using Power BI. Proficient in SQL with 5+ years of experience and skilled in Azure Data Factory with over a year of hands-on experience. Recently worked with Databricks for 6 months to develop and maintain a robust Data Warehouse. Adept at extracting, transforming, and loading data for visualizations, developing Power Apps for business dashboards, and administering Power BI Reporting Server. Experienced in developing and executing database queries, conducting in-depth analyses, and maintaining documentation on data visualizations. Committed to ensuring data integrity across all systems, participating in roadmap development for future visualizations, and providing Power BI support and guidelines to colleagues to ensure a consistent and efficient end-user experience.
Overview
11
11
years of professional experience
3
3
Certifications
3
3
Languages
Work History
Senior Business Intelligence Developer
3Pillar
2 2021 - Current
- Design, develop, and test advanced dashboards and reports using PowerBI.
- Development of Power Apps used in business dashboards.
- Extract, transform, and load data for visualizations.
- Administrator Power BI Reporting Server.
- Develop and execute database queries and conduct analyses.
- Development of pipelines in Azure Data Factory.
- Work in Databricks to develop Data Warehouse.
- Upkeep of Data Warehouse.
- Interrogate Data Warehouse to get best data for dashboards.
- Maintain documentation on data visualizations.
- Constant work on data integrity throughout all of our systems.
- Participate in roadmap development sessions for future visualizations and dashboards.
- Offer Power BI support to my colleagues.
- Create guidelines to produce a consistent, standardized, and efficient end user experience.
Business Analyst
Emerson
06.2018 - 02.2021
- Developing new dashboards using different software like: Power BI ,SSRS or Tableau.
- Writing SQL queries for SSRS reports and Power BI dashboards.
- Go-to person for Excel, Tableau and Power BI issues.
- Owner on multiple projects such as, process improvement, revenue growth and data integrity.
- Provide data analysis and data integrity of business ERP.
- Offer technical and process learning support inside business department.
- Identifying needs and offer feedback for process improvement.
- Offer accurate solutions in short timeframes
- Working closely with managers to meet business needs.
- Provide Power BI and Tableau trainings for colleagues.
Senior Project Controller
Bombardier
07.2017 - 06.2018
- Responsible for dashboard automation and optimization by developing macros
- Responsible for month end reporting operations in terms of expense controlling and project performance
- Analyzing project KPIs against budget and forecast
- Reconciliation of data between SAP and the group consolidation ERP, Global Fore
- Creating and monitoring train production progress based on costs / hours booked on specific activities, networks, WBS’s
- Responsible for all factoring activities
- Customer/Supplier invoices
- Customer/Supplier invoices – approval, payment coordination and variation requests
- Issue final invoices towards customers based on project calculations
- Responsible for costs booking
Sales Analyst
Emerson
08.2015 - 07.2017
- Collect data and prepare reports for order and sales POR for total EMEA, by MU and by COE
- Collect data and prepare reports for weekly order and sales reports
- Collect data and prepare reports for various order and sales parameters and KPI
- In charge of the monthly forecast for orders and sales
- Prepare other sales and MU reports and analyses as directed by the Director Planning and Administration
- In charge with creating, adjusting and handling all sales pipeline reports for the Sales Process Manager
- Responsible for new reporting implementation and functionality
- In charge of monthly presentation of the EMEA orders & sales to the Sales Management
Price Analyst
Emerson
09.2013 - 08.2015
- Coordinate, analyze, manage and monitor Price Lists and Price/discount escalations for all Emerson Network Power Systems products in order to support pre-sales efforts of EMEA Market Units
- Interface with Sales offices, as well as with other functional units within Bid Management Team and in order to ensure smooth and timely creation and submission of commercial quotes
- Collect and analyze requirements for pricing support from Sales offices, provide operational pricing support when requested and identify the needs for price/discount escalations
- Analyze, prepare and process the Special Price Requests (SPR) received from Sales Offices
- Apply respective Price lists and multipliers by Country/Market Unit, by Product, also the Price lists/multipliers for Partners /Distribution channels) as well as specific Price list for Key Account business
- Analyze/optimize the SPR processing flow in co-operation with COEs and other functional units
Education
Masters in European Projects - European Projects Management And Evaluation
Faculty of Economics And Business Management
Cluj Napoca Sep 2008 - 06.2010
Bachelor in Finance And Banking - Finance And Banking
Faculty of Economics And Business Management
Cluj Napoca Sep 2005 - 06.2008
Software
Tableau
Excel
SQL
SSRS
Databricks
Azure Data Factory
Python
SAP
Salesforce
JavaScript
VBA
Certification
Certified Frond-End Web Development
Timeline
Certified Frond-End Web Development
11-2018
Business Analyst
Emerson
06.2018 - 02.2021
Senior Project Controller
Bombardier
07.2017 - 06.2018
Certified Microsoft Excel Advanced
10-2016
Sales Analyst
Emerson
08.2015 - 07.2017
Certified VBA Programming - Microsoft Office Excel
05-2015
Price Analyst
Emerson
09.2013 - 08.2015
Senior Business Intelligence Developer
3Pillar
2 2021 - Current
Masters in European Projects - European Projects Management And Evaluation
Faculty of Economics And Business Management
Sep 2008 - 06.2010
Bachelor in Finance And Banking - Finance And Banking
Faculty of Economics And Business Management
Sep 2005 - 06.2008
Similar Profiles
Prince ChaudharyPrince Chaudhary
Senior Team Lead at 3pillar GlobalSenior Team Lead at 3pillar Global
SK SADIP RAHMANSK SADIP RAHMAN
Sr Business Development Representative - Global Accounts at 3Pillar GlobalSr Business Development Representative - Global Accounts at 3Pillar Global
Sidhant SatpathySidhant Satpathy
QA Team Lead at 3pillar GlobalQA Team Lead at 3pillar Global
Daniel CristeaDaniel Cristea
Car rental contract operator at Tim Rent a CarCar rental contract operator at Tim Rent a Car
Opinca StefaniaOpinca Stefania
Manager at Urban TreatsManager at Urban Treats