Apr 2023 – May 2024 · 1 yr 1 mo · Noida, Uttar Pradesh, India

• Developed comprehensive ETL workflows for managing healthcare data in the United States.
• Insight generation for proprietary products including retention, customer satisfaction and lifetime value and risk analysis
• Collaborated with product and design teams to establish timelines, set priorities, and seek issue resolutions.
• Acquired proficiency in Snowflake SQL, basic Python, a proprietary ETL tool (DAP), and honed project management capabilities.
• Created multidimensional dashboards in Tableau representing health of business including patients' risk
• Enhanced client relations through the presentation of providers analysis, data gaps and optimised data deployment based on client inputs.

Dec 2021 – Apr 2023 · 1 yr 4 mos · Gurugram, Haryana, India

• Performed marketing analysis of all new and existing website visitors, customers and incremental revenue
• Used excel, SQL and python for analysis of customer and leads data
• Performed A/B testing on marketing campaigns in relevant customer segmentation models
• Power BI interactive dashboards and reports for presentation to clients to generate new business opportunities
• Sales Analysis, Website Analysis and Digital Marketing Analytics in collaboration with marketing and product team.

Nov 2020 – Nov 2021 · 1 yr · Noida, Uttar Pradesh, India

• Responsible for analytics of revenue generating verticals
• Conceptualising KPIs for performance measurement and performing journey analytics to help understand behaviour of customers segments over different time frames
• Creating a reporting framework using Snowflake SQL and Power BI for dashboards
• ETL Processing using Informatica
• Responsible for leading analytics solutions to marketing and product analytics teams, prioritising team tasks, technical support, helping set/meet deadlines and stakeholder management

Nov 2017 – Nov 2020 · 3 yrs · Gurugram, Haryana, India

• Customer cohorts generated using demographics, purchase & browsing behaviour helped analyse the campaigns performance and future targeting strategies.
• Attribution analysis of various events in sales e-commerce merchandise
• Studying sales data from better than normal, gaining industry insights and doing competitive analysis
• Analysing social media data from all platforms such as YouTube, Facebook, Instagram and observe and report growth trends using Power BI.
• Website analysis in terms of bounce rates, conversion rate, and other metrics.

Dec 2015 – Nov 2017 · 1 yr 11 mos · Gurugram, Haryana, India

• Created reports for analysing the social media campaigns across Google analytics and Facebook Analytics
• Automated weekly and monthly reporting using Excel Pivots
• Created funnel analysis and optimisation techniques for users
• Improved marketing strategy through process of continuous improvement by analysis lift
• Conducted L30, L90 and L150 days retention analysis for courses and other product offerings and comparing the impact of sales and discounts

Jul 2014 – Nov 2015 · 1 yr 4 mos · Gurugram, Haryana, India

• Worked on simplifying vast data sets used for back-office financial reporting and analysis
• Built a dedicated reporting dashboard and various reconciliation reports for analysis of liquidity-data and its classification