Lawrence Ajayi

AJAYI LAWRENCE TOLULOPE 7 Udosen street, Eket , Akwa Ibom. --www.linkedin.com/in/lawrence-ajayi-4642b8119 Professional Summary Detail-oriented Excel specialist with over 12 years of experience in data analysis, reporting, and financial modeling. Proficient in advanced Excel functions, including pivot tables, VLOOKUP, macros, and data visualization tools. Strong analytical skills with a proven ability to streamline processes and enhance decision-making through accurate data reporting. Core Competencies - Advanced Excel Functions (VLOOKUP, HLOOKUP, INDEX, MATCH) - Data Analysis & Reporting - Pivot Tables & Charts - Macros & VBA Programming - Data Cleaning & Formatting - Financial Modeling - Database Management - Problem-Solving & Critical Thinking - Project Management - Effective Communication Professional Experience Accounting officer and Head of ICT unit Helene British Schools (Eket, Akwa Ibom) September, 201] – Present - Developed and maintained complex Excel spreadsheets for data analysis and reporting, resulting in a 68% increase in efficiency. - Created automated reporting dashboards using pivot tables and charts, enabling senior management to visualize key performance indicators. - Collaborated with cross-functional teams to gather data requirements and provide actionable insights through data modeling and analysis. - Utilized macros to streamline repetitive tasks, reducing processing time by 12 hours per week. Accountant Royalty Hotel (Eket, Akwa Ibom) August 2016 – September 2019 - Conducted thorough data cleaning and validation processes to ensure the accuracy of large datasets. - Implemented advanced Excel techniques to perform financial forecasting and budgeting, which supported strategic decision-making. - Trained team members on best practices in Excel, enhancing overall team productivity and capability. - Assisted in the transition to cloud-based data solutions, improving accessibility and collaboration. Accountant / Manager Cardon Food Limited (Ifako- Ijaye, Lagos State) May 2014 – July 2016 - Conducted thorough data cleaning and validation processes to ensure the accuracy of large datasets. - Implemented advanced Excel techniques to perform financial forecasting and budgeting, which supported strategic decision-making. - Trained team members on best practices in Excel, enhancing overall team productivity and capability. - Assisted in the transition to cloud-based data solutions, improving accessibility and collaboration. Education Bachelor of Business Administration University Lagos — (Lagos, State) 2012 Certifications - Microsoft Office Specialist: Excel, word, power point, publisher ( 2012) - Graphics Design : Corel Draw, and Photoshop ( 2012) Professional Development - Completed [Relevant Course/Workshop] on Advanced Excel Techniques, [2013] - Attended [Relevant Conference/Webinar], (2016) References Oj Ablert CEO of AM FLOURISH CONCEPT- Available upon request. Feel free to customize this template with your specific details, experiences, and accomplishments!