Bill Gesora
Development
Nairobi, Kenya
Skills
Data Analysis
About
Bill Gesora's skills align with System Developers and Analysts (Information and Communication Technology). Bill also has skills associated with Management Analysts and Consultants (Management, Policy and Governance). Bill Gesora has 7 years of work experience.
View more
Work Experience
Data Analytics Consultant
Mint Group
March 2023 - Present
- Create solution design documents and write relational database queries. Participate in the development and maintenance of Data lakes and Data warehouses. Engaging with clients and gathering requirements for data migration projects. Building migration pipelines in Azure Data Factory and orchestrating them seamlessly to enable migration of systems from OnPrem to the Cloud. Developing operational reports and dashboards in Power BI. Leveraging machine learning technology to extract insights from transactional data such as churn prediction, revenue prediction, customer upsell & cross-sell segmentations.
Senior Data Analyst
Netlify
September 2021 - December 2022
- Model data coming from various sources to give insights on a regular basis. Utilize SQL, Python, and Git to build new analyses and maintain existing reporting. Build upon and document Netlify's common data framework to connect and analyze all data. Help to define and improve internal standards for style, maintainability, and best practices for high-scale data infrastructure. Maintain and advocate for these standards through code review, including testing, documentation, and reproducibility. Maintain deliverables, projects, and timelines for the Finance stakeholders. Monitor and fix failing data ingestion pipelines dealing with financial data. Preparation of ad-hoc reports to C-Suite and external clients showcasing the data team architecture and infrastructure. Communicate and train team members on how to use the Business Intelligence tools (Mode Analytics) Communicate findings clearly to a broad range of stakeholders.
Analyst -> Senior Analyst -> Consultant
Deloitte East Africa
October 2016 - August 2021
- Functioned as analytics and reporting expert for assigned functions by developing standard reports and designing, running, and maintaining ad hoc queries. Develop reports, metrics, models, scorecards, and dashboards by gathering data and transforming it into stories and insights that drive business recommendations and decision-making. Build reports and dashboards in Microsoft Power BI, Analysis for Office, Bex, and other reporting tools Hold training sessions on how to use the various tools and reports created by the department Perform ad hoc analysis using data from various systems and explain the results of an analysis to all levels of management Create Standard Operating Procedures (SOPs) and maintain documentation for processes Reviewing the work of junior analysts and supporting them in the efficient and quality delivery of services to clients. Provide comprehensive analytical and fact-based reporting to support and/or identify opportunities to impact operational results, make changes to processes, and support strategic initiatives.
Education
University of East London
MSc
January 2022 - Present
