Senior Data Analyst with 5+ Years BFSI Experience

JAGANNATH PATRO ALLUPATI

Data Analyst

West Haven, CT +1-203-***-**** *********@**********.***

PROFESSIONAL SUMMARY

Intellectually curious and results-driven Senior Data Analyst with 5+ years of experience in the Banking and Financial Services (BFSI) industry. Expert in transforming complex datasets into actionable insights using SQL Server, Python, and Power BI/Tableau. Specialized in Source-to-Target Mapping (STTM), Data Governance, and Financial Crime (AML/Fraud) compliance. Proven track record of automating ETL workflows and optimizing vendor data dictionaries for multi-million dollar projects. Adept at bridging the gap between technical teams and C-suite stakeholders in high-pressure, regulated environments. Experienced in designing executive-ready Tableau dashboards, automating operational reporting, modernizing legacy reporting systems, and delivering data-driven insights for business performance monitoring and SLA tracking. TECHNICAL SKILLS

Data Analysis & Scripting

Python (Pandas, NumPy, Scikit-learn), SQL (T-SQL, PL/SQL), R, PySpark, SAS, Python Automation for Data Transformation, Predictive Analytics, TabPy Integration BI & Visualization

Tableau Desktop, Power BI (DAX), Looker, Matplotlib, Seaborn, Excel (VBA/Macros), Interactive Dashboard Design, Executive Reporting, Data Storytelling, SLA Performance Dashboards, Operational Analytics Financial & Market Data

Bloomberg Terminal, Refinitiv Eikon, MDM (Calero/MDSL), FactSet, S&P Capital IQ Databases & Big Data

SQL Server, Oracle, Snowflake, Azure Synapse, PostgreSQL, Hadoop, Google BigQuery, Enterprise Data Lakes ETL & Governance

Informatica, Apache Airflow, Data Mapping, Lineage, Metadata Management, Data Dictionary Cloud Platforms

AWS (SageMaker, S3), Azure (Fundamentals), Google Cloud (Associate Cloud Engineer), AWS Data Environments Integration

Domain Expertise

Financial Crime (AML/KYC), Risk Adjustment, Regulatory Compliance (HIPAA, HEDIS, Stars), RCM, Operational Reporting, SLA Monitoring, Contact Center Performance Analytics Methodologies

Agile (Scrum/Kanban), SDLC, UAT Testing, Data Validation, Reconciliation, End-to-End Analytics Solution Delivery

WORK EXPERIENCE

State Street, USA Senior Data Analyst

June 2024 – Present

• Source-to-Target Mapping: Lead the mapping and reconciliation of disparate data sources into the Enterprise Data Warehouse (EDW), ensuring 100% accuracy in high-frequency financial reporting.

• Financial Compliance: Partner with the Compliance team to manage Financial Crime (AML/Fraud) data requirements, creating robust data lineage documents to satisfy regulatory audits.

• Vendor Data Management: Analyze and interpret complex vendor data dictionaries (Bloomberg, Refinitiv) to align external market data with internal proprietary systems.

• Reporting & Insights: Design and maintain interactive Power BI dashboards for Desk Heads, providing real-time visibility into usage trends and market data compliance.

• SQL Optimization: Wrote advanced T-SQL queries and stored procedures for data validation, reducing report generation time by 40%.

• Collaboration: Facilitate UAT (User Acceptance Testing) and data reconciliation sessions between data engineers and business stakeholders.

• Tableau Dashboard Development: Designed highly interactive Tableau dashboards for operational performance monitoring, enabling leadership teams to track service KPIs, operational metrics, and client SLA compliance.

• Operational Reporting Automation: Automated business-as-usual (BAU) reporting workflows using SQL and Python, reducing manual reporting effort and improving accuracy of operational analytics.

• Service Performance Analytics: Developed dashboards supporting operational performance metrics including service remediation insights, helping business teams identify operational inefficiencies and improve response times.

• Executive Data Storytelling: Delivered executive-ready visual dashboards with intuitive navigation and compelling storytelling to support data-driven strategic decisions.

• Cross-Team Collaboration: Partnered with data engineering teams to improve data pipelines and create scalable datasets enabling self-service analytics and automated reporting capabilities. DXC Technology, India Data Analyst (Healthcare & Financial Projects) June 2020 – July 2022

• Automated ETL Pipelines: Developed automated data ingestion workflows using Python and Informatica, reducing manual processing effort by 50% and improving data reliability.

• Data Governance: Established a standardized Data Quality Framework that identified and corrected data anomalies, improving reporting integrity by 35%.

• Predictive Analytics: Built a patient risk-stratification model using Python, helping healthcare clients identify high- utilizer cohorts and improving care outcomes by 20%.

• Stakeholder Management: Translated complex technical specifications into clear business insights for non-technical leadership, supporting data-driven strategic planning.

• Environment Migration: Supported the migration of legacy on-premise data to AWS Redshift, ensuring seamless transition and zero data loss during the ETL load.

• Advanced Tableau Reporting: Developed Tableau dashboards to monitor operational KPIs and SLA metrics, enabling business teams to track performance and identify service improvement opportunities.

• Automation & Analytics: Leveraged Python for automation of data transformation and analytics workflows, improving efficiency of recurring operational reports.

• Operational Insights: Delivered friction-reduction analytics by identifying repetitive service requests and operational bottlenecks using SQL and Tableau dashboards. KPIT, India Data Analyst

March 2019 – May 2020

• Ad-hoc Reporting: Handled high-priority analytical requests in a timely manner, providing rapid-response dashboards using Tableau.

• Market Research: Conducted data-driven market trend analysis for automotive clients, identifying growth opportunities in niche segments.

• Data Validation: Performed rigorous quality checks on large-scale datasets, ensuring consistency and reliability across multi-functional reporting modules.

• Dashboard Modernization: Supported the transition from legacy Excel-based reporting to Tableau dashboards, improving reporting efficiency and data accessibility for operational teams.

• Data Visualization: Designed visually compelling dashboards and reports to communicate complex data insights to senior stakeholders and business leaders.

EDUCATION & CERTIFICATIONS

Master of Science in Data Science

University of New Haven, CT

Dec 2024

Google: Associate Cloud Engineer

AWS: Certified Cloud Practitioner Academy Cloud Architecting Microsoft: Azure AI Fundamentals (AI-900) Azure Fundamentals (AZ-900) Azure Data Fundamentals (DP-900)

Contact this candidate