Satyam Vishwakarma

Data Engineer (Client- EAB, USA)

EAB is a consulting firm specializing in education institutions. It has partnership with over 300 colleges in USA. They aim at creating marketing campaign and and analytical dashboard for the Users.

Contributions/Responsibilities -

• Rewrote the logic for DND using SQL.
• Rewrote and simplified entire pipeline for calculating enrollment statuses using SQL.
• Developed the logic for GDPR requests, which is a European policy where a student/parent can request the legal team to delete their PPI.
• Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
• Worked on Good Data to create reports.
• Supervised two junior engineers gave them KT whenever necessary.
• Interacted with client directly to gather information on business requests and discuss possible technical solutions.
• Worked on DBT, AWS, Snowflake, Postgre SQL and other in-house tools.

Oracle PL/SQL Developer (Client - Mazda)

Mazda is a Motor Corporation which also supplies motor parts. I worked as an engineer for Enterprise Resource Planning (ERP).

Responsibilities-

• Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Created database objects like tables, sequences, stored procedures, functions, packages , cursors and triggers.
• Worked on Interfaces.
• Wrote complex SQL queries using joins, sub queries, analytical functions.