Data Analyst Python

Owusu Asubonteng Osei

+1-817-***-**** linkedin.com/in/Osei-Owusu ************@*****.***

SKILLS:

● Technical:Advance Microsoft Suite : Excel, PowerPoint, Word, Financial analysis, Tableau Data Visualization, Power BI, Python, SQL

● Soft Skills: Collaborative skills, Attention to details, Advanced written and Oral English PROFESSIONAL EXPERIENCE:

Data Analyst,Digital Creative Institute Dallas, Texas Dec 2019 – Present

● Evaluated App store data and presented finding using PYTHON

● Clean data using python.

● Format date time functions for date time analysis with PYTHON scripts

● Analyzed text data and presented the findings using aggregation

● Reviewed data and classified the tables/measures functions by using multiple SQL queries, views and procedures

● Developed advanced SQL queries with multi-table joins, group functions, subqueries and set operations user defined functions (UDFs) for data analysis

● Solved applicable business problems writing SQL queries

● Created and managed a data science website

● Managed sections of data science projects with a minimum team of 5

● Project management; assign ETL steps among team members

● Created a complex dashboard using parameters, sets, groups, and calculations in worksheets and customization using filters and actions.

● Involved in reviewing business requirements and analyzing data sources from Flat file, Excel, SQL Server for design, development and analysis projects within Tableau Desktop.

● Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build TABLEAU Dashboards and managing the delivery

● Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

● Ensured the user security for the views using User filters and shared with business users.

● Established backup policies, wrote scripts, and implemented schedule to comply with availability needs of all instances with the use of CentOS 7 OS

● Implemented monitoring and wrote monitoring scripts specific to each instance

● Created and maintained shell scripts to simplify administrative work Live Chat Sales Specialist, E Tech Company ltd., Dallas Texas Sept 2019 – Dec 2019

● Answer customer inquiries about account status

● Assisted Customers with placing orders using OMNI software

● Use multiple computer software applications to locate information for consistent response to benefit inquiries.

● Analyzed budget friendly plans for customers

● Designed sales presentations and implemented steps to streamline the closing process

● Established promotional packages that led to an increase of sales

● Used questioning and attention to detail skills that supported effective online communication

● Maintain a call center database by entering information PROJECTS:

● Cleaned and analyzed mobile apps data to find profitable apps. click here to view

● Analyzed text data from a website to accurately find the best time to post content. click here to view

● Solved business problems applicable to writing queries click here to view EDUCATION:

● Digital Creative Institute, Dallas, Texas April, 2020 Data Analyst Apprentice

● University of Professional Studies, Accra, Ghana June, 2019 Bachelor of Business Administration

CERTIFICATIONS:

● Python for Data Science: Fundamentals

● Python for Data Science: Intermediate

● Oracle Database 12C: Basic SQL

● Oracle Database 12C: Advanced SQL

● Oracle Database 12C: Security

● Linux Mastery: Master the linux command line

● Tableau: Data Visualization with Tableau Specialization (Ongoing)

Contact this candidate