Data Analyst Power Bi

SOUMYA RANJAN PRADHAN

Data Analyst, Web developer

+91-814******* *******************@*****.***

Summary

Data Analyst with a strong foundation in SQL, Python, Excel, and Power BI. Skilled in cleaning, analyzing and visualizing data to generate insights and support data-driven decision-making. Interested in collaborating on meaningful analytical work in fast-paced environments. I’m also a Web Developer; I specialize in building and maintaining websites and web applications. My expertise spans both front-end developments, using HTML, CSS, and JavaScript to create responsive, user-friendly interfaces, and back-end development, handling server-side logic, databases, and API integrations.

Skills

Programming & Querying: SQL, HTML, CSS, Python

Data Visualization Tools: Advanced MS Excel, Power BI, Tableau Analytical Abilities: Data Cleaning, Exploratory Data Analysis (EDA), Insight Generation, Descriptive Statistics Experience

Data Analyst Intern at NALCO April 2024 – July 2024 Data Analytics (Remote) Tools Used: Excel, SQL, Power BI

– Processed and standardized a dataset of over 1,00,000 rows from multiple regions to support weekly analytics—enabled business teams to track KPIs across geography and time.

– Designed smart Excel templates embedded with lookup functions and pivot logic, saving 40% reporting time across 4 departments.

– Developed and maintained Power BI dashboards to visualize revenue trends, customer mix, and monthly performance—regularly used by managers and analysts across business units. Projects

Customer Churn Analysis Python March 2025 – April 2025

– Analyzed behavior of 7,043 telecom customers to identify churn patterns based on tenure, contract type, and monthly charges.

– Engineered new features including contract type buckets and tenure bands to improve segmentation and insights.

– Generated 11 visualizations (histograms, box plots, heatmaps) to highlight churn-prone segments. Sales Dashboard for Regional Performance SQL, Power BI February 2025 – March 2025

– Queried and joined 3 sales-related tables covering over 25,000 rows across 12 months and 5 regions using optimized SQL joins to create consistent, analysis-ready datasets.

– Built 10 dynamic measures and KPIs in Power BI to track regional sales, return trends, and product performance.

– Detected a 14% sales drop post-festival in the South region. Later, the insight was used for a marketing recovery plan. Awards & Certifications

• Google Data Analytics Certificate – Coursera (2024): Completed 8 practical case studies involving SQL, data cleaning, dashboards, and presentations.

• Top 5% in SQL Hackerrank Challenge – 2024: Ranked among top 150 out of more than 3,000 participants for advanced SQL problem-solving.

• Best Final Year Project – 2025, Trident Academy of Technology College: Built a Power BI dashboard analyzing academic performance across 6 departments over 3 years. Education

Btech Computer Science and Engineering Graduated: 2025 Trident Academy of Technology, Bhubaneswar CGPA: 8.2 / 10 Language

Odia,English,Hindi

Contact this candidate