Maged Shafike

Senior Business Intelligence DeveloperFull Time

• Job Details:- Monitoring business requirements gathering, system analysis, designing, developing and implementing the workflow program, procedures and managing various phases of interface development based on techno-functional specifications. - Drafting requirement specifications as per data fields to build a data marts for various departments. - Steering development of Complex database objects like Stored Procedures, Functions, Packages, & Triggers using SQL & PL/SQL. - Creating and implementing cubes across the multiple data mart by using OLAP Methods in Business Object for users to access reporting as required. - Administered functions in developing PL/SQL packages for loading Data Warehouse and Data Mart Tables to satisfy the User needs. - Formulating dashboard reports for Top Management; generating rich dashboards and advance charts using Tableau Desktop Analytical Tool to improve corporate profitability measures and comparative financial analysis; designing, developing and establishing KPI’s. - Preparing SQL queries in line with business logic to retrieve data from Data Warehouse. - Generating reports using Tableau Desktop and publishing it to the Tableau Server in an actionable formats for Stakeholders. - Coordinating and communicating with the line of business for any escalation and resolving the queries timely. - Liaising with the Power Users and IT Teams to understand business logic behind each report, and identifying all end users. - Performing the identification of key reports that will need to be accessible during the migration process and developing sandbox environment to house those dashboards and reports. - Executing data extraction from different data sources; planning, aggregating, and implementing various calculation measures. - Defining data requirements and report layouts for the business to review. - Spearheading and creating the following: > Testing plans and scripts based on requirements. > Database design to the highest level of scalability and performance > Various processes, functions, procedures, and views through TOAD to develop a data warehouse project. > Ad-hoc queries, procedures, and reports to collect and present information to achieve organizational goals.

Senior developerFull Time

• Job Details:- Re engineering company’s systems set-up, optimized system performance, installed upgrades & established system monitoring. - 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. - Responsible for testing of new modules and corrected errors. - Coordinated 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. - Acted as escalation point for troubleshooting and debugging software codes using Oracle Form Software 10g techniques. - Developed, coded, tested and debugged system software; reviewed code & design; validated new application designs; supported Quality Assurance (QA); provided post-production support, application maintenance and enhancement support with regard to the software application. - Conceptualized and created a report based application as per the business needs and requirements by using Oracle Report Developer Tool 10g. - Analyzed & troubleshoot the software issues and employed the solutions to prevent its future occurrence. - Directed the development of documentation and maintenance of the application codes as required and facilitated the end-user with full manuals on the application.

Oracle DeveloperFull Time

• Job Details:- Distinguished efforts in successful: > Applications Development by using Oracle Software 9I techniques to build a new Enterprise Resource Planning system for Projects Management Office (PMO), Talaat Mustafa Group. > 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. > 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. - Meticulously devised and identified defects in the system to provide and collect information on KPI, Statistic, Charts, and so on by using Oracle Report Developer Tool and reported the relevant information to the Senior Management. - Engaged in writing and updating the documentation of codes and maintained program codes to meet system requirements and comprehensive user guide.