Pavan Kumar
Data Analyst | Python, SQL, Power BI, Hadoop, Hive | Expert in ETL, Compliance Reporting & Financial Analytics | Freddie Mac | MS in CS - SUNY Binghamton
- Role
- Data Engineer at Philip Morris International
- Location
- New York, NY, US
- LinkedIn followers
- 500 followers
About Pavan Kumar
Data Analyst with around 5 years of experience specializing in Python, SQL, Power BI, and data engineering tools like Hadoop and Hive, with a strong track record at Freddie Mac and Hexaware Technologies. Proven ability to design ETL pipelines, perform data validation, and create insightful dashboards for compliance and executive reporting. Known for effective cross-functional collaboration, delivering data-driven insights that enhance accuracy, reduce risk, and support strategic decision-making in financial and lending domains.
Experience
Data Engineer
Nov 2024 — Present · US
Built scalable ETL/ELT pipelines across 12 source systems to support high-volume data processing and improve reliability of business-critical reporting.Led source-to-target mapping analysis for an Azure Synapse-to-Snowflake migration, resolving mapping gaps and transformation issues that reduced go-live defects.Contributed to migration efforts by rebuilding ingestion and transformation logic for 60+ reports, helping reporting and analytics teams maintain dashboard continuity during cutover.Implemented metadata-driven pipeline frameworks to manage source-specific rules, improving maintainability and simplifying support across recurring data loads.Optimized SQL transformations and refresh logic to improve data consistency, reduce post-refresh failures, and strengthen production stability.Reduced manual support effort across migrated data pipelines by improving release quality, pipeline stability, and rerun handling.Integrated API-based and structured enterprise data into curated Snowflake views used by Power BI and analytics teams for KPI and operational reporting.Worked within a CI/CD release process using Bitbucket to promote SQL scripts, Snowflake objects, and pipeline changes across multiple environments.Partnered with QA, reporting, and functional teams to validate outputs, resolve defects, and accelerate production readiness.Built and enhanced Power BI dashboards on Snowflake datasets to support updated business logic and downstream reporting needs.
Education
Binghamton University
Master's degree
2022 — 2024
AMRITA VISHWA VIDYAPEETHAM
Bachelor's degree
2016 — 2020
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.