Looking for a job

SHILPEE PATTANAIK

@shilpeepattanaik

Data Analyst at HSBC, improving financial reporting accuracy by analyzing payment processing data in Excel.

At HSBC, I aggregate payment processing data from SharePoint, remove duplicates, and analyze it in Excel to improve financial reporting accuracy and efficiency.

I apply predefined business rules to categorize datasets and prepare daily and weekly reports that support operational decisions.

At COFORGE (Client: AOCC), I worked with flight, passenger flow, baggage handling, and weather data. I identified and fixed missing, duplicate, and inconsistent data, increasing data quality and reliability by 40%.

At COFORGE, I also used SQL, Excel, Tableau, and Python to analyze operational trends and investigate disruptions. My findings supported improvements in operational efficiency, and I documented data sources, transformations, and logic.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

HSBC

Nov 2025 - Present (10 months)

Optimized financial reporting by aggregating payment processing data from SharePoint, eliminating duplicates, and conducting in-depth analysis in Excel. Applied predefined business rules to categorize large datasets and generate accurate daily and weekly reports.

SQL Excel SharePoint Data Analysis Data Management Data Quality Reporting

Data Analyst

COFORGE

Sep 2022 - Sep 2023 (1 year)

Gathered data from various sources including flight data, passenger flow, baggage handling, and weather systems. Improved data quality and reliability by 40% and operational efficiency by 30% through root cause analysis and data standardization.

SQL Excel Tableau Python Data Extraction Data Cleaning Data Governance Data Visualization Root Cause Analysis

Data Analyst

AXISBANK

Nov 2021 - May 2022 (6 months)

Utilized Excel features to achieve data accuracy for customer account reporting. Created daily, weekly, and monthly analytics reports of product KPIs, maintaining report accuracy of 99% and securing a 95% project success rate.

Excel V Lookups HLOOKUP Pivot Tables Pivot Charts Sumifs COUNTIF Conditional Formatting Data Analysis Reporting

Education

Degrees, certifications, and relevant coursework

Institute of Technical Education and Research (ITER)

B.Tech/M.Tech, Electrical and Electronics Engineering

Pursued B.Tech/M.Tech in Electrical and Electronics Engineering from Institute of Technical Education and Research (ITER), S'O'A University, Bhubaneswar.