Making datamake sense.

I’m Rahat Maksud Pranto — a Data Analyst working across data & analytics engineering.

I work where analytics, trustworthy data and practical engineering meet—building dashboards, maintaining databases and automating the work behind better decisions.

Explore my work Get in Touch

PROFESSIONAL EXPERIENCE & CLIENT PROJECTS

V2 Technologies Ltd.

Direct employer

British American Tobacco BangladeshClient project through V2

Banglalink

Client project through V2

A Little About MeThe story behind the work

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

Rahat Maksud Pranto · Data Analyst

Read my full story

After graduating in Computer Science and Software Engineering from AIUB, I explored different paths before finding my direction in data analytics.

At V2 Technologies, what began with SQL reports and dashboards grew into work on enterprise CRM analytics, BigQuery, PostgreSQL operations, automation and consumer identity resolution.

What motivates me most is making information more trustworthy—understanding where records come from, what can go wrong, and how to build a more reliable system.

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

Major Project ExperiencesIndependent analytics and academic work

Problems I've worked through.

Independent project · Power BI & SQL

Pizza Sales Analytics

An end-to-end Power BI study of 50,000+ pizza sales records, 15+ KPIs, peak-order periods and menu performance.

My contribution · Independent ETL, data modeling, Power BI dashboard development and seven business recommendations.

View project details

Dashboard or project screenshot for Pizza Sales Analytics

ORIGINAL PUBLIC PROJECT

View all 8 projects

Independent analytics and academic work

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

Data Analyst

V2 Technologies Ltd.

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.

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.

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.

Jan 2022 — Apr 2022