Shehroz Babar Email & Phone Number

Lahore, Pk

📌 Responsible for delivering insights to management consulting firms through consultations.📌 Tasked with utilizing the Research-As-A-Service (RaaS) model to connect clients with the latest market expertise.📌 Sourcing insights from a network of over 1 million highly specialized experts.📌 Utilising Artificial Intelligence to ensure timely and secure delivery of data and insights.

📌 Revamped Professional Products Division’s financial model: Recreated over 15 separate sections from the previous financial model, connected them to offline and online Profit and Loss statements, and organized data which readjusted according to different assumptions. Sections like Minorations, Advertising/Promotions, Slow-moving and Obsolete goods were aligned for robustness. A live dashboard within the model was formulated for visualisation. Moreover, personalised navigation bars improved usability, resulting in a much more dynamic, user-friendly model.📌 PPD’s Sales Data Consolidation for PowerBI: Consolidated 18 months' worth of primary and secondary sales data, both for offline and E-Commerce sales. This data laid the foundation for a dynamic PowerBI dashboard, adding valuable insights to the decision-making process.📌 Automation: Leveraged Visual Basic for Applications (VBA) and macros to automate monotonous month-end tasks, simplifying complex processes into single-click solutions such as filtering data according to the month’s requirements, making pivot tables, sending personalised emails etc. 📌 Employer Branding Reel: Created a reel highlighting a glimpse of the unique experiences a L’Oréal internship has to offer.

📌 Financial Integrity: Ensured transparency and accountability in financial statements, achieving 100% audit clearances by aligning with the International Accounting Standards (IAS).📌 Budget Oversight: Worked on formulating annual budgets, tracking variances, and analyzing ratios to guide the region's financial sustainability. Quarterly reports were presented to the general body and the country heads to facilitate informed decision-making.📌 Education Cycle: Embarked on an educational journey through engaging Instagram reels, garnering 32,000+ views and making Finance and Legal the most preferred portfolio for team leader applications, with 34 applicants throughout the term.📌 Legal Duties: Juggled various legal responsibilities from membership and exchange contracts to MoUs, participating in legislative meetings, and organizing a mock legislation for general body members.📌 Financial Strategy: Created a reserve fund and implementing monthly investments from equity and revenue to enhance financial stability.📌 Event Coordination: Collaborated on organizing financially sustainable local and national conferences, contributing to successful outcomes.📌 Risk Assessment: Conducted comprehensive risk assessments across portfolios to ensure a proactive approach to potential challenges.

Maintained the financial statements of the organisation. Hands-on experience with multiple accounting softwares like Odoo and Wave, 100% audit clearances.

Working with the National Head of HR to research, develop, and implement engagement strategies for members nationwide

Assessing applicants based on a two-step recruitment process including case study analysis and personal interviews

📌 Managed accounting and procurement manually for a 3-person finance team, ensuring regulatory compliance.📌 Developed Google Sheets to streamline processes such as tracking software and server details, enhancing cost transparency and proactively identifying anomalies.📌 Conducting budget analysis to improve financial planning and resource allocation, and managed payroll.📌 Helped shift from manual financial operations to automated accounting softwares like QuickBooks and Odoo.

📌Helped organise a seminar delivered by the CEO of Foodpanda in collaboration with the HR department, resulting in an attendance of over 100 students at NUST📌Brought Foodpanda as a sponsor to the NUST Literary Festival to set up a kiosk and market the organisation’s new subscription model-Pandapro

📌Successfully invited 25 delegates from 7 different nationalities to the event📌Held meetings with the Ambassadors of Indonesia, Poland, and Turkey to Pakistan 📌Invited and hosted the Ambassador of Poland to Pakistan H.E. Maciej Pisarski, and the incident manager of World Health Organization (WHO) Dr. Michael Lukwiya as chief guests in the event’s opening and closing ceremonies respectively

📌Sent mass emails to carry out the recruitment process of the organising committee 📌Database Management of over 400 members📌Introduced a live podcast show on the event’s instagram handle (@o_nust) and appeared as a guest on its first episode

Web 3.0 training and analysing social media statistics to plan digital marketing strategies for startups

Cold calling and facilitating customers through the procedures of AIESEC’s outgoing exchange product

Bachelor Of Science - Bs, Economics And Data Analytics, 3.53/4.00

Activities and Societies: -International Linkages Director @NUST International Model United Nations 2023 -Human Resources Executive.

Gcses And A Levels, 9 A/A*S In O Levels, 2 As And 1 B In A Levels