Ian Ngari
Profile & Portfolio
Business Intelligence Analysts, Database Administrators, Marketing Specialists
I’m a Data Analyst skilled in SQL, Python, Excel, Tableau, and R, with a strong domain foundation in marketing. I excel in transforming complex data into actionable insights, driving strategic decision-making. Passionate about using data to uncover trends, optimize processes, and support business growth. Eager to leverage my analytical expertise and marketing knowledge to contribute to innovative, data-driven projects.
Experience
-
Topcare Lands Investment LTD
Digital Sales Executive - June 2023 - April 2024 -
● I conducted A/B testing and performance analysis of digital marketing channels and product trends to optimize campaign performance to showcase the real estate offerings, tailoring pitches based on customer preferences and market analysis.
● I collaborated with the marketing team to create personalized campaigns based on data insights, resulting in a 20% increase in lead generation and analyzed product performance identifying strengths and weaknesses to enhance sales effectiveness by 50%.
● Guided buyers in property purchasing decisions, utilizing data analysis to secure profitable transactions and optimize sales processes.
● Leveraged client relationship management to ensure high customer satisfaction and retention, fostering trust and loyalty. -
Topcare Lands Investment LTD
Financial Data Associate - Oct 2022 - May 2023 -
● I cleaned and organized more than 5,000 client records in Excel using advanced functions and formulas to improve data integrity and accessibility in sales operations by 50% thus assisting the finance department in financial reporting and analysis.
● Facilitated the migration of client data into a new system database, ensuring seamless transition and data consistency.
● Recorded and maintained detailed records of customer land purchases, enhancing transparency and accountability in sales operations.
● Verified completion of customer payments for land purchases, ensuring accuracy and financial compliance. -
Ruiru-Juja Water & Sewerage Company Ltd
Marketing Data Intern - June 2021 - September 2021 -
● I utilized QGIS, an open-source software, to process, analyze, and visualize geographical data pertaining to water service areas, enhancing operational efficiency and accuracy.
● I managed data entry in Excel for water meter accounts, ensuring accurate record-keeping and resolving meter errors promptly.
● Successfully connected over 20 customers to the company’s water service lines, employing meticulous attention to detail and customer service.
Education
-
Bachelor of Business Administration (Marketing)
Dedan Kimathi University of TechnologyMay 2017 -May 2022 -
Google Data Analytics Professional Certificate
CourseraJanuary 2024 - April 2024
Skills
- Digital Marketing
- Excel
- Power BI
- Python
- R
- SQL
- Tableau