# Dhruba Joshi

Dhruba Joshi is a remote worker on Himalayas, Sr. Lead Data Analytics at Wells Fargo Bank, based in Nepal.

Source: https://himalayas.app/@dhrubajoshi

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

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Nepal |
| Authorized to work in | Nepal |
| Job categories | Software Engineer, Data Analyst, ETL Developer, Data Quality Analyst, Data Quality Engineer |
| Skills | Base SAS, SAS Data Step, SAS MACRO, PROC SQL, Pass Through SQL, LIBNAME Technique, SAS ODS, SAS Export, SAS Enterprise Guide, SAS DI Studio, SAS STAT And SAS ACCESS, Tableau, Informatica, ETL, Unix Commands, Linux, Windows, SQL, Pl SQL, Python, Jupyter Notebooks, Pandas, NumPy, Matplotlib, SeaBorn, scikit learn, Teradata, Oracle, Snowflake, Hadoop, Data Profiler, Data Quality, Autosys, CA Automation, Jira, Putty, Column, JSON, Java, Jupyter, Method, Numeric, SAS, XML |

## What I'm looking for

```text
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.
```

## About

```text
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

### Sr. Lead Data Analytics

[Wells Fargo Bank](https://himalayas.app/companies/wells-fargo). Sep 2023 - Mar 2025

```text
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.
```

Skills: SAS-Data-Step, SAS-MACRO, Pass-Through-SQL, LIBNAME, Data-Validation, Oracle, Teradata, SAS-ODS-Reporting

### Sr. SAS Programmer / Data Analytics

[U.S. Bank](https://himalayas.app/companies/u-s-bank). Sep 2022 - Aug 2023

```text
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.
```

Skills: SAS, SAS-MACRO, SAS-ODS, CA-Automation, Autosys, Shell-Scripting, Pass-Through-SQL, Teradata

### Sr. Lead Data Analytics

[Wells Fargo Bank](https://himalayas.app/companies/wells-fargo). Mar 2021 - Aug 2022

```text
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.
```

Skills: Pass-Through-SQL, LIBNAME, Data-Quality, Data-Validation, Oracle, Teradata, SAS, Jira

### Sr. SAS Programmer / SAS Analyst

Salliemae Financial System. Aug 2019 - Feb 2021

```text
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.
```

Skills: Base-SAS, Data-Quality-Rules-Development, LGD, CECL-Model-Validation, Unix

### Sr. SAS Programmer

PNC Bank. Dec 2016 - Aug 2019

```text
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.
```

Skills: UAT, SAS-MACRO, SAS-Enterprise-Guide, Production-Support, Data-Preparation, Python, Jupyter, Regression-Modeling

## Education

### Old Dominion University

Master of Science

```text
Completed an M.S. degree at Old Dominion University in Norfolk, Virginia.
```

### Tribhuvan University

M.Sc., Physics

## Tech stack

- SAS
- DB
- MySQL
- Microsoft SQL Server
- Oracle
- Hadoop
- Gmail
- Java
- JSON
- XML
- scikit-learn
- Linux
- Oracle PL/SQL
- Root Cause
- SQL
- Phase
- Column
- Check
- Method
- Numeric
- Seaborn

To contact Dhruba, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Sooraj Sharma](https://himalayas.app/@soorajsharma): Principal Data Analyst, Numeric Mind
- [Ankit Bisht](https://himalayas.app/@ankitbisht1): Quality Assurance Team Lead, Aerion Technologies
- [Sabin Tandukar](https://himalayas.app/@sabintandukar): Delivery Consultant, IBM
- [Rakshita Baidya](https://himalayas.app/@rakshitabaidya): Support Engineer Trainee, Octacore Soutions Pvt. Lmt.
- [kebal khadka](https://himalayas.app/@kebalkhadka): Data Intern, eXtenso Data | F1soft International Pvt Ltd
- [Dhawa Dorje Ghising](https://himalayas.app/@dhawadorjeghising1): Freelance Data Analyst, Self Employed
- [sarbagya neupane](https://himalayas.app/@sarbagyaneupane): Data Analyst, Asseti Holding
- [Yogesh Roy](https://himalayas.app/@yogeshroy): Associate Solution Architect, FlexTecs
- [Suvash Gautam](https://himalayas.app/@suvashgautam): Data Engineer, Pwnbot Systems
- [Nikhil Gain](https://himalayas.app/@nikhilgain): Independent Data Analyst, Personal Project
