Francis Kagua
Apache Junction, AZ *****
adjpkr@r.postjobfree.com
CAREER OBJECTIVE
Process oriented and dedicated Data analyst with diverse skills. A quick learner, adaptable and prolific problem solver who works well with teams and also can deliver independently.
My expertise involves working with large data set and implementation of ETL process and extracting data from multiple sources, while preserving data integrity.
CORE COMPETENCIES
Proficient in documentation, interpreting, and analyzing data in a fast-paced environment.
Expertise in ETL using Alteryx.
Experience leading small project teams and working directly with stakeholders.
Ability to work with large data sets, data mining, modeling, and trend forecasting using SQL.
Data Visualization and reporting using Tableau.
Proficient in Microsoft Excel.
Agile Methodology.
WORK EXPERIENCE
ETL Developer(Alteryx)/Data Analyst
Smart Data Analytic, Remote – Plano, Texas July 2017 – Dec 2020
Responsibilities
Conduct statistical analysis and draw insightful decisions to present to both technical and non-technical stakeholders.
Use advanced Excel functions (VLOOKUP, Pivot tables) for data analysis and creating reports.
Develop new and modify existing SQL code based on the requirements to generate data reports.
Run Ad-hoc requests for the business as needed.
Convert complex data from multiple sources into meaningful and easy to understand formats for various stakeholders.
Implement ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel, CSV) and schedule workflows.
Manage end to end complex data migration, conversion, and data modeling (using Alteryx, SQL), and create visualization using tableau to develop high quality dashboards.
Update fields and data types and heavily utilized case statements logics for developing business logic.
Use joins and sub queries / nested queries in SQL.
Develop various documents associated with design phase; Software Specification Document (SDD), unit testing validation document and traceability document.
Support in gathering requirements from the business partners and develop Business Requirement Document (BRD).
Conduct peer review test, create test plans, and execute test script and validation.
Self Employed
Taxi and Trucking business – Arizona July 2015 – June 2017
Responsibilities
Direct activities related to dispatching, routing and tracking transportation vehicles.
Managed all truck’s driver contracts including insurance liability, payables, compensation, and benefits.
Oversaw scheduling for the day-to-day activities of employees.
Handled new recruitment and employment law matters.
Actively participated in streamlining operational policies and procedures related to transportation.
Establish performance objectives for associates in the distribution center, analyze attainment to find ways to improve performance.
Established transportation cost standards and economical shipping practices.
Forecasted manpower requirements based on daily workload and company targets.
Increase employee retention rate above 90% by creating and maintaining a positive environment
Certified Nursing Assistant (CNA)
Apache Junction Health & Rehabilitation Center – Apache Junction, AZ Dec 2014 – June 2015
Desert Blossom Health & Rehabilitation Center – Mesa, AZ Jan 2011 – Dec 2014
Responsibilities
Educated patients and their families on the nature of their physiological disorders.
Take resident’s vital signs, record inputs and outputs, provide bed baths, grooming and ambulation
Help nurses with any additional tasks that they needed to complete with patient care
Delegated CNA staff to understand infectious disorders and methodologies for infection control.
Ensured the observation of Privacy/HIPAA regulations by non-medical personnel.
Inspired empathetic care and compassion among staff and patients.
EDUCATION
Diploma: Health Information Specialist, Arizona College, Mesa, 2014
Certified Nursing Assistant: CNA Arizona, Mesa AZ, 2010
Associate Degree: Human Resource Management, Kenya Institute of Management, 2009
Bachelor’s Degree : Cartography, The Kenya Polytechnic University, 1995
ACHIEVEMENTS
Academic achievement dean’s list - Arizona College: April 2014 and June 2014