Mohammad Shahfaishal
Lead Data Analyst
Bengaluru,KA
Summary
Results-driven Lead Data Analyst with over 8 years of expertise in Business Intelligence, Data Analytics, and Big Data solutions across diverse sectors including automotive, banking, e-commerce, chemicals, oil and gas, healthcare, and finance. Proven track record of leading analytics teams to build scalable data pipelines and deliver actionable insights that inform strategic business decisions. Proficient in integrating generative AI and machine learning models to automate reporting workflows, enhance data storytelling, and enable predictive and prescriptive analytics. Committed to leveraging data-driven strategies to drive organizational growth and efficiency.
Overview
8
8
years of professional experience
4
4
Certifications
Work History
Lead Data Analyst
Scienaptic AI
09.2022 - Current
- Built a real-time, data-driven Dealer Management Dashboard for an automobile company that increased booking closure efficiency by 15% in the first quarter, improved billing efficiency, and enhanced average dealer satisfaction scores from 3.7 to 4.5.
- Leveraged competitor sales and demographic data to identify optimal pin codes for dealership openings, resulting in a 12% absolute market share increase within 24 months.
- Improved Power BI efficiency by streamlining Databricks queries, cutting dataset size from 3 GB to 1 GB, and reducing refresh times by over 60%.
- Created an automated email distribution pipeline using Copilot, Python, and the SMTP library, sending early-morning KPI dashboards to business leaders and dealers, improving response time to underperforming areas by 30%.
- Conducted a detailed analysis of ad conversion metrics to pinpoint top-performing marketing channels, reallocated the budget to maximize ROI, and provided channel partners with actionable insights to improve campaign effectiveness.
- Developed interactive credit prediction dashboards in Power BI to track model accuracy, default probabilities, and portfolio risk distribution, improving lending decision efficiency by 20%.
Senior Software Engineer
Diebold Nixdorf
06.2021 - 09.2022
- Developed an interactive Ticket Tracking Dashboard that monitored ticket lifecycles, automated escalation alerts, and helped the Maintenance and Support team reduce average resolution time to less than 20 days , improving SLA compliance.
- Built an interactive Sales Pipeline Monitoring Dashboard that empowered the Marketing team to monitor deal progress, prioritize high-value opportunities, and improve sales closure rates by 20%.
- Created a high-accuracy revenue projection model for the banking sector, integrating multi-source financial data to support strategic decision-making, and enhance profitability forecasting.
- Directed a four-member team to design and deploy a Power BI Embedded–powered Video Teller Analytics platform, delivering real-time dashboards that improved customer service monitoring and branch performance analysis.
- Built a full-cycle ATM Monitoring Analytics prototype using Power BI Reporting Server and Sisense, empowering operations teams to proactively address downtime, and optimize ATM cash management.
Senior Business Intelligence Developer
Augmento Solutions, Bengaluru (Client- Diebold Nixdorf)
02.2021 - 05.2021
- Applied best-practice data modeling techniques to cut report refresh times by 90%, and built Azure NiFi-based ETL pipelines connecting diverse sources, such as Salesforce, Confluence, and JSD, to the BI environment.
- Created and automated recurring executive reports (daily, weekly, monthly, annual) to equip senior management with timely KPIs and trend analysis for informed business planning.
- Administered role-based access to BI reports and dashboards while developing auto-triggered KPI alerts via email, improving operational responsiveness and data security.
Senior Business Analyst
Accenture
07.2017 - 11.2020
- Performed traffic source analysis and bid optimization for an e-commerce client, improving campaign efficiency, and maximizing return on advertising spend (ROAS).
- Built real-time safety compliance monitoring reports, integrating IoT sensor data, ensuring 100% adherence to regulatory standards, and reducing safety incidents by 12% for an oil and gas client.
- Developed predictive maintenance dashboards for drilling equipment using Tableau, reducing unplanned downtime by 15% and saving $2M annually in maintenance costs.
- Processed and analyzed over 100,000 patient records per month using SQL for a healthcare client.
- Developed and deployed a real-time truck tracking dashboard for a chemical industry client, integrating GPS, logistics, and supply chain data to optimize route planning, reduce delivery delays, and enhance transportation visibility.
Education
Master of Technology - Chemical Engineering
Indian Institute of Technology Guwahati
Guwahati, India 04.2001 -
Bachelor of Technology - Polymer Science & Chemical Technology
Delhi Technological University
Delhi, India06-2015
Skills
SQL Database
Power BI
Python Programming
Azure Databricks
Tableau
Excel
Sisense
Data Factory
AWS
Snowflake
Stakeholder Engagement
Agile/Scrum
Team Management
Big data
Statistical Modeling
Certification
AWS Certified Cloud Practitioner
Accomplishments
- Received the Employee of the Quarter award in both 2023 and 2024.
- Developed a Password Manager desktop application using Python's Tkinter module to generate, store, and search complex passwords for self.
Created a Daily Rain Alert SMS system by integrating the OpenWeather API with the Twilio API.
Hobbies
- Badminton, Cycling, Trekking, and Following Market News.
Timeline
Lead Data Analyst
Scienaptic AI
09.2022 - Current
Senior Software Engineer
Diebold Nixdorf
06.2021 - 09.2022
Senior Business Intelligence Developer
Augmento Solutions, Bengaluru (Client- Diebold Nixdorf)
02.2021 - 05.2021
Senior Business Analyst
Accenture
07.2017 - 11.2020
Master of Technology - Chemical Engineering
Indian Institute of Technology Guwahati
04.2001 -
Bachelor of Technology - Polymer Science & Chemical Technology
Delhi Technological University