Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Santosh Reshmi

St Louis,MO

Summary

I am a dynamic IT Professional with 11+ years of rich experience in the Business Intelligence area. Throughout these years, I have mainly used SAS, Tableau, and peripheral technologies for BI projects in Financial Services, Insurance, and Retail Data Management and also have performed a wide range of roles including Solution Architect, SAS Developer, SAS Administrator, SAS BI Developer, and Data Analyst. I was involved in Project Leadership for Analysis, Design, and Development, Maintenance, and Support delivery for multiple BI projects for large Banking clients, gaining strong experience of various SAS BI tools, BI Tools along with Project Coordination.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Sr Software Engineer

Motion Recruitment
11.2021 - Current
  • Manage end to end implementation of AML and Name screening module
  • Requirement analysis and design, development of AML requirements from Compliance
  • Develop historical conversion processes which migrate the existing operational data into SAS Anti-Money Laundering and Enterprise Case Management solutions
  • Create and modify Programs to Monitor Transactions, for Global Remittance Services, Customer Lending, Leased Routing Numbers, and International Wire transfers, Online Trafficking, Foreign Currency Exchange, and Cash Structured Monitoring
  • Customize SAS Alert Generation Process models to meet specific business requirements
  • Identify issues with code implementation, logic, and performance issues and take corrective actions
  • Create new SAS programs and or modify existing SAS programs to generate Alerts for the Financial Crimes Investigation team to determine SARs warranted
  • For program group customers into various segments(class) which are aggregated across LOB’s based on class specific attributes
  • Automated generation of comprehensive dashboard reporting and visualizations of Data Management area to support managerial decisions
  • Interface with AML solution providers to meet the requirements of Monitoring and Surveillance users
  • Monitor batch jobs and provide support on production issues, collaborate with team members on SAS architecture, design, development, and testing and Coordinate with the production team to deploy enhancements and new releases
  • Debugging and testing SAS programs to check and process data; generate graphs, tables and listings in analysis system
  • Conducted GAP analysis to create an inventory of data controls by identifying potential gaps in existing controls, such as financial balancing, source- and post-load audit validations, against the standards across the Data warehouses; prioritized and defined common execution framework approach for remediation
  • Prioritized defects and validated traceability of test cases to functional specifications; provided quality assurance and user acceptance testing support and tracked data issues to resolution
  • Resource Management: Groomed resources in a distributed setup- technically & functionally, while ensuring accountability; provided constructive feedback, motivated, and trained them, ensuring 0 attrition.

SAS Solution Architect

Matrix-IFS
12.2017 - 10.2021
  • Worked on SAS AML8.2 implementation for different banking clients which included AML data preparation, scenario and ECM tasks
  • Worked closely with SAS US team on AML add-ons
  • SAS Viya Installation and configuration for banks.SAS AML - Solr enhancement and customization
  • SAS AML Data integration job
  • Manage large volume of structured and unstructured data as well as extracted and cleaned data to make it amenable for analysis
  • Collaborate with senior leadership to develop analytical solutions/initiatives by leveraging on SAS platform
  • Customer information and risk scoring factors configured; initial risk rating of the customer is calculated by the SAS engine
  • Define processes and create multiple, workflows for various types of cases – fraud, anti-money laundering, and regulatory filings
  • Developed SAS Stored Process to strategically assign AML alert investigations based on multiple business rules and priorities and created rules to Monitor Financial Advisor’s Activity
  • Created rules to identify premium transactions related to firm from Depository Trust and Clearing Corporation (DTCC) that belongs to a Firm
  • Monitor the Transactions/Purchases of annuities outside the Firms platform and FA Selling Annuities
  • Annuities to avoid the Supervisory process; Selling to clients without an account with the Firm or proved by the Firm by directly going to the carrier
  • Transactions under the same Party/Account where values for 'Applicant' or 'Beneficiary' changes from historical values for this Party/Account
  • Flag parties who are the originators of messages above a specified value and volume that went to/through a high-risk jurisdiction
  • Developed historical conversion processes which migrates the existing operational data into SAS Anti-Money Laundering and Enterprise Case Management solutions
  • Import Data from Sources (Flat files, Databases)
  • Updating SAS ECM functionality, Including UI modifications, and changes
  • Updates to the SAS programs which ingest cases into ECM using ECM web-services and development of new SAS stored process to carry out tasks unavailable in SAS ECM
  • Analyse data from multiple sources like Oracle, Hadoop, and End User UI’s, Excel files using SAS EG, SQL Workbench, HUE, and Oracle SQL Developer
  • Extracted data from Hadoop, Postgres, Teradata, and Oracle using PROC SQL Pass-through facility and SAS/ACCESS, lib-name statements
  • Successfully converted SAS code to Python3.x
  • Performed in-depth investigations of data problems/issues within Data & Analytics team and employing statistical and technical skills to develop solutions
  • Pipelined (ingest/clean/transform) data for feature extraction toward downstream classification
  • Worked on adding Cloud configurations to Java Spring Batch–Rule Engine and pushed it to Cloud Foundry
  • Identified outliers and imputed missing values to clean data for analysis, worked closely on Variable and Data Mapping to build ER diagram
  • Participated in internal hands-on training on architecture and implementation techniques for SAS EGRC/MRM solutions.

