Business Intelligence Data Analyst

Venkata Sai Kalyan Manavarthi

*******************@*****.*** 940-***-**** TX, USA https://www.linkedin.com/in/venkatasai-kalyan/ SUMMARY

Data Analyst with 3+ years of experience in delivering business intelligence and advanced analytics solutions across BFSI, Healthcare, and Energy domains. Skilled in SQL, Python, and R for data querying, automation, and statistical modeling. Proficient in building interactive dashboards using Tableau and Power BI, complemented by strong expertise in Excel for ad-hoc reporting. Experienced in developing and managing ETL workflows with Informatica, Apache Airflow, and AWS Glue, enabling seamless data integration from diverse sources. Adept at leveraging cloud platforms (AWS, Azure, Snowflake) to optimize reporting pipelines, support risk analytics, and deliver actionable insights for stakeholders. Recognized for transforming complex datasets into meaningful strategies through business intelligence, machine learning techniques, and collaborative problem solving in Agile environments. TECHNICAL SKILLS

Programming & Querying: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn), R (ggplot2, dplyr, caret, tidyverse), SQL (MySQL, PostgreSQL, SQL Server, Oracle, Redshift, Snowflake) Data Engineering & ETL: Informatica, Alteryx, Talend, Data Pipelines (Apache Airflow, AWS Glue, Azure Data Factory), Big Data Basics (Hadoop, Spark)

Cloud Platforms: AWS (S3, Redshift, Lambda), Azure (Synapse, Data Factory, Power BI Service) GCP

(BigQuery)

Visualization & Reporting: Tableau, Power BI, Looker, Advanced Excel (Pivot Tables, Power Query, VBA, Macros)

Analytics & Domain Knowledge: Business Intelligence & Reporting, Financial Data Analysis, Risk Analytics (BFSI), Healthcare Claims & Clinical Data Analytics (Healthcare), Customer Segmentation, Marketing Analytics, A/B Testing (Retail/E-commerce), Supply Chain Analytics (Logistics) Machine Learning & Statistics: Regression (Linear, Logistic), Classification (Decision Trees, Random Forest, XGBoost), Clustering (K-Means, Hierarchical), Time Series Forecasting (ARIMA, SARIMA, Prophet basics), A/B Testing & Hypothesis Testing

Project Management & Methodologies: Agile, Scrum, Waterfall, Jira, Confluence, Git, GitHub, SDLC

(Software Development Life Cycle)

PROFESSIONAL EXPERIENCE

JPMorgan Chase & Co TX, USA

Data Analyst Mar 2025 – Current

Designed ETL workflows in Informatica and AWS Glue to streamline data ingestion across S3, Redshift, and SQL Server, ensuring seamless integration of structured and semi-structured datasets.

Engineered queries in SQL and Snowflake to optimize reporting pipelines supporting risk analytics and regulatory compliance requirements.

Automated daily reporting processes using Python (Pandas, NumPy), reducing manual interventions and improving accuracy in business intelligence dashboards.

Developed interactive Power BI dashboards with DAX measures and integrated them with Azure Data Factory pipelines to deliver real-time insights for financial operations teams.

Authored scripts in R (dplyr, tidyverse) to validate data quality checks, improving the reliability of key metrics used in decision-making for BFSI stakeholders.

Structured time-series models using Prophet and SARIMA in Python, supporting trend analysis and forecasting for transaction monitoring activities.

Coordinated with cross-functional teams under Agile frameworks using Jira and Confluence, ensuring deliverables aligned with business requirements.

Leveraged Advanced Excel (Pivot Tables, Power Query, VBA) to build interim reporting tools that complemented enterprise-level dashboards and supported ad-hoc analytics requests. Adani HYD, India

Data Analyst Feb 2021 – Dec 2022

Constructed ETL workflows with Apache Airflow and Talend to centralize operational data, aligning business reporting standards across divisions.

Queried relational databases (MySQL, PostgreSQL, Oracle) to prepare datasets for exploratory analysis and visualization in Tableau.

Implemented classification models such as Random Forest and XGBoost in Python to evaluate project risk and resource utilization patterns.

Produced Tableau dashboards that visualized customer segmentation outcomes and supported strategic planning initiatives for marketing teams.

Deployed Azure Synapse Analytics solutions to consolidate structured data from disparate systems, facilitating advanced analytics on key performance indicators.

Applied K-Means clustering techniques in R to analyze customer behavior data, identifying distinct groups that improved campaign targeting strategies.

Maintained version control for scripts and ETL jobs using GitHub, enabling collaborative development and smoother deployment cycles.

Documented workflows and data dictionaries as part of SDLC best practices to ensure knowledge transfer and sustainability of analytics solutions. Cipla HYD, India

Data Analyst Intern Jun 2020 – Jan 2021

Retrieved healthcare claims data through SQL queries and transformed datasets into analysis-ready tables for compliance reporting.

Prepared Excel-based reports incorporating Pivot Tables and macros that supported ongoing performance monitoring in clinical operations.

Built prototype dashboards in Power BI to visualize clinical trial metrics, demonstrating the value of interactive analytics to stakeholders.

Executed regression models in R to analyze experimental trial data and identify significant variables influencing treatment outcomes.

Scripted automation tasks in Python to clean and preprocess unstructured datasets, improving the usability of clinical records for downstream analysis.

Explored the application of Hadoop and Spark in batch processing pipelines, assisting the team in evaluating big data frameworks for research projects.

Collaborated with senior analysts under Agile methodology, attending sprint planning sessions and contributing to backlog refinement for data-related tasks.

Drafted technical documentation and training notes to support ongoing adoption of BI and reporting tools within the analytics team.

EDUCATION

University of North Texas TX, USA

Master of Science in Advanced Data Analytics Jan 2023 – Dec 2024 Audisankara College of Engineering and Technology India Bachelor in Electronics and Communication Engineering Jun 2017 – May 2021 CERTIFICATIONS

Accenture North America – Data Analytics & Visualization Job Simulation (Forage) R Programming – DataCamp

CORE COMPETENCIES

SQL, Python, R, Tableau, Power BI, Excel, AWS, Azure, Snowflake, Redshift, Informatica, Airflow, Hadoop, Spark, Alteryx, ETL, Data Modeling, Data Wrangling, Machine Learning, Predictive Analytics, Time Series, Business Analysis, A/B Testing, Agile, Jira.

Contact this candidate