Jatin Sahnan

Jatin Sahnan

Mentor
Rising Codementor
US$10.00
For every 15 mins
ABOUT ME
Data Analyst and BI Consultant
Data Analyst and BI Consultant

Experienced Data Analyst Consultant with 14+ years of expertise in data analysis, data visualization, business intelligence, insight generation, and predictive analytics. Adept at creating impactful dashboards using Power BI, Tableau, and SQL to showcase key metrics and trends. Skilled in leveraging machine learning, deep learning, RAG models, NLP, Python and Pyspark to generate valuable insights and recommendations. Proficient in analyzing complex data sets, identifying patterns, and providing actionable insights to drive strategic decision-making.

Demonstrated success in designing and implementing predictive models for sales forecasting and customer behavior analysis. Strong expertise in data visualization, report creation, and effective presentation of findings to stakeholders. Collaborative team player experienced in working with cross-functional teams to deliver solutions aligned with business objectives. Exceptional communication skills with a proven ability to build positive relationships with clients and stakeholders.

GitHub: https://github.com/jatin-sahnan

Dashboard Portfolio: https://github.com/jatin-sahnan/Dashboard-Samples

LinkedIN: https://www.linkedin.com/in/jatin-sahnan-07549469/

Pacific Time (US & Canada) (-07:00)
Joined November 2024
EXPERTISE
7 years experience
5 years experience
8 years experience
8 years experience
7 years experience
8 years experience
10 years experience

REVIEWS FROM CLIENTS

Jatin's profile has been carefully vetted and approved as a Codementor. Connect with Jatin now, and leave a review for them once you're done!
SOCIAL PRESENCE
GitHub
CNN-Classifier
Creating a CNN classifier to classify the pathology images as foreground vs background.
Python
0
0
Kaggle_Competition
Prediction of Wild Blueberry Yield
Jupyter Notebook
0
0
EMPLOYMENTS
Director
DataIntellec
2024-09-01-Present

As Director of DataIntellec, I lead BI transformation, predictive analytics programs, and AI-driven automation. My fo...

As Director of DataIntellec, I lead BI transformation, predictive analytics programs, and AI-driven automation. My focus is on building scalable data models, actionable dashboards, machine-learning pipelines, and intelligent agents.

Business Intelligence (BI)

  • Architect enterprise BI systems using Power BI, BigQuery, Looker, and Snowflake.
  • Build semantic models, KPI layers, data governance, and automated refresh pipelines.
  • Integrate data from Shopify, GA4, Meta, CRM, and ERP for unified reporting.
  • Deliver finance, sales, marketing, and operational dashboards.

Key BI Example:

  • Created the Del Monte FP&A and Logistics Dashboard, combining sales, inventory, dispatch, and financial planning into a single reporting system for real-time visibility.

Predictive Modeling & Machine Learning

  • Build ML models for forecasting, revenue prediction, churn, and segmentation.
  • Perform feature engineering, model testing, and automated re-runs in Python.
  • Use regression, tree-based models, and boosting algorithms.

Key Predictive Example:

  • Developed the Sodexo Revenue Prediction Model for 3,000+ universities using variables like enrolment, dorm capacity, board amounts, region, and urbanicity, achieving <10% median error.

AI Agents & GenAI Automation

  • Create agents that automate reporting, insights, workflows, and knowledge extraction.
  • Integrate LLMs with BI tools for conversational analytics and automated summaries.

Key AI Agent Example:

  • Built an AI agent that analyzes Zoom recordings and automatically updates Jira tickets with summaries and action items.
Python
SQL
MySQL
View more
Python
SQL
MySQL
Azure
Machine Learning
Fabric
Google BigQuery
NLP
Forecasting
BI
Data analytics
Power BI
Data modeling
Data Engineering
Looker
1C:Enterprise
Data Pipelines
PyTorch
Pydantic
AI
AWS
Generative AI
RAG
Agent Driven ai architectures
View more
Data Analytics Consultant
Freelance
2021-02-01-2024-08-01

Working as a freelance consultant successfully completed projects for various companies on contractual basis.

● Worked on a BI a...

Working as a freelance consultant successfully completed projects for various companies on contractual basis.

● Worked on a BI and reporting integration project involving data extraction and analytics from a 1C ERP environment for manufacturing operations. Assisted in analyzing 1C transactional data related to sales, inventory, procurement, and finance, and integrated it into Power BI dashboards for operational reporting.
● Successfully completed a sentiment analysis project for a Vacation Property review website in US, with FastAPI deployment on AWS EC2.
● Successfully built a city rank scoring system based on affordable living for a US based publication, using Python and Data modelling techniques.
● Achieved a 4% increase in conversion rate and reduced first payment defaults by successfully building lead scoring models and conducting credit risk analysis for a US-based Fintech Company, using Python and Power BI.
● Optimized sales and inventory forecasting using ML algorithms and insightful KPI dashboards for auto accessory manufacturer, resulting in a 13% increase in profit margin within 6 months.
● Streamlined Sales & Marketing strategy for a key client, by structuring the available data and gathering relevant insights, using Tableau.
● Business Intelligence insight provided for an e-commerce firm using PowerBI paginated reports, and achieving 22% reduction in Churn rate.
● Created a robust Applicant shortlisting model for a HR firm, using NLP, and achieved model accuracy of 79%.
● Automated 90% of system checks using business rule automation by applying Lean principles.

Python
SQL
MySQL
View more
Python
SQL
MySQL
R
PostgreSQL
Azure
Fabric
Google BigQuery
Data Science
Tableau
Data analytics
Power BI
Data modeling
Looker
1C:Enterprise
Data Pipelines
AWS
View more
Senior Manager - Business Development
Orix Hifidelity Pvt Ltd
2011-07-01-2021-01-01

Exclusive Automotive Partners for HARMAN and Exclusive India Partners for Elettromedia (Italy)

Data Analyst Role:
● Optim...

Exclusive Automotive Partners for HARMAN and Exclusive India Partners for Elettromedia (Italy)

Data Analyst Role:
● Optimized dispatch operations for B2B distribution by collaborating with a transport company and implementing advanced route optimization tools and real-time tracking systems.
● Utilized data-driven analysis of historical sales data using Excel and Tableau to revamp sales and marketing strategies, resulting in consistent annual turnover growth of 15% over a 5-year period.
● Developed insightful Management Information System (MIS) reports for Board of Directors, enhancing decision-making capabilities and fostering transparency.
● Led a team of 5 members, acting as the primary liaison between clients and operations, ensuring seamless communication and project execution.
Conducted comprehensive performance analysis, aligning business outcomes with objectives, and presenting findings to optimize strategies and achieve business goals.
● Leveraged PowerBI and Tableau to create interactive and visually compelling dashboards, empowering stakeholders with intuitive insights for informed decision-making.

Business Development Role:
● Spearheaded end-to-end operations of product and business development, as well as direct sales for Original Equipment Manufacturers (OEMs) and the Aftermarket segment.
● Successfully introduced a diverse range of automotive products (Speakers, Subwoofers & Amplifiers) to esteemed OEM clients including Maruti Suzuki, Honda, Toyota, Mahindra, and others, tailoring offerings to meet RFQ specifications.
● Orchestrated cross-functional collaboration for documentation, product demonstrations, Quality Assurance approvals, packaging, marketing strategies, and after-sales service to ensure seamless project execution.
● Pioneered the formulation of operational processes and established a new process line.

Python
SQL
Tableau
View more
Python
SQL
Tableau
Power BI
View more