Soma Choudhury

Soma Choudhury

Business Intelligence (BI) Data Analyst
India

نبذة عني

Business Intelligence Analyst with proficiency in Power BI, SQL, Python, and Excel. Recently transitioned into Business Intelligence through professional certifications and hands-on freelance projects focused on data ana…

الخبرة

Freelance Business Intelligence & Data Analyst

Self-Employed
Jul 2025 - حتى الآن · 1 سنة 3 أشهر

<p>Designed and delivered an end-to-end Power BI HR Analytics dashboard for a consultancy client, covering employee attrition, headcount trends, and performance KPIs using DAX measures and dynamic slicers.<br>
Built a Sales Performance Monitoring report in Power BI for a retail SME, integrating multiple data sources via Power Query; enabled tracking of regional sales.<br>
Scraped engineering college data using Python (BeautifulSoup).<br>
Cleaned and transformed the dataset for analysis using Power Query and built an interactive Power BI dashboard.<br>
Analysed IITs, IIITs, NITs and private colleges based on fees, courses, ratings, reviews and city-wise distribution.<br>
Collected hotel data through web scraping.<br>
Performed sentiment, pricing and revenue analysis.<br>
Created dashboards showing city-wise revenue, average ratings, top-rated hotels, price distribution and review trends.<br>
Processed and analysed the World Happiness dataset.<br>
Used Generative AI to derive insights.<br>
Built dashboards covering GDP, life expectancy, social support and happiness score comparisons.</p>

Data Analyst Intern (Hybrid)

Analytics Space. · Hyderabad, India
Aug 2024 - May 2025 · 8 أشهر

<p>Cleaned and pre-processed large datasets, improving data accuracy by 20% for better analysis and reporting.<br>
Built and executed SQL queries to extract, manipulate, and aggregate data from various sources (MS SQL).<br>
Developed dashboards and visual reports using Tableau and Power BI to present actionable business insights.<br>
Performed exploratory data analysis (EDA) with Python (Pandas, NumPy), uncovering trends that informed decision-making.<br>
Worked as project coordinator with HR responsibilities.<br>
Coordinated cross-functional teams and managed project timelines, ensuring 95% on-time delivery of HR projects and initiatives.<br>
Leveraged Excel and Tableau to track project milestones, resource allocation, and performance metrics, improving reporting efficiency by 30%.<br>
Analyzed HR data to identify trends in employee performance and satisfaction, providing actionable insights that enhanced employee engagement by 20%.<br>
Led the implementation of Agile methodologies in project management, resulting in improved team collaboration and faster decision-making.</p>

Worked as Business Analyst

Showytech Solutions Pvt. Ltd · Hyderabad, India

<p>Conducted business requirement analysis, facilitating communication between stakeholders and development teams to ensure alignment on project goals.<br>
Used SQL to extract, clean, and analyze data for process optimization, identifying key operational inefficiencies that led to a 15% improvement in workflow.<br>
Designed and delivered reports and dashboards in Excel and Tableau to monitor project progress, KPIs, and business performance, enhancing data-driven decision-making.</p>

HR Manager

Showytech Solutions Pvt. Ltd · Hyderabad, India

<p>Managed recruitment, onboarding, and employee engagement initiatives, improving retention by 12% through targeted HR programs.<br>
Utilized SAP HCM for efficient employee data management and reporting, reducing administrative time by 25%.<br>
Developed and implemented HR policies and procedures, improving compliance and streamlining HR operations.</p>

Senior HR Executive

Apollo Microsystems Pvt. Ltd · Hyderabad, India

<p>Coordinated HR functions, including employee performance management, training programs, and payroll administration.<br>
Introduced a data-driven performance review system using Excel and internal databases, which improved performance feedback by 20%.<br>
Collaborated with senior management to align HR strategies with company goals, improving workforce productivity by 15%.</p>

المهارات

Python SQL Data Analysis Data Visualization Tableau Power BI Excel Data Cleaning Data Transformation ETL Dashboarding KPI Monitoring Data Reporting Data Interpretation Statistical Analysis SQL Querying Data Wrangling Data Extraction Data Modeling Business Intelligence Analytical Thinking Problem Solving Data-driven Decision Making BRD FRD JIRA Performance Metrics Business Metrics Trend Analysis Reporting Automation Agile Methodology Project Management Stakeholder Communication HR Analytics Employee Attrition Analysis Sales Performance Analysis Time-Series Analysis Business Analysis Process Optimization Data Insights Data Integrity DAX Power Query BeautifulSoup Pandas NumPy MS SQL SAP HCM
الإبلاغ عن هذا الملف الشخصي؟