Sai Swaroop Medisetty
Visakhapatnam
Summary
My Profile I've been an Azure data engineer and Power BI Developer for three years, utilizing Power BI, Azure Data Factory, and SQL while working with a major clothing brand client.In order to advance my career and help the firm, I would like to work as a data analyst for a quickly growing company.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Azure Data Engineer and Power BI Developer
Tata Consultancy Service's TCS
Banglore
07.2021 - Current
- Created a report that includes every purchase request that has been generated over the last three days. Using this report as a basis, I created a dialy report that provides the customer with an order count and other generated metrics.
- Created a report that provides end-to-end order flow information, enabling the client to comprehend and analyze which flow is causing the problem with order creation, what the problem is with the order, and why it failed.
- The third report gathers information from Azure Application Insights and keeps track of whether the purchase order is being approved by all apis.
- Additionally, all three of these reports are available on the Power Bi service, where I have set up a scheduled refresh that occurs every six hours for each of these reports.
- I periodically restore the test environments' Azure SQL servers from the production backup.
- I recover test environment's Azure SQL databases from production.
- Additionally, I maintain an Azure SQL Database backup in containers, which is used by other teams that rely on us to restore their own databases.
- Optimized existing queries to improve query performance by creating indexes on tables.
- Performed data cleansing and achieved a 20% improvement in system performance.
- Created stored procedures for automating periodic tasks in SQL Server.
- I have developed pipelines that copy data from on-premises SQL databases to Azure SQL databases using the copy activity in Azure Data Factory.
- In addition, for these pipelines, I've established a schedule-based trigger that runs every 4 hours to ensure that no data is missed
- I created a logic app that is linked to the adf pipeline via the web activity and sends us an email when the pipeline fails.
- Contributed to sprint planning, stand-ups, and reviews as part of agile development procedures to guarantee timely delivery of data projects.
Education
Computer Science
Anil Neerukonda Institute of Technology and Sciences
05.2021
Skills
- BI Tools - Power BI Desktop, Power BI Service's
- Databases-Microsoft SQL Server
- Cloud-Azure
- Python & C#
- Query Languages - DAX & SQL
- Reporting Tool - Power View
- MS Office - Word, Excel, and PowerPoint
- ETL Tools - Azure Data Factory basics, Power Query
- Cross-Functional
- Data Transformation
- Data Modeling
- Data Processing Systems
Certification
Microsoft Certified Power BI Data Analyst Associate(PL-300)
Microsoft Certified: Azure Developer Associate(AZ-204)
Microsoft Certified: Azure Data Fundamentals(DP_900)
Microsoft Certified: Azure Fundamentals(AZ-900)
Timeline
Azure Data Engineer and Power BI Developer
Tata Consultancy Service's TCS
07.2021 - Current
Computer Science
Anil Neerukonda Institute of Technology and Sciences
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Jocil D'souzaJocil D'souza
Assistant Manager at TCS - TATA Consultancy ServiceAssistant Manager at TCS - TATA Consultancy Service
Prabhakar SinghPrabhakar Singh
Sourcing Specialist at Kornferry Supporting GoogleSourcing Specialist at Kornferry Supporting Google
SHADIQ ALI SHAIKSHADIQ ALI SHAIK
Assistant Manager at MUSIC BROADCAST PRIVATE LIMITEDAssistant Manager at MUSIC BROADCAST PRIVATE LIMITED