Sarvesh Lunia-Data Analytics for Renewable Energy Integration
Check rate
Experience
Data Analytics for Renewable Energy Integration
Harz University
- Created data pipelines and visualization tools to support sustainable energy decision-making
- Developed insights that could optimize renewable energy deployment and grid integration strategies
Business Coordinator
Uniper
- Identified transformation risks (data migration, user adoption) and developed mitigation strategies, achieving 90% automation while maintaining business continuity
- Designed and implemented enterprise Power BI dashboards for IT portfolio management serving C-level executives, IT managers, and operational teams
- Supported requirements analysis for digital products and reporting use cases, translating business needs into structured data outputs and dashboard logic
- Created hierarchical reporting structure enabling drill-down from company-level KPIs to project-level details
- Developed and maintained reporting solutions and automated workflows that provided near-real-time operational insights, reducing manual reporting effort, enabling proactive interventions and better risk control
Automated Data Compression and Archive
Harz University
- Built a system to automatically compress and archive time series data, transferring from InfluxDB to PostgreSQL using Python scripts with scheduled automation
- Reduced storage requirements by 95% while maintaining data integrity and accessibility
Senior Associate
PricewaterhouseCoopers
- Developed automation tools in Google Sheets and Apps Script, saving approximately 230 hours (8,300 USD) annually, and an additional curation tool reducing workload by over 600 hours (36,000 USD) annually
- Delivered analytics solutions using Tableau, Alteryx, and Excel for global consulting clients, demonstrating deep understanding of business KPIs and processes
- Diagnosed and resolved production data issues across People Analytics, Curation and Development teams
- Optimized data flows and queries in Google Sheets/AppScript for large-scale analytics, enhancing reporting for specialist departments
TL – Business Intelligence Analyst
Cars24 Services India
- Analyzed large-scale marketplace transaction and geospatial data (MySQL, QGIS, Tableau) to optimize retail expansion strategy, contributing to 60% store growth and 500,000+ new customers
- Created KPI frameworks and automated dashboards for retail, sales and operations, providing management with a consistent view of store performance and customer growth
- Worked closely with business, sales and operations to understand needs, translate them into structured analyses, and deliver actionable insights
- Specialized in retail KPIs including conversion rates, sales per auction, inventory turnover, and customer acquisition
Retail Location Analysis System
Cars24
- Utilized Tableau, MySQL, and QGIS to identify potential retail locations for the expansion team
- Contributed to a 60% increase in store count and onboarding of 500,000+ new customers
Developer - Reports and Automation
Clik.ai Technologies
- Designed and maintained financial dashboards for commercial real-estate loan servicing in the US and Canada, supporting management of a loan portfolio worth over 350 million USD
- Collaborated with product teams to understand requirements and translate them into reporting logic, dashboards, and automation solutions
- Built HR management systems and process automation tools to improve efficiency and data quality within internal operations
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Automotive, Retail, Energy, Utilities, Professional Services, and Banking and Finance.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, Operations, Sales, Strategy, and Finance.
Summary
Product and analytics professional with experience in product requirements, market-oriented analysis, stakeholder management, reporting, and business decision support across consulting, startup, energy, retail, and finance-related environments. Strong background in KPI development, cross-functional collaboration, digital transformation, and strategic problem-solving, with hands-on exposure to both startup and consulting settings. Well suited to commercial assessment projects requiring market research, customer segmentation thinking, product extension analysis, and roadmap definition.
Skills
- Core Competencies: Product Management And Requirements Analysis | Commercial Assessment And Business Case Thinking | Market Research And Customer Segmentation Support | Strategic Roadmap And Product Planning | Cross-Functional Collaboration With Business And Development Teams | Stakeholder Communication And Presentation | Startup And Fast-Paced Delivery Environments | Consulting-Style Problem Solving And Structured Analysis
- Bi & Reporting: Power Bi, Tableau, Excel, Google Sheets, Dax, Alteryx, Qgis
- Data & Querying: Mysql, Postgresql, Snowflake, Ms Access, Influxdb
- Automation & Programming: Python, Vba, Javascript, Google Appscript, R, Power Apps, Uipath
- Product & Delivery Tools: Servicenow, Azure Devops, Celonis, Sharepoint, Jira, Slack, Miro
Languages
Education
Hochschule Harz
Master’s · Technology and Innovation Management · Wernigerode, Germany
Lovely Professional University
Bachelor’s · Mechanical Engineering · Jalandhar, India
Certifications & licenses
McKinsey.org Forward Program
AI For All: From Basics To GenAI Practice
NVIDIA
Becoming A Product Manager: A Complete Guide
IIBA
PMI Citizen Developer Business Architect (CDBA)
PMI
Celonis Foundations
Celonis
Data Analysis And Presentation Skills: The PwC Approach
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Analytics for Renewable Energy Integration
Nearby freelancers
Professionals working in or nearby Ratingen, Germany
