Business Analyst Intelligence

Govind Ruthwik Baba Puchcha

Business Analyst

+1-203-***-**** *****************@*******.*** https://www.linkedin.com/in/puchchagrb Summary

Strategic Business Analyst with 5+ years of experience in stakeholder analysis, business intelligence, process optimization, and KPI definition to drive data-driven decision-making and business case development. Adept at leading change management initiatives and implementing scalable solutions to improve efficiency across Healthcare, IT, and Finance industries. Expert in leveraging SQL, Power BI, Tableau, Python, cloud platforms (AWS, GCP), and API documentation to deliver data-driven solutions, streamline workflows, and enhance regulatory compliance. Proven success in automating business processes, enhancing performance metrics, and improving decision-making through effective use of Agile methodologies and cross-functional collaboration. Adept at identifying inefficiencies, developing scalable solutions, and translating complex business needs into actionable insights, driving growth and profitability for organizations. Skills

Data Analytics & Business Intelligence Tools: SQL, Tableau, Figma, Roadmap, Microsoft Access, Google Analytics, Data Modeling, Data Visualization, Business Intelligence (BI), Data Analytics, Power BI, QlikView, Advanced Excel, Excel Pivot Tables, Regulatory Risk Analysis, Data Governance, Investment Analysis, Supply Chain Analytics, Predictive Analytics. Programming & Database Management: SQL, Python, Financial Modeling, Budgeting, FP&A (Financial Planning & Analysis), Cost/benefit analysis, Impact analysis, GAP analysis, Risk analysis, Regulatory Compliance (SOX), Capital Markets Analysis, SWOT analysis.

Healthcare Data & Compliance: Medicaid, HIPAA, CMS, Encounter Data Processing, ICD Codes, EHR/EMR Systems, HL7 Standards, Claims Adjudication, Healthcare Analytics, Patient Engagement Metrics, Logistics Optimization. Project Management & Collaboration Tools: JIRA, Trello, Microsoft Visio, Smartsheet, Confluence, MS Project, MS SharePoint, Rational ClearQuest, Azure DevOps.

Process & Requirements Management: RTM (Requirements Traceability Matrix), UAT (User Acceptance Testing), JAD (Joint Application Development), Business Requirements (BRD), Functional Requirements Document (FRD), Software Requirements Specification (SRS), Use Case Mapping, User Stories, Test Plans, Test Cases, Test Outlines, Prototypes, Standard Operating Procedures (SOPs), Business Process Reengineering. Cloud & Integration Technologies: Cloud Platforms (AWS, GCP), REST APIs, API Documentation, Microservices Architecture, ETL/ELT Processes, ERP Systems, SaaS Platforms, DevOps Collaboration, CI/CD Pipelines, Cybersecurity Compliance Considerations.

Methodologies: Agile (Scrum & Kanban), Waterfall, Lean Six Sigma, SDLC. Soft Skills: Strategic Thinking & Data-Driven Decision-Making, Stakeholder Analysis, Stakeholder Management and Communication & Cross-Functional Collaboration, Business Case Development, Process Mapping, Problem-Solving & Analytical Skills, Project Management Skills, Change Analysis and Change Management, and Adaptability & Priority Management Work Experience

True-Care Pharmacy LLC, USA Business and Operations Analyst January 2024 – Present

● Designed and deployed automated Medicaid claim validation protocols, reducing claim denials by 35% and improving reimbursement efficiency through enhanced Encounter Data Processing (EDP).

● Developed and implemented Power BI dashboards to track pharmacy KPIs, improving real-time decision-making and increasing reporting efficiency by 40% for leadership teams.

● Led workflow automation initiatives in prescription fulfillment, leveraging pharmacy management software to reduce manual processing time by 30% and enhance operational efficiency.

● Optimized inventory forecasting models using predictive analytics, leading to a 15% reduction in overstock while ensuring critical medication availability for patients, and also keeping in mind the brand to generic ratio for medications.

● Established a compliance tracking framework ensuring full HIPAA, CMS, and Claims Adjudication adherence, while reducing manual reporting workload by 40% through automation.

● Integrated EHR (Electronic Health Record) system enhancements and HL7 data standards to streamline patient record management, ensuring compliance and interoperability across platforms.

● Spearheaded a POS and CRM integration project, aligning pharmacy transactions with patient engagement strategies, resulting in more than 1/3rd reduction in transaction times and enhanced customer experience.

