Jainam Jain

Operations Associate

Ahmedabad, Gujarat, India1 yr 9 mos experience

Key Highlights

  • Expert in SQL and Power BI for data-driven insights.
  • Proven ability to identify and resolve execution bottlenecks.
  • Strong background in analytics bridging technical and business teams.
Stackforce AI infers this person is a Data Analyst specializing in Renewable Energy and Digital Marketing analytics.

Contact

Skills

Core Skills

Data AnalysisBusiness Intelligence (bi)Operational AnalysisBusiness Analysis

Other Skills

SQLMicrosoft Power BIKPI DashboardsGoogle SheetsPower BIRedashData CleaningExcelKPI AnalysisMicrosoft ExcelCommunicationProblem SolvingData VisualizationStatistical AnalysisCritical Thinking

About

Data & Operations Analyst at Solarium Green Energy, supporting planning, execution, and performance analytics across large-scale solar EPC projects using SQL, Power BI, and Google Sheets. I help leadership and cross-functional teams turn project and operations data into execution clarity, KPI visibility, and data-driven decision-making. I bring a business-first lens from my earlier experience in digital marketing and sales, which helps me understand how KPIs, timelines, and execution gaps directly impact revenue, delivery, and stakeholder confidence. This allows me to build analytics that are practical, actionable, and aligned with real business outcomes. Here’s what I work on in practice: • Build and maintain end-to-end project performance dashboards (Google Sheets & Power BI) to track milestones, timelines, and KPIs across Survey, Design, Procurement, Projects, and Accounts teams, enabling early visibility into delays and risks. • Use SQL (via Redash) to query and structure operations data, improving reporting accuracy, reducing manual effort, and supporting weekly and monthly performance reviews. • Analyze stage-wise progress and dependency data to identify bottlenecks, delays, and process gaps, helping teams re-prioritize tasks and improve turnaround times. • Design MIS and tracking frameworks to monitor task ageing, resource utilization, and status variance, bringing transparency and accountability across multiple ongoing sites. • Serve as the analytics bridge between technical, commercial, and finance teams, translating complex data into clear insights that support planning, follow-ups, and management decisions. My work sits at the intersection of data analysis, operations analytics, business intelligence, and decision support. If you’re looking for someone who combines data analysis, operations ownership, and strong business understanding, I’d be happy to connect. 📩 jainjainam07@gmail.com Let’s connect and explore how data can drive execution excellence and smarter business decisions.

Experience

1 yr 9 mos
Total Experience
11 mos
Average Tenure
10 mos
Current Experience

Solarium green energy limited

Data & Operations Analyst (Planning & Strategy)

Aug 2025Present · 10 mos · Ahmedabad, Gujarat, India · On-site

  • Lead end-to-end analytics for 100+ solar EPC projects, tracking planning, milestones, dependencies, delays, and closures across the full lifecycle.
  • Develop and optimize SQL queries (CTEs, Joins) in Redash/MySQL to extract and validate 10k+ rows of project, procurement, and finance data for weekly and monthly MIS.
  • Build and maintain 15+ dashboards and track 25+ KPIs covering timelines, task ageing, and milestone slippages.
  • Identify 5–10 execution bottlenecks per month through stage-wise analysis, enabling data-driven prioritization.
  • Serve as the analytics bridge across Survey, Design, Procurement, Projects, and Accounts teams, translating operational data into management insights.
SQLMicrosoft Power BIData AnalysisOperational AnalysisKPI DashboardsBusiness Intelligence (BI)

Career break

Career transition

May 2025Aug 2025 · 3 mos · Ahmedabad, Gujarat

  • Took a planned career break to transition into Data & Business Analytics by completing hands-on courses in SQL, Power BI, Excel and currently learning Python.
  • Built end-to-end analytics projects (Sales, Finance, Operations) involving data cleaning, KPI analysis, SQL querying, and dashboarding in Power BI & Excel to gain practical, job-ready experience.
  • Strengthened problem-solving and business analysis skills through real-world case studies, which directly supported my move into a Data & Operations Analyst role at Solarium Green Energy.
SQLPower BIExcelData CleaningKPI AnalysisData Analysis

Blue chip clicks

Business Development Executive

May 2024Apr 2025 · 11 mos · Ahmedabad, Gujarat, India · On-site

  • Built and managed Excel-based lead funnel trackers for 300+ prospects, structuring data into Hot/Warm/Cold stages, meetings, and 30+ closures across Google Ads, SMM, and Website projects.
  • Logged and analyzed 700+ calls and email interactions, tracking conversion stages and follow-up cycles to improve pipeline visibility.
  • Analyzed call-to-meeting and meeting-to-deal conversion rates to identify funnel leakages and support data-driven sales planning.
  • Created weekly performance reports highlighting outreach volume, response rates, and deal progress for founder-level review.
  • Standardized lead tracking formats and reporting logic, improving data consistency and follow-up prioritization across campaigns.
Microsoft ExcelData AnalysisCommunicationProblem SolvingBusiness Analysis

Education

Janardan Rai Nagar Rajasthan Vidyapeeth University

Bachelor of Education - BEd — Mathematics

Jan 2019Jan 2021

Mohanlal Sukhadia University

Bachelor of Science - BS

Jan 2016Jan 2019

Stackforce found 100+ more professionals with Data Analysis & Business Intelligence (bi)

Explore similar profiles based on matching skills and experience