RMP.

Turning data into clarity

ABOUT ME / THE STORY BEHIND THE DATA

Hey, I’m Rahat.

Curiosity led me to data.
Real-world problems made me stay.

I’m Rahat Maksud Pranto, a Data Analyst working across business intelligence, database operations and analytics engineering.

Read my story
Portrait of Rahat Maksud Pranto
WHO I AM

My Story

I'm Rahat Maksud Pranto, a Data Analyst with a background in Computer Science and Software Engineering. After graduating from AIUB in 2023, I took time to explore where I wanted to build my career. My interest in databases gradually led me toward data analytics, where I discovered how technical problem-solving could help people and businesses make better decisions.

Before entering the industry, I invested in learning SQL, Python, Power BI, data modeling, and business intelligence through hands-on projects and professional courses. In February 2025, I joined V2 Technologies as a Data Analyst Intern. What began with SQL reporting and dashboards quickly developed into working with enterprise CRM systems, large datasets, cloud data platforms, and complex business requirements.

Today, my work extends beyond visualization into PostgreSQL operations, BigQuery transformations, automation, data quality, and consumer identity resolution. One of the most meaningful parts of my experience has been developing ways to connect repeated consumer records and improve the reliability of consumer-level analysis.

I enjoy understanding how data moves through a system, finding where things can go wrong, and building solutions that make information more trustworthy and useful. As I continue to grow professionally, I'm working toward deeper expertise in analytics engineering and data engineering.

ExperienceThe path from learning to ownership

Built through experience. Grounded in data.

A chronological account of how my responsibilities evolved from teaching to enterprise analytics and database operations.

Feb 2026 — Present
Current role

Maintain production PostgreSQL databases and reliable analytics pipelines for an enterprise CRM platform, combining operational database management, data quality, documentation and analytical engineering work.

  • Manage production PostgreSQL operations, investigate data quality issues and support BigQuery campaign reporting and analytics.
  • Developed multi-method consumer identity profiling across millions of contact records using SQL, Python, fuzzy matching, consumer attributes and location signals to investigate likely duplicate patterns.
  • Handled large-volume PostgreSQL database migration with pg_dump, pg_restore, scripted workflows, compatibility checks and integrity validation.
  • Developed batch-cleanup and partition-maintenance procedures and investigated database performance, indexing and query optimization.
  • Reconciled PostgreSQL contact and survey records with BigQuery fact, dimension and datamart tables; investigated discrepancies and backfilled missing survey data.
  • Documented ECRM database tables, relationships, data dependencies and workflows; guided three interns and one teammate transitioning into the work.
PostgreSQLBigQuerySQLPythonDatabase administrationData quality
Aug 2025 — Feb 2026

Junior Data Analyst

V2 Technologies Ltd.

Experience

Built analytical reporting and segmentation dashboards, translating stakeholder requirements into tested datasets and repeatable workflows.

  • Built a multi-page consumer segmentation dashboard with BigQuery SQL and Looker Studio for analysis of consumer groups and campaign targeting.
  • Developed campaign, consumer-behavior and field-performance dashboards with interactive filters, KPI definitions and analytical reporting datasets.
  • Improved ETL data quality through SQL/Python cleaning, structured transformation and validation checks; automated recurring data workflows.
  • Translated client and operational requirements into analytical datasets and tested dashboards.
BigQueryLooker StudioSQLPythonETL
Feb 2025 — Aug 2025

Data Analyst Intern

V2 Technologies Ltd.

Experience

My transition into industry work began with SQL reporting and an early BIDA dashboard assignment, then expanded into enterprise CRM reporting.

  • Produced more than 15 SQL reports spanning campaigns, call check-back and live observation for the enterprise CRM project.
  • Built more than five interactive Looker Studio dashboards to monitor campaigns and consumer engagement, following the initial BIDA dashboard assignment.
SQLLooker StudioOperational reporting
Jan 2022 — Apr 2022
Experience

Supported practical database teaching during my undergraduate years.

  • Helped 40 students understand database concepts and reviewed over 100 Oracle SQL queries and lab assignments.
Oracle SQLTeachingRDBMS
WHAT I'M WORKING ON

What I Do Today

My work sits between operational data and decisions. At V2 Technologies, I help maintain and validate large-volume PostgreSQL datasets, reconcile data with BigQuery and develop analytical reporting that makes activity easier to understand.

