I'm a data and marketing analyst with 3.5+ years of experience driving business impact through insights. From building dashboards to optimizing campaigns, I turn complex data into clear, actionable strategies using Power BI, SQL, and Python.
Comprehensive, well-rounded, and strategic — here's how I solve problems with data.
Providing a range of services to help businesses make data-driven decisions and achieve their goals.
Uncovering actionable insights through deep analysis using Excel, SQL, and Python.
Building dashboards and reports using Power BI, Tableau, and Data Studio to track KPIs and business metrics.
Analyzing campaign data, A/B tests, user funnels, and product engagement to drive growth.
Turning complex data into intuitive visuals that support data-driven decisions.
Building predictive models for forecasting, segmentation, and optimization using Python.
A deeper look at how I’ve applied data to solve business problems, optimize systems, and deliver results.
ACE Solar (Jan 2025 – May 2025)
At ACE Solar, I joined the analytics team during a growth phase where manual data entry and disconnected reporting slowed down operations. My goal was to streamline CRM data capture and improve sales performance visibility.
I deployed an AI-powered OCR system using Google Cloud Vision API to extract data directly from site inspection photos, which reduced CRM entry time by over 70%. I also built Power BI dashboards integrating HubSpot CRM and Google Analytics, helping the sales team track funnel performance and increase lead conversion by 18%.
To ensure accuracy in internal reports, I automated data validation using Google Sheets, VLOOKUP, and VBA, significantly reducing reconciliation errors.
Worcester Polytechnic Institute (May 2024 – Feb 2025)
I worked closely with academic operations to transform how WPI tracked and forecasted enrollment trends. My main focus was to develop automated pipelines and performance dashboards for internal departments.
I designed SQL pipelines in Azure using joins and CTEs to automate reporting workflows, which cut prep time by 40%. My Power BI dashboards used DAX and RLS for dynamic, role-based reporting.
I also built Python-based time series models to forecast student intake, improving strategic planning accuracy by 25%.
Worcester Polytechnic Institute (Aug 2023 – Dec 2024)
I contributed to academic research projects that involved large-scale survey data and behavioral metrics. My role centered around structuring and automating data flows for analysis.
I standardized JSON survey data for use in SmartPLS and built Python pipelines to clean and validate over 12,000 behavior records, accelerating research cycles and minimizing preprocessing errors by 30%.
WebCraft IT (Jan 2022 – Jun 2023)
My responsibilities at WebCraft focused on performance analytics, campaign optimization, and automating reporting systems. I collaborated with developers and marketing teams to deliver real-time insights.
I optimized reporting in BigQuery and built Power BI dashboards and Excel macros for multi-platform sales tracking. I conducted A/B tests using Python and statsmodels, improving ad conversion rates by 15%.
Eynosoft Pvt. Ltd. (May 2021 – Dec 2021)
I worked alongside the BI team to integrate disparate data sources and automate manual business reports. This role introduced me to foundational tools and business problem-solving.
I developed Tableau dashboards using data from SQL Server, Excel, and CSV files. I also supported the implementation of ETL logic for ongoing reporting automation.
Highlighting some of the key projects I have worked on and the impact they have made.
Feel free to reach out for any inquiries or collaborations.
Address: Boston, MA, USA
Phone: +1 (508) 410-4802
Email: [email protected]
LinkedIn: linkedin.com/in/vishalpatidar91