lprosh / junior-analyst-portfolio

The portfolio includes a mix of educational and technical tasks. For a more detailed description, see the README file.

👋 Hi there! I'm Liliia.

⚒️Tech Stack

• Python: NumPy, SymPy, SciPy, Pandas, Seaborn, Matplotlib
• SQL: DML (Subquery, JOIN, GROUP BY), DDL
• MS Excel: VLOOKUP, PivotTables, Power Query, Power Pivot, VBA (basic)
• Google Sheets
• Power BI, Tableau (basic)
• Git, Docker (basic)

📁 Junior Analyst Portfolio ru

During the interviews, I solved problems using certain analytics tools. You can get acquainted about it in the corresponding repository.

• MS Excel
• SQL
• Tableau

👔 Work experience

Job Position	Company	Department \ Division	Work Period
Junior Sales Suppor Analyst	Nestlé	Sales Dpt. \ Reporting Div.	12.2022 - present
Trainee Data Analyst	Nestlé	Sales Dpt. \ Reporting Div.	06.2022 - 12.2022
Intern Analyst	EVA Technologies	Analytics	11.2020 - 03.2021

🎓 Education

• Bachelor's degree in Mathematics at Peoples' Friendship University of Russia (2017 - 2021)
  • Diploma thesis: "Mathematical Modeling of Autowave Processes"
  • Courseworks:
    • Mathematical analysis: "Approximate Calculation of Integrals: Midpoint, Trapezoid, Simpson's rule"
    • Algebra: "Pell's equation"
    • Differential equations: "Bernoulli's Equation"

📜 Certifications

Stepik

• Basic Python, Python Programming, Good, Good Python by Sergey Balakirev
• Basic SQL

Coursera

• Operational Analytics in MS Excel
• Excel Power Tools for Data Analysis
• IBM Data Science Specialization
  • What is Data Science?
  • Tools for Data Science

SoloLearn

• SQL
• Python for Beginners

Other

• Basic Excel
• Advanced Excel

💬 Contacts

• Telegram: @proshlil
• E-mail: [email protected]