Swara Gupta
Pittsburgh,PA
Overview
5
5
years of professional experience
Work History
Data Analyst
Bank Of New York Mellon Corp
09.2023 - Current
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools like Power BI to effectively communicate business insights.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Improved data governance practices, ensuring compliance with regulatory standards and internal policies.
- Analyzed financial data using SQL to identify root causes of problems and recommend corrective actions.
- Utilized Collibra for modifying business rules as per 14M, and 14Q requirements
Data Analyst (Research Assistant)
San Diego State University
10.2022 - 07.2023
- Utilized SDSU survey data to monitor student's well-being by creating numerous Tableau stories with more than5 dashboards
- Performed data cleaning and data preprocessing on Excel of 2k-3k rows monthly
- Designed and developed data pipelines using Alteryx to acquire, clean and process data.
- Identified patterns and trends in large data sets and provided actionable insights.
Student Assistant at Instructional Technology Services
San Diego State University
08.2022 - 05.2023
- Maintained smooth teaching environment in over 150 classrooms by providing technical assistance
- Utilized Service Now to effectively manage technical issues in university
- Created tableau dashboard to analyze recurring issues monthly
Graduate Assistant
San Diego State University
09.2021 - 05.2022
- Incorporated Alteryx on collected information about minority-entrepreneurs to reduce the data-merging and data-cleaning time by 50%
- Generated pivot tables to filter out the top 20% of the startups based on its worth
Web Developer Intern
Technosoft Informatics
08.2019 - 11.2019
- Implemented 8 steps of Agile Approach and developed a Movers & Packers website using HTML, CSS and Java
- Managed company data using SQL and increased company outreach by 30%
Education
MS - Management Information Systems
San Diego State University
San Diego, CA05.2023
B.E - Electronics and Telecommunications
IET DAVV
06.2021
Skills
- Technical Skills: SQL, Excel, (Python (NumPy, Pandas, Matplotlib, Seaborn), R, SQL, HTML5, CSS, Statistical Modelling, ETL, Data Warehousing
- Data Visualization/BI Reporting Tools: (Tableau, Microsoft Excel, Power BI, Jupyter)
- Tools & Databases: Oracle, Collibra, Service Now, R Studio, Visual Studio, Microsoft SQL Server Management Studio, My SQL Workbench, Microsoft Outlook, Microsoft Excel, GitHub, NetBeans, SQLyog, Alteryx, Microsoft SQL Server, MySQL
Timeline
Data Analyst
Bank Of New York Mellon Corp
09.2023 - Current
Data Analyst (Research Assistant)
San Diego State University
10.2022 - 07.2023
Student Assistant at Instructional Technology Services
San Diego State University
08.2022 - 05.2023
Graduate Assistant
San Diego State University
09.2021 - 05.2022
Web Developer Intern
Technosoft Informatics
08.2019 - 11.2019
B.E - Electronics and Telecommunications
IET DAVV
MS - Management Information Systems
San Diego State University
Similar Profiles
Aarthi GauthamAarthi Gautham
IT Auditor at Bank Of New York Mellon CorpIT Auditor at Bank Of New York Mellon Corp
Giana GrantGiana Grant
Associate Client Processing at Bank Of New York Mellon CorpAssociate Client Processing at Bank Of New York Mellon Corp
Adithya RaamanAdithya Raaman
Senior Analyst at Bank Of New York Mellon CorpSenior Analyst at Bank Of New York Mellon Corp
Deepansh SinghDeepansh Singh
Associate II (Supervisory) at Bank Of New York Mellon CorpAssociate II (Supervisory) at Bank Of New York Mellon Corp
Destiny HickeyDestiny Hickey
Bartender at Shawn Ryan's PubBartender at Shawn Ryan's Pub