Adnew Berasa

• Commercial Videography: Collaborated with businesses to produce high-quality promotional videos, ensuring content aligned with branding goals and effectively communicated key messages to target audiences.
• Wedding Videography & Photography: Captured memorable moments with a cinematic approach, managing all aspects of planning, shooting, and post-production to deliver timeless keepsakes for clients.
• Music Videos: Partnered with musicians to conceptualize and produce visually compelling music videos, managing creative direction, storyboarding, and post-editing.
• Real Estate Videography: Created professional property tours with drone footage, wide-angle shots, and walkthrough videos to help real estate agents showcase homes and increase sales potential.
• Post-Production Editing: Edited videos using Adobe Premiere Pro and Adobe Audition, performing color grading, sound engineering, and visual effects to ensure professional-quality content.
• Client Collaboration: Worked closely with clients to understand their vision, provided creative input, and consistently delivered projects on time and within budget.
• Equipment Expertise: Operated professional-grade equipment, including Blackmagic cameras, lighting rigs, audio gear, and stabilizers, ensuring top-tier production quality in various environments.
• Team Management: Coordinated with assistants and contractors for larger projects, ensuring seamless production workflows and adherence to tight deadlines.
• Social Media Content Creation: Designed short-form video content optimized for platforms like Instagram, TikTok, and YouTube to increase clients' digital engagement and visibility.

• Oversaw live streaming, audio-visual operations, and podcast production for weekly church services and special events.
• Directed a team of volunteers in managing schedules, setting up equipment, and troubleshooting technical issues during events.
• Maintained and upgraded studio equipment, including cameras, microphones, lighting, and audio mixing consoles.
• Produced video content for online distribution and promotional purposes.
• Identified training needs, created a comprehensive onboarding program and conducted orientation sessions for new hires.
• Collaborated with other managers across the organization in order to identify best practices that could be implemented at all levels.
• Managed daily operations of the team including scheduling shifts, assigning tasks, tracking attendance and approving time off requests.

 Worked on claims data and extracted data from various sources.
 Worked with data investigation, discovery and mapping tools to scan every single data record
from many sources.
 Involved in requirement gathering and data analysis and Interacted with Business users to
understand the reporting requirements, analyzing BI needs for user community.
 Involved in logical and physical designs and transforming logical models into physical
implementations.
 Performed data analysis, data mapping, data validation and reconciliation.
 Metrics reporting, data mining and trends in helpdesk environment using Access
 Combined and cleaned big numbering data using lookup and different functions.
 Developed Project Plan with Project manager's assistance for the first two phases of the
Project
 Developed an Estimation model for various product & services bundled offering to optimize
and predict the gross margin
 Built sales model for various product and services bundled offering.
 Developed predictive causal model using annual failure rate and standard cost basis for the
new bundled services.
 Designed and develop analytics, machine learning models, and visualizations that drive
performance and provide insights, from prototyping to production deployment and product
recommendation and allocation planning.
 Worked with sales and Marketing team for Partner and collaborate with a cross-functional
team to frame and answer important data questions.
 Developed dashboards to help discover shopper insights utilizing Tableau

Maintain responsibility for analyzing the overall planning, organizing, directing, controlling, and delivery of all projects prioritized in alignment with the client’s expectations and business needs.
Dissecting and interpreting large data sets in support of real-world operations.
Building analytical dashboards using Tableau Desktop.
Pulling big data from the data warehouse using SQL queries.
Creating extracted data using Tableau Prep.
 Design dashboard using filters, parameters and action filters as well as produce standard monthly reports using
tableau. Connected tableau server with share-point portal and setup auto refresh feature
 Building and publishing customized interactive reports and dashboards, report scheduling using tableau server
 Participated in various meetings, reviews and user group discussion as well as communicating withstakeholders and business groups.
 Developed tableau workbooks from multiple data sources using joins and data blending.
 Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional
analysis and gives business a 360 view of what is going on.
 Extensively used SAS functions such as Proc Report, Proc Tabulate, Proc Summary, Proc Print and data Null
Reports.
 Created numerous permanent tables, Local Temporary tables and Global Temporary tables.
 Performed Detailed Data Analysis, Data Quality Analysis and Data Profiling on source data.
 Involved in creating database objects like table, views, procedures, triggers and functions using T.SQL to
provide definition structure and to maintain data efficiently.