Power Bi Systems Analyst

Kirshna Karthik Reddy

Location: Boston, MA Phone: 603-***-****, Email: ****************@*****.***, Linkedin Business Systems Analyst with 3+ years of experience in consulting, banking, and healthcare, streamlining workflows and improving reporting by up to 30%. Skilled in BRD/FRD documentation, SQL analysis, Power BI/Tableau dashboards, and CRM/ERP integrations (Salesforce, ServiceNow, Dynamics 365). Known for aligning business needs with technical solutions to deliver scalable, user- focused results.

TECHNICAL SKILLS

Data Analysis & Reporting: SQL, Python (Pandas, NumPy), Power BI, Tableau, Excel

Process Modeling & Documentation: BPMN, UML, Visio, Lucidchart, BRD, FRD, Use Cases, User Stories

CRM & ERP: Salesforce, ServiceNow, Microsoft Dynamics 365

Workflow & Automation: Jira, Trello, ServiceNow, Excel Power Query

Testing & QA: UAT planning, test case design, defect tracking

Statistical Analysis: Hypothesis testing, A/B testing, campaign analytics

Methodologies: Agile, Scrum, Sprint Planning, Retrospectives Education

Master in Computer Information System Rivier University, Nashua, NH May 2023 – Dec 2024 Certification

Certified Business Analysis Professional

Microsoft Certified: Power BI Data Analyst Associate PROFESSIONAL EXPERIENCE:

KPMG / R K Software Services LLC Jan 2025 – Present Business System Analyst

Gathered onboarding requirements with stakeholders, reducing cycle time by 15% through improved documentation.

Designed process flows using BPMN/UML in Visio and Lucidchart, streamlining workflows and cutting inefficiencies by 20%.

Authored BRDs, FRDs, and use cases to guide system enhancements with zero rework.

Wrote SQL queries for SLA tracking and performance analysis, improving data accuracy by 25%.

Built interactive dashboards in Power BI, Tableau, and Excel, reducing reporting time by 30%.

Supported CRM/ticketing integrations (Salesforce, ServiceNow, Dynamics 365), enhancing cross- system data access.

Managed deliverables using Jira and Trello, maintaining 100% on-time tracking.

Supported UAT execution and defect tracking, reducing post-launch issues with early feedback loops.

Induslnd Bank Aug 2021 – Mar2023

Business Data Analyst

Collaborated with risk, credit, and analytics teams to define data reporting requirements

Used SQL to extract and join transactional and loan data for performance tracking.

Applied data cleaning and transformation using Python (Pandas) and Excel Power Query to prepare datasets.

Analyzed customer behavior and loan trends to identify repayment patterns and risk indicators.

Supported statistical modeling and performed hypothesis testing to inform business decisions.

Designed Power BI and Tableau dashboards to visualize metrics like default risk, transaction volume, and segmentation, reducing manual reporting by 30%.

Evaluated outreach strategies using A/B testing, increasing campaign engagement by 12%.

Documented project processes, KPI definitions, and business rules to support compliance and transparency.

Maintained data pipelines in Snowflake and SQL-based systems, resolving discrepancies for accurate global reporting.

Presented insights to stakeholders, recommending improvements that reduced reporting turnaround by 10%.

Collaborated with global teams to align data models and ensure consistent metrics across regions.

Apollo Hospital May 2020 - Jun 2021

Business Analyst

Partnered with clinical, operational, and IT teams to gather requirements for patient intake and scheduling improvements.

Mapped current and future workflows using Visio and Lucidchart, conducted gap analysis to identify front-desk inefficiencies, and recommended enhancements to streamline processes.

Drafted BRDs, FRDs, and use cases to support development and process changes.

Designed Power BI and Tableau dashboards to visualize wait times and appointment trends, reducing reporting turnaround by 30%.

Used SQL to analyze patient and service data, identifying bottlenecks and reducing appointment no-shows by 15%.

Supported workflow prototyping in Trello and ServiceNow, and led UAT by reviewing test cases and ensuring user alignment.

Created end-user training materials and facilitated onboarding sessions, achieving 100% adoption rate in the first rollout.

Collaborated with Salesforce and Dynamics 365 teams to enhance CRM/ERP integration for improved patient experience and data consistency.

Academic Projects

1. Healthcare Appointment Analytics and Dashboard Development Developed a data analytics solution to analyze patient appointment data and visualize key operational KPIs to improve scheduling efficiency in a simulated healthcare environment.

Key Responsibilities:

Gathered requirements to define key appointment metrics and reporting needs.

Designed data models and used SQL to extract, clean, and transform appointment data.

Built interactive Power BI dashboards to visualize no-show rates, wait times, and utilization trends for decision-making.

Created Visio process flow diagrams to map current workflows and recommend efficiency improvements.

Documented requirements, dashboard specifications, and user guides to support end-user adoption.

2. Retail Sales Performance Reporting and Process Optimization Designed an end-to-end sales reporting solution for a simulated retail dataset, enhancing performance visibility and informing strategic product placement decisions.

Key Responsibilities:

Analyzed sales data using SQL and Python (Pandas) to identify top products, trends, and regional performance.

Built Tableau dashboards for daily sales, category trends, and inventory turnover, reducing manual analysis by 30%

Created BRDs and FRDs outlining data mappings, business rules, and dashboard requirements.

Mapped sales and inventory workflows using BPMN, identifying inefficiencies and recommending process improvements.

Presented insights and dashboards to stakeholders, demonstrating project value and usability.

Contact this candidate