Business Analyst Data Analysis

Rashmi Gupta

New Jersey, USA

+1-973-***-**** ***************@*****.*** http://www.linkedin.com/in/rashmi-gupta-a8034a159/ Summary

Business Analyst with 3.4+ years of experience in data analysis, business analysis, and reporting. Proven track record in creating impactful data visualisations using Tableau and generating insightful reports to support business decisions. Skilled in advanced SQL queries and statistical analysis for performance evaluation. Eager to leverage analytical skills to drive business success.

Skills

• Data Analytics & Visualization: Tableau, Power BI, MS Excel

• Business Process Modeling Tool: MS Visio, JIRA, Joint Application Development (JAD)

• Database Programming: Advanced SQL, Database SQL Server

• Data Gathering & Data Mining: MS Excel, SQL

• MS Office: Advanced MS Excel, MS PowerPoint, MS Word, MS Access

• MS Excel: Pivot Table, VLOOKUP, HLOOKUP

• Regression/Predictive Analysis: Time series, Cross-sectional data

• Financial Statements: Budgeting, P&L, Forecasting, Analysis

• Accounts: GAAP, Accounts payable, Accounts receivable, General ledger, Bank reconciliation

• Software: QuickBooks Online, Tally, CorpTax, Lacerte Tax Software, Monday.com, Slack, Shopify, Rippling, Ramp card, Stripe, PayPal, Bill.com, Gusto

• Certifications: Capital Budgeting, NYIF, NYC, AICPA Tax Fundamentals

• Other: Produced Master's Thesis on Global Recession 2009 Work Experience

EALearn Inc Feb 2024 - Present

Business Analyst New Jersey, USA

• Performing data analysis using statistical techniques to improve business strategies, resulting in more informed decision-making

• Creating data visualizations, including charts and graphs in Tableau, to enhance data comprehension, leading to better stakeholder understanding

• Generating reports to support research and provide actionable insights, aiding in strategic planning

• Extracting and transforming data using advanced SQL queries to ensure data accuracy and reliability, improving data quality

• Analyzing past and present data to understand and improve business performance, leading to enhanced operational efficiency Apex Limited Group, LLC Aug 2023 - Feb 2024

Business Analyst Remote, United States

• Utilized data visualization techniques in Tableau to assist business users in representing data visually to solve complex problems

• Extracted, transformed, and loaded data from various sources into Tableau for reporting, improving data accessibility and deci- sion-making

• Developed various visualizations in Tableau, including bar charts, line charts, pie charts, maps, scatter plots, heat maps, and table reports, to provide comprehensive data insights

• Wrote advanced SQL queries with various types of joins, tables, and sub-queries for data validation, ensuring data accuracy and reliability

• Designed impactful dashboards and reports to present analysis, facilitating better management decision-making

• Performed data visualizations and transformations on large data sets using various analytical tools, improving data accessibility and decision-making processes

• Conducted detailed analyses on past, future, and comparative performance, developing forecast models that enhanced strategic planning and resource allocation

• Created process flow charts, presentations, and defect management documentation using JIRA, Visio, PowerPoint, and MS Excel, streamlining project workflows and improving team communication Nezaj & Co. CPAs (CPA firm) Jun 2023 - Aug 2023

Associate New York, NY

• Performed month-end close process for multiple clients, ensuring accurate and timely financial reporting

• Performed monthly bank, credit card, and ramp card reconciliations, and coded general ledger entries, improving financial accuracy

• Created bills and processed weekly payments to vendors, ensuring timely and accurate transactions

• Prepared balance sheet reconciliations and managed monthly payroll expenses for clients, ensuring compliance and accuracy

• Reviewed monthly financial statements, SaaS income, and P&L, providing insights for financial decision-making Neptune Retail Solutions Jul 2022 - Oct 2022

Tax Internship Jersey City, NJ

• Prepared local and state tax returns and local tax apportionment calculations for partnership entities, ensuring compliance with regulatory requirements

• Prepared business tax returns, partnership returns, 1065, and 1040 according to federal, state, and local laws. Trigent Software Ltd Jul 2019 - Aug 2020

Analyst Bengaluru, India

• Created detailed data reports using MS Excel features like VLOOKUPs, pivot tables, and data points, resulting in improved data representation

• Researched, updated, and validated data for spreadsheet production using Microsoft tools, ensuring data accuracy and completeness

• Processed and cleansed data using Excel, Access, and SQL, enhancing data quality and reliability

• Interacted with business users to collect and analyze business and functional requirements, leading to more accurate project specifi- cations

• Conducted Joint Application Development (JAD) sessions for requirements gathering, analysis, and design, resulting in more efficient project planning

• Performed ad-hoc analysis using Power BI, enabling fast business decisions that improved operational efficiency

• Coordinated with cross-functional teams and led client presentations, resulting in improved project alignment and client satisfaction

• Assisted in P&L forecasting process using SaaS Income and Stripe, contributing to more accurate financial projections Birla Cement Corporations Jun 2018 - Jul 2018

Analyst Internship Rae Bareli, India

• Created project presentations using MS PowerPoint, enhancing communication with businesses, stakeholders, and clients, leading to improved project understanding

• Performed marketing research and data-driven analysis using Pivot Table, providing actionable insights that informed strategic decisions

ITI Ltd. Jun 2017 - Jul 2018

Analyst Internship Rae Bareli, India

• Created daily reports of orders and shipments using MS PowerPoint, improving reporting efficiency and ensuring timely updates

• Assisted in preparing the bank's regulatory Call Reports using Tally, ensuring accuracy and compliance with other statements Education

Saint Peter's University Sep 2021 - Feb 2023

Masters in Finance New Jersey, USA

PES University Aug 2016 - Aug 2019

Bachelor of Business Administration (Marketing & Finance) Bengaluru, India

Contact this candidate