Home

Durgama Kondaveeti - Data Analyst

[email protected]

Location: Austin, Texas, USA

Relocation: yes

Visa: F1-OPT

Durgama k | Data Analyst | [email protected] | +1 737 291 1069 _____________________________________________________________________________________________________ Experienced Data Analyst/Data Engineer in designing and implementing Data Migration ETL pipelines. Proficient in SQL, Python, AWS, Azure, Excel, SAP, Tableau, Power BI, and I have experience in Data Migration, enhancing data accuracy and operational efficiency. Educational Details: Bachelor of Technology from KL University, India in the stream of Computer Science and Engineering. Master of Science from Lindsey Wilson College, USA in the stream of Technology Management. Professional Experience: UPS Data Analyst Nov 2023 May 2024 Designed and implemented data migration pipelines with Azure Data Factory (ADF) to transfer 90% SQL DB data, CSV, JSON, and Excel files. Created and managed 10+ stored procedures with parameters, resulting in a significant improvement in overall query performance of 30%. In SQL Server Database, Tuned SQL queries to reduce execution time by 50% for datasets exceeding 10 million records. In SQL Server Database and Snowflake, I have created 10+ SQL Server objects using complex joins and conditions for database activities. Developed and optimized Alteryx workflows for financial forecasting, improving data retrieval and transformation speed by 40%. Enhanced data accuracy by 25% through complex joins and stored procedures in Alteryx, ensuring precise integration of financial datasets. Increased data processing efficiency by 35% by leveraging Alteryx's complex join capabilities to merge and analyze financial data. Automated financial data analysis workflows in Alteryx through the implementation of self-selects and parameterized workflows. Executed data pivots on large financial datasets, improving decision-making speed by 20% through key trend identification. Created over 5+ financial Power BI reports and dashboards, providing actionable insights for management and stakeholders. Developed over 10+ DAX functions in Power BI reports and dashboards, which improves report accuracy by 30%. Analyzed financial datasets using microsoft advanced Excel functions, led to a 25% improvement in data-driven decision-making processes. Communicated data insights via Power BI reports to leadership, enabling a 20% boost in data-driven decision-making Presented Power BI dashboards to stakeholders, providing data-driven insights that influenced strategic decision-making. Analyzed financial datasets using microsoft excel functions, led to a 25% improvement in data-driven decision-making processes. Developed and automated microsoft excel dashboards that reduced reporting time by 40%, enabling faster business insights and actions. Performed data cleaning for financial datasets, resulting in a 25% increase in data accuracy and reliability across multiple projects. Improved data quality by implementing Advanced Excel data validation rules, leading to a 25% decrease in data entry errors. Optimized SQL queries to audit UPS' financial data, identifying discrepancies that reduced revenue leakage by 15%. Created automated SQL scripts for auditing compliance, enhancing accuracy in financial data reports by 20% across multiple business units. Streamlined financial data validation processes using complex SQL joins and business conditions, improving audit efficiency by 30%. Integrated data from SQL Server, Excel files, and Azure Synapse into Power BI reports and dashboards for supply chain and logistics analysis. Utilized Power Query to clean, transform, and merge data, cutting data preparation time by 40% and ensuring report consistency. Built 5+ Power BI dashboards for real-time supply chain metrics, reducing stockouts by 30% and enhancing inventory control. Implemented advanced DAX functions for calculated measures, boosting financial and operational analysis accuracy by 25%. Skills: Azure Cloud, AWS Cloud, PL/SQL, Python), Troubleshooting, T-SQL (DDL, DML, DCL, SQL Queries, Oracle, Advanced Excel Analysis, Visual Basic, Alteryx, Designing stored procedures, functions, tables, views, triggers, indexes, constraints), Power BI, Tableau, Troubleshooting Data Pipelines, Scheduling Data Pipelines, Production Support, Microsoft Office Tools, Data Visualization Reports & Dashboards, Structured Data, Semi Structured Data(Avro Files, CSV Files, JSON Files, Parquet Files, Zip Files, Txt Files), Jira, Confluence, ServiceNow, Agile Methodologies. Keywords: business intelligence database procedural language