Learn Data Skills
Beta
Andrey Kotovets

Andrey Kotovets

Data Analyst

UC Berkeley | San Fransisco

Technologies

Over 12 years of experience in Data Analysis. Proficient in integrating extensive SQL development, Business Intelligence expertise (Power BI, Tableau), and advanced Python analytics, developing robust data solutions that enhance business decision-making and operational efficiency.

My Work

Take a look at my latest work.

article

Employee Retention. Part 1: Exploratory Data Analysis

Python
article

NYC Citi Bike Share Program Analysis. Part 1: Performing analysis

PythonSQLTableau
article

NYC Citi Bike Share Program Analysis. Part 2

PythonSQLTableau
article

Employee Retention. Part 2: Predictive Modeling

Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

University Of California Berkeley Data Analytics

Google Google Data Analytics

IBM Data Analysis

DataCamp Course Completion

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

My Work Experience

Where I've interned and worked during my career.

Truist | Feb 2021 - Present

Data Analyst

Gathered requirements from various business lines to create sales performance reports (loan funding, loan fees, deposit growth, new relationships, cross-sales). Acted as a liaison between the commercial line and IT department to facilitate the implementation of database modifications. Collected requirements for customized performance reports and queries (pre- and post-tax, synthetic, and gross-of-fee calculations) and developed them according to customer specifications. Developed, modified, and maintained Python scripts to ensure efficient data transfer and integrity. Ensured the accuracy of weekly data loads by evaluating and refining the load procedure rules.
Show More

B2Future Consulting | Jan 2016 - Feb 2021

Business Data Analyst

Designed complex interactive dashboards using Tableau for over 100 clients. Analyzed the data flow between client systems and pipeline dashboards to ensure data integrity, identifying and resolving issues related to various metrics not displaying on the dashboards. Conducted ad hoc data analysis, research, and reporting, and set up new automated reports as required. Developed and maintained a Data Dictionary to clarify communication and eliminate ambiguity across different departments. Created Data Flow Diagrams to illustrate the connections and data flow between various applications. Led cross-functional team projects to comprehend business processes, gather and document requirements, and convert these into functional and non-functional specifications for BI reports and applications. This led to the implementation of various data analytic solutions, across  500+ clients, and 2000+ users.

OMС-Management | Mar 2012 - Oct 2015

Information Technology Business Analyst

• Created 250 documented procedures and regulations for 16 company departments in less than 1 year by creating business process models and documenting processes, defining stakeholders needs, identifying problems, and identifying and consolidating best practices in corporate regulations and procedures • Developed and implemented Computerized Maintenance Management System (CMMS - a software solution for Facility Management Companies) in 9 months by leading a cross-functional 12-member team

EuroDesign | Mar 2009 - Oct 2012

Business Analyst

• Identified business needs and problems, overhauled processes, defined IT requirements, tested new software solutions, rolled out training, and supported more than 1000 users • Created business process models and documented processes (50+ in 9 months) for all departments with a total of 1000+ employees) by identifying problems, overhauling and adjusting processes to increase team and department efficiency

My Education

Take a look at my formal education

Data Analytics University of California, Berkeley | 2022
Master's degree, Mathematics and Computer Science  · (SeptemberKuban State University (KubSU) | 2004

About Me

Andrey Kotovets

Data Analyst | Business Data Analyst | Business Intelligence Developer.

Powered by

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