Peninah Adongo Orengo

Peninah Adongo Orengo P.0. BOX 14504 | - Nairobi-Profile: Data & Operations professional with over 6 years’ experience in the world of data, finance, tech, operations, and analytics. In-depth knowledge of business management processes, project management, database management, and tools such as SQL, Python, Gantt charts, Excel, Google Data Studio, QuickBooks, Power Bi, Tableau, etc. Proficient at multitasking and managing large 10+ or small person teams with a proven track record for being highly efficient. Detail-focused, collaborative and innovative with great reporting skills with a proven record of creating excellent reports & presentations using digital tools. Proficient in SQL, Power-Bi, Microsoft Office suite including MS Word & Powerpoint and in Advanced Excel skills including macros, vlookup, pivot tables, VBA, data sorting, creating dashboards, and analysis. Exceptional organizational, project management, and leadership skills. Highly motivated and results-oriented with great people management, decision making, time management, and interpersonal skills, with the flexibility (adaptability) in handling changes and deadlines. Passionate about finance, technology, Big Data, and business management processes. EXPERIENCE Data Analysis Assistant March 2022 – May 2023 UN Environment Programme (UNEP), Nairobi • Collaborated with cross-functional teams to ensure accurate and up-to-date data for use in analyzing project, grants, implementing partners and HR data. • Front-end design of dashboards, paginated reports, and visualizations in PowerBi/Power Bi report builder while gathering and documenting requirements from users. • Maintained an inventory of KPI’s, developed algorithms and predictive models to identify patterns in data, and measured project outputs and outcomes by conducting performance analyses based on budget allocations and activities. • Used Python, SQL, PowerBi and other tools including AZURE databricks to streamline data workflows, clean, manipulate and store complex datasets and facilitate presentation of this information in a simple and intuitive format • Resolved and logged any data related issues presented by teams. • Developed operational workflows to collect, inspect, clean and transform data in ETL processes and load data through extracting, transforming & loading relevant data from a wide array of data sources into staging datasets & ultimately into visualization tools. • Effectively used Microsoft Word, Powerpoint, Google Docs, Sheets, Forms, Calendar and Excel to create professional documentation, presentations and reports and conduct trainings to teams to communicate technical aspects of the reports. • Managed the organizations MySQL database server, performing and maintaining data ingestion, backups and restoration, cleaning and transformation processes within the database, and extracting/importing data sets from SAP business objects. Project Manager Apr 2021 – Feb 2022 KALNA LTD., Kisumu ● Oversaw project operations of a social impact project focusing on rural development in agriculture involving women empowerment in business development processes, farming practices and income generating activities. ● Developed tools, policies, and strategies to monitor the progress, quality, and impact of the rural project while maintaining a database and drafting project proposals, agreements, tenders, policy documents and reports for the donors (KCIC). ● Collaborated with grant stakeholders, community stakeholders, and team managers to organize and monitor the allocation of resources in the most efficient and costeffective way, review projected revenue, and adjust resources accordingly aiming for the highest quality of implementation and helping resolve any budgetary issues. ● Monitored on monthly-basis actual expenditures and compared them with the implementation model, budget requirements and social impact while reviewing the budget when needed with the team and stakeholders. ● Prepared monthly, quarterly, semi-annual, annual and other program and financial reports as needed (including budgets, budget narratives, workplans, etc.) Operations Officer Aug 2019 - Feb 2021 Turaco Kenya Ltd, Nairobi ● Business Intelligence analysis and Reporting; statistics. ● Used raw data to identify and analyze business performance, monitor performance metrics, and report on trends. ● Led a team of 12 to provide call center analysis, customer behavioral analysis, predictive analytics, operational data, and key insights for multiple key departments within the organization. ● Used digital tools like Google Analytics, Google Data Studio, Excel, and Tableau for data modeling and to develop business insights and generate reports. ● Operations Management, Policy & Claims Administration. ● Provided excellent customer care and client training to maintain and improve customer relations, resolve issues, strengthen loyalty, and increase product and service sales. ● Reviewed, updated, and published standard operating procedures (SOPs) using stakeholder, customer, and employee input and feedback resulting in clearer & more useful instruction for users, smoother operations, and improved vendor relationships. Sales Analyst Jan 2018 - Jul 2019 Platinum Credit Limited, Nairobi ● Worked with Sales Coordination team to proactively track and analyze sales rep activities, providing general sales reporting and analysis and identifying metrics to determine activities that correlated to success. ● Developed accurate sales forecasts by analyzing sales feedback and created reports for senior leadership. ● Applied sales forecasting techniques and strategic planning to verify sales and profitability of products, lines, and services. ● Assisted in the identification and development of business opportunities through analysis and interpretation of consumer, customer, and market data Administration Assistant Jan 2016 - Sep 2017 Enfinite Solutions Limited, Nairobi ● Acted as first-level application support for users by analyzing, categorizing, and logging issues reported via calls or emails at the service desk and ensured any issues not resolved at 1st level were escalated to 2nd level support. ● Assisted in installation and support of peripheral IT systems and investigated any service disruptions reported and initiated incident management process to ensure timely resolution. ● Conducted scheduled training for clients on software use, preparing dashboards, presentations, standard operating procedures and reports when necessary. EDUCATION CISCO IT Essentials certificate ACWICT Kenya Feb 2015 Entrepreneurship & Management African Women Entrepreneurs Cooperation Dec 2022 Bachelors of Commerce Degree, Actuarial Science Major Kenyatta University Dec 2014 Certificate of Secondary Education (KCSE) Kisumu Girls High School Kenya Dec 2009 SKILLS Proficient in: Excel, Data Analysis, SQL, Azure Databricks, Database Management, Project Management, Leadership, Dashboard creation, Report Writing, Operations Management, Data Visualization, Quickbooks, Presentations, Power-Bi. REFERENCES Annelise Francis Growth Manager Turaco Microinsurance Kenya Limited Tel: - Email:-Luke Ngugi Senior Software Developer Enfinite Solutions Limited Tel: - Email:-Robert Wafula DevOps Engineer UN Environment Programme Tel: - Email:-