Omkar Joshi
Data Analyst
Mumbai
Summary
Strategic and results-oriented Senior Executive with 6 years of experience in Power BI development and ETL operations. Adept at leading teams to execute large-scale data projects, optimizing data solutions, and improving business outcomes. Highly skilled at adapting to new technologies and organizational needs to achieve sustained success.
Overview
6
6
years of professional experience
8
8
years of post-secondary education
9
9
Certifications
4
4
Languages
Work History
Senior Executive
L&T Technology Services
07.2023 - Current
- Managed a team responsible for maintaining data, dashboards, and reporting across HR, Operations, Business, and Resource Management groups to ensure timely and accurate insights.
- Designed and implemented dynamic Power BI visualizations using both flat and hierarchical datasets, enabling drill-down functionality for detailed analysis at the aggregate, team, and individual levels.
- Applied Row Level Security (RLS) to dashboards to control data access and ensure appropriate visibility based on user roles and security requirements.
- Created and optimized SQL queries to enhance the performance of Power BI dashboards, resulting in faster data load times and more responsive reporting.
- Maintained and executed automated data pipelines using Microsoft Azure Blob Storage and SFTP to ensure the Finance team received up-to-date, accurate data for reporting and analysis.
- Worked closely with internal stakeholders to translate business requirements into actionable dashboards and visualizations, providing rich, data-driven insights to support decision-making.
- Ensured the accuracy, completeness, and consistency of data by developing robust data validation processes and collaborating with cross-functional teams to resolve discrepancies.
- Delivered regular reports and custom visualizations that empowered leadership to make informed business decisions, driving operational efficiencies and improving resource allocation.
- Streamlined reporting processes by automating data refreshes and dashboard updates, reducing manual effort and ensuring real-time data availability for stakeholders.
- Promoted and implemented data governance policies, ensuring adherence to best practices for data security, privacy, and compliance within the organization.
- Conducted training sessions for team members and business stakeholders on how to effectively use Power BI and SQL queries to analyze data and extract valuable insights.
- Gathered user feedback and made iterative improvements to dashboard design and functionality, enhancing user experience and increasing adoption across business units.
Associate Enterprise Software Engineer
Wolters Kluwer
08.2022 - Current
- Designing data models to convert raw data to meaningful insights by understanding business requirements in BI context
- Designing new systems by analysing current ETL processes and made changes to the existing BI systems in order to enhance their working
- Developing executive-level dashboards and visually interactive reports for business partners to get insights on disaster recovery based on various parameters along with the KPIs leveraging Microsoft Power BI
- Using power BI Desktop to import data sources, identifying the relationships of the objects, and creating calculated column's measures using DAX
- Having experience in Power Query, Power Pivot, and Power View for creating effective reports and dashboards on Power BI desktop
- Publishing reports in Workspace, Configured Data Gateway, Scheduled Data Refresh, Shared Dashboards to users
- Creating suitable visualisations such as pies, maps, bubbles, tree maps, highlight tables and custom visuals to boost the impact of storytelling with data and informed decision making
Trainee Software Engineer
Wolters Kluwer
06.2022 - 07.2022
- Led design and implementation SharePoint solutions that met functional, capacity and security requirements
- Developed, configured and maintained custom web parts, document libraries, enterprise lists and site collections
- Relevant experience in the areas of Microsoft Power BI Desktop, Power BI service having data sources like Excel, SharePoint and SQL Server
- Created visualisations such as bars, lines, pies, maps, bubbles, tree maps, highlight tables, custom visuals
Senior Data Analyst Executive
Being Beautiful.A.I. Pvt. Ltd.
03.2019 - 10.2020
- Interpreted sales and purchase of raw materials, packing materials, finished products and turn it into non-technical information format by handling large data sets and relational databases, thus affecting business decisions
- Managed algorithm to find patterns in the company database and come up with matches for the customers and their need of the products
- Reported directly to the CEO and the head of marketing team by processing confidential data and information for Inventory maintenance and interpreting current market cycle, thus, helping company to invest money in more efficient way
Data Analyst Executive
Being Beautiful.A.I. Pvt. Ltd.
06.2017 - 02.2019
- Collaborated with internal teams to establish business needs
- Implemented a basic inventory management system, filling a communication gap between the 'team of purchase for materials' and the 'team of production for finished products'
- Created monthly forecasting recommender system for stock maintenance at warehouses all over India
Education
Master of Technology - Computer Engineering
Somaiya Vidyavihar University
Mumbai, India 11.2020 - Current
Bachelor of Engineering - Computer Engineering
University Of Mumbai
05.2013 - 06.2017
Skills
Power BI
BI desktop
SQL
Excel
SharePoint Online
Power Apps
Machine Learning
AI
CNN
DAX
Deep learning
Growth planning
Procedure implementation
Performance improvement
Operations management
Cross-functional team coordination
Technical support
Project management
Certification
Letter of Appreciation from NeuroGen Hospital, Seawood, Navi Mumbai for Development.
Publications
Real-Time Face Emotion Recognition Using Convolutional Neural Network, International Journal for Modern Trends in Science and Technology, Omkar Janardan Joshi, MS. Rohini Nair, 07/20/22, Real-Time Face Emotion Recognition Using Convolutional Neural Network. International Journal for Modern Trends in Science and Technology 2022, 8(07), pp. 248-254., https://doi.org/10.46501/IJMTST0807036
Timeline
Senior Executive
L&T Technology Services
07.2023 - Current
Associate Enterprise Software Engineer
Wolters Kluwer
08.2022 - Current
Trainee Software Engineer
Wolters Kluwer
06.2022 - 07.2022
Master of Technology - Computer Engineering
Somaiya Vidyavihar University
11.2020 - Current
Senior Data Analyst Executive
Being Beautiful.A.I. Pvt. Ltd.
03.2019 - 10.2020
Data Analyst Executive
Being Beautiful.A.I. Pvt. Ltd.
06.2017 - 02.2019
Bachelor of Engineering - Computer Engineering
University Of Mumbai
05.2013 - 06.2017