Senior Data Analyst with BI & SQL Expertise

KARAN RAJA S

Senior Data Analyst

*************@*****.*** +91-917*******

EXECUTIVE OVERVIEW

Results-driven Data Analyst with 5+ years of experience in leveraging data to uncover insights, optimize processes, and support strategic decision-making. Skilled in SQL, Python, Power BI, and Tableau, with a proven ability to transform complex datasets into actionable business intelligence that drives organizational success. KEY SKILLS

•Data Analysis & Visualization: Power BI, Tableau, Excel, Data Cleaning, Data Wrangling, Data Modeling, ETL Processes

•Programming Languages: Python (NumPy, Pandas, Matplotlib, Seaborn)

•Database Management: MySQL (Joins, Subqueries, CTEs, Data Extraction, Query Optimization)

•Statistical Analysis: Descriptive & Inferential Statistics, Hypothesis Testing, Correlation & Regression Analysis

•Tools & Technologies: Power BI, Tableau, MySQL, Advanced Excel (VLOOKUP, Pivot Tables, Power Query)

•Reporting & Storytelling: Dashboard Design, KPI Tracking, Data Interpretation, Business Reporting

•Soft Skills: Problem-Solving, Attention to Detail, Critical Thinking, Collaboration, Effective Communication PROFESSIONAL SUMMARY

Infiniti Software Solutions Pvt Ltd Sep 2020 – Present

•Highly skilled Data Analyst with over 5 years of expertise in data analysis, visualization, and business intelligence across multiple domains.

•Proficient in SQL for data extraction, cleaning, and transformation, with strong expertise in Tableau, Power BI, and Excel for developing dynamic dashboards and interactive reports.

•Experienced in performing requirement gathering, root cause analysis (RCA), and optimizing business operations through actionable, data-driven insights.

•Adept at applying statistical methods and predictive modeling to identify patterns, forecast outcomes, and proactively mitigate potential risks.

•Known for effective collaboration with IT, operations, and management teams to ensure data integrity, accuracy, and governance across all business processes.

•Passionate about transforming complex datasets into strategic solutions that drive performance improvement and informed decision-making.

•Committed to documenting analytical processes to ensure transparency, reproducibility, and readiness for internal and external audits.

ACADEMIC BACKGROUND

2020

B.Tech (Automobile Engineering)

Hindustan Institute of Technology and Science

PROJECT 2

Project: Emblem Health - Healthcare Claims & Member Services Analytics Description: The project aimed to analyze large-scale healthcare claims, member enrollment data, and provider network performance to enhance operational efficiency and support regulatory reporting. By leveraging SQL, Power BI, and Python, the goal was to identify cost drivers, improve claim processing timelines, monitor member engagement, and ensure compliance with CMS and HIPAA guidelines. Roles & Responsibilities:

•Extracted, integrated, and validated data from multiple sources including claims systems, member repositories, and provider directories using SQL and Power BI Dataflows for seamless data consolidation.

•Performed data wrangling, cleansing, and transformation using Python (Pandas) and Excel, resolving missing values, removing duplicates, and standardizing procedure and diagnosis codes to ensure data consistency.

•Conducted in-depth analysis of medical and pharmacy claims to identify high-cost services, anomalies, potential fraud patterns, and trends in claim denials.

•Designed and developed interactive dashboards in Power BI to visualize key performance indicators (KPIs) such as claims turnaround time, provider efficiency, and member satisfaction metrics.

•Executed statistical analysis and predictive modeling, including hypothesis testing and regression techniques, to assess program effectiveness, healthcare outcomes, and readmission rates.

•Collaborated with cross-functional teams to interpret analytical results, generate actionable insights, and support strategic healthcare initiatives.

•Ensured HIPAA compliance and supported CMS reporting by maintaining strict data security, quality assurance, and privacy protocols across all datasets.

•Documented data transformation workflows and analysis procedures to promote transparency, reproducibility, and audit readiness.

PROJECT 1

Project: HSBC Data Analytics and Insights

Description: The project focuses on enhancing decision-making processes by consolidating and analyzing data from multiple banking domains, such as retail banking, investment banking, and compliance. The primary goal is to deliver actionable insights to improve customer experience, optimize financial operations, and ensure regulatory compliance.

Roles & Responsibilities:

•Gathered, consolidated, and integrated data from multiple sources, including transaction databases, CRM systems, and external market feeds, ensuring accuracy and consistency for analysis.

•Conducted trend and pattern analysis on customer behavior, transaction volumes, and operational KPIs using advanced Excel functions and Python scripts to drive data-backed decisions.

•Extracted actionable insights from data to inform business strategies and optimize operational performance.

•Automated routine data processing and reporting tasks using Python, reducing manual effort and increasing efficiency.

•Collaborated with cross-functional teams—IT, Finance, and Marketing—to understand business requirements and deliver customized analytics solutions.

•Designed and deployed interactive dashboards in Tableau to visualize sales trends, customer segmentation, and inventory levels for data-driven decision-making.

•Developed Excel-based reports with advanced charts, pivot tables, and conditional formatting, making complex data accessible to non-technical stakeholders.

•Maintained thorough documentation of analytics processes and ensured compliance with HSBC’s data governance policies.

Contact this candidate