Data Analyst

PREETHAM PADALA

PA, USA 201-***-**** **************.****@*****.*** LinkedIn

SUMMARY

Data Analyst with 4 years of experience in financial services and enterprise analytics, specializing in SQL, Python, ETL pipelines, and cloud-based data solutions.

Skilled in designing dimensional data models, automated reporting dashboards, and scalable data pipelines, improving data accuracy, efficiency, and actionable insights for business stakeholders.

Experienced in data quality management, validation frameworks, and workflow optimization, reducing reporting errors by over 80% and accelerating report generation across multiple enterprise systems.

Proficient in BI tools, cloud platforms (AWS, Snowflake), and Python-based analytics, delivering interactive dashboards, KPI tracking, and insights that support data-driven decision-making.

SKILL SECTION

Programming & Query Languages

Python (Pandas, NumPy), SQL, Shell Scripting (Bash)

Databases & Warehousing

MySQL, PostgreSQL, Oracle, SQL Server, Snowflake, Amazon Redshift

ETL & Data Pipelines

Apache Airflow, AWS Glue, Informatica, Talend, SSIS

Data Modeling & Analytics

Dimensional Modeling (Star/Snowflake Schema), Fact & Dimension Tables, KPI Analysis

Data Visualization & Reporting

Tableau, Power BI, Excel (Advanced, VBA)

Data Quality & Governance

Great Expectations, Data Validation, Metadata Management, Logging & Monitoring

Cloud & DevOps

AWS (S3, Lambda, Redshift), Git/GitHub, Jenkins, Docker

WORK EXPERIENCE

Data Analyst Capital One, PA, USA Jun 2024 – Present

Developed end-to-end automated financial dashboards using SQL and Snowflake, reducing manual reporting efforts by 35%, while improving transparency of credit risk and portfolio performance metrics.

Built Python (Pandas, NumPy) scripts to clean, transform, and aggregate over 5 million+ customer transactional records monthly, ensuring consistent and accurate data for executive reporting.

Implemented AWS Lambda and S3 workflows to automate daily ingestion, transformation, and storage of high-volume banking datasets, reducing operational overhead and enabling faster analytics delivery.

Designed and delivered interactive Tableau dashboards for stakeholders, tracking KPIs such as loan delinquency, repayment trends, and portfolio exposure, improving actionable insights by 40%.

Created and validated dimensional data models with fact and dimension tables for various financial products, enabling scalable reporting, faster query execution, and standardized analytics across teams.

Integrated Great Expectations for automated data quality validation, reducing downstream reporting errors from 120+ weekly incidents to fewer than 15, significantly enhancing confidence in decision-making.

Collaborated with Risk, Finance, and Compliance teams to optimize SQL queries and ETL pipelines, improving report generation speed from 6 hours to 90 minutes, boosting operational efficiency.

Data Analyst Capgemini, India Jan 2021 – Apr 2023

Collected and cleaned transactional sales data from Oracle and MySQL databases using Python (Pandas, NumPy) and SQL, processing over 3 million+ records monthly for analytics purposes.

Designed dimensional data models (star and snowflake schemas) for revenue and sales KPIs, enabling faster query execution and 25% improved reporting efficiency across regions.

Built automated ETL pipelines using Informatica and Talend to extract, transform, and load sales data, reducing manual data preparation time by 30% for enterprise clients.

Developed interactive Tableau dashboards to monitor daily, weekly, and monthly revenue, highlighting trends, top-performing products, and underperforming regions with visual drill-down capabilities.

Performed advanced SQL analytics and Python-based aggregations to calculate revenue variance, growth rates, and regional sales trends, handling over 10 million+ transaction records annually.

Conducted data quality checks using Python scripts and validation rules, reducing reporting errors from 150+ incidents per month to under 20 incidents, enhancing stakeholder confidence in analytics.

Collaborated with client finance, sales, and operations teams to optimize SQL queries, ETL jobs, and workflow scheduling, improving report generation speed from 8 hours to 2.5 hours.

EDUCATION

Master of Science in Data Science Monroe University, New York, USA May 2023 – Apr 2025

Bachelor of Technology in Electronics and Communication Engineering JNTUH, Hyderabad, India Jun 2014 – Dec 2018

CERTIFICATION

Postgraduate Certificate in Data Science – International School of Engineering (INSOFE) Apr 2020 - Feb 2021

Contact this candidate