JULIANA AJAYI
+1-407-***-**** *****************@*****.*** www.linkedin.com/in/julianajayi
Professional Summary
Detail-oriented and highly motivated Data Analyst with a strong foundation in data analysis, statistical modeling, and reporting. Proficient in Excel, SQL, and Python, with a passion for transforming data into actionable insights. Seeking to contribute to a dynamic analytics team. Key Skills
• Data Analysis & Visualization
• SQL & Excel (Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP)
• Python (Pandas, NumPy, Matplotlib)
• Power BI / Tableau
• Statistical Modeling
• Attention to Detail
• Problem Solving
• Communication & Presentation
Professional Experience
DATA ANALYST
Megaplux Global Ng Limited – Lagos, NG Jan 2019 – Jul 2024 Constructed predictive models that can forecast consumer good prices within a 16% standard deviation
• Constructed a predictive model that can forecast consumer good prices within a 16% standard deviation
• Analyzed and visualized large data sets to uncover key insights, resulting in a 22% increase in revenue for the company
• Created weekly dashboards using Excel and Tableau to monitor KPIs, resulting in 10% improved reporting efficiency
• Analyzed customer churn data using SQL, identifying trends that led to a targeted retention campaign
• Collaborated with senior analysts to deliver insights in stakeholder meetings
• Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
DATA ANALYST INTERN
Tech Studio Academy – Lagos, NG Jul 2023 – Dec 2023
• Created online dashboards to track client ROI and financial KPI's
• Analyzed and cleaned large data sets for clients and provided strategic insights
• Gained exposure to various aspects of the industry through active participation in company events, workshops, and training sessions during the internship period.
• Developed strong communication skills by presenting findings in team meetings and collaborating on group projects
DATA ANALYST
Fioten LLC – Lagos, NG Jan 2016– Mar 2018
• Built a data warehouse that stored and organized customer data, improving data accuracy by 24%
• Maintained data models and data flows to improve system architecture
• Developed and implemented a data backup and recovery system, increasing data security and reducing downtime in the event of a system failure DATA ASSOCIATE
Midas Shipping Company – Ikeja, NG Dec 2012– Jan 2016
• Provided administrative support to multiple departments, including scheduling, coordinating meetings and events, and taking meeting minutes
• Participated in the creation of detailed documentation outlining data workflows, processes, and governance guidelines.
• Championed a culture of continuous improvement by proactively identifying opportunities for process enhancements within the organization’s data ecosystem.
• Collaborated with cross-functional teams to ensure data consistency and quality across multiple platforms.
• Optimized database performance through the implementation of indexing strategies and query optimization techniques.
DATA ENTRY ASSOCIATE
Ibadan North Local Government – Ibadan, NG Jan 2011– Dec 2012
• Reduced errors by conducting thorough quality control checks on all entered and updated data.
• Improved data accuracy by meticulously entering and updating information in company databases
Education
Bachelor of Technology Mechanical Engineering
Ladoke Akintola University of Technology, Ogbomosho Graduated: November 2012 West African Senior Certificate
Brightville College, Lagos, Nigeria. 2007
Certifications
• Google Data Analytics Certificate - Coursera
• Microsoft Power Bi – Coursera
• Advanced Microsoft Excel - Udemy
• Data Science & Data Analysis – Tech Studio Academy
• Data Analysis – Pluralcode Academy