
Subham Singh
Associate Analyst

Connect with Subham Singh to Send Message
Connect
Connect with Subham Singh to Send Message
ConnectTimeline
About me
Business Analytics Manager @ The Media Ant
Education

Swami Vivekananda School of Diploma
2014 - 2017Diploma Mechanical Engineering A
Maulana Abul Kalam Azad University of Technology, West Bengal formerly WBUT
2017 - 2020Bachelor of Technology - BTech Mechanical Engineering A
Experience

XL Dynamics India Pvt. Ltd.
Sept 2020 - Sept 2022Associate Analyst• Boosted operational efficiency by 20% through Loan Boarding process optimization. • Analysed missed SLAs on loans, recommending checklist improvements to achieve 100% SLA compliance with zero errors. • Collected client feedback data and generated reports with clear insights for the higher management to improve ratings. • Build 10+ Power BI dashboards to automate the tracking of business funnel performance and efficiency. • Prepared monthly and quarterly reports on Microsoft Excel for individual and team performance. Show less

The Media Ant
Jan 2023 - now• Build & Lead the Business Analytics team of 8 members to improve organizational data architecture & reporting mechanism. • Worked closely with the CEO & CBO to build strategies and develop new revenue streams. • Designed a Cashflow Management System to track cash flow and prioritize vendor payments. • Collaborated with CTO & CPO during in-house ERP system development to identify requirements and define product features. • Led end-to-end development and integration of the finance module with internal ERP system to streamline control over P&L. • Onboarded & Implemented CRM in the organization for better lead management which increases mid funnel Sales KPI by 25%. • Managed a process re-engineering project to achieve 32% reduction in TAT for pre-sales, post-sales & finance processes. • Automated entire lead flow, lead scoring and task management to prioritize leads and reduce the initial response time by 50%. • Designed & Developed data lake & data warehouse on the Google Cloud Platform for enterprise data management. • Revamped data architecture across the platforms to improve reporting data accuracy by 20%. Show less • Partnered with CBO & COO in Planning & Organizing TMA Maha Festival initiative to drive YOY sales growth up to 42%. • Built reporting infrastructure from scratch using Power BI to track business funnel and monitor individuals’ sales performance. • Developed 20+ Power BI dashboards for different departments reporting and monitoring purpose to support decision making. • Automated data collection from multiple marketing platforms to analyse digital campaign performance and drive client ROI. • Managed campaign performance reporting for clients like Spinny, Zoom Car, Spencer’s, L&T Finance, Beyond Snacks etc. • Conducted comprehensive ad hoc analysis and shared insights with the board of members. • Generated reports regarding different product adoption metrics to improve the performance and usability. Show less
Business Analytics Manager
Jan 2024 - nowBusiness Analyst
Jan 2023 - Dec 2023
Licenses & Certifications
- View certificate

Data Analyst in SQL
DataCampNov 2022 - View certificate

Intermediate SQL
DataCampOct 2022 - View certificate

Power BI Data Analytics for All Levels
CodebasicsNov 2022 - View certificate

SQL Masterclass: SQL for Data Analytics
UdemyJul 2022 - View certificate

Jira Fundamentals Badge
AtlassianJul 2022 - View certificate

Data Science Orientation
CourseraAug 2020 - View certificate

Mastering Microsoft Excel
UdemyAug 2020 - View certificate

Data Scientist with Python
DataCampJun 2020 - View certificate

Python Programming Track
DataCampMay 2020 - View certificate

SQL (Basic)
HackerRankOct 2022
Honors & Awards
- Awarded to Subham SinghTMA Culture Champion The Media Ant Mar 2024
Recommendations

Dominique longworth
Trade Account ManagerReading, England, United Kingdom
Moisés tamayo restrepo
Abogado especialista en Responsabilidad Civil y SegurosMedellín, Antioquia, Colombia
Łukasz pińkowski
Java DeveloperKatowice, Woj. Śląskie, Polska
Flavio nunes
IT Manager - Consultor de TI - Gerente de Projetos de TIRio de Janeiro, Rio de Janeiro, Brazil
Nihar joshi
Manager- Strategy and AnalyticsMumbai, Maharashtra, India
Daniela rodríguez
Insurance | Underwriting | Financial Lines | Claims Analysis | ReinsuranceBogota, D.C., Capital District, Colombia
Sudip mahanti
BITS Pilani' 25 || M.Engg. in CSISPilani, Rajasthan, India
Rajitha vadlakonda
Google Certified-Data Analyst | Data Science | Web Developer | Python | SQL | R | Tableau | Power BI...Slough, England, United Kingdom
Awad alkhatam
Civil Engineer فيAJ Saudiمكة جدة السعودية
Jennifer gragson
6th Grade Vocal Music at Maize USD 266Wichita, Kansas, United States
Dominic ajogbei
Assistant Vice President, Investment Banking at MUFGUnited Kingdom
Aline nogueira
Data Analyst Manager | Business Intelligence Manager | SQL | SSIS| SSAS | Power BICariacica, Espírito Santo, Brazil
Erica kron-owen
HR Business PartnerGreater Stockholm Metropolitan Area
Deepak katyan
Supply Chain Enthusiast l Ex-DHLDelhi, India
Seth corbett-davies
Game Designer and Product Owner at RunawayNew Zealand
Vaishnavi hulke
Student at Rajarambapu Institute of Technology, Rajaramnagar, SAKHARALESangli, Maharashtra, India
Vinay singh
QMS & QA Head | Driving Quality Excellence | ISO 9001, IATF 16949, ISO 14001 & ISO 45001,MACE | Audi...Rohtak, Haryana, India
Shree shanti.s
Project Manager at Pertubuhan Kemajuan Sosial MalaysiaMalaysia
Kay hall
Asst Technology OfficerCharlotte, North Carolina, United States
Anand chalawadi
Principal architectBengaluru, Karnataka, India
...