Business Analyst Power Bi

Preethi Cheruku

Business Analyst

Utica, NY – ***02 *******.**.**@*****.*** 315-***-****

https://www.linkedin.com/in/preethi-cheruku/

SUMMARY

Business Analyst with extensive experience of 5 years in healthcare and finance domains, skilled in driving process improvements and implementing technology solutions to enhance operational efficiency.

Proven track record in managing large-scale projects, conducting comprehensive GAP analyses and collaborating with cross-functional teams to deliver high-quality software solutions.

Proficient in data analysis, requirements documentation, and compliance with industry standards.

Adept at utilizing various tools and technologies including Power BI, SQL, Python, MS Visio, SSIS, Informatica, UML, BPMN and SAP to support business objectives and ensure data accuracy.

Strong expertise in developing Functional Requirement Documents (FRD), Business Requirement Documents

(BRD), and Software Requirement Specifications (SRS).

Committed to continuous improvement and excellence in delivering impactful business insights and solutions for impactful solutions.

EDUCATION

MBA in BA – Utica Uinversity, NY, USA Dec 2024

SKILLS

Languages: SQL, Python, R, SAS.

Methodology: SDLC, Agile, Waterfall, Scrum, Kanban, Lean Six Sigma. Documentations: FRD, BRD, SRS, Test Plan, User Guide. Project Management Tools: MS Project, MS Excel, MS SharePoint, Asana, Trello, Rally. Visualization Tools: Tableau, Power BI, Google Data Studio. Tracking Tools: Jira, HP Quality Center, Rational ClearQuest, RTM. Business Analysis: Cost/Benefit Analysis, Impact Analysis, GAP Analysis, Risk Analysis, Root cause Analysis. ERP Planning & CRM: SAP, MS Dynamics Nav, Salesforce, HubSpot, Epic and Oracle. Technical Skills: KPI, User Acceptance Testing (UAT), Alteryx, Requirement gathering, Google Analytics, Data Analysis, MS Visio, Joint Application Development (JAD), MS Office, User Story creation, Software development

& testing, Data Modelling, Database Knowledge, Business Intelligence (BI) Tools, Process Mapping, User Experience (UX) Understanding, Quality Assurance (QA) Knowledge, Prototyping. Soft Skills: Time management, Leadership, Management, Problem-solving, Negotiation, Decision- Making, Documentation and Presentation, Verbal communication, Sprint Planning, Sprint Reviews, Interview Sessions. SWOT Analysis.

Operating System: Windows, Linux.

EXPERIENCE

BUSINESS ANALYST

CVS HEALTH, USA Feb 2024 – Present

Spearheaded and recorded key project requirements, collaborating with departments like Nursing Informatics and Strategy Management to merge workflows and create more efficient patient follow-up processes, particularly for heart failure and kidney injury metrics.

Guided end-to-end data analysis using SQL, SAS, and Python to derive actionable insights, optimizing physician teleconsultations and patient follow-up metric tracking to the fullest.

Utilized Power BI and Google Data Studio for creating interactive dashboards, allowing for deeper insight into patient care metrics and data-driven decision-making, resulting in a 20% improvement in reporting accuracy.

Conducted GAP and Root Cause Analysis, identifying over 25 areas of process enhancement, which resulted in an 18% reduction in operational bottlenecks and improved resource allocation.

Conducted User Acceptance Testing (UAT) with 95% success in validating system functionality for seamless integration of teleconsultation and claims processing workflows. Collaborated with IT teams to achieve HIPAA and GDPR compliance, safeguarding patient data while embracing secure data exchange practices through EDI and X12 standards.

Implemented Agile and Scrum methodology, including sprint planning and daily stand-ups, to drive project timelines, simplify cross-team coordination, and enable on-time delivery of healthcare products. BUSINESS ANALYST

CGI, India Feb 2020 – Nov 2022

Led the development of a next-generation credit risk management platform, reducing credit approval time by 25% and enhancing customer satisfaction through optimized workflows and a user-friendly interface.

Facilitated requirements-gathering workshops with key stakeholders from risk management, finance, and compliance teams to collect, analyze, and document detailed functional and non-functional requirements, mapping to regulatory and business priorities.

Created end-to-end data models and ER diagrams using UML and BPMN and certified the system architecture to support primary credit risk assessments and improve reporting capability for loan portfolios.

Collaborated with cross-functional IT teams, including solution architects, developers, and QA, to make system performance, scalability, and security aligned with risk management principles and regulatory requirements.

Implemented a deliberate change management program, significantly minimizing disruptions by presenting targeted training programs, clearly communicated platform launches, and extensive post-launch assistance.

Developed and executed formal User Acceptance Testing (UAT) plans, working in close consultation with credit analysts and end-users to ensure system functionality, usability, and production-readiness for deployment, ensuring a smooth rollout.

Designed over 25 process flow diagrams with the help of MS Visio to document complex workflows for risk rating, loan approval, and credit limit alteration, reducing project timelines for completion.

Conducted meticulous SWOT analysis at all project stages, allowing proactive management of risks and evidence-based decision-making in a bid to optimize credit assessment procedures.

Utilized SQL and Python for sophisticated data analysis and reporting to determine credit risk exposure, customer credit, and default probability.

Combined SAP financial data with a 99% accuracy rate for all credit assessment systems.

Integrated strict compliance controls for AML and Customer identity verification in the system development lifecycle, enabling full regulatory compliance and protecting the institution from financial and reputational loss. JR BUSINESS ANALYST

DXC Technology, India Apr 2018 – Jan 2020

Led the development and automation of 3 key business processes for top-tier banking clients, resulting in enhanced service reliability, process efficiency, and adherence to quality assurance protocols within highly regulated environments.

Developed and delivered interactive dashboards using Tableau and Power BI to provide real-time insights for stakeholders, directly contributing to a 30% improvement in data-driven decision-making and project visibility.

Collaborated with cross-functional teams to gather and analyze business requirements using SDLC, Agile, and Waterfall methodologies. Translated stakeholder needs into detailed BRDs, FRDs, and SRS documents for development and QA teams.

Conducted thorough requirements analysis, impact assessments, and GAP analysis to identify business needs, assess process inefficiencies, and propose actionable solutions aligned with organizational goals.

Facilitated JAD sessions, interviews, and workshops with 15+ internal and external stakeholders, ensuring alignment between business needs and technical solutions, while maintaining effective communication throughout the project lifecycle.

Managed end-to-end UAT processes, created comprehensive Test Plans, and supported test execution to ensure that final deliverables met user expectations and compliance standards.

Utilized MS Project, Trello, Asana, and SharePoint for effective project tracking, task assignment, and progress reporting, improving team collaboration and ensuring timely project delivery.

Leveraged Excel for reporting and analysis, including the use of pivot tables, formulas, and conditional formatting to track KPIs and monitor project performance, supporting informed management decisions.

Contact this candidate