Badges
Certifications
Work Experience
Business Data Analyst
ExoStudios•  April 2021 - December 2022
• Utilized Python to automate data processing and cleaning tasks. • Conducted data analysis using SQL queries to extract insights from databases. • Worked with large datasets, including data cleansing, data manipulation, and data visualization. • Created and maintained reports and documentation to communicate insights and findings to stakeholders. • Used Tableau to create visualizations and dashboards for business stakeholders. • Collaborated with cross-functional teams to identify business problems and develop data-driven solutions. • Provided technical support and training to team members on Tableau, Python, and SQL databases.
Project Manager
Sky Windows and Aluminum Products LLC•  October 2019 - November 2022
• Project Management: customer support and conducting projects from start to finish; • Calculation of project expenses, preparation of test reports, blueprints and documentation; • Discussion and revision of projects details, search for optimal solutions, problem-solving at every step; • Contractor Foreman, Salesforce, Monday, communication problem-solving to improve the effectiveness of the team and department.
Senior Consultant
PricewaterhouseCoopers•  September 2016 - October 2019
• Led projects, organization of the interns’ work, junior staff, coordinating their work, distributing the responsibilities, and preparation of the results of the work; • Work in VSCode and MS SQL, preparation of unloading of accounting records (postings) from Quickbooks to processing in SQL, conducting the necessary tests, reconciliation with WWS, scripts; • Implementation of various tests and reports in Excel: formulas, pivots, search for a solution, macros; • Conducting Forensic corporate crime investigation projects, identifying fraud patterns and reporting; • Survey of organizations and the preparation of statistics on salary policies, and management efficiency factors.
CFO Assistant
Delta. Security Systems•  August 2014 - April 2015
• Financial reports, Cash Flow, Profits & Losses Report in MS Navision, preparation in Excel; • Analysis and elimination of errors in the reconciliation reports of intragroup turnovers; • The formation, revision, and optimization of reports for management accounting for internal use; • Performing the role of an intermediary between accounting and IT specialists in the transition of the implementation of MS Navision; helping in setting up the program for the organization's activities.
Education
Per Scholas Institute for Technology
Data Engineering, Course•  November 2022 - March 2023
Program: Data Engineering | 750+ hours of intensive data analysis/data engineering training over 15 weeks Linux Action Statements • Navigated through the directory tree and set up root and user permissions on a Virtual Machine, • Troubleshoot system logs and Managed user and folder permissions, • Used Nano, VIM, and VI editors within the bash shell as well as Archived and Zipped files, • Used a virtual machine to make an SSH connection through the CLI to connect to a remote machine Database SQL Action Statements • Downloaded, set up, and created a new database server using MariaDB and HeidiSQL • Created Databases and tables, using normalization and focused on data integrity • Ran Select statements to group data to make it accessible for end users and aggregation PostgreSQL • Created roles and assign permissions to roles and ownership; • Created & used trigger functions and bind them to a trigger procedure; • Created & used transactions and functions; • Created table schemas, views, tablespaces, and server groups • Used meta-commands in the SQL shell Python • Jupyter Notebook, Virtual Environment, VSCode IDE • Data Classes and methods, Built-in Functions, Writing Functions • XML Manipulation, JSON Manipulation, Parsing HTML • Closures, Decorators, Generators, Lambda functions, Try and Except • Database Connection using MySQL Connector • APIs, Connecting & Querying an API endpoint, Requests Module Data Analysis • Pandas (series, data frames, descriptive statistics, data aggregation, pandas’ methods, read files, data clearing) • Model Evaluation (linear, multilinear, and polynomial regression, cross-validation, training, and testing set, data pipeline, correlations, normalization, Rsquared, MSE, overfitting & underfitting) • Data Visualization (matplotlib, dash, Plotly, seaborn) • Data Modeling, Data Warehousing, and ETL Apache Spark, Tableau, Docker, DevOps Principles
Yandex Practicum with University 2035
Data Analyst Professional Training, Course•  December 2020 - April 2021
Kazan State University
General and Strategic Management, MS•  September 2014 - June 2016
Justus Liebig Universität Gießen
Transitional Economics Management, MS•  September 2015 - April 2016
Kazan State Finance and Economics Institute
Accounting, Financial Analysis and Audit, BS•  September 2010 - June 2014
Links
Skills
limonogon has not updated skills details yet.