Anduamlak Yitayeh Portfolio

About

Data Analyst/Data Scientist

I'm so passinated in the field of data analytics/Science with having strong information technology professional with MSc degree focused in Computer Science from Bahir Dar University.

Birthday: June 6 1993
Website: www.anduamlaky.github.io
Phone: +251 911 859 866
City: Addis Ababa, Ethiopia

Age: 30
Degree: MSc in Computer Science
Email: ndy.andupa@gmail.com
Freelance: Available

I'm experienced Senior data analyst ,Data Enginner and data scientist with demonstrated history of working in telecommunication industry.Skilled in SQL/T-SQL/PL/SQL,ADF,SSIS, Web Scraping ,Exploratory data analysis, transformation,Visualization Using Power BI, DBT,Big Data, Data Modeling,Python,Pyspark,Snowflake, Databricks, Azure Synapse,Wireless & Communication & Research.

Skills

Skills I have:

Deep knowledge of SQL/T-SQL/PL/SQL 100%

Python 90%

Pyspark 90%

Big data 90%

DBT90%

ADF90%

Azure Synapse90%

Data Modeling100%

Excel 100%

Exploratory data analytics(EDA) 100%

Data cleaning and transformation 100%

Web scraping using Python Script 60%

Data Visualization using Power BI 90%

DAX 90%

VBA code in Excel80%

Macros in Excel90%

Power Query 100%

Snowflake90%

ETL Developer using SSIS 90%

Resume

A showcase for my professional experiances and acadamic achivements:

Sumary

Anduamlak Yitayeh

Experienced Data Analyst with over 8 years of experience in Telecom Industry. Excellent reputation for resolving problems and improving customer satisfaction.

WPX9 324 Addis Ababa Street,1000
(+251)911-859866
ndy.andupa@gmail.com

Education

MSC DEGREE IN COMPUTER SCIENCE

2019 - 2021

Bahir Dar University,Ethiopia

Computer Science Major Advanced courses (Distributed Computing.

Cryptograph and Computer Security, Advanced Algorithm analysis).

Artificial Intelligence(AI) Courses (Machine Learning and Natural Language Processing(NLP)).

Advance Networking Courses (Wireless Networking and Mobile Communication and Advanced Computer Network).

Software Project Management Course.

Supportive Research Courses (Research Methodologies and Scientific writing, and Graduate Seminar).

Final Thesis: Analysis of Grey-hole attack on the performance and Energy Consumption of TCP Variants.

BSC IN COMPUTER SCIENCE

2012 - 2015

Hawassa University,Ethiopia

Computer Science major Programming Courses (C++, Python, Object-oriented Programming, Java, HTML and PHP).

Computer Science major Database Course (Fundamental of Database System ((MYSQL) and Advanced Database (ORACLE)).

Computer Science major Courses such as Basics of Networking, Data structure and algorithms, operating system, Software Engineering, Information Retrieval, Introduction to Compute and its application, Compiler Design, analysis of algorithms and Data Mining courses.

Other Supportive course such as Research Method and Methodologies, Basics of Electronics, Digital Electronics, Introduction to Statistics, Applied Mathematics, Numerical Analysis, Entrepreneurship, College Writing Skills, Communication Skills, Introduction to Civics and Ethics Studies.

Final Project: Online Job and Recruitment System (using PHP, HTML, JavaScript, JQuery, MYSQL).

Professional Experience

Freelancer:Senior Data Analyst

2021 - Present

Remote

Experienced in Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows involved in creating functional and technical specification documents after gathering requirements from business.
Excellent in exploratory data analytics using Pandas, Numpy, Matplotlib, Seaborn, Sqldf, Plotly and Pyspark modules for translating data into insights using Python.
Experiences in working with version control systems like Git, Bitbucket and Azure Devops.
Experience in working with large volume of data using Pyspark module of python.
Developed complex T-SQL , PL/SQL and PL/pgSQL Queries and SQL Scripts that employ CTEs, Pivot Clause, Window Functions, Subquery (simple as well as correlated) for efficient data load based on complex business rules.
Performed Power BI Desktop Data modeling using start and snowflake schema, which cleans, transforms, mash up Data from multiple sources.
Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
Developed visual reports, dashboards, and KPI scorecards using Power BI desktop.
Able to implement row-level security on data and understand application security layer models in Power BI.
Hands on experience in utilizing DAX functions, which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
Proficient in making DAX queries in Power BI desktop.
Adopted, developed, publishing, and scheduling Power BI reports as per the business requirements.
Developed SSIS packages that employed various Transformation such as Lookup Transformations, Merge Joins, and Derived Columns.
Involved in automating SSIS Packages using SQL Server Agent Jobs.
Configured various event driven e-mail notification process in SSIS packages.
Created audit database to handle SSIS error output and validate data.
Configured report server and report manager for SSRS report deployment and management.

Fraud Analyst

2021 - Present

Ethiotelecom, Addis Ababa,Ethiopia

Detecting GSM, Mobile Money and other frauds by running and automating data queries.
Proactively identify Mobile Money Frauds and design dashboards using data analytics tools to continuously monitor it.
Identify international spam fraud patterns through monitoring of high-risk Countries.
Responsible for creation of alert, patterns, rating plans and configurable parameters within FMS (Fraud Management Systems)
Contribute to the creation of fraud rules by providing analytical data to support decisions.
Report risk information and findings to the immediate supervisor in a timely manner.
To analyze telecoms fraud cases as presented by fraud management system (FMS).
Define and document the user requirements for fraud management system.
Responsible for user acceptance testing (UAT), preparation of security requirements on any upcoming systems, changes, upgrades on FMS and other systems

CUSTOMER PROFILE MANAGEMENT

2019 - 2021

Ethiotelecom, Addis Ababa,Ethiopia

Monitoring and detecting subscription fraud before we approving or rejecting one’s Mobile subscriber.
Solving different e-CAF (electronic customer acquisition form) system errors faced while subscribing, reconnecting and recycling of their SIM card using the database tool ORACLE 11g.
Proposing different approaches for cleaning up customer profile for having data qualities.
Leading Standard Quality Circle Meeting (SQC) which is focused on identifying frequently faced errors and finding solutions to it and give trainings to respective team.

CONTACT CENTER ADVISOR

2016 - 2019

Ethiotelecom, Addis Ababa,Ethiopia

Handling and answering all Ethiotelecom customer call inquiries using Internet Protocol Contact Center(IPCC) system and CRM
Working as Standard Quality Circle (SQC) leader for managing the team.
Reporting customer inquiries to the respective department.