KRANTHI KUMAR KANNESANI
Philadelphia
Summary
Experienced Business Technology and Delivery Analyst with 8 years in the IT industry, specializing in Business Intelligence (BI) solutions and data analytics. Extensive hands-on experience with Power BI Desktop, Power BI Service, Power Apps, SQL, Excel, SharePoint, and Azure DevOps to design and deliver scalable, data-driven solutions. Proven track record of creating actionable insights by transforming complex datasets, enhancing decision-making efficiency. Adept at building ETL pipelines, implementing advanced statistical techniques, and creating interactive dashboards that address business challenges. Skilled in streamlining workflows and supporting strategic objectives through automation and advanced data governance practices.
Overview
8
8
years of professional experience
Work History
Business & Technology Delivery Analyst
Accenture Solutions PVT Limited
Bengaluru
01.2021 - 09.2023
- Imported large sets of data from SQL Server Database, Azure SQL Database to generate Power BI reports
- Created Power Apps integration within the Power BI Dashboards to maintain clients' live comments on the business review
- Applied statistical and analytical techniques to extract meaningful insights and trends from the data
- Authorized, managed, and delivered dynamic reporting solutions through Various DAX functions
- Involved in troubleshooting topics for Data level, Report level & Service level, to explore and visualize data for better understanding and identify differences in data distribution that could impact model performance when deploying it in real-world scenarios
- Build a Leadership dashboard in Power BI which includes SLA, and KPI metrics for Service Delivery Leads by using Complex Relationships and DAX functions
- Automated workflows and reporting processes using VBA and RPA tools to reduce manual effort
Data Analyst
Magical Spiders Info Solutions
Bengaluru
06.2015 - 01.2021
- Design and developed various reports using SSRS based on business requirements
- Write complex SQL queries to retrieve and manipulate data for reporting purposes and optimize queries for performance and efficiency
- Optimized SQL queries to extract specific subsets of data, aggregate information, and join multiple tables to create a comprehensive dataset for analysis
- Created data model by using multiple data sources like files, databases, and OData sources
- Analyzed business processes, systems & data to identify areas where technology can be leveraged to improve efficiency, productivity, and profitability
- Interpreted data, analyzed results using statistical techniques, and provided ongoing reports
- Created advanced visualization methods in Power BI to provide valuable business insights to clients
- Monitored the audit logs through O365 audit logs for Power BI activities
- Managed the multiple on-prem_data gateways and clusters
Education
Master of Science - Business Analytics
Drexel University
03.2025
Bachelor of Mechanical Engineering -
JNTU Kakinada
05.2013
Google Data Analytics for Professional Certificate -
Coursera
Skills
- Power BI
- Tableau
- PowerApps
- MS Excel
- Share Point
- Azure Data Factory
- Azure Data Lake Storage
- Azure Data Bricks
- SQL Server
- Azure SQL
- Python
- R
- Data Analysis
- Statistical Modeling
Projects
Microsoft Global Service Center, MICROSOFT, 02/01/21, 09/30/23, In this Project, the Microsoft GSC Team organized the 1Q Tracker developed by the Accenture team. As a Bus and Technology delivery analyst I worked closely with business stakeholders to identify business requirements. To Provide meaningful business value through easy-to-comprehend data visualizations, deploy and configure solutions for consumption. It is used to get productivity and calculate the work times of tasks and resource shift details. Data infrastructure and Control (DI&C), LLOYDS Banking Group, 07/01/15, 01/31/21, In this project, data was extracted from SQL Server Databases and generated the Daily, Monthly, Weekly, and Quarterly reports to the end users gathering the Collection and Recoveries data from the various sources and loading them into Particular databases as an ETL process. Expertise in GDW (Group data warehouse) and extracting the data as per the client's requirement.
Timeline
Business & Technology Delivery Analyst
Accenture Solutions PVT Limited
01.2021 - 09.2023
Data Analyst
Magical Spiders Info Solutions
06.2015 - 01.2021
Master of Science - Business Analytics
Drexel University
Bachelor of Mechanical Engineering -
JNTU Kakinada
Google Data Analytics for Professional Certificate -
Coursera
Similar Profiles
SANIYA BHIWANISANIYA BHIWANI
Senior Software Development Analyst at Accenture Solutions Pvt LimitedSenior Software Development Analyst at Accenture Solutions Pvt Limited
Padire PravalikaPadire Pravalika
New Associate at Accenture Solutions Pvt LimitedNew Associate at Accenture Solutions Pvt Limited
HARI KHARI K
Genaral Accounting Ops Associate at Accenture Solutions Pvt LimitedGenaral Accounting Ops Associate at Accenture Solutions Pvt Limited