Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Yasser Khadr

Principal Business Intelligence Developer

Home Experiences Education Skills
Download my PDF resume
Yasser Khadr
41 years old
Farmington (06032) United States (Connecticut)
Contact me
Professional Status
Employed
Open to opportunities
About Me
Extensive experience in developing business intelligence solutions, data warehouses and reports using different set of tools
Resume created on DoYouBuzz
Experiences
  • Evaluate end client technical systems to determine the optimal approach for obtaining data from diverse source platforms and integrating the data into a business intelligence system
  • Develop customized data marts, design ETL packages, and integrate them between multiple data source systems
  • Provide specialized technical support and troubleshooting, develop analytical and ad-hoc reporting, and provide management with Key Performance Indicators and Dashboards
  • Provide estimates of effort and time of project implementation in accordance with internally developed processes and procedures and provide expert advice to guide proposals and presale activities with existing clients
  • Conduct specialized analyses by engaging with clients and internal teams to gather requirements
  • Develop and maintain internal requirements specification documentation, technical deployment and implementation guides, and process mapping for the specialized business intelligence, data warehousing, data reporting, and K2 business applications
  • Serve as the subject matter expert in business intelligence and data warehousing solutions for clients based in North America within the U.S. team
  • Serve as the subject matter expert in building, maintaining and upgrading HR related systems
  • Determine BI design strategies and methods for developed modules and components
  • Determine and find solutions for the key design issues of BI applications, for instance; distribution of components, error and exception handling and fault tolerance, interaction and presentation, and data persistence
  • Understand and verify the functional requirements of BI projects
  • Determine security and performance requirements of BI systems
  • Provide guidance/mentorship on programming practices and techniques to individuals and cross-functional teams
  • Support BI development team members and address projects technical challenges
  • Review code written by BI development team members
  • Ensure applications design and construction artifacts are stored correctly in source control system
  • Provide business and technical consultation on BI projects
  • Provide support on BI applications deployment and configuration on client environments
  • Responsible for BI engineering activities like coding using ETL, analysis & reporting tools, unit testing, integration with other modules, root cause analysis, debugging code, bug fixing, and process measurements
  • Responsible for preparing and deploying BI internal builds as per procedure
  • Prepare BI solutions packages for shipping to clients following process
  • Troubleshoot BI applications production problems
  • Determine the optimal approach for obtaining data from diverse source system platforms (DB2, Oracle, TXT, Excel …etc.) and moving it to the Data Warehouse.
  • Design ETL packages (IBM Datastage 8.7)
  • Build OLAP cubes, MDX queries (SSAS 2008 R2)
  • Develop analytical and ad-hoc reports (OBIEE11g)
  • Writing relational and multidimensional database queries
  • Creating and deploying reports
  • Debugging, monitoring and troubleshooting BI solutions
  • Designing and planning BI solutions
  • Responsible for aggregating data from multiple sources in an efficient data warehouse and designing enterprise-level solutions for very large multidimensional databases.
  • Build Data Marts (MS SQL Server)
  • Design ETL packages to Integrate between multiple source systems: DB2 on AS400, Axapta, CODA, eCODA, MSSQL Server, Excel …etc.
  • Build OLAP cubes, MDX queries
  • Develop analytical and ad-hoc reports
  • Provide the top management with different KPIs and Dashboards (ProClarity, Performance Point, …)
Certifications

Qlik Sense Data Architect

November 2020
(View certification)

Azure Data Engineer Associate

October 2023
(View certification)
Skills

Business Intelligence

  • MS SSIS
    Expert
  • MS SSAS
    Good
  • MS SSRS
    Expert
  • MS Power BI
    Good
  • Azure Data Factory
    Intermediate
  • Qlik Sense
    Advanced
  • QlikView
    Good
  • IBM Datastage
    Good
  • Oracle OBIEE
    Notions

Programming Languages

  • T-SQL
    Expert
  • PL/SQL
    Good
  • Python
    Intermediate
  • PowerShell
    Intermediate
  • VBScript
    Intermediate
  • C#
    Intermediate

DevOps

  • Azure DevOps
    Good

Workflow

  • K2
    Intermediate
Languages
  • English
    Advanced
  • Arabic
    Expert
Education

Bachelor's degree, Electrical Power and Machines Engineering

Helwan University Cairo

September 2002 to September 2009
Resume created on DoYouBuzz