Ashika Ashokan

Data Analyst with 1+ years of experience in SQL, Power BI, Python, excel, and ETL pipelines, specializing in marketing analytics, CRM data, and business intelligence. Proven ability to clean, transform, and analyze large datasets, build automated reporting solutions, and deliver KPI-driven insights to stakeholders. Experienced in 6sense, ABM analytics, dashboard development, and data-driven decision support across global clients.

Adept at translating complex business requirements into scalable, efficient reporting solutions that enhance operational visibility and performance.

Data Analyst / Data Consultant - Bounteous (Lister Technologies) - Chennai

(2022-12 - 2024-04)

• Built and automated ETL/ELT data pipelines using SQL, Big Query, AWS RDS, and Cloud Storage to process marketing, CRM, and product datasets at scale.
• Unified and transformed data from 6sense, Salesforce, HubSpot, and website tracking tools, ensuring clean, reliable datasets for analytics and reporting.
• Designed and optimized SQL data models and complex queries (CTEs, joins, subqueries, window functions) across MySQL, PostgreSQL, and Big Query.
• Improved query and pipeline performance by 20–40% through indexing, query restructuring, and efficient data modeling.
• Developed interactive dashboards using Power BI, Tableau, and Metabase to track account engagement, funnel metrics, pipeline trends, and revenue impact.
• Delivered KPI-driven insights including conversion analysis, lead quality scoring, churn indicators, and campaign performance measurement.
• Performed 6sense analytics on intent signals, ICP matching, account scoring, keyword engagement, and pipeline movement to support ABM strategies.
• Integrated 6sense and CRM data to analyze end-to-end account journeys and identify high-intent, high-propensity sales opportunities.
• Measured ABM campaign effectiveness across LinkedIn Ads and email workflows, enabling sales and marketing teams to prioritize target accounts.
• Collaborated with global clients and cross-functional stakeholders to define KPIs, present insights, deliver weekly/monthly reports, and support data-driven decisions.

Data Analyst Intern - Pvt Ltd - Chennai

(2020-07 - 2020-10)

• Developed Power BI dashboards to visualize client investment patterns, trading activity, and portfolio performance, enabling advisors to deliver data-driven recommendations.
• Analyzed daily NSE/BSE market data, including top gainers/losers, sector performance, and volatility trends, and automated daily market reports to reduce manual work by 70%.
• Performed customer segmentation based on trading frequency, product usage (Equity, F&O, Mutual Funds), and investment behavior to support targeted marketing and cross-sell strategies.
• Conducted portfolio risk & return analysis using metrics such as beta, volatility, and CAGR to identify overexposed or high-risk portfolios.
• Cleaned and queried CRM and transaction datasets using SQL to support onboarding funnel analysis, lead quality checks, and investor activation insights.
• Collaborated with advisory and business teams to present insights that improved client engagement, sales decisions, and investment recommendations.

PG Diploma - Data Analytics - Imarticus Learning (2022)

Bachelor of Business Administration - Business Administration - Shri Krishnaswamy College for Women (2020)