Data Analyst Power Bi

MANOJ KUMAR VALLABHANENI

Kentucky, USA +1-859-***-**** ******************@*****.*** LinkedIn Summary

Data Analyst with 4+ years of experience specializing in financial risk analysis, data engineering, and business intelligence. Expertise in Python, SQL, Snowflake, dbt, Tableau, and Power BI to build automated ETL pipelines, optimize cloud data warehouses, and develop interactive dashboards that drive strategic decisions. Proven ability to enhance operational efficiency, reduce costs, and ensure regulatory compliance across banking, healthcare, and academic domains. Strong collaborator adept at translating business needs into technical solutions for stakeholders at all levels. Skills

Programming & Scripting Languages: Python, SQL, R, SAS, Bash/Shell Scripting

Cloud Data Platforms: Snowflake, AWS (S3, Glue, Athena), Azure

(Synapse, Data Lake), Google Cloud Platform, Data Warehousing

ETL/ELT & Data Pipeline Tools: dbt, Azure Data Factory, Alteryx, Apache Airflow, ETL

Data Visualization & BI Tools: Tableau, Power BI, DAX, Power Query, Matplotlib, Seaborn, Microsoft Excel

Methodologies & Frameworks: Agile, Waterfall

Machine Learning: Scikit-learn, Random Forest, XGBoost, Forecasting (ARIMA), A/B Testing, Hypothesis Testing, Regression, KNN, Decision Tree, Naive Bayes, Statistical Modelling

Databases & Data Modeling: SQL Server, Oracle, PostgreSQL, MySQL, MongoDB, SQLite, Star Schema, Data Modeling

Data Governance & Compliance: GDPR, HIPAA, FCRA, SOC2, Data Quality Frameworks, PII Handling

DevOps & Version Control: Git, API Integration, Data Pipeline Monitoring, Alerting Systems, Visual Studio Code, SDLC

Data Management & Analytics: Data Cleaning, Data Mining, Data Wrangling, Statistical Analysis, NumPy, Pandas, SciPy

Domain Expertise: Financial Risk Analysis, Fraud Detection, Healthcare Analytics (EMR, HL7), Retail/CRM Analytics

Soft Skills: Stakeholder Collaboration, Technical Documentation, Cross-functional Training, Data Storytelling

Professional Experience

Data Analyst 01/2025 to Current

Capital One Remote, USA

Automated credit risk data validation to reduce reporting errors by 8%, ensuring regulatory compliance for finance teams.

Developed Tableau dashboards to track 50+ customer segmentation metrics, improving targeted marketing ROI by 18%.

Optimized SQL queries to cut loan approval data processing time from 4hrs to 30mins, benefiting underwriting teams.

Collaborated with fraud detection teams to refine anomaly algorithms, reducing false positives by 12%.

Mined transaction data to identify 3 new cross-sell opportunities, generating $2M in incremental revenue.

Migrated legacy SAS scripts to Python to modernize 10+ risk models, saving 200+ hours/year.

Designed A/B test frameworks to evaluate digital banking features, increasing user engagement by 22%.

Audited 5+ third-party data vendors to ensure 100% FCRA compliance, mitigating legal risks.

Forecasted quarterly charge-off rates to adjust loss reserves, improving accuracy by 15%.

Presented data-driven cost-cutting strategies to executives, influencing FY2026 budget priorities. Graduate Assistant 08/2023 to 12/2024

Eastern Kentucky University Richmond, KY

Automated attendance tracking for 15+ courses using Python, reducing manual grading by 5 hours weekly for faculty.

Developed Tableau dashboards monitoring 200+ student performance metrics, enabling early intervention for at-risk students.

Audited and corrected 2,000+ student records in Banner SIS, ensuring 100% data integrity for registrar submissions.

Tutored 50+ students in R, SPSS, and SQL, improving practical exam scores by 15% on average.

Migrated 10 years of course evaluations to an SQLite database, streamlining data access for program reviews. Data Analyst 07/2022 to 07/2023

Persistent Systems Limited Pune, India

Engineered scalable data pipelines in Snowflake via dbt, reducing data processing time by 8 hrs per week for data engineering team.

Optimized Snowflake warehouse configurations and storage procedures, achieving a $15K annual cost savings for the cloud infrastructure department.

Automated 15+ manual data workflows using Python and shell scripting, eliminating 20 hours of manual effort monthly for the BI team.

Developed interactive Power BI dashboards tracking 5+ key business KPIs, enabling executives to make data-driven decisions faster.

Migrated 10+ legacy ETL jobs to the Snowflake platform, enhancing data reliability and reducing job failures for the operations team.

Implemented data quality frameworks with SQL assertions in dbt, preventing 500+ erroneous records from reaching production for end-users.

Designed star schema data model for the enterprise data warehouse, improving query performance for analytical reports by 40% for business analysts.

Orchestrated data ingestion routines from 5+ SaaS applications via APIs, ensuring daily data availability for sales and marketing teams.

Authored technical documentation for all deployed data models and pipelines, cutting new team member onboarding time by 3 weeks.

Collaborated with data scientists to productionize a machine learning model, creating feature store that improved prediction accuracy.

Resolved 200+ data discrepancies through root cause analysis, preventing a potential $50K reporting error for the finance department.

Monitored data pipeline performance and built alerting systems, decreasing system downtime by 5 hours per month.

Translated business requirements from 3 different departments into technical specifications for 10+ new data assets. Data Analyst 06/2021 to 07/2022

Capgemini Remote, India

Transformed 10+ TB of IoT sensor data to predict equipment failures, reducing downtime by 18% for manufacturing clients.

Created Power BI dashboards to visualize sales trends, enabling regional managers to adjust targets quarterly.

Assisted in migrating client data to Azure to reduce storage costs by $50K/year for cloud operations teams.

Tested 200+ data pipelines to ensure SLA adherence, preventing 15+ potential outage incidents.

Anonymized PII in datasets to meet GDPR requirements, protecting 100K+ customer records.

Automated weekly sales reports using Python, saving 8 hours/month for the sales analytics team.

Collaborated with UX researchers to analyse A/B test results, improving app engagement by 9%.

Integrated weather API data to predict delivery delays, reducing logistics costs by 9% for retail clients.

Piloted an NLP tool to analyze 10K+ customer service logs, identifying 3 key churn drivers.

Coordinated with cybersecurity to encrypt 5+ client datasets, achieving 100% SOC2 compliance.

Audited 5 legacy reports to retire redundant metrics, simplifying leadership reviews.

Supported a data warehouse upgrade to reduce query runtime from 20 mins to 5 mins. Certifications

Microsoft Certified: Azure Fundamentals (AZ-900)

Google Cloud Certified Associate Cloud Engineer

Education

Master of Science: Computer Science 12/2024

Eastern Kentucky University Richmond, KY, USA

Bachelor of Technology: Computer Science and Engineering 07/2022 Jawaharlal Nehru Technological University Anantapur, India Projects

Titanic Dataset EDA & Visualization: Conducted exploratory data analysis on the Titanic dataset to identify key factors influencing survival rates. Developed 5+ interactive visualizations (bar charts, scatter plots), improving stakeholder clarity and engagement by 30%.

Medical Insurance Cost Prediction: Pre-processed and engineered features from raw medical data using one-hot encoding and normalization to improve model fairness. Performed EDA with visualizations to uncover demographic and lifestyle trends driving insurance premiums.

Contact this candidate