data analyst

Pruthvi rao Cell No: +1-302-***-****

Email: **********.****@*****.***

Professional Summary:

Data Analyst around 3 years of experience in using data to support business decisions and enhance operational efficiency. Proficient in SQL, Python, Tableau and Cloud Technologies like AWS, with a strong background in data Visualization, ETL Processes, and collaborative analysis using Jupyter notebooks and Databricks. Proven ability to produce actionable insights through effective data analysis and visualization, contribution to the development of data-driven cultures with organization.

Education:

Master’s in information systems technology

Wilmington University GPA: 3.7/4.0 New Castle, DE

Bachelor’s in computer science

Vaagdevi college of engineering. GPA:7.6/10 Warangal, India

Work Experience:

Data Analyst Apr 2024 – present

(Client: Lumeris, Loc: Maryland Heights, MO)

•Developed ETL pipelines using SQL and Python to automate claims data processing for Medicare Advantage and value-based care contracts, hosted on AWS and Snowflake, improving accuracy and efficiency.

•Optimized claims validation, reducing errors by 25% and cutting manual efforts by 30% using Databricks, Pandas, and cloud-based solutions.

•Implemented cost-saving algorithms to identify billing discrepancies and improve reimbursement rates, contributing to a 15% reduction in operational costs.

•Automated monthly financial reports to track claims expenses and ensure compliance, providing actionable insights via Tableau dashboards for senior management.

•Improved data accuracy through advanced SQL queries on cloud platforms, enhancing processing speed and ensuring timely payment reconciliation.

Environment: Python, SQL, Databricks, Pandas, Altair, NumPy, AWS, EC2, EMR, Redshift, Spark, ETL, Snowflake, Tableau, Jira.

Data Analyst Jan 2022 – Nov 2022

(Client: Impetus Technologies, Loc: Hyderabad)

•Assisted in migrating legacy financial databases to AWS, improving data scalability and enabling more efficient analysis of large datasets.

•Supported the development of ETL pipelines using SQL to automate the extraction, transformation, and loading of financial data, reducing manual effort by 40% and ensuring up-to-date reporting.

•Analysed data using SQL and Excel, performing data cleansing, trend analysis, and aggregation.

•Created financial dashboards and automated reports in Excel (pivot tables, VLOOKUP, charts, macros and advance formulas) to reduce reporting time and errors along with Tableau for actionable insights.

•Validated financial data using SQL scripts, resolving discrepancies and improving accuracy by 20%.

•Collaborated with senior analysts to create interactive Tableau visualizations, translating complex financial data into understandable charts and graphs for key stakeholders.

•Automated CI/CD pipelines for data workflows, ensuring seamless deployments and version control using Terraform and Git.

Environment: Python, SQL, Databricks, Agile, Jira, ETL, GIT, Tableau, Power BI, Git, Terraform Postgres, MySQL, AWS

Projects:

Sales Performance Analysis

Conducted a comprehensive analysis of sales performance, identifying key trends across regions and products.

Created Tableau dashboards integrated with AWS Redshift to provide real-time updates for leadership teams.

Skills: Tableau, SQL, AWS

Customer retention prediction and optimization

Built a churn prediction model using SQL, Python (logistic regression), and Snowflake, achieving 85% accuracy.

Developed Power BI dashboards for real-time customer insights, reducing churn by 15%.

Developed Power BI dashboards to present actionable insights to business stakeholders.

Skills: Python, SQL, Pandas, Snowflake, PowerBI

Student Performance Analysis

Designed and implemented a data-driven approach to analyze student performance using SQL for database management and Python (Pandas, Matplotlib) for statistical insights.

Built interactive reports to identify key factors affecting student grades, helping institutions optimize learning strategies.

Skills: Python, SQL, Pandas, MySQL

SKILLS:

•Programming languages: Python, SQL, MySQL, Postgres

•Data Analysis & management: Databricks, Excel, Jupyter Notebook, NumPy, Pandas, Power BI, Tableau, GIT.

•Cloud Technologies: AWS, Ec2, EMR, Redshift, S3, snowflake.

Contact this candidate