MANISH RANJAN
Bangalore
Summary
Results-driven Data Analyst with a proven track record at Azadea Group, specializing in Power BI and SQL. Successfully automated reporting processes, enhancing decision-making speed and reducing turnaround time by 40%. Adept at delivering actionable insights through data visualization and collaboration, driving customer retention and revenue growth.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Analyst
Azadea Group
Dubai
05.2023 - Current
- Developed and automated Power BI dashboards for Retail and eCommerce stakeholders, reducing manual reporting effort by 30%.
- Built ETL workflows using Power Query, SQL, and Excel to integrate data from GA4, CRM, POS, and sales systems.
- Analyzed customer acquisition, retention, conversion, and revenue trends across 16 retail brands operating in the Middle East.
- Led GA4 and GTM implementation projects, improving tracking accuracy for key customer journey events and campaign attribution.
- Automated weekly and monthly KPI reporting, reducing report turnaround time by 40% and improving decision-making speed.
- Partnered with Marketing, Finance, and Retail teams to deliver actionable insights that supported customer retention and revenue growth.
Data Analyst
LIXIL GROUP
Gurugram
06.2022 - 05.2023
- Analyzed large datasets to identify trends and insights for business decisions.
- Collaborated with cross-functional teams to support data-driven initiatives.
- Analyzed sales, inventory, and order fulfillment data using SQL and Tableau, enabling process optimization and operational visibility.
- Designed reports to effectively communicate findings to stakeholders.
- Developed executive dashboards and business reports to monitor KPIs, customer service metrics, and process performance.
- Contributed to CRM enhancement initiatives that increased cross-selling opportunities by 8%.
Associate Data Analyst
PRISM JOHNSON LTD.
Mumbai
04.2016 - 12.2018
- Developed PBI dashboards and KPI reports to track lead conversion, customer engagement, and business performance.
- Analyzed sales, customer, and marketing data to support CRM transformation and business process improvement initiatives.
- Developed visualizations to present complex data insights clearly.
- Collaborated with cross-functional teams to define data requirements for analysis.
- Generated detailed reports for management review to inform strategic planning.
Education
MBA - Finance
KIIT School of Management
BhubaneshwarBachelor of Commerce (Hons.) -
Delhi University
Skills
- Power BI
- SQL
- DAX
- Power Query
- Data Visualization
- Dashboard Development
- KPI Reporting
- Statistical Analysis
- Machine learning
- Sales Forecasting
- User Behavior Insights
- Web Analytics
- Financial Analysis
- User Behavior Insights
Certification
- Certified Scrum Master (CSM), Scrum Alliance, 2023
- Business Analyst Master's Program, Simplilearn & IBM, 2020
- Python & SQL Certification, Hub Net, 2021
Projects
- Customer Insight Dashboard, Power BI, SQL, Power Query, Developed a centralized customer analytics dashboard covering 16 retail brands across UAE, Qatar, Kuwait, and Lebanon. Implemented RFM segmentation, retention analysis, and customer behavior tracking to support targeted marketing campaigns. Consolidated data from CRM, POS, eCommerce, and campaign platforms into a single reporting model.
- Mango UAE eCommerce Analytics Dashboard, Power BI, GA4, Built interactive dashboards tracking website traffic, conversions, revenue, and product performance metrics. Reduced reporting effort by 40% through dashboard automation and self-service analytics.
- Multi-Site GA4 & GTM Implementation, Implemented end-to-end analytics tracking across multiple eCommerce brands in the Middle East. Designed event tracking frameworks for Add-to-Cart, Checkout, Purchase, and customer engagement analysis.
Timeline
Data Analyst
Azadea Group
05.2023 - Current
Data Analyst
LIXIL GROUP
06.2022 - 05.2023
Associate Data Analyst
PRISM JOHNSON LTD.
04.2016 - 12.2018
MBA - Finance
KIIT School of Management
Bachelor of Commerce (Hons.) -
Delhi University