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

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.
• 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.
• 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.

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