Business Analyst Power Bi

LOKESH REDDY MALLELA

BUSINESS ANALYST

Colorado, USA Email: ***************@*****.*** Mobile No: 551-***-**** LinkedIn SUMMARY

• Experienced Business Analyst with 3+ years of expertise in gathering, analyzing, and translating complex business requirements into actionable solutions using tools like JIRA, Confluence, and Microsoft Visio.

• Proficient in data analysis and reporting using SQL, Excel, Power BI, Tableau, and Python, enabling data-driven decision- making and business process optimization.

• Skilled in creating BRDs, FRDs, user stories, wireframes, and process flows, with a strong understanding of Agile, Scrum, and Waterfall methodologies for end-to-end project lifecycle management.

• Demonstrated ability to collaborate with cross-functional teams including stakeholders, developers, QA testers, and product owners to deliver high-impact business solutions.

• Adept at working with ERP systems (SAP, Oracle), CRM tools (Salesforce), and integrating API-based solutions to enhance operational efficiency and customer experience. TECHNICAL SKILLS

Methodology: SDLC, Agile, Waterfall, Kanban

Programming Languages: SQL, Python (NumPy, Pandas, Matplotlib), R Database Management: MySQL, PostgreSQL

Documentations: FRD, BRD, SRS, User Stories, Use cases, Requirements Traceability Matrix Project Management Tools: JIRA, Trello, MS Project, Confluence Visualization Tools: Power BI, Tableau, Advanced Excel (Pivot Tables, Macros) Business Analysis: Cost/benefit Analysis, Impact Analysis, GAP Analysis, Risk Analysis, SWOT Analysis Tracking Tools: Jira, HP Quality Center, Rational ClearQuest, RTM Cloud Computing Platforms: AWS, Azure

ERP Planning & CRM: SAP, MS Dynamics Nav, Salesforce, HubSpot Technical Skills: Snowflake, Alteryx, Probability distributions, Confidence Intervals, ANOVA, Hypothesis Testing, Regression Analysis, Advance Analytics, Data Mining, Data Visualization, Data warehousing, DAX, Power Query, Power Pivot, KPI, UAT, Requirement gathering, Data Modeling, Data Analysis, MS Visio, Process Mapping, Prototyping

Soft Skills: Time management, Leadership, Management, Problem-solving, Negotiation, Decision-Making, Documentation, and Presentation, Verbal communication, Sprint Planning WORK EXPERIENCE

Anthem, CO Business Analyst Jul 2024 - Present

• Analyzed Medicare and Medicaid claims data to support the Claims Overpayment Recovery Initiative, identifying $3.5M+ in overpayments and reducing audit cycle time by 40%.

• Collaborated with actuarial, provider analytics, IT, and compliance teams to gather and document business requirements aligned with CMS and payment integrity standards.

• Utilized SQL, Python (Pandas, NumPy), and Excel to analyze medical, pharmacy, and behavioral health claims, enabling operational enhancements and compliance insights.

• Conducted claims adjudication reviews to detect CPT/ICD-10 coding errors, duplicate billing, and provider anomalies, improving claims accuracy by 15%.

• Built Power BI dashboards and supported ETL development using SSIS and Snowflake to streamline reporting, enhance data integration, and improve KPI tracking.

HCL Technology, India Business Analyst Apr 2021 – Jul 2023

• Developed and automated risk and performance analytics models for $3B+ in multi-asset portfolios (equities, fixed income, alternatives) using Python, and SQL, reducing manual analysis time by 40% and enhancing decision-making accuracy.

• Collaborated with quantitative researchers to design and deploy analytical tools that improved portfolio construction and risk decomposition, leading to a 20% increase in efficiency for the investment advisory team.

• Built over 25 interactive Tableau dashboards to visualize risk metrics, benchmark comparisons, and return attribution, used by 100+ Client Advisors across wealth management to improve client reporting.

• Implemented data quality assurance frameworks that reduced portfolio reporting errors by 35%, ensuring compliance with internal governance policies and industry standards across 50K+ portfolio records.

• Acted as a liaison between Portfolio Management and Risk teams on quantitative research projects, mentoring 3 junior analysts and streamlining project workflows using Jira, which accelerated delivery timelines by 15%. EDUCATION

University of Colorado Denver, CO Master’s in Information Systems NIIT University, Rajasthan, India Bachelor’s in Computer Science

Contact this candidate