Data Entry Analyst

Melaku Mengistu Haile

********@*****.***

Years of Relevant Experience: 5 Years

Security Clearance: level (Status) – N/A

Current Title: Research Analyst

PMA: DEOMI

Professional Summary

Dedicated and results-oriented Data Analyst with over 4 years of industrial experience in transforming complex datasets into actionable insights. Proficient in programming languages such as Python, R, and SQL, with expertise in leveraging advanced libraries like Pandas, NumPy, Matplotlib, and Seaborn for efficient data manipulation and analysis. Skilled in creating compelling visualizations and dashboards using Tableau, Power BI, and Excel to support data-driven decision-making. Experienced in managing databases like MySQL and SQL Server, and adept at utilizing cloud technologies such as AWS and Azure to design scalable data solutions.

Education, Awards, Training and Certificates

Diploma, Languages, St. Mary’s University College, 2009.

Bachelor’s Degree, Computer Sciences, Bahir Dar University, 2011.

Certificate, Data Analytics, THINKFUL a Chegg service, 2021.

Professional Experience

09/24 – Present: DEOMI – OY2 TO7 Research Analyst, JHT Inc/Precise Systems, Remote

Analyzing and interpreting large data set from EEO, EOAC, and EOARCC courses to extract actionable insights and identify trends in students’ performance, demographics, and satisfaction.

Developing interactive dashboards in Tableau to visualize average rates, counts, and demographic distributions for leadership and stakeholders.

Cleaning, transforming and mapping raw survey data, ensuring accuracy and consistency across multiple datasets to support reliable reporting.

Conducting statistical analyses using tools such as SPSS and Excel to generate reports on participant satisfaction, relevant lessons, and open-ended feedbacks.

Coordinating with team members to validate data models and streamline reporting processes in alignment with project timelines.

09/22 – 09/24: Data Analyst, SilverSpace Technology, Remote

BNY, Financial Data Analysis

Developed custom Python scripts to extract data from various sources, including PostgreSQL databases and API endpoints, consolidating disparate data sources into a unified data model.

Crafted custom R scripts and functions to automate repetitive data processing tasks, improving the efficiency and consistency of data workflows.

Created dynamic Tableau Dashboards with drill-down, filtering, and slicer functionalities, allowing users to interactively explore and analyze data at different levels of granularity and dimensions.

Automated repetitive data processing tasks in Excel using macros and VBA (Visual Basic for Applications) programming, improving the efficiency and reliability of reporting workflows.

Wrote complex SQL queries to extract, filter, and aggregate data from the MySQL databases, leveraging advanced SQL features such as stored procedures, triggers, and user-defined functions.

Applied Agile techniques, including user stories, acceptance criteria, and story points, to clearly define, prioritize, and estimate data-related tasks, enabling the team to respond quickly to changing business needs.

03/22 – 08/22: Data Analyst, Tekwissen, Remote

Amazon, AMZL Power Project

Developed Smartsheet Dashboards and annual plans to measure KPIs, Work breakdown structures, RASCI Charts, Various process flows, and databases, establishing a program foundation and tracking health in an aggressive, schedule-focused program lacking existing measurement means.

Utilized a last-mile business intelligent data system to construct analytical models informing the safety program strategy and generating custom deep-dive analyses beyond regular reports.

Supported efforts to rectify data quality issues by identifying root causes and presenting potential solutions.

Presented daily and weekly reports by analyzing milestones on project phases' improvement.

Analyzed data, identified business needs, and defined requirements for the largest nationwide distributed power and infrastructure expansion for AMZL, all for the Climate Pledge. Created dashboards, processes, metrics, and operating plans to drive an annual $100M+ capital program. Directed strategy for annual planning and change management across multiple organizations

Built and published customized interactive reports and dashboards, and scheduled reports using Power BI.

02/19 – 02/22: Data Analyst, Silverspace, Remote

Pay Chex, Financial Data Analysis

Designed and optimized SQL-based data models and relational schemas to support scalable data pipelines and real-time analysis.

Wrote advanced SQL queries using joins, subqueries, CTEs, and window functions to extract and transform large-scale market and operational datasets.

Ensured data integrity by performing thorough validation, anomaly detection, and consistency checks across multiple data sources.

Collaborated with cross-functional teams to define data requirements, support data product development, and maintain high data quality standards.

Applied strong attention to detail to identify discrepancies in structured datasets and proposed actionable resolutions.

Contributed to the development of data products by analyzing real-time or near real- time data for trend detection and anomaly monitoring.

Experience working with hybrid data environments using on-premise and cloud-based platforms (e.g., Azure, AWS).

Familiar with best practices in data security and compliance within regulated industries, including finance and government.

Leveraged Python’s robust data manipulation and analysis capabilities to automate and streamline various data-related tasks, including data extraction, cleaning, transformation, and feature engineering.

Designed and implemented custom PostgreSQL database schemas to support the company’s data infrastructure, ensuring data integrity, scalability, and performance.

Contact this candidate