Shyvalya Vurugonda
Business Analyst @Bigtree Renewable Energy
Signup · Get unlimited contacts
WORK HISTORY
Business Analyst @Bigtree Renewable Energy
Gathered and documented requirements from operations, compliance, and renewable energy trading teams, creating BRDs and user stories in Jira/Confluence to support system upgrades in power generation reporting.• Designed process workflows and ERDs using Visio, BPMN, and UML, identifying inefficiencies in energy distribution and billing systems that reduced reconciliation delays by 15%.• Developed SQL scripts to validate and reconcile energy production and consumption data across Data Warehousing systems, improving reporting accuracy to 98%.• Built Power BI and Tableau dashboards to track KPIs such as energy output, transmission losses, and cost per megawatt, cutting reporting turnaround from 3 days to a few hours.• Automated recurring Excel reports with Power Query, Pivot Tables, and Macros, saving 20+ hours monthly and improving efficiency of energy trading analysis.• Partnered with ETL teams to streamline integration of SCADA ( Supervisory Control and Data Acquisition) data into enterprise reporting systems, enabling near real-time visibility for grid performance.• Collaborated with Salesforce CRM teams to integrate customer billing and engagement data with renewable energy consumption reports, increasing accuracy of sustainability program tracking by 12%.• Conducted UAT and QA testing for energy management system enhancements, preparing test cases, logging defects, and ensuring a 95% first-cycle pass rate.• Performed gap analysis and cost-benefit evaluations of legacy reporting processes, recommending automation initiatives that reduced operational costs by 10%.• Validated regulatory compliance datasets to ensure alignment with FERC and ISO standards, minimizing audit exceptions and improving audit readiness.• Presented data-driven insights to senior leadership using Python-based analysis and BI dashboards, directly influencing capacity planning and renewable project investments.
EDUCATION
University at Buffalo
Master's degree
ABOUT SHYVALYA VURUGONDA
I’m a Business Analyst with 4+ years of experience working at the intersection of data…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.