Overview
Summary
Work History
Certification
Education
Skills
Timeline
Generic
Dhananjay Shembekar

Dhananjay Shembekar

Analytics & Business Intelligence Leader
Dubai

Overview

10
10
years of professional experience
6
6
Certificates

Summary

Dynamic leader with 10+ years as a Business and Data Analyst, adept in diverse industries including Real Estate, HR, IT, and Retail. Proven adaptability in coordinating with stakeholders and implementing feedback loops. Experienced in team management, with 3 years of remote work experience. Committed to leveraging analytical expertise to drive innovation and excellence in lead or managerial roles.

Tools & Technologies : Expertise in Python, Excel, PowerBI, Tableau, SQL, and Advanced Excel for data analytics and visualization. Proficient in utilizing Adobe Analytics, Qlik, Azure Analysis Services, Salesforce Objects, and Streamlit for operational efficiency and reporting automation. Experience with LangChain, OpenAI API, and prompt engineering for innovative chatbot solutions. Skilled in competitive benchmarking and market research with SEMRush, Medallia, and Factiva. Knowledgeable in HR and management systems including Workday, Phenom, Prism, and Oracle Fusion (Compensation). Familiar with Supervised Machine Learning techniques for predictive analytics. Utilized Bloomberg and Hoovers for comprehensive market analysis.

Work History

Team Lead - Analytics, Sales Performance & MIS

DAMAC
09.2022 - Current
  • Data Analytics & Visualization Leadership : Led the adoption of PowerBI, Qlik, and Azure to automate analytics and reporting processes. Developed critical KPIs for pricing, sales, and commissions, enhancing decision-making and operational efficiency.
  • Competitive Benchmarking and Market Research : Conducted comprehensive market research and competitive analysis to inform strategic pricing, promotions, and payment plans, ensuring the company's agility and competitiveness.
  • Product Development & Process Optimization :
  • Queue Management System : Implemented a Python-based solution to streamline customer service operations.
  • Pricing Engine Development : Created an innovative tool using Streamlit and Python to expedite pricing decisions and simplify the auditing process, boosting productivity and market responsiveness.
  • Chatbot for Inventory Management: Developed a chatbot utilizing Large Language Models (LLM) with Python, Streamlit, and the OpenAI API for efficient inventory querying. This chatbot revolutionizes inventory management by providing results for short queries in approximately 5 seconds, significantly reducing the need to manually open reports and configure pivot tables. This innovation exemplifies cutting-edge prompt engineering to enhance operational efficiency and decision-making processes.
  • Achievements:
    Salesforce Migration Excellence: Successfully managed the migration of inventory data to Salesforce, achieving zero data loss and maintaining data integrity for enhanced inventory management.
    Operational Efficiency and Cost Savings:
  • Introduced automated analytics dashboards, significantly saving time in reporting and analysis. This automation reduced manual data processing time by over 30%, allowing teams to focus on strategic initiatives.
  • Achieved substantial cost savings of 65,000 AED with the Queue Management product, enhancing customer service efficiency and satisfaction.
  • The Pricing Engine resulted in a 40% faster time-to-market for new products and streamlined the pricing and auditing process, further contributing to operational cost savings.

Analytics Associate Lead

TIAA
11.2020 - 09.2022
  • Project Management: Spearheaded critical initiatives in Employee Surveys, Upward Feedback, Market Analysis, Ratings, Attrition, Diversity, and Year-End Reporting, driving significant improvements in employee satisfaction and strategic decision-making.
  • HR & People Analytics: Played a pivotal role in the HR department, enhancing reporting capabilities and automating processes using Power BI, Python, and Workday, which led to a 30% reduction in time spent on manual data processing.
  • Achievements:
  • Tool Development: Developed and implemented innovative tools for Headcount Walk, Candidate Selection, Pay & Rewards Analysis, and Workforce Planning, which collectively:
  • Enhanced efficiency of workforce planning by 25%, by automating and streamlining data analysis process, enabling more accurate and timely decisions.
  • Reduced time to fill open positions by 15% through Candidate Selection Tool, which utilized predictive analytics to match candidate profiles with job requirements, improving quality of hires.
  • Achieved 20% reduction in labor costs related to pay and rewards analysis by automating compensation benchmarking, ensuring competitive and equitable pay practices.
  • Facilitated 10% improvement in headcount accuracy and forecasting precision, directly contributing to 5% cost saving in annual workforce budgeting.
  • Star Performer: Recognized twice for exceptional dedication and leadership, directly contributing to a 10% improvement in team productivity and fostering a culture of innovation and continuous improvement.

Analytics Analyst

