Shreya Konkathi

AI Data Analyst Role

Hyderabad 3+ yrs exp 91 · Outstanding

About

Experienced in utilizing Microsoft Copilot with Excel to automate data analysis workflows, perform data cleaning and transformation, and improve reporting efficiency using Data Validation, Conditional Formatting, Pivot Tables, and Copilot-powered automation. Familiar with Excel functions such as Vlookup, Xlookup, Index & Match, Countifs, and Sumifs. Proficient in SQL and PySpark, with experience writing and complex queries for large datasets to support database management, data transformation, and data-driven decision-making. Skilled in Subqueries, CASE WHEN statements, and Joins, Window Functions and CTES while leveraging AI-assisted development tools to improve query optimization, productivity, and code quality. Experienced in Power BI for performing data transformation using Power Query, developing data models, writing DAX measures, and designing interactive dashboards to deliver actionable business insights. Hands-on experience with Python, Pandas, NumPy, Matplotlib, and Scikit-Learn for data cleaning, transformation, feature engineering, exploratory data analysis (EDA), and visualization. Skilled in preparing high-quality datasets and implementing Machine Learning algorithms, including Linear Regression and Logistic Regression, to support predictive analytics and data-driven decision-making.

Skills & Expertise (41)

Microsoft Copilot Intermediate

8.1/10

Years Exp

Problem Solving Advanced

8.0/10

Years Exp

Analytical Thinking Advanced

8.0/10

Years Exp

Communication Advanced

8.0/10

Years Exp

Excel Advanced

7.6/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

SQL Intermediate

7.4/10

Years Exp

Python Intermediate

6.8/10

Years Exp

Machine Learning Intermediate

6.0/10

Years Exp

GitHub Intermediate

6.0/10

Years Exp

scikit-learn Team Collaboration Linear Regression Logistic Regression Prompt Engineering Logical thinking Requirements Gathering Trouble Shooting Time management Process Improvement Business Analysis Root Cause Analysis Stakeholder Management PySpark Data Validation Conditional Formatting Pivot Tables VLOOKUP XLOOKUP INDEX & MATCH Countifs SUMIFS Matplotlib Subqueries Joins Window Functions CTEs Power Query DAX measures Pandas NumPy

Work Experience

Data Engineer I

Cencora

Sep 2024 - Present

Analyzed legal reporting requirements and extracted data from SAP Business Objects, SAP ECC, and SQL Server to develop accurate, business-critical Legal reports supporting Legal stakeholders. Leveraged AI-powered Microsoft Copilot to streamline data transformation, cleansing, and standardization, enabling reliable and standardized legal reporting with 100% accuracy. Served as the backup Business System Analyst, gathering business requirements, preparing functional specifications, collaborating with Legal stakeholders, and coordinating with development and data teams to translate business requirements into technical reporting solutions, ensuring accurate and timely legal report delivery. Optimized SAP BusinessObjects (BO) data transformations by centralizing reusable transformation logic, reducing report-level development effort, improving consistency, and accelerating report delivery. Developed an interactive Power BI dashboard that enabled real-time tracking of report ownership, daily reporting activities, and individual performance by visualizing the number of reports processed by each team member.

Programmer Analyst

Cognizant

Sep 2022 - Nov 2023

Translated client requirements into solutions and provided post-implementation technical support to maintain optimal performance. Collaborated with cross-functional teams for seamless project execution while monitoring software applications, implementing performance improvements and creating comprehensive documentation for code and system designs. Managed service tickets using SNOW and fixed bot issues promptly and provided workarounds to ensure runtime SLA compliance. Engaged with clients for feedback, needs assessment, progress updates and responded promptly to customer communications, ensuring proactive interactions.