Data Analyst/Business Analyst
--
UGWUANYI STANLEY
Skills
SQL (SQL Server, MySQL).
Tableau
Excel (Vlookup, Conditional formatting, Pivot tables).
Microsoft PowerBi.
Projects
MARKET CONDITION ANALYSIS – Personal Projects
March - April 2023
Identified, analyzed and executed new and potential products, services, markets and advertising opportunities.
Collected and analyzed data on established and prospective customers, competitors and marketing channels and
sources
Prepared reports that interpreted consumer behavior, market opportunities and conditions, marketing results and
trends and investment levels.
DATA ANALYSIS – Personal Projects
May 2023
Utilized Excel basic and advanced features to track and analyze data
Optimized data collection procedures and generated reports on weekly, monthly and quarterly basis.
Used advanced Excel to create pivot tables and pivot reporting as well as use Vlookup function.
Proposed solutions to improve the systems efficiencies and reduce total expenses.
CLIENT SALES ANALYSIS – Personal Projects
July - August 2023
Engaged SQL to extract data from 8 different related table from customers’ database and combining them using JOIN
and VIEW
Transformed the data using Aggregate and filtering functions to improve reporting process
Loaded and visualized data using Python to identify key business intelligence that can improve sales performance.
Work Experience
BUSINESS ANALYST – Digibrid Inc. – Romford, UK
Jan - August 2022
Identified stakeholders expectations through stakeholders analysis
Curated the requirement analysis using Gap Analysis
Mapped out and prioritize High – Level Requirement (To-Be)
Engaged in users acceptance testing
Education
BACHELORS OF ENGINEERING – University of Nigeria Nsukka
Electrical Engineering
March 2023
