Learn Data Skills
Marek Keller

Marek Keller

Data Analyst

unemployed | Warsaw

Technologies

My Portfolio Highlights

My New Project

Investigating Netflix Movies

My New Course

Introduction to Python

My New Project

Investigating Netflix Movies

Quantitative detective, solving mysteries and uncovering truths in data.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Intermediate Git

PythonSQLGit
course

Introduction to Python

course

Introduction to SQL

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Amazon Web Services AWS Solutions Architect - Professional

DataCamp Course Completion

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

Courses

Introduction to Python
Introduction to SQL
Intermediate Python
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

NatWest | Sep 2022 - Present

Data Analytics Manager

Risk & Finance Data Transformation: - managing the analysis of complex Bank, franchise or function data to identify business issues and opportunities - supporting the delivery of high quality business solutions including data transformation and cloud
Show More

NatWest Markets Plc | Jan 2022 - Aug 2022

Finance Systems Analysis & Change Manager (Senior Business Analyst)

T0 P&L Flash project: - creation of the new Operating Model for the process consolidating procedures for the Front Office, Middle Office, Finance and IT departments - review and remediation of the tech infrastructure and data flow in order to: * increase P&L accuracy for the End-of-Day process in Front Office * shorten the time spent in Front Office for the P&L sign-off * align the P&L process to Regulatory and internal policies requirements * increase the ratio of automated P&L deliveries in Finance - managing regular product calls with stakeholders, gathering new process requirements and addressing to appropriate programmes within the Bank

NatWest Markets | Oct 2016 - Dec 2021

Team Leader/Manager (VP), Portfolio Optimisation & Clearing, Warsaw Middle Office

Running the team supporting Front Office in the below areas: a) Compressions - ensuring global Bank's exposure is constantly being reduced as per EMIR and Dodd Frank requirements, ie. reducing exposure with London Clearing House via SOLO runs b) Clearing - ensuring all the Mandatory-to-Clear trades (under EMIR and DoddFrank) for the whole Bank are being successfully logged with Clearing House, including both Rates and Credit products; running controls ensuring proper categorization of regimes is applied c) Backloading - re-affirmation of trades on the market via MarkitWire platform, resolving discrepancies on trades economics between Bank's accountancy/ risk systems and bilateral Clients; investigating IT issues; maintaining proper Customer relationship d) Trade Stamping - ensuring that the total population of the trades in the Bank has a proper information on the CSA, Initial and Variation Margin details for proper collateral calculation - Deputy Manager of Central's POD in Warsaw Middle Office (24 professionals) - Ensuring high level of accuracy, meeting deadlines and proper work prioritization in a dynamic and challenging environment - Process development and optimisation, removing control gaps, increasing efficiency - Relationship management with Customers and business stakeholders based in London - Transition of the Portfolio Optimisation & Clearing Team from London to Warsaw; and supporting other transitions within Middle Office area

Royal Bank of Scotland | Mar 2015 - Sep 2016

Fixings & Reconciliations Rates Team Leader (Middle Office)

Team Management (6 professionals) Supporting MO operations for following Front Office desks: Options, Inflation, Vanilla & Emerging Markets, Hybrids, Exotic Rates. Activities range greatly for these businesses including: - Daily Interest Rates Fixings for Rates products - End-of-Day FX Rates control - the official closing Spots and Forward Curves for the whole Bank - Reconciliations between internal systems and vs external (Clearinghouses, via Markitwire), including products from Rates & Currencies worlds - Process development & improvement, focus on removing control gaps & increasing efficiency (LEAN 1A accreditation) - close co-operation with Risk & Control: weekly control forums with Senior Management, risk adequacies testing, incidents management

BNY Mellon | Jan 2014 - Feb 2015

Assistant Manager in Derivatives Support Department

