Aniket Ghosh
Kolkata
Summary
Experienced Data Analyst Manager with 13+ years of expertise in data extraction, analytics, dashboard development, and insight generation. Proficient in Tableau,SQL, SAS, Power BI, Snowflake and Excel, with a proven ability to translate raw data into actionable business intelligence. Adept at marketing analytics, customer segmentation, campaign performance tracking, and competitor analysis. Strong background in data cleaning, ETL, and visualization to drive data-informed strategic decisions. Strong background in consulting with business stakeholders, data engineers, and IT teams to define data-driven strategies, optimize analytics solutions, and enhance decision-making. Passionate about leveraging data storytelling and visualization to empower organizations with actionable insights.
Overview
17
17
years of professional experience
Work History
Data Analytics Manager
Innovatics Consulting LLP Private Limited
Ahmedabad
12.2023 - Current
- Helped stakeholders meet needs and resolve problems by recommending data-driven solutions.
- Visualized data trends and results with graphs and charts.
- Designed interactive dashboards and reports for executive-level stakeholders, facilitating data-driven decisions.
- Collaborated with cross-functional teams to define data collection and analysis standards.
- Developed documentation for data analysis processes, ensuring the reproducibility of results.
- Analyzed customer behavior patterns, contributing to targeted marketing strategies.
- Provided mentorship and training to junior data analysts, promoting best practices.
- Prepared comprehensive reports for executive leadership using visualization tools, such as Tableau or Power BI.
Assistant Manager
Bridgetree Research Services Private Ltd.
Kolkata
11.2020 - 11.2023
- Managed daily workloads by organizing schedules, and delegating tasks.
- Assisted with hiring, training, and evaluating new staff members.
- I supervised a team of employees, providing guidance and support for their professional development.
- Created and refined standard queries for verifying data quality and pinpointing errors.
- Contributed to data capture, storage, and forecast for analysis projects.
- Made actionable recommendations after analyzing and interpreting data from different sources.
- Coordinated with design, project management, and production teams to deliver timely support to planned campaigns.
Data Analyst
Bridgetree Consultancy Private Ltd.
Kolkata
09.2011 - 01.2016
- Developed reports and dashboards to report on key business intelligence.
- Documented report and dashboard specifications from existing systems and tools.
- Collaborated with cross-functional teams to gather and define data requirements.
- Automated repetitive data processing tasks, enhancing productivity.
- Developed custom reports and dashboards to meet specific stakeholder needs.
- Analyzed large data sets to identify trends and patterns.
Trainee Junior Data Analyst
Bridgetree Consultancy Private Ltd.
Kolkata
03.2011 - 08.2011
- Cleaned raw data prior to analysis by identifying and correcting errors, inconsistencies, or missing values.
- Performed data cleaning and preprocessing to ensure the accuracy of datasets.
- Engaged in continuous learning to stay updated with the latest data analytics tools.
- Conducted thorough data validation checks to ensure the accuracy and completeness of datasets.
- Documented technical specifications and requirements for data collection.
- Cleaned, categorized, and stored data in specific groups and sets.
Village Level Entrepreneur
West Bengal Government
Kolkata
03.2008 - 02.2011
- Managing the e-Panchayat system, which digitizes Gram Panchayat records and processes. Assisting in the implementation of the West Bengal e-Governance Mission Mode Project (MMP).
- Entering and updating records in government databases (e.g., land records, MNREGA job cards, and ration card databases). Maintaining financial records and digital accounts for Panchayat expenditures and schemes. Uploading development project reports, and monitoring real-time progress of schemes.
- Conducting computer training for Panchayat officials and village entrepreneurs. Promoting digital literacy programs, like PMGDISHA (Pradhan Mantri Gramin Digital Saksharta Abhiyan). Encouraging villagers to use digital services for financial transactions and government schemes.
Education
Bachelor of Computer Applications - Computer And Information Systems
NIBMT
New Delhi01-2008
Skills
- Programming and Querying: SQL, SAS
- Data Visualization and BI Tools: Tableau, Power BI, Excel
- Data Warehouse: Snowflake
- Campaign and Marketing Analytics: Customer Segmentation, Competitor Analysis, Response Optimization
- Statistical and Analytical Methods: A/B Testing, LTV and CAC Analysis, Regression Analysis
- Project Management and Collaboration: Asana, Performyard
- ETL & Data Processing: Data Cleaning, Data Mining, and Ad-hoc Data Exploration
- CRM and Customer Insights: Google Analytics, GeoLIFT
Accomplishments
- Won 2nd prize in Analytics competition for presenting best stat model in Bridgetree
- Awarded Rising Super Start at Innovatics in January 2024
Languages
Bengali
First Language
English
Proficient (C2)
C2
Hindi
Intermediate (B1)
B1
Projects
- Customer LTV & Marketing Performance Dashboard (Tableau, SQL, Excel) Designed interactive dashboards for trend identification in cost, revenue, and customer acquisition. Created cohort analysis tools to compare customer behavior across marketing channels.
- Channel Attribution & Marketing Spend Optimization (Google Analytics, SQL, Tableau) Built a multi-tab dashboard analyzing customer journeys from ad impression to purchase conversion. Implemented TOFU, MOFU, BOFU models for tracking marketing effectiveness across different channels.
- Developed a Snowflake Performance Tracking Dashboard in Tableau to monitor and optimize query performance, warehouse usage, and cost efficiency. Provided real-time insights to improve resource allocation and enhance query execution efficiency across data pipelines.
- EDA for Amusement Park CRM (SAS, Tableau, Excel) Conducted pattern analysis on customer visits, leading to data-driven promotional campaigns. Developed frequency distribution reports based on demographics, revenue, and customer loyalty data. Conducted exploratory data analysis (EDA) on CRM data for 16 amusement parks, uncovering customer trends that improved visitor retention by 22%.
- Creation of report comparing different matrices of customers profile for a US based sports company. Development and implementation of SQL queries used for extracting data from client’s database. Cleaning the data and standardizing of address using SAS and Mailers as per the requirements. Create indexes for all the demographic/ house graphic trait to test significance
Timeline
Data Analytics Manager
Innovatics Consulting LLP Private Limited
12.2023 - Current
Assistant Manager
Bridgetree Research Services Private Ltd.
11.2020 - 11.2023
Data Analyst
Bridgetree Consultancy Private Ltd.
09.2011 - 01.2016
Trainee Junior Data Analyst
Bridgetree Consultancy Private Ltd.
03.2011 - 08.2011
Village Level Entrepreneur
West Bengal Government
03.2008 - 02.2011
Bachelor of Computer Applications - Computer And Information Systems
NIBMT
Similar Profiles
RAVIKUMAR TRAVIKUMAR T
Team Lead for Income Tax and ROC Compliances at PSVV Consulting Private Limited & PCP Advisory & Consulting LLPTeam Lead for Income Tax and ROC Compliances at PSVV Consulting Private Limited & PCP Advisory & Consulting LLP
Balamurugan DevadossBalamurugan Devadoss
Business Analyst at BNP Paribas India Solution Private Limited, Vendor : Quantum Leap Consulting Private LimitedBusiness Analyst at BNP Paribas India Solution Private Limited, Vendor : Quantum Leap Consulting Private Limited
Ramchand MekaRamchand Meka
Senior Accountant ( Team Lead) at TATA Sikorsky Aerospace Limited ( Payroll Pulivarthi Consulting India Private Limited)Senior Accountant ( Team Lead) at TATA Sikorsky Aerospace Limited ( Payroll Pulivarthi Consulting India Private Limited)