Data Analyst Power Bi

SANJAY NOORBASHA

● Dallas, Texas ● *.***********@*****.*** ● 972-***-**** ● https://www.linkedin.com/in/sanjay420a3538/ PROFESSIONAL SUMMARY

Data Analyst and Engineer with 4+ years of experience in building scalable data pipelines, performing advanced analytics, and delivering actionable business insights. Proficient in Python, SQL, Spark, AWS, Snowflake, Tableau, and Power BI, with expertise in predictive modeling, NLP, and time series forecasting. Experienced in automating workflows, optimizing reporting, and collaborating with cross-functional teams to drive data-driven decisions, improve customer engagement, and support business growth. EDUCATION

YOUNGSTOWN STATE UNIVERSITY, YOUNGSTOWN, OHIO December 2023 Master of Science in Computing and Information Systems R.V.R. & J.C. COLLEGE OF ENGINEERING, INDIA May 2019 Bachelor of Technology in Computer Science &Engineering PROFESSIONAL EXPERIENCE

Capital One, Plano, TX December 2024 – Present

Data Analyst

• Built and maintained scalable data pipelines using Python, SQL, Spark, and AWS to process large volumes of transactional and behavioral data, helping teams make faster, more accurate decisions.

• Developed dashboards and reports in Power BI and Tableau to track key metrics such as customer engagement, fraud detection, and operational performance, cutting manual reporting time by 40%.

• Conducted cohort, trend, and predictive analyses to uncover customer behavior patterns and churn risks, supporting retention strategies that increased customer lifetime value by 12%.

• Worked closely with marketing, risk, fraud, and finance teams to turn business requirements into actionable analytics solutions, supporting strategy and operational improvements.

• Implemented automated data quality monitoring and governance processes, ensuring over 98% accuracy and providing reliable data for business decisions.

Nebula Partners LLC, Alpharetta, GA February 2024 – December 2024 Data Engineer Intern

• Built and maintained ETL pipelines to extract, transform, and load transactional and customer data from AWS S3 into Snowflake, ensuring clean and reliable datasets for analytics.

• Designed schemas, staging tables, and optimized queries in Snowflake, reducing report generation by 30% and improving efficiency for analysts.

• Automated daily data loads and monitoring using Python scripts and SQL validation checks, improving pipeline reliability and reducing manual effort by 40%.

• Applied Snowflake Time Travel and Cloning features to support audit, compliance, and sandbox testing, ensuring data accuracy and regulatory alignment.

• Developed Power BI dashboards connected to Snowflake to track customer churn, fraud patterns, and transaction trends, enabling business leaders to make faster, data-driven decisions.

• Documented pipeline processes and created technical guides, supporting team collaboration and compliance reporting. ERICOM SOFTWARE SYSTEMS PVT LTD., Hyderabad, India. June 2019 - July 2022 Data Analyst/Engineer

• Developed customer sentiment analysis models using NLP techniques and pre-trained BERT, improving customer experience insights and driving a 15% increase in satisfaction.

• Led a team delivering 100+ daily operational and ad hoc reports using SQL and Excel automation, increasing reporting efficiency by 70%.

• Created dynamic Tableau dashboards to monitor sales trends and identify new business opportunities, enabling 10% growth in targeted campaigns.

• Automated customer inquiry categorization workflows with SQL, reducing response times and improving SLA compliance by 86%.

• Built ETL pipelines using Python and Spark SQL to integrate and cleanse data from multiple sources, enhancing data accessibility and reducing processing times by 20%. ACADEMIC PROJECTS

• Walmart Sales Forecasting – Built ensemble models (LSTM, LightGBM) in Python to predict 28-day retail sales using 5 years of historical data; achieved an RMSE of 0.056, enabling data-driven inventory and marketing decisions.

• Marketing Campaign Performance Dashboard – Developed Tableau dashboards to monitor campaign KPIs, customer engagement, and conversion trends; integrated predictive insights to optimize targeting and improve campaign ROI.

• Customer Segmentation & Predictive Modeling – Used clustering and predictive models in Python to segment large customer datasets, evaluate campaign effectiveness, and recommend strategies that increased engagement rates by 12%.

• A/B Testing & Campaign Optimization – Conducted hypothesis testing and multivariate analyses on advertising channels; identified Channel 1 outperforming Channel 2 by 85%, leading to actionable campaign recommendations.

• AI-Driven Workflow Automation – Designed and implemented automated data workflows using n8n, integrating multiple data sources for analytics. Applied basic AI prompt engineering to generate insights, automate reporting, and assist scenario analysis, reducing manual effort and data processing time by 30%.

SKILLS

Programming & Scripting: Python, SQL, R, DAX, VBA

Data Analysis & Visualization: Pandas, NumPy, Matplotlib, Seaborn, Tableau, Power BI, Looker, Google Data Studio, Excel (Pivot Tables, VLOOKUP, Macros)

Data Engineering & ETL: Python ETL, Spark SQL, Apache Spark, Hadoop, Databricks, n8n, SQL-based pipelines Data Warehousing & Cloud Platforms: Snowflake, Redshift, Azure Data Factory, Azure ML Studio, AWS (S3, Redshift, Lambda), Google BigQuery

Machine Learning & AI: Scikit-learn, TensorFlow, XGBoost, LightGBM, NLP (BERT), Predictive Modeling, Time Series Forecasting, Classification, Regression, Clustering

Statistical & Analytical Techniques: Data Cleaning, EDA, A/B Testing, Hypothesis Testing, Statistical Inference, Cohort & Trend Analysis

Workflow Automation & Reporting: Automated Reporting, Dashboards, Data Quality Monitoring Domain Knowledge: Marketing Analytics, Customer Segmentation, Fraud Detection, Investment Data Reporting, Business KPIs Collaboration & Productivity: Git, Jira, VS Code, Microsoft Office Suite Soft Skills: Data Storytelling, Stakeholder Communication, Cross-functional Collaboration, Problem Solving, Critical Thinking Certifications: Microsoft Data Analyst Associate (Power BI), AWS Certified Data Analytics.

Contact this candidate