Business Analyst Power Bi

Anil Kumar Jampala

Business Analyst

Missouri, USA +1-314-***-**** **************@*****.*** LinkedIn SUMMARY

Analytical and results-driven Business Analyst with 7+ years of experience delivering data-driven insights and technology- enabled business solutions in banking, finance, and enterprise systems. Skilled in SQL, Power BI, Tableau, Excel, and Python to transform complex financial data into actionable business intelligence. Proven track record in requirements gathering, process optimization, and stakeholder management to deliver BRDs, FRDs, and user stories for development and QA teams. Experienced in ERP and financial system implementations, UAT coordination, and compliance with SOX, GAAP standards. Adept at driving measurable improvements in KPI visibility, operational efficiency, and revenue optimization. SKILLS

Business Analysis & Process Improvement: BRD, FRD, Use Cases, Test Plans, UAT, SDLC (Agile, Waterfall, SAFe), Process Mapping, Data Mapping, Change Management, Stakeholder Management, Workflow Optimization, SOP Documentation Data & Reporting Tools: Power BI, Tableau, Excel, Google Sheets, KPI Dashboards, Data Pipelines, ETL (ADF, AWS Glue, Talend, Informatica), SQL, Snowflake, Snowflake, Redshift, Data Modeling (Star Schema, Snowflake Schema), DAX Technical Skills: Python (Pandas, NumPy), API Testing (Postman, Swagger), AWS, Azure, Data Warehousing (Redshift, Snowflake, Star Schema), JIRA, Confluence, JIRA, Confluence, Data Governance, Data Quality, Business Intelligence Development Domain Expertise: Banking, Fintech, Consumer Lending, Insurance, Accounting, Tax, Credit Policy, Healthcare Analytics, Financial Modeling, Compliance, Risk Management, Fraud Detection, AML/KYC EXPERIENCE

PNC Financial – USA

Business Analyst Jan 2024 – Present

Designed and implemented real-time KPI dashboards in Power BI and SQL, reducing manual reporting effort by 30% and enabling faster, more informed executive decisions with improved visibility into key banking metrics.

Analyzed banking and lending workflows to identify and implement cost-saving opportunities in loan processing, payments, and reconciliations, resulting in a measurable reduction in operational costs.

Defined source-to-target data mappings with engineering teams, ensuring 99% reporting accuracy for financial datasets.

Authored BRDs, FRDs, and user stories, and coordinated UAT to achieve zero critical defects in production release.

Prepared and delivered executive presentations that influenced strategic financial and compliance initiatives, ensuring alignment with SOX and GAAP requirements.

Cognizant – India

Business Analyst Jul 2018 – Dec 2022

Spearheaded the migration from multiple legacy reporting systems to a cloud-based enterprise data warehouse (EDW), improving data accessibility and reporting efficiency by 40% across global business units.

Directed cross-functional teams of developers, data engineers, and QA analysts to define source-to-target mappings and complex transformation rules for structured and semi-structured datasets.

Established data governance and quality control processes, reducing data inconsistencies by 30% before migration and ensuring compliance with corporate and industry data standards.

Designed and deployed advanced Power BI and Tableau dashboards with drill-through capabilities, enabling senior leadership to monitor revenue trends, operational KPIs, and risk indicators in real time.

Authored comprehensive BRDs, FRDs, data flow diagrams, and functional specifications, ensuring alignment between stakeholders and technical teams for enterprise-scale projects.

Championed Agile delivery cycles by managing product backlogs, user stories, and acceptance criteria; facilitated sprint reviews and retrospectives that improved sprint velocity by 15%.

Provided strategic insights and executive-level reporting to influence investment decisions, cost optimization initiatives, and new product launches, directly impacting organizational growth. Odoo – India

Project Coordinator May 2017 – Jun 2018

Led requirements elicitation for ERP (Odoo) implementation across finance, inventory, and CRM modules, documenting functional specifications, process flows, and user stories to guide development teams.

Conducted business process analysis to identify workflow inefficiencies and recommend system enhancements, resulting in 30% higher adoption rates post-go-live.

Managed project plans, sprint schedules, and stakeholder communication, ensuring alignment with delivery milestones and minimizing scope creep.

Coordinated UAT cycles by developing test scripts, tracking defects, and validating fixes, leading to minimal post-deployment issues.

Authored standard operating procedures (SOPs), training materials, and knowledge transfer documents to support long-term operational continuity.

EDUCATION

Master of Business Analytics

Trine University Angola, Indiana Dec 2024

Bachelor of Technology Automobile Engineering

Jawaharlal Nehru Technological University, India May 2016 CERTIFICATES

Certified Scrum Product Owner (CSPO) – Scrum Alliance Aug-2025

Contact this candidate