Ryan Cliff Wandera Email & Phone Number

Nairobi County, Kenya

Nairobi County, Kenya

Collaborating with cross-functional teams to integrate data from different systems, ensuring data quality and consistency.Designing, developing, and maintaining BI solutions using tools such as SQL Server, OBIEE 12, Power BI, Tableau, Oracle Analytics Cloud, and/or other BI platforms.Performing data quality checks and implementing data validation procedures to identify and resolve data inconsistencies or errors.Creating data models that support business requirements and ensure data accuracy, consistency, and integrity.Developing and maintaining ETL processes to integrate data from various sources into the BI platform.Developing and maintaining reports and dashboards that provide insights into business performance and support decision-making.Developing and optimizing data transformation processes, such as data cleansing, aggregation, and normalization.Providing training and support to end-users to ensure proper use of BI solutions.Contributing to the development and maintenance of data models and schemas for efficient storage and retrieval of data.Staying up-to-date with the latest BI trends, technologies, and best practices.

Kenya

I worked as a Non-FTE to Microsoft through Techno Brain Group. Responsibilities:Collating user feedback from Microsoft feedback channels and external forums. Detecting patterns and anomalies in feedback data and creating an executive summary. Communicating with feature owners regarding found issues. Using dashboards and analytics tools built using advanced natural language processing techniques. Monitoring monthly Windows releases to provide early detection of regression issues. Reviewing past regressions to improve the program analytics capabilities. Working closely with Microsoft engineers and data scientists to develop better tools for regression detection. Presenting feedback data using Power BI visuals in cross-team review meetings.

Designed new alternatives to health business intelligence reporting approachesto enable the scalability of health data reporting solutions.Teamed up in the development of a node script data warehouse tool for migratingdata from CouchDB to PostgreSQL using Couchwarehouse.Transformed existing CouchDB JSON data to relational data in PostgreSQL.Cleaned, filtered, and tagged data from different sources according to a complexset of criteria.Analyzed health data using Google Data Studio.Visualized data to optimally support health management specialists in operatingtheir health facilities and properly managing different diseases.User interface design and development alongside documentation of systemprocesses.Unit, integration, performance, scalability, and system testing to ensure that all thedevelopment is in line with defined requirements and acceptance criteria.

Developed analytical dashboards to identify trends lines across several data sources within theorganization using Power BI tool.Tracked and reported on department initiatives and status reports.Conducted research on specific complaints and other relevant information related to individualqueries or systemic issues.Updated and managed information on revenue collection and metering mobile application systems.Enhanced report performances by tuning the derived tables and join structures.Applied technical skills using Apex Jenkins, Pentaho , Power BI and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to executive staff requests in a timely manner.Acting as the liaison between Business Stakeholders, Developers, Infrastructure teams and project management groups.

Collaborating and supporting in technically challenging projects as a Jedox Consultant.Conception and implementation of planning projects around the technology of Jedox EPM.Collaborating with functional heads to identify opportunities for operational improvement andstrategic decisions in respective functions based on data.Developing KPI trackers and scorecards to monitor product sales and the route to market focusareas increasing achievement by 30%.

Collected and recorded field data and samples as per the GDP survey follow-up objectives from various industries.Conducted interviews with various subjects, in accordance with the data collection procedures and documentation standards.Reviewed and edited data to ensure completeness and accuracy of information, followed up with subjects to resolve problems or clarify data collected. Delivered qualitative results through research and analysis.

Nairobi

Managed quality assurance program by leading on site evaluations and internal audits.Resolved typical IT problems including and not limited to network optimization to establish exceptional staff experience.Lead a team that successfully developed the Asset management system to help track the ministry's equipment in quest for provision of improved administrative functions

Embakasi

Resolved access control problems to improve operations and provide exceptional customer experience.Installed(including wiring and cabling), repaired and optimised networks.Coordinated with clients in monitoring and evaluation to establish that the pre-installed systems conform to requirements as per the SLA. Managed system wide operating system and software deployment as well as handling any required upgrades.

Bachelor Of Science - Bs, Software Engineering

Education record

O level education