Capita
10.2018 - 11.2020
  • Analytics Tool Development : Pioneered the in-house creation of cutting-edge analytics tools across Business Planning, HR Analytics, and Procurement. Demonstrated exceptional innovation and problem-solving skills by:
  • Enhancing strategic decision-making in Business Planning, resulting in a 10% increase in operational efficiency and supporting a 5% year-over-year revenue growth.
  • Automating key HR Analytics processes, which improved talent management strategies and led to a 20% reduction in turnover rates.
  • Streamlining Procurement analysis, leading to a 15% cost saving in supply chain operations through better vendor selection and contract negotiation strategies.
  • Data Management & Reporting : Excelled in the management, cleaning, and categorization of data, utilizing Tableau and PowerBI to provide actionable insights for Retail, Logistics, and Telecom sectors.
  • Achievements :
    Developing comprehensive dashboards that reduced reporting times by 30%, enabling faster decision-making.
  • Implementing advanced data categorization techniques that improved data accuracy by 25%, enhancing overall business intelligence.
  • Sentiment & Emotion Analysis Tool : Conceptualized and developed an innovative in-house tool using Python (NLTK, IBM NLU, LDA, etc.) for sentiment and emotion analysis in Retail, Telecom, and Social Media sectors.
  • Saved $40K annually by replacing third-party analytics services with an in-house solution.
  • Improved customer satisfaction scores by 15% through deeper insights into customer sentiments and trends, directly influencing product development and marketing strategies.
  • Enabled real-time social media monitoring, which increased brand awareness and engagement by 20%.

Research Associate/Consulting

MarketsandMarkets, ICT-Analytics
10.2016 - 04.2018
  • Research Excellence:
    Excelled in conducting exhaustive primary and secondary research, producing over 25 in-depth reports on cutting-edge developments in Analytics, Software & Services, and IoT. This work highlighted a commitment to thorough analysis and a keen eye for detail, contributing to a deeper understanding of technology trends.
  • Strategic Consulting:
    Partnered with more than 7 clients to develop bespoke market entry strategies, conduct competitive landscape analyses, and define product positioning. Showcased flexibility and strategic insight, delivering tailored solutions that enabled clients to navigate complex markets effectively.
  • Achievements:
    Data Sanity Solution for Microsoft: Engineered a critical solution to a data integrity issue for Microsoft, directly leading to a 13.33% average increase in sales. This not only illustrates a capacity to tackle and solve complex data challenges but also reflects a significant contribution to enhancing client revenue and operational efficiency.

Business Analyst

Shembekar Foundry Pvt. Ltd, Software
05.2014 - 08.2016
  • Conducted in-depth data analysis to identify inefficiencies and areas for process improvement, leading to a 15% reduction in operational costs.
  • Utilized advanced excel to develop and maintain dashboards, providing real-time insights that supported strategic decision-making.
  • Managed cross-functional project teams, ensuring timely delivery of initiatives that enhanced productivity and reduced waste, saving the company over INR 400,000 annually.
  • Automated manual reporting processes, decreasing report generation time by 50% and freeing up resources for value-added activities.
  • Collaborated with stakeholders to define business requirements and translate them into actionable analytics projects, directly contributing to a 20% improvement in customer satisfaction scores.
  • Led the implementation of a cost-saving initiative by optimizing supply chain logistics, resulting in a 10% decrease in shipping and handling expenses.
  • Achievements - “Difference Maker” award as a Business Analyst in June 2015

Certification

Advanced Analytics using Excel

08-2017

Data Science using Python and R (Udemy)

01-2018

People Analytics

09-2019

Prompt Engineer

11-2022

GenAI, LangChain and LLM

08-2023

Agile SAFE 5.0

06-2022

Education

Business Course - Business Administration And Management

SP Jain Institute of Management, Business Analysis
Mumbai
05.2014 - 2015.05

MBA ( 2 Masters ) -

Sinhgad Business School
Pune
2012.01 - 2014.05

Bachelor of Engineering Technology - Information Technology

Smt. Kashibai Navale College of Engineering
Pune
01.2008 - 2012.05

Skills

    Data Analysis and Strategy Advice

undefined

Timeline

GenAI, LangChain and LLM

08-2023

Prompt Engineer

11-2022

Team Lead - Analytics, Sales Performance & MIS

DAMAC
09.2022 - Current

Agile SAFE 5.0

06-2022

Analytics Associate Lead

TIAA
11.2020 - 09.2022

People Analytics

09-2019

Analytics Analyst

Capita
10.2018 - 11.2020

Data Science using Python and R (Udemy)

01-2018

Advanced Analytics using Excel

08-2017

Research Associate/Consulting

MarketsandMarkets, ICT-Analytics
10.2016 - 04.2018

Business Course - Business Administration And Management

SP Jain Institute of Management, Business Analysis
05.2014 - 2015.05

Business Analyst

Shembekar Foundry Pvt. Ltd, Software
05.2014 - 08.2016

Bachelor of Engineering Technology - Information Technology

Smt. Kashibai Navale College of Engineering
01.2008 - 2012.05

MBA ( 2 Masters ) -

Sinhgad Business School
2012.01 - 2014.05

Similar Profiles

CREATE PROFILE
Dhananjay ShembekarAnalytics & Business Intelligence Leader