Might be available
(Updated 2022-10-30)BIG DATA ANALYST
Cobeña, España
Fluent English
- MySQL
- Access
- PowerBI
Skills (19)
Business Intelligence
DATABASE
Excel
BI
Power BI
FINANCE
Excel Macros
INDUSTRIAL ENGINEER
SQL
ACCOUNTING
SAS
QUALITY ASSURANCE
BUDGETS
ADJUSTMENTS
PROBLEM SOLVING
ACCOUNTING SYSTEMS
TRANSLATING
CONTINUOUS IMPROVEMENT
VBA
Professional Experience
2012-01 - 2021-01
Responsible for Monitoring and Presentation of the Profits & Loss Account of Corporate Investment Banking in Global Markets.
" Successfully improved the data output of the management account and reporting by more than 100%, automating P&L and franchise reports with Python, Excel and Access Data base. Allowing a more agile analysis and improving business anticipation.
" Managed to add chronologically the historical balances of the financial securitizations in a database with pySpark and SQL in the Data Lake, which allowed accounting adjustments that reached 22 million euros in P&L.
" Designed a Dashboard in Power BI with DAX, through an excel Database, which automatically showed statistical figures from different issues caused by accounting systems and adjustment by product received from the risk area.
2006-01 - 2011-01
Responsible for assessing markets and investment strategies to make the right financial decisions. Performing calculations, managing budgets, analyzing costs keeping in mind accounting principles. Operating various software's like Bloomberg and Reuter to perform research of financial and economic facts.
" Created a robust database linked to Bloomberg, which performed different calculus to generate key information. " Developed Excel Macros to facilitate the end of the month, obtaining the P&L, return and duration by Products.
Academic Background
2024-12 - 2024-12
2024-12 - 2024-12