Summary
Overview
Work History
Skills
professional affiliation
Timeline
Generic

Mohamed Omer

US CITIZEN | Public Trust | DHS Suitability

Summary

  • A highly resourceful, reliable, and detail-oriented data analyst with a vast experience of business intelligence tools backed by knowledge of SQL, T-SQL, Power BI, Tableau, Python, Basic Data Science concepts such as Exploratory Data Analysis and Machine Learning.
  • Data scientist contractor with a focus on supporting DHS in data management and analysis solutions
  • Created data collection templates, maintained databases, and utilized analytical tools
  • Analyzed acquisition data, formulated conclusions, and produced written deliverables
  • 6 years of experience analyzing and interpreting data, creating reports and dashboards. Attended daily standup meetings to discuss the tasks at hand and weekly meetings to present the status of tasks & reports.
  • Proficient in design and development of various dashboards, reports on Power BI Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc.
  • Making use of actions and other local and global filters according to the end user requirement.
  • Extensive experience in Extract, Transfer and Load (ETL) processes using MS SQL Server Integration Services (SSIS) for Data migration and Data Warehousing projects along with good project management skills.
  • Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring parameters, DAX functions, sorting, expressions, drill down and drill through, etc.
  • Proficient in main Business Intelligence tools such as Tableau and Power BI for creating dynamic dashboards and reports for various business functions.
  • Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
  • Creating and modifying Business Intelligence analytical reports using Tableau.
  • Built complex Tableau dashboards with advanced functions to provide insightful analysis, identify growth opportunities, and maximize profits.
  • Great leadership qualities and excellent communication skills. Can work independently or within a team, self-motivated, determined, optimistic, and willing to learn new technology.
  • Ability to stay calm in stressful situations and adapt to new surroundings quickly.

Overview

6
6
years of professional experience

Work History

Data Scientist II

Systems Planning And Analysis, Inc
02.2023 - Current
  • Enhanced data-driven decision making by implementing machine learning models and algorithms.
  • Optimized business processes for increased efficiency through detailed data analysis and visualization tools.
  • Developed custom data analytics solutions, leading to improved operational performance and strategic planning.
  • Collaborated cross-functionally with stakeholders, ensuring alignment on key initiatives and project goals.
  • Cleaned transformed, and analyzed large datasets to uncover hidden trends and patterns for actionable insights.
  • Streamlined data collection methods to improve quality control measures and minimize errors in analysis results.
  • Presented complex findings in a clear, concise manner using visualizations that informed executive decision-making processes.
  • Mentored junior team members in best practices for data science methodologies, fostering a culture of continuous improvement.
  • Assisted in managing Jira dashboards to track tasks and projects with the DART team
  • Experience using ACE for cost estimating and analysis
  • Translated business requirements into data-driven solutions, providing value-added insights that directly contributed to the organization''s strategic goals.

Data Analyst

Alliance TEK Solutions
07.2020 - 02.2023
  • Support product success, marketing, and finance teams by translating data into actionable insights using Power Bi Desktop
  • Upgraded project dashboard for product success team to understand the funding trends and patterns for successful projects that resulted in increase in the number of new projects
  • Assist with ETL process by using SQL Server Integration Services (SSIS) and review the Source to Target Mapping (STTM) to ensure accurate pipelines design
  • Created customer deep dive dashboard to understand the customer behavior and buying patterns to assist marketing and product teams with customer retention and attracting new customers
  • Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPI, Filters, and Aggregations
  • Used Python for Data cleaning and Exploratory Data Analysis (EDA) to help KickStarter to understand trends and patterns of creators, backers, and funders
  • Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads
  • Supported management teams with report generation and analysis using reporting and visualization on Power BI
  • Used Common Table Expressions (CTE), constraints and complex queries to extract data from different servers
  • MS Tools such as (Excel, Microsoft Word) and google sheets in order to construct report sheets

Data Analyst

Patreon Project
03.2018 - 06.2020
  • Built and published customized interactive reports and dashboards for Real-time survey feedback data using Tableau
  • Built complex Tableau dashboards with advanced functions to provide insightful analysis, identify growth opportunities, and maximize profits
  • Incorporated advanced Tableau functionalities into dashboards including parameters to change dashboard layouts, level of detail calculations, sets, dual axis charts, and dashboard actions
  • Designed SSIS Packages to transfer data between servers, load data into database on SQL Server environment and deploy the data
  • Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server
  • Designed dashboards, reports and stories in Tableau by using sets, groups, parameters, calculated fields, data blending and more; published to Tableau Online
  • Designed dashboard for finance department to display sales and profit data to better forecast and understand the financial information
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu options and Parameters using Tableau
  • Good experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Online and setup schedule refreshes
  • Used Pandas library to clean, manipulate and analyze data
  • Assisted with data cleaning in Python by using Pandas Library in Jupiter Hub and Google Collab

Skills

  • SQL, T-SQL & Basic Python
  • Windows & MacOS
  • MySQL, SQL Server, Oracle
  • SQL Developer, SQL Server Management Studio
  • Pandas using Google Collab
  • Excel, Microsoft Word, Access, and Power Point
  • AWS RDS, Azure
  • Data Exports
  • Data Visualization
  • JIRA
  • SharePoint
  • ACE

professional affiliation

Delta Sigma Pi Professional Business Fraternity, Philanthropy Chair, Recruitment Chair, 01/2017, Present, Organized events to raise $50,000+ for the National Breast Cancer Awareness Fund (Fall 2019) and $20,000 for the Harrisonburg Fire Department (Spring 2018)

Timeline

Data Scientist II

Systems Planning And Analysis, Inc
02.2023 - Current

Data Analyst

Alliance TEK Solutions
07.2020 - 02.2023

Data Analyst

Patreon Project
03.2018 - 06.2020
Mohamed Omer