Back to Developers
Deepa SN

Deepa SN

Data Analyst

Chennai, India 9+ yrs exp 90 · Outstanding

About

Results-driven Data professional with 9 years of experience spanning the banking and public sector domains — including 6 years as a Data Analyst in the public sector and 3 years in banking operations. Strong hands-on expertise in SQL and Python, building ETL workflows, automating data validation, and optimizing complex queries across large, high-volume datasets. Skilled at translating business requirements into efficient data structures, with a solid foundation in data modeling (Star/Snowflake schema) and Power BI reporting. Proven track record of reducing manual processing effort and improving report delivery speed through SQL and Python-based automation, with strong stakeholder collaboration and communication skills.

Skills & Expertise (24)

Pandas Advanced
8.5/10
5
Years Exp
NumPy Advanced
8.5/10
5
Years Exp
SQL Advanced
8.5/10
9
Years Exp
Python Advanced
8.5/10
5
Years Exp
Excel Advanced
8.0/10
9
Years Exp
ETL Pipelines Advanced
8.0/10
5
Years Exp
Data Validation Advanced
8.0/10
5
Years Exp
Data Warehousing concepts Advanced
8.0/10
5
Years Exp
Power BI Advanced
8.0/10
5
Years Exp
Dimensional Modeling Advanced
7.5/10
5
Years Exp
Tableau Advanced
7.5/10
5
Years Exp
Power Query Advanced
7.5/10
5
Years Exp
DAX Advanced
7.5/10
5
Years Exp
Snowflake Schema Advanced
7.5/10
5
Years Exp
Star Schema Advanced
7.5/10
5
Years Exp
Databricks Intermediate
7.0/10
2
Years Exp
Apache Spark Intermediate
7.0/10
2
Years Exp
GitHub Intermediate
6.0/10
3
Years Exp
Matplotlib Intermediate
6.0/10
2
Years Exp
Streamlit Intermediate
5.5/10
1
Years Exp
Normalization MySql Oracle PySpark

Work Experience

Data Analyst / BI Developer

Chennai Metro Water

Mar 2019 - May 2025

Extracted and analyzed data from Oracle databases using SQL to support business reporting and operational analysis. Developed ETL workflows using SQL and Python for data extraction, transformation, and loading, reducing manual data processing effort by 30%. Built and optimized complex SQL queries and data models, improving report delivery speed by 35%. Used Python (Pandas, NumPy) for data cleansing, validation, reconciliation, and quality checks to ensure data integrity and consistency across datasets. Designed and maintained Star Schema and Snowflake Schema data models to support reporting, analytics, and downstream BI consumption. Applied dimensional modeling and normalization principles to structure customer, billing, payment, and operational datasets for consistency and reuse. Collaborated with business users, stakeholders, and ETL developers to gather requirements and translate them into efficient, scalable data structures. Documented data definitions, relationships, and business rules to support ongoing reference and governance. Designed and developed Power BI dashboards and reports to monitor key operational and performance metrics for business stakeholders. Supported data governance and quality initiatives through validation frameworks and business rule implementation.

Operations Officer - Trade Settlement & Data Reconciliation

Standard Chartered Global Business Services

Jan 2011 - Feb 2014

Managed trade settlement operations for financial transactions, ensuring timely and accurate processing in accordance with banking regulations and operational procedures. Performed transaction reconciliation across multiple banking systems to identify and resolve settlement discrepancies. Conducted data validation and quality checks to ensure the accuracy, completeness, and integrity of financial transaction records. Investigated and resolved trade breaks, settlement exceptions, and data mismatches in collaboration with internal teams and counterparties. Generated operational reports, reconciliation summaries, and performance metrics using Excel and SQL-based reporting tools. Monitored settlement activities and ensured compliance with internal controls, regulatory requirements, and service-level agreements (SLAs). Collaborated with cross-functional teams including Operations, Finance, Risk, and Compliance to streamline processes and improve operational efficiency. Supported process improvement initiatives that reduced reconciliation exceptions and enhanced settlement accuracy by 100%. Maintained high standards of data integrity and operational risk management through effective reconciliation and control procedures.

Education

MBA - HR & Marketing - Anna University

- · Afghanistan

B.Sc. Mathematics - Bharathidasan University

- · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
✅ Verified 5/5
Total Score 90/100

Profile Overview

Member sinceOct 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Depends on Offer