Ashwini Wathare
Summary
- With over 18 years of experience in the Banking, Retail, and Healthcare domains, I specialize in Data Warehousing and Enterprise Data Management, overseeing the full lifecycle of data management—from business requirements gathering to production support. I have a strong track record in data analysis, data profiling, and data quality, including writing complex SQL queries and debugging stored procedures to ensure data integrity across enterprise datasets.
I have led Enterprise Data Management initiatives involving data lineage, metadata management, and the creation of ETL data mapping and data transformation documents. My technical expertise includes proficiency in Ab Initio, Informatica PowerCenter, and Data Quality (IDQ) for ETL processes, alongside experience in analytics and reporting tools such as Tableau, Cognos 8, and Power BI.
I have solid experience in documentation and process excellence, authoring BRDs, FSDs, technical documentation, and creating UML diagrams for business process modeling. Additionally, I am proficient in Python for scripting and data manipulation. My communication skills, combined with expertise in SDLC and Agile/Scrum methodologies, ensure effective stakeholder collaboration and project success.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Senior Technical Data Analyst
Randstad Technologies, LLC [Wells Fargo]
02.2025 - 02.2026
- Involved into Commercial Banking and Lending Data Quality team, designing, executing, and monitoring data quality checks across critical datasets.
- Analyzed complex data sets to identify trends and support decision-making processes.
- Managed end-to-end data quality lifecycle: defined/implemented DQ rules, published observations, identified errors, investigated root causes, reviewed with ABO, enhanced rules, confirmed resolutions, implemented fixes, and documented findings.
- Gained domain expertise in Wholesale Credit Data Information, Regulatory Reporting, Corporate & Industrial loans, and Commercial Real Estate data, iHub data, LoanIQ, Wholesale Customer Data.
- Communicated data quality observations to ABO stakeholders via interactive DQ Dashboard and standardized Excel observation packages, enabling timely remediation and transparency into data trends.
- Validated and involved into data analysis of data quality rules using Oracle, Teradata SQL, and Microsoft SQL Server to ensure accurate, complete, and consistent data for reporting and downstream applications.
- Ensured accurate physical data elements were identified, mapped, and implemented for FR Y-14Q schedules to mitigate regulatory reporting and data quality risks across critical portfolios.
- Designed and implemented data quality rules in Ab Initio (Express>It) and Alteryx to detect validity, completeness, consistency, and uniqueness issues, enabling proactive data quality observations.
- Debugged Teradata stored procedures to trace data updates, identify root causes of discrepancies, and validate data quality rule effectiveness across source systems.
- Analyzed data from multiple source systems, leveraging lineage and metadata to recommend rule enhancements, identify false positive root causes (e.g., system errors, timing issues, transformation logic, manual entry), and created User Stories in JIRA/Intake tool for enhancements.
- Performed data profiling of source systems and created data quality rules aligned with business and regulatory requirements.
- Conducted User Acceptance Testing (UAT) for multiple functional areas across applications and platforms (files, Oracle, etc.).
- Analyzed complex data sets to identify trends and support decision-making processes.
- Developed and maintained interactive dashboards using Tableau for real-time data visualization.
Senior Technical Data Analyst
Mitchell Martin [Bank Of America]
03.2024 - 01.2025
- Involved into Treasury Risk and Forecasting Data Management team, acting as liaison between upstream data teams, Technology, and Corporate Treasury to enhance reporting, forecasting, and analytics capabilities.
- Implemented data transformation logic in Data Connect, a web-based no-code visual development platform enabling non-technical users to automate business processes and integrate upstream systems.
- Utilized Data Connect for modularized data ingestion, quality checks, business rules, workflows, scheduling, and calculations, delivering end-to-end solutions from data sourcing to reporting and analytics.
- Supported data enrichment, transformation, and process automation across diverse applications.
- Configured and monitored Data Quality rules (string/date patterns, custom SQL, uniqueness) and feed-level metrics (record counts, averages) using Data Connect.
- Integrated multiple upstream/downstream systems including email (file/FTP/HTML), API sources, and JDBC connections.
- Gathered user requirements, proactively proposed features/enhancements, created User Stories in JIRA, and prioritized with Product Owner and Scrum Team.
- Collaborated with QA team on testing Data Connect scenarios via JIRA User Stories.
- Designed business processes in Data Connect, implementing data flows, plugins, enriches (DDL/DML), complex SQL with window functions (moving sums/averages), joins, filters, calculations, flow/global variables, DATE functions, and regular expressions.
- Developed Test Plans and Test Cases for Data Connect by analyzing use cases.
- Configured job scheduling (time-based, feed/file-triggered) and monitored execution tracking.
- Conducted User Acceptance Testing (UAT) across multiple functional areas and platforms (files, Oracle, etc.).
Senior Technical Data Analyst
Randstad Technologies, LLC [Wells Fargo]
02.2022 - 01.2024
- Involved into Wholesale Credit Data System application managing financial, non-financial, and transaction data for customers.
- Worked with Loan Accounting Systems of Record (SORs) including LoanIQ, AFS, Strategy, and data provisioning/reporting platforms such as iHub, WCDIR, TPD, CAR, and eONE.
- Analyzed FR Y-14Q Credit Risk reporting data focusing on Obligor, Obligation, and Facility-level details.
- Developed complex Teradata SQL queries from Stored Procedures (joins, filters for data quality rules) using Oracle Toad.
- Conducted gap analysis in Oracle Toad comparing complex Teradata SQL results against data loaded by Relationship Managers in Loan Validator Tool (LVT).
- Performed data profiling, validation rules, inconsistency checks, and comprehensive data quality assessments.
- Created data mapping and lineage documentation; reviewed mappings for consistency across datasets and stored procedures.
- Executed unit testing at transaction level, comparing key reporting attributes to source documents.
- Conducted unit testing to identify gaps, implement data fixes, perform root cause analysis for defects, and log issues in JIRA.
- Analyzed data patterns, frequencies, and relationships between assets to support defect remediation.
Senior Technical Data Analyst
Info Services [First Hawaiian Bank]
05.2021 - 01.2022
- Worked on the Velocity Intelligent System application, managing financial, non-financial, and transactional data for customers.
- Developed data mappings and ETL transformation logic for data standardization, validation, and cleansing, applying data quality rules in SQL Developer.
- Implemented source-to-target transformation logic, identified data mismatches, and performed complex SQL queries for validation across various systems.
- Collaborated with developers on Informatica mappings, conducted unit testing, and provided root cause analysis for defect remediation in JIRA.
- Created functional specification documents, data lineage mappings, and business requirement documentation (BRD) for data quality controls and technical design.
Senior Technical Data Analyst
Randstad Technologies LLC [Wells Fargo]
08.2019 - 02.2021
- Developed data management strategies for lineage/metadata, data controls, and defect/issue tracking in an enterprise environment.
- Involved in data analysis, profiling, governance, and designing data quality rules for implementation, monitoring, and reporting using Ab Initio Express IT.
- Coordinated with business partners to capture requirements, implemented rules on core data elements, and performed root cause analysis for defect remediation.
- Worked on data lineage mapping, created transformation rules, and managed data quality dimensions (completeness, accuracy, consistency, uniqueness) in Ab Initio.
- Utilized Collibra Data Dictionary for data lineage, imported datasets, and used JIRA for agile methodologies to manage user stories and issue tracking.
Senior Technical Data Analyst
Systechcorp Inc [Lowes]
08.2017 - 07.2019
- Managed and updated Customer Master Data for enterprise operations, reporting, and analytics, implementing data quality monitoring, mapping, and validation.
- Developed complex SQL queries for relational databases (Teradata, DB2), used Alteryx for ETL, and optimized data flow processes for analysis and reporting.
- Suggested and implemented changes to data models at all levels (conceptual, logical, physical) for relational and dimensional solutions, ensuring high data integrity.
- Created data flow diagrams, normalized data models, and performed data validation, cleansing, and analysis to ensure consistency across multiple systems.
- Developed dashboards in Excel, performed SQL performance tuning, and worked with Information Analyzer for column, primary, and foreign key analysis.
Business Systems Consultant
Advantage Technical Resourcing [Wells Fargo]
01.2014 - 05.2015
- Acted as a Compliance consultant, working with Global Sanction scanning groups to analyze complex business problems and develop automated solutions.
- Provided technical expertise to evaluate and develop cost-effective systems and procedures, while applying industry trends to drive organizational change.
- Defined, developed, and implemented data models to deliver actionable insights and self-service analytics using PowerBI, including Power Pivot, Power View, and Power Desktop.
- Collaborated with project managers, business users, and technical teams to create functional and business requirement documents (FSD & BRD), while ensuring compliance with Sanctions rules.
- Supported Unit Testing and System Integration Testing (SIT), using Teradata Fastexport for data analysis and ensuring alignment with business and technical specifications.
Computer Programmer Analyst
Odyssey Information Service [Bank Of America]
11.2012 - 12.2013
- Worked on the Enterprise Data Management (EDM) project with the Anti-Money Laundering (AML) group, focusing on data standards, policies, and metadata creation.
- Analyzed and validated data in Teradata, verifying KBE definitions and creating Data Lineage and Transformation Logic documents using BTEQ, SAS, and XML files.
- Collaborated with business users and technical staff to create metadata and process flow diagrams, ensuring proper data movement and transformation across systems.
- Translated business requirements into conceptual and logical data models using Sybase Power Designer and developed SQL queries for data profiling in Teradata and Oracle.
- Conducted UAT, reviewed data quality rules, and facilitated business and IT SME review meetings to ensure alignment with business goals.
Senior Technical Consultant
Cap Gemini India Pvt Ltd India
08.2011 - 03.2012
- Analyzed business requirements with users and translated them into technical specifications, creating BRD, mapping documents, and data quality reports.
- Worked on Teradata FSLDM for Credit Risk data, developing BTEQ and FASTEXPORT scripts to load data and generate files for upstream systems.
- Used Informatica Data Quality (IDQ) for data cleansing, ensuring accuracy, consistency, and integrity before loading into the data warehouse.
- Developed test plans, test cases, and SQL scripts to validate ETL data transformations and created reports using Access, Excel, and PowerPoint for presentations.
- Provided training and knowledge transfer on Teradata, and collaborated with business users to make changes to reports based on feedback.
Senior Technical Consultant
Teradata India Pvt Ltd India
04.2006 - 07.2011
- Led a team to analyze business requirements, translating them into technical specifications, and developed key documents such as BRD, mapping, and data quality reports.
- Developed and optimized Teradata BTEQ and FASTEXPORT scripts for efficient data loading, and created complex SQL queries and shell scripts for data transformation.
- Worked with IBM InfoSphere DataStage to build and manage ETL jobs, loading data from flat files to Teradata, and used QualityStage for data profiling and cleansing.
- Conducted performance tuning of SQL queries, including explain plans and indexing, and ensured data consistency, accuracy, and integrity during the ETL process.
- Developed test plans, test cases, and SQL scripts to validate ETL transformations and ensure proper data controls before loading into the data warehouse.
Education
Bachelor of Engineering - Electronics and Telecommunication
Mumbai University
India06-2004
Skills
- Skills & Expertise
Databases:
Teradata, Oracle, SQL Server, DB2, MS Access
Advanced query writing, data extraction, and performance tuning for large datasets
ETL/ELT Tools:
Ab Initio (Express IT, Enterprise Metadata Hub), Informatica PowerCenter, IBM DataStage, Alteryx, SQL Developer, Oracle Toad, Oracle Data Integrator (Sunopsis V4), Data Connect
Data Analytics & Mining:
Data Analysis, Data Profiling, Data Validation, Data Quality, Data Cleaning, Metadata Management
Proficient in applying statistical methods for data analysis and quality assurance
Teradata Tools & Utilities:
Teradata Visual Studio, Teradata SQL Assistance 13, SQL Developer
Deep experience in Teradata-specific optimization, data profiling, and query management
Programming:
Python
Experienced with core Python concepts including functions, loops, and conditionals, along with data handling using Pandas
BI/Reporting Tools:
Cognos 8-Report Studio, MS Excel, MS PowerPoint, Tableau
Designed interactive dashboards, reporting solutions, and data visualizations to drive business decisions
Agile Methodologies:
Scrum, JIRA, Confluence
Data Flow Diagramming:
Microsoft Visio 2010, Erwin
Created data flow diagrams, process models, and ER diagrams for effective communication of system design
Advanced Excel:
Pivot Tables, VLOOKUP, Macros, Data Models
Business Skills:
SDLC, Scrum/Agile Development Methodologies, Requirement Gathering, Process Documentation, Compliance Data
Certification
- Teradata Certified Master V2R5
- Oracle Certified Associate 9i - Oracle Database Administrator
Timeline
Senior Technical Data Analyst
Randstad Technologies, LLC [Wells Fargo]
02.2025 - 02.2026
Senior Technical Data Analyst
Mitchell Martin [Bank Of America]
03.2024 - 01.2025
Senior Technical Data Analyst
Randstad Technologies, LLC [Wells Fargo]
02.2022 - 01.2024
Senior Technical Data Analyst
Info Services [First Hawaiian Bank]
05.2021 - 01.2022
Senior Technical Data Analyst
Randstad Technologies LLC [Wells Fargo]
08.2019 - 02.2021
Senior Technical Data Analyst
Systechcorp Inc [Lowes]
08.2017 - 07.2019
Business Systems Consultant
Advantage Technical Resourcing [Wells Fargo]
01.2014 - 05.2015
Computer Programmer Analyst
Odyssey Information Service [Bank Of America]
11.2012 - 12.2013
Senior Technical Consultant
Cap Gemini India Pvt Ltd India
08.2011 - 03.2012
Senior Technical Consultant
Teradata India Pvt Ltd India
04.2006 - 07.2011
Bachelor of Engineering - Electronics and Telecommunication
Mumbai University