San Diego, California, United States
Greetings, and welcome to my LinkedIn profile! I’m Rohit, a Data & Business Analyst passionate about transforming data into meaningful insights that drive decisions. With expertise in data visualization, predictive analytics, and automation, I specialize in solving real-world challenges across sustainability, healthcare, and pharmaceutical consulting. I hold a Master’s in Business Analytics from UC San Diego, where I gained hands-on experience with machine learning, optimization, and cutting-edge analytical tools. At Context Nature, I analyzed biodiversity risks across 431 global supplier sites using ArcGIS, SQL, and Tableau, helping businesses make informed ecological decisions. I also optimized ESG reporting workflows with AI, reducing manual efforts by 85%. Previously, as a Business Analyst at ZS, I built Tableau dashboards tracking $46B in pharmaceutical product performance, developed AWS-based ETL pipelines, and automated workflows, improving data refresh cycles. What drives me? I’m driven by curiosity—whether forecasting trends, optimizing pricing, or building AI-driven solutions, I enjoy turning data into actionable strategies. Technical Skills: 📊 Data Visualization & BI – Tableau, Power BI, Amazon QuickSight, Excel 📈 Analytics & ML – Predictive & Prescriptive Analytics, Python (Pandas, Scikit-Learn), R 🛠️ Data Engineering – SQL, PostgreSQL, Alteryx, AWS (S3, Redshift, Bedrock) 🌍 Geospatial & ESG Analytics – ArcGIS, Sustainability Data Analysis If you’re looking for someone who blends technical expertise with business acumen to unlock data-driven opportunities, let’s connect!
Mentored 120+ students in statistics, Python for data analytics, and business intelligence, fostering data-driven decision-making through visualization and storytelling. 🔹 Led office hours and work sessions, simplifying complex programming and Tableau concepts for real-world applications. 🔹 Assessed assignments to ensure a practical understanding of data preparation, visualization, and strategic insights. 🔹 Guided students in transforming raw data into actionable insights, enhancing their analytical thinking and problem-solving skills. This experience strengthened my ability to distill complex ideas, mentor aspiring analysts, and cultivate a data-centric mindset.
Led data-driven ESG and AI initiatives, transforming raw data into strategic insights for sustainability and compliance. 🔹 Biodiversity Risk Analysis – Assessed the impact of 430+ global supplier sites on biodiversity using ArcGIS, SQL, and Tableau, identifying high-risk locations and proposing mitigation strategies aligned with TNFD frameworks. 🔹 AI-Powered Text Extraction – Tested and optimized agentic AI workflows with Python, evaluating GPT-4, Claude, and Ollama, enhancing text extraction accuracy by 58% while reducing manual effort by 85%. 🔹 Decision-Support Chatbot – Developed a custom LLM-powered assistant by pre-training a foundational model (Amazon Titan) with structured JSON data, improving regulatory compliance workflows. This role strengthened my expertise in ESG analytics, LLM optimization, and AI-driven decision-making, enabling me to bridge data science with sustainability and automation.
Worked with a Fortune 500 pharmaceutical client, leveraging data-driven insights for strategic decision-making. 🔹 Data Analytics & Visualization: Built Tableau dashboards tracking $46B in pharmaceutical sales & marketing performance. 🔹 ETL & Automation: Developed an AWS-based ETL pipeline (Glue, S3, Redshift) with 99% accuracy, cutting retrieval time by 40%. Automated 15+ workflows using PostgreSQL & Alteryx, reducing errors by 22%. 🔹 Process Optimization: Created a Python-based data inventory tool, optimizing metadata management for 300+ reports, cutting redundant purchases by 10%. 🔹 Collaboration & Leadership: Bridged business & technical teams, ensuring actionable insights. Trained 34 team members on analytics best practices. 🔹 Innovation & Research: Evaluated emerging BI tools, enhancing data storytelling and personalized analytics. This role honed my ability to translate complex data into actionable insights while collaborating across technical and business teams.