Open to BA & DA Roles

Vernit Tayal

Analyst at TCS · Supporting BT Group, UK

Turning messy data and complex processes into clear business decisions — through SQL, Power BI, and sharp analytical thinking.

✉ Get in Touch View Projects →

credit_risk_analysis.py

1# Load & query customer data
2import pandas as pd
3import sqlalchemy as sa
4 
5query = """
6  SELECT customer_id, risk_score,
7    SUM(txn_amount) AS total_spend,
8    COUNT(*) FILTER (WHERE delinquent)
9  FROM customers GROUP BY 1,2
10"""
11 
12df = pd.read_sql(query, engine)
13high_risk = df[df.risk_score > 0.75]
14# 18% of users → 62% of losses

Monthly Delinquency Rate — BT Orders

📊

Power BI · SQL · Python

End-to-end analytics pipeline

Scroll down

About Me

Analyst by role, problem-solver by nature

I'm Vernit — an Analyst at Tata Consultancy Services (TCS), deployed to support BT Group, a leading UK telecom enterprise, on order lifecycle analysis and escalation management.

My day-to-day involves root cause analysis, stakeholder reporting, process gap documentation, and cross-functional coordination — essentially making sure complex service delivery operations run smoothly and improving them when they don't.

I'm actively building projects in SQL, Power BI, and Python to transition into a BA/DA role at a product-driven organization — open to opportunities across banking, fintech, telecom, e-commerce, and any data-first company where analytical thinking drives real business decisions.

B.Tech in Computer Science Engineering, Graphic Era University — GPA 8.8/10.

Year at TCS

8.8

B.Tech GPA

10+

Stakeholders Managed

15%

SLA Improvement

Core Skills

What I bring to the table

📊

Analytics

SQLPower BIDAXPythonPandasExcelEDAETL

🗂️

Business Analysis

Requirements GatheringBRD/FRDGap AnalysisUser StoriesProcess MappingRCA

🛠️

Tools & Platforms

ServiceNowSalesforceJiraConfluenceMS SQL ServerAgile/Scrum

📈

Data Skills

Data ModellingKPI FrameworksStakeholder MgmtA/B TestingDashboard DesignReporting

Projects

Work I'm proud of

DataGenie 🧞 — WhatsApp AI Data Analyst

Live & Deployed

An AI-powered WhatsApp bot that analyses any Excel file — built from scratch and deployed on cloud.

Send a file, ask a question, get instant insights or Excel reports.
Auto file summary + Excel report with download link
Deployed 24/7 on Render.com with Twilio WhatsApp API

PythonFlaskGroq AIPandasRender

💬 Try on WhatsApp

Customer Credit Risk & Delinquency Analysis

Will be live soon

End-to-end analytics simulating a fintech/banking BA use case — from raw SQL extraction to executive Power BI dashboard.

Analysed 100K+ records via optimised SQL queries & ETL pipeline
Applied data modelling & feature engineering — top 5 default predictors
Power BI dashboard flagging segments driving 62% of delinquency losses

SQLPythonPower BIPandasEDA

Sales & Revenue Performance Analytics

Will be live soon

BI reporting solution for a retail/FMCG scenario — built for stakeholder self-service and executive decision-making.

Integrated SQL Server with Power BI for real-time KPI monitoring
Authored 15+ DAX measures: MoM growth, YoY variance, profit margin
Built Revenue Trend, Regional Heatmap & Product Mix dashboards

Power BISQLDAXExcel

Certifications & Achievements

Recognition & credentials

📊

Databricks Certified Data Analyst Associate 2026

Validated proficiency in data analysis using Databricks — covering data analytics, visualisation, and working with Lakehouse architecture.

Databricks · ↗

🏅

GenAI Powered Data Analytics Job Simulation 2025

Performed AI-powered EDA, predictive modelling, and designed a delinquency risk framework in a simulated enterprise environment.

Forage · ↗

🏆

Cognizant Digital Nurture Ideathon 2023

Presented a data-driven business solution — recognised among top teams for analytical problem-solving approach.

Cognizant · ↗

⭐

TCS Internal Recognition 2026

Recognised at TCS for SLA dashboard automation and improving cross-team visibility through structured analytical reporting.

TCS

📘

Microsoft PL-300 — Power BI Data Analyst Associate

Currently pursuing the Microsoft certified Power BI Data Analyst Associate certification.

In Progress

Resume

Download my resume

📄

Vernit Tayal — BA / DA Resume

