Avishruti Pant

Experience

• 

  University of Minnesota

  Sept 2017 - May 2021

  • Used UM Analytics by Oracle Business Intelligence (BI) to prepare and integrate various financial Reports• Independently created a holistic budget request system for the School of Dentistry using Qualtrics Software.• Assisted in Website Design for the research department of the School of Dentistry,• Handled accounting reports including sponsored reports, burn rates, payroll reports and carry over year-end reports for all the Principal Investigators of the UMN School of Dentistry.• Assisted in making different Excel audits including P.I Efforts, and profit-loss for grants.• Made 60 budget reports every month and effectively maintained communication with all parties. Show less

  • SSFC Sub-Committee Chair

    Oct 2019 - May 2021

  • Student Accounting Analyst

    Sept 2017 - Oct 2020
• 

  Chaudhary Group

  Jun 2019 - Aug 2019

  Finance Intern

  · Prepared year-end budget reports of various multinational hotels including Taj Hotels.· Prepared balance sheets, trial balance, VAT, and TDS reports with minimal supervision.· Learned budget analysis and forecasting and applied them on various occasions.

• 

  RBC Wealth Management

  Jun 2020 - Aug 2020

  Business Intelligence Intern

  • Used Salesforce Einstein Analytics and Tableau for data visualization and analytics for the Client Attrition Project.• Developed user stories and created dataflow & recipes using Einstein Analytics in a given sprint.• Created and deployed prediction models to create scores for client attrition data.• Designed interactive dashboards on Tableau and Einstein Analytics.• Utilized SQL Server Management and excel to create queries to broaden understanding of data for further analysis.• Collaborated with interns from across RBC to work on various projects.• Successfully completed advanced Tableau eLearning and acquired Analyst badge.• Completed and received Einstein Analytics and Discovery Insights Specialist Superbadge.• Guided other interns to use Access Database and Tableau for them to successfully implement in their respective projects Show less

• 

  RBC Wealth Management

  Oct 2020 - May 2021

  Student Ambassador
• 

  Nelnet Diversified Services

  Jan 2021 - May 2021

  Business Analyst Intern

  - Conducted Gap analysis to ensure accuracy on the data for data validation.- Responsible for formulating and defining system scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements.

• 

  Crew

  May 2021 - Jul 2021

  Data Analyst

  - Professionally trained to learn SQL for querying in the Oracle database- Gained experience in working as data consultant and successfully managed work in complex and changing environments

• 

  Cummins Inc.

  Aug 2021 - now

  IT Technical Analyst

  - Lead the entire team of unit testing, functional testing and overall quality of 250 + reports containing 3500+ fields- Reviewed analyzed and evaluated business systems (OTBI vs BI publisher) and user needs- Created comprehensive and complex Power Bi dashboards using Power Query and DAX- Gained through experience and proficiency in OTBI and BIP reports- Drove project management efforts for Oracle Cloud implementation for the entire Cummins HR IT- Played key decision making role in visualization and formatting of OACS reports- Created process diagrams for smoother business analysis and process improvements- Lead collaborative efforts between developers and business analysts to further project success Show less