Database Engineer and Analyst

sql, postgresql, oracle cloud
• Writing of advanced SQL, analyzing developer SQL and make recommendations for
performance tuning SQL, rewriting SQL, or adding indexes for efficiency and creating/updating
stored procedures.
• Creation of stored procedures, triggers, functions, packages, Logical and Physical database
design.
• Operated in an agile development team and participate in the design, development, testing,
and debugging of applications.
• Working with a technical lead and product manager to clearly define product requirements.
• Working with colleagues and engineering leadership to define technical solutions that meet
business requirements.
• Development of clean, elegant, and reusable code that is easy to maintain and extend.
• Ensuring that the architectural integrity of the source code is maintained and improved.
• Identifying improvements to reduce technical debt.
• Conducting efficient code reviews and enforce team coding standards.

python, mysql, aws, spark, javascript
•Data Engineering and Full Stack development at Pinterest.
•Migrating spark notebook's logic to back-end applications using Python.
•Mantenancing of home-made data science tools front-end using Javascript.

pentaho, amazon‐redshift, apache-airflow
• Constructed ETLs. updated and guided overall features of Pentaho software.
• Coached and helped colleagues with Pentaho and Redshift technologies, including performance tunning, data structure, and monitoring.
• Maintained, updated, and provided overall Pentaho’s feature guidance