Learn Data Skills
Beta
Sergiu ŞERBAN

Sergiu ŞERBAN

Senior Financial Analyst

Steelcase

Technologies

My Portfolio Highlights

My New Track

Data Analyst

My New Course

Introduction to Python

My New Track

Data Analyst

Quantitative strategist, harnessing the power of data for strategic advantage.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to Python

course

Intermediate Python

course

Introduction to SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Steelcase | Jan 2022 - Present

Senior Financial Analyst

• External reporting to US entities such as Bureau of Labor Statistics and BIFMA (Business + Institutional Furniture Manufacturers Association). • Internal reporting on various functions & KPIs: Operations: Labor Reporting (daily & weekly) – data source & scripts maintenance, tableau dashboards development. Sales: Sales indicators for AMER & EMEA (orders, opportunities, pipeline, etc.), Backlog Computation (by variable), BIFMA Sales, Sales Slicers & Trends, Gap analysis. • Data extraction from sources such as SAP Business Warehouse, Sap S4/ Hana, Salesforce, Workforce, and other sources. • Data preparation and transformation for Tableau development using various tools such as SQL queries, Python scripts, Power Automate, Power Apps, Tableau Prep Builder. • Developing visualizations in Tableau (workbooks, dashboards, stories) according to the business needs. • Supporting the monthly/ quarterly/ yearly closing activities by preparing and presenting reports to various stakeholders.
Show More

Continental | Jan 2022 - Jan 2022

Shortage & Operational Risk Specialist

• Managed daily operational alignments with the customer operations manager and the plant representatives. • Maintained exceptional communication and secured the information flow with all the stakeholders (customer plants, supply chain management, suppliers, purchase). • Performed complex analysis of data and identified main supply chain components bottlenecks. • Offered support for escalation meetings at the executive levels and third- party calls with the suppliers when supply risks cannot be avoided. • Calculated the impact dates for the customer plants based on the supply chain allocation, customer requirements, and transportation time. • Developed risk assessments and mitigation strategies taking into consideration the supply chain and capacity constraints. • Participated in the standardization and continuous improvement of the shortage process. • Reported shortage updates for the customers under my responsibility in internal management meetings. • Participated in claim preparation and defence.

Continental | Dec 2020 - Jan 2022

Financial Analyst

• Steered the material management process using the SAP ERP for 4 segments and 14 customers according to the engineering releases and product lifecycle. • Effectively tracked, maintained, and adjusted the characteristics of each material/product, such as plan prices, product hierarchy, model version, project id, etc. • Forecasted production figures for the mid-term (1-3 years) based on historical deliveries, customer demands, market intelligence information, and alignments with sales managers. • Prepared the production figures for the budget in collaboration with other departments (sales, logistics, project management, supply chain). • Delivered reports and overviews based on the evolution of customer demands and the production planning (business as usual) or complex analysis of various data / KPIs / metrics: material coverage, supply plan allocation, cost/ revenue calculation, historical deliveries, etc. • Organized and managed internal monthly alignments with the sales, logistics, and engineering departments, and external meetings (less frequently) with customer representatives based on various topics: material and product specifications, production transfer, material shortage, etc.

OTP Bank Romania | Mar 2019 - Jan 2019

Internship Trainee

• Assisted with day-to-day operations and support the dedicated team in the corporate loans area. • Performed assessment of the documentation provided by borrowers to ensure compliance with regulations and the bank’s standards. • Created and updated (if necessary) the documentation of the operational procedures used. • Participated in the preparation of the documents linked to the terms and conditions for the customers.

SC RAU Bookstore SRL | Mar 2015 - Sep 2016

Commercial Assistant

• Part-time job at a sports facility with the following responsibilities: • Managed and tracked the bookings for each field according to customer priority. • Tracked the inventory of products using WinMentor ERP, placed orders to the suppliers when the inventory was low, and received the goods. • Offered customer support and information regarding the facilities, services, and products available at the commercial unit. • Managed the cash register and prepared the invoices for the customers. • Implemented a marketing campaign to increase the customer base.

Societatea de Ştiinţe Juridice | Jan 2012 - Oct 2013

Internship Trainee

• Performed research and documentation activities in the juridical area such as: writing essays, comments, and informative materials in diverse juridical areas; translations, and syntheses from Romanian to English; attending different juridical events and taking notes for articles posted on the www.juridice.ro platform; providing administrative and logistic support in organizing the in-house events for juridical specialists.

My Education

Take a look at my formal education

Master's degree, Quantiative Asset and Risk Management  · (septembrieFachhochschule des bfi Wien | 2022
Master's degree, Finance and Risk Management  · (septembrie 2020 - iulieUniversitatea „Alexandru Ioan Cuza” din Iași | 2022
Economics and FinanceUniwersytet Łódzki | 2020
Bachelor's degree, Finance and bankingUniversitatea „Alexandru Ioan Cuza” din Iași | 2020
LawUniversitatea Româno-Americană din București | 2016

About Me

Sergiu ŞERBAN

Sergiu hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free