Senior Consultant

Capgemini America Inc.
03.2017 - 12.2017
  • Using SAS fraud management, First Data Defense Edge tools, Design/Frame fraud detection rules to flag or identify suspicious activities for millions of transactions
  • Analyze fraud data in old system & drawing inference from historical data
  • Developed and designed strategies, innovative solution via analytics to catch ATO (account take over) and Account generation fraud that helped organization to catch fraud on the fly
  • Aid project teams with architecture design, develop documentation and create project deliverables in SAS software and technologies
  • Created/Modified production code/Scripts (SAS, SQL, Unix, pivot tables etc.) for Auth/fraud changes validation and reporting
  • Convert High level strategy requirements to detailed design with the coding specs which has high level overview of the coding, the rules and strategies involved and datasets involved
  • Implemented & designed SAS fraud management tool as a fraud detection platform for various stakeholders; and mentor, guide, and monitor programmers, ensuring adherence to programming and documentation policies
  • Produced and maintained fraud analysis models to optimize analysis and review
  • Processed and reviewed regular transactions to identify fraudulent transactions
  • Investigated instances of fraud
  • Conducted risk assessment and reconciled accounts
  • Assist in performance tuning of the systems and servers
  • Used SAS Viya to process huge transactional data through Proc casutil & other procedures.

Senior Software Analyst

Accenture LLC
02.2011 - 03.2017
  • Led a geographically dispersed team of 6 System Analysts in Personal Insurance space for a major Insurance client
  • Collaborated with various stakeholders to develop technical solutions for business requirements; participated in Agile development cycles, backlog refinement and defect triage activities
  • Created SAS Application Servers for OLAP Servers, Workspace Servers, Pooled Workspace Servers, Connect Servers, Stored Process Servers, Batch Servers, and Java Batch Servers and worked with internal and external AIX Technical Support, Help Desk Support, Access Technical Support, SAS Technical Support groups to set up connectivity, validate installations, troubleshoot, and facilitate resolution of issues and have remotely assisted the AXA Business Intelligence Infrastructure Team in Using the SAS BI 9.2 Suite
  • Used SAS Management Console (SMC), to add and modify permissions for SAS Business Partners and Monitor, Control and manage the SAS account for different Business Users across all Entities
  • Scheduling and refreshing the reports for the Business, so that the Business can access the critical data on scheduled time thus reducing manual intervention, Actively Involved in Metadata Security implementation of SAS BI and SAS VA framework (SAS 9.1.3 and SAS 9.2) Provide support to all the Client SAS customers
  • Developed SAS Data Integration jobs and SAS Webservices to serve the retail business logic for a large Campaigns
  • Understand/analyse the requirements of different business users and provide enriched data in the form of reports
  • Provided solution designing/IT technology consulting to meet business requirements using agile SDLC by using rally tool
  • Also, resolved complex business queries by analyzing data with help of Teradata queries
  • Data analytics work on marketing, campaign, policy, quotes & billing subject areas on P & C data warehouse
  • Helping Marketing team to automate marketing reports and measure efficiency early so that marketers can spend more time gaining insights
  • Provides (cleansed) customer and household level view of client’s universe
  • Schedule and support the different SAS reports (through LSF Scheduler) which are running as part of marketing operations team
  • Completed POC using (ESRI, MicroStrategy & Qlik sense) to accurately report risks by marring policy data with hurricane/wildfire and other hazards data.

Software Engineer

