Position: SQL/Data Analyst
Category: SQL
English level: fluent
Years of experience: 2


With almost 2 years of experience as a data analyst and SQL developer, I have worked on several end-to-end projects analyzing large datasets and building SQL databases. In my current role, I work closely with stakeholders to understand business requirements and translate those into technical specifications.

Some of the key projects I have worked on include:

* Developed a PostgreSQL database from scratch to store and analyze 10 years of 
   sales data. Designed the schema, handled ETL processes, wrote complex SQL 
   queries to generate insights on sales trends.
* Led the data migration effort from an on-prem SQL server to a cloud data 
   warehouse on AWS Redshift. Oversaw data modeling, ETL, validation and 
   performance testing during cutover.
* Built a Tableau dashboard visualizing keyword performance trends from Google 
   Analytics for a marketing analytics dashboard. Implemented calculated fields and 
   parameters for dynamic filtering.
* Automated the generation of daily, weekly and monthly sales reports by 
   developing stored procedures in PostgreSQL and setting up cron jobs to run 
   them.
* Cleaned and standardized messy ecommerce dataset with over 500K rows 
   before loading into a MySQL database. Used Python for data wrangling and 
   transformation.
In terms of technologies, I have hands-on experience with SQL databases like PostgreSQL, MySQL, Microsoft SQL Server, and cloud data warehouses like AWS Redshift and Snowflake. I am proficient in SQL and Python for data analysis. I have also worked with ETL tools like Apache Airflow and visualization tools like Tableau.

In my current role, I work in a collaborative data team where I partner with business analysts and engineers on analytics initiatives. I enjoy the problem-solving aspect of data analysis and want to continue honing my technical skills in SQL, cloud technologies and optimization. I am looking for freelance projects where I can use my experience working with complex data and keep learning.