● Orchestrated root cause analysis on rejected claims, uncovering systemic billing errors; implemented corrective workflows, resulting in a 20% increase in claim approval rates.

● Enhanced pharmacy performance analytics, introducing targeted patient engagement strategies that improved customer retention by 20% through personalized medication adherence programs.

● Collaborated with IT and compliance teams to implement automated auditing processes, ensuring 100% regulatory adherence for Medicaid and CMS compliance requirements.

● Conducted financial and operational risk assessments, utilizing data-driven cost management strategies to reduce expenses by 1/5th of what it was before, while maintaining optimal patient care services.

● Led Agile sprint planning and backlog refinement in JIRA, improving cross-functional collaboration and increasing sprint completion rates by 25%.

● Standardized pharmacy reporting procedures, providing executive leadership with actionable data insights to drive strategic growth and operational enhancements.

Datapro Information Technology Pvt Ltd, India Business Analyst July 2020 – July 2022

● Led an enterprise-wide automation initiative using SQL, Python, and ETL processes, streamlining workflows and increasing operational efficiency by 40%, significantly reducing reliance on manual processes.

● Designed and deployed SQL-powered Tableau and Power BI dashboards, enhancing financial forecasting accuracy by 20% and improving executive decision-making.

● Managed the transition to an upgraded ERP system, overseeing data migration, API integrations, microservices-based architecture, API documentation, and process standardization with zero downtime.

● Conducted in-depth business process audits using BPMN and Lean Six Sigma methodologies, identifying inefficiencies and driving improvements that resulted in approximately $77,000 in annual cost savings.

● Contributed to financial modeling initiatives and budgeting analysis, supporting executive decision-making and aligning with regulatory compliance frameworks including SOX.

● Implemented Agile best practices using JIRA and Confluence, working closely with Product Owners and cross-functional teams to optimize backlog management and reduce project delivery timelines by 25%.

● Collaborated closely with DevOps teams to streamline CI/CD pipelines, ensuring smooth deployment of ETL workflows and secure cloud-based integrations (AWS, GCP).

● Established enterprise-wide data governance policies, leveraging SQL, Power Query, and REST APIs to improve data accuracy, security, and reporting consistency across business systems.

● Developed a KPI tracking system using Power BI, Excel Pivot Tables, and QlikView, enabling real-time performance monitoring and increasing operational transparency for senior leadership.

● Authored comprehensive Business Requirements Documents (BRD), Functional Requirements Documents (FRD), and User Stories using JIRA and Confluence, improving cross-functional collaboration and project clarity.

● Led Joint Application Development (JAD) sessions and Use Case Mapping workshops with Product Owners, Developers, and Stakeholders, reducing development rework and accelerating product deployment timelines.

● Conducted cost-benefit analyses leveraging Power BI and SQL, optimizing resource allocation and reducing operational costs by 15%, while maintaining efficiency.

● Developed a risk assessment framework for compliance adherence, integrating Salesforce CRM, REST APIs, and ETL processes, improving risk mitigation strategies and financial security. Associate Business Analyst April 2018 – July 2020

● Conducted gap analyses and process evaluations to identify inefficiencies, leading to a 30% improvement in operational workflows.

● Developed SQL-based reports for financial data retrieval, reducing query execution time by 50% and improving accessibility for stakeholders.

● Supported ETL pipeline optimization by assisting in data validation and transformation processes, enhancing data consistency across systems.

● Assisted senior analysts in mapping business workflows using BPMN, contributing to improved documentation and process understanding.

● Automated compliance tracking reports using Excel macros and SQL queries, reducing manual effort and increasing data accuracy.

● Collaborated with the data team to integrate business intelligence tools, enabling real-time reporting for executive decision-making.

● Facilitated stakeholder interviews and gathered business requirements, ensuring clear alignment between business needs and technical solutions.

● Contributed to the development of Standard Operating Procedures (SOPs), improving documentation quality and process efficiency.

● Conducted basic training sessions on SQL and Power BI for junior team members, enhancing data literacy and reducing dependency on external training.

● Documented key business processes and reporting standards, improving transparency and communication across departments.

● Assisted in optimizing cross-functional workflows by identifying bottlenecks, leading to a reduction in process delays.

● Supported risk assessment initiatives by compiling data for compliance audits, helping reduce audit findings and improve regulatory adherence.

Education

Sacred Heart University, Fairfield, CT

Master of Science (MS) in Business Analytics August 2022 – December 2023

Contact this candidate