Business Intelligence Power Bi

Krishna Gandrathi Financial BI Analyst II

California, USA +1-334-***-**** *********************@*****.*** LinkedIn SUMMARY

Strategic Financial BI Analyst with 8+ years of experience in FP&A, financial modeling, and business intelligence. Expert in Power BI, SQL, Python, and ERP systems (SAP, NetSuite, Oracle) with a proven track record of automating reporting (30% faster), improving forecast accuracy (18%), and delivering $1.5M+ in cost savings. Adept at budgeting, forecasting, KPI tracking, and regulatory compliance (GAAP, IFRS, SOX). Recognized for transforming financial data into executive-ready insights that drive profitability and decision- making.

TECHNICAL SKILLS

Financial Analysis & FP&A: Forecasting, Budgeting, Variance Analysis, Cost Optimization, KPI Reporting

Business Intelligence & Automation: Power BI (DAX, Power Query), Tableau, VBA, SQL (ETL, Data Modeling), Python (Pandas, NumPy)

ERP Systems: SAP FI/CO, NetSuite, Oracle Financials

Accounting & Compliance: GAAP, IFRS, SOX, Basel III

Financial Modeling & Valuation: DCF, ROI, IRR, NPV, Comparable Company Analysis

Data Management: SQL Server, ETL Pipelines, Data Cleansing & Reconciliation PROFESSIONAL EXPERIENCE

AIG – AMERICAN INTERNATIONAL GROUP DEC 2024–PRESENT BUSINESS INTELLIGENCE ANALYST

Improved forecast accuracy by 18% through automation of financial models using Python, Excel, and Power BI.

Cut reporting cycle by 30% by streamlining ERP reporting (SAP & NetSuite) with VBA and Power Query.

Delivered $1.5M+ in cost savings via variance analysis, KPI tracking, and cross-functional collaboration.

Designed executive-level Power BI dashboards for real-time KPI monitoring, boosting decision efficiency by 20%.

Reduced financial discrepancies by 35% using SQL-based reconciliation and advanced analytics.

Drove annual budget planning and quarterly forecast reviews, lowering budget deviations by 12%.

Identified cost-saving opportunities, reducing operational expenses by 10%.

Enhanced financial reconciliation workflows, increasing reporting accuracy by 25%.

Performed deep-dive margin and revenue analysis, lifting profit margins by 15%. BROWNFRAME TECHNOLOGIES AUG 2019–JUL 2023

FINANCIAL & BI ANALYST

Led enterprise FP&A and BI reporting, delivering insights across finance and operations.

Authored BRDs, FRDs, and user stories, improving Agile delivery velocity by 22%.

Built Power BI/Tableau dashboards with DAX & data storytelling, cutting manual reporting by 25%.

Developed ETL workflows (Talend, Alteryx, SSIS) integrating SQL, MySQL, PostgreSQL, MongoDB enabling cloud analytics.

Performed gap analysis & process audits, improving efficiency by 18% (Lean Six Sigma aligned).

Facilitated Agile ceremonies (Scrum, sprint planning) with JIRA/Confluence for stakeholder alignment.

Supported UAT, regression testing, and defect triage with QA & DevOps ensuring SLA compliance.

Designed KPI-driven BI frameworks aligned with C-suite metrics, enabling data-driven decisions. ADONS SOFTECH JUL 2016–JUL 2019

SAP (FP&A) ANALYST

Carried out financial analysis for a 50B+ portfolio, improving returns by 8%.

Built budgeting, forecasting, and cash flow models, reducing forecast errors by 15%.

Ensured regulatory compliance (GAAP, SOX, IFRS) avoiding 10% penalty exposure.

Leveraged SQL, Python & Excel for large-scale data analysis, lowering NPAs by 12%.

Automated reporting & reconciliation, boosting process efficiency by 20%.

Managed CapEx planning & cost optimization for large-scale projects, reducing costs by 18%.

Conducted ROI/NPV/IRR analysis, improving profitability by 15%.

Developed cash flow forecasting models, reducing liquidity shortfalls by 20%.

Supported preparation of quarterly/annual financial statements, cutting close time by 25%. PROJECT HIGHLIGHTS

ERP IMPLEMENTATION CRITICAL SUCCESS FACTORS

SAP FICO, Oracle Cloud ERP, NetSuite, Tableau

Executed comparative analysis of ERP platforms, identifying integration challenges & risk factors.

Built evaluation framework on cost-benefit, scalability, compliance, aiding enterprise decision-making.

Presented results through executive dashboards & reports, aligning with FP&A KPI frameworks. RESEARCH & TEACHING-RELATED EXPERIENCE

PROJECT LEADER – INFO6550: DEEP LEARNING COMPUTER VISION RESEARCH PROJECTAUBURN UNIVERSITY AT MONTGOMERY SPRING 2025

Directed a team of 7 graduate students to design and train a TensorFlow-based computer vision model.

Delegated roles, scheduled progress reviews, and provided technical guidance to peers.

Facilitated group understanding of deep learning frameworks, simulating GTA-style teaching support.

Led the preparation and delivery of a conference-style poster and presentation. TEAM LEADER – EMPLOYEE TURNOVER ANALYSIS DATA ANALYTICS PROJECT AUBURN UNIVERSITY AT MONTGOMERY FALL 2024

Supervised a group research project analyzing turnover drivers using SAS Studio, SAS Viya, and Excel.

Guided peers in dataset exploration, statistical modeling, and visualization techniques.

Reviewed team deliverables and provided constructive feedback, paralleling responsibilities of a GTA.

Presented findings to faculty and classmates, strengthening communication and teaching skills. LEAD – ERP SYSTEMS IMPLEMENTATION CASE STUDY

AUBURN UNIVERSITY AT MONTGOMERY SUMMER 2024

Coordinated project tasks among peers to analyze ERP critical success factors and implementation challenges.

Mentored classmates in synthesizing literature review insights into structured case analysis.

Facilitated discussions and ensured knowledge sharing, demonstrating leadership and instructional abilities.

EDUCATION

Master’s in Management Information Systems – Auburn University at Montgomery, USA

Bachelor of Engineering, Electronics & Communication – Balaji Institute of Engineering & Sciences, India

Contact this candidate