Data Analyst Power Bi

Keerthi Nivasshini Thangaraj

New Jersey 774-***-**** ****************.***@*****.*** LinkedIn GitHub

Summary

Data Analyst with 3+ years of experience in financial and sales data analysis and business Intelligence, specializes in compelling visual stories for presentations that effectively communicate complex data insights to non-technical audiences. Expertise in leveraging advanced Excel techniques, SQL, Python and BI tools for data-driven decision-making. Proven ability to collaborate with cross-functional teams to gather requirements and deliver impactful visualizations that can help evolve business strategy by strategic planning.

Skills

Programming Languages: Python (Pandas, NumPy, Matplotlib, Seaborn, SciPy, Scikit-learn), SQL, R language

Data Analytics & BI: Microsoft Power BI (DAX, Power BI Query Editor, Power BI Service), Tableau (Desktop, Server, Online, Tableau Prep), Microsoft Word, PPT, Microsoft Excel (formulas, VLOOKUP’s, power pivots, macros, VBA), Google analytics.

Cloud platforms: Azure, AWS (S3, Redshift)

Database Management: MySQL, Oracle, MS SQL, Snowflake

Project Management: Agile (Scrum), JIRA

Other skills: Data ETL, Data Integration, Data Cleaning, Feature extraction, Data Manipulation, Statistics, Financial Reporting, Presentation

Professional Experience

Data Analyst Intern Optum USA (remote) Mar 2024 - Current

Developed advanced Tableau dashboards to monitor hospital metrics and patient data, enabling better decision-making and reducing operational inefficiencies by 23%.

Leveraged Python (Pandas, NumPy) to process large healthcare datasets and perform statistical analysis for treatment effectiveness and patient outcome correlations.

Integrated data from multiple healthcare sources, including EHRs, lab results, and billing systems, creating a unified dataset for in-depth analysis.

Optimized MS-SQL queries for reporting on clinical trials, leading to improved patient treatment protocols and enhanced data-driven decision-making.

Conducted budget variance analysis and financial forecasting using SQL and Excel, ensuring accurate tracking of healthcare expenditures and alignment with financial goals.

Collaborated with cross functional teams to analyze cost discrepancies in healthcare budgets, providing actionable insights for cost optimization.

Executed complex SQL queries to monitor and audit patient data flows, identifying risks, anomalies, and compliance issues related to Medicare and Quality assurance reporting.

Worked closely with clinical, financial, and data teams to maintain data integrity and ensure adherence to industry standards in healthcare quality reporting.

Data Analyst RK Software Services LLC India Jun 2019 – Jun 2022

•Crafted interactive dashboards and visualizations using Power BI, providing insights into Sales and Finance, to drive data solutions for business clients.

•Collaborated closely with executive stakeholders to understand and meet business requirements, ensuring deliverables aligned with organizational goals and expectations, with a focus on business key performance Indicators (KPI metrics).

•Utilized DAX and Power BI Query Editor for advanced data modeling relationship building and streamlined reporting, achieving a 25% increase in overall reporting efficiency.

•Improved Sales performance by 20% through marketing and inventory management strategy derived from comprehensive reports, incorporating forecast models for demand planning.

•Implemented robust ETL processes automating data extraction, transformation, and loading from MySQL, SQL Server and cloud databases, ensuring high data quality and consistency organization wide.

•Reduced financial losses due to fraud by 15% by developing fraud detection models and visualizations using Python with advanced analytics tools and deployed reports on SharePoint Server to enhance data accessibility and security.

•Streamlined data processes using Python (Pandas) and Power BI Query Editor, significantly reducing analysis and reporting time and published the reports using Power BI Service, enabling real-time data access across various business units.

•Leveraged Python (Pandas, NumPy) for data preprocessing and feature engineering, improving operational efficiency by 30%.

•Applied advanced Excel functionalities (VLOOKUP’s, pivot tables, formulas) for data accuracy, trend analysis, financial reporting, and decision support.

•Built parameterized Sub-Reports, Matrix Reports, Charts, and Drill-down and Drill-Through reports, using Power BI Created effective presentations using PowerPoint to communicate data insights and trends to stakeholders.

Education

MS in Data Analytics Clark University Worcester, MA Dec 2023

Coursework: Python, Machine Learning, Data Visualization, Data Management, Business Intelligence, Linear regression, Agile and Splunk

BSc in Computer Systems and Design Anna University India July 2019

Academic Projects

Business Intelligence Strategy for E-commerce Sector, Clark University

• Crafted an advance Delivery Optimization Dashboard for TEMU, resolving delayed deliveries and stock discrepancies by strategic placement of Warehouses and implementing a dynamic stock allocation plan based on product demand.

Sentimental Analysis of IMDB Movie Reviews, Clark University

• Leveraged Data Mining and Machine Learning Algorithms such as Support Vector Machine (SVM), Naive Bayes, and Logistic Regression, Exploratory Data Analysis, and Natural Language Processing for reliable sentiment classification of unstructured movie reviews.

Amazon Database Simulation using SQL, Clark University

• Implemented an Amazon-like database in MySQL, boosted database performance with indexing, while executing DML and DDL operations and documenting entity relationships and attributes via optimized SQL scripts.

Certification

Tableau Desktop Specialist Certification (2023) Credly Badge

Snowflake Data Warehouse Workshop Batch

Contact this candidate