Pavan Kumar B. Email & Phone Number

San Francisco Bay Area

• Supporting stakeholders by analysis of disparate large, complex marketing data sets across different sources to address strategic and operational business questions. Provided actionable recommendations based on analysis results.•Leveraged advanced data analysis HIVEQL and SQL query skills to extract useful insights from Hive, HDFS on-prem server to generate reports for the leadership team to track the campaign performance.•Implemented data flow and ETL methods using SSIS (SQL Server Integration Services) to integrate diverse marketing data sources such as on-prem data, Salesforce, Google Analytics, Pardot/Eloqua and disparate marketing data.•Developed efficient dashboards and key insight reports for leadership team for their informed decisions by utilizing Tableau, Looker Studio and Salesforce analytics studio by understanding business needs.•Created Marketing influenced pipeline and pipeline velocity metrics, ROI and ACV, Social Media performance metrics, Marketing Email metrics, Hypothesis and A/B testing of tactics.•Expert in creating visually appealing dashboards, data stories, and insightful reports for effective communication.

Data analyst in the Housing department, analyzed student records, and work order analysis with help of SQL queries from databases and Excel to report the insights.

•Utilized advanced analytical tools and SQL queries to analyze large, disparate data sets, identifying whitespace opportunities and solving complex business questions. •Created dynamic dashboards and detailed reports using Tableau and Qlik View, providing clear insights on performance metrics.•Developed predictive pricing models and implemented machine learning algorithms (ARIMA – time series) for price and product demand forecasting•Conducted comprehensive analysis of accounts focusing on revenue, aging, payments, and cash flow, providing actionable insights. •Drove margin targets and profit goals, including forecasting receivables and inventory to ensure alignment with financial objectives.•Automated report generation processes and maintained product sales database tables, enhancing data accessibility and decision-making. •Enrolled and nurtured new B2B leads, tracked pipeline metrics, and utilized business intelligence tools to proactively serve clients.•Collaborated with cross-functional teams to consolidate inputs for updating performance metrics and reports, facilitating informed decision-making. •Played a key role in Project Anubhav, implementing CRM Salesforce and leading the digital transformation initiative for customer service excellence.•Conducted credit analysis and account reconciliation for clients, contributing to data-driven decision-making.•Analyzed market potential through various research initiatives using external data sources and developed complex data models and customized solutions for strategic initiatives.

Master Of Science - Ms, Business Analytics

Bachelor Of Technology - Btech, Mechanical Engineering

Activities and Societies:  Internship in IIT Kanpur - Laser Doppler Vibrometer – vibration analysis in a composite plate using control.

+2, Engineering Physics/Applied Physics

Bachelor Of Technology - Btech, Mechanical Engineering, 3.5