Rana Muhammad Tehseen
Data Analyst, Statistician & AI Chatbot Developer for Automation.
Hello! I'm RM Tehseen, a Data Analyst with expertise in data analytics, dashboard development, and AI chatbot creation. I specialize in transforming raw data into actionable insights through interactive visualizations using tools like Power BI and Excel, as well as programming in Python and SQL. Additionally, I can develop AI chatbots to automate customer interactions and enhance user engagement. Whether you need end-to-end analytics solutions, automated reporting, or web and mobile app development, I'm here to help! Let me know how I can assist you today. Lets Enter my world
Professional Expertise
Developing visulization Report & Dashboard using MS Excel & Power BI to support Sales & Retails, HR, Banking, and Healthcare industries.
AI chatbots automate audience management, messaging, appointments, and interactions across chat, email, and social media platforms.
AI integration solutions for web and mobile applications to automate your tasks.
Developing mobile and web solutions to enhance your online presence and solve your problems.
Data Analysis | Business Analysis
Transforming raw data into actionable insights
AI Automation | Chatbot Developement
Building intelligent solutions that scale your business/growth
Visualization | Mobile & Web Solutions
Creating compelling data stories that drive decisions
Approaching graduation with extensive practical experience in statistical analysis, business intelligence, and AI development. My technical toolkit includes Power BI, Excel, Python, and SQL.
Services Offered
Dashboard Development
Creating interactive visualizations with MS Excel and Power BI that transform complex data into clear, actionable insights.
Data / Business Analytics
Leveraging Python, SQL, and BI tools to uncover patterns and forecast trends that drive strategic business decisions.
AI Chatbot Development
Building intelligent conversational interfaces that enhance customer engagement and streamline business operations.
Mobile Application & Web Development
We deliver innovative and tailored digital solutions, partnering with clients from concept to execution to create visually appealing and highly functional products with team.
Project Portfolio
Bank Loan Application Management Dashboard
Developed predictive Dashboard to assess loan applicant risk profiles, improving approval accuracy by 27% and reducing default rates.
Coffee Shop Chain Sales Management Dashboard
Created interactive Excel & Power BI dashboards tracking KPIs across regions, identifying $1.2M in untapped revenue opportunities.
Road Accident Dashboard
Built an end-to-end solution for campaign tracking and customer segmentation, increasing conversion rates by 32%. This D
HR - Recruitment Dashboard
Designed an all-in-one HR dashboard to track international and local recruitment. It provides key insights on hiring trends, offer acceptance, position closures, and project status—helping the client make faster, data-driven recruitment decisions.
Recruitment Tracking Dashboard
Built for a Saudi HR team to monitor 2025 hiring, this dashboard tracks candidate progress across all stages, with 12 joined hires and real-time insights into internal vs. external sourcing. It supports faster, data-driven decisions for both local and international recruitment.
E-commerce Analytics Dashboard Project
This case study showcases an e-commerce dashboard that monitors sales across platforms like Amazon and Flipkart. It reveals 64% of customers are women, highlights top states and product categories, and tracks order statuses to optimize business decisions.
Sales Analysis Dashboard Project
The Sales Analysis Dashboard provides real-time monitoring of key sales metrics. It tracks sales trends, analyzes category performance, and breaks down profit by sub-category. With features like regional and monthly filters, it helps businesses optimize sales strategies and improve decision-making to enhance profitability.
Sales Dashboard South America 2024
This project provides a McDonald's South America sales dashboard tracking key metrics like sales, profit, and customer satisfaction across countries. It visualizes monthly trends, breaks down sales by country, and offers insights through interactive charts and maps to support strategic decision-making.
Interactive Sales Performance Report
This dashboard tracks sales metrics in real-time, shows sales distribution for Computers (32%), Laptops (35%), and Mobiles (33%), and offers filters for salesperson, date, and item name to aid performance analysis and data-driven decision-making.
Bank Churn Analysis Dashboard
This dashboard monitors customer churn metrics, showing customer distribution by gender, activity, and credit card status. It analyzes churn rates by age and credit score, and tracks lost customers by country and gender, aiding in retention strategies.
HR Analytics Dashboard/Report
This HR Analytics Dashboard offers real-time monitoring of employee attrition metrics. It visualizes attrition by education, age group, and salary slab, and tracks attrition rates across different job roles and years at the company. With insights into average age, salary, and tenure, HR departments can develop targeted retention strategies to reduce attrition rates
Super Store Sales Dashboard
This dashboard provides a comprehensive overview of sales performance with key metrics like total sales (1.57M), quantity (22K), profit (175K), and average delivery time (4 days). It visualizes sales by region, segment, payment mode, product category, and sub-category. The dashboard also offers year-over-year sales and profit comparisons, sales by ship mode, and a 15-day sales forecast, aiding businesses in strategic planning and performance optimization.
Work Experience
1
Data Analyst @ Market Brains
Oct 2023-present | Remote
Leading data analysis initiatives for market research projects, delivering actionable insights to enterprise clients.
2
Business Analyst @ Global Data Genius
Aug 2022 - Dec 2023 | Faisalabad, Pakistan (Hybrid)
Transformed business requirements into technical specifications and delivered comprehensive analytical solutions.
3
Data Analyst Intern @ CosmiCode
Jun 2022 - Aug 2022 | Remote
Developed dashboards and reports while gaining hands-on experience with industry-standard analytics tools.
Education & Certifications
Education Degree
Bachelor of Science (BS) in Statistics
Government Graduate College of Science, Faisalabad (Affiliated with GCUF)
September 2020 – December 2024 | Faisalabad, Pakistan
gcuf.edu.pk
Completed a 240-credit (ECTS equivalent) undergraduate degree in Statistics, focused on mathematical and statistical analysis. Gained strong skills in data interpretation, statistical modeling, and real-world problem solving. Proficient in tools such as MS Excel, PowerPoint, Word, SPSS, Minitab, R, and C++. Developed strong communication, collaboration, and presentation skills through coursework and extracurricular activities.
Professional Certifications
Technical Skills
Visualization & Reporting
  • MS Excel
  • Power BI
Data Analytics
  • Reports Building
  • Data Extraction
  • Data Cleaning
  • SQL
Programming
  • Python & Libraries
  • R Statistical Language
  • Flutter (Team)
  • CSS, Java, HTML
AI & ML
  • Machine Learning
  • NLP (Basic)
  • Chatbot Development
Contact Me!
Connect with me for professional opportunities & Tips.
Get In Touch!
Have a project or idea in mind? Let's discuss how I can help you transform data into actionable insights.
Fill out the form below, and I'll respond within 24 hours.
Loading...