# priyank pandey

priyank pandey is a remote worker on Himalayas, Analyst II at Bank of America, based in India.

Source: https://himalayas.app/@priyankpandey

```text
Data Analyst at Bank of America who created 20+ Tableau dashboards and automated recurring Excel and SQL reporting.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 50k+ USD |
| Job categories | Data Analyst, SQL Developer, Business Intelligence Analyst |
| Skills | SQL, Data Analysis, Tableau, Dashboard Development, KPI Reporting, Data Visualization, Microsoft SQL Server, Oracle, T SQL, Query Optimization, Join, CTEs, Subqueries, Stored Procedures |
| LinkedIn | https://linkedin.com/in/priyank |

## What I'm looking for

```text
I'm seeking a Data Analyst, SQL Developer, or Business Intelligence role.
```

## About

```text
At Bank of America, I write and optimize SQL queries across Oracle and Microsoft SQL Server to extract and analyze financial data for reporting and investigation. I also designed and maintain 20+ Tableau dashboards that track KPIs, data quality, and operational trends.

I automated recurring Excel and SQL reports using Power Query and Python, reducing manual reporting effort and improving turnaround time and accuracy. My analysis of recurring data and process issues has helped inform recommendations to improve data quality and reporting reliability.

Earlier, as a Technical Analyst (Production & Data Support) at Bank of America, I queried databases to investigate data issues and validate completeness. I also monitored data pipelines and scheduled jobs, managed Axiom workflows, and resolved incidents for EMEA business users.
```

## Experience

### Analyst II (current)

[Bank of America](https://himalayas.app/companies/bank-of-america). Jun 2023 - Present

```text
Wrote and optimized complex SQL queries against Oracle and Microsoft SQL Server to extract and analyze large financial datasets. Designed and maintained 20+ interactive Tableau dashboards tracking KPIs and data quality metrics, and automated recurring reports using Power Query and Python.
```

Skills: SQL, T-SQL, Oracle, Microsoft-SQL-Server, Tableau, Power-Query, Python, Pandas, NumPy, Data-Analysis, Data-Validation, Root-Cause-Analysis, Automation, Stakeholder-Management

### Technical Analyst (Production & Data Support)

[Bank of America](https://himalayas.app/companies/bank-of-america). Sep 2022 - Jun 2023

```text
Queried Oracle and MS SQL Server databases daily to investigate data issues and validate completeness. Built and managed Axiom data workflows, monitored production pipelines with Autosys and ITRS, and conducted root cause analysis on incidents for EMEA users.
```

Skills: SQL, Oracle, Microsoft-SQL-Server, Toad, SSMS-(Microsoft-SQL-Server-Management-Studio), AXIOM, Autosys, ITRS-Geneos, BMC-Remedy, ITSM, Data-Validation, Root-Cause-Analysis, Automation

## Education

### Coursera

Business Analytics with Excel, Business Analytics

```text
Completed the Business Analytics with Excel certification on Coursera in 2023.
```

### Coursera

Introduction to Data Analytics, Data Analytics

```text
Completed the Introduction to Data Analytics certification on Coursera in 2022.
```

### SRM University

Bachelor of Technology, Technology. 2018 - 2022

```text
Bachelor of Technology degree from SRM University, Delhi, completed from 2018 to 2022.
```

## Tech stack

- Tableau
- NumPy
- Pandas
- Microsoft SQL Server
- Oracle
- Python
- Microsoft Excel
- SQL
- Join
- Axiom
- Microsoft PowerPoint

To contact priyank, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [vineetha Maganti User](https://himalayas.app/@vineethamagantiuser): Data Analyst, HCL Technologies
- [Prashanth Nayak](https://himalayas.app/@prashanthnayak): Junior Analyst, Federal Bank
- [mitali gavhane](https://himalayas.app/@mitaligavhane): Tableau Developer, Novel Financials
- [Abhijeet Sarkar](https://himalayas.app/@abhijeetsarkar): Assistant Manager, AXA XL
- [Shubham Saxena](https://himalayas.app/@shubhamsaxena2): Data/BI Analyst, Genpact India Pvt. Ltd.
- [Manasi Jadhav](https://himalayas.app/@manasijadhav2): Data Analyst, IBM
- [Puneeth Kumar](https://himalayas.app/@puneethkumar2): Associate – Data Analyst, Wipro
- [Nishtha Raturi](https://himalayas.app/@nishtharaturi): Systems Engineer, Infosys Limited
- [Komanduri Kavya](https://himalayas.app/@komandurikavya): Software Engineer, Wipro Limited
- [Arghajit Ghosh](https://himalayas.app/@arghajitghosh): Data Analyst, ADP Pvt Ltd
