About Me
Hi, I’m Ivan Zhukov.
I have been working in banking analytics for seven years, specializing in portfolio analysis and CRM. During this time, I have progressed from working with Excel, mastered SQL, and now I use Python and Spark, continuously enhancing my technological skills. I prefer to work as an analyst with a focus on technical functionality: programming, working with databases, creating visualizations, and generating reports. I enjoy solving complex problems and developing effective analytical tools that deliver measurable business impact.
Proficient in: SQL, Python
Tools Mastery: Apache Spark, Jupyter Notebook, Excel, Tableau
I am currently working remotely but am open to new opportunities in the United Kingdom or in a remote format.
Experience
Gidfinance
Data Analyst
Fintech B2B
July 2024 - Present
A finance startup focused on data enrichment and lead generation for microfinance companies
I handle regular reports, A/B testing, and ad hoc projects, plus I track user activity in online channels with an eye on risk indicators.
oneFactor
Data Analyst
Fintech B2B
January 2021 - February 2024
A high-tech company providing scoring and lead generation for banks and microfinance organisations
Created detailed daily reports monitoring the efficiency of lead generation campaigns for 10+ diverse clients, tracking key metrics to ensure data-driven decisions were made to improve marketing strategies.
Revised campaign logic and signal scope, leading to the development of 45 new data pipelines, expanding the company’s repository to 200 pipelines. This enhanced data flow and campaign effectiveness.
Addressed specific customer requests by conducting over 30 detailed analyses to check the accuracy of conversion funnels to identify areas for improvement, with the findings used to refine offers and services.
Enhanced SMS campaigns by creating 16 new SMS templates, with 9 designed to better target different customer segments and 7 aimed at specific audiences. This approach led to a 3% boost in conversion rates.
Facilitated pre-sales activities, preparing data for pilot campaigns, ensuring client requirements were met. Total customers increased from 13 to 30 and annual revenue from $10m to $16m between 2021 and 2024.
One of the top 10 largest banks in Russia
Identified and rectified a critical error in the credit conveyor system within the CRM integration, resolving services for 110,000 clients and leading to an approximate financial recovery of $3m over six months.
Developed and tested guidance for the PACL credit conveyor, expediting client approvals and offers. This collaboration with IT and Tech accelerated analysis processes and ensured swift client batch approvals.
Devised a revenue calculation method based on peak debt load, reducing gross loss risk by 0.4% for clients with low credit scores, considering full and partial loan repayments to enhance risk management strategies.
Conducted comprehensive research on internal fraud within bank offices, uncovering six suspicious activities and prompting internal audits, leading to strengthened internal control mechanisms and security.
Mentored a group of Data Analyst interns, training them in SQL, risk analysis, and core business processes.
A leading Russian insurance company specialising in auto, real estate, and health insurance
Automated call centre list preparation with SQL scripts, reducing prep time from 1.5 weeks to 4 days.
Developed four SSRS reports for the Digital Insurance division, including sales funnel diagrams, streamlining data reporting.
One of the top 10 banks in Russia and a pioneer in innovative technological solutions to the Russian financial sector
Delivered an automated ROI calculator for individual CIB clients and segments, utilising a prefab methodology to implement the script in SQL, leading to streamlined calculations and portfolio assessments.
Managed workload assessments for CIB Salesforce managers in collaboration with the HR CIB department, constructing an SSRS report with daily updates and recommendations to optimise workforce efficiency.
Regional bank with a strong position in private banking, servicing both individuals and businesses
Implemented an automated system to calculate incentive bonuses for attraction and support managers based on workloads, reducing calculation time from one day to several hours.
Reduced weekly data prep time from 2 days to 3 hrs by automating the reporting of SME portfolios (assets, liabilities, NPLs), enabling analysis of indicator dynamics based on data granularity and network geography.
Prepared tariff calculation tools for the sales department, helping to maximise efficiency and accuracy of loan parameter calculations.
Cross-collaborated on the development of competitor analysis for financial products, enhancing sales department productivity and the bank’s competitiveness in the market
Education
Bauman University
Master of Engineering in Nuclear Power Technology
Master of Management in Industrial Management
2007 - 2013
My education gave me a deep technical foundation with a focus on practical skills. I learned to solve complex problems quickly and continuously acquire new knowledge to stay current with modern technologies.
I studied at Bauman Moscow State Technical University — one of the best technical and engineering universities in the country. In 2013, I earned two specialist Masters’ degrees in technical and economic fields.
Over these six years, I studied engineering disciplines, programming, statistics, as well as economic subjects.
When I'm Not Coding
When I’m not coding, I love keeping up with the latest in data and tech. I’m always reading Medium articles or taking online courses to stay sharp, and right now, I’m especially into data visualisation and BI best practices. I follow a few top BI experts on social media, which helps me stay up-to-date with new trends.
I’m also curious about machine learning and have taken a few courses on it. I’m thinking about launching my own project in this area to apply what I’ve learned.
Outside work, I’m all about family time—I spend a lot of my free time exploring southern Britain with my son. We enjoy the parks, the countryside, and just soaking up the local culture.