Ramy Hamdy Email & Phone Number

Cairo, Egypt

Regional Data & Insights Functional Lead - Microsoft Marketing Analytics Team

Cairo, Egypt

Dubai, United Arab Emirates

- Managing and delivering data based projects for MEA HQ. Serving as a knowledge resource concerning data analytics tools and data structures.-Responsible for improving the performance of marketing activities and campaign planning by developing and evangelizing data-based solutions.-The technical main role is to provide Microsoft with summarized and current data reports using some data mining in sales DB using SQL Server with some work on analytics models to be used in making the most appropriate and strategic decisions involving the company. The job of the analytics lead plays a helping key role for the company’s decision-making processes.-Driving insight at the campaign design to shape data strategies that achieve measurable gains in marketing activities for agency clients.- Driving all MSC data communication to MARCOM MSDs. Building and implementing targeting and advanced-analytics models to provide data-driven insights for predicting and optimizing outcomes.- Commanding the data quality fixing process, partnering with the DB team to give further insights and consulting services in the daily operation.- Monitoring data acquisition and implementing optimization techniques for extremely large databases. Supporting design & implementation of database structures for maximizing the speed and efficiency with which data is retrieved.- Employing step-by-step approach for profiling enterprise data, framing the quality rule, validating data, analyzing exceptions, cleansing data and standardization, ongoing monitoring and data quality reporting.- Keeping up-to-date with best practice and capabilities concerning relevant data analytics processes and tools.

Cairo, Egypt

 Managing 6 data team members on a daily operation work, managing the marketing data executions for all what is related to the database and the analysis. Leveraged expertise in analytics tools, developed and evangelized data-based solutions to produce actionable insights for enhancing performance of marketing activities and campaign planning. Developed, maintained and deployed creative reporting and analytic solutions for Microsoft using some data mining in sales DB using SQL Server with some work on analytics models to be used for identifying opportunities and making the most appropriate and strategic decisions to optimize revenue and growth potential. Functioned as a business intelligence expert, drove insight at the campaign design to shape data strategies and facilitate attainment of measurable gains in marketing activities for agency clients. Implemented best practices and frameworks for high volume data processing and analytics including Info Path DEV-Design with SharePoint WF Integrations, SharePoint 2007-2010 Design and Microsoft sales DB & analysis tools. Explored new technologies, languages, and techniques in the rapidly evolving world of high volume data processing.

Montreal, Canada Area

 Provided various technical support services -problem analysis and resolution support for the Tenrox’s Enterprise System including timesheet, billing, payroll systems, etc. Deployed specially designed test scripts, reclaimed system metrics, gathered and formatted statistics and ran analyses to identify system issues.  Provided constant technical support for applications to ensure optimal durability and reliability including MS Reporting Services/Crystal reports/OLAP 2005, SQL Server 2008, CRM Application Support and Microsoft Project planning tool. Exhibited mastery in the latest cutting-edge technologies as well as excellence in change and capacity management. Extensive knowledge of software development life cycle / process / methodologies / support frameworks. Analyzed the codes for any bugs, troubleshot issues, application support functions, deployed the codes on test servers and tested for any issues.

- Effectively designed software solutions driving continuous improvement to processes, systems, work flow and customer responsiveness.- Hands on experience on all phases of Software Development Life Cycle (SDLC) including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.- Expertise in enhancing and deploying the SSIS Packages from development server to production server. Extracting, Transforming and Loading (ETL) data to MS SQL Server by using DTS and SSIS services.- Developed OLAP reports using Analysis Services 2000 and Reporting Services. Created line-of-business applications utilizing VS.Net 2005.- Compiled detailed statistical reports in MS Excel and OLAP to track progress of quarterly, monthly and weekly customers and sales growth.- Designed solution approach of data warehouse implementations, implemented best practices, performed BI assessment of client projects with Micro-Strategy Tools.

Bachelor'S Degree, Computers Science, B+

Activities and Societies: • I was the president of student's union 2005-2006.A Bachelor Degree in Computer Science: - Graduation Project.

Certificate, Mcpd

•MCPD : “Microsoft Certified Professional Developer” 70-536: Application Development Foundation 70-526: Windows-Based Client Development.