Power Bi Business Intelligence

NITISH KUMAR

Phone: : 234-***-**** Email: *******************@*****.*** LinkedIn

SUMMARY

Data professional with 4+ years of experience analyzing, modeling, and visualizing data to support business decisions in the finance and technology sectors. Applied SQL, Python, and BI tools to reduce reporting time, uncover cost inefficiencies, and improve data- driven strategies. Designed automated dashboards, developed predictive models, and led cross-functional analysis projects across cloud and on-prem environments. Focused on building reliable data pipelines, improving reporting accuracy, and translating complex datasets into actionable insights.

TECHNICAL SKILLS

• Analytics & BI Tools: Power BI, Tableau, Looker

• Programming & Data Analysis: SQL, Python (Pandas, NumPy, TensorFlow, Matplotlib, Seaborn, scikit-learn), R (dplyr, ggplot2)

• Databases & Data Warehousing: Snowflake, MySQL, PostgreSQL, MongoDB

• Cloud Platforms: AWS (Redshift, S3), GCP

• Big Data Technologies: Hadoop, MapReduce

• ETL & Workflow Orchestration: Alteryx, Apache Airflow, Excel (Power Query, VBA)

• Statistical & Analytical Techniques: A/B Testing, Forecasting, Cohort Analysis, Data Cleaning, KPI Tracking, Regression Analysis, Clustering, Classification, Statistical Inference, Hypothesis Testing

• Version Control & Collaboration: Git, GitHub

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst January 2025 – Present Capital One, USA

• Reduced manual reporting time by 40% by automating 15+ executive dashboards using Power BI and optimizing SQL data models.

• Identified $1.2M in marketing overspend by conducting customer segmentation and cohort analysis using SQL and Excel.

• Improved customer retention forecasting by 20% by developing churn prediction models in Python using scikit-learn, achieving 87% model accuracy.

• Increased operational transparency by defining 10+ KPI metrics in partnership with business teams, tracked via Power BI and Looker.

• Detected anomalous fraud trends by analyzing 500K+ transaction records using SQL and Python, supporting compliance reporting.

• Enhanced data quality by 30% by redesigning ETL workflows using Airflow and SQL-based validation checks across Snowflake and Redshift.

Data Analyst December 2020 – April 2023

Novahire Tech, India

• Delivered weekly performance reports using SQL, Excel, and Power Query, increasing stakeholder response time and decision-making efficiency by 25%.

• Reduced report generation time by 50% by rewriting inefficient SQL queries and optimizing data joins in PostgreSQL and MySQL databases.

• Designed Tableau dashboards for tracking sales trends and customer engagement, adopted by 4+ departments to guide campaign strategies.

• Led A/B testing analysis on new UI components, identifying winning variants with 18% higher engagement, using Python

(Pandas, Seaborn).

• Consolidated 5+ fragmented datasets into a centralized reporting environment using Alteryx and Excel Power Query, improving data reliability across marketing and finance.

• Visualized business KPIs by converting unstructured logs into SQL queries and generating reports in R (ggplot2, dplyr), enabling department heads to monitor operational metrics.

• Created forecasting models to project monthly revenue and churn using Python (scikit-learn), achieving a prediction accuracy of 7% over actuals.

• Collaborated with engineering to implement data validation scripts that reduced manual QA checks by 40%, ensuring clean pipelines for analytics.

EDUCATION

Master of Computer Science August 2023 – December 2024 Kent State University, Kent, OH

GPA: 3.73/4.0

Bachelor of Engineering – Computer Science July 2019 – May 2023 Sathyabama Institute of Science and Technology

GPA: 3.0/4.0

Contact this candidate