Cynthia Koskei
About Me
I am a motivated and talented data analyst with more than two years experience in the IT sector with a passion for data analysis, data modeling, and data visualization. Experienced in using various tools such as Tableau, Microsoft Excel, and Python to obtain insights from data. Proven history of developing actionable findings from data to drive business decisions.
Skilled in creating reports and visualizations with Tableau and Power BI, as well as designing and implementing data models using SQL. Adept at analyzing complex data sets and synthesizing information into actionable insights for stakeholders. Capable of collaborating with cross-functional teams to provide business solutions and improve decision-making.
Education
Kabarak University
Work & Experience
Data Analyst
Kenya Revenue Authority
Efficiently applying SQL for extracting and delivery of tailored data solutions for diverse organizational sectors, meeting and set Service Level Agreements (SLAs). This led me to achieve a 97% on-time delivery rate. Utilizing Oracle Data Integrator (ODI) as a tool to streamline the seamless movement of data from source tables to target table, ensuring efficient and accurate data integration processes. Spearheading a project tasked with live streaming data in its JSON format from a 3rd-party application, via an API URL, employing Jupyter Notebooks, Python and SQL for seamless viewing and storage in a structured database. Assisted in creating data extraction routines from various sources, applying data transformations and efficiently loading the processed data into the organization’s database system. Analyzed system environments and user requests, delivering targeted solutions with a focus on enhancing operational efficiency and thus achieving a 20% increase in problem resolution by addressing user needs. Performed comprehensive testing for developed components, actively contributing to System Integration testing (SIT), and providing extended support for User Access Testing (UAT). Utilized Excel for generating reports and graphs, analyzed trends, and created visualizations for management. Developed SQL queries for data extraction and maintained databases to track and analyze customer data. Designed and implemented visualizations and dashboards using Tableau and Power Bi for senior management decision-making. Reviewed large data-sets, identified trends and provided actionable insights for business stakeholders. Leveraged statistical methods and predictive modeling techniques for data analysis.