Experience
2022 — Now
2022 — Now
Santa Ana, California, United States
● Contributed 50+ Pull requests to the Transcompiler (Transpiler) Software.
● Made extensive use of tokenization, parsing, rules, translation and writing, in C#, to compile and automate the conversion of database languages from one to another.
● Worked on weekly tickets to fix issues in the Compiler. Fixed bugs, and made new classes for parsing. Made new rule classes. Fixed writing issues.
● Was incharge of implementing the conversion of SybaseASA, SybaseASE, and PostgreSQL to Google
BigQuery. Made the barebones project for conversion. Then worked on tickets to automate conversion
given by the DBA’s.
● Worked on the SQLSplitter that automates the splitting of large SQL files into smaller ones, without the
need of DBA’s. The code would then be given to the compiler that converts it.
● The SQLSplitter parses files, reads excel files that have variant list, pattern files, and data types list. Reads each sql file, loops through each line, processes comments, valid lines, and invalid lines. Makes a valid and invalid statement list, and writes the files accordingly.
● Worked on the SQLValidator that checks the SQL code given to it by the compiler against a database.
● The SQLValidator , parses files, creates a work order list, creates an Excel sheet using OfficeOpenXml. It then uses NpgSQL to validate the input against a database. Results are then written to the Excel sheet.
Education
Penn State University