Data Analyst Power Bi

Pavan Kumar Madavaram

OH +1-216-***-**** *************@*****.*** LinkedIn

Summary

Data Analyst with 4 years of experience in healthcare and financial services, specializing in leveraging data to enhance operational efficiency and drive financial performance. Proficient in SQL, Python, and ETL processes, with a strong track record of developing interactive dashboards and conducting A/B testing for actionable insights. Experienced in ensuring HIPAA compliance and integrating large datasets in cloud environments (AWS, Azure). Skilled in data visualization using Tableau and Power BI, known for collaborating with cross-functional teams to deliver impactful solutions that support strategic initiatives. Education

Master of Science in Computer Science May 2022

Cleveland State University, Cleveland, Ohio

Bachelor of Technology in Computer Science and Engineering Jun 2019 SRM University, Chennai, India

Skills

Programming Languages: Python, R, SQL

Frameworks & Libraries: ETL, NumPy, Pandas, Matplotlib, Scikit-learn, Seaborn Databases: MySQL, PostgreSQL, MS SQL Server, Amazon Redshift, Snowflake Big Data Technologies: Apache Spark, PySpark

Data Analysis & Visualization

Tools:

Tableau, Power BI, Microsoft Excel

Cloud Services: AWS (Lambda, S3), GCP, Azure

Statistical Tools: Time Series Analysis, Regression Models, Principal Component Analysis (PCA), Hypothesis Testing, A/B Testing

Version Control & CI/CD Tools: Git, GitHub, Docker, Jenkins Operating Systems: Windows, Linux, macOS

Additional Skills: Agile Methodologies (Scrum), Microsoft Office Suite Experience

Data Analyst Jun 2022 - Present

Citigroup, USA

• Analyzed large volumes of retail banking and credit card transaction data using SQL and Python, enabling data-driven insights that improved customer segmentation and enhanced targeted marketing efforts.

• Developed and maintained interactive dashboards in Tableau and Power BI for wealth management and corporate lending teams, providing real-time analytics that streamlined decision-making processes.

• Leveraged Apache Spark and PySpark for big data processing, optimizing data workflows and improving data retrieval times for treasury and trade services by 25%.

• Collaborated with cross-functional teams in an Agile environment to implement ETL processes using SQL and cloud services like AWS and Azure, increasing data processing efficiency for small business banking solutions.

• Conducted time series analysis and regression modeling on corporate loan portfolios to identify risk factors and trends, supporting risk management strategies for institutional lending.

• Utilized data warehousing solutions (Snowflake, Amazon Redshift) to streamline data integration and reporting processes, ensuring compliance and enhancing data accessibility across departments. Data Analyst Jan 2019 – Nov 2020

Philips Healthcare, India

• Led data analysis projects to optimize healthcare operations and improve patient satisfaction, aligning with Philips' mission to enhance care across the health continuum.

• Analyzed extensive datasets related to imaging, ultrasound, and respiratory care products, providing insights that guided product development and operational enhancements.

• Developed interactive dashboards in Tableau and Power BI, delivering real-time insights into clinical performance and patient satisfaction, enabling data-driven decision-making.

• Conducted A/B testing and statistical analysis with Python (Pandas, Scikit-learn), providing actionable recommendations to elevate service quality and patient outcomes.

• Designed and implemented ETL processes using Apache Hadoop and AWS (S3, EC2), improving data accessibility and integration across healthcare services and consulting teams.

• Configured the Facets system to automate electronic claims processing, enhancing benefits management accuracy and ensuring compliance through rigorous data validation.

• Utilized advanced SQL (MS SQL Server, PostgreSQL) to extract and analyze healthcare datasets, supporting strategic initiatives aimed at advancing healthcare quality and efficiency. Certifications

• AWS – Aws certified Solutions Architect Associate

• JAVA – Java certification from NIIT

Contact this candidate