Mehari Lemlem

Database Developer/Administrator, Fraud Analyst, Telecom Billing Specialist

Phoenix, AZ 85027

adoq3b@r.postjobfree.com

480-***-****

Skilled, highly-qualified and solution-driven Database Developer /Administrator with 11+ years of extensive experience of modeling, designing, coding, testing, and supporting applications and database solutions. In-depth experience with all aspects of Database Systems. Expert in RDBMS, SQL, PL/SQL, T-SQL, Microsoft office, ETL, Fraud Detection Algorithms, Billing systems, Big data analytics, Data integration, Data Processing and Reporting. Proficient in an assortment of technologies, including Oracle 11g and 12c, MySQL, Postgres, MongoDB, SQL Servers, GitHub, Tableau, IBM SPSS, Compass, Windows, Linux, Unix, C, C++, Python, Java, Scala, XML, JSON. Visa Status: Green Card holder

Work Experience

Database Consultant (Part-time)

Malam Engineering PLC - Addis Ababa, Ethiopia

June 2017 to July 2021

● Provide trends and analysis to support decisions regarding resource allocation management of data center environments.

● Advise on and implement database backup and recovery strategies.

● Conduct training to junior staff on database design, development and maintenance activities.

● Assist in design, development and implementation of database systems.

● Advise and assist operations staff with technical issues concerning installation, security, performance and other configurations.

Database Developer/Administrator (Billing, Fraud Analysis) Ethio telecom - Addis Ababa, Ethiopia

January 2011 to June 2019

● Collaborated with developers, project managers, quality assurance and business analysts in conceptualizing and developing new database systems and enhancements.

● Developed mapping specifications, Source to target mappings and ETL workflows to allow automatic updates to data mart to extend application life cycle.

● Supported and advised Operational teams; acting as third line support and responding to incidents where necessary.

● Standardized job tasks and trained junior team members on industry best practices and standards.

● Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.

● Participated in implementing and testing complex systems such as Mediation, Billing, Revenue assurance and Fraud management systems.

● Developed complex and well-optimized queries for report and monitoring dashboards.

● Played a vital role on Telecom Fraud Management and Revenue Assurance systems deployment; Planning Detection scenarios, Developing Detection Algorithms, Testing, Operation, and System Monitoring by leading and coordinating the team.

● Played Key role in integrating the Fraud Management System (FMS) with other data source systems such as CBS, CRM, Core-Network, PRM, BI, IPCC, ERP, eTopUp, UBS, RA, Mediation, DCH, Data warehouse, Data mart.

IT Expert

Ethio telecom - Addis Ababa, Ethiopia

December 2009 to December 2011

● Played active roles on major Billing System implementation tests and deployment.

● Conducted analysis on project requirements and formulated plans based on customer specifications including training programs.

● Implemented database integration and data migration during New Generation Networks deployment projects.

● Experienced in Customer Service Representative (CSR),Service provisioning, Reporting systems, and Incident management.

● Advanced understanding of bill collection, Dunning and Payment. Education

Master of Science in Computer Science

Arizona State University - Tempe, AZ

August 2019 to July 2021

B.Sc in Electrical Engineering

Mekelle Institute of Technology (Mekelle

University)

Mekelle Institute of Technology - Mekele, Ethiopia September 2005 to July 2009

Skills

● SQL

● Oracle

● Agile (Scrum)

● Linux

● MySQL

● Microsoft SQL Servers

● XML

● C/C++

● AWS

● SDLC

● GitHub

● SPSS

● Scripting Language

(Bash, PowerShell)

● HTML5

● Cloud Computing

● Jira

● APIs

● Java

● Waterfall

● UNIX

● Unit testing

● Requirements gathering

● ETL

● Telecommunication

● Apache Hadoop

● Astah (UML)

● Scripting

● PL/SQL

● Docker

● JSON

● T-SQL

● MongoDB

● PostgreSQL

● Python

● UI

● Data warehouse

● Talend

● CRM

● API

Links

https://www.linkedin.com/in/mehari-l-546b60b7/

Awards

Standard Quality Circle team leader of the year

April 2016

As a team leader I inspired and led my team members to:

● conduct skill gaps assessment, and develop PDP that improved professional competency of the team members.

● develop a standard operational procedure (SOP) that improved the previous operational performance by 30%.

● adapt kaizen principles which resulted in decreasing power consumption by 15%, improving transparency and customer-centric service delivery.

● create communication channels with stakeholder departments to improve operational efficiency and service delivery time by 50%.

In addition, I myself trained my team members SQL, PL/SQL and SPSS which saved the expense of the company and highly improved the overall performance of the team. Outstanding System Tester

September 2017

During migration of my company’s billing system, I worked with vendor companies in testing complicated systems such as:

● Mediation : a system that collects all types of data from different network elements, parse and preprocesses the data using different algorithms, and sends the preprocessed data to different billing systems.

● Partner Relationship Management system (Roaming & Interconnection): A system that processes roaming and international data and does settlement with international partner telecom companies.

● Fraud Management System (FMS): It is a system that collects different data formats from all other systems, transforms and loads the data (ETL), processes and detects fraudulent activities.

I finished the project three weeks ahead of the due date. Project

● Username and Password Generator SOC Application: Developed SOAP and REST web services, as well as website client application that will use them using Visual Studio 2019 IDE.

● BMI Calculator - MVC Architecture Mobile App: Developed MVC architecture-based BMI Calculator Mobile Application, that uses Web API calls and processes JSON data, using XCode 10.

● Directory Management System: Object-Oriented design Java code implementation based on Astah (UML) class diagram.

Trainings/Workshops/Certifications

● Oracle Database 11g: RAC Administration - (Credential ID 7096755)

● Oracle Database 11g: Data Guard Administration - (Credential ID 7096749)

● Oracle Database 11g: Security - (Credential ID 7096754)

● Oracle Database 11g: Administration II - (Credential ID 7096742)

● Oracle Database 11g: Grid Control Essentials - (Credential ID 7096746)

● IBM: Storage Area Networking (SAN) - (Credential ID 486-616)

● IBM: SAN Volume Controller (SVC) Planning and Implementation - (Credential ID 486-599)

● IBM: Introduction to Storage Networking - (Credential ID 486-632)

● GRAPA: Revenue Assurance Foundations (RAF)

● Machine Learning with Big Data - (Credential ID VF4ARFYNF3L4)

● Big Data Modeling and Management Systems - (Credential ID 67SM2K8C2F78)

● Introduction to Big Data - (Credential ID 37M7UEYATJVS)

● BICS: Open Connectivity Roaming Hub - Brussels, Belgium.

● ZTE University: Fraud Management System (FMS) workshop - Shenzhen, China.

Contact this candidate