نبذة عني
Business Intelligence Engineer with 5 years of experience possesing strong analytical, programming and collaboration skills with a passion for utilizing data to solve complex problems and drive business growth. Strong cr…
Business Intelligence Engineer with 5 years of experience possesing strong analytical, programming and collaboration skills with a passion for utilizing data to solve complex problems and drive business growth. Strong critical thinking skills, able to analyze data, identify patterns, and extract actionable insights and information from multiple sources.
الخبرة
Business Intelligence Analyst
• Worked with business users to determine business requirements, priorities,
define key performance indicators, and develop Business Intelligence solutions
and Data Warehouse strategies
• Generated, wrote and ran SQL script to implement the DB changes including
table update, addition or update of indexes, creation of views and store
procedures.
• Extracted data using Yellowfin ETL Transformation from Oracle, SharePoint,
Google Analytics, XML and flat files, perform transformations and populate the
data warehouse for reporting
• Created SharePoint dashboards with Dashboard Designer and Performance
Point Services.
• Developed and implemented tactical and strategic data warehousing solutions
including corporate Data Warehouse.
Business Intelligence Engineer
Worked with business users to determine business requirements, priorities, define key performance indicators, and develop Business Intelligence solutions and Data Warehouse strategies
Generated, wrote and ran SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures
Extracted data using Yellowfin ETL Transformation from Oracle, SharePoint, Google Analytics, XML and flat files, perform transformations and populate the data warehouse for reporting
Created SharePoint dashboards with Dashboard Designer and Performance Point Services
Developed and implemented tactical and strategic data warehousing solutions including corporate Data Warehouse
Business Intelligence Developer
Developed a descriptive analysis dashboard in Power BI to provide information on incident ticket status for the IT team
The all-in-one live tracking report has saved the IT department from having to perform several checks every hour
Designed and implement the data loading ETL and publishing processes within the DW/BI environment
Created forty various reports using SSRS from OLAP cubes and publish and secured with SharePoint Server
Created MDX queries according to business requirements
Maintain data flow documentation and perform object-oriented mapping using BI tools
Business Intelligence Developer
Used various transformations such as an Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner to design ETL mappings to ensure optimized queries in ETL process
Involved in creation and execution of test plan, test scenarios and test cases - integration testing, negative testing and UAT
Developed and designed various statistical reports and dynamic dashboards to highlight data analysis trends and various analytical KPIs as per business requirements
Created various events like Broadcasting reports and emails, FTP Schedulers, Timeline and Decision-making events in BI
Deployed and supported the Reports, Dashboards and ETL Transformations through various phases of Software Development Lifecycle and manage product delivery by agile methodology
Participated in meetings with management,users for open and pending issues,involved in reviewing/analyzing business requirement documents