Data Analyst Power Bi

RAMANJALI MEDARAMETLA

Kansas *************@*****.*** +1-913-***-**** LinkedIn

SUMMARY

Detail-oriented Data Analyst with experience in data collection, validation, and visualization within financial, compliance, and software environments. Skilled in transforming raw transactional and operational data into meaningful insights to support audits, reporting, and business strategy. Adept at building automated dashboards, maintaining structured datasets, and collaborating across departments to deliver data-driven solutions. Strong foundation in Python, SQL, Excel, and BI tools such as Power BI and Tableau.

WORK EXPERIENCE

PRINCIPAL FINANCIAL Des Moines,IA

Data Analyst Aug 2024 – Jun 2025

• Analyzed large volumes of transactional and operational data for Enhanced Due Diligence (EDD) processes, ensuring data accuracy, completeness, and compliance with reporting standards.

• Collected, cleaned, and transformed raw datasets from multiple sources using Excel, SQL, and Python, improving data readiness for audits and internal analysis.

• Developed and maintained interactive dashboards and automated templates using Power BI and Tableau, streamlining report generation and improving stakeholder visibility.

• Built and documented ETL pipelines and reporting workflows, enhancing reusability and collaboration across analytics and compliance teams.

• Delivered weekly data summaries and trend analysis reports to business units and external stakeholders, supporting project tracking and strategic planning initiatives.

DXC Technologies Hyderabad,IND

Data Analyst Jun 2021 – Dec 2022

• Collected, cleaned, and validated transaction data used in Enhanced Due Diligence (EDD) to ensure consistency in compliance reporting.

• Created and maintained data-driven reports supporting internal audits and risk monitoring initiatives.

• Built automated dashboards and reporting templates using Power BI and Excel, reducing manual reporting time by over 40%.

• Delivered weekly operational summaries and trend analysis reports for stakeholders, driving data-backed decision-making.

• Structured data collection processes to support transparency, traceability, and data integrity across departments. Magna Infotech Bangaluru

Data Analyst Intern Jun 2020 – Aug 2021

• Collected, cleaned, and transformed raw operational data into structured formats, improving data usability for analysis and reporting.

• Designed and maintained ETL pipelines to support routine data extraction and transformation tasks across departments.

• Created interactive dashboards and reports using Tableau and Excel, visualizing business growth and operational metrics for internal teams.

• Documented data workflows and reporting procedures to ensure process transparency and knowledge transfer across analytics teams.

• Collaborated with project managers to deliver weekly status updates and performance summaries, aligning analytical insights with business objectives

TECHNICAL SKILLS

• Programming & Analysis: SQL, Python (Pandas, NumPy), R, Typescript, HTML5, CSS3

• Data Visualization & Analytics: Power BI, Tableau, Sisense, Seaborn, Data visualization dashboards, Data analysis, Dashboard design, Analytical skills, Digital Marketing data

• Data Engineering & Warehousing: Azure Databricks, Delta Lake, Parquet, Unity Catalog

• ETL/ELT: Data pipelines, API & SQL-based ingestion, Master Data Management

• Cloud & DevOps: Azure, AWS, GitLab, Jenkins

• Database: Stored procedures, triggers, indexing, partitioning, performance tuning

.

EDUCATION

University OF Central Missouri warrensburg, MO

Master’s In Computer Science Jan 2023 – Aug 2024

KKR&KSR Institute Of Technology Guntur, IND

Bachelor’s in Computer Science July 2017 – Jun 2021 CERTIFICATION

• Google data Analytics Professional Certification

• Azure Fundamentals by Microsoft – April 2022

• AI for Everyone by Coursera – June 2020

• Software Programmer by Infosys – June 2020

• NPTEL Course R Language – 88%

• NPTEL Course Java Programming – 74%

• NPTEL Course Joy of Computing Python – 80%

Contact this candidate