ATS Optimised · 1 Page · Updated 2026

⬇ Download Resume

Contact

Let's connect

Open to new opportunities

I'm actively looking for Business Analyst and Data Analyst roles at product-driven companies. If you think I'd be a good fit — or just want to talk data — reach out anytime.

✉️ tayal.vernit.0802@gmail.com 💼 linkedin.com/in/vernit-tayal-o8o2 📞 +91-9528381162

✉ Send me a message

✅

Message sent!

Thanks for reaching out. Vernit will get back to you soon.

📱 User sends Excel → 💬 WhatsApp → 🔴 Twilio → 🐍 Flask Server → 🤖 Groq AI → 🐼 Pandas → 📲 WhatsApp Reply

What is DataGenie? An AI-powered WhatsApp bot that lets anyone upload an Excel file and instantly get data analysis — without needing Excel, Power BI, or any technical tools. Just send a file and ask your question in plain English.

How does it work? When a user uploads an Excel file on WhatsApp bot, the bot reads it using Pandas and generates a file summary. The user then types any question. Groq AI (LLama model) generates accurate Pandas code, Python executes it on the actual data, and the result is formatted and sent back. This two-step approach — AI generates code, Pandas runs it — ensures 100% accurate numbers instead of AI hallucinations.

Why WhatsApp? Most non-technical users — shop owners, sales managers, HR teams — already live on WhatsApp. They have Excel files but no idea how to analyse them. DataGenie brings data analysis to a platform they already use every day.

₹0

Total Build Cost

Days to Build

24/7

Live on Cloud

Tool	Role	Why This	Cost
Python + Flask	Backend web server	Lightweight, fast to build, easy webhook handling	Free
Twilio WhatsApp API	Send/receive WhatsApp messages	Most reliable WhatsApp API, easy sandbox for testing	Free trial
Groq API (LLama 3.3)	Generate Pandas code from questions	Free, faster than OpenAI, good code generation	Free
Pandas	Execute analysis on actual data	Industry standard for data manipulation in Python	Free
openpyxl	Read/write Excel files	Best Python library for .xlsx handling	Free
tmpfiles.org API	Host Excel output files	No signup, instant upload, free download links	Free
Render.com	Cloud deployment 24/7	Free tier, GitHub integration, auto-deploy on push	Free
cron-job.org	Keep server awake	Pings server every minute to prevent Render sleep	Free
GitHub	Version control + CI/CD	Render deploys automatically on every git push	Free

🏪

Small Business Owners

A shop owner tracking monthly sales in Excel can send the file and ask "Which product had highest sales last month?" — without knowing any analytics tools.

📞

Call Centre Managers

Upload agent performance data and ask "Which agent has the lowest CSAT score this week?" or "Give me all records where response time is above SLA in Excel."

👥

HR Teams

Upload employee data and ask "How many employees joined in Q3?" or "List all employees whose salary is above 50000 in Excel report."

📦

Sales & Operations

Upload order data and ask "Which region has the highest revenue?" or "Show me all orders from North region where delivery was delayed."

🎓

Students & Analysts

Quickly explore any dataset by asking questions in plain English — great for quick EDA without writing code.

😴

Cold Start Delay

Render free tier sleeps when inactive. First message after a long gap may take 30-50 seconds to respond.

✅ Fix: cron-job.org pings server every minute — reduces this significantly. Full fix requires Render paid plan ($7/month).

📨

Twilio Sandbox Limit

Free Twilio sandbox allows only 50 messages/day and requires users to join via a code before using the bot.

✅ Fix: Upgrade to Twilio production WhatsApp number (~$15/month) for unlimited messages with no join code required.

📁

Excel Files Only (.xlsx)

Currently only supports Excel files. CSV, JSON, Google Sheets not yet supported.

✅ Fix: CSV support takes ~2 hours to add. Google Sheets integration planned as next feature.

🧠

No Conversation Memory

The bot doesn't remember previous questions in the same session — each question is independent. New file upload resets the session.

✅ Fix: Conversation history can be added to the session dictionary — planned for next version.

📊

No Chart Visualisation

Bot provides text answers and Excel downloads but cannot send chart images directly on WhatsApp via free tier.

✅ Fix: Imgur API integration for chart hosting planned — would enable sending bar/line charts as images.

🔒

No Data Persistence

Uploaded files are stored temporarily in server memory. If Render restarts, session is lost and user must re-upload.

✅ Fix: Adding a database (PostgreSQL — free on Render) would persist sessions across restarts.