Headline

Data Analyst | Power BI · SQL · Python · Excel| Built Dashboards for 200+ Client Accounts | Cutting Inefficiency, Driving Smarter Decisions

About

I am a results-driven Data Analyst with a passion for turning complex datasets into clear, actionable business strategies. With a Master of Computer Application and a robust technical foundation in SQL, Power BI, Excel, and Python, I specialize in building interactive dashboards and reports that simplify information for stakeholders and drive operational efficiency. My approach to data goes beyond numbers; I focus on connecting insights with real-world business needs to improve outcomes and streamline processes. Whether it’s optimizing financial portfolios or predicting healthcare trends, I thrive on solving puzzles that lead to better decision-making. Key Professional Achievements: ->Financial Portfolio Optimization: While at Talentele, I designed a Power BI dashboard for a portfolio of 200+ client accounts, resulting in a 25% improvement in collection rates and a 30% reduction in claim denial rates. ->Operational Efficiency: I successfully managed high-volume accounts receivable, achieving a 95% collection rate and a 20% reduction in outstanding balances through meticulous data review and dispute resolution. ->Predictive Analytics: I analyzed over 10,000 patient records using Python and SQL to develop predictive models that improved the accuracy of forecasting patient readmission rates by 15%. ->Core Technical Toolkit: Data Analysis & Visualization: Power BI (Desktop & Service), DAX, Matplotlib, Seaborn.Database Management: SQL Server, MySQL, Data Modeling, ETL Processes. Advanced Analytics: Python (Pandas, NumPy), Excel (LOOKUP, Pivot Tables, Power Query), Predictive Modeling. I am always eager to collaborate on new projects or discuss how Data Analytics can transform your business operations. Let’s connect! Feel free to reach out here on LinkedIn or via email at souravsumanrout@gmail.com.

Location

Bengaluru

Work experience

Associate at Kalinga IT Enabled Services LLP, Nov 2025 - Present · 8 mos, On-site

Data Analyst Intern at Talentele, Mar 2025 - Aug 2025 · 6 mos, Bhubaneswar, Odisha, India, Compiled and processed client data from raw Excel files and SharePoint, improving data analysis efficiency by 50% through the effective use of Pivot Tables and VLOOKUP. Designed and developed Power BI dashboards for a financial claims portfolio covering 200+ client accounts, enabling KPI monitoring and contributing to a 25% improvement in collection rates and a 30% reduction in claim denial rates, supporting faster revenue recognition. Collaborated with cross-functional teams to resolve billing and payment-related issues, facilitating communication with stakeholders and achieving a 15% improvement in client satisfaction. Utilized Power BI (Desktop & Service), Power Query, DAX functions, Excel LOOKUP functions, Pivot Tables, and MS SQL Server to perform data transformation, visualization, and reporting.

Data Analyst Intern at KultureHire, Sep 2024 - Feb 2025 · 6 mos, Remote, Analyzed complex datasets to identify patterns and generate meaningful insights supporting data-driven decision-making. Produced analytical reports and visual summaries, transforming raw data into structured insights for improved understanding and interpretation. Demonstrated strong attention to detail while working with real-world datasets, ensuring accuracy and reliability in analysis outputs. Adapted quickly to new challenges in a dynamic learning environment, showcasing problem-solving abilities and analytical thinking. Maintained consistent performance throughout the program, reflecting strong commitment, collaboration, and professional work ethic.

Education

Master of Computer Applications - MCA, Computer Science, Centurion University of Technology and Management