Business Analyst Power Bi

Avinash Achyutha

314-***-**** ****************@*****.*** Linkedin

EDUCATION

Master of Arts in Information Technology Management Mar 2023 - Mar 2025 Webster University-St Louis, Missouri

SKILLS

Methodologies: SDLC, Agile/Scrum, Waterfall

Programming & Query Languages: Python, R, SQL

Project Management Tools: Smartsheet, Microsoft Office (PowerPoint, Excel), MS Project, Primavera, JIRA Documentation & Tracking Tools: FRD, BRD, SRS, Microsoft Visio, HP Quality Center, Rational ClearQuest, RTM Collaboration & Development Tools: JAD, UAT, Confluence Data Analysis & Visualization: Data interpretation, dashboarding (Tableau, Power BI), reporting, predictive analytics Strategic Planning & Execution: Cost/benefit analysis, impact analysis, GAP analysis, risk analysis, SWOT analysis Process Documentation & Improvement: Business process mapping, workflow optimization, SOP creation Vendor & Tool Analysis: Evaluation, ROI assessment, procurement support Client Reporting & Communication: Stakeholder updates, KPI tracking, presentation decks Project Management: Agile/Waterfall execution, resource allocation, timeline management EXPERIENCE

PNC Financial Services,USA Aug 2024 – Current

Business Analyst

• Facilitated Joint Application Development (JAD) sessions to gather requirements, ensuring stakeholder alignment and creating detailed Functional Requirement Documents (FRDs) for banking system enhancements.

• Conducted GAP analysis to identify discrepancies between current and desired business processes, recommending solutions to streamline operations and improve efficiency.

• Utilized Microsoft Visio to design business process maps and visualize workflows for loan processing systems, enhancing clarity and stakeholder understanding.

• Executed Agile/Scrum methodologies, participating in sprint planning and daily stand-ups to deliver iterative improvements for financial reporting tools.

• Performed cost/benefit analysis to evaluate proposed system upgrades, presenting findings in PowerPoint decks to senior management for approval.

• Leveraged SQL queries to extract and analyze customer data, supporting the development of predictive analytics models for credit risk assessment.

• Managed User Acceptance Testing (UAT), coordinating with QA teams using HP Quality Center to validate system functionality against business requirements.

Orion Technolab, India Jan 2019 - Apr 2023

Business Analyst

• Developed comprehensive Business Requirement Documents (BRDs) and System Requirement Specifications

(SRS) to support the implementation of enterprise software solutions.

• Utilized Tableau for data visualization, creating interactive dashboards to track project KPIs and provide actionable insights to stakeholders.

• Conducted SWOT analysis to evaluate vendor tools, aiding in procurement decisions by assessing ROI and alignment with business objectives.

• Managed project timelines and resource allocation using MS Project, ensuring on-time delivery of software development projects under Waterfall methodology.

• Created Standard Operating Procedures (SOPs) to document optimized workflows, improving team efficiency and compliance with organizational standards.

• Tracked project requirements and defects using JIRA and Confluence, maintaining Requirement Traceability Matrices (RTMs) to ensure complete coverage.

• Performed impact analysis to assess the effects of system changes on existing processes, mitigating risks during software upgrades.

• Supported client reporting by developing Excel-based reports and Power BI dashboards, presenting performance metrics to stakeholders for strategic decision-making. PROJECTS

Streamlined Order-to-Cash (O2C) Process Optimization Role: Business Analyst Tools: Visio, Excel, Power BI

• Mapped and analyzed the O2C workflow for a retail client, identifying delays due to manual approvals.

• Used historical data to reveal a 20% lag in fulfillment; implemented automated workflows to reduce bottlenecks.

• Led cross-functional workshops to align process improvements. Outcome: Cut processing time by 25%, saved 10 hours/week, and boosted customer satisfaction by 15%. Customer Segmentation for Marketing Strategy

Role: Business Analyst Tools: SQL, Python, Tableau

• Conducted cluster analysis on customer data to create actionable marketing segments.

• Collaborated with marketing to design targeted campaigns, increasing ROI by 18% and reducing churn by 10%.

• Built a dashboard for ongoing campaign and customer behavior tracking.

• Outcome: Enhanced personalization and campaign performance, with insights driving 30% higher response rates.

Contact this candidate