Shagana Subramani
Aurora,OH
Summary
Data Analyst with expertise in SQL and Tableau, adept at transforming complex datasets into actionable insights. Proven track record in enhancing data quality assurance and fostering stakeholder collaboration. Committed to driving informed decision-making and improving business outcomes through effective data visualization and analysis.
Overview
13
13
years of professional experience
Work History
Data Analyst
CITI BANK/DATAECONOMY INC.
Cleveland, USA
01.2025 - Current
- Led data validation and quality assurance efforts on the Enterprise Risk Data Layer (ERDL), ensuring 99.9% data accuracy across risk reporting pipelines.
- Collaborated with cross-functional teams (risk, compliance, and IT) to define business rules and map source-to-target transformations aligned with Citi’s risk data aggregation standards.
- Produced comprehensive dashboards and reports using tools like Tableau enabling senior risk managers to make timely, data-driven decisions.
- Contributed to regulatory reporting initiatives, including CCAR and Basel reporting, by ensuring integrity and traceability of data lineage within the ERDL framework.
Data Analyst
CITI BANK/DATAECONOMY INC
Cleveland, USA
08.2024 - 12.2024
- Extracted actionable insights and identified patterns through analysis of diverse datasets.
- Collaborated with stakeholders to gather business requirements and created detailed functional documentation.
- Conducted thorough analyses of ERDL data, highlighting significant trends for informed decision-making.
- Developed interactive dashboards in Tableau, enabling users to customize views for Top and Material risk evaluations.
- Identified and flagged data inconsistencies originating from upstream systems related to data quality.
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
Cleveland, USA
11.2023 - 07.2024
- Managed source-to-target mappings across systems, ensuring data transformation aligned with business objectives from Data Lake to EDP Hub and downstream platforms.
- Engaged with downstream application stakeholders to align business goals with data-driven strategies.
- Conducted impact analysis for EDP supplemental processes sourcing wholesale lite data to meet CECL and CCAR regulatory needs.
- Collaborated cross-functionally to document potential impacts of DB2-to-Snowflake conversion on source systems.
- Presented analytical findings and recommendations in a clear, accessible manner to business stakeholders.
- Participated in Agile sprints; gathered and refined functional requirements, supporting data validation through UAT and production cycles.
- Analyzed complex, multi-source datasets to uncover trends and actionable insights.
- Developed and executed test plans to verify system updates, identifying and resolving discrepancies to uphold data integrity.
- Led impact analysis on source systems including BCS Relay, TSYS, MDM, ORA, IM, ST, ODP, AFS, ALS, and MSP to ensure seamless integration and minimal disruption.
- Performed rigorous system testing and reconciliation to validate data accuracy across platforms.
- Utilized tools such as Snowflake, Access, DB2, and Data Lake to conduct data analysis and reporting.
- Performed data profiling and preparation, identifying gaps and qualifying data for DB2-to-Snowflake transition efforts.
- Contributed to daily stand-ups and sprint planning to ensure alignment and timely delivery of data solutions.
- Collaborated with the Data Governance team to submit DTR and DRD mapping documentation for various EDP source systems.
- Conducted advanced data analysis using Snowflake, Microsoft Access, DB2, and Data Lake environments.
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
Cleveland, USA
07.2022 - 08.2023
- Performed impact analysis on the BCS origination source system to support the transition from DataStage to Talend.
- Managed and updated source-to-target mappings for BCS systems as part of the DataStage-to-Talend migration.
- Conducted data analysis using a range of tools and platforms including PostgreSQL, Microsoft Access, DB2, and Data Lake environments.
- Executed comprehensive testing and reconciliation to validate data accuracy and consistency across integrated platforms.
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
Cleveland, USA
05.2021 - 06.2022
- Led essential data mapping initiatives within the Enterprise Data Platform, supporting applications and systems across the Citizens enterprise.
- Created and maintained source-to-target mappings, business rules, and data definitions to ensure seamless data integration.
- Extracted and interpreted data using Excel functions (VLOOKUP, XLOOKUP) to develop dashboards that transformed raw data into actionable insights for leadership.
- Applied SQL-based data profiling techniques to detect anomalies and collaborated with source teams to address data quality issues.
- Investigated and resolved data-related queries from UAT, QA, and Production environments on behalf of downstream stakeholders.
- Provided technical guidance to developers and testers to promote accurate understanding and implementation of mapping documentation.
- Coordinated with source systems, downstream consumers, technical teams, and SMEs to troubleshoot and resolve data mapping issues efficiently.
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
Cleveland, USA
02.2021 - 04.2021
- Analyzed deliverables required for RACOE submissions and collaborated with downstream consumers to ensure alignment and clarity.
- Participated in all phases of the data warehouse lifecycle, including analysis, design, development, testing, implementation, and maintenance.
- Led discussions around high-priority bank reporting, such as investor decks for IR submissions, leveraged lending summaries, and CRE quarterly updates.
- Reverse-engineered and created source-to-target mappings (STMs) to facilitate the Web focus migration from Cognos.
- Validated newly developed Web focus reports during the transition process to ensure reporting accuracy and completeness.
- Supported the identification, measurement, and monitoring of credit risk related to loan purchases and participations.
- Contributed to credit risk reporting and modeling by developing tools for risk identification, measurement, and management.
Loan Document Specialist
GENPACT LLC
Cleveland, USA
01.2021 - 02.2021
- Client: BANK OF AMERICA
- Performed a range of loan documentation tasks for moderately complex loan products, applying in-depth knowledge of applicable policies and procedures.
- Researched and analyzed account data across multiple account types to troubleshoot issues and ensure timely processing.
- Audited closed loan files to confirm documentation accuracy, including loan terms, payment schedules, interest rates, and other technical details; evaluated credit reports to assess creditworthiness.
- Monitored loan applications for compliance with federal, state, and investor guidelines and regulations.
- Reviewed loan modifications for completeness and accuracy against system records.
- Handled high-volume, time-sensitive documentation tasks, leveraging strong research and problem-solving skills to meet quality, compliance, and timeliness standards.
- Managed and tracked daily loan pipeline activities, performing maintenance tasks and coordinating with internal departments to address discrepancies, status updates, and data inquiries.
Assistant Manager/Data Analyst
City Union Bank Ltd.
Bangalore, India
10.2012 - 03.2016
- Company Overview: City Union Bank has 700+ branches throughout India.
- Assessed credit risk and processed 20-25 major credit proposals by analyzing balance sheets, computing debt-service coverage ratios (DSCR), break-even analysis, and sensitivity analysis to ensure loan viability to underwriters.
- Maintained accurate financial records and prepared clear and appropriate reports for audits and operational use.
- Collated and interpreted financial data to determine the financial performance of companies seeking loans, comparing various companies with industrial sectors, analyzing past deals and developing valuation to minimize risk.
- Performed complex financial analysis, monitored and evaluated market and customer trends, and identified potential business growth and opportunities to assist the loan eligibility decision-making process.
- Created customer and account-level monthly and quarterly reports to review account performance and analyze risk to identify potential non-performing assets (NPAs) that might burden the bank.
- Studied financials including balance sheets, income statements, schedule of investments, statement of changes in net assets, cash flow statements and financial highlights to improve financial forecasts.
- Remitted $1M+ in foreign currency for import advances and other expenses like travel, consultancy, advertising and exports.
- Managed non-fund-based products such as bank guarantees, letters of credit for international banking, safety deposit boxes and bill discounting to be er serve high-end customers.
- Ensured that no illegally obtained funds passed through the bank through RBI queries for import/export matters.
- Ensured regulatory compliance through effective participation in annual statutory RBI (Reserve Bank of India) and internal audits by following the Basel Regulatory Framework.
- Ensured superior policy and process adherence and implementation of compliance guidelines per regulatory procedures.
- City Union Bank has 700+ branches throughout India.
Education
MBA - Finance and Human Resources
Kumaraguru College of Technology
Coimbatore, India04.2012
Bachelor of Science - Computer Technology
Sri Ramakrishna Engineering College
Coimbatore, India05.2010
Skills
- Data visualization and analysis
- SQL querying and databases
- Data quality assurance and cleaning
- Dashboard development and reporting
- Business requirements gathering
- Data mapping and profiling
- Problem solving and troubleshooting
- Putty and Unix/Linux proficiency
- Tableau and Snowflake expertise
- Microsoft visio
- SAS
- Python
- Oracle and DB2 management
- AWS Redshift and Spectrum knowledge
- Access DB and SQL Server skills
Awards
- Received CREDO Award from Racoe team for contribution in Climate Risk Project
- Received momento/recognition from EDO for contribution in ISBC Project
Certifications Trainings
- Salesforce certified Tableau Desktop Foundations
- Udemy - SQL for Beginners, 05/01/20
- JAIIB (Junior Associate of Indian Institute of Bankers) certified by Indian Institute of Banking and Finance, 02/01/14
Timeline
Data Analyst
CITI BANK/DATAECONOMY INC.
01.2025 - Current
Data Analyst
CITI BANK/DATAECONOMY INC
08.2024 - 12.2024
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
11.2023 - 07.2024
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
07.2022 - 08.2023
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
05.2021 - 06.2022
Data Analyst
CITIZENS BANK/DATAECONOMY INC.
02.2021 - 04.2021
Loan Document Specialist
GENPACT LLC
01.2021 - 02.2021
Assistant Manager/Data Analyst
City Union Bank Ltd.
10.2012 - 03.2016
MBA - Finance and Human Resources
Kumaraguru College of Technology
Bachelor of Science - Computer Technology
Sri Ramakrishna Engineering College
Similar Profiles
Senthilkumar SSenthilkumar S
Service Delivery Manager at Citi Bank USA, The Citi BankService Delivery Manager at Citi Bank USA, The Citi Bank
null null
Service Delivery Manager at Citi Bank USA, The Citi BankService Delivery Manager at Citi Bank USA, The Citi Bank
ANKITA PUROHITANKITA PUROHIT
Assistant Manager AML KYC at CITI Corp Services India Pvt Ltd-CITI BankAssistant Manager AML KYC at CITI Corp Services India Pvt Ltd-CITI Bank
Jessica RheaJessica Rhea
Senior Claims Director (New Jersey) at NASenior Claims Director (New Jersey) at NA
Christopher ScottChristopher Scott
Sterile Processing Technician at Cleveland ClinicSterile Processing Technician at Cleveland Clinic