SOLIANA OGBAMICHAEL

DATA ANALYST

ad3lxi@r.postjobfree.com 714-***-**** Linkedin/GitHub Anaheim, CA

Results - driven data analyst with a diverse background in customer service and cashier role. Analyst with a background in customer interaction and foundation in understanding customer behavior and needs. SKILLS

● Analytics(Descriptive analytics, Data quality measures,Data transformation and integration, Data wrangling and mergin)

● Excel(Data cleaning, Data grouping and summarizing,Vlookup, Conditional formatting, Pivot table)

● SQL(Data base query using SQL, PostgreSQL, SQL server,Oracle)

● Python(Pandas, NumPy, SciPy, MatplotLib)

● Tableau(Data visualization, Presentation)

PROJECTS

INFLUENZA SEASON STAFFING REQUIREMENTView full project

● Determine the staffing needs for a national medical agency during the influenza season.

● Analyze CDC data sets to find limitations and spot trends.

● Created Tableau dashboard to distribute to stakeholders.

● Applications : Excel, Tableau, Word

INSTACART CUSTOMER ANALYSIS View full project

● Analyzed customer trends across different regions, age, income and other demographic factors using open-source data.

● Analyzed customer trends across different regions, age, income and other demographic factors using open-source data.

● Application : Python, Pandas, Matplotlib.

ROCKBUSTER STEALTH View full project

● International business analysis of online video rental services using SQL.

● Extracted an entity relationship diagram ( ERD) and design a data dictionary.

● Application : SQL, Excel, PowerPoint, Tableau.

EDUCATION

CARIER FOUNDRY 2023 UNDERGRADUATE 2018 - Present

Data analyst certification full time student Cypress community college (Cypress, CA) EXPERIENCE

BUSINESS ANALYST OESON( remote internship)

September 2023 - present

Internet service provider (ISP)(2009 - 2013) Asmara City, Eritrea Workingasacashierandcustomerservicegivesmeavaluableexperienceinvariousaspects.ithelpsmehowto engagewithcustomersandhandlingtheirinquiries.Therolealsohelpsmetofosterteamworkandcollaboration with colleagues.

Eritrean Ministry of Defense (2011 - 2013)

Served as the office member in the technician department in the office of Eritrean Ministry of defense Asmara City, Eritrea

Contact this candidate