Data Analyst Supply Chain

Swara Gupta

Pittsburgh, PA (Open to Relocation)

************@*****.*** 619-***-**** Linkedin Tableau Github EDUCATION

M.S Management Information Systems San Diego, California San Diego State University (GPA 3.65/4.0) May 2023 Courses- Business Analytics, Enterprise Database Management, Time Series Analysis for Business Forecasting, Business System Analysis & Design, Statistical Analysis, Project Planning & Development, Operations & Supply Chain Management, Financial Reporting & Analysis, Decision Support Systems, OOP(Python), Big Data Infra. B.E. Electronics and Telecommunications India

Institute of Engineering and Technology DAVV (GPA 3.5/4.0) Jun 2021 Courses- Data Structures and Algorithms, OOP(Java) SKILLS

Technical Skills: SQL, Excel, Data Visualization, Python (NumPy, Pandas, Matplotlib, Seaborn), R, Hadoop, Modelling & Design, Statistical Modelling, ETL, Data Warehousing Databases: MySQL, Oracle

Tools: Tableau, Power BI, My SQL, R Studio, Visual Studio, Microsoft SQL Server Management Studio, Collibra Certifications- MySQL for Data Analysis and Business Intelligence WORK EXPERIENCE

Data Analyst, Bank of New York(BNY) Sep 2023-Current

• Designed and automated 5+ Tableau dashboards to monitor data governance KPIs, enabling faster issue resolution and improving data quality by collaborating with reporting team.

• Produced monthly operational and performance reports using advanced Excel functions (VLOOKUP, pivot tables) reducing manual reporting time by 30%.

• Enhanced strategic decision making by delivering accurate data analysis and clear visualizations using SQL.

• Partnered with cross functional teams to validate data integrity and ensure accuracy leading to reliable business decisions.

• Strengthened data governance practices to ensure compliance with regulatory standards(14M,14Q).

• Utilized Collibra to modify and manage business rules in alignment with regulatory requirements.

• Performed root cause analysis on financial data using complex SQL queries, identifying key discrepancies and recommending corrective actions that improved reporting accuracy. Data Analyst (Research Assistant), San Diego State University Oct 2022-May 2023

• Utilized SDSU survey data to monitor student's well-being by creating numerous Tableau stories with more than 5 dashboards.

• Cleaned and preprocessed monthly datasets of 2k-3k rows using Excel Power Query improving data readiness and reducing manual effort.

• Designed and built end to end data pipelines in Alteryx to automate data acquisition, cleansing, and transformation processes streamlining reporting workflows.

• Analyzed large datasets to uncover key trends and patterns, translating findings into actionable insights that informed student support initiatives.

Graduate Research Assistant, San Diego State University Sep 2021-May 2022

• Consolidated minority entrepreneur data from multiple sources, then cleaned and merged datasets using Excel, reducing data preparation time by 50% and enabling faster analysis.

• Created pivot tables in Excel to filter and rank startups by valuation, isolating the top 20% for research publication. PROJECTS

Applied Machine Learning- Pulsar Star Prediction (Tool- RStudio, Language- R)

• Performed data cleaning on around 18k observations and split into 70/30 training and test set to determine if radio signal based on various measurements is of a pulsar star.

• Implemented Machine Learning models like Logistic regression, Linear Discriminant Analysis, Quadratic Discriminant Analysis, Random Forest, Bagging, Naïve Bayes & K Nearest Neighbor.

• Choose the best classification method based on Type I, Type II error, Accuracy and Misclassification rate. Applied Machine Learning- Stock Price Prediction Walmart (Tool- RStudio, Language-R)

• Worked on Time series(weekly) data for predicting the adjusted close price of a stock.

• Identification of model like AR, MA, ARMA, performed model diagnostics (overspecification, under-specification), model selection based on AIC, rolling forecast, lastly prediction of stock value of coming weeks.

Contact this candidate