Los Angeles Power Bi

SHRUTI PARULEKAR

Los Angeles, CA 213-***-**** ******.***********@*****.*** linkedin.com/in/parulekarshruti EDUCATION

University of Southern California, Marshall School of Business Los Angeles, CA August 2022-May 2024 Master of Science in Business Analytics (STEM), Data Science Track University of Mumbai Mumbai, India August 2015-May 2019 Bachelor of Engineering in Computer Engineering

TECHNICAL SKILLS

Programming Language: Python (Matplotlib, Pandas), R, MySQL, VBA (for Excel automation). Tools and Technologies: Microsoft Power BI, Tableau, Google Search Console, Similarweb, Google Analytics (web analytics). Certifications: AWS Certified Cloud Practitioner, Advanced Google Analytic. EXPERIENCE

Business Analyst, Acxiom, Conway, Arkansas, US May 2023-May 2024

● Performed monthly audits on performance and productivity data, ensuring compliance with criteria enhancing accuracy by 20%.

● Formulated an insightful dashboard using Google Looker Studio, identifying KPIs to analyze customer behavior trends.

● Enhanced data extraction efficiency by 40% through strategic ETL optimization and precise SQL queries utilizing GoogleBigQuery.

● Automated data pipeline with Python, reducing processing time by 30% and enhancing internal processes to better efficiency.

● Collaborated with special projects, including data analysis and bonus modeling, enhancing presentation quality for key meetings.

● Handled 20+ clients in Salesforce platform ensuring 100% adherence to data governance principles through meticulous due diligence. Business Intelligence Analyst, University of Southern California, Los Angeles, CA, US January 2023-May 2023

● Developed Power BI dashboards for real-time water consumption tracking, providing better insights into irrigation meter usage.

● Refined decisions and data quality resulted in 20% fewer data reporting errors such as sensor malfunctions and missing data.

● Improved data collection and reporting processes, achieving a 10% increase in operational efficiency cutting data errors.

● Translated technical insights from Power BI optimization efforts to VP of the department, facilitating better decision-making. Data Analyst (Digital Marketing), MasterTech Web Applications LLP, Mumbai, India June 2019- July 2022

● Leveraged Google Analytics and external data to analyze user behavior, to inform website optimizations that improved metrics.

● Revamped website content to align with branding guidelines, ensuring consistent messaging boosting engagement by 30%.

● Analyzed market trends to refine marketing strategies, boosting campaign effectiveness by 25%; produced key reports.

● Improved e-commerce marketplace performance, implementing SEO enhancements leading to 15% rise in conversion rates.

● Led an analytics initiative to perform extensive root cause analysis for newsletter sign-up pages, optimizing for customer acquisition.

● Crafted insightful strategies analyzing 20,000 monthly active user data, doubling user experience and slashing bounce rates by 30%.

● Coordinated communications and trained 4+ interns to enhance engagement with existing employees, boosting retention. ACADEMIC PROJECTS

Starbucks Rewards Revitalization (Class Project) January 2024

● Conducted quantitative research utilizing K-means clustering to identify 3 clusters, resulting in a 15% increase in retention rates.

● Leveraged SPSS software to perform regression to influence customer retention, achieving a 30% reduction in customer churn rate.

● Enhanced rewards program visibility, leading to a 15% increase in enrollment rates and a 20% boost in engagement metrics. USC Students Lyft Services Satisfaction and Future Retention Analysis (Class Project) December 2023

● Conducted USC Students Lyft Services Satisfaction and Future Retention Analysis, utilizing Qualtrics for data collection and analysis.

● Employed techniques like Cluster Analysis to identify user clusters for customer segmentation and tailor programs to their needs.

● Improved conversion and retention rates; and emphasized data-driven decision-making to enhance overall service quality. Supply Chain Optimization Power BI Dashboard Development (Healthcare Case Competition -2nd Prize) March 2023

● Developed a PowerBI dashboard to streamline the supply chain of a biotech company, addressing challenges and delivery of kits.

● Optimized kit delivery with 3 dashboards: Overview, Activity Tracker, and Alert Dashboard, ensuring real-time visibility.

● Led data cleaning, addressing duplicates, missing, and erroneous values, enhancing data accuracy and reducing memory usage.

● Achieved 10% reduction in lead time, and 7% increase in on-time deliveries, reflected in dashboard metrics.

● Provided recommendations for metric tracking within the warehouse management for kit storage and distribution processes. LEADERSHIP SKILLS

● Established @stitchyourlife_ as a Social Media Influencer and Podcaster, securing 5 brand collaborations and 1.2K followers.

● Volunteered at SarkariSchool.in and served as Vice President at Marshall Business Case Competition Club, USC.

● Awarded a diversity-based scholarship by Acxiom. RELEVANT COURSEWORK

● Consumer Insights and Analytics: Market Research, Consumer Behavior Analysis, Customer Segmentation, Consumer Trends.

● Databases: Database Management, Query Optimization, Relational Databases, SQL Queries, BigQuery, A/B Testing.

● Data Visualization: Tableau, Data Governance, Data Analysis, data synchronization, Business Analysis, Microsoft Office.

Contact this candidate