Open to new opportunities · New York, NY (Open to Relocate)

Pratik Pawar

Senior Data & AI Analyst with 8+ years owning enterprise data platforms, KPI governance programs, and AI-powered reporting ecosystems across Transportation, FinTech, and Digital Marketing.

8+
Years Experience
$1B+
Portfolio Managed
10M+
Records Migrated
PL-300
Microsoft Certified
Contact me → GitHub ↗ LinkedIn ↗
About

Summary

I'm a Senior Data Analytics Engineer with 8+ years of experience building enterprise BI platforms, ELT pipelines, and AI-assisted reporting across Transportation, FinTech, and Marketing.

At the Metropolitan Transportation Authority (NYC), I led an end-to-end analytics transformation on a $1B+ capital portfolio — migrating 10M+ records to Azure, engineering self-service Power BI scorecards for C-suite consumption, and designing governance frameworks that drove a ~90% reduction in data discrepancies.

Currently at Verizon, I serve as Talend SME on the GFO Central Team, architecting ETL workflows across enterprise finance systems and automating month-end reporting. I pair that engineering fluency (Talend, dbt, ADF, Snowflake, Python) with modern AI capabilities — NL-to-SQL, RAG pipelines, and GenAI for analytics. Microsoft PL-300 certified and currently completing an MBA in Analytics.

Location
New York, NY (Open to Relocate)
Phone
201-423-1675
Email
pawarrpratik91@gmail.com
Focus Areas
BI · AI/ML · Cloud Analytics
Career

Experience

Oct 2024 – Present
Verizon (Contract)
Senior Data Analyst
Basking Ridge, NJ
  • Serve as Talend SME on Verizon's GFO Central Team, architecting ETL workflows that process 5M+ financial transaction records across enterprise systems, improving reconciliation accuracy by ~30%.
  • Built and optimized scalable data pipelines using Talend, SQL, and Teradata, cutting reporting turnaround time by ~40% and enabling faster month-end close for downstream finance teams.
  • Automated financial business processes with Python, SQL, and UiPath, eliminating ~20 hours of manual effort per week and improving processing efficiency across Finance Operations.
  • Designed executive Power BI dashboards giving leadership real-time visibility into financial KPIs, controls, and operational metrics — replacing 10+ manual reports.
  • Applied advanced SQL to reconcile and analyze millions of transaction records, driving root-cause analysis that resolved 50+ recurring data discrepancies and strengthened financial controls.
  • Led proof-of-concept initiatives for emerging automation technologies, driving ~25% efficiency gains and reducing manual intervention across the GFO organization.
TalendSQLTeradataPythonUiPathPower BIFinancial Reconciliation
Mar 2022 – Sep 2024
Metropolitan Transportation Authority
Data Analyst
New York, NY
  • Owned and delivered a cloud data warehouse migration of 10M+ legacy capital project records into Azure SQL Server, cutting data retrieval latency by 60% and forming the analytics backbone for a $1B+ infrastructure portfolio.
  • Architected and deployed 7+ executive Power BI scorecards with advanced DAX, RLS, and incremental refresh — enabling C-suite and finance leadership to monitor capital expenditures across 50+ live projects, driving a 15% improvement in budget utilization.
  • Engineered automated Azure Data Factory ETL pipelines integrating 12+ source systems (ERP, project management platforms), reducing manual data prep by 70% and compressing data delivery SLAs from 48 hours to under 6 hours.
  • Designed an enterprise data quality and KPI governance framework with automated validation, anomaly detection, and audit logging — eliminating 90% of cross-system data discrepancies, formally adopted org-wide.
  • Developed predictive risk models (regression, trend decomposition) to forecast schedule and budget overruns, giving project leadership 3–4-week early warning signals before cost escalation.
  • Drove C-suite alignment translating KPI requirements into self-service reporting products, reducing executive report turnaround from 5 days to under 48 hours and cutting ad-hoc data requests by 60%.
Azure Data FactoryAzure SQL ServerPower BIDAXRLSKPI GovernancePredictive Modeling
Jun 2021 – Feb 2022
Vetro Technologies Inc.
Data Analyst
New York, NY
  • Designed real-time operational BI dashboards monitoring POS transaction volumes and vendor performance across 100+ vendors, reducing exception resolution time by 40%.
  • Built automated SQL and Python ETL workflows for high-frequency performance log ingestion and reconciliation, reducing data processing overhead by 50% and enabling near-real-time reporting.
  • Executed systematic root-cause analysis on payment failure patterns, identifying 3 critical systemic risk drivers that directly informed platform engineering changes and improved payment success rates by 12%.
  • Partnered with QA, DevOps, and Product teams on data-driven platform diagnostics, surfacing bottleneck patterns through SQL analysis that improved system reliability and SLA compliance.
SQLPythonETLBI DashboardsRoot Cause Analysis
Jun 2015 – Jul 2019
Endurance Technologies
Data Analyst
Mumbai, India
  • Engineered Python and SQL marketing data pipeline infrastructure automating ingestion and transformation across digital channels, reducing processing time by 50% and enabling same-day campaign reporting.
  • Built and maintained Tableau KPI dashboards tracking CPL, CTR, and conversion performance — insights directly drove media spend reallocation that improved digital campaign ROI by 15%.
  • Ran structured A/B experiments across campaign segments that increased click-through rates by 22%; testing methodology was formalized as the standard experimentation playbook across all brand lines.
