Umiejętności
Access
AML
Analiza
Oprogramowanie Cognos
Corporate Finance
Analiza kredytowa
Ryzyko kredytowe
Kontrole wewnętrzne
Microsoft Excel
Microsoft Office
MS Excel Tabele przestawne
Onboarding
PowerPoint
QlikView
SharePoint
SOP authoring
SOP development
SOPC Builder
SQL
SQL Tools
Stress Testing
SAS Enterprise Guide
Narzedzia Business Intelligence
MS Office (Word, PPT, Outlook, Excel)
SQL Developer
PLSQL - Oracle
SQL Oracle
Prawo jazdy kat.B (czynne)
VBA w środowisku MS Excel - tworzenie makr do automatyzacji przetwarzania danych, tworzenie funcji oraz aplikacji (formularze)
process mapping
VBA Visual Basic for Applications
Języki
polski
ojczysty
angielski
dobry
rosyjski
dobry
Doświadczenie zawodowe
Backend Developer
- Customization of the back end of MI modules (interface, customer’s historical data loads, data loading),
- Preparing optimized SQL, PL/SQL queries/ procedures,
- Optimization of the application for maximum speed and scalability,
- Implementation/ improvements of data storage/export solutions,
- Integration of user-facing elements developed by a front-end developers with server side logic,
-Designing processes using ETL tool.
- Preparing optimized SQL, PL/SQL queries/ procedures,
- Optimization of the application for maximum speed and scalability,
- Implementation/ improvements of data storage/export solutions,
- Integration of user-facing elements developed by a front-end developers with server side logic,
-Designing processes using ETL tool.
Credit Risk Portfolio Reporting Specialist
- Preaparing variety of reports and analysis concerning credit portfolio quality using: Oracle PL/SQL, Excel, VBA, SAS 4GL.
- Participation in the credit portfolio quality data preparation for IPO process
(analyst presentation and prospectus).
- Preparing “Forbearance” Report according to the EBA standards.
- Testing new Oracle Database dedicated to Integrated Risk Management Department.
- Preparing credit portfolio quality data dashboards and presentations for
“Credit Portfolio Steering Committee”.
- Filling out the KNF questionnaires.
- Participation in the credit portfolio quality data preparation for IPO process
(analyst presentation and prospectus).
- Preparing “Forbearance” Report according to the EBA standards.
- Testing new Oracle Database dedicated to Integrated Risk Management Department.
- Preparing credit portfolio quality data dashboards and presentations for
“Credit Portfolio Steering Committee”.
- Filling out the KNF questionnaires.
Analysis and Reporting Specialist
- The development of reporting system in “Digital Banking” area.
- Analysis of sales growth, processes and products profitability sold via Internet and recommending improvements in sales process.
- Creating billing reports for financial controlling department.
- Preparing reports for online sales and other remote channels (water-fall, sales per source, etc.) and its optimization based on VBA.
- Active cooperation with other bank units in order to collect data source for reports.
- Designing and managing of Access Database.
- Preparing KPI Dashboards for the board of Directors.
- Analysing data concerning traffic and conversion on the website using Google Analytics.
- Analysis of sales growth, processes and products profitability sold via Internet and recommending improvements in sales process.
- Creating billing reports for financial controlling department.
- Preparing reports for online sales and other remote channels (water-fall, sales per source, etc.) and its optimization based on VBA.
- Active cooperation with other bank units in order to collect data source for reports.
- Designing and managing of Access Database.
- Preparing KPI Dashboards for the board of Directors.
- Analysing data concerning traffic and conversion on the website using Google Analytics.
Analyst
- Provide the necessary analytical data to support business decisions in the area of sales operations (sales analyser, sales deduction, gross margin, deviations, plan achivements, open orders, price waterfall)
- Creating the application and participation in the sales estimation (sales deduction area), control its execution ( VBA/ SQL programming).
- The development of modern methods of reporting of sales data and its automation using different tools
- Analysis of growth and profitability of customers / products
- Cooperation with other organizational units in terms of data collection and analysis,
- Sharepoint administration
- Access database administration
- Creating the application and participation in the sales estimation (sales deduction area), control its execution ( VBA/ SQL programming).
- The development of modern methods of reporting of sales data and its automation using different tools
- Analysis of growth and profitability of customers / products
- Cooperation with other organizational units in terms of data collection and analysis,
- Sharepoint administration
- Access database administration
Senior Accredited Analyst/ Analyst
- accumulating facts from investigations to be utilized in presentation to Senior Management and Compliance
- conducting enhanced due diligence investigations in support of policies and procedures of RBS Corporate Customers
- reporting unusual client activities which might relate to money laundering or terrorist financing
- conduct alert investigation using global standard policies, procedures and tools, aimed at meeting internal and external regulatory requirements
- participation in process optimalization, taking part in additional tasks like creating process maps for new joiners/ SOP's.
- establishing and maintaining of business relations with internal and external partners,
- identifying and escalating potential risks and operational issues as appropriate,
- preparing daily reports for the department,
- analyzing alerts and investigating transactional activities to detect any suspicions of money, laundering or terrorist financing activity
- conducting enhanced due diligence investigations in support of policies and procedures of RBS Corporate Customers
- reporting unusual client activities which might relate to money laundering or terrorist financing
- conduct alert investigation using global standard policies, procedures and tools, aimed at meeting internal and external regulatory requirements
- participation in process optimalization, taking part in additional tasks like creating process maps for new joiners/ SOP's.
- establishing and maintaining of business relations with internal and external partners,
- identifying and escalating potential risks and operational issues as appropriate,
- preparing daily reports for the department,
- analyzing alerts and investigating transactional activities to detect any suspicions of money, laundering or terrorist financing activity
Specjalizacje
Finanse/Ekonomia
Rynki kapitałowe
Ubezpieczenia
Analizy/Ryzyko/Aktuariat
Grupy
CIMA - The Chartered Institute of Management Accountants
Candidates, students, associates, fellows & other fans of CIMA
Skazani na sukces.
Grupa jest tylko i wyłącznie dla ludzi, którzy nie boją się podjąć wyzwań na skalę globalną oraz takich, którzy nie boją się kontaktów z rekinami biznesu.