Data Analyst Business Intelligence

DEVANSH GUPTA

BI Developer

967-***-**** *******.********@*****.***

https://www.linkedin.com/in/devansh-gupta-

06410b10b Pune

SUMMARY

Business Intelligence Developer with 4+ years of experience delivering data- driven solutions in the Finance and Insurance domains. Expert in Tableau, SQL, Power BI, Excel Reporting, and JIRA Reporting. Proven track record of designing interactive dashboards, automating processes using Python, and enabling data-driven decision-making through compelling visualizations and reports.

EXPERIENCE

Tableau Developer

Bitwise Solutions Pvt. Ltd.

04/2021 - Present Pune

Designed and developed interactive Tableau dashboards, KPIs, and visual analytics for business users, enabling quick insights into operational and financial data (e.g., Student Loan portfolio).

Translated 10 business requirements into technical specifications and visual mockups, ensuring 100% accurate and impactful reporting. Created complex SQL queries (CTEs, window functions, temp tables) to prepare datasets and support Tableau reports.

Built JIRA-based and Excel-based reports for tracking Agile sprint KPIs, issue tracking, and project progress.

Migrated reporting and data processing logic from Teradata to Snowflake, and from SAS Grid to SAS Studio, adhering to tight project timelines. Automated report generation in Tableau, eliminating manual Excel-based reporting efforts and improving efficiency.

Conducted query performance optimization, reducing execution times and improving overall system responsiveness.

Provided mentorship to junior colleagues and facilitated knowledge- sharing sessions, strengthening team performance and knowledge retention.

Proactively identified and escalated data issues and job failures, ensuring minimal impact on business users.

Developed a Python-based AI compliance tracking script, enabling management to track compliance, streamline audits, and eliminate manual tracking efforts.

CERTIFICATION

Tableau Desktop Specialist

Tableau

01/2025

https://www.credly.com/badges/e9379cb8-07c4-4987-86d8- afb2290217d2

Tableau Fundamentals (Advanced)

StudySection

08/2025

https://www.studysection.com/users/socialMedia/ODEyMjk2/ZGV2YW5 zaC4wMDVndXB0YUBnbWFpbC5jb20%3D

SKILLS

Tableau Desktop, Tableau Server, Power BI

Teradata SQL, Snowflake SQL, Oracle SQL

SAS EG, Python, Java, Airflow

Excel Reporting, JIRA Reporting, Data

Visualization, Data Analytics, Compliance

Automation, GitHub

KEY ACHIEVEMENTS

Real-time Executive Dashboard

Enablement

Created a real-time Marketing Performance

Dashboard for leadership to track 20+ KPIs

for student loans.

Excel-to-Tableau Automation Efficiency

Automated 15+ Excel reports into Tableau,

saving 1 full workday per report monthly and

reducing manual workload.

Agile Metrics Visualization through JIRA

Developed JIRA dashboards for Agile team

performance tracking, sprint analysis, and

team productivity insights.

Compliance Automation Using Python

Implemented Python automation scripts for

internal compliance reporting, enhancing

accuracy and reducing manual tasks.

LANGUAGES

English

Advanced

Hindi

Native

www.enhancv.com Powered by

•

•

•

•

•

•

•

•

•

•

E

q

EDUCATION

BE Computer Engineering

Zeal College of Engineering & Research, Pune 2014 – 2019 08/2014 - 08/2019

www.enhancv.com Powered by

Contact this candidate