Maged Mohammed Shafike

OLAP Methods | PL/SQL Packages | KPI’s | Reports & Dashboards | Sandbox Environment | Testing Plans and Scripts | Database Design | Data Extraction | Tableau Analytical Tool

Description

I am responsible for the development of new Business Intelligence dashboards using Tableau Analytical Tool and providing creative thought and insight to current and future analytics. I am profound in delivering the design/development, programming, maintenance, and publication of operational reports that plays a key role in driving business decisions. Accompanied, I coordinate with teams to gather, analyze, and document business cases, functional and technical requirements, and processing the flow diagrams for new projects, enhancements to existing solutions and production issues reported by the end users.

I proactively working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming the data for loading into the pre-designed data warehouses. Making significant contributions, I am creating a reports and dashboard design process to translate business requirements into technical design documents resulting in improved quality control and output and accomplished projects on time. I proficiently coordinating and communicating with the line of business for any escalation and resolving the queries timely.

Key Outcomes
I essayed a key role in:
• Data warehouse, Data fields, data marts, meta data, cubes, SQL queries,
• Development of Complex database objects like Stored Procedures, Functions, Packages, & Triggers using SQL & PL/SQL.
• Generation of reports using Tableau Desktop Analytical Tool and publishing it to the Tableau Server in an actionable formats for Stakeholders.
• Liaison with the Power Users and IT Teams to understand business logic behind each report, and identified all end users.
• Various processes, functions, procedures, & views through TOAD to develop a data warehouse project.
• Ad-hoc queries, procedures, & reports.

System Performance Enhancement | Installation and Upgrades | Troubleshooting and Debugging Software Codes | Post-Production Support | Quality Assurance | New Modules | Errors Correction

Description

My principle responsibility was to established a new system and maintained the existing complex system and subsystems for medical insurance applications and claims system, financial cost analysis in which transaction were automatically processed through a full system of records. My main focus was to coordinate with the Functional Staff to develop and support the new system with an emphasis on various medical and general insurance modules as per the organizational standards and strategic business plans.

Key Outcomes

I efficaciously conceptualized and created a report based application as per the business needs and requirements by using Oracle Report Developer Tool 10g. I proficiently directed the development of documentation and maintenance of the application codes as required and facilitated the end-user with full manuals on the application.

- Responsible to transfer Data from old Database to new Database using Access tools and Excel sheet.
- Contact with (local and foreign) users through mail or phone to get accurate data from them.

Identified Defects | KPI, Statistics, Charts | Oracle Report Developer Tool | Documentation Development and Update | System Requirements | User Guide

Description

I was involved in implementing, maintaining and designing Oracle databases in support of the development & installation of new systems & enhancements to existing systems.

Key Outcomes

With proficiency, I have exhibited distinguished efforts in successful:
o Applications Development by using Oracle Software 9I techniques to build a new Enterprise Resource Planning system for Projects Management Office (PMO), Talaat Mustafa Group.
o Input Forms Application Designing using Oracle Form builder to institute and implement an efficient and effective project processes in different departments such as HR, Purchase, Site Engineer, Stores and so on to evaluate the current system and recommended a suitable upgrades.
o Implementation of procedures and up gradation of packages in the software using PL/SQL at Database level to enhance the application performance and reduced any retrieval data from live database.