Data Scientist Programmer Mathematician
ngoogstein@gmail.com
Google BigQuery
I use Google BigQuery as a productive and reliable data warehouse for all our non-personalized data. It is accessible from anywhere in the world and can be easily queried and analyzed using Looker.
Python
I utilize numerous Python scripts to extract data from internal sources. These scripts are run on a dedicated internal server operating Debian Linux, enabling efficient data retrieval and processing.
SQL
SQL is a significant part of my work because it is needed both for querying internal databases and as a native language inside BigQuery.
Looker Studio
I have developed several useful dashboards that display the current state of our business.
About me
As a mathematician, I take great pride in my diligent work with numbers and data, uncovering intricate patterns. With a dedicated focus on formulating and rigorously testing hypotheses, I utilize Python programming and the powerful BigQuery warehouse. My sincere goal is to advance my career in the fields of Data Science and Machine Learning, continuously enhancing my skills and expertise. I am committed to staying current with industry advancements, striving for excellence in all endeavors.
OPEN TO RELOCATION.
Achievments
70
Online dashboards
20
Subordinates in my team
5
Years in data analysis
4
Years as a product owner
2
Mathematical books
Experience
Head of Content and Data Analyst in Softline (2019-2023)
1. ETL/ELT: developing the process for data aggregation in Google BigQuery.
2. Building upto 70 dashboards using Google Looker Studio and BigQuery datasets to provide bysiness metrics insights to managers.
3. Fulfillment of tasks from various business customers including marketing and internal development departments.
4. As the Product Owner of our internal CRM mcf.softline.com I am responsible for defining its functional design.
Head of Content in Softline (2014-2019)
Management of the catalog of hardware and software in online stores in four countries, support for more than 50 product categories, the total number of product items has grown to 100,000 pieces,
A new content management system was implemented, the functionality of the system was developed by me and built by programmers.
Team Leader of content managers in Utinet (2011-2014)
I managed a group of content managers and oversaw the setup and maintenance of product categories in the Utinet online
store.
This included developing an information model for each category such as laptops servers and desktops planning the
queue for filling product cards and collaborating with catalog developers on new functionality. Additionally I managed the team and worked closely with category managers to ensure seamless communication and coordination.
Certifications
May 2023
Data Scientist with Python (DataCamp)
The course teaches Python skills specifically tailored towards data science, including data manipulation, analysis, and machine learning. It covers important Python libraries used in data science like Pandas, Seaborn, Matplotlib, scikit-learn. It works with real-world datasets to practice statistical techniques and machine learning algorithms for tasks like hypothesis testing and predictive modeling. The course aims to build hard skills in Python and data science, as well as career-readiness for roles like data scientist. It starts with Python basics but progresses to more advanced techniques like supervised learning and projects.
May 2023
Data Analyst (DataCamp)
This course provides comprehensive training in data analysis, focusing on practical skills using Python. It begins with interactive exercises and hands-on experience with popular Python libraries such as pandas, NumPy, and Seaborn. By working with real-world datasets, you will develop expertise in data manipulation and exploratory data analysis. As you advance, the course covers essential topics such as data manipulation techniques and data joining. Additionally, you will acquire key statistical skills, including hypothesis testing.
Nov 2022
Introduction to Tableau (DataCamp)
Tableau is a widely used business intelligence (BI) and analytics software trusted by companies like Amazon, Experian, and Unilever to explore, visualize, and securely share data in the form of Workbooks and Dashboards. With its user-friendly drag-and-drop functionality it can be used by everyone to quickly clean, analyze, and visualize your team’s data.
June 2023
Preparing for Google Cloud Certification: Cloud Data Engineer
The Spezialization includes:
1. Modernizing Data Lakes and Data Warehouses with Google Cloud
2. Preparing for the Google Cloud Professional Data Engineer Exam
3. Building Batch Data Pipelines on Google Cloud
4. Building Resilient Streaming Analytics Systems on Google Cloud
5. Google Cloud Big Data and Machine Learning Fundamentals
6. Smart Analytics, Machine Learning, and AI on Google Cloud
May 2023
Analyzing and Visualizing Data in Looker
Use dimensions, measures, filters, and pivots to analyze and visualize data
Create advanced metrics instantaneously with table calculations
Create and share visualizations using Looks and dashboards
Discuss the use of folders and boards in Looker to manage and organize content
June 2023
Building Batch Data Pipelines on Google Cloud
Review different methods of data loading: EL, ELT and ETL and when to use what
Run Hadoop on Dataproc, leverage Cloud Storage, and optimize Dataproc jobs
Build your data processing pipelines using Dataflow
Manage data pipelines with Data Fusion and Cloud Composer
Education
June 2000 - November 2003PhD in Mathematics
Russian Academy of Sciences Institute of Applied Mathematical Research
My dissertation was focused on Random Forests and Random Permutations.
September 1994 - June 2000Master's degree in Math
Petrozavodsk State University
I studied various mathematical disciplines including analysis probability theory programming mathematical logic etc.
My projects
August 20167 - now
MCF: matching catalog and content factory
I have developed the entire functional design of our CMS and ensured its
development and implementation with a team of developers.
June 2021 - now
Mathematics as a foreign language (in Russian)
This playlist comprises 17 videos, wherein I endeavor to elucidate mathematics as if it were a foreign language. Commencing with level A1, which delves into basic logic, it culminates at level B2, exploring formal arithmetic and set theory.
September 2022
The book "Introduction to real Mathematics" (in Russian)
The book presents the fundamental concepts of classical mathematics, including
group theory, analysis, and geometry.
December 2019
The book "Archetypes of Mathematics" (in Russian)
This is my monograph dedicated to the foundations of mathematics and its basic
ideas and principals.