Business Analyst, Data Analyst, Finance Analyst, Tableau, SAP, Excel

Bhupinder Kaur Sandhu

Bay Area, CA, 408-***-****

**.*.*****@*****.*** www.linkedin.com/in/bhupinder-k-9a4abb132

Objective: To work at a company where I can grow with the company and my skills can be used to help become the company great.

SKILLS: Tableau, Sales order Management in ERP using SAP, AWS, CRM, Microsoft Office, Google Data Studio, Lacerte, QuickBooks, AME, and Go System (Tax).

WORK EXPERIENCE

Market Analyst Intern – NERG July 2022 to August 2022

https://www.nerg.life/

Worked as a Market Analyst Intern in NERG. NERG is a startup company, and their product is a hydration powder.

Extensively researched the market across four major states in the US and gathered data that can provide key statistics for the first report I prepared based on sports activities, gender, ingredients, age, etc. These reports are key to the success of their marketing plan for obtaining an education grant.

Prepared another report based on data of competitors in this area of business. I collated information for various hydration supplements for a competitor analysis of price, cost, quantity sold, flavors, etc. These reports were very detailed.

Researched and located fitness events, appropriate for NERG company to distribute and market their free samples in the future. This information is key to the future success from the very start of the company.

Capstone Project - People Reign June 2022 to August 2022

From June to August 2022, I along with my teammates worked on an AI capstone project with People Reign to create a virtual chatbot. People Reign is an AI platform for virtual agents.

I worked on an online environment created by People Reign’s team, to create the content, questions and replies for the chatbot.

I got the opportunity to research extensively on the data required to create the questions and answers, the prospective clients could ask. This data analysis was crucial for the response of the virtual chatbot.

Every week we were trained by the People Reign’s team on various topics including their virtual chatbot’s environment, architecture, etc.

Junior Accountant - Milani, Lee & Associates CPAs Jan 2020 to July 2020

Prepared federal and state income taxes for individuals, corporates, partnerships, and S- Corporations and estimated tax payments

Prepared Sales Tax Liability Reports and Business Property Tax Reports (571L)

Ensured compliance with accounting deadlines

Prepared company accounts and tax returns for audit

Prepared the work papers and schedules supporting the federal and state tax returns

Prepared quarterly estimated payroll tax payments reports 941, DE9 and DE9C

Prepared weekly, semi-weekly, monthly and half yearly payroll reports for clients

Process Associate (AP) Genpact India Jan 2010 to May2012

Managed vendors by processing and updating their invoices. Providing information about their payment terms and payment status on invoices.

Verified the payment terms and details on the purchase order for future payments. Worked on CRM for the processing of invoices and data analysis.

Updating employees of Pfizer Pharmaceuticals Inc. (US based pharmaceutical company) for their Accounts Payable payments.

Briefly evaluated the payment terms, invoice price, payment date, etc., and worked closely with vendor management team, and vendor payment team to make corrections for timely payment to vendors.

Solved any payment related and billing related issues.

Thoroughly verified details of purchase order with the invoice details for quick processing of payments.

Responded via calls as well as emails for Accounts Payable of employees of Pfizer Pharmaceuticals and payment of invoices of vendors.

Scanned invoices as well as replied to web-based queries of vendors and employees.

EDUCATION

Master of Business Administration in Business Analytics from International Technological University (2022).

Associate in Arts Degree - Accounting from De Anza College (2020)

Master of Commerce, Panjab University (2009)

Bachelor of Commerce, Panjab University (2007)

TRAINING & CERTIFICATIONS

Certificate of Achievement in Accounting At De Anza College (2018)

Top Grads Graduate as a Business Analyst

Certificate of Core Competence in Computing (November 2004)

Toastmasters International Communicate to Lead - Certificate of Appreciation

ACHIEVEMENTS AT WORK

Achieved Accounts Payable Certificate of Recognition for Exemplary Performance & Demonstration of Values at the Workplace (June 2011)

Achieved Accounts Payable Certificate of Recognition for Exemplary Performance & Demonstration of Values at the Workplace (September 2011)

Contact this candidate