Open to opportunities

Kumara Naga Venkata Rama Satish Vankayala

@kumaranagavenkataram

I build automated analytics and KPI dashboards that turn complex data into operational decisions.

I'm building scalable reporting solutions at Citi Bank, where I use SQL, Python, Snowflake, AWS Redshift, Power BI, and Tableau to make financial data more accessible and actionable.

I've reduced query runtime by 35%, cut manual reporting time by 40%, and improved operational reporting accuracy by 25% through Python-based root cause analysis. I also maintain more than 12 Power BI dashboards with dynamic KPIs and trend analysis, and automated reporting delivery to reduce turnaround time by 50%.

Previously at Beansh Business Services, I automated weekly reporting with Python and Pandas, created KPI dashboards, and standardized ETL transformations with dbt. My work reduced reporting errors by 25%, dataset preparation time by 40%, and improved operational efficiency by 20%.

I'm completing a Master of Science in Business Analytics and enjoy turning validated, well-modeled data into clear insights for cross-functional stakeholders.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

Citi Bank

Feb 2024 - Present (2 years 6 months)

Extracted complex datasets using advanced SQL query optimization, reducing query runtime by 35%. Automated data workflows with Python and Pandas, cutting manual reporting time by 40% and developed over 12 Power BI dashboards.

SQL PostgreSQL Redshift Advanced SQL Query Optimization Python Pandas NumPy data transformation Data Cleaning Data Validation Root Cause Analysis Power BI Tableau Redash Dashboard Development AWS Snowflake Data Build Tool (Dbt)

Data Analyst

Beansh Business Services

May 2021 - Jun 2023 (2 years 1 month)

Extracted actionable datasets using optimized SQL queries with complex joins and CTEs, reducing query runtime by 35%. Automated weekly reporting workflows with Python and Pandas, cutting manual processing time by 50% and created interactive Power BI dashboards tracking over 15 KPIs.