Sandro Scordo's Email Addresses & Phone Numbers

📖 Summary

I am a dedicated, highly organised and confident professional with extensive project management, business relationship management experience working for multinationals (Coca-Cola and Seat-Yellow Pages Group). Advanced analysis of data with a world-renowned NGO (Save the Children) and CRM/database management with a London based cancer charity. I hold a First Class Honours Degree in Management Engineering with a dissertation in management of industrial data. KEY SKILLS - CRM Management and Development: Donor Strategy (at Beating Bowel Cancer), The Raiser's Edge (at Save the Children). - ERP: SAP (at the Coca-Cola Company). - T-SQL with SQL Management Studio. - Excellent MS Excel, MS Access, MS Powerpoint. - Business Intelligence Management: Microsoft Power BI, Qlik. - MS Microsoft Project. - HTML editing. - Ability to present complex ideas to technical and non-technical audiences. - Data analysis for fundraising also using statistical techniques. - Data Quality Management: Experian Pandora. - Excellent analytical and problem-solving skills. - Quick learner of new technologies. - Advanced Fundraising. - Advanced Procurement. - Project Management. - Process Improvement.Senior Database and Analysis Officer @ • CRM Management using Donor Strategy (Advanced NFP Group) - Data deduplication, data migration, data reorganization, troubleshooting, backups/restore of the database. Global updates of data, executing imports/exports and so on. • Management of multiple databases using MS SQL Management Studio. • Data Analysis Management mainly using MS Excel and Microsoft Power BI. • Training of Users. Defining, promoting and sharing database policies, after an analysis of procedures and data flow, with every CRM User at all levels, according to a specific User Development Plan. • Creating tailored reports across all functions, using the SQL code. • Management of campaigns data using MS Access for data flow management, MS Excel for data manipulation, Just Giving for data synchronization, the CRM/SQL for data selections, Mailchimp for campaign to send mass-emails and track results. • Managing of the synchronization between the CRM & the finance system (Exchequer). • Early adopter of the CRM. Collaboration with the CRM’s supplier for spotting mistakes and bugs in order to make enhancements at the existing system. • Management of IT suppliers. Main achievements include: • Introduced a “Database Development Strategy”, aimed to improve the database consistency and reliability of data, but also data flows, internal procedures and the general understanding of the CRM across the Charity. It contributed to generate +50% in terms of income on the previous year in 2014. • Managed all the data flows of the Decembeard 2014 and 2015 Campaigns. • Introduced new data analysis for fundraising and for monitoring the service's performance. Realised a new KPI dashboard. • Customization of the CRM: created new fields, new masks (for example: new medical tab for nurses) and related procedures for data collection via web. • Solved long standing problems generated after data migration from the previous database and in particular about the Gift Aid process. From May 2015 to Present (8 months) Database Officer @ • Supporting all colleagues in their use of the database, particularly in creating and running reports • Responsibility for ensuring that all supporter data from the charity’s website is accurately and frequently transferred to the database • Ensuring that records within the database remain accurate, working proactively with colleagues to ensure that they are recording necessary data in an efficient and timely manner • Making enhancements and alterations to system functionality as required by all departments within the charity • Downloading and importing data from other third party sources into the database • Working with colleagues to coordinate the content and sending of the charity e-newsletter, maintaining high quality content • Ensuring that other bulk emails requested by colleagues are scheduled appropriately and that the content is accurate and adheres to brand guidelines • Synchronising e-newsletter mailings with the database. From August 2014 to May 2015 (10 months) Data Analysis for Fundraising & Processes Improvement @ • Supported the creation, development and the implementation of fundraising data analysis in order to steer the Department's strategy. Worked with regular donors and one-off donors recruited from different sources (F2F, on-line, DRTV, Direct Mailing, etc.), using the CRM "The Raiser’s Edge"​ and the "Qlink" Business Intelligence. • One Off Data Analysis: Cold Contacts reports. Performance Analysis of mailings and e-mailings (cold; lapsed; renewal; development). ROI analysis with split by segments. Analysis of events by fund destination. General monthly overview by product type - main indicators: numbers of orders/donations/average donation. Donor profile Analysis. Unsolicited Donations Analysis. Analysis on actual vs forecast. KPI & Income. Performance Analysis on average and payment method -including web. • Regular Donors Data Analysis: Performance Analysis by product and channels (new; termination; active donors and allocation of funds by product). Main indicators: gift numbers, child link enrollment, monthly attrition. Performance Analysis of total donors by product and acquisition channel. Performance analysis by frequency and payment method. Performance analysis of new donors by recruitment channel (agency and or in house). Performance analysis of ongoing donors by recruitment channel (agency and or in house). Performance analysis based on no-show attrition by recruiter. Performance analysis based on no show attrition by location/group /CF /age. Reactivation performance analysis. Upgrade performance analysis. Main achievements include: • Improved the process of importing on-line and off-line donations. • Developed quantitative analysis and statistical modeling​ using the CRM, the business intelligence, MS Access and MS Excel. • Created a tool in order to forecast attrition performances of products and channels of recruitment. • Created a dashboard of fundraising KPI. From April 2012 to June 2013 (1 year 3 months) Rome Area, ItalyProject Manager Assistant @ Project of industrial development: building of two filling lines (value of investment: 40 million euros). Description of duties: • Supported the feasibility study in order to build two filling lines (value of investment: 40 million Euros). • Coordinated project materials and research, managed minutes, updated project information and scheduling. • Contributed in the processes of initiating, project planning and design: Work Breakdown Structure, Feasibility Study, Resource Management Plan, Project Schedule, Responsibility assignments, Risk Management Plan, Change Control Plan Achievements: • Contributed to the delivery of the project on time, forecasting costs, resources and technical issues. • Built new business relationships with the best suppliers of the packaging market (Rexam, Ball Packaging & Crown). From April 2009 to March 2012 (3 years) Raw Materials Buyer / Data Analysis / Logistician @ Description of Duties • Purchasing Management: scheduling of purchases, stock monitoring using the MRP of SAP, negotiating about prices and further commercial and logistic conditions, issues management. Average weekly expenditure managed for raw materials only: €1,200,000. Assurances and contracts management in collaboration with the Quality Assurance and the Legal Office. • Analysis of Data​: reporting and simulation of economic scenarios using MS Excel. Budget and costs monitoring. Budget and costs estimation (regression analysis using historic data, correlation with the oil market etc) In order to apply the most appropriate purchase strategy. Achievements: • Improved the turnover of stocks index. • Introduced statistical techniques for stock monitoring and scheduling of purchases by year, quarter and month, considering priorities and costs. • Contributed to reduce the lead time of core suppliers. • Saved over 20% of the raw materials budget in my second year of service due better planning of resources and a stronger collaboration with strategic suppliers (mainly sellers of ingredients and preforms). From March 2008 to March 2012 (4 years 1 month) Business Reengineering - Logistics/Production/Suppliers and Customers Management/Database @ • Line Manager of six individuals. • Production planning. • Procurement management. • Business processes reengineering. • Data Management: encoding onto the database of customers and suppliers, items and mixing instruction. Import/Export production data. Creation of groups of products and segmenting in categories and sub-categories. • Data Analysis: profitability analysis (customer / sku’s / channel), make or buy evaluation, cost forecasting in case of lunch of the new products, ROI evaluation. Monitored and defined KPIs. • Managed the project of building of an industrial warehouse. Main achievements included: • Designed and implemented internal processes. Introduced procedures for the management of the warehouse, the production area and for better control of stocks. • Managed the migration of data into the new Database. Defined new coding strategy and segmentation. • For the first time I used statistical sales forecasting techniques, increasing the general performances of the factory. • Contributed in producing more products in a shorter time due the increment of productivity and efficiency. From September 2006 to February 2008 (1 year 6 months) Catania Area, ItalyInternship on Logistics, Business Intelligence & Organization Management @ • Processes analysis. • Data Analysis in order to calculate standard times. Main achievement: • Set the standard time in which a worker should complete that task. • Created an innovative incentive plan for workers based on the standard times of work. From March 2005 to February 2006 (1 year) Catania Area, ItalyPostgraduate Certification in Computing, Computer Science @ The Open University From 2015 to 2016 BA of Engineering Management- Class of Degrees in Industrial Engineering, Engineering Management - Class of Degrees in Industrial Engineering, 108/110 @ Facutly of Engineering - University of Catania, Italy From 2002 to 2006 High School in Sciences From 1997 to 2002 Industrial Engineers Professional Order examination passedIntensive training by Save the Children and Unicef on Fundraising Sandro Scordo is skilled in: Project Management, Management, SAP, Data Analysis, Forecasting, Fundraising, Analysis, Project Planning, Marketing Management, Procurement, Negotiation, Budgets, Logistics, Non-profits, ERP