Open to opportunities

Srujana Aella

@srujanaaella

Message

Experienced data analyst with expertise in automotive and healthcare analytics.

United States

Message

What I'm looking for

I seek a role that fosters collaboration, innovation, and continuous learning in data analytics.

I am an analytical and detail-oriented professional with over 8 years of experience in the automotive and healthcare analytics sectors. My proficiency in SQL, Tableau, Power BI, and R has enabled me to design and maintain impactful dashboards and reports that drive decision-making and operational efficiency. I have a strong background in data modeling, ETL workflows, and dashboard development, particularly in the context of infotainment and telematics datasets.

Throughout my career, I have collaborated with cross-functional teams to analyze vehicle systems and define requirements, delivering scalable data solutions that align with business objectives. My experience includes leading data migration projects, modernizing dashboards, and ensuring compliance with HIPAA and GDPR standards. I am passionate about leveraging data to improve patient care and operational performance, and I thrive in environments that challenge my analytical skills and foster innovation.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

Fresenius Medical Care

Oct 2024 - Present (9 months)

Analyzed large healthcare datasets to identify trends in patient care, treatment outcomes, and operational performance. Developed interactive dashboards using Tableau, SQL, and R to visualize patient metrics, clinical KPIs, and financial indicators.

Tableau SQL R Salesforce HIPAA)Data Validation Data Governance ETL Data Visualization Data Analysis

Functional Data Analyst

Stellantis

Feb 2023 - Present (2 years 5 months)

Created and optimized SQL queries for data extraction, transformation, and validation to support analytics initiatives. Designed and developed Tableau dashboards using MySQL connectors, Excel, and CSVs for visualizing vehicle performance and sales trends.

SQL Tableau MySQL Power BI ClickUp Agile Jira Data Mapping

Technical Lead & Product Manager / Data Analyst

Ford Motor Company

Apr 2018 - Present (7 years 3 months)

Designed and executed advanced SQL queries for data extraction, ETL operations, and backend testing. Built QlikView dashboards to visualize fleet performance, vehicle diagnostics, and system health data.

SQL Qlikview ETL HIPAA)Salesforce UML Selenium Git Agile

Data Analyst

Danlaw

Jun 2017 - Present (8 years 1 month)

Developed and optimized SQL Server and Snowflake queries for large-scale data processing and analytics. Designed, developed, and deployed SSRS reports, including drill-down and parameterized reports.

SQL Server Snowflake SSIS Salesforce ETL Jira Bugzilla Agile

Business Data Analyst

MEKSWEB PVT LTD.

May 2015 - Present (10 years 2 months)

Created and managed user stories, acceptance criteria, and sprint tasks using JIRA, Confluence, and Rally. Worked with Oracle SQL Developer and Ambari to extract, transform, and analyze operational data.

Jira Confluence Rally Power BI ETL Data Mapping Salesforce Informatica SharePoint)

Education

Degrees, certifications, and relevant coursework

Colorado Technical University

Masters, Computer Science

Completed a Masters in Computer Science, gaining advanced knowledge in the field. This program enhanced my analytical and problem-solving skills.

Google

Professional Certificate, Data Analytics

Obtained the Google Data Analytics Professional Certificate, focusing on data analysis, visualization, and reporting. This certification provided practical skills in handling large datasets and creating insightful dashboards.