This is a repository dedicated to showcase my work.
Resume |
LinkedIn |
Tableau
Notebooks
- NumPy: Link
NumPy quick showcase.
- Pandas: Link
Pandas quick showcase.
- Card War Game: Link
Automated Card War Games.
- CodingBat Code Practice: Link
Various exercise from CodingBat Python website.
Singletons
- Mobius Strip: Link
Utilizing
matplotlib.pyplot, creating a chart in a form of famous Mobious Strip - Modern Email ReGex: Link
Email validation and cleanup function, putting into account the ability of GMail to use
+and.in email address. - Number Worder: Link
Function to translate number into word (e.g.
1toone), up to Novemdecillion (1060). - PlusMinus: Link
Based on two numbers, find the middle number and a number which can be substracted and added to find back the initial numbers.
- Prime Number: Link
Receiving input, then list all the prime number from 1 to that number, then count and total them.
- Three Dimensional Points and Lines: Link
Utilizing
matplotlib.pyplot, creating a chart in a shape of a spring. - Anti Vowel: Link
Removing vowels from given string.
- Fibonacci Series: V1 Link - V2 Link
Creating Fibonacci Number sequence. Version 1 is using recursive, an Version 2 is using loop which can be easily scalable.
- Factorial: Link
Given the input number, list all the Factorial result from 1 to that number with the grand total in the end.
- Key-Value Database: Link
Receiving input to create a Key-Value database using Python dictionary.
- LCD and GCD: Link
Listing all the common denominator from two given numbers, resulting in LCD and GCD
[Expand]
-
Mock SQL Interview Test - Solving problem of test found on the internet:
-
Transaction: Link
Using Window Function, to find the share of each employee's sales and their share by department.
-
Manager Randomizer:Link
Based on User table, generate
manager_idandsupervisor_idwith a rule thatmanager_idcan't be lower thanuser_id, andsupervisor_idmust be betweenmanager_idanduser_id - 1.
[Expand]
- Live Stream Data: Published - Source
Showcasing various formulas used on mock live stream data, including string manipulation,
VLOOKUP,QUERYand more. - Contract Mapping Data:
Showcasing my previous work using mock contract classification in projection of current user settings. Includes simple dashboarding using Pivot Table and Chart. App Script script coming soon.
Short version.
Closer to the actual architecture.