Ankit Kumar Singhal
Manager at Accordion (Merilytics) | DMS IIT Delhi (2021-23) | Treasurer - Opcentuate | Executive Member - SportsCom | Ex - TechnipFMC | Ex - IOCL | Project Management | Co-founder - CMSE Mentors | IIT Dhanbad\'18
- Role
- Project Manager at Accordion India
- Location
- New Delhi, DL, IN
- LinkedIn followers
- 500 followers
About Ankit Kumar Singhal
Ankit is a student of the Department of Management Studies, IIT Delhi of batch 2021-23…
Experience
Project Manager
May 2023 — Present · Hyderabad, IN
Managing data warehouse and BI reporting for a key (CPG) account with USD 600 Mn annual revenue and a subsidiary of a top 50 Forbes’ List Company- Responsible for managing a cross-functional global team of 10 analysts to ensure seamless operations of a project worth ~$2m annual revenue using a Kanban board- Won the Team Squad and Team Marvel Awards for their consistent quality delivery throughout the year- Led Agile product development as Product Owner, delivering 5+ features in 6 months. Implemented Sprint-based Scrum practices, boosted efficiency by 20%- Coordinated with Vendors, internal and external business, technical, and leadership team (CXOs) to manage impediments effectively and ensure delivery- Developed re-usable KPI focused dashboards leveraging Excel and Power BI to help businesses generate impactful insights to help in decision making- Established Customer segment analysis and automated email marketing campaign to reactivate the lost customers, increased 38% sales, and 6% customer retention- Performed account receivables (AR) analysis to optimize working capital requirement, reduced delayed AR by ~10%- Build reconciliation dashboards to flag any issues in data ingestion among the three different systems (JDE, Salesforce, Magento)- Implemented a unified data model to collate data from 6 subsidiaries and built executive reporting for leadership- Created robust and scalable ETL pipelines in Data Factory for daily, weekly and monthly loads to process around ~100 tables with automated custom quality rules - Integrated multiple data sources On-prem, database, ADLS, SFTP, API, REST APIs into single Data Lake and created delta tables using Data Factory and DBT- Introduced and created Entity Relationship diagrams for self-serve Data Products using Star and Snowflake schema and Medallion architecture- Set up Cloud Data Warehouse and Delta Lake architecture in Azure using Azure Data Factory, Synapse and performed CI/CD activities using Azure DevOps
Education
Asian Institute of Technology
Short Term Course, Business Administration and Management, General
Indian Institute of Technology, Delhi
Master of Business Administration - MBA, Business Administration and Management, General, Majoring in IT Analytics, Finance
2021 — 2023
Indian Institute of Technology (Indian School of Mines), Dhanbad
Bachelor of Technology (B.Tech.), Mechanical Engineering
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.