ALOK GUPTA

Aspiring Data Engineer with academic expertise in data science and hands-on experience in ETL processes, SQL, and programming. Detail-oriented, collaborative, and eager to apply skills in a dynamic data engineering role.

• Paper published in IEEE(Novel Model for the Efficient Vehicle Movement in Vehicular Ad hoc Network Based IOT)
• Done Training in AWS and SQL
• Done a certification in Android App Development using Java
• Microsoft Certified Azure Data Fundamentals (DP-900)
• Python for Data Science (Kaggle).
• Certified Databases and SQL for Data Science with Python (Coursera)
• The Bits and Bytes of Computer Networking (Coursera)
• Won State level championship in gaming

• SQL
• Python
• Snowflake
• ADF
• Power BI
• SSMS
• SSIS
• Putty

Data Migration for Insurance group (Lockton & Affinity):-

1. Creating a data flow for data migration from excel model to SQL server tables using various transformation techniques in SSIS.

2. Created SSIS packages for JSON conversion from excel model.

3. Created an error message flow.

4. Created database design documents and stored procedure function documents to present to the business.

Worked in multiple projects under Insurance client(NBFC):-

1. Develop and maintain ETL processes to transform and load data into the data warehouse.

2. Data loading and warehousing using snowflake.

3. Develop and maintain reports and dashboards in Power BI to provide insights into business performance and trends.

4. Performed mapping document validation for the documents provided in DASH and Data Delivery POD.

5. Performed metadata validation for different tables provided on ADF boards. Schema, table & column level validation.

6. Created SQL minus query to validate the source and target data in snowflake.

7. Created test cases and SQL queries for record count check from linux(source) to snowflake(target).

8. Created tests cases for one to one data validation from source to target.

9. Created SQL queries and stored procedures to test data for validity edits check and historical and incremental data load checks.

10. Running daily audit query and monthly audit query update for amount check in support board.