PAVANKALYAN P.
Senior Data Analyst
Open to offersNew to PlatformAbout
PavanK is a seasoned Senior Data Analyst with five years of experience harnessing SQL, Python, and BI tools like Tableau and Power BI to generate decision-ready insights across various sectors including operational, financial, and clinical domains. At Amazon, he designed KPI datasets and automated data pipelines that intensified forecast alignments globally, while massaging complex data into insightful metrics that facilitated major strategic decisions. His tenure at Norton Healthcare involved integrating clinical data into Azure Synapse Analytics, thereby enhancing leadership's decision-making capabilities through standardized reporting. At JPMorgan Chase, PavanK pioneered the reconciliation of risk and finance datasets, which bolstered audit readiness and executed CI/CD pipelines to ensure consistent metric delivery for compliance reporting. His educational background includes a Master's in Data Analytics and Visualization from Yeshiva University, complemented by certifications in advanced data analytics from eminent institutions such as Google and IBM.
Experience
Sr. Data Analyst
Amazon · 2025 — PresentDeveloped scalable KPI datasets in Snowflake, utilizing SQL transformations to provide weekly performance narratives for category leaders and enhance forecast alignment across global fulfillment workflows. Automated ingestion and validation processes on AWS through Python and ETL jobs, decreasing manual reconciliation and ensuring consistent delivery of metrics to downstream BI dashboards. Conducted A/B testing analysis and Excel modeling to identify conversion drivers, thereby refining feature rollouts and improving the clarity of the customer journey across devices. Enhanced reporting layers in Tableau and Power BI using Power Query, which sped up refresh cycles and improved self-service access to operational insights for stakeholders during peak periods. Verified source-to-dashboard lineage via CI checks in GitHub, which reinforced data quality controls and minimized recurring metric disputes among analytics, finance, and product teams.Data Analyst
Norton Healthcare · 2024 — 2025Merged clinical and revenue-cycle extracts into Azure Synapse Analytics using SQL, which facilitated standardized measures for quality reporting and expedited leadership decisions across the organization. Established standardized data definitions and documentation in Confluence and BI artifacts, aligning multidisciplinary teams and consistently reducing ambiguity in regulatory and operational dashboards enterprise-wide. Streamlined the production of recurring reports through Excel, PowerPoint, and Tableau templates, improving turnaround times for service-line reviews and enhancing transparency of patient outcomes on a monthly basis among leaders. Managed ELT processes using Databricks notebooks and Python, augmenting scalability of encounter-level analytics while supporting refreshes for inpatient and outpatient reporting operations at scale. Created visualizations of care-variation patterns in Looker, uncovering actionable opportunities for clinicians and facilitating targeted initiatives across departments without interrupting daily clinical workflows.Data Analyst
JPMorgan Chase · 2020 — 2023Conducted reconciliations of risk and finance datasets using SQL and Excel controls to ensure accurate data warehouse reporting and aid in audit readiness related to cross-border payments and anti-money laundering monitoring. Developed customer segmentation features with Python and BI datasets to enable relationship managers to effectively prioritize outreach, which improved consistency across quarterly portfolio performance reviews. Oversaw pipeline health through CI and CD pipelines, identifying upstream breaks early and ensuring reliable metric delivery for executive scorecards and global compliance reporting. Implemented governed access controls for AWS and Azure resources, promoting least-privilege analytics and safeguarding sensitive financial data while maintaining analyst productivity. Authored documentation for requirements and acceptance criteria with stakeholders, translating ambiguity into testable metrics to ensure dashboards conformed to policy expectations across various business units.
Skills & Expertise
Education
- Master's in Data Analytics and VisualizationYeshiva University
- Bachelor's in Computer Science and EngineeringJawaharlal Nehru Technological University