Sriram S P

Data Analyst | Carelon Global Solutions

September 2023 – Present (1.8 years)

• Spearheaded multiple automation initiatives using Excel VBA, resulting in the development of over 10 automation tools to streamline manual processes and improve data accuracy.
• Designed and implemented a Time Tracker tool using Excel VBA, enabling real-time tracking and reporting of associates’ productivity and time allocation.
• Built an interactive Power BI dashboard for senior management to visualize and monitor product details and associate performance metrics, enhancing data-driven decision-making.
• Utilized SQL for querying, cleaning, and transforming large datasets to support reporting and analytics requirements.
• Currently collaborating on an end-to-end web application project to automate key processes; contributing to data integration and backend operations using PostgreSQL, Django, Visual Studio, and Postman, ensuring seamless data flow and reporting functionalities.
• Engaged in end-to-end data workflows from data extraction, transformation, analysis, visualization, and reporting to drive actionable insights for operational improvements.

Key skills: Excel VBA, Power BI, SQL, PostgreSQL, Data Automation, Data Visualization, Data Analysis, Process Automation, Dashboard Development

• Performed manual and automated testing to ensure software quality across releases.
• Developed Python scripts to automate data extraction and reporting, improving accuracy and efficiency.
• Created Power BI dashboards to visualize test coverage, defect trends, and automation metrics for stakeholders.
• Used AWS (S3, EC2) to manage test data and remote lab environments.
• Integrated testing data with Jira and Jenkins for real-time reporting on execution and defect status.
• Built automated reporting pipelines using Python and AWS for structured test result datasets.
• Analyzed historical data to identify defect patterns and recommend process improvements.
• Mentored junior testers in reporting best practices and data visualization techniques.
• Collaborated in Agile Scrum teams, contributing data insights to sprint reviews and retrospectives.

Key Skills: Power BI, Excel (Advanced), Python (Automation), AWS (S3, EC2), Jira, Jenkins, TestRail