Data Analyst Analysis

RUMA PAL

412-***-**** ******.***@*****.***

PROFESSIONAL SUMMARY

Detail-oriented Data Analyst with 6 years of IT experience, specializing in SQL development, data analysis, reporting, and ETL processes. Strong background in Oracle PL/SQL, data warehousing, and performance optimization. Adept at translating business requirements into actionable insights using SQL and data visualization tools like Tableau. Experienced in working with cross-functional teams in Agile and Waterfall environments to deliver accurate, timely data solutions and support decision-making processes.

TECHNICAL SKILLS

Data Analysis & Reporting: SQL, PL/SQL, Oracle Reports, Tableau

ETL & Data Integration: Informatica PowerCenter, SQL Loader

Databases: Oracle 12c/11g/10g, TOAD, SQL Navigator, OEM

Scripting & Automation: Unix Shell Scripting, Perl

Version Control: Git, TFS, SVN

Tools: WinSCP, MS Excel, SQL*Plus

Methodologies: Agile, Waterfall, Snowflake

Web Technologies: HTML, JavaScript (basic exposure)

PROFESSIONAL EXPERIENCE

State Street, MA

Data Analyst / Sr. PL/SQL Developer

Jan 2024 – Present

Analyzed large financial datasets to generate performance and risk metrics for institutional clients.

Developed PL/SQL scripts and queries to extract and summarize key business insights.

Participated in cross-functional data validation and impact analysis.

Improved performance of existing reports by optimizing SQL logic and joins.

Giant Eagle, Pittsburgh, PA

PL/SQL Developer / Data Analyst

Oct 2020 – Dec 2023

Collaborated with business analysts to understand pricing data models and developed scripts for data reconciliation and variance analysis.

Created and modified SQL-based reports for Retail Pricing and Inventory data using Oracle Reports and Document Direct.

Automated recurring data loads and transformations using shell scripting and Autosys job scheduler.

CareFirst Blue Cross Blue Shield, MD

Oracle Developer / Data Analyst

Apr 2019 – Sep 2020

Extracted and analyzed healthcare claims data to support provider performance tracking.

Created and maintained dashboards using SQL and internal BI tools for utilization trends.

Addressed data quality issues and improved accuracy of analytical outputs through normalization and data cleaning techniques.

Fidelity Investments, Durham, NC

PL/SQL Developer / Junior Data Analyst

Sep 2018 – Mar 2019

Worked on financial report generation and data extraction for wealth management operations.

Converted and optimized legacy Sybase queries into Oracle-based systems for smoother reporting.

Involved in data migration, cleansing, and trend analysis tasks supporting product teams.

EDUCATION

Bachelor of Engineering (B.E.) in Computer Science & Engineering

Biju Patnaik University of Technology

CERTIFICATIONS

Oracle Certified Associate (OCA) – Oracle 9i PL/SQL

PL/SQL Programming – Certified by SQL Star International

ADDITIONAL SKILLS & STRENGTHS

Strong problem-solving and analytical skills

Effective communicator with cross-functional teams

Experienced in working with structured and semi-structured data sources

Excellent time management and attention to detail

Contact this candidate