Power BI Developer
Johnson Controls Arabia
مجموع سنوات الخبرة :57 years, 10 أشهر
• Achieving compliance between department managers, sales team, and operations team to consolidate their requirements and understand their needs for more info
• Maintaining SQL Server Job that Extracts, transforms, and loads (ETL) data from multiple sources into main data warehouse
• Managing data from many sources like Excel sheets in SharePoint servers, and SQL Server Queries Maintaining, and modifying existing Power BI reports and their Data Models using complex calculations, measures, and DAX expressions to better analyze input data
• Creating Power BI dashboards that would give business insights to management about their projects schedule, timeline, actual cost, forecasted cost, resources, risks met etc.
• Using Row Level Security to provide correct info to right people
• Researching and staying up to date with Power BI and data visualization techniques
• Attending regular meetings with PMs to modify Power Bi reports to better reflect their concerns and provide any new needed info.
Collect weekly actual status from PMs
Track unitization of testing offshore resources according to release plan
Collect test status report on system level
Create/update general test status report
Update the release overview
• Extracting, Modifying, and Analyzing weekly resource demand reports existing in Project Portfolio Management (PPM) tool
• This task was done manually first then automated using Power BI to Extract data through Transformation and Query Editor from many excel sheets and SharePoint files
• Providing decision support, and systematic approach to management to ensure organization is managing its internal strategic projects
• Working end-to-end from Initiating phase to Project Closure phase,
.
.
ensuring that all stakeholders have aligned Project Communication Demand Management functionality like: Employee Profile Provides limited data regarding each resource for purposes of matching resources to work assignments
• Data includes employee name, location, email address, start date as well as skills (if employee has taken required actions to have their profile updated)
• Only Resourcing Executives can view this data
• Demand Forecasting Defines client workload in terms of time and skills required
• Project Managers, Approvers and Resourcing Executives can view demand forecast information
• Updating excel sheet macros to meet new needs
• Generate& Analyze monthly POST MILESTONE PROJECT REVIEW (PMPR) report, which is an initiated process after project is closed
• Generate & analyze weekly Vodafone Project Repository (VFPR) reports
• Generate & Analyze Weekly Timesheet Reports Track & report discrepancies between actual timesheet and demand extract
• Create and renew Enterprise Management User Accounts
• Updating excel sheet macros to meet new demands
• Create weekly timesheet reports.
• As part of digital transformation program, Im Investigating digital tools for Automation & Analytics like MS Power BI, MS Teams, JIRA, Excel macros Using Power BI in Automation and development for more illustrative management reports using Power BI Desktop application. in order to visualize data and share insights with PMs.
Assist PMs in creating demand in the Portfolio and Project Management @ Enterprise Services (PPMC@ES) tool, which is a single consistent tool across regions and segments to capture, approve and manage labor demand requests.
Track projects missing info on PPMC with each PM on daily basis
Assist PMs in updating their Project missing info on PPMC
Create weekly Yotta (self-service reporting tool that provides LDSM reporting) report that captures Labor Demand and Supply Management (LDSM) process weekly demand.
Send weekly report to L2 management
• Evaluating Vodafone Money Transfer (VMT) Release 8 Application for performance tuning
• Application previous releases were handled by Sagentia, a British software house which developed applications for Vodafone and supported it in several markets like Kenya, Tanzania and India
• Due to increasing number of users, application started showing performance issues which lead to EDS handing next release 9
• Average Number of users in Kenya and Tanzania is 5 million users
• Average starting number of customers in India is expected to reach 30 million
• Team Management is distributed between EDS UK, and Egypt Solution Centre. Training was conducted in Sagentia in EDS UK as well for two months
• Communication was carried out through international conference calls, NetMeeting and emails.
• Developing web site for HP Insight Dynamics software package which
.
.
provides core automation of data center infrastructure Web site provides HP customers with instructions and examples of how to integrate HP Insight Dynamics into their business and IT operations processes.
• E-commerce web site was developed for big department store client in Sweden, called COOP. Web site was designed using Abstract Factory Design Pattern, in which interfaces are used to create families of related or dependent objects without specifying their concrete classes. One example of this pattern is within Data Access Layer tier, which has projects for IDAL, DAL Factory, Oracle DAL, and SQL Server DAL. Abstract factories are created for caching, inventory and orders data access, messaging, and profile data access. In addition, client requested web service that contains most of functionalities of products search feature to be used in their own existing asp site.
Understanding Requirements
Discussing Design
Developing a web site for HP Insight Dynamics software package which provides core automation of data center infrastructure. The web site is an educational site that provides HP customers with instructions and examples of how to integrate the HP Insight Dynamics into their business and IT operations processes
• Production support to Treasury Portal system of ABN Amro Bank
• Project handles major trades that occur every few seconds at ABN Amro form branches all over the world
• Project is to be migrated to Egyptian solution center (EgSC) from USA, Chicago IL solution center and a team of 7 were formed to receive training. I was one of five people to be chosen to attend training there.
• Using Microsoft Solutions .NET Framework (MSF), Microsoft SQL Server database Engine, and SourceOffSite version control, in developing and supporting Service Excellence Best Shore Migration project to Egyptian Solution Centre (EgSC) Service Excellence Experience system ensures that quality of client service is known at all times and that EDS service performance is at top of industry Through this system, EDS is capable of predicting every curve within its client relationships, and facilitates open, active and trusting relationship with EDS clients Clients can provide real-time performance feedback using EDS Client Survey, online survey tool. Add enhancements to application and develop new modules as per client requirements.
Evaluating the Vodafone Money Transfer (VMT) Release 8 Application for performance tuning. The application previous releases were handled by Sagentia, a British software house which developed the application for Vodafone and supported it in several markets like Kenya, Tanzania and India. Due to the increasing number of users, the application started showing performance issues which lead to EDS handing the next release 9.
Average Number of users in Kenya and Tanzania is 5 million users. The average starting number of customers in India is expected to reach 30 million.
Team Management is distributed between EDS UK, and Egypt Solution Centre
A training was conducted in Sagentia in the UK and EDS UK as well for two months.
Communication was carried out through international conference calls, NetMeeting and emails.
An e-commerce web site was developed for a big department store client in Sweden, called COOP. The web site was designed using the Abstract Factory Design Pattern, in which interfaces are used to create families of related or dependent objects without specifying their concrete classes. One example of this pattern is within the Data Access Layer tier, which has projects for IDAL, DAL Factory, Oracle DAL, and SQL Server DAL. Abstract factories are created for caching, inventory and orders data access, messaging, and profile data access. In addition, the client requested a web service that contains most of the functionalities of the products search feature to be used in their own existing asp site.
Team leading of the functional specification part of the team,
Proof of concept development for the VMT Admin web site modifications.
Production support to the Treasury Portal system of ABN Amro Bank. The project handles major trades that occur every few seconds at ABN Amro form branches all over the world. The project is to be migrated to the Egyptian solution centre (EgSC) from the USA, Chicago IL solution center and a team of 7 were formed to receive training, I was one of five people to be chosen to attend training there.
Production Support to the Credit Toolkit (CTK) project for ABN AMRO Bank. The project handles the core credit risk control processes which are: Investigation, validation, and escalation. The project is to be migrated to the Egyptian solution centre (EgSC) from the UK solution centre and a team of four was formed to receive training, I was one of two people to be chosen to attend training there. The project was written in Visual C++ 6, Visual Interdev 6, Active Server
Pages 6, using Rational ClearCase for source code version control.
Using Microsoft Solutions .Net Framework (MSF), Microsoft Sql Server database Engine, and SourceOffSite version control, in developing and supporting a Service Excellence Best Shore Migration project to Egyptian Solution Centre (EgSC). The Service Excellence Experience system ensures that the quality of client service is known at all times and that EDS’ service performance is at the top of the industry. Through this system, EDS is capable of predicting every curve within its client relationships, and facilitates an open, active and trusting relationship with EDS clients. Also Clients can provide real-time performance feedback using the EDS Client Survey, an online survey tool.
• Using Microsoft Solutions Framework (MSF) in developing and supporting a Workflow Application System for new product registration for the Ministry of Health- General Authority for Drug and Pharmaceutical Planning and Registration. This system licenses were provided as a gift to the Ministry of Health from Procter & Gamble Egypt.
.
.
• Using Microsofts Commerce server 2000 for empowering the B2C providing the critical e-commerce infrastructure needed to build an effective online business. User profiling and management, product and service management, transaction processing, and targeted marketing and merchandising are all integrated to create a comprehensive system customizable for the customers specific needs.
• Share Point Portal Server 2001 to create a corporate portal which is a Web site that gathers information from a variety of sources and displays them in a single location. Portal Server includes a corporate portal with a dashboard site as a centralized location for information. The dashboard site brings together information from throughout the organization and from outside the organization into one dashboard site.
Using Microsoft Solutions Framework (MSF) in developing and supporting a Workflow Application System for new product registration for the Ministry of Health- General Authority for Drug and Pharmaceutical Planning and Registration. This system licenses were provided as a gift to the Ministry of Health
Using Used Microsoft Solutions Framework (MSF) in developing and supporting a taxes Intranet service based on the Income Tax Authoritys need for one centralized database for Egypts taxpayers allowing the finance ministry and the Taxes department officials to view daily the development of taxes with all its subsidiaries.
Using Microsoft’s Commerce server 2000 for empowering the B2C providing the critical e-commerce infrastructure needed to build an effective online business. User profiling and management, product and service management, transaction processing, and targeted marketing and merchandising are all integrated to create a comprehensive system customizable for the customer’s specific needs.
• Project Description: Systems for the automation of The Egyptian Kuwaiti Holdings Company (EKH).Share Holders subsystem: The system keeps track of all contributors in the company and the movement of shares between them (selling and buying shares among themselves), their meetings attendance, and the coupons they use in cashing their profits on preset dates. The system issues reports displaying all the previous information using Crystal Reports.
• Stock Trading subsystem: The system keeps track of the brokers who buy and sell shares, upon request. All the information is registered in Sales Orders and Purchase Orders. The system issues reports displaying all the previous information using Crystal Reports. DBMS used was Oracle.
• Corporate developed ERP system, sold to many companies
3.6