SOUMITA SORKHEL
Open to work4 years experienceData Analyst
Data Analyst | Business Analyst
Standing Rank
Rank Not Available
Developer Badges
Skills & Technologies
12 skillsWork Experience
Deputy Manager
ICICI Bank
- Gathered and analysed operational data from cross-functional stakeholders (Product, Credit, and Operations) across a portfolio of 5,000+ active accounts to identify business trends and support data-driven decision-making on retail banking products.
- Built and maintained MIS reports, KPI trackers, and dashboards in Excel and Power BI, translating complex data into clear, actionable insights for branch-level business strategy and operational planning.
- Partnered with cross-functional teams to investigate data discrepancies, document findings, and streamline reporting workflows — driving a 30% improvement in turnaround time as part of ongoing process improvement initiatives.
- Managed a relationship portfolio of 5,000+ customers, applying data-informed engagement and strong stakeholder communication to maintain a 95% retention rate and improve customer satisfaction.
- Promoted to Deputy Manager II (DM II) in 2024 in recognition of consistent performance in data analysis, reporting, and business insight delivery.
Projects
Mobile Sales Analysis Dashboard
- Utilised Power Query to perform data cleaning and transformation across multiple datasets, ensuring data accuracy and consistency across sales, transaction, pricing, and customer-related data.
- Created a custom Date Table and developed DAX measures to calculate key performance indicators (KPIs), including Total Sales, Total Quantity, Total Transactions, and Average Price.
- Built interactive visualisations to analyse sales performance and customer behaviour by city, brand, mobile model, payment method, and customer ratings, identifying key business trends and patterns.
- Designed interactive slicers, filters, and drill-down views to enable self-service analysis and support data-driven insights into sales trends, product performance, and customer preferences.
Netflix Data Analysis Dashboard
- Cleaned and prepared Netflix content data by identifying duplicate records, missing values, and data inconsistencies, ensuring data quality for accurate analysis.
- Analysed key KPIs, including Total Titles, Movies vs. TV Shows, content growth over time, country-wise content distribution, genre distribution, and rating distribution.
- Utilised PivotTables, Pivot Charts, Excel formulas, and slicers to analyse content trends and identify patterns across content type, release year, country, genre, and ratings.
- Developed an interactive Excel dashboard to provide insights into Netflix's content growth, content mix, geographic reach, and content rating trends, supporting data-driven interpretation of the platform's content library.
Leaderboard Standings
Leaderboard Position Pending
Global test scores, peer standing percentiles, and algorithm leaderboard ranks are updated dynamically.
Assessment Highlights
Assessments Not Completed
Coding evaluations, system assessment results, and conceptual score badges will appear here after taking a test.
AI Collaboration Score
AI Collaboration Score Pending
Developer coding behavior, assistant cooperation, and AI pair-programming indicators are evaluated during live coding sessions.
Role Compatibility Profile
Role Compatibility Analysis Pending
Custom matching reports, candidate role compatibility percentiles, and core engineer strength profiles are processed once conceptual code screenings are complete.
Achievements
Promoted to Deputy Manager II
Promoted to Deputy Manager II (DM II) in recognition of consistent performance in data analysis, reporting, and business insight delivery.
About Details
Professional Bio
Data-driven banking professional with 4 years of experience in customer portfolio analysis, KPI tracking, and MIS reporting. Skilled in SQL, Excel, and Power BI for data cleaning, dashboard development, and reporting. Proven track record partnering with cross-functional stakeholders.
MBA (Master of Business Administration)
Vidyasagar University ( - Present)
BCA (Bachelor of Computer Application)
Burdwan University ( - Present)