Smita Sahu

Wells Fargo – Senior Analytics Consultant – Customer Remediation Analytics, 2023 – Present.

• Conduct in-depth analysis to identify customer populations impacted by system or operational failures using SAS and complex SQL queries.
• Identify affected populations, evaluate financial and credit bureau impacts, and propose appropriate remediation strategies in alignment with regulatory and compliance standards.
• Delivered data-driven insights to support risk mitigation and customer restitution strategies.
• Develop, optimize, and maintain SQL queries for data extraction, transformation, and reporting purposes.
• Collaborate with stakeholders across business, risk, and technology teams to understand data requirements, and deliver tailored data solutions.
• Ensure data integrity, security, and adherence to enterprise data governance, and regulatory compliance policies.

Tata Consultancy Services (TCS) – Senior SAS Analyst – Italy-based Banking Client, UniCredit, 2022 – 2023.
Led the offshore SAS development team, managed code reviews, and enforced quality coding standards.
Maintained project documentation, process notes, and standard operating procedures (SOPs).
Handled ad hoc analysis and reporting via SAS EG and SAS DI; supported DR testing, and resolved server-related issues.
Used JIRA to manage Agile sprint activities and team progress tracking.

TCS – SAS Analyst – Citibank, 2019 – 2022.
Developed automated ETL processes using SAS/BASE, MACROS, and SQL to support daily, weekly, and monthly business reporting.
Liaised with business stakeholders to gather requirements and provide analytical insights.
Acted as Scrum lead, managing the product backlog and sprint planning with cross-functional teams.
Validated reports and datasets to ensure accuracy and compliance.

TCS – QA Analyst – Citibank, 2014 – 2019.
Interpreted BRDs, FRDs, and process documents to define development strategies.
Executed test plans, defect tracking, and reporting using HP ALM QC.
Facilitated agile transformation, combining waterfall and Agile best practices.
Ensured data governance and compliance with organizational standards.
Delivered progress reports using burn-down charts, acceptance rates, and defect metrics.