SQL • Python • Power BI • Data Storytelling
📍 Telangana, India | 📧 asmashaik.nov11@gmail.com | 🔗 LinkedIn
I'm a career-changer and returning professional transitioning from 5 years as an SEO Analyst into Data Analytics and Business Analysis.
After a planned career break, I rebuilt my technical skills from scratch — working through 8+ real-world analytics projects in SQL, Python, and Power BI. I bring a unique combination of business domain knowledge (from SEO and travel industry experience) and hands-on data skills developed through consistent self-learning.
I believe in learning by doing — every project I build represents real understanding, not just course completion.
"You're not late. You're evolving — and every skill you build rewrites your comeback story."
| Project | Tools | Key Highlight |
|---|---|---|
| Brazilian E-Commerce Analysis (Olist) | SQL Server, T-SQL | Analyzed 100K+ orders across 15 business questions — identified 97% one-time buyer retention gap |
| HR Analytics — Employee Performance & Retention | Python, Pandas, Matplotlib | Analyzed 17,415 employee records — found referred employees had 53% KPI success vs 35% others |
| Diwali Sales Retail Analysis | Python, Pandas, Seaborn | Analyzed 11,251 transactions — female customers aged 26–35 generated ₹74.3M vs ₹31.8M by males |
| Credit Card Transaction & Customer Analysis | SQL Server, Power BI, DAX | Built 3-page dashboard on $57M revenue — wrote 7 DAX formulas including WoW revenue ratio |
| Super Stores Sales Dashboard & Forecasting | Power BI, DAX | Built custom date calendar tables after 4 days of independent problem solving — enabled YoY analysis |
| Chinook Music Store — SQL Analysis | SQL Server, T-SQL | Built UDFs, Views, window functions — resolved FK constraint error using sp_fkeys |
| Project | Tools | Key Highlight |
|---|---|---|
| MyTravelBuddy — Travel Web App | React.js, Tailwind CSS, Netlify | Live deployed app — built using GenAI tools, inspired by 5 years in UK travel industry |
🔗 Live Demo: mytravelbuddyapp.netlify.app
| Category | Skills |
|---|---|
| Languages & Databases | Python, SQL (T-SQL / SQL Server), SQLite |
| Analytics & BI Tools | Power BI (DAX, M Query), Excel (Pivot Tables, VLOOKUP) |
| Python Libraries | Pandas, NumPy, Matplotlib, Seaborn, Requests |
| Tools & Platforms | Jupyter Notebook, VS Code, Git/GitHub, REST APIs, JSON, React.js (Basic), Netlify |
| Core Skills | Data Cleaning, EDA, Statistical Analysis, Data Visualization, Dashboard Development, KPI Tracking, Business Reporting |
| AI Tools | ChatGPT, Claude AI, Google Gemini (used for learning support, debugging, and documentation) |
| Area | Status |
|---|---|
| Python Fundamentals | ✅ Completed |
| Python — Pandas, Matplotlib, Seaborn | ✅ Completed |
| SQL — T-SQL / SQL Server | ✅ Completed |
| Power BI — DAX, Dashboards, Forecasting | ✅ Completed |
| REST API Integration (Python) | ✅ Completed |
| React.js — Basic Web App Development | ✅ Completed |
| Interview Prep & Portfolio | 🔄 Ongoing |
| Advanced SQL Project | 🔄 In Progress |
SEO Analyst — Teletext India Pvt. Ltd. & Blighty India Pvt. Ltd. | 2010–2015
- Worked on UK travel booking platforms — BeatTheBrochure & Teletext Holidays
- Data-driven reporting using Google Analytics and Excel dashboards
- Weekly/monthly stakeholder reporting on CTR, bounce rate, conversions, organic traffic
Career Break: 2015–2025 (Personal/Family Responsibilities) Returned 2024 — rebuilt technical skills through intensive self-learning and project work
- 🎓 Master of Computer Applications (MCA) — 71% Distinction | 2006–2009
- 📊 Business Analytics with AI — Internshala | December 2025
- 📈 Power BI & Python Training — Dhyana Mano Prasthanam Spoorthi Classes | 2024–2025
- 🤖 AI Generalist Workshop — Outskill | 2025
I'm actively looking for Data Analyst and Business Analyst opportunities in Hyderabad or Remote.
Thanks for visiting my profile! Feel free to explore my projects and reach out. 😊