Jaya Punjabi

Intro

Aspiring data analyst with an analytical background and extensive Experience in analyzing data through rigorous course work. Over one and half years of professional as well as three years of academic experience using data analysis software such as SQL, TABLEAU and TALEND as well as experience wrangling data in Microsoft Excel. A self-starter who can dig into the technical details but also has no problem explaining things to non-technical stakeholders.

Experience

ETL Developer

PRGX Global Inc.
07/2021 - Ongoing
Prgx provides recovery audit services to businesses having payment transactions and procurement environments worldwide.

• I am responsible to create various Jobs or solution through TALEND and other ETL tools with satisfies the business needs for loading the client data to databases.
• Work with various types of flat files, dump or pump files, XML and xlsx’s files depending on the data received from clients.
• Analyze and Query data using SQL, ORACLE, POWERBI, MS-EXCEL, etc.
• Store the data in Data warehouse as well as Extract client data, Transform it and Load client’s data to data warehouse.
• Created some basic Python scripts to make data extraction easier.
• Created JSONs layouts to create schemas into SQL.

Trainee ETL Developer(intern)

PRGX Global Inc.
01/2020 - 06-2021

• Learnt and created configurations for data pipeline(uses technologies such as Apache Spark, Airflow, Minio, JSON, Python, PowerBI) and deliver client data using it.
• Learnt about ETL tools to deliver the data. Analyzing bugs/issues and fixing at the same time. Working with SQL.

Projects

Tableau Projects

Tableau Dashboards for projects on COVID 19, Financial Forecasting of AirBnB,etc
Click to view all tableau Dasboards

SQL Data Cleaning

In this project I used SQL Server Clean global COVID 19 data for further use.
Click to view SQL data Cleaning Scripts

SQL Data Exploration

In this project I used SQL Server to explore global COVID 19 data.
Click to view SQL Data Exploration Scripts

Excel Dashboard

In this project I have used the data cleaning process and created dashboard in Excel.
Click to view Excel Dashboard Worksheet

Python

In this project I used Python to find correlations between variables..
Click to view Python Data Correlation Script

Contact

• Gmail
• Linkedin
• GitHub

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';