szemiako
Pet projects, hobbies and other useful tools to make my job easier. Mostly Python with some SQL and Powershell.
New York, NY
Pinned Repositories
bpl-class-registration
Register a person for a free public class at the Brooklyn Public Library. Please be responsible with your requests.
Create_Legacy_Production_Site
Quick and easy implementation to create new customer interfaces on the legacy product.
Extract_and_Match_Data
Extract data from source vendor files, stitch them together with customer's data after some parsing, and join possible matches for client reporting purposes.
Find_and_Load_Files
Written in Powershell 2.0 due to system limitations, find files for a given customer, decrypt and normalize the filenames, and load them into an SFTP (for retrieval for other processes).
popup_retail_selenium_scraper
Pull data regarding popup retail venues, and load it into a csv.
produce_daily_export_files
Create comma-delimited export files in three (3) different flavors, as per customer requirements, with a command-line based interface in Python. Includes a Powershell / batch wrapper to run.
Puerto_Rico_Businesses
Use Google Place API to get data on businesses in specific Puerto Rican municipalities, map them on a plot and perform some data visualizations and analysis.
PyService
A project created to parse structured data files from different vendors to load into a database, while also producing an output file. Goal was to use functional arguments and no for loops.
Tools_and_Snippets
Some tools and code snippets of scripts written for QOL during day to day operations.
VendorReport
Get a real-time report of currently processed vendor feeds using dash.
szemiako's Repositories
szemiako/Extract_and_Match_Data
Extract data from source vendor files, stitch them together with customer's data after some parsing, and join possible matches for client reporting purposes.
szemiako/produce_daily_export_files
Create comma-delimited export files in three (3) different flavors, as per customer requirements, with a command-line based interface in Python. Includes a Powershell / batch wrapper to run.
szemiako/PyService
A project created to parse structured data files from different vendors to load into a database, while also producing an output file. Goal was to use functional arguments and no for loops.
szemiako/VendorReport
Get a real-time report of currently processed vendor feeds using dash.
szemiako/bpl-class-registration
Register a person for a free public class at the Brooklyn Public Library. Please be responsible with your requests.
szemiako/Create_Legacy_Production_Site
Quick and easy implementation to create new customer interfaces on the legacy product.
szemiako/Find_and_Load_Files
Written in Powershell 2.0 due to system limitations, find files for a given customer, decrypt and normalize the filenames, and load them into an SFTP (for retrieval for other processes).
szemiako/popup_retail_selenium_scraper
Pull data regarding popup retail venues, and load it into a csv.
szemiako/Puerto_Rico_Businesses
Use Google Place API to get data on businesses in specific Puerto Rican municipalities, map them on a plot and perform some data visualizations and analysis.
szemiako/Tools_and_Snippets
Some tools and code snippets of scripts written for QOL during day to day operations.
szemiako/szemiako
Config files for my GitHub profile.