Priyanka Prasad
Hoboken,NJ
Summary
- 3+ years of experience as a Data Analyst with Data Modelling and Data Warehousing, Application Design, development, testing, documentation, and reporting.
- Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing, and Implementation.
- Good experience in performing statistical analysis, causal inference, and statistical modeling in R and Python.
- Working experience in Integrated Development Environments (IDE) like PyCharm, and Visual Studio Code.
- Adept in Python libraries such as NumPy, Pandas, Matplotlib, SciPy, and ggplot2.
- Proficient in using visualization tools like Tableau, and Power BI for creating dashboards.
- Knowledge of writing queries and subqueries to retrieve the data using SQL from various servers including MySQL, and SQL Server.
- Well-Versed in Data Analysis, ETL, Data Conversion, Data Cleansing, Data Profiling, Design, and Data Modeling
Overview
5
5
years of professional experience
Work History
Data Analyst
Capital One Financial
08.2022 - Current
- Use Agile Methodology to implement project life cycles of reports design and development.
- Supporting technical team members with Microsoft Excel, R, and Python technologies improving team productivity by 20%.
- Develop visualizations using Tableau to better understand data, and perform data cleaning, normalization, and transformation.
- Create 5-7 mockups of Dashboards and individual data visualizations in MS Excel.
- Work autonomously, exhibiting excellent communication skills, and demonstrating problem-solving abilities.
- Perform data manipulation, development, and validation of data models using SQL.
- Utilize and maintain database in MS SQL Server to extract data inputs from internal systems
Data Analyst
Oval SoftTech
07.2018 - 06.2021
- Exercised Waterfall Methodology at beginning of project.
- Automated web-scraping tool reducing time in producing marketing content by 50% using Python.
- Applied Python libraries like NumPy, Pandas, Matplotlib, SciPy, and ggplot2.
- Generated functions, triggers, views, and stored procedures using MySQL.
- Developed 10-15 custom Dashboards and Visualizations in Excel and Power BI.
- Wrote, executed, andperformance-tuned SQL queries for data analysis and profiling and compiled complex SQL queries using joins.
- Involved in data analysis and creating data mapping documents to capture source-to-target transformation rules.
Education
Master of Science - Business Intelligence And Analytics
Stevens Institute of Technology
Hoboken, NJ05.2023
Bachelor of Science - Computer Engineering
University of Mumbai
05.2018
Skills
- Methodologies: SDLC, Agile, Waterfall
- Language: Python, R, SQL, Java
- IDEs: Visual Studio Code, PyCharm
- Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2
- Visualization Tools: Tableau, Power BI, Microsoft Excel
- Database: MySQL, SQL Server, RDBMS
- Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving
- Operating System and Software: Windows, Linux, JIRA
Timeline
Data Analyst
Capital One Financial
08.2022 - Current
Data Analyst
Oval SoftTech
07.2018 - 06.2021
Master of Science - Business Intelligence And Analytics
Stevens Institute of Technology
Bachelor of Science - Computer Engineering
University of Mumbai
Similar Profiles
Naomi BarrettNaomi Barrett
Senior Account Manager Fraud and Disputes at Capital One FinancialSenior Account Manager Fraud and Disputes at Capital One Financial
Sonya LewisSonya Lewis
Anti-Money Laundering (AML)Supervisor/Manager at Capital One FinancialAnti-Money Laundering (AML)Supervisor/Manager at Capital One Financial
ANDREW VUANDREW VU
Senior Commercial Credit Analyst at Capital One Financial CorporationSenior Commercial Credit Analyst at Capital One Financial Corporation