HCL Technologies Pvt Ltd.
07.2010 - 02.2011
  • Developed comprehensive training material and conducted training sessions for team members
  • Created tools using VBA for MS-Excel like Account Planning Tool, Vacancy Management Tool, Customer Transition Tool, Profiling Tool, Differentiation Tool and Multichannel Tool
  • Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same
  • Create and maintain SAS datasets that are extracted from an Oracle Database using SAS/ACCESS for ORACLE and extensively used Proc SQL to manipulate the data
  • Data analysis, reports using SAS procedures and SAS/Macros.
  • Tested methodology with writing and execution of test plans, debugging and testing scripts and tools.
  • Analyzed proposed technical solutions based on customer requirements.
  • Collaborated with clients to define solution requirements.
  • Delivered unit-tested systems within customer-prescribed timeframes.
  • Provided guidance and mentored less-experienced staff members.
  • Collaborated with fellow engineers to evaluate software and hardware interfaces.
  • Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
  • Analyzed data to coordinate installation of new systems or modification of existing systems.
  • Tested and deployed scalable and highly available software products.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.

Software Engineer

Mantra Analytics Pvt Ltd.
01.2009 - 12.2009
  • Automated a manual task of using Excel VBA to automatically align the Data in Excel sheets and these excel files were used as Source files for the data load., leading to 90% savings in time
  • Created datasets by extracting the data from SQL Server using pass through facility or read in the data from the Excel files using the data step programming and identify the wine and classify them into various types of wines for e.g.: (RED, WHITE, PORT etc.) Data Analytics work on marketing, campaign, Sales area on ODS data warehouse
  • Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same
  • Generate the reports using procedures like Proc Means, Proc Tabulate and Proc Frequency
  • Reviewing data for cleaning and validation process and verifying the data which is loaded into target data bases and maintained the daily error log for cleaning the data
  • Responsible for increasing enrolment by identifying the proper target population using statistical models like logistic regression and cluster analysis using SAS Base
  • Worked on data manipulation and cleaning for statistical modelling and Pulled Transaction level data for reporting to build insight tables at various levels
  • Complex SQL queries were developed for joining multiple tables to create final insight tables
  • Used Data for Regression Analysis, predictive analysis, Competitor Analysis, and Trend Analysis.
  • Delivered unit-tested systems within customer-prescribed timeframes.
  • Worked with customers for needs analysis and to determine vendor costs.
  • Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.

Process Associate

Fidelity Investments
03.2006 - 12.2007
  • I was responsible for the calculation of Retirement Benefit of 401k plan participants based on the investments made, medical history which includes the critical illness and other detail medical details about the participants
  • Extract the Work Items from the Dash Board and distribute the Work items within the team and keep track of the Work Items missing the SLA and informing the concerned team members
  • Created an Age calculation tool using Ms-Excel VBA Macros to calculate the Age of the participant and classify them by Age for calculation of defined benefits.

Education

Bachelor of Science in Physics and Mathematics -

Karnatak University- Dharwad

Skills

  • Base SAS/Macros
  • SAS Enterprise Case Management
  • SAS DI Studio
  • SAS AML
  • SAS Fraud Management
  • First Data Defense Edge tools
  • SAS Viya
  • SAS Stored process
  • SAS ACCESS
  • SAS CONNECT
  • SAS EBI Suite
  • Information Map Studio
  • SAS Web Report Studio
  • SAS BI Dashboard
  • SAS Enterprise Guide
  • SAS Management Console
  • Python3x
  • ESRI suite of products
  • ArcGIS Server
  • ArcMap
  • MS SQL Server
  • Jira
  • GitHub
  • Cloud Foundry

Certification

  • SAS Certified Programmer for SAS 9
  • SAFE AGILE Certified Practitioner

Timeline

Sr Software Engineer

Motion Recruitment
11.2021 - Current

SAS Solution Architect

Matrix-IFS
12.2017 - 10.2021

Senior Consultant

Capgemini America Inc.
03.2017 - 12.2017

Senior Software Analyst

Accenture LLC
02.2011 - 03.2017

Software Engineer

HCL Technologies Pvt Ltd.
07.2010 - 02.2011

Software Engineer

Mantra Analytics Pvt Ltd.
01.2009 - 12.2009

Process Associate

Fidelity Investments
03.2006 - 12.2007

Bachelor of Science in Physics and Mathematics -

Karnatak University- Dharwad

Similar Profiles

CREATE PROFILE
Santosh Reshmi