Data Analyst & BI Developer

Sahil
Rokkam

Turning raw data into decisions — building Power BI dashboards, ETL pipelines, and GenAI-powered applications for banking and government organizations.

Vijayawada, Andhra Pradesh, India
+91 9701725465
1.5+
Years Experience
12+
Power BI Dashboards
39
Banking Branches
26
Districts Covered

Transforming Data
Into Decisions

I'm a Data Analyst and Business Intelligence Developer with 1.5+ years of experience building analytics solutions, executive dashboards, ETL pipelines, and AI-powered applications for banking and government organizations.

I've delivered 12+ Power BI dashboards supporting operational and strategic decision-making across 39 banking branches and district-level monitoring systems covering all 26 districts of Andhra Pradesh.

My strength lies in translating complex business requirements into scalable reporting solutions — and recently, in bridging the gap between enterprise data and non-technical stakeholders through conversational GenAI applications.

Power BI SQL Python GenAI ETL Pipelines DAX
📊
12+
Power BI dashboards deployed in production
🏦
39
Banking branches monitored via centralized BI
🗺️
26
Andhra Pradesh districts tracked in real time
🤖
GenAI
NL-to-SQL chatbot for government officers

Professional Experience

Power BI Developer / AI Solutions Developer
Oct 2024 – Present
Code Trees Software Solutions Pvt. Ltd.
Power BIDAX SQLPython FlaskGenAI ETLAPIs
  • Developed and deployed 12+ Power BI dashboards enabling business performance tracking across 39 banking branches for APCOB and DCCB leadership.
  • Designed advanced DAX measures, KPI scorecards, variance analysis models, and automated reporting workflows to improve decision-making efficiency.
  • Built district-level performance monitoring dashboards covering all 26 districts of Andhra Pradesh, enabling data-driven intervention planning.
  • Developed commodity price monitoring systems helping government stakeholders identify pricing anomalies and monitor MSP compliance.
  • Engineered a GenAI-powered chatbot enabling government officers to query enterprise datasets using natural language, backed by a SQL Agent architecture.
  • Built AI-assisted document processing workflows supporting PDF, DOCX, XLSX, CSV, and OCR-based ingestion.
  • Built and maintained ETL pipelines using SQL, Power Query, and API integrations for near real-time reporting environments.
Data Analyst Intern
Apr 2024 – Sep 2024
Code Trees Software Solutions Pvt. Ltd.
Power BISQL Data PreparationReporting
  • Developed Power BI dashboards and analytical reports using relational databases and API-driven datasets.
  • Performed data preparation, transformation, cleansing, and validation activities for client reporting initiatives.
  • Presented analytical findings and business recommendations to internal and external stakeholders.
  • Supported dashboard testing, validation, and performance optimization activities.

Featured Projects

🏦
Enterprise Banking Analytics Platform
Challenge

Branch performance monitoring was fragmented across multiple banking locations with no centralized visibility for leadership teams.

Solution

Built Power BI dashboards integrating customer engagement, loan performance, deposit growth, and branch-level KPIs into a unified view.

✓ Leadership monitors 39 branches through a single centralized reporting suite
🗺️
Government Performance Monitoring Platform
Challenge

Limited visibility into district-level program execution across Andhra Pradesh hindered effective resource allocation and intervention.

Solution

Developed district monitoring dashboards covering all 26 districts with drill-down reporting and performance indicators for government officials.

✓ Improved visibility enabling targeted, data-driven intervention planning statewide
🤖
GenAI-Powered Data Assistant
Challenge

Business users and government officers lacked SQL knowledge to access and query enterprise datasets independently.

Solution

Developed a natural language interface using GenAI and SQL-agent architecture with prompt engineering for accurate query translation.

✓ Non-technical users can now query enterprise data via conversational language

Technical Skills

Business Intelligence
Power BI DAX Power Query (M) Dashboard Development KPI Reporting Data Visualization Executive Reporting Data Modeling
Data & Analytics
SQL MySQL ETL Development Data Transformation Data Cleaning Data Validation Trend Analysis API Integration
Programming & AI
Python Pandas Flask Prompt Engineering GenAI Applications SQL Agents Conversational Analytics HTML / CSS / JS
Business Functions
Requirements Gathering Stakeholder Management Performance Monitoring Decision Support Business Reporting

Education & Certifications

🎓
Bachelor of Science — Data Science
KBN Degree College
CGPA: 7.8
Professional Certifications

Get in Touch

Open to new opportunities in data analytics, BI development, and AI-powered solutions. Whether you have a project in mind or just want to connect — reach out.

+91 9701725465
Vijayawada, Andhra Pradesh, India
✓ Thanks for reaching out! Your message has been received. Sahil will get back to you soon.