Open To Work
Manzar Imam
Bengaluru
Work Preference
Summary
10+ years of experience in the field of ETL, BI, Data Analytics, Loyalty Programs, CRM. I have always enjoyed working on challenging tasks and like to explore new solutions and technologies.
Overview
14
14
years of professional experience
Work History
Lead Product Specialist
Alshaya Group
Bengaluru
04.2024 - Current
- Collaborated with marketing to launch targeted campaigns showcasing new features, driving user awareness.
- Configured offers, rewards, and lifecycle campaigns in Comarch loyalty program and CRM tool to enhance customer engagement on app.
- Track KPIs such as conversion rate, average order value, and customer retention.
- Conduct surveys and analyze shopping behavior data.
- Conducted pos testing before campaigns launched across all stores.
- Collected and analyzed customer feedback post-launch to evaluate satisfaction levels and inform future improvements.
- Provided training and support to junior specialists to enhance their professional growth.
- Recognized by Arc Award for outstanding work.
- Working for 70+ multinational retail brand such as Starbucks, H&M, Mothercare, BBW etc.
Digital Engineer
DGliger consulting
Gurgaon
04.2021 - 09.2023
- Developed logging and monitoring systems for scripts, jobs, and processes, enhancing data integrity and troubleshooting.
- Created and managed data processing scripts and scheduled tasks to streamline data workflows.
- Skilled at optimizing large complicated SQL statements, using joins & analytic functions.
- Capable of configuring popular database engines.
- Maintained architecture and process flow diagrams for data systems to support efficient data management and communication.
- Work closely with the product development team to resolve bugs & defects.
- Provided ad hoc data reports, matched data sets, and extracted data for analytics teams.
Assistant Manager
Net Carrots Loyalty Services
Noida
01.2020 - 02.2021
- Led successful launch of loyalty and CRM projects for new and existing clients.
- Customize and pull engagement and marketing reports from the CRM, and analyze reports to determine what kind of customer trends the business should respond to.
- Consulted with clients to clarify project details.
- Coordinated with departments such as Creative, Operations, Reward, and Technology to ensure alignment with client briefs.
- Managed the Rewards and Help Desk team to ensure efficient operations.
- Handled reports and conducted data mining and analysis to address business needs.
- Delivered business insights based on existing customer data.
- Do UAT (User Acceptance Testing) for both POS and new loyalty platform.
- Performing Day to Day coordination with the technology team for the smooth running of the CRM/Loyalty program.
- Troubleshoot user or software errors that affect the efficiency of the interaction between people and technology.
- Knowledge of master data management, data warehousing and business intelligence architecture.
Data Analyst
Arla Foods
Oman
12.2017 - 07.2018
- Analysing complex business problems and issues using data from internal and external sources to provide insight to decision-makers.
- Own the marketing domain KPIs and contribute these to the central data platform, working closely with the data engineers to create quality ETL.
- Identified new technologies and enhanced processes for analytics and reporting to improve data insights.
- Experience in ensuring data integrity and validating results, with a high attention to detail and accuracy.
- Addressed data quality issues, including data gaps and biases in underlying data sets.
- Implemented various analytics techniques such as segmentation, churn analysis, RFM, Market basket analysis, retention, cross sell/upsell which helped the Marketing team to properly target customers through SMS /Email.
- Analyse and deliver as requested, or initiate the development of dashboards and regular reports with observations, analysis, key findings and recommendations to support the department in tracking ongoing programs.
- Hands on SQL, able to form queries on large data set.
- Tracked and analyzed data for periodic reporting using advanced Excel to meet reporting needs.
- Delivered regular CRM reporting and data analysis to support internal clients in effective analysis and reporting preparation.
- Hands on work to translate business requirements into Technical Functional Designs.
- Data Governance, reconciliation and cleansing the data so reports can be made.
Analyst
Cartesian Consulting
Bangalore
03.2014 - 09.2017
- Experience on writing SQL/PL SQL scripts for Data reconciliation and SVOC (single view of customer) creation having various kpi such as recency, frequency etc used for various business reports, campaign and analysis.
- Implemented analysis techniques such as clustering and segmentation to enable marketing team to effectively target users through campaigns (SMS/Email) and assess ROI.
- Oversaw campaign management processes by suggesting targeted campaigns, defining segments, and evaluating campaign effectiveness while calculating ROI.
- Generate and compile CRM reports periodically and measure results of all CRM initiatives/ Campaigns to know the impact and effectiveness.
- Preparing various business reports, analysis and ad hoc data to client.
- Campaign, Dashboard and Report Automation – Automating daily basic campaigns-based tasks and minimizing the time for list generation.
- Supporting team with adhocs based on the New and Repeat customer’s transaction and New customers acquired.
- Facilitated collaboration between production and development teams to develop data warehouse and improve processes used by analysts.
- Supported team with infrastructure setup, security, software implementation, data integration, data load, ETL design, database design, and automated queries for existing and new clients.
- Hands on experience on Implementing open-source BI tools (SpagoBI)to provide various business reports.
- Experience of Database creation, Database Maintenance, User management, Database Backup and Recovery, Performance Tuning, Database Base hardening (Security & compliance) Maintenance and support to the Developers.
- Hands on Experience on database Administration.
- Participate in daily stand-up meetings with both Technology and client to facilitate the Understanding, clarification and implementation of requirements.
- Hands on Experience on data aspects of successful launching in Analytics Project for new and existing clients.
Analyst
Capillary Technology
Bangalore
01.2013 - 03.2014
- Handled Big Data across transactions, customer data, and demographics to support data-driven decisions.
- Oversaw effective management of a large database containing approximately 15 million records.
- Managed data quality and health check data reports.
- Database development in SQL: Developing queries for data retrieval for various business analysis requests from commercial teams.
- Worked on Excel for preparing reports and Dashboards based on business requirements.
- Hands on experience on the latest BI Tools of Capillary Technologies “Intouch”, dashboard creation, customer segmentation, campaign design and customer lifecycle models.
- Gained comprehensive understanding of Capillary’s Import Framework, facilitating data transfer to Intouch server.
- Oversee the technical set up of the loyalty program on key platforms – loyalty management system, CMS, campaign tool.
- Analyzed technical and data landscape of loyalty programme to troubleshoot and resolve issues effectively.
Education
B. E - Computer Science & Eng
Paavai Engineering College
India05-2012
Intermediate (XII) -
D.A.V Public School
India03-2007
High School (X) -
D.A.V Public School
India03-2005
Skills
- Campaign Automation
- Loyalty program management
- Data Analysis
- Segmentation
- Campaign design and analysis
- Data Visualization
- BI Tools
- ETL
- SQL
- MySQL
- MS Sql
- Excel
- Data Management
- Windows
- Unix
- Unix
Disclaimer
I hereby declare that the above information is true to the best of my knowledge.
Personal Information
- Father's Name: Mr. Irshad Ahmed
- Date of Birth: 07/10/87
Accomplishments
- ARC
- AI HACKATHONS WINNER
Timeline
Lead Product Specialist
Alshaya Group
04.2024 - Current
Digital Engineer
DGliger consulting
04.2021 - 09.2023
Assistant Manager
Net Carrots Loyalty Services
01.2020 - 02.2021
Data Analyst
Arla Foods
12.2017 - 07.2018
Analyst
Cartesian Consulting
03.2014 - 09.2017
Analyst
Capillary Technology
01.2013 - 03.2014
B. E - Computer Science & Eng
Paavai Engineering College
Intermediate (XII) -
D.A.V Public School
High School (X) -
D.A.V Public School