Ndungu Catherine

Experience

• 

  KTDA

  Jun 2008 - Aug 2008

  Intern

  Supported financial reporting and budgeting, aiding analysis and strategic decisions.Conducted financial research and data analysis, aiding strategic decision-making

• 

  ACTED

  Apr 2011 - Mar 2015

  Finance Officer

  Managed accounts, ensuring precision and timeliness. Prepared monthly financial reports, highlighting indicators. Assisted in budgeting, periodic forecasts, and financial audits for compliance.Fostered industry partnerships, facilitating project success. Generated cash forecasts, pending Finance Manager's approval. Prepared Budgetary Funding Updates for financial transparency

• 

  Adeso

  Apr 2015 - Jan 2016

  Finance Associate

  Analyzed data, supported financial statement preparations, reconciled accounts. Aided budgeting and forecasting, aligning with objectives. Collaborated on cross-functional teams to assess project costs, boost profitability.Conducted in-depth research and data analysis for strategic decision-making. Assisted in audits, ensuring compliance and generated stakeholder reports. Managed financial docs, streamlining data retrieval and reporting. Facilitated interdepartmental comms, ensuring financial data consistency. Show less

• 

  International Institute of Rural Reconstruction

  Oct 2016 - now

  Finance and Administration Manager/Business Data Analyst

  > Perform medium to complex data transformations and cleansing in Excel using formulas like VLOOKUP, INDEX/MATCH, IFS, MID, Conditional Formatting, and array formulas.> Gather and document requirements, perform systems analysis, model data flows between IT systems, create and update use case diagrams, and prepare technical specifications of application functionality.> Serve as functional lead on moderately complex projects for assigned application(s). > Support applications and their dependencies. Responsibilities included installation, configuration, administration, designing, building, testing, troubleshooting, and maintaining simple to complex applications.> Understand and adhere to the Organization's risk and regulatory standards, policies, and controls by the Company’s Risk policies. Identified risk-related issues needing escalation to management.> Maintaining relationships with important clients by making regular visits, understanding their needs, and anticipating new marketing opportunities> Support daily inquiries, integrate content, and manage internal communications, including management of weekly management meetings, data reporting, and other day-to-day business administrative activities.> Apply strong SQL knowledge (querying tables) to source and compile data. Interpret and analyze data for accuracy and efficiency, effectively communicating analysis output.> Track and monitor progress against a timeline and key milestones, and also track project-related financial expenditures.> Work with the organization to capture and document requirements using a range of techniques such as workshop facilitation, document analysis, user stories, task, and workflow analysis.> Establish and maintain effective communication and relationships across multiple areas, divisions, and project leaders/teams. > Utilize Microsoft Excel to categorize previous budget reports into a detailed pivot table to develop an improved company financial strategy. Show less

• 

  SmartData Learning

  Jan 2022 - now

  Data Analyst

  >Utilize advanced analytics techniques to analyze large datasets and extract actionable insights for business stakeholders.>Develop predictive models to optimize marketing campaigns, increasing customer acquisition and retention.>Collaborate with cross-functional teams to identify key business problems and formulate data-driven solutions.>Design and implement statistical experiments to test hypotheses and drive data-based decision-making.>Conduct exploratory data analysis to identify patterns, trends, and anomalies, leading to process improvements and cost savings.>Build machine learning models to automate processes, reducing manual effort and improving accuracy.>Deploy natural language processing models to analyze customer feedback and extract meaningful insights for product improvement.>Present findings and recommendations to executives and non-technical stakeholders clearly and concisely.>Stay up to date with the latest industry trends and advancements in data science through continuous learning and professional development.>Elicit requirements related to the payment system and translate them into technical options and solutions that meet stakeholders’ needs.>Conduct a Gap Analysis to show the current and proposed functionalities of the system.>Develop Business Requirement Document (BRD)>Manage the entire ETL process, involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to customers in the source area.>Maintain relationships with important clients by regularly visiting, understanding their needs, and anticipating new marketing opportunities.>Convert complex data from multiple sources into meaningful and easy-to-understand formats for various stakeholders.>Manage end-to-end complex data migration, conversion, and modeling (using Alteryx, SQL), and create a tableau visualization to develop high-quality dashboards. Show less