AYIDA AKALEWOLD

Business Systems Analyst, Data Analyst, Salesforce Administrator, Platform Administrator

ad0vfc@r.postjobfree.com 716-***-**** Buffalo, NY 14221 Visa Status: Permanent Resident (GC)

Professional Summary

●More than 5 years of industry experience as a business administration professional in human resource and financial management team. After graduating with a master’s degree in MIS (management information systems) looking for a business systems analysis, data analyst, and related roles with strong understanding of business system requirements, translating requirements into specifications and application design.

●Experience in proven track record in developing and executing CRM strategies, driving customer engagement, and increasing lifetime value.

●Ability to write and optimize diverse SQL queries, working knowledge of RDBMS, i.e., MySQL

●Good industry knowledge, analytical and problem-solving skills, teamwork, and ability to work independently.

●Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

●Experience working in Microsoft Offices: Microsoft PowerPoint, Microsoft Excel with possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks.

●Professional experience of developing data applications on Windows and MacOS environment.

●Practical experience with working in multiple environments with a variety of professionals at multiple levels.

Skills

Programing Languages: SQL and SAS language

Tools: Tableau Desktop, Tableau Prep-Builder, Power BI, Microsoft Office (Excel, Word, Access, PowerPoint)

Databases: MySQL, Oracle

Data Analysis: Data Modeling, Data Manipulation, Data Warehousing, Data Mining, Data Visualization

Cloud Computing: MS Azure, Salesforce

Operating Systems: Windows and Mac OS

Experience

Certificate. July - October 2023

Power BI- Power Bi Desktop and power Bi Services features, project works.

SQL- MS SQL Server features, connecting the server with different tools.

Full-time Caregiver

●Cared for ailing parent. Currently ready to return to the workforce full time. March 2023-June 2023

Data Analyst, EMPIRE TP LLC, Buffalo, NY June 2022– February 2023

●Created data models to support decision-making processes for the Senior Management.

●Developed customized reports, summarized, and presented data in visually appealing format by using MS Excel.

●Created dashboards by using Tableau, MS PowerPoint to visualize profit by year. Optimized data access and storage to improve performance of analytics systems.

●Utilized data visualization techniques to present and explain complex data sets.

●Experience working in Microsoft Excel with possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks.

GLOBAL DIGITAL MARKETER, ENAGIC USA, NEW YORK, NY May 2020 – Present

•Used social media platforms to market manufacturers’ sustainable and environmental products, resulting in the highest remote sales by 400% rate in company’s history.

Driving customer engagement and increasing lifetime value, working with a global team.

HARP Patient Health Navigator, GBUAHN, Buffalo, NY December 2017–December 2020

●Effectively managed caseload of underprivileged clients in home healthcare. Established and maintained positive, trusting, and ongoing relationships.

●Conducted health needs assessments and other required assessments and documentation while meeting with clients in their homes, physician/provider offices, and other public places.

●Used mobile devices and machines to safely access electronic health records (EHR system)

●Worked collaboratively with a team that includes care managers, health navigators, and social needs coordinators, and the clients’ providers to develop and maintain a care plan.

●Attended and participated in regularly scheduled case reviews with care team.

●Prepared presentation with PowerPoint for the higher managers and CEO.

●Worked on Epic charting system includes features such as medical templates, patient history, and referrals so that healthcare providers can deliver the best patient care.

Corporate Compliance Data Administration Intern, KALEIDA HEALTH, Buffalo, NY April 2017–December 2017

●Managed practical action plans to respond to audit discoveries and compliance violations.

●Implemented improvement initiatives and developed compliance testing program to monitor and identify gaps in new and existing practices.

●Assisted Human Resource FMLA leaves department by filing data, in process of shifting hard copy system into softcopy data storage system.

●Improved data collection by 50% using different methods by designing surveys, polls, and other instruments for Human Resource Department.

AYIDA AKALEWOLD p.2

Assistant Accountant Intern, MARLOCK FOUNDATION, Buffalo, NY November 2014–December 2015

●Performed general accounting duties, deposits, data entry and data visualization using MS Excel. Recorded financial transaction on QuickBooks. Balanced and submitted financial reports for review and approval.

Project Experience

From September 2021–December 2022

●System Analysis and Design, University at Buffalo

● Project on improving Patients management system by using a platform called Medent Mobile, which is used by many health care providers in Buffalo. We used Use Case, Activity Diagram, Domain Activity Diagram to visualize the improvements.

●The system should be capable of: Sending out notifications to select patients when an earlier appointment date is available. Handle traffic when a lot of users log into the system. Update appointment date of patients. Sending out notifications to patients, clinics, and doctors to confirm the new appointments.

●The business benefits to the health clinics: - Increase business revenue by decreasing no. of no-shows, improve patient experience, expedite the treatment process of a patient.

●The outcome: Reduce the number of emergency room visits, as it improves patient communication with the clinic, they can easily get an appointment by using the platform.

●Salesforce as Supervised Research. University at Buffalo

Created First Salesforce.org, Understanding Fundamentals of CRM, created profiles and implemented object level,

field-level and record-level security and managed roles, visibility setting. Created various reports (summary report,

matrix reports, pie charts, and dashboards and report Folders to assist managers to better utilize Salesforce. Prepared a

presentation Salesforce Training: Cloud computing

●Innovation and Technology. University at Buffalo

●Worked with an Innovation and Technology course on a water Machine called K8- Kangen that changes a tap water into an alkaline water.

Attributes Importance

Quality and Reliability: Conformance to product and service specifications over product life. Easy to

maintain, resistant to failure and adaptable.

Ease of use: The product be easy to use that consumers can learn without much trouble?

Performance: The product be smaller, faster, have greater capacity, better resolution, be more

convenient, compatible, and adaptable?

Design: The external and internal form of the product will be attractive. The product is visually,

tactically, audibly, and olfactorily attractive? The product packaging reflects contemporary trends.

Value Creation: The product is distinctive and solves essential problems consumers want to solve.

●We prepared an app (which I attached the link below) to present for our audience how the product looks, the range of the prices, different types of products available, how to go to through the payment method and the login details to buy the product.

https://marvelapp.com/prototype/ab596g1/screen/83946435

Education

University of Buffalo, The State University of New York

Master of Science, Management Information Systems (MIS) February 2023

Bryant & Stratton College, Amherst, New York

Bachelor of Business Administration, General Management December 2017

University of Stavanger, Stavanger, Norway

Certificate in Norwegian Language and Culture with Concentration in International Leadership May 2013

Addis Ababa University, Addis Ababa, Ethiopia

Bachelor of Arts, Accounting and Finance May 2010

Certification

Microsoft Azure- Fundamental

Language

Language (Level) Language (Level)

English Full Professional Proficiency

Amharic Native

Norwegian Elementary Proficiency

Tigrigna Elementary Proficiency

Personal Achievements

Award/Achievement Took online courses (self-trained myself during my maternity leave)) and

shift my career from accounting to data analyst and got back to school for my Information system

master’s degree after I worked as a data analyst.

Award/Achievement Work as a digital marketer as a side hustle based on social media and reach

so many lives, help many people to find additional means of income from home. Since 2019

Institution/Company Enagic, USA

Award/Achievement Certificate of Recognition/Board member May 2019

Institution/Company Buffalo Ethiopian Orthodox Church

Award/Achievement Interpreter

Since 2014

Institution/Company Buffalo International Institute, work as an interpreter in my free time to

assist Ethiopian or Eritrean who doesn’t understand English.

Contact this candidate