Data Analyst - SQL, Python, Power BI

Srilatha Kothuri

Minnesota, United States

+1-612-***-****

********.*******@*****.***

www.linkedin.com/in/srilatha-k-202397213

PROFESSIONAL SUMMARY

Data Analyst with 4 years of experience transforming complex business data into actionable insights using SQL, Python, Excel, and modern BI tools. Strong expertise in SQL, Power BI, Tableau, and Python for data analysis, reporting, and visualization. Experienced working with cloud data platforms including Azure, AWS, and Snowflake and building scalable ETL pipelines using Azure Data Factory, SSIS, and Databricks. Skilled in Data Modeling using Star and Snowflake schemas, building dashboards, performing exploratory data analysis, and delivering KPI-driven insights for healthcare, telecommunications, and enterprise analytics environments.

TECHNICAL SKILLS

Programming & Query Languages SQL, Python (Pandas, NumPy)

Data Visualization & Reporting Power BI, Tableau, Advanced Excel (Power Query, Power Pivot, PivotTables, XLOOKUP)

Cloud Platforms Microsoft Azure (Azure Data Lake Gen2, Azure SQL, Azure Data Factory), AWS (S3), Snowflake

Data Engineering & ETL Azure Data Factory, SSIS, Databricks (PySpark)

Data Modeling Star Schema, Snowflake Schema, Data Warehousing

Tools & Platforms Git, Azure DevOps, JIRA

PROFESSIONAL EXPERIENCE

T-Mobile — Overland Park, KS, USA Jan 2024 – Present

Data Analyst

• Analyzed operational and manufacturing datasets using SQL, Python, and Power BI to generate insights supporting business decision-making.

• Performed exploratory data analysis (EDA) to identify production inefficiencies, supplier performance trends, and operational bottlenecks.

• Built Power BI dashboards tracking KPIs such as throughput, yield percentage, inventory turnover, and delivery performance.

• Developed DAX measures for MTD, QTD, and YTD reporting metrics to track operational trends.

• Automated data validation processes using Python (Pandas) to improve reporting reliability.

• Used Advanced Excel (Power Query, PivotTables, XLOOKUP) for data validation and variance analysis during UAT testing.

• Utilized Python with libraries such as Pandas and NumPy for data manipulation, cleansing, and exploratory data analysis.

• Experienced working with cloud-based data platforms such as Snowflake and integrating data from multiple sources.

• Built ETL pipelines and data transformation processes using Alteryx or Informatica.

• Designed dimensional data models with fact and dimension tables to support enterprise reporting.

• Write complex SQL queries including joins, aggregations, and window functions to analyze large datasets.

• Supported ETL pipelines using Azure Data Factory and Databricks for data ingestion and transformation.

Environment:

SQL Server, Azure Data Factory, Azure Data Lake, Databricks, Python, Power BI, Tableau, Excel

Elevance Health — Bangalore, India Aug 2022 – Nov 2023

Data Analyst

• Analyzed healthcare datasets containing millions of patient records, supporting clinical and operational analytics.

• Built Power BI dashboards to track patient volumes, hospital utilization, and provider performance metrics.

• Used advanced SQL queries (CTEs, window functions, CASE statements) to analyze patient encounters and healthcare KPIs.

• Performed data profiling and reconciliation across EHR systems, claims datasets, and reporting layers.

• Built ETL workflows using SSIS and Azure Data Factory to integrate data from healthcare systems and operational databases.

• Automated recurring data quality checks using Python (Pandas and NumPy).

• Conducted exploratory data analysis to identify trends and anomalies in healthcare utilization.

• Developed Tableau dashboards for interactive data visualization and reporting.

• Used Power Query and DAX to transform data and build semantic models.

• Collaborated with business teams to validate KPI definitions and ensure reporting accuracy.

Environment:

SQL Server, Oracle, Azure Data Factory, Databricks, Python, Power BI, Tableau, Excel

Accenture — Bangalore, India Jul 2020 – Jul 2022

Data Analyst - Intern

• Collected and analyzed enterprise datasets using SQL and Excel to support reporting and analytics initiatives.

• Developed SQL queries, views, and stored procedures to extract and transform data for reporting.

• Built ETL pipelines using SSIS to load data from multiple source systems into enterprise reporting databases.

• Performed data cleansing, validation, and reconciliation to ensure data accuracy and completeness.

• Designed Tableau dashboards to visualize business performance metrics and operational KPIs.

• Developed analytical reports using Excel Power Pivot, PivotTables, and advanced formulas.

• Assisted in designing data warehouse models with fact and dimension tables.

• Used Python for data preprocessing and transformation tasks across multiple datasets.

• Worked with global teams following Agile and SDLC methodologies to deliver analytics solutions.

Environment:

SQL Server, SSIS, Tableau, Excel, Python

EDUCATION

Master of Science – Information Technology and Management

Concordia University St. Paul, Minnesota, USA — 2025

Bachelor of Technology – Computer Science and Engineering

JNTUH College of Engineering Manthani — 2022

Contact this candidate