Loading...

CYNTHIA MUTHONI WAIGWA

About Me

Passionate Data Analyst & Developer with the ability to extract, transform, load, interpret and visualize data using various statistical methods, tools and programming languages.

About Picture
WHAT I DO

My Services

Data Engineering
Informatica

Extract, transform and load with Informatica PowerCenter

Data Analytics
Python

Data cleaning and wrangling with Python

Data Visualization
Tableau

Creating interactive dashboards with Tableau

Resume

My Qualifications

My Experience
IT Command Center Analyst
October 2019 - Present | Fujitsu, Richardson TX

● Performed nightly database backup on client’s PCs ● Partnered with various IT technicians in carrying out nationwide remote upgrade and installation of software on at least two PCs per day ● Collaborated with DBAs in running scripts on Oracle Database via the command line, in addition to moving, copying and uploading files

Manufacturing Specialist
April 2018 October 2019 | Texas Instruments, Dallas TX

● Propelled the company’s goals and strategies by offering exceptional training to new hires ● Minimized misprocesses by optimizing standard operating procedures

Office Manager
May 2016 - March 2017 |Wanjohi & Muli Law Firm, Dallas TX

● Entered, updated and maintained client data in a secure manner ● Created, maintained and shared reports with the attorneys ● Worked respectfully with both founding attorneys and clients

My Education
Master of Science in Informatics (Data Analytics)
In Progress

Texas Woman’s University, Denton TX

Bachelor of Science in Business Laws
Sep 2010 - Dec 2014

Moi University, Eldoret KENYA

Relevant Experience
Data Analyst Pre-Apprenticeship
Jan 2020 - May 2020 | Digital Creative Institute, Austin TX

● Collaborated with team members to analyze business requirements and translate them to technical specifications ● Performed data cleansing and wrangling using Python programming language ● Utilized SQL to extract, analyze, join datasets, perform aggregations and manipulate output using CTEs and sub queries ● Created interactive dashboard reports on Tableau Desktop; while adhering to Tableau’s best practice concepts of reporting

DevOps Boot Camp
Jul 2019 - Oct 2019 | Codegravity, Irving TX

● Developed and maintained automated CI/CD pipelines for code deployment using Jenkins ● Managed GitHub repositories and permissions; including branching ● Provisioned EC2 instances, S3 buckets and IAM rules on AWS platform

Data Warehousing Boot Camp
Aug 2018 - Dec 2018 | Itek Vision Consultancy, Dallas TX

● Extracted data from diverse sources such as flat files, xml and SQL Server; using Informatica PowerCenter 9.0.1 ● Utilized Informatica to implement Slowly Changing Dimension to maintain historical data in the data warehouse ● Performed code migration between different environments ● Created, scheduled and monitored sessions using Informatica Workflow Manager ● Called stored procedure from Oracle Database using Informatica’s Stored Procedure Transformation ● Created drill-down, drill through, matrix and sub-reports; and added report mapping functionality to the reports using SSRS

TOOLS
SQL Developer
Toad
Informatica PowerCenter 9.0.1
Tableau Desktop
CODING LANGUAGES
Python
SQL
R
Portfolio

My Works

PYTHON PROJECT
Profitable IOS and Android Apps

This project was aimed at coming up with the profile of an app that would be most marketable to both the Android and iOS users

GITHUB (CODE) LOOM (VIDEO)
PYTHON PROJECT
Hacker News Post Analysis

The aim of this analysis was to find out which kind of posts receive the most comments and points on various websites

GITHUB (CODE) LOOM (VIDEO)
SQL PROJECT
Sales Department Data Analysis

This analysis provided insight to the sales department on the bottom five (least profitable products) and the employee of the year

GITHUB (CODE) LOOM (VIDEO)
LINUX PROJECT
Redirection and Piping

Redirecting files and connecting linux commands on a single pipeline

LOOM (VIDEO)