سارة ابوزيد

 Analyzing business requirements and processes
 Work with management and different business units to analyze business processes and
requirements
 Identify opportunities to improve processes and strategies
 Develop and manage BI solutions and dashboards
 Creating and maintaining documentation that includes the design, requirements and user
manuals for the organization

 Analyzing business and gathering requirements remotely
 Developing ETL Jobs via Microsoft SSIS
 Developing fancy Dashboards in power BI
 Consult any issue regarding Business Intelligence firm

 Built the Data Architecture and data flows of DWH Layers
 Identify Business Needs in each different business areas
 Define data modelling and design methodologies for the organization
for which they work
 Set standards for document naming, lifecycle and retention architecture

▪ Revamped two important Data marts for Parts and Service that reduced running time
for the packages from 17 hours to 6 hours
▪ Built tableau Dashboard that saved time and effort for business user that took 1 week to
prepare the report with just one click
▪ Built 4 big Dashboards in power BI
▪ Meet business users and gather requirements then cascade them, elaborate main
requests to one of my colleagues
▪ Prepare and help team to prepare the model design
▪ Report the status with alarms, explanations and solutions
▪ Interface between team and management
▪ Handle ad hoc inquiries
▪ Mentor people & Build and maintain team spirit
▪ Define main targets for team
▪ Analyze performance issues and develop strategy for any revamp plan
▪ First and second line of support in operational issues
▪ Find the root cause and try to fix it to keep operational environment stable
▪ Build new models that should be integrate to entire DataMart

▪ Designed for the first time ERD for the 3 biggest Data Marts in DWH that helps them for
documenting and saving Metadata also help in transforming to the new infrastructure of
DWH
▪ Manage between DWH internal teams and Demand teams
▪ Translating Business Requirements into logical and physical data models
▪ Full Documentation for production Models
▪ Study Impact analysis on database during any system migration or transformation
▪ Maintaining Metadata for Tables, jobs and reports and provide users with full impact
for any change