Projects in consumer identity resolution, segmentation, reporting reliability and workflow automation have taught me that a useful dashboard depends on the quality of everything behind it.

Analytics & BISQL · BigQuery · Looker Studio
Database operationsPostgreSQL · Migrations · Data quality
AutomationPython · SQL workflows · Validation
HOW THE WORK EVOLVED

Along the way

2023

Finding my direction

After finishing my CSSE degree at AIUB, I began focusing on the kind of work I wanted to do—where databases, problem-solving and real business needs met.

2023–2024

Learning by building

I developed my skills with SQL, Python, Power BI, modeling, courses and personal projects, learning how to make data useful before joining the industry.

February 2025

My first step into the industry

I joined V2 Technologies as a Data Analyst Intern on 9 February 2025, working through the change from course projects to real deadlines, business requirements and reporting systems.

2025–2026

From reports to dependable systems

The work grew from reporting to BigQuery analytics, PostgreSQL operations, segmentation, automation, migrations, reconciliation and consumer profiling.

BEYOND MY SCREEN

Beyond the Data

Outside professional work, I care about learning, community and the experiences that shape how I collaborate. My academic background includes a final-year IoT irrigation research project, and I've been involved with the MZS Ex-Students Sports Club since 2020.

I'm interested in opportunities where I can combine analytical thinking with engineering discipline—and keep learning by solving real problems.

Explore the projects
CapabilitiesMethods, tools and the work behind them

Skills that turn ideas into dependable work.

Analytics & business intelligence

Interactive reporting, metric definitions and analytical narratives.

Looker StudioPower BIMicrosoft ExcelGoogle SheetsPower QueryDAXKPI dashboardsStatisticsExploratory analysisEDAExcel Pivot Tables

Databases & cloud

Relational modeling, production querying and reporting warehouse operations.

PostgreSQLGoogle BigQuerySQL ServerMySQLOracle 10gSnowflake

Programming & automation

Repeatable data preparation, QA and operational processing.

SQLPythonpandasPowerShellETL scriptingTransformationsWorkflow automation

Database administration

Maintenance, continuity and reliability for growing production datasets.

Backup / restoreMigrationQuery tuningIndexingPartition maintenanceStored proceduresDatabase troubleshooting

Data & business analysis

Turning complex business requirements into trustworthy analytical logic.

Data modelingData reconciliationConsumer profilingFuzzy matchingSegmentationCRM analyticsCampaign reporting

Development & collaboration

Versioning, documentation, coordinated delivery and review.

GitGitHubJiraClickUpTrelloRequirements analysisHTML/CSS (academic)

Documentation & methods

Engineering foundations and documented operating procedures.

Schema documentationWorkflow documentationRDBMSSDLCUMLSQAManual testingIoTAgileCanvaFilmora

AI-assisted tools

AI-assisted research and review with human verification.

ChatGPTClaudeTechnical researchSQL reviewDocumentation support
Education

Where it started.

LIFE BEYOND THE CLASSROOM

Academic &Extracurricular

2023 · FINAL-YEAR THESIS

Smart Irrigation System Using IoT

Academic research exploring IoT sensor data and the automation of irrigation decisions.

2020 — PRESENT · COMMUNITY

Founder Executive Member

MZS Ex-Students Sports Club. Supporting alumni sports and community activities.

2012 · SPORT

National School Handball Champion

A documented extracurricular achievement from my school years.

CredentialsContinuous learning

Built through study and practice.

Public credential image: DataCamp Certified Data Analyst Associate
DataCamp Certified Data Analyst AssociateDataCamp
Verify
Public credential image: Associate Data Analyst in SQL
Associate Data Analyst in SQLDataCamp
Verify
Public credential image: Associate Data Engineer in SQL
Associate Data Engineer in SQLDataCamp
Verify
Public credential image: Microsoft Power BI Data Analyst Specialization
Microsoft Power BI Data Analyst SpecializationCoursera / Microsoft
Verify
Public credential image: Microsoft Power BI Desktop for Business Intelligence
Microsoft Power BI Desktop for Business IntelligenceUdemy
Verify
LET’S PUT THIS TO WORK

What are you working on?

I’m happy to discuss analytics challenges, database reliability, automation projects, and opportunities to build something useful with your team.

Start a conversation