Teresiah Kimani
Nairobi
Summary
I am a seasoned data engineer with extensive expertise in data engineering, business intelligence, and software development using Oracle. I excel in designing, developing, and maintaining data pipelines and systems. I am proficient in data modeling, ETL processes, and big data technologies, and skilled in SQL. I have experience integrating data from diverse sources, ensuring data quality and governance, and optimizing performance for efficient data processing. My proven experience includes creating and managing executive dashboards to provide actionable insights for business decision-making. I am adept at collaborating with cross-functional teams to deliver data-driven solutions and support business intelligence initiatives. I am committed to leveraging my technical expertise and problem-solving skills to enhance data infrastructure and drive organizational success.
Overview
5
5
years of professional experience
Work History
Data Engineer
Kenya Revenue Authority - Corporate Data Office
Nairobi
01.2023 - Current
- Create, schedule, test, deploy, and maintain data pipelines from different sources to the required destinations with the required transformations for reporting (ETL)
- Identify, analyze, and interpret trends or patterns in complex data sets using statistical techniques and provide reports
- Acquire data from primary or secondary sources, maintain databases/data systems, and apply ETL procedures to normalize data
- Collaborate with cross-functional teams, including data scientists, analysts, and software engineers, to understand requirements and deliver data-driven solutions
- Gather information from business users to understand their detailed requirements and expectations
- Analyze business/use case requirements from BI analysts to identify operational problems, define data modeling requirements, and gather and validate information
- Apply judgment and statistical tests and develop data structures to support the generation of business insights and strategy
- Analyze user requirements and recommend solutions to address their needs while managing the queue of requests and communicating with the appropriate advanced analytics, BI, or data management functions to ensure timely and effective resolution
- Assist in preparing system definitions/specifications by highlighting technical requirements and rolling out BI solutions to stakeholders
- Assist in developing and implementing a continuous improvement program for BI processes through a cycle of analyzing existing systems, processes, and tools, identifying areas for improvement, implementing high-impact changes, and gathering feedback from stakeholders
- Make changes to system/database configurations and parameters to accommodate business and technological requirements
- Build visualizations to summarize data and prepare presentations for business and key stakeholders
- Filter and clean data, and review reports, printouts, and performance indicators to troubleshoot and resolve data-related issues
- Assist in designing data models and schemas for efficient storage, retrieval, and analysis of structured and unstructured data
- Design and maintain Oracle BI RPD files to align with business intelligence requirements, creating efficient logical data models for reporting and analytics
- Work closely with BI analysts and developers to ensure that the RPD accurately reflects business requirements and supports decision-making processes
- Integrate multiple data sources into a unified model within the RPD, ensuring consistent and reliable data flow for business intelligence platforms
- Implement data quality checks, validation processes, and data governance policies to ensure consistency and regulatory compliance, while securing BI solutions through adequate controls and restricted user access in accordance with regulatory requirements
- Collaborate closely with senior executives to design and manage an executive dashboard, ensuring real-time data and key performance indicators (KPIs) are effectively presented
- Play a key role in gathering and analyzing business intelligence to support strategic decision-making through the dashboard
- Work cross-functionally with various departments to ensure accurate and timely data integration, enhancing the dashboard's effectiveness
- Regularly updated and customized the dashboard to align with changing business priorities and objectives.
Project Coordinator
Tapis Handyman and Cleaning Services
11.2020 - 02.2021
- Support the development of project plans, including defining project scope, objectives, deliverables, and timelines
- Help coordinate day-to-day activities and tasks to ensure project milestones are met according to schedule
- Monitor and report on project progress, including tracking project schedules, budgets, and resources
- Ensuring the project are completed within the agreed timelines and quality is achieved
- Facilitate communication between project stakeholders, including team members, clients, and senior management, to ensure everyone is informed and aligned
- Help track project expenses and ensure that spending stays within the approved budget
- Support efforts to ensure project deliverables meet quality standards and client expectations
- Continuously learn and apply project management best practices and tools, seeking guidance from senior project managers and mentors.
Attachment
East African Cables
05.2019 - 08.2019
- Data entry and reporting
- Handling and resolving customer's queries and complaints
- Going for field visits to market the company products to the community
- Support management in identifying and resolving business risks.
Education
Data Science Certification Professional -
Oracle University
08.2023
BSc. Economics and Statistics -
Kenyatta University
01.2022
B Minus Kenya Certificate of Secondary Education
Kiawambogo Secondary School
01-2015
Skills
- Strong knowledge and experience with ETL tools(ORACLE ODI) and technologies such as informatics, Proficiency in , SQL for database management and querying
- Programming languages with SQL for data manipulation and scripting
- Knowledge of visualization tools Oracle Analytic Serve(OAS), (OBIEE, )Power BI,
- Data Quality and Governance: Understanding data quality management practices, data cleansing, and implementing data governance policies
- Data Warehousing: Knowledge of data warehousing concepts
- Data Integration: Ability to integrate data from various sources databases
- Data Security: Knowledge of data security practices and implementing access controls, encryption, and compliance measures
- Problem-Solving Skills: Strong analytical and problem-solving abilities to troubleshoot and resolve data-related issues
- Collaboration: Ability to work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions
- Communication Skills: Effective communication skills to explain technical concepts and findings to non-technical stakeholders
- Experience with Dimensional data modelling, data management and data processing
- Ability to work independently and as part
Personal Information
- Gender: Female
- Nationality: Kenyan
Languages
- English
- Swahili
References
- Madam Magrate Wanjiru Pere, Manager Corporate Data Office, Kenya Revenue Authority, 0720484164
- Mr. Peter Karenju, CEO, Tapis Handyman and Cleaning Services, pmkarenju@gmail.com, 0722664121
- Mrs. Ann Kamau, HR and Admin Assistant, East African Cables, AnneKamau@eacable.com, 0722202125
Timeline
Data Engineer
Kenya Revenue Authority - Corporate Data Office
01.2023 - Current
Project Coordinator
Tapis Handyman and Cleaning Services
11.2020 - 02.2021
Attachment
East African Cables
05.2019 - 08.2019
Data Science Certification Professional -
Oracle University
BSc. Economics and Statistics -
Kenyatta University
B Minus Kenya Certificate of Secondary Education
Kiawambogo Secondary School
Similar Profiles
NAMAIYAN LESEETONAMAIYAN LESEETO
Customs Officer at Kenya Revenue AuthorityCustoms Officer at Kenya Revenue Authority
MARK KIPKEMBOI NGOSOSEIMARK KIPKEMBOI NGOSOSEI
Customs officer at KENYA REVENUE AUTHORITYCustoms officer at KENYA REVENUE AUTHORITY
LOIS AKINYI LOIS AKINYI null
Customs Officer-Support 1 at Kenya Revenue AuthorityCustoms Officer-Support 1 at Kenya Revenue Authority