Srinadh Neelam

Client Name: Wells Fargo India Solutions
Project Name: Enterprise Data Warehouse - Consumer Lending Credit Cards (EDW CLCR)

Project Description: To Design and architect a scalable, cloud-native enterprise data warehouse consolidating consumer lending and credit card data from multiple source systems.

Roles & Responsibilities:Architected end-to-end Snowflake data warehouse design with multi-layer schemas (Raw, Staging, Analytics) supporting scalable compute-storage separation

• Defined Snowflake governance policies including role-based access control, resource management, warehouse scaling strategies, and disaster recovery procedures
• Collaborated with developers and AWS engineers to integrate data transformation and ETL pipelines, implementing automated data quality testing and validation frameworks
• Led data modeling workshops with business stakeholders and technical teams to establish best practices, documentation standards, and performance optimization strategies
• Defined Data architectural roadmaps during cloud migrations from native Teradata on premise.

Tech Stack Used in the Project:
Snowflake (Multi-cluster warehouses, Time-Travel, Zero-copy cloning)& Teradata,AWS,Snow Flake Dbt (data build tool), SQL,AWS S3 , Apache Airflow, Power BI,GitHub/GitLab with CI/CD pipelines

Client Name: Wells Fargo India Solutions
Project Name: Enterprise Data Lake - Traded Products Domain
Project Description:

-To Design and architect a scalable, enterprise data lake consolidating Traded Products for investment banking data.

Roles and Responsibilities:
-Directed engineering teams to design and implement enterprise-scale data lake and warehouse solutions for traded products.
-Defined architectural roadmaps and enforced engineering standards across teams.
-Mentored engineers while facilitating agile ceremonies.
Delivered scalable data pipelines, reducing processing time by thirty percent.
-Conducted impact analysis ensuring seamless integration of upstream and downstream systems.
-Served as business liaison between technology and product teams to enhance collaboration.
-Managed database solutions for stock loan operations, improving data lake transformations.
Tech Stack Used in the Project:
Teradata, SQL,Python,Power Designer,Erwin DI

• Client Name: Wells Fargo India Solutions
  Project Name:EDW-Prime Brokerage and Margin Systems
  Project Description: Data warehouse platform facilitates master data for prime brokerage and Margin executions.
  Roles and Responcibilities:
  Designed and developed normalized and dimensional data models (Star Schema, Snowflake Schema) for margin and collateral data and performed master data management for securities financed transactions.
  - Created comprehensive ERD (Entity Relationship Diagrams) and data lineage documentation mapping source systems to fact and dimension tables
  - Established data governance framework defining data ownership, metadata standards, data classification, and lineage tracking across all layers of the warehouse
  - Implemented slowly changing dimensions (SCD Type 1, 2, 3) and fact table designs supporting incremental loads and historical data retention policies
  - Collaborated with business analysts to translate business requirements into logical and physical data models with proper indexing and partitioning strategies
  -Conducted data profiling, quality assessment, and root cause analysis identifying data inconsistencies and implementing validation rules within dbt tests and SQL checks
  -Designed and built analytical data marts and cubes enabling self-service analytics for business stakeholders with performance metrics and drill-down capabilities
  - Created data quality dashboards and monitoring frameworks tracking completeness, accuracy, and timeliness metrics with automated alerts for anomalies
  - Performed exploratory data analysis (EDA) and statistical analysis supporting regulatory compliance reporting (CCAR, DFAST) and risk management analytics
  Tech Stack Used in the Project: Data Model techniques,SQl,Power Designer

• Collaborated with JPMorgan Chase Bank to design and develop test automation suites using QTP and VB scripting, improving testing efficiency.
• Developed design specifications from functional requirements for collateral module, aligning solutions with business needs.
• Executed implementation and unit testing for title search module, enhancing system reliability and user experience.

• Acted as client representative for Nation Wide Insurance.
• Designed test cases for applications affected by the release.
• Executed functional and regression testing.
• Implementation, Unit Testing of Title Search module.
• Developed test plans, executed scripts, and managed QC/ALM life cycles for efficient test management.