Looking for a job

Dorthy Sudha

@dorthysudha

Data Analyst at Fidelity Investments who developed Power BI dashboards and Excel KPI reports for portfolio performance, risk, and data quality.

India

Message

At Fidelity Investments, I wrote complex SQL queries and developed Power BI dashboards and Excel KPI reports covering portfolio performance, risk indicators, and data quality. I also validated financial data for portfolio risk reporting and data quality audits.

My analytics projects include Power BI dashboards for healthcare, airline routes, and logistics, plus a Python loan approval prediction and credit risk analysis project. Before Fidelity, I administered Oracle databases at Technip India Limited and resolved technical and database issues at CSS Corp Pvt Ltd.

Experience

Work history, roles, and key accomplishments

Data Analyst / Oracle DBA

Fidelity Investments

Jun 2022 - Dec 2022 (6 months)

Wrote 50+ complex SQL queries weekly and performed data cleaning, transformation, and EDA to validate large-scale financial data sets. Developed Power BI dashboards and Excel KPI reports, and managed 30+ ServiceNow tickets monthly with 100% SLA adherence.

SQL CTEs Window Functions Join Aggregation Data Cleaning data transformation EDA Power BI DAX Excel KPI Reporting ServiceNow Oracle Oracle RMAN Dataguard ASM

Career Break

Family and Parental Leave

Feb 2016 - May 2022 (6 years 3 months)

Planned family career break; maintained SQL and database skills and returned to full-time work at Fidelity Investments in 2022, followed by 2 Data Science and Machine Learning certifications.

Oracle Database Administrator

Technip India Limited

Apr 2013 - Jan 2016 (2 years 9 months)

Administered Oracle databases for engineering projects for nearly 3 years, monitoring disk space and job logs via Oracle Enterprise Manager (OEM) and resizing tablespaces and data files to prevent unplanned downtime. Delivered schema changes and database refreshes for 2 non-production environments.

Oracle Oracle Enterprise Manager (OEM)Database Administration Tablespace Management Schema Evolution Database Refresh

Software Engineer

CSS Corp Pvt Ltd

Dec 2010 - May 2013 (2 years 5 months)

Resolved escalated technical and database issues for enterprise clients on Windows and Linux for 2.5 years, maintaining system stability and SLA commitments. Ran SQL-based data operations and routine database maintenance on 2 platforms.

SQL Database Maintenance Query Optimization Windows Linux Technical Support SLA Management