Power Bi Business Analyst

Pranav Sai Reddy Yedulla

Chicago, IL 217-***-**** ************@*******.***

Professional Summary

Business Analyst with 4+ years of experience spanning digital media analytics, supply chain operations and financial planning. Adept at transforming business needs into data-driven insights and reporting solutions using SQL, Power BI, Tableau, Python and advanced Excel. Demonstrated ability to build automated dashboards and forecasting models that reduce manual reporting time, streamline production workflows and support strategic decision-making. Experienced with Deltek Costpoint, Oracle ERP, IBM Planning Analytics (TM1) and government contract reporting requirements. Known for collaborating with cross-functional teams, training users on analytical tools and improving data accuracy and com- pliance.

Technical Skills

• Data Analysis & Visualization: Power BI, Tableau, Excel (Advanced – Piv- otTables, VLOOKUP, forecasting, macros), IBM Planning Analytics (TM1)

• Database & Querying: SQL (Oracle, SQL Server – data extraction, joins, optimization)

• Financial & ERP Systems: Deltek Costpoint, Oracle ERP, SAP (basic navi- gation), budget variance reporting, capital expenditure analysis, financial forecasting

• Requirements & Documentation: BRD, FRD, user stories, use case devel- opment, gap analysis, UAT coordination

• Business Process Modeling: BPMN, flowcharts, swimlane diagrams (Lucid- chart, MS Visio)

• Project & Collaboration Tools: JIRA, Confluence, Trello, Mi- crosoft Teams, Slack

• Programming & Scripting: Python (Pandas, NumPy – data manipulation and analysis)

• Cloud & Data Platforms: Azure Data Factory, AWS S3, SharePoint

• Agile & Scrum: sprint planning, daily stand-ups, backlog grooming, retro- spectives

• Communication & Presentation: PowerPoint, Google Slides, execu- tive-level reporting

• Version Control & Documentation: GitHub, Google Docs, SharePoint Professional Experience

Data Analyst – ComScore, Illinois, USA Jan 2024 – Feb 2025

• Collected, cleaned and analyzed large digital media datasets using SQL (Ora- cle,SQL Server), Excel and Python to ensure data integrity.

• Designed automated Power BI and Tableau dashboards to visualize KPIs, campaign trends and performance metrics, reducing manual reporting time by 25%.

• Developed forecasting models in IBM Planning Analytics (TM1) to support campaign planning and budgeting.

• Utilized Deltek Costpoint to track financial reports and monitor internal pro- ject costs.

• Performed ad-hoc analyses and delivered data-backed insights to improve au- dience targeting and strategic decision making.

• Collaborated with marketing and analytics teams to optimize campaign effec- tiveness.

• Provided user training and troubleshooting for dashboards and planning tools. Business Analyst – Operations & Supply Chain, HBL Power Systems Ltd, India Mar 2021 – Jun 2023

• Analyzed high-volume production and operational data to identify inefficien- cies, achieving a 10% reduction in cycle time through workflow redesign.

• Developed Power BI dashboards to monitor KPIs, production metrics and supply chain performance, enabling real-time decision making.

• Partnered with engineering, procurement and logistics teams to streamline operations, accelerating turnaround times and reducing costs.

• Conducted root cause analysis on quality issues and delivery delays, leading to improved product reliability and reduced rework rates.

• Built demand forecasting models to optimize raw material procurement and prevent stockouts or overstocking.

• Automated repetitive data tasks and improved reporting efficiency, reducing manual effort by 20%.

• Participated in supply chain risk assessments and recommended mitigation strategies for vendor-related risks.

• Enhanced ERP system data accuracy by coordinating with IT, improving consistency across planning and reporting tools.

• Used Deltek Costpoint and Oracle ERP to support financial tracking, project reporting and cost monitoring.

• Created financial and operational forecasting models using Excel and IBM Planning Analytics (TM1) to aid procurement and budget planning.

• Performed cost-benefit analyses for major initiatives, identifying savings op- portunities while maintaining compliance.

• Prepared monthly performance reviews, variance analyses and executive summaries for senior leadership.

• Provided training and support on dashboards and ERP-based financial tools, ensuring user adoption.

Business Analyst Intern – Darwinbox, India Aug 2020 – Jan 2021

• Gathered client requirements and documented HR process flows for the rollout of Darwin box HCM modules (attendance, payroll, onboarding).

• Conducted “as-is” versus “to-be” process comparisons and supported gap analysis to expedite approvals and configuration.

• Created structured data templates and Excel summaries to ensure clean em- ployee records prior to system go-live.

• Prepared job aids, addressed user queries and logged enhancement requests to support user training.

• Coordinated user acceptance testing (UAT), captured issues and ensured res- olution before product launch.

Education

Master of Science in Management Information Systems, University of Illinois Springfield, Illinois, USA

Bachelor of Technology in Electrical and Electronics Engineering, Jawaharlal Nehru Technological University Hyderabad (JNTUH), India

Contact this candidate