Data Analyst Power Bi

Venkata Ramya Duddupudi

Data Analyst

NJ, USA +1-551-***-**** ****************@*****.*** LinkedIn SUMMARY:

Detail Detail-oriented and results-driven Data Analyst with 4+ years of experience in transforming complex datasets into actionable insights that influence strategic decision-making and drive business growth. Adept at data mining, statistical analysis, predictive modeling, and interactive dashboard development using tools such as SQL, Excel, Python, Tableau, and Power BI. Proven track record of streamlining operations, automating reporting processes, and enhancing KPI visibility across diverse sectors including finance, e-commerce, retail, and healthcare. Skilled in collaborating with cross-functional teams to gather business requirements, translate them into analytical solutions, and present findings to both technical and non-technical stakeholders. Strong foundation in ETL processes, A/B testing, and data storytelling with the ability to identify trends, patterns, and anomalies that lead to measurable improvements in performance and decision-making. TECHNICAL SKILLS:

Languages SQL, Python (Pandas, NumPy, Matplotlib), R, DAX Databases PostgreSQL, MySQL, Oracle, MS SQL Server, Snowflake, MongoDB Cloud Platforms AWS (S3, Glue, Athena, Redshift, RDS, Lambda, IAM, CloudWatch) ETL & Data Handling AWS Glue, Power Query, Alteryx, Talend, Informatica, Excel (Pivot Tables, VBA Macros), dbt Data Visualization Power BI, Tableau, Looker Studio, Excel Dashboards, Google Data Studio Reporting & BI Scheduled Reports, KPI Dashboards, Ad Hoc Analysis, Automated Reports (Power BI/Tableau with SQL/AWS) Machine Learning Python (Scikit-learn - basic), Regression, Clustering, Forecasting, A/B Testing Data Processing AWS Lambda, Athena, Redshift, MapReduce (basic), Apache Spark (basic), EMR Automation & Scripting Shell Scripting, Python Scripts, Cron Jobs, Power Automate Documentation Tools MS Word, Excel, PowerPoint, Visio, Lucidchart Project Management JIRA, Confluence, Trello, Agile/Scrum Version Control Git, GitHub

Soft Skills Data Storytelling, Business Communication, Stakeholder Management, Problem Solving EDUCATION:

Master of Science in Computer Science Jan 2023 – May 2024 New Jersey Institute of Technology (NJIT)

Bachelor of Science in Computer Science June 2018 – April 2022 KL University, India

PROFESSIONALEXPERIENCE:

Senior Data Analyst Sep 2024 – Present

CVS Health, USA

• Developed optimized SQL queries using joins, window functions, and CTEs in PostgreSQL and Snowflake to extract, cleanse, and validate large-scale healthcare claims and patient data for compliance reporting, operational analytics, and interactive dashboards aligned with HIPAA standards.

• Built dynamic Excel dashboards using Power Query, pivot tables, and VBA for medical cost forecasting, utilization tracking, and patient outcome trends; supported budgeting and variance analysis to aid in executive decision-making for hospital resource allocation.

• Designed and maintained interactive dashboards in Power BI, Tableau, and Google Data Studio to monitor clinical KPIs such as readmission rates, average length of stay (ALOS), and treatment adherence across departments; visualized outcomes of population health and chronic care programs.

• Automated recurring financial and operational reports using ETL pipelines in PostgreSQL with validation via Linux/Unix shell scripting and cron jobs; wrote and maintained PL/SQL procedures for ingestion and transformation of EHR and pharmacy datasets into centralized BI platforms.

• Built ETL pipelines using AWS Glue to process healthcare data from S3 and transform it for analysis in Redshift and Snowflake; Queried datasets using AWS Athena for ad hoc reporting and data validation.

• Stored and managed raw and processed data securely in Amazon S3, applying version control and lifecycle policies; Scheduled automated jobs using AWS Lambda for data ingestion, cleansing, and transformation tasks.

• Defined and monitored critical healthcare KPIs including ROI on telemedicine programs, forecast accuracy in patient volume, physician utilization rates, and cost-per-case metrics using DAX, calculated fields, and slicers in Power BI/Tableau.

• Conducted UAT (User Acceptance Testing) for dashboards and ETL workflows by collaborating with clinicians, revenue cycle managers, and quality analysts to validate data against real-world healthcare records; documented test cases and aligned with user stories.