PythonSQLTableauA/B TestingCampaign Analytics
Capabilities

Technical Skills

Analytics & BI
12 technologies
Power BIDAXRLSSemantic LayerIncremental RefreshPL-300 CertifiedTableauLookerQlik SenseExcel · Power QueryCopilot for Power BINL Q&A · Ask Data
Data Engineering
13 technologies
TalendAzure Data FactorydbtETL / ELTDimensional ModelingStar SchemaData Warehouse ModernizationData Quality FrameworksAI-Powered PipelinesPinecone · pgvectorEmbedding StorageRAG ArchitectureSemantic Search
Cloud Platforms
12 technologies
Azure Synapse AnalyticsAzure SQL ServerAzure OpenAI ServiceAzure AI FoundryAzure Machine LearningSnowflakeSnowflake Cortex AIAmazon RedshiftAmazon SageMakerGoogle BigQueryBigQuery MLAWS Glue
Programming
14 technologies
PythonPandas · NumPy · SciPyscikit-learnHugging Face TransformersOpenAI SDKLlamaIndexSQL · CTEs · Window FunctionsQuery OptimizationRSQL ServerTeradataPostgreSQL · pgvectorMySQLOracle
AI & Advanced Analytics
21 technologies
Generative AI for AnalyticsNL-to-SQLGPT-4 APILangChainLlamaIndexRAG ArchitectureLLM OrchestrationAI Agent DesignPrompt EngineeringChain-of-ThoughtFine-Tuning · Few-ShotARIMA · ProphetRandom Forest · XGBoostLSTM · Time-Series NNsA/B TestingPredictive ModelingFeature EngineeringSHAP · LIMEMLflowResponsible AIProcess Automation · UiPath
Financial Analytics & Reporting
7 areas
Financial Reporting & ReconciliationVariance AnalysisMonth-End Close SupportKPI & Metrics DevelopmentForecasting & BudgetingFinancial Controls & GovernanceOperational & Management Reporting
Leadership & Governance
10 skills
KPI GovernanceData Quality StandardsAI Governance & Model RiskSelf-Service Analytics StrategyGenAI Enablement & TrainingExecutive CommunicationCross-Functional CollaborationAgile · ScrumGitJira
Work

Projects

01 · NLP / Python
Metacritic Sentiment Analyzer

Built a Python application that scrapes user reviews from Metacritic and classifies sentiment (positive, negative, neutral) using NLTK and VADER. Backed by PostgreSQL and served via a Flask API.

PythonFlaskPostgreSQLBeautifulSoupNLTK · VADER
View on GitHub ↗
02 · Analytics / SQL
FoodEx · Food Delivery Analytics

End-to-end analytics platform built on a food delivery database — MySQL OLTP schema, Azure Data Factory ETL pipeline, Azure Synapse star schema, dbt transformations, Power BI dashboards, and Azure ML models for demand forecasting and churn prediction.

MySQLAzure SynapseAzure ADFdbtPower BIAzure ML
Live Portfolio ↗ GitHub ↗
03 · Coming Soon
NL-to-SQL Query Engine

An LLM-powered interface that translates natural language business questions into optimized SQL queries — built with LangChain, GPT-4, and a Snowflake backend.

LangChainGPT-4 APISnowflakePython
In progress
04 · Coming Soon
Transit Delay Forecast Dashboard

End-to-end ML pipeline predicting subway delays using ARIMA and Random Forest, with a Power BI front-end and Azure Data Factory orchestration — inspired by MTA work.

Azure ADFRandom ForestARIMAPower BI
In progress
Academic

Education

MBA in Business Management, Analytics & Information Technology
Monroe University
New York, NY · 2025 – Present
Master of Science in Information Systems
Pace University
New York, NY · 2019 – 2021
Bachelor of Engineering in Electronics & Telecommunications
Pune University
Maharashtra, India · 2012 – 2015
Credentials

Certifications

✦
Microsoft Certified: Power BI Data Analyst
PL-300 · Microsoft
✦
Add your next certification here
e.g. Azure Data Engineer DP-203
Writing

Articles & Insights

How I Built a NL-to-SQL Engine with LangChain and Snowflake
A walkthrough of building a production-ready natural language query interface for business analysts.
Coming Soon
dbt + Azure Synapse: Lessons from a Real Migration
What I learned modernizing a legacy SQL Server warehouse for a 12M-records-per-day transit dataset.
Coming Soon
Power BI Semantic Layer: The Foundation No One Talks About
Why the semantic layer is the most underrated component of any enterprise BI stack — and how to build one right.
Coming Soon
Contact

Let's build something together.

I'm open to full-time roles, contract work, and consulting engagements in data analytics, BI engineering, and AI-powered analytics. Let's talk.

✉
pawarrpratik91@gmail.com
⌥
github.com/PratikNPawar
in
linkedin.com/in/pratiknpawar
Send message →