Automating ETL tasks using Python Scripts
I’ve been using Python scripts to automate my ETL tasks and it made me more efficient with work. Here's one python script using cx_oracle module...
I'm a Boston based Data Scientist with a background in Data Engineering and Statistics.🤓 My current research focus is on developing efficient AI algorithms and models to solve optimization and big data challenges in the healthcare and retail space.🤖
I’ve been using Python scripts to automate my ETL tasks and it made me more efficient with work. Here's one python script using cx_oracle module...
Connecting to Reddit API, collecting subreddit data and applying NLP techniques to analyze unstructured text data. This Analysis project is still in progress - but some codes are available.
Exploring various ways to collect tweets easily using python, R and Javascript using Node.js.
Predicting how much revenue to expect from customers within their first year of using a startup's services.
Using different Machine Learning techniques to come up with a best model to predict which customers will subscribe to the cross selling promotion partnership.
Formulating a hypothesis and doing Exploratory Analysis, linear regression and interpreting results using R
Extracting data from Google Sheets , Transforming and loading the data to BigQuery Datawarehouse
This is one of the basic scripts that I've written but was super helpful in making some of our data transfer process more efficient.
Using R to do a quick data exploration and statistical analysis of a facebook campaigns dataset available for research.
There are several tools or software that I use to carry out my daily tasks and data operations. Data science tools can be categorized into programming tools ....
Check out my 2021 most used programming languages, favorite tools, algorithms I built and more!
Nike and Adidas are both known brands and are good at what they do. Nike has always been leading in terms of sportswear, sneakers and financial capabilities.
I was born and raised in the islands of the Philippines, after working for a few startups in Asia both as a full time and part time consultant, I moved to Boston, US to do my Masters and have lived here since then.
Outside of work, I enjoy doing outdoorsy stuff like hiking, skiing and surfing. I've travelled to 10 countries so far (have lived in some of them for a couple of months). I love journaling, watching sports games and making my own summer jewelries.
Most Used Tools:
Pycharm, Jupyter Notebook, Spyder, Oracle SQL Developer, RStudio, Azure Databricks, Tableau, Data Studio, CLI, Google Cloud Platform, BigQuery Datawarehouse, Snowflake, Alation, Trifacta
Download my resume ➡️
Send your message below or email me at itskathleenlara@gmail.com to get immediate response.