Sudeep Sapkota

Data Scientist @Wells Fargo

InsuranceAnalyticsTechnologyInvestment ManagementBusiness Analyst🧨 ConsultingBanking & Capital MarketsGovernment & Public Services🧑‍🔬 EngineerConsumer IndustryStatistical AnalysisSQLData ModelingHivePythonTableauData ModellingNatural Language ProcessingSparkDatabase ManagementETLData WarehousingHadoopPowerBI✔️ ITDatabase DeveloperML EngineerData ScientistData EngineerData AnalystBI Analyst

Sudeep Sapkota is a highly skilled Data Scientist at Wells Fargo, where he applies his expertise in machine learning, data analysis, and predictive modeling to drive business solutions. He excels in utilizing big data technologies to optimize business processes, reduce costs, and improve customer experiences. His exceptional understanding of data infrastructure and algorithms, coupled with his ability to communicate complex concepts to non-technical stakeholders, makes him a valuable asset to the Wells Fargo team.

Feedback from Sudeep’s ex-colleagues

Let me see

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

Wells FargoExecutive Director - Emerging Risk & Innovation - Fraud Analytics Senior Lead Analytics Consultant

May. 2024Charlotte, North Carolina, United StatesPre-Transaction digital fraud strategy, detecting emerging risk and innovation in fraud analytics

Wells FargoExecutive Director - Insider Threat Senior Lead Analytic Consultant

Nov. 2021 - May. 2024Charlotte, North Carolina, United StatesExperienced Senior Lead Analytics Consultant / Executive Director with expertise in data analytics, Power BI, Advanced SQL, Teradata, SAS Enterprise Guide, Tableau, and Introductory Python for analytics. Proven track record of leading and managing teams of 4-6 members in daily operations, task assignment, priority setting, and ensuring efficient project execution and timely delivery. Specializes in insider threat-related projects focusing on Employee Risk Rating implementations, MITRE ATT&CK risk data analysis, DLP data exfiltration analysis, ProofPoint Malicious Clicks analysis, and critical assets IAM data strategy. Skilled in collaborating with cross-functional teams, providing actionable insights with Diagnostics/Prescriptive Analytics with impact rationale, and influencing decision-making at all levels, including senior leadership. Led a specialized technical team to implement the Employee-Risk Scoring solution. Developed and implemented an automated Data Health Check Summary program, ensuring daily data refresh for currency and completeness. Monitors, verifies, and promptly notifies stakeholders of discrepancies or issues, taking necessary action. Created a robust data preprocessing ETL program specifically designed to efficiently load data into the Teradata data warehouse environment. Actively involved in the end-to-end Software Development Life Cycle (SDLC) process, taking a hands-on approach to change implementation. Skills: • Data Analytics • Power BI • SQL • Teradata • SAS Enterprise Guide • Tableau • Unified Modeling Language (UML) • Advanced Visualization, Network Graph, Sankey Diagram, Bowtie etc. • Daily Diagnostic Analytics • GitHub • Big Data Analytics • AWS S3 Bucket • MSFT Fabrics • AI/ML • Python for Analytics • Team Leadership and Management • Insider Threat Analysis • Data Integration and Collaboration • Influencing Stakeholders • Presentation and Communication Skills • Automation Solutions • Rapid Technical Build out

Wells FargoVP - Analytic Consultant - Wells Fargo Home Mortgage - Servicing Data & Analytics

May. 2019 - Oct. 2021Charlotte, North Carolina AreaProvided comprehensive support for the community outreach program within home lending servicing, assisting customers with past due balances to prevent default and ensure loan sustainability by offering tailored loan modification options, ultimately striving to make all loans current. Worked in various areas including Loss Mitigation, Default Management, and Single Point of Contact within home mortgage servicing. Developed a COVID-19 loan search tool using Power BI and Teradata SQL to support customers in forbearance. Built call center inbound and outbound call volume analysis to provide comprehensive insights into home mortgage customer analytics. Utilized tools such as MS SQL, SAS EG, Power BI, and Tableau for data analysis and visualization. Worked in Loss Mitigation of home mortgage servicing, Default management operation, Single point of contact, COVID-19 loan search tool etc. using MS SQL, SAS EG,TERADATA SQL, Power BI, and Tableau.

Wells FargoAVP - Analytic Consultant - Wells Fargo Bank - Wholesale Financial Crimes Risk Controls

