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
2022.09 - 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
2020.11 - 2022.09
- 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
2018.10 - 2020.11
- 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
2016.10 - 2018.04
- 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
2014.05 - 2016.08
- 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
Education
Business Course - Business Administration And Management
SP Jain Institute of Management, Business Analysis
Mumbai 2014.05 - 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 2008.01 - 2012.05
Skills
Data Analysis and Strategy Advice
Timeline
GenAI, LangChain and LLM
2023-08
Prompt Engineer
2022-11
Team Lead - Analytics, Sales Performance & MIS
DAMAC
2022.09 - Current
Agile SAFE 5.0
2022-06
Analytics Associate Lead
TIAA
2020.11 - 2022.09
People Analytics
2019-09
Analytics Analyst
Capita
2018.10 - 2020.11
Data Science using Python and R (Udemy)
2018-01
Advanced Analytics using Excel
2017-08
Research Associate/Consulting
MarketsandMarkets, ICT-Analytics
2016.10 - 2018.04
Business Course - Business Administration And Management
SP Jain Institute of Management, Business Analysis
2014.05 - 2015.05
Business Analyst
Shembekar Foundry Pvt. Ltd, Software
2014.05 - 2016.08
Bachelor of Engineering Technology - Information Technology
Smt. Kashibai Navale College of Engineering
2008.01 - 2012.05
MBA ( 2 Masters ) -
Sinhgad Business School
2012.01 - 2014.05
Similar Profiles
Karan NairKaran Nair
Client Relationship Manager at DAMACClient Relationship Manager at DAMAC
Barah KarBarah Kar
Cloud Data Engineer at DamacCloud Data Engineer at Damac
Mohammed EssaMohammed Essa
Real Estate Agent at DAMACReal Estate Agent at DAMAC