Ojas Phansekar
Senior Data Analyst Global Sales Operations @Meta
Signup · Get unlimited contacts
WORK HISTORY
Senior Data Analyst Global Sales Operations @Meta
San Francisco, CA, US
Architected Annual Planning One-View Tableau BI solution for Meta Reality Labs with 5 executive dashboards, 31 worksheets, and 152 calculated fields tracking revenue attainment, unit goals, co-marketing spend, and Channel Services OPEX across Portal and VR.* Designed Partner Performance Tableau dashboard monitoring retailer timeliness, completeness, and accuracy across NA, APAC, and EMEA, classifying 3P Retail, Telco, and Optical partners into KPI-driven performance zones for Sales reviews.* Automated Tableau reporting pipelines via advanced SOQL queries integrating Salesforce CRM, partner, and sales datasets into refreshable BI dashboards, eliminating manual Excel workflows and reducing 36+ bi-weekly reporting hours by 70%.* Led large-scale Salesforce data quality remediation using SOQL and bulk upload tools to resolve missing MSRPs, trade prices, rebates, offer values, and SVPs, cutting resolution time by ~90%.* Owned end-to-end pricing operations and data governance across Oracle Fusion, Catalog Manager, Hive, Google Sheets SSOT, and Salesforce CRM, ensuring accuracy for sales planning, promotions, and rebate calculations.* Built Resource Capacity Planning Tableau dashboard providing leadership visibility into headcount allocation, project utilization, and effort distribution by week, month, and quarter.* Automated Salesforce CRM self-service reporting by connecting reports to Google Sheets via Salesforce Connector with auto-refresh, replacing manual GTM extracts for SKU-product mapping and account setup tracking.* Streamlined high-volume Salesforce account management using bulk upload tools to build placeholder and live retailer account structures for demand planning, reducing manual data entry by ~80%.* Integrated generative AI into analytics workflows to accelerate SQL development, Tableau optimization, pricing gap analysis, and SOP documentation across pricing, trade promotion, and account management.
EDUCATION
Northeastern University
Master of Science, Information Systems
University of the Cumberlands Graduate and Online
Master of Science - MS, Data Science
University of Mumbai
Bachelor of Engineering, Electronics
Udacity
Data Engineering Nanodegree
SKILLS
ABOUT OJAS PHANSEKAR
Senior Data Analyst | Business Intelligence Specialist | Data Storytelling & AutomationResults-driven data analytics professional with ~7 years of experience in business intelligence, data visualization, and predictive analytics across technology, operations, and sales functions. I specialize in transforming complex datasets into actionable insights that drive decision-making, optimize processes, and improve business performance.Currently working at Meta (Global Sales Operations), leveraging SQL, Python, Tableau, Salesforce to build interactive dashboards, deliver advanced analytics, and automate reporting workflows. Pursuing Salesforce Administrator Certification to expand CRM and operational analytics expertise.Core Competencies & Skills: • Data Analytics & Visualization: Tableau, Microsoft Power BI, Salesforce CRM, MS Excel, Google Sheets • Programming & Data Science: SQL, Python (Pandas, NumPy, SciPy), SOQL • Business Intelligence & Reporting: KPI dashboards, Data Quality Management • Automation & Optimization: Workflow automation, Reporting pipelines, Data cleaning & transformation • Collaboration & Agile Delivery: Cross-functional stakeholder engagement, Microsoft VisioCareer Goal:Seeking Business Intelligence Analyst, Data Analyst, or Senior Data Analyst opportunities where I can combine technical expertise, analytical insight, and business strategy to deliver measurable impact. Email: o••••••••@gmail.com Let’s connect if you’re looking for a data-driven, business-focused analytics professional ready to deliver results.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.