Open to opportunities

Dhruba Joshi

@dhrubajoshi

Message

Senior SAS programmer and data analyst specializing in data validation, SAS automation, and banking analytics.

Nepal

Message

What I'm looking for

I’m looking for a SAS-focused analytics role where I can own data validation, data quality, and reporting—using SAS automation and pass-through SQL—while collaborating with banking stakeholders to ensure reliable results in production pipelines.

I’m a Certified SAS Specialist and senior SAS programmer/data analyst combining SAS data manipulation, data gathering, exploratory data analysis, and data management—especially in Banking and Financial sectors.

Across my roles, I’ve built and modified SAS programs using “SAS Data step,” “SAS Proc step,” “SAS Macros,” and “proc SQL,” with strong focus on “pass-through sql code,” “libname” connectivity, and advanced data manipulation that improves runtime and ensures consistent results.

I’m trusted for data quality and validation work: I develop validation logic aligned to BRD, run “data profiling” and DQ checks (including type/length/valid & invalid values), and produce reporting outputs using “SAS/ODS” and “SAS/Export” for stakeholder review. I’ve supported end-to-end model-related workflows including CECL (PD, EAD, LGD), “RFW,” “MIP,” and model validation before and after production.

I also bring production and operational strength—SAS debugging with precise log-based troubleshooting, automation with “CA Automation” and “AutoSys,” and administrative responsibilities for SAS ECL systems (project creation, user provisioning, key process execution). I’ve delivered run books and UAT scenarios/cases, and partnered across teams to resolve data discrepancies and strengthen analytics pipelines.

Experience

Work history, roles, and key accomplishments

Sr. Lead Data Analytics

Wells Fargo Bank

Sep 2023 - Mar 2025 (1 year 6 months)

Developed SAS pass-through validation and LIBNAME-based database connections (Oracle, Teradata) to update master and result tables from intermediate datasets using business flagging logic. Built SAS macro-driven data validation between monthly snapshots and history tables, including data profiling and discrepancy detection aligned to BRD requirements.

SAS Data Step SAS MACRO Pass Through SQL LIBNAME Data Validation Oracle Teradata SAS ODS Reporting

Sr. SAS Programmer / Data Analytics

U.S. Bank

Sep 2022 - Aug 2023 (11 months)

Supported end-to-end FCDM daily processing from pre-stage to core2 by monitoring CA Automation/AutoSys, producing runbooks, and troubleshooting SAS log errors to resolve production issues. Developed SAS macro programs for operational record-count checks, data distribution and stage-to-core mapping, and implemented shell-script-aligned workflows for exports and error analysis.

SAS SAS MACRO SAS ODS CA Automation Autosys Shell Scripting Pass Through SQL Teradata

Sr. Lead Data Analytics

Wells Fargo Bank

Mar 2021 - Aug 2022 (1 year 5 months)

Reviewed BRDs, extracted data from multiple sources (Oracle DW, Teradata, ECAR, Brickyard, Excel), and executed sanity/Data Quality checks in SAS against reporting requirements. Authored validation reports and pass-through/libname-based SAS validation code to reconcile intermediate-to-master updates and validate SHRP/legacy control reports.

Pass Through SQL LIBNAME Data Quality Data Validation Oracle Teradata SAS Jira

Sr. SAS Programmer / SAS Analyst

Salliemae Financial System

Aug 2019 - Feb 2021 (1 year 6 months)

Used BASE SAS processes for CECL-related PD/EAD/LGD data quality checks, reconciling data issues and documenting DQ and business rules to support model inputs. Developed automation for monthly and MIP-vs-Base SAS comparisons, including RFW execution and workflow/runbooks for SAS Model Implementation Platform (MIP) and SAS ECL administration tasks.

Base SAS Data Quality Rules Development LGD CECL Model Validation Unix

Sr. SAS Programmer

PNC Bank

Dec 2016 - Aug 2019 (2 years 8 months)

Developed and maintained SAS macro-driven data processing in OMDM, including dataset merges, indexing, aggregation, view modifications, and production support for data issues. Built Python/Jupyter analyses for data quality, joining, exporting, and regression modeling, and created UAT scenarios and test cases to validate reporting/analytical needs.

SAS MACRO SAS Enterprise Guide Production Support Data Preparation Python Jupyter Regression Modeling UAT Testing