Georgi Angelov

**** **** *** *, **. Petersburg, FL - 33710 ac6kg3@r.postjobfree.com

Education

B.S. IN INFORMATION SYSTEMS MANAGEMENT MAY 2015

UNIVERSITY OF SOUTH FLORIDA

Developed a POS application (Visual Studio/ C#)

Designed and administered databases (MySQL/ Access)

Organized and presented data with Tableau, Excel and PowerPoint

CERTIFICATIONS AND ADDITIONAL EDUCATION

Google Analytics Certification - completed

MCSE: Data Management and Analytics – in progress

DataCamp Python for Data Science – completed

Microsoft Virtual Academy SQL Database Fundamentals - completed

Skills & Abilities

SQL CODING EXPERIENCE

Basic and intermediate SQL queries and database setup with MySQL, SQL Server Management Studio (SSMS) and Azure

Creating and populating tables

Querying multiple tables

Grouping and aggregating data using subqueries, indexes and constraints

DATABASE SET UP AND ADMINISTRATION EXPERIENCE

Set up SQL Server 2017 on private server, administer with SSMS.

Backed up and practice with the WideWorldImporters and AdventureWorks practice databases in SSMS.

ADDITIONAL CODING EXPERIENCE

Python basics, lists, functions and packages including NumPy

C# with Visual Studio to create a simple POS system

Understanding of iterative SDLC processes (SCRUM, Agile)

DATA ANALYTICS EXPERIENCE

Used Google Analytics data to provide insights and recommendations leading to improvement in KPIs.

Learning to use NumPy, Pandas and other Python packages for more streamlined and advanced data refinement, computations and analytics.

BUSINESS ANALYTICS EXPERIENCE

Analyzed business needs and processes and provided KPI improvement recommendations

Worked with stakeholders and developers to define achievable project requirements

Facilitated productive communication and understanding between stakeholders and developers

Provided ad hoc analysis and reports with Excel (Sorting Data, Pivot Tables, Charts) and Tableau (Treemaps, Histograms, Gantt charts)

Work Experience

CONSULTANT APPEN FEB 2012 – PRESENT

SQL CODING EXPERIENCE AT APPEN

Retrieving and examining Amazon product tables

Outputting data using different constraints and sorting it to locate duplicates, redundancies and overlaps

Querying multiple tables and manipulating the data with AVG, SUM, COUNT, etc.

Grouping and aggregating data using subqueries, indexes and constraints, renaming columns accordingly

ADDITIONAL EXPERIENCE AT APPEN

Study and utilize digital media classification guidelines from top 10 digital tech companies.

Utilize that information in the analysis and review of digital data.

Improved the Amazon e-commerce search engine by analyzing and categorizing 1000’s of data sets to improve product to query relevance.

Used audience data derived from Google Analytics to provide recommendations for page design improvements relative to customer’s gender and age.

Used audience and behavior data points derived from Google Analytics to provide recommendations for reducing bounce rates.

Used Google Analytics content drilldown data, primarily average time on page, bounce rate and exit percentage rates to develop recommendations for improving product category and subcategory relationships.

Used Google Analytics page timings and bounce rate data to monitor and determine design improvement effects on load speed and customer retention.

Compare data points to guideline specifications and use critical thinking to designate data to most appropriate categories.

Create user stories and acceptance criteria.

Perform quality assurance work and resolve analyst disagreements.

Summarize and clarify project guidelines and requirements for other analysts.

Communicate with project management and tech support to resolve issues and drive project completion.

Improved the Microsoft Bing search engine by analyzing and categorizing websites using Microsoft approved guidelines and criteria.

Used web page analysis experience to develop traffic improvement suggestions and used Google Analytics to monitor organic search acquisition rates and determine impact of changes.

SEARCH ENGINE OPTIMIZATION AND ADVERTISEMENT EVALUATOR

LIONBRIDGE JAN 2011 – FEB 2012

Implemented Google guidelines to improve the search engine end user experience through the analysis of websites for quality and relevance.

Analyzed data sets of Google AdWords and ads to determine relevance and accuracy based on content, market language and market location.

Tested and reviewed websites for functionality, quality, relevance and authority based on guidelines provided by Google.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate