Karnik Kalani Email & Phone Number

San Jose, Ca, Us

San Jose, California, United States

● Designed and implemented over 5 Power BI dashboards to visualize billings, revenue, product margins, and overall product performance, providing leadership and business stakeholders with crucial insights during weekly reviews.● Streamlined weekly sales funnel reporting by integrating Python and Power BI, analyzing 2-week snapshots to extract lead dynamics, new opportunities, losses, and overall trends, saving over 40 man-hours per week for sales directors.● Automated the sharing of… Show more ● Designed and implemented over 5 Power BI dashboards to visualize billings, revenue, product margins, and overall product performance, providing leadership and business stakeholders with crucial insights during weekly reviews.● Streamlined weekly sales funnel reporting by integrating Python and Power BI, analyzing 2-week snapshots to extract lead dynamics, new opportunities, losses, and overall trends, saving over 40 man-hours per week for sales directors.● Automated the sharing of generated reports on SharePoint and to key stakeholders through email by utilizing Power Flow Automate and Power BI Report Builder, integrating them seamlessly with Power BI dashboards.● Spearheaded the consolidation of inventory data from multiple subcontractors, enhancing inventory tracking and conducting precise comparisons with finance-generated reports to identify discrepancies, improving data accuracy and inventory management.● Implemented thorough A/B testing on competitor pricing strategies, conducting meticulous analysis of their influence on revenue and margin dynamics, resulting in a $4 million increase in revenue with minimal decrease in margin points.● Facilitated timely and accurate ad-hoc query analyses for senior management while overseeing the administration of the Nehanet CRM software providing all the data, reports, KPIs, and Admin support for employees.● Conducted comprehensive ROI analysis on new product launches over the past three years, evaluating success and failure rates by considering all development costs. Provided detailed reports on financial performance and strategic recommendations for future product development. Show less

India

● Enhanced data quality by 20% by performing comprehensive data cleaning and wrangling using Python, NumPy, and Pandas, which resulted in high-quality datasets for more accurate analysis and reporting.● Increased decision-making accuracy by conducting advanced statistical analysis with SciPy and creating detailed visualizations using Matplotlib, providing stakeholders with actionable insights.● Boosted stakeholder engagement by 30% by developing interactive dashboards and detailed… Show more ● Enhanced data quality by 20% by performing comprehensive data cleaning and wrangling using Python, NumPy, and Pandas, which resulted in high-quality datasets for more accurate analysis and reporting.● Increased decision-making accuracy by conducting advanced statistical analysis with SciPy and creating detailed visualizations using Matplotlib, providing stakeholders with actionable insights.● Boosted stakeholder engagement by 30% by developing interactive dashboards and detailed reports in Power BI, effectively visualizing complex data trends and key metrics.● Improved report generation speed by streamlining reporting processes using advanced features in Microsoft Excel, including PivotTables and VLOOKUP, ensuring quick and accurate data retrieval.● Reduced query execution time by optimizing data retrieval and management through the development and execution of complex SQL queries on SQL Server, enhancing data access and processing efficiency.● Enhanced data accessibility by implementing scalable data storage solutions on AWS, leveraging services such as EC2, S3, and Lambda to ensure secure and efficient data management.● Increased data processing efficiency by managing and optimizing data warehousing solutions, supporting large-scale data analysis and reporting, and ensuring efficient data storage and retrieval.● Improved system performance and reliability by conducting regular data audits and implementing best practices for data governance and security, maintaining high data integrity.● Ensured timely project delivery and continuous improvement by utilizing Agile methodologies, actively collaborating with cross-functional teams in sprint planning, daily stand-ups, and retrospectives.● Drove informed business decisions by delivering clear and impactful presentations of data insights and findings to stakeholders, leveraging strong communication and presentation skills to convey complex information effectively. Show less

Master Of Science - Ms, Data Analytics

2020, Computer Science, 8.08

Activities and Societies: CESA (Computer engineering students association ) Committee member Instincts 2017’, 2019’ coordinator