Data Analyst Power Bi

Divya Kollipara

Cockeysville, MD +1-667-***-**** *.***********@*****.*** Linkedin

SUMMARY

Detail-oriented Data Analyst with 3+ years of experience driving data-informed decision-making across financial operations, capital planning, and compliance. Proven ability to design predictive models, automate financial reporting, and lead end-to-end data workflows using Python, SQL, Tableau, Power BI, and Excel. Skilled in cloud platforms including AWS (S3, Redshift, Glue), Azure (ADF), and GCP

(BigQuery), and experienced with ETL tools like Apache Spark, Informatica, dbt, and Talend. Strong background in financial modeling

(DCF, ROI, IRR), variance analysis, and GAAP/SOX compliance, with a successful track record of optimizing reporting cycles by up to 60%, improving forecast accuracy, and supporting multi-million-dollar investment decisions. SKILLS

• Programming: Python, SQL, Java, Scala, Shell scripting

• Data Engineering: Apache Spark, Hadoop, Kafka, dbt, Apache Airflow, Informatica, Talend

• Cloud Platforms: AWS (S3, Lambda, Glue, EMR, Redshift), Azure (Data Factory), GCP (BigQuery)

• Databases: Snowflake, PostgreSQL, MySQL, MongoDB, Redshift, BigQuery, Oracle Financials, SAP FICO, NetSuite, MS Access, QuickBooks

• Visualization Tools: Power BI, Tableau, Looker, Google Data Studio

• Financial Modeling: DCF, NPV, IRR, ROI analysis, capital budgeting, scenario modeling, profitability analysis

• Accounting & Compliance: GAAP, IFRS, SOX compliance, journal entries, tax provisioning, reconciliations, internal audit

• ETL & Automation: SQL-based ETL, Excel Power Query, Power Pivot, VBA macros, report automation, Excel dashboards

• DevOps & CI/CD: Docker, Kubernetes, Jenkins, Terraform, CI/CD pipelines EXPERIENCE

Oracle Corporation May 2021 – Jul 2023

Data Analyst

• Designed and implemented a liquidity forecasting model integrated with Oracle ERP, improving short-term cash visibility and increasing liquidity coverage ratio by 20% across business units.

• Built interactive Tableau dashboards visualizing capital usage and variance trends, reducing monthly reporting time by 60% and enhancing accessibility for executive stakeholders.

• Developed a Python-based investment risk model using Pandas and Matplotlib, helping protect $1.2M in capital by accurately modeling market volatility, ROI, and liquidity risk.

• Led full data migration from legacy systems into Oracle Financials, resolving data inconsistencies and reducing monthly close errors by 30% across three cycles.

• Performed a departmental cost audit using Excel Power Query, identifying $800K in non-essential spend and designing a cost optimization plan adopted company-wide.

• Standardized CapEx workflows in collaboration with finance and procurement teams, reducing budget exceptions by 35% using Power BI tracking tools.

• Automated quarterly compliance reporting across multiple entities using SQL-based ETL and Excel macros, reducing manual effort by 45% and ensuring alignment with GAAP and SOX requirements.

• Created predictive cash flow models using historical ERP data and Python forecasting libraries, increasing planning precision and supporting treasury decisions impacting over $10M in fund allocation. Intel Corporation May 2020 – Apr 2021

Data Analyst

• Designed and automated financial dashboards using Tableau and Power BI to monitor R&D spend across global business units, reducing manual reporting effort by 50% and improving stakeholder visibility.

• Collaborated with FP&A and business operations teams to develop dynamic Excel-based forecasting models, improving forecast accuracy by 23% and aligning resource allocation with revenue targets.

• Extracted and transformed large-scale financial and operational datasets using SQL and Python (Pandas), enabling data-driven decisions across budget planning, cost control, and operational efficiency.

• Developed and deployed an internal KPI tracking framework using Excel VBA and Power Query to monitor variance analysis across capital projects, shortening reconciliation cycles by 35%.

• Partnered with data engineering teams to ingest and structure financial data from SAP FICO and NetSuite into a Snowflake warehouse, streamlining ETL pipelines and improving data accuracy.

• Conducted profitability analysis and scenario modeling for new product initiatives, delivering actionable insights that influenced investment decisions worth over $10M in capital allocation.

• Built an automated variance analysis report pipeline using SQL and Excel macros, cutting monthly close cycle time by 40% and enhancing audit readiness across finance teams.

• Supported internal audit and compliance functions by creating traceable reporting logs and reconciliation templates that met SOX controls, improving accuracy in regulatory reporting cycles. EDUCATION

• Master of Computer Information Systems

St. Francis College – Brooklyn, NY

• Bachelor of Science

Osmania University – Hyderabad, Telangana

May 2025

USA

Jul 2022

India

Contact this candidate