Sep. 2018 - Apr. 2019Charlotte, North Carolina AreaWorked in the Wholesale Financial Crimes Risk Controls division, focusing on BSA (Bank Secrecy Act) and AML (Anti-Money Laundering) operational reporting. Actively identified and detected potentially fraudulent activities, SAR (Suspicious Activity Report) filings, and promptly took appropriate actions to mitigate risks.

Wells FargoAVP - Analytic Consultant (BI & Data Warehouse ) - Wells Fargo Bank - Home Mortgage Servicing

Nov. 2016 - Sep. 2018Fort Mill SC Analysis, designed, developed, test, and deployed Community Outreach data acquisition and reporting solution for Wells Fargo Home Mortgage Servicing and Data Analytics. Worked with multiple lines of business and SDA partners to accomplish undertakings. Providing technical and analytical insights in the form of SSRS, executive, operational, dashboard, and ad-hoc reporting. Built ETL solutions using SSIS to streamline legacy manual processes and standardized reporting and data loading process. Automated solutions using SQL Agent jobs with validations and notifications to stakeholders for informed solutions progress of underlined data loading process for downstream reporting and reduced significant time and effort . Created BRD, Design document, data elements mapping, testing software artifacts, peer review executables such as database objects, scripts, Stored Procedure, SSIS, and SSRS etc. Documented processes and software programs, modeled use case diagram, dataflow diagram, and activity diagrams for the solutions being built for community Outreach within Home Mortgage Servicing. Built end to end solutions starting from inception of projects to post delivery support as part of software development life cycle. Created redundant solutions of community outreach event processing for each component such as solicitations, RSVP, Attendance, and Event Calendar to minimize operational risk and reinforced robust system as alternative and automated process. Promoted configuration artifacts into UAT and PROD environment using JIRA, Check in - Check out executable in TFS. TOOLS: SSMS 2012/2017, Visual Studio 2010/2012/2017, MS office 2016, MS Visio 2012, Teradata SQL Assistance 15.10, TFS 2010/2012/2017, SSDT 2017, JIRA .

LPL FinancialSQL Server Developer - MSBI (Consultant)

Feb. 2014 - Nov. 2016Charlotte, North Carolina AreaSupported various departments and line of business with operational, GRC, and dashboard reporting with SQL Server reporting service (SSRS), SQL Server Integration Service (SSIS) and TSQL – Oracle SQL queries and complex stored procedures. Involved and participated all stages of software development life cycle(SDLC), software development methodologies such as waterfall and agile. Checked In- Checked Out the code into TFS, Created RFC’s, Scope and change control for the projects and deployed the configuration items into dev, QA and production environment. Smoked tested the installed software artifacts in production and obtained UAT sign off. Generated Ad-hoc and SLA reports. Tools used -SSMS2005/2008/ 2008R2/2012, Visual Studio 2010/2013, BIDS 2008 and Oracle SQL Developer 10g/11g

CapgeminiTechnical Lead

Feb. 2014 - Nov. 2016Charlotte, North Carolina AreaDelivered the assigned projects, Database, and MSBI solutions for clients representing Capgemini family under Insight and Data vertical.

PepsiCoDB2 SQL- SAP Crystal Report Developer (Consultant)

Sep. 2013 - Jan. 2014Greater New York City AreaDeveloped and Integrated the Crystal Report RPT files in enterprise level application (ERT) using DB2 SQL in the back end for Pallet Tracking Project which helped to save millions of dollars tracking the pallets's whereabouts where no reliable automated system to track and report those assets from single system earlier. Leveraged the various tools for this effort such as IBM's DB2, Embarcadero Rapid SQL, SQLinForm and SSMS 2008 R2.

Wells FargoDatabase Developer(Consultant)

May. 2013 - Aug. 2013Des Moines, Iowa AreaWorked in M2B and B2M Project as a part of Data acquisition effort and integrated data from various source system such as Oracle, Teradata, and SQL then loaded the data into newly built destination server using SQL Server Integration Service(SSIS) for further reporting by Micro-strategy team.

ActelionSQL Server Developer & Data Analyst(Consultant)

Nov. 2012 - Apr. 2013San Francisco Bay AreaWorked as a SQL Server Developer and Data Analyst for MDM project in order to standardize the Physicians data from various source system. Worked with DataFlux tool for the effort and identifying mapping in order to document them. Helped in business process and streamlined workflow for stakeholders specially for senior management.

Bare Escentuals, San Francisco,MS SQL Server BI Developer

Aug. 2010 - Oct. 2012San Francisco Bay AreaCollaborated with business partners to generate CRM reports using Oracle PLSQL, TSQL, SSIS, and SSRS, while also designing and implementing an ETL package to efficiently extract and load data from diverse sources into the target server