Shagun Agarwal

Operations Associate

Ghaziabad, Uttar Pradesh, India8 yrs 8 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in Data Management and Statistical Analysis.
Co-founded a successful sports startup.
Proven track record in business analytics and reporting.

Stackforce AI infers this person is a Business Analyst with expertise in Data Management and Analytics in the Fintech and Sports industries.

Contact

Skills

Core Skills

Data ManagementStatistical Data AnalysisBusiness ManagementBusiness DevelopmentMarketing

Other Skills

CommunicationVBAData AnalysisExcelReportingEvent ManagementClient RelationsR Programming LanguagePython (Programming Language)Microsoft Power BIVBA ProgrammingVisual Basic for Applications (VBA)HTMLwixC

About

Experienced Business Management Analyst with demonstrated history of working in the investment banking industry and dealing with stakeholder and vendors. Skilled in R language, SQL, VBA, Microsoft Power BI, Tableau, Microsoft Excel, Microsoft PowerPoint and Data Science. Also had previous experience as Business Coordinator and Activity Manager in my own startup Sports Academy India, also had great experience of dealing with business owners for event sponsorship An experienced Marketing Executive with a demonstrated history in dealing with Ayurved doctors and Yoga Instructors. Strong marketing professional skilled in Microsoft Word, WordPress, Microsoft Office, Always trying to slove real life problems for business perspective.

Experience

8 yrs 8 mos

Total Experience

1 yr 8 mos

Average Tenure

3 yrs 4 mos

Current Experience

Nab innovation centre india

Senior Associate

Jan 2023 – Present · 3 yrs 4 mos · Gurugram, Haryana, India · On-site

Apple

Senior Business Analyst

Oct 2021 – Jan 2023 · 1 yr 3 mos · Gurugram, Haryana, India

Statistical Data AnalysisData ManagementCommunication

Natwest markets

Performance and Business Management Analyst

Sep 2019 – Jul 2021 · 1 yr 10 mos · Gurgaon, India

I was part of central Business Management Team and managed all BM related activities including HR Analytics, Headcount Tracking, PMO activities, Business Analyst activities, budget tracking, actuals, forecast and target comparison and seat tracking using sentinel.
Perform Data Analysis on HR data and Published monthly Headcount report, MIS report, Rewards and recognition file, monthly GPL completion status to the management
Published Attrition pack with analysis of LTM (Last Twelve Months), YTD (Year Till Date), Month wise rise/dip in attrition number and percentage etc. after performing necessary Data Analytics on the file. Also the attrition dashboard was prepared in excel involving a lot of formulas and hence I have automated the pack using VBA. This automation reduced the time from 2 days to 30 minutes to prepare the Attrition pack
Worked directly with director of BM Team and managed the WFMI Tableau portal for correct and smooth tracking of actuals and forecast of headcount and budget
I have Handled PMO activities for NWM technology, I have Managed SAP Fieldglass for SOW creation and SOW approving at technology India level for onboarding of TPS resources, also involved in sentinel management for seat tracking. I have also handled Supply Chain and Vendor related activities like TPS contract management, vendor rate verification, PES approval, SOW Signoff

Data ManagementCommunicationBusiness Management

Kranti tech services pvt. ltd

Software Tester

May 2019 – Aug 2019 · 3 mos · Noida, Uttar Pradesh, India

Sports academy india

Co-Founder / Activity Incharge

Nov 2017 – Apr 2019 · 1 yr 5 mos · NCR India

Sports Academy India was a startup found in 2017 and worked to promote sports and to make people aware about benefits of sports. We have also collaborated sports expert and corporates to provide a platform to sports enthusiasts to showcase their skills and enhance them. We teach the better techniques to develop sports skills.
Co-founded Sports Academy India in 2017 with one of my classmates, 2 investors were also involved in our startup
Worked as Business Head and look after all the clients, deal closure, event sponsorship, corporate connect, lead the design & development team and testing team
Worked as Activity Incharge and handled all the activities related to sports events. We have organized several events including, Marathon, Badminton, Cricket and Table Tennis
I have also handled the accounts and finance related activities for Sports Academy India

CommunicationBusiness Development