Power Bi Business Analyst

Pallavi Arora

USA 972-***-**** *******.*******@*******.*** Linkedin Github

EDUCATION

The University of Texas at Dallas (Scholar with Recognition – Special Honors) Master of Science, Business Analytics and Artificial Intelligence GPA 3.6 December 2024

Ashoka University, Sonipat (Scholarship Awardee)

Post Graduate Diploma, Liberal Studies GPA 3.43

July 2021

University of Delhi, Delhi

Bachelor of Commerce (Hons.) GPA 3.15

June 2017

TECHNICAL SKILLS

Languages & Libraries: SQL (MySQL, T-SQL), SAS, Python, R, NumPy, Scikit-learn, PyTorch, TensorFlow, Matplotlib, NLP, EDA, A/B Testing, Predictive Modeling, Decision Trees, Random Forest, SVM, KNN, Ridge, Lasso Regression Tools: Tableau, Power BI, Azure, Snowflake, Oracle, Jira, Splunk, Slack, Alteryx, Microsoft Office (Excel, VBA), Apache Hive, Collibra Concepts & Methodologies: Statistical Analysis, Data Warehousing, Optimization, Agile Methodologies, ETL, ELT, Governance PROFESSIONAL EXPERIENCE

Axis Bank, Mumbai August 2021 – November 2022

Business Analyst (Business Intelligence Unit)

• Designed and executed an A/B test comparing personalized and standard email campaigns for gold loans, resulting in a 9% increase in application rates and a 17% higher engagement rate.

• Collaborated with cross-functional teams, including the Center of Excellence and Sales, on the strategy to expand Gold Loan Offices in the next three financial years to leverage the estimated increase of gold portfolio holdings to 44%.

• Analyzed FY 2021-22 credit basket to ensure 40% ESG-compliant loans using PROC SQL, SAS; created an ESG dashboard for leadership in Power BI, delivering automated reports in collaboration with data engineering.

• Developed automated processes for creating monthly financial statements, including Profit & Loss (P&L) reports, and performed forecasting to support accurate financial tracking and decision-making, using Power BI, VBA and SAS.

• Spearheaded the Priority Sector Lending (PSL) categorization using an agile discovery process to identify eligible MSMEs, resulting in re-tagging loans worth $1.21 million.

• Conducted ad hoc analyses to support business teams in achieving operational goals using SAS, SQL and Excel. Grassroots & Rural Innovative Development, India August 2020 – July 2021 Project Consultant

• Facilitated the establishment of a Solar Microgrid-powered water purification system near Jodhpur, providing 6500+ gallons of potable water & creating a community laundromat that reuses wastewater, resulting in job creation for 30+ families.

• Recommended ways of impact delivery through the inclusion of 7 Sustainable Development Goals (SDGs).

• Created a pitching document to secure key sponsorships from organizations of national importance and received a grant from Facebook & collaboration from National Bank for Agriculture and Rural Development (NABARD) for project implementation. Venus Homoeos, India July 2017 – July 2020

Entrepreneur-Assistant Manager

• Spearheaded technological intervention to dematerialize and centralize invoices and purchase orders, leading to 28% increase in efficiency in pharmaceutical delivery.

• Reformed the matrix organizational framework to streamline workflows, accomplishing the introduction of 7 new lines of products.

• Facilitated the introduction of cloud-based electronic billing system, improving accountability and reducing leakages by over $5000.

• Streamlined the financial reporting and compliance, implementing the GST regime resulting in the reduction of 12% in tax liability. ACADEMIC PROJECTS

Advanced Trading Strategy through Big Data Alpha Model, Fintech & Blockchain - Collaborated in developing a trading strategy using Big Data Alpha Model & R to analyze a diverse portfolio of securities, performing sentiment analysis (NLP), building correlation matrices, and utilizing the Fama-French Three-Factor Model to assess excess returns. Vehicle Sales Forecasting Using Machine Learning, Applied Machine Learning - Crafted a comprehensive predictive model using Python for estimating car prices through feature engineering, meticulous data preprocessing, and rigorous model training. Models trained included several variations of Linear Regression and Random Forests. CERTIFICATIONS

Udacity A/B Testing, Oracle Cloud Infrastructure Generative AI Professional, Agile Project Management, CFA Level 2 Candidate, Tableau Business Intelligence Analyst, Financial Modeling and Valuations, Introduction to SAS I & II, Pendo Product Analytics

Contact this candidate