Shanmuka Rao Karri
Data Engineer
Hyderabad,Telangana
Summary
Software professional with over 5.2 years of experience in data analytics and business intelligence, specialized in Power BI, SQL Server, and Azure Cloud. Expert in managing priorities to meet deadlines and realize high-quality outcomes. Committed to optimize, resolve complex problems and deliver innovative improvement strategies.
Overview
5
5
years of professional experience
3
3
Certifications
Work History
Software Developer
Wipro
02.2022 - Current
- Developed Scope scripts and Power BI reports for Microsoft Teams Application as part of Calling/Meetings/Devices (CMD) and Virtual Events data team.
- Created Cosmos Script for Monthly active users (MAU) for MS Teams phone premium subscription data which provides feature wise usage metrics.
- Created and updated C# methods of Cosmos for Reliability and Performance scripts of Teams CMD. Added new scenarios and customized scenarios to existing reports.
- Automated data entry processes and enhanced data management practices using Cosmos scripting and Power BI, ensuring accurate and efficient data handling.
- Created new pipelines for scripts and updated parameters according to script changes.
- Written KQL queries for data analysis, validation and accuracy. Merged latest code changes to Azure DevOps Repos using Visual studio.
- Developed new reports and dashboards using KQL and Power BI, providing insights into failure rates, metrics, and performance indicators.
- Implemented DAX for Calculated columns and measure for KPIs and logical indicators in reliability and performance
- Updated dashboards with bookmarks and new filters for better UI and ease of use
- Created data models in Power BI for managing interactions between tables also updated scheduled refreshes in Power BI service
- Managed and optimized data pipelines and C# scripts, improving performance, data load times, and ensuring seamless data flow and processing.
Associate Consultant
Capgemini
05.2019 - 01.2022
- Developed Power BI reports using SQL DB and SSAS Cubes to meet supply chain business requirements and standards.
- Collaborated with users to identify solutions and implement enhancements for better report performance.
- Implemented SQL stored procedures for incremental data loads and created optimized views to improve dataset refresh rates.
- Designed Power BI reports with KPIs, measures, and calculated columns using DAX queries; utilized bookmarks and buttons for effective filter and page management.
- Published reports to Power BI Workspace, set up gateways, and created dashboards; managed dataset refresh schedules and workspace access.
- Monitored daily pipeline loads in Azure Data Factory (ADF) and managed data load activities in Databricks.
- Developed new Power BI dashboards using Azure Analysis Services (AAS) cubes and managed user access via Azure Active Directory.
- Onboarded and trained new team members on project technologies, providing ongoing guidance and support.
- Demonstrated proficiency in Azure ADF, Azure Databricks (Scala), and ServiceNow; handled application handovers from vendors to ensure requirement compliance.
- Created Azure alerts based on resource metrics and activities; implemented KQL queries for log analysis and enforced Row-Level Security (RLS) on Power BI reports.
Education
Bachelor of Technology - Electronics And Communications Engineering
Gokaraju Rangaraju Institute of Engineering & Technology
Hyderabad 08.2015 - 2019.05
Skills
Databases: SQL DB, Cosmos Scope
Programming: SQL & Scope Scripting, C#, Spark SQL, KQL
BI Tools: Power BI Desktop & Service
Azure Cloud: ETL, Data Aggregation and Pipelines
Certification
Microsoft Certified: AZ-900 (Azure fundamentals)
Timeline
Software Developer
Wipro
02.2022 - Current
Microsoft Certified: DA-100 (Data Analyst Associate)
06-2021
Microsoft Certified: AZ-900 (Azure fundamentals)
08-2020
Coursera Certified: Agile Software Development
08-2020
Associate Consultant
Capgemini
05.2019 - 01.2022
Bachelor of Technology - Electronics And Communications Engineering
Gokaraju Rangaraju Institute of Engineering & Technology
08.2015 - 2019.05
Similar Profiles
Ankan BeraAnkan Bera
Application Architect at WiproApplication Architect at Wipro
Yogesh YadavYogesh Yadav
Senior Analyst at WiproSenior Analyst at Wipro
Vaishnavi GundojuVaishnavi Gundoju
Senior Associate at WiproSenior Associate at Wipro
Hari Kumar ModalaHari Kumar Modala
Lead Administrator- Asset and Configuration Management at WiproLead Administrator- Asset and Configuration Management at Wipro
Katamneni SrinivasaraoKatamneni Srinivasarao
Head Operations Manager at SUBWAY®RestaurantsHead Operations Manager at SUBWAY®Restaurants