Karan Deshmukh Email & Phone Number

Boston, Massachusetts, United States

•⁠ ⁠Designed and implemented PowerBI reports and dashboards providing real-time insights leveraging PowerQuery to perform data transformations and optimized DAX Queries to create complex measures and calculated columns•⁠ ⁠Performed incremental data loading to PowerBI Service using incremental refresh policy in PBI •⁠ ⁠Implemented dynamic filters that lets user select Top ‘N’ making the visuals dynamically update values based on user selection •⁠ ⁠Optimized reports in PBI and published to PBI Service enabling end users to access and interact with reports while ensuring data governance using Dynamic Role Level Security (RLS) •⁠ ⁠Performed complete data migration from on-premises SQL server to cloud via Azure Data Factory•⁠ ⁠Designed and implemented a data de-duplication pipeline in Azure Data Factory that automatically loads data from source to destination simultaneously eliminating duplicate rows in the data•⁠ ⁠Optimized SQL queries and stored procedures using indexing, improving data retrieval by 15% •⁠ ⁠Created Stored Procedures to perform complex business calculations saving manual labor by 27%•⁠ ⁠Created different database objects such as views, triggers, stored procedures, functions, indexes and triggers in SQL Server performing operations against AdventureWorks Database

United States

• Conducted analysis of 100+ stakeholder feedback responses using Python and NLP techniques to extract, clean, and preprocess text data from Excel files.• Analyzed term frequency and visualized most frequent words for each response category to facilitate trend identification, employing RAKE (Rapid Automatic Keyword Extraction) to identify key phrases and recurring themes, reducing manual tagging effort and saving 4 hours.• Created a dynamic Tableau dashboard for interactive toggling between metrics based on stakeholder groups, enabling comprehensive overview of each category of feedback response.• Communicated analysis results to stakeholders, highlighting key organizational strengths and weaknesses, leading to a 22% increase in engagement

Bangalore Urban, Karnataka, India

● Effectively managed operations for an international client's Learning Management System application by delivering data-driven resolutions of 20,000+ tickets across 3 regions.● Created a dashboard displaying overhead heap space, drive spaces, CPU and memory utilization of application servers that single handedly reduced application accessibility issues by 37%, facilitating seamless functionality.● Automated a weekly report extraction that involved manual data entry, reducing generation time from 4 hours to 5 seconds, resulting in a time reduction of 99.97% and 208 hours saved annually per employee resource.● Manipulated 2TB+ datasets containing user data identifying root cause to no access errors. Achieved a 27% decrease in redundancy, further preventing the integration of 9000 duplicate user accounts into company database● Owned a root cause analysis on print server logs and optimized the SQL queries leading to a reduction in the backlog of active print jobs by 26%.● Identified the top 3 categories of tickets raised using Excel and Python, followed up with vendors, visualized findings using Tableau, and presented key insights to application owners which led to a 14% decrease in overall tickets inflow.● Collaborated with cross functional teams and created documentation for 4 Knowledge Base Articles. Implemented training programs, took leadership of training and knowledge transfer of new joiners which led to a reduction in onboarding time by 50%.

Bangalore Urban, Karnataka, India

• Developed basic knowledge of Game engine - Unity Editor and Unity Scene Management • Understanding of Basic Physics System along with creating DB system using Unity Json utilities• Hands-on experience of OOP concepts for scripting as well as Basics of Unity Camera and created a simple UI for a basic game• Created an AR application which Replaces a pre-configured real object with an alternate augmented image/object while viewing through phone camera in real time. Converted to an APK file and deployed it in Android OS.

Master Of Science - Ms, Data Analytics

Bachelor Of Engineering - Be, Electronics And Communications Engineering