Ankit Kumar

Senior Data Analyst

Cling Multi Solutions•  April 2023 - December 2023•  Mumbai

 Enhanced Data Retrieval & Reporting: Developed optimized SQL queries (CTE-based), improving data retrieval speed and enabling real-time Tableau updates.  Automated Data Pipelines: Built ETL pipelines integrating multiple sources, minimizing errors and boosting data accuracy.  Profit & Pricing Optimization: Conducted competitive market analysis and dynamic pricing strategies aligned with business expansion goals, improving profit margins by 8%.  Cost-Effective Cloud Solutions: Partnered with engineering teams to optimize AWS & Azure pipelines, cutting cloud storage costs by 25%.  Data-Driven Marketing Strategy: Developed and deployed Python-based customer segmentation models using classical ML algorithms (e.g., decision trees), supporting targeted international expansion and boosting Q2 sales by 20%.

Senior Data Analyst

Institutional Investor•  October 2021 - March 2023•  New York City

 SQL & BI Optimization: Enhanced SQL queries, reducing report generation time by 10%, enabling faster sales decisions. Built and maintained interactive Tableau dashboards using SQL and cloud data sources, aligning with real-time reporting practices  Pricing & Revenue Strategy: Developed a pricing model (SQL & Excel-based) with Sales & Finance teams, ensuring profitability while maintaining value for money.  Marketing & User Engagement: Developed Python regression models to optimize digital marketing efforts and drive 20% customer acquisition growth. Conducted A/B testing on landing pages, improving conversion rates by 15%.  Data-Driven GTM & Compliance: Executed Go-To-Market (GTM) strategies using Google & Adobe Analytics, optimizing marketing and driving quarterly revenue growth. Ensured GDPR compliance, reducing reporting time by 10%.  Leadership & Mentorship: Led cross-functional data initiatives with product, finance, and marketing teams. Trained a junior analyst in Salesforce, Excel, and BI solutions, improving team efficiency.

Associate Consultant

Accenture•  November 2016 - July 2019•  Mumbai

 Agile Project Execution: Led requirement gathering & scrums, reducing project scope creep and improving sprint completion times through stakeholder collaboration.  SAP Implementation & Integration: Configured SAP framework for seamless enterprise-wide integration, improving data accuracy.  Automated Reporting Efficiency: Developed Excel VBA macros, reducing report consolidation time by 70%. System Testing & Deployment: Conducted UAT & validation tests, cutting post-launch defects by 25% and ensuring smooth SAP deployments.  User Training & Adoption: Created training materials & documentation, boosting system adoption and enhancing operational efficiency.