Pratap Puttaswamy

Pratap Puttaswamy

Business Analyst & Data Scientist

About Me

As a dynamic Business Analyst and Data Scientist, I thrive on uncovering stories hidden in data and transforming them into powerful, actionable insights. My journey in the world of analytics has been nothing short of an exhilarating puzzle-solving adventure—one where I marry technical prowess with strategic thinking to deliver innovative solutions. Currently, I’m wrapping up my Master’s in Business Analytics at Northeastern University, where I’ve sharpened my skills in cutting-edge data analysis, visualization, and governance practices. Along the way, I’ve gained hands-on experience across diverse industries, diving into projects that involve everything from enhancing data governance frameworks to crafting interactive dashboards that make decision-making a breeze for stakeholders. But it’s not just about the tools and techniques—it’s about the impact. Whether leading cloud migrations, streamlining operations, or improving data quality, I’m driven by the joy of turning chaos into clarity. Think of me as the translator who speaks the languages of both tech geeks and business executives, bridging gaps to ensure data-driven strategies don’t just make sense—they make a difference. What sets me apart? A curious mind that’s always eager to learn, a knack for collaboration, and a genuine passion for finding solutions that work in the real world. Add a splash of humor and a sprinkle of creativity, and you’ve got someone who believes that data analysis should be as much about discovery as it is about delivering results. I’m on a mission to channel my expertise into opportunities where I can innovate, collaborate, and help businesses unlock their full potential. If you’re looking for someone who brings both technical savvy and strategic insight to the table—with a healthy dose of enthusiasm—let’s connect!

Professional Experience

Data Science and Analytics Intern
WSP, Boston, USA | June 2024 - Sep 2024
  • Improved data governance with Profisee MDM
  • Developed and maintained Power BI dashboards
  • Optimized data validation tool in Python
Associate Consultant Business Intelligence and Micro Automation
Eli Lilly, Bangalore, India | Aug 2021 - May 2022
  • Led design and development of Power BI dashboards and Power Apps
  • Translated customer requirements into problem statements
  • Engineered VBA macro solutions for process automation
Senior Consultant
Quinnox, Bangalore, India | Mar 2018 – June 2022
  • Directed Cloud migration projects of RESTful web services
  • Led team in implementing data-driven solutions for Waste Management, USA
  • Developed fleet management applications
  • Spearheaded advancements in data warehousing and ETL architectures

Technical Skills

Data Science & Analysis
Python (Pandas, NumPy, Scikit-learn)
SQL
Java
R
Data Profiling
Data Cleansing
Machine Learning
Data Pipelines
Data Automation
Alteryx
NLP (Natural Language Processing)
TensorFlow
PyTorch
Data Visualization
Power BI (DAX, Data Modeling)
Advanced Excel (VLOOKUP, Pivot Table, Power Query)
Tableau
Looker
QlikView
Programming & Automation
Python
R
VBA
Power Automate
Restful APIs
Alteryx
Database Management
MySQL
PostgreSQL
Microsoft SQL Server
Oracle Fusion SSMS
ETL Processes
Software Testing & Integration
UAT
Unit Testing
End-to-End System Testing
Postman
SoapUI
JMeter
Web Servers
Data Management
Data Migration
Data Cleansing
Legacy Data Mapping
Master Data Management (Profisee, Informatica)
Data Pipelines
Data Flows
Cloud Platforms & Big Data
AWS (Redshift, SageMaker, S3)
Azure (Synapse Analytics, Data Factory)
IBM DB2
Google Cloud (BigQuery)
Apache Spark
Hadoop
Airflow
Kafka
Version Control (Git, GitHub)
Project Management & Documentation
Agile Methodologies
Jira
SDLC
Microsoft Word
Excel
PowerPoint
PPM Pro
Stakeholder Communication
Risk Management
PMP Concepts
Advanced Analytics
Forecasting
Predictive Modeling
Regression
Variance Analysis
Time Series Analysis
Optimization Techniques
Bayesian Analysis
Business Skills
Stakeholder Management
Technical Documentation
Business Process Modeling
Data Governance Policies
KPI Design and Optimization
Cost-Benefit Analysis
Requirements Gathering
Statistics & Mathematics
Hypothesis Testing
Probability and Statistics
Time Series Analysis
Optimization Techniques
Bayesian Analysis
Soft Skills
Collaboration
Critical Thinking
Problem Solving
Leadership
Mentoring
Adaptability
Effective Communication

Projects

Transportation Data Analysis for MBTA
Mar 2018 – June 2022
  • Conducted extensive data analysis on MBTA data
  • Developed interactive dashboards in Plotly and Power BI
Sales Performance Analysis for NOVICA on Amazon
Sep 2024 – Dec 2024
  • Analyzed NOVICA's product sales data on Amazon
  • Implemented statistical and machine learning models for sales forecasting
Twitter Trends Analysis
March 2025
  • Developed an interactive Power BI dashboard to analyze Twitter trends, user engagement, and influencer statistics.
  • Implemented dynamic filtering for tweet sources, user interactions, and daily/weekly trends.
  • Leveraged DAX and Power Query to generate real-time insights on the most influential tech profiles.
Twitter Trends Analysis