mohamed ramadan

Working as an independent Business Intelligence Consultant on various projects at the Canadian head offices of multinational pharmaceutical companies

Developed structural design for residential buildings and supervised construction process

Worked as an independent consultant on various Sales Force Operations analytics for business effectiveness projects.

* Responsible for the Electronic Data Processing (EDP) that ensured the uniformity of database production process in addition to the implementation and customer support of a newly launched in the Middle East region decision support system * Designed and developed programs in COBOL and Visual Basic to reformat and control the quality of electronic data files * Analyzed, maintained, and developed directories for databases involved in production * Maintained, modified and manipulated software packages for all steps of production * Implemented software systems including the management of marketing research package (IMSView) newly introduced to the Middle East by IMS HEALTH * Provided user support and training in individual and group settings

* Analyzed and designed programming steps identifying algorithms to be employed and the appropriate file structure * Programmed, coded, tested and debugged using MF COBOL 3 & 4.5, MF Animator resulting in the automation of previously manually processed several business systems * Developed management systems including fixed assets, inventory control for automotive dealership and ship fuelling bunker tracking * Maintained and modified existing programs and systems to suit client needs which ensured the sustainability of data files and system flow as new requirements being requested

* Working as an independent consultant on various Sales Force Operations analytics for business effectiveness projects. Accomplishments examples: * Developed, implanted and executed business process solutions designed to mange and enhance quality of third party data assets * Designed and created process to enhance customers segmentation and call planning activates for the field force using CRM data in conjunction with IMS’s Doctor Level prescription data * Documented and participated in setting Standard Operating Procedures (SOP) under the Data Governance principles to identify: Acceptable applications, Key Business Questions and Limitation/Cavities of all datasets used for commercial Business Effectiveness analysis and reporting * Managed and improved the sales force compensation plans and payout process * Created Post Launch reporting solutions that offers Dashboards and Key Performance Indices (KPI) score cards

Responsible for the application support and best practice usage by clients on the applications of IMS sales databases (Territory Sales Analysis) via IMSView (a decision support front end user interface four dimensions system) Managed eight pharmaceutical clients with more than 60 users on the IMSView system which involved the setup and installation of software Defined and documented client requirements for report automation and ensured the on-time and quality delivery of the reporting tools including data integration and custom database creation Compiled databases needed for client extensive demonstration including data integration and mapping presentations which resulted in expanding the use of the system in complex market definitions with multiple geographical alignment environment

* Responsible for the administration of internal database, application development and report generating for IMS’s data suppliers * Managed database production, loading and data extraction that resulted in the consistency of the production flow of monthly updated efficient databases * Resolved data integrity issues, dealing with inquiries and report verification to ensure quality and integrity of deliverables * Created monthly reports and ad-hoc requests which demonstrated the value of analyzing and reporting from the raw data supplied to IMS which established a robust strategic partnership with IMS’s supply chain * Recommended, developed and provided support for new report output and product/applications projects designed to simplify the querying process

Responsible for sales reporting, sales targets, forecasting, specialized pharmaceutical IMS data management and all aspects of Sales Force Effectiveness reporting.

* Working in the production group of the Specialty Rx division responsibilities includes : * Data reports automation * Report analysis * Improved data quality * Standardized customer reporting * Identification of data & its analysis to drive business effectiveness