- department co-management (team of 12): recruitment, cross-training, defining knowledge/process gaps, periodical performance goals settings and reviews, Competencies Assessment Matrix creation and weekly administration, knowledge sharing, Business Continuity Plan, overtime approval, Holidays’ planning, daily tasks allocation etc. - OTC derivatives support for the daily NAV production by internal Fund Accounting Dep: trade capture, life cycle events, reconciliation on the range of Over-The-Counter financial instruments (SWAPs, FX Forwards, OTC options, etc.), - 2 successful business migration projects: department start-up (training in Cork and transferring daily reconciliation tasks), additional trade capture tasks (transition from Dublin with SME on-site training in Wrocław), - project for main reconciliation tool transfer between 2 external providers

Citi | Aug 2011 - Dec 2013

Fund Accounting Analyst in NAV Luxembourg Dep

- daily NAV production: analysis of other departments inputs (Trade Processing, Static Data, Corporate Actions etc.), interpretation of the accounting exceptions, errors, NAVs review performed by junior analysts, - independent NAV production process during the night shift: fund accounting, analysis of the accounts variances and entries processed by other departments, queries with the Pricing Department on the prices applied and their sources, reports production for the internal and external purposes (including use of the SQL tools and macros), NAV publication (sending emails/ reports to the client, NAV price to the TA),

Royal Bank of Scotland | Oct 2008 - Jul 2011

Fund Accounting Oversight Officer

- oversight activities over valuations produced by external Fund Accountants (as a Management Company for funds domiciled in Luxembourg), - coordination of new fund launches, migrations, transfers, mergers, liquidations, - other controls related to the operational side of fund’s management activities – accuracy of asset and cash reconciliation, Performance Fees review, budget set-up and TER evolution analysis, - NAV Error correction process – impact calculation and remedial action plan, reporting to the regulatory authorities (CSSF), - investment funds’ performance analysis against market indices, - External Compliance Review – on-site audit of the procedures and organization of the external Fund Accountants, - review of the Service Level Agreements and Operating Memorandum, comments on funds Prospectuses and KPI requirements, - support during Financial Year End process – comments on Annual Reports and Long Form Reports, Financial Statements review, issuing Comfort Letters to the Auditors and Board of Directors of the Fund, - advisory on Fair Value Policy, Swing Pricing and Dilution Levy procedures upon occurrence, - reporting to Fund’s Board of Directors (FA overall performance),

BNY Mellon | Jan 2008 - Sep 2008

Fund Administrator

- daily NAV calculation – worldwide Investment Funds domiciled in Luxembourg (including Hedge Funds), - processing transactions into the accounting system: booking securities, bonds, FX transactions, derivatives, TA activities, - assets and cash reconciliation, investigating discrepancies with Custody and Fund representatives, - expenses accruals, budget and taxes set up review, - specific controls and validation of prices used for NAV calculation, interest rates, corporate actions, fees accruals etc., - stress tests after IT developments in the accounting system.

Bank BPH | Dec 2006 - Dec 2007

Relationship Manager

- sale of banking products and service to the biggest corporate players in the TMT market (Telecoms, Media, IT) in Poland and Central Europe, - advisory support for Cash Management, eBanking, Loan Facilities, Structured Finance, Trade Finance, Bank Guarantees, - individual projects supporting Spin-off and Merger processes with Bank Pekao SA within UniCredit Group, - involvement in loan granting process (due diligence, analyzing customer’s profitability, preparation of the loan application, attending to the Bank Credit Committee sessions, post-granting loan administration), - coordination of the special financial projects – i.e. bond issuance, companies take-overs by Private Equity Funds, - managing customers portfolio and maintaining relations with key clients from TMT Industry

Volkswagen AG | Mar 2006 - Nov 2006

Recruitment Officer

- Recruitment processes including Assessment Centres and Personal Marketing - Individual Projects (ie. on reducing employees work absention)

My Education

Take a look at my formal education

Master's degree, Economics, Economic Policy and Corporate StrategiesUniwersytet Ekonomiczny w Poznaniu | 2006

About Me

Marek Keller

I'm trying to refocus from Finance to Technology

Powered by

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