• Participated in Agile ceremonies (stand-ups, sprint reviews, backlog grooming) and managed requirements through BRD/FRD creation in Confluence; tracked sprint progress in JIRA and ensured seamless transition across dev, UAT, and production under full SDLC lifecycle governance.

• Utilized Python (Pandas, NumPy, Matplotlib) to automate patient cohort analysis, treatment pattern recognition, and payer trend segmentation; generated graphs and insights used by medical review boards and compliance teams to detect anomalies and drive quality improvements.

• Collaborated with data scientists to support machine learning initiatives for predicting patient readmissions and identifying fraud in insurance claims; facilitated data preparation for models using feature engineering and outlier detection scripts in Python.

• Assisted in integrating outputs from MapReduce workflows (within Hadoop/Spark environments) into BI dashboards, enabling high-volume batch processing of radiology records and appointment data for predictive analytics and population risk stratification.

• Created executive-level PowerPoint presentations summarizing financial risk scores, patient satisfaction metrics, and departmental benchmarking; combined storytelling visuals from Tableau, Power BI, and Excel to drive leadership engagement in quarterly reviews. Data Analyst May 2019 – Nov 2022

Hexaware, India

• Designed financial dashboards in Excel using Power Query, Pivot Tables, VBA macros, enabling accurate monthly forecasting and cost analysis while cutting manual reporting time by 40%.

• Developed and maintained KPI-driven dashboards in Power BI, Tableau, and Google Data Studio, aligning reports with CFO and senior leadership metrics like ROI, variance, and budget adherence.

• Built automated ETL processes in PostgreSQL to extract and transform high-volume financial data, leveraging Linux/Unix shell scripting and cron jobs for job orchestration and validation checks.

• Extracted and reconciled financial data using PL/SQL procedures, ensuring clean integration with BI tools and adherence to financial data quality controls.

• Built and maintained automated ETL pipelines using AWS Glue and S3 to process financial data for reporting and audit purposes; Queried large datasets using AWS Athena to support ad hoc financial analysis and compliance reporting.

• Stored sensitive financial records securely in Amazon S3, applying encryption and IAM policies to ensure data privacy and access control; Used Amazon Redshift to power executive dashboards and quarterly reports for financial forecasting and cost analysis; Integrated Power BI and Tableau with AWS data sources to visualize KPIs such as revenue trends, cost savings, and risk metrics.

• Defined and monitored financial KPIs including forecast accuracy, cost efficiency, capital expenditures, and departmental headcount through real-time dashboards with drill-down functionality.

• Created and executed detailed UAT test cases for both ETL pipelines and dashboards, coordinating directly with finance users to ensure data accuracy and audit-readiness.

• Followed Agile Scrum methodology; participated in stand-ups, sprint reviews, and retrospectives while maintaining user stories and test logs in JIRA and Confluence.

• Applied SDLC principles to reporting lifecycle: from requirements (BRD/FRD) through QA/UAT to production deployment, maintaining complete version control and documentation.

• Used Python (Pandas, NumPy, Matplotlib) to automate financial data transformations, perform time series analysis, and feed insights directly into BI dashboards.

• Created executive-level presentations in PowerPoint combining visuals from Power BI, Tableau, and Excel, enabling senior leadership to make strategic investment and budgeting decisions. CERTIFICATIONS:

• ServiceNow Certified Administrator

• Introduction to Big Data (Coursera)

• Six Sigma Principles (Coursera)

• UX Design Fundamentals (Coursera)

• AI Agents Fundamentals with Hugging Face

PROJECTS:

• Customer Segmentation for Targeted Marketing – E-commerce: Tools: R, Python, Excel, K-Means Clustering, Power BI Performed clustering on customer behavior data using K-means to segment customers by purchase frequency, monetary value, and recency (RFM analysis). Visualized buyer personas using Power BI dashboards to support targeted marketing campaigns; Achieved actionable group-level insights to increase conversion and improve retention strategy.

• Sales Forecasting & Revenue Trend Analysis – Retail Domain: Tools: Python (Pandas, NumPy, Matplotlib), Power BI, SQL, Excel Analyzed historical sales data from a mid-sized retail company to identify seasonal patterns and regional revenue trends. Built predictive models using linear regression and time-series forecasting to forecast sales for upcoming quarters. Developed Power BI dashboards to visualize trends by product category, region, and seasonality, supporting inventory planning